Forms 1
Symfony 2.5.12
Symfony 2.5.12
Symfony Documentation
PHP
PHP7.1.33
PHP Extensionsxdebugaccel
PHP SAPIfpm-fcgi
Environment 2deb0d app dev
Nameapp
Environmentdev
Token2deb0d
Request 200 HomeController indexAction on operatori_matrimonio_vetrina
Status200 OK
ControllerHomeController indexAction
Route nameoperatori_matrimonio_vetrina
Has sessionyes
Logs 44
Deprecated Calls 44
Time 3934 ms
Total time 3934 ms
Memory Usage 36.0 MB
Memory usage 36.0 / 128.0 MB
Security
anon.
Logged in as anon.
Authenticated Yes
Token class AnonymousToken
Database 44 in 305.18 ms
DB Queries 44
Query time 305.18 ms
Invalid entities 0

Queries

Connection default

#▲ Time Info
1 0.94 ms
+ - Shrink query SELECT t0.id AS id_1, [...] FROM lmn_vetrina t0 WHERE t0.url_scheda = ? 
SELECT 
  t0.id AS id_1, 
  t0.created_by AS created_by_2, 
  t0.updated_by AS updated_by_3, 
  t0.url_scheda AS url_scheda_4, 
  t0.stato AS stato_5, 
  t0.email AS email_6, 
  t0.premium AS premium_7, 
  t0.testo AS testo_8, 
  t0.info_recapito AS info_recapito_9, 
  t0.fattura AS fattura_10, 
  t0.edit AS edit_11, 
  t0.website AS website_12, 
  t0.data_attivazione AS data_attivazione_13, 
  t0.stat_user AS stat_user_14, 
  t0.stat_pwd AS stat_pwd_15, 
  t0.preview AS preview_16, 
  t0.nuovo AS nuovo_17, 
  t0.no_rinnovo AS no_rinnovo_18, 
  t0.ritardo_pagamento AS ritardo_pagamento_19, 
  t0.data_pubblicazione AS data_pubblicazione_20, 
  t0.scadenza AS scadenza_21, 
  t0.link_scambio AS link_scambio_22, 
  t0.link_url AS link_url_23, 
  t0.link_checked AS link_checked_24, 
  t0.vetrina_tipo_id AS vetrina_tipo_id_25, 
  t0.data_conferma AS data_conferma_26, 
  t0.slug AS slug_27, 
  t0.pubblico AS pubblico_28, 
  t0.titolo AS titolo_29, 
  t0.h1 AS h1_30, 
  t0.h2 AS h2_31, 
  t0.meta_title AS meta_title_32, 
  t0.meta_keyword AS meta_keyword_33, 
  t0.meta_description AS meta_description_34, 
  t0.descrizione AS descrizione_35, 
  t0.created_at AS created_at_36, 
  t0.updated_at AS updated_at_37, 
  t0.categoria_id AS categoria_id_38, 
  t0.geo_id AS geo_id_39, 
  t0.cliente_id AS cliente_id_40, 
  t0.recapito_id AS recapito_id_41, 
  t0.listing_id AS listing_id_42, 
  t0.boximage_id AS boximage_id_43, 
  t0.logo_id AS logo_id_44, 
  t0.vetrina_tipo_id AS vetrina_tipo_id_45, 
  t0.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina t0 
WHERE 
  t0.url_scheda = ?
 Parameters: [cloryndamakeup]
[Display runnable query]
 [ + - Explain query ]
2 0.35 ms
+ - Shrink query SELECT t0.id AS id_1, t0.old_id AS [...] FROM lmn_categoria t0 WHERE t0.id = ? 
SELECT 
  t0.id AS id_1, 
  t0.old_id AS old_id_2, 
  t0.limitrofi AS limitrofi_3, 
  t0.lft AS lft_4, 
  t0.lvl AS lvl_5, 
  t0.rgt AS rgt_6, 
  t0.root AS root_7, 
  t0.slug AS slug_8, 
  t0.pubblico AS pubblico_9, 
  t0.titolo AS titolo_10, 
  t0.h1 AS h1_11, 
  t0.h2 AS h2_12, 
  t0.meta_title AS meta_title_13, 
  t0.meta_keyword AS meta_keyword_14, 
  t0.meta_description AS meta_description_15, 
  t0.descrizione AS descrizione_16, 
  t0.testo AS testo_17, 
  t0.created_at AS created_at_18, 
  t0.updated_at AS updated_at_19, 
  t0.padre_id AS padre_id_20, 
  t0.copertina_id AS copertina_id_21 
FROM 
  lmn_categoria t0 
WHERE 
  t0.id = ?
 Parameters: [8]
[Display runnable query]
 [ + - Explain query ]
3 0.72 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ INNER JOIN [...] WHERE l0_.url_scheda = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.created_by AS created_by_1, 
  l0_.updated_by AS updated_by_2, 
  l0_.url_scheda AS url_scheda_3, 
  l0_.stato AS stato_4, 
  l0_.email AS email_5, 
  l0_.premium AS premium_6, 
  l0_.testo AS testo_7, 
  l0_.info_recapito AS info_recapito_8, 
  l0_.fattura AS fattura_9, 
  l0_.edit AS edit_10, 
  l0_.website AS website_11, 
  l0_.data_attivazione AS data_attivazione_12, 
  l0_.stat_user AS stat_user_13, 
  l0_.stat_pwd AS stat_pwd_14, 
  l0_.preview AS preview_15, 
  l0_.nuovo AS nuovo_16, 
  l0_.no_rinnovo AS no_rinnovo_17, 
  l0_.ritardo_pagamento AS ritardo_pagamento_18, 
  l0_.data_pubblicazione AS data_pubblicazione_19, 
  l0_.scadenza AS scadenza_20, 
  l0_.link_scambio AS link_scambio_21, 
  l0_.link_url AS link_url_22, 
  l0_.link_checked AS link_checked_23, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_24, 
  l0_.data_conferma AS data_conferma_25, 
  l0_.slug AS slug_26, 
  l0_.pubblico AS pubblico_27, 
  l0_.titolo AS titolo_28, 
  l0_.h1 AS h1_29, 
  l0_.h2 AS h2_30, 
  l0_.meta_title AS meta_title_31, 
  l0_.meta_keyword AS meta_keyword_32, 
  l0_.meta_description AS meta_description_33, 
  l0_.descrizione AS descrizione_34, 
  l0_.created_at AS created_at_35, 
  l0_.updated_at AS updated_at_36, 
  l1_.id AS id_37, 
  l1_.old_id AS old_id_38, 
  l1_.limitrofi AS limitrofi_39, 
  l1_.lft AS lft_40, 
  l1_.lvl AS lvl_41, 
  l1_.rgt AS rgt_42, 
  l1_.root AS root_43, 
  l1_.slug AS slug_44, 
  l1_.pubblico AS pubblico_45, 
  l1_.titolo AS titolo_46, 
  l1_.h1 AS h1_47, 
  l1_.h2 AS h2_48, 
  l1_.meta_title AS meta_title_49, 
  l1_.meta_keyword AS meta_keyword_50, 
  l1_.meta_description AS meta_description_51, 
  l1_.descrizione AS descrizione_52, 
  l1_.testo AS testo_53, 
  l1_.created_at AS created_at_54, 
  l1_.updated_at AS updated_at_55, 
  l2_.id AS id_56, 
  l2_.tipo AS tipo_57, 
  l2_.lat AS lat_58, 
  l2_.lon AS lon_59, 
  l2_.old_id AS old_id_60, 
  l2_.url AS url_61, 
  l2_.main AS main_62, 
  l2_.slug AS slug_63, 
  l2_.pubblico AS pubblico_64, 
  l2_.titolo AS titolo_65, 
  l2_.h1 AS h1_66, 
  l2_.h2 AS h2_67, 
  l2_.meta_title AS meta_title_68, 
  l2_.meta_keyword AS meta_keyword_69, 
  l2_.meta_description AS meta_description_70, 
  l2_.descrizione AS descrizione_71, 
  l2_.testo AS testo_72, 
  l2_.created_at AS created_at_73, 
  l2_.updated_at AS updated_at_74, 
  l0_.categoria_id AS categoria_id_75, 
  l0_.geo_id AS geo_id_76, 
  l0_.cliente_id AS cliente_id_77, 
  l0_.recapito_id AS recapito_id_78, 
  l0_.listing_id AS listing_id_79, 
  l0_.boximage_id AS boximage_id_80, 
  l0_.logo_id AS logo_id_81, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_82, 
  l0_.copertina_id AS copertina_id_83, 
  l1_.padre_id AS padre_id_84, 
  l1_.copertina_id AS copertina_id_85, 
  l2_.regione_id AS regione_id_86, 
  l2_.provincia_id AS provincia_id_87, 
  l2_.copertina_id AS copertina_id_88 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  INNER JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l0_.url_scheda = ? 
  AND l1_.slug = ?
 Parameters: [cloryndamakeup, trucco_e_acconciatura]
[Display runnable query]
 [ + - Explain query ]
4 0.43 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND (? [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  ) 
  AND l0_.quantity > l0_.used
 Parameters: [2338, '2025-04-03 04:18:58']
[Display runnable query]
 [ + - Explain query ]
5 0.69 ms
+ - Shrink query SELECT t0.id AS id_1, [...] FROM lmn_media_foto t0 [...] WHERE lmn_vetrina_foto_re [...] ORDER BY t0.posizione ASC 
SELECT 
  t0.id AS id_1, 
  t0.pubblico AS pubblico_2, 
  t0.height AS height_3, 
  t0.width AS width_4, 
  t0.mime AS mime_5, 
  t0.size AS size_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8, 
  t0.titolo AS titolo_9, 
  t0.name AS name_10, 
  t0.path AS path_11, 
  t0.old_id AS old_id_12, 
  t0.posizione AS posizione_13, 
  t0.album_id AS album_id_14 
FROM 
  lmn_media_foto t0 
  INNER JOIN lmn_vetrina_foto_rel ON t0.id = lmn_vetrina_foto_rel.mediafoto_id 
WHERE 
  lmn_vetrina_foto_rel.vetrina_id = ? 
ORDER BY 
  t0.posizione ASC
 Parameters: [2338]
[Display runnable query]
 [ + - Explain query ]
6 0.48 ms
+ - Shrink query SELECT t0.id AS id_1, t0.titolo AS [...] FROM lmn_vetrina_recapito t0 WHERE t0.id = ? 
SELECT 
  t0.id AS id_1, 
  t0.titolo AS titolo_2, 
  t0.telefono AS telefono_3, 
  t0.cell AS cell_4, 
  t0.fax AS fax_5, 
  t0.cap AS cap_6, 
  t0.suggest AS suggest_7, 
  t0.lat AS lat_8, 
  t0.lon AS lon_9, 
  t0.indirizzo AS indirizzo_10, 
  t0.testo AS testo_11, 
  t0.old_id AS old_id_12, 
  t0.geo_id AS geo_id_13, 
  t0.vetrina_id AS vetrina_id_14 
FROM 
  lmn_vetrina_recapito t0 
WHERE 
  t0.id = ?
 Parameters: [24752]
[Display runnable query]
 [ + - Explain query ]
7 0.39 ms
+ - Shrink query SELECT t0.id AS id_1, t0.tipo AS [...] FROM lmn_geo t0 WHERE t0.id = ? 
SELECT 
  t0.id AS id_1, 
  t0.tipo AS tipo_2, 
  t0.lat AS lat_3, 
  t0.lon AS lon_4, 
  t0.old_id AS old_id_5, 
  t0.url AS url_6, 
  t0.main AS main_7, 
  t0.slug AS slug_8, 
  t0.pubblico AS pubblico_9, 
  t0.titolo AS titolo_10, 
  t0.h1 AS h1_11, 
  t0.h2 AS h2_12, 
  t0.meta_title AS meta_title_13, 
  t0.meta_keyword AS meta_keyword_14, 
  t0.meta_description AS meta_description_15, 
  t0.descrizione AS descrizione_16, 
  t0.testo AS testo_17, 
  t0.created_at AS created_at_18, 
  t0.updated_at AS updated_at_19, 
  t0.regione_id AS regione_id_20, 
  t0.provincia_id AS provincia_id_21, 
  t0.copertina_id AS copertina_id_22 
FROM 
  lmn_geo t0 
WHERE 
  t0.id = ?
 Parameters: [21197]
[Display runnable query]
 [ + - Explain query ]
8 0.57 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )
 Parameters: [2338, 1, vetrina_visibilita_telefono, '2025-04-03 04:18:58']
[Display runnable query]
 [ + - Explain query ]
9 0.65 ms
+ - Shrink query SELECT t0.id AS id_1, t0.tipo AS [...] FROM lmn_geo t0 WHERE t0.id = ? 
SELECT 
  t0.id AS id_1, 
  t0.tipo AS tipo_2, 
  t0.lat AS lat_3, 
  t0.lon AS lon_4, 
  t0.old_id AS old_id_5, 
  t0.url AS url_6, 
  t0.main AS main_7, 
  t0.slug AS slug_8, 
  t0.pubblico AS pubblico_9, 
  t0.titolo AS titolo_10, 
  t0.h1 AS h1_11, 
  t0.h2 AS h2_12, 
  t0.meta_title AS meta_title_13, 
  t0.meta_keyword AS meta_keyword_14, 
  t0.meta_description AS meta_description_15, 
  t0.descrizione AS descrizione_16, 
  t0.testo AS testo_17, 
  t0.created_at AS created_at_18, 
  t0.updated_at AS updated_at_19, 
  t0.regione_id AS regione_id_20, 
  t0.provincia_id AS provincia_id_21, 
  t0.copertina_id AS copertina_id_22 
FROM 
  lmn_geo t0 
WHERE 
  t0.id = ?
 Parameters: [10401]
[Display runnable query]
 [ + - Explain query ]
10 0.61 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_organizzazione_categori [...] WHERE l0_.slug = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.countdown AS countdown_1, 
  l0_.lft AS lft_2, 
  l0_.lvl AS lvl_3, 
  l0_.rgt AS rgt_4, 
  l0_.root AS root_5, 
  l0_.box_categorie_operatori AS box_categorie_operatori_6, 
  l0_.titolo_breve AS titolo_breve_7, 
  l0_.slug AS slug_8, 
  l0_.pubblico AS pubblico_9, 
  l0_.titolo AS titolo_10, 
  l0_.h1 AS h1_11, 
  l0_.h2 AS h2_12, 
  l0_.meta_title AS meta_title_13, 
  l0_.meta_keyword AS meta_keyword_14, 
  l0_.meta_description AS meta_description_15, 
  l0_.descrizione AS descrizione_16, 
  l0_.testo AS testo_17, 
  l0_.created_at AS created_at_18, 
  l0_.updated_at AS updated_at_19, 
  l0_.padre_id AS padre_id_20, 
  l0_.categoria_id AS categoria_id_21, 
  l0_.geo_id AS geo_id_22, 
  l0_.newsTag_id AS newsTag_id_23, 
  l0_.forumTag_id AS forumTag_id_24, 
  l0_.copertina_id AS copertina_id_25 
FROM 
  lmn_organizzazione_categoria l0_ 
WHERE 
  l0_.slug = ?
 Parameters: [organizzazione-matrimonio]
[Display runnable query]
 [ + - Explain query ]
11 0.86 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_organizzazione_ [...] WHERE l0_.padre_id = ? ORDER BY l0_.titolo ASC 
SELECT 
  l0_.id AS id_0, 
  l0_.countdown AS countdown_1, 
  l0_.lft AS lft_2, 
  l0_.lvl AS lvl_3, 
  l0_.rgt AS rgt_4, 
  l0_.root AS root_5, 
  l0_.box_categorie_operatori AS box_categorie_operatori_6, 
  l0_.titolo_breve AS titolo_breve_7, 
  l0_.slug AS slug_8, 
  l0_.pubblico AS pubblico_9, 
  l0_.titolo AS titolo_10, 
  l0_.h1 AS h1_11, 
  l0_.h2 AS h2_12, 
  l0_.meta_title AS meta_title_13, 
  l0_.meta_keyword AS meta_keyword_14, 
  l0_.meta_description AS meta_description_15, 
  l0_.descrizione AS descrizione_16, 
  l0_.testo AS testo_17, 
  l0_.created_at AS created_at_18, 
  l0_.updated_at AS updated_at_19, 
  l0_.padre_id AS padre_id_20, 
  l0_.categoria_id AS categoria_id_21, 
  l0_.geo_id AS geo_id_22, 
  l0_.newsTag_id AS newsTag_id_23, 
  l0_.forumTag_id AS forumTag_id_24, 
  l0_.copertina_id AS copertina_id_25 
FROM 
  lmn_organizzazione_categoria l0_ 
WHERE 
  l0_.padre_id = ? 
ORDER BY 
  l0_.titolo ASC
 Parameters: [1]
[Display runnable query]
 [ + - Explain query ]
12 0.80 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_news_categoria [...] WHERE l0_.pubblico = ? ORDER BY l0_.titolo ASC 
SELECT 
  l0_.id AS id_0, 
  l0_.slug AS slug_1, 
  l0_.pubblico AS pubblico_2, 
  l0_.titolo AS titolo_3, 
  l0_.h1 AS h1_4, 
  l0_.h2 AS h2_5, 
  l0_.meta_title AS meta_title_6, 
  l0_.meta_keyword AS meta_keyword_7, 
  l0_.meta_description AS meta_description_8, 
  l0_.descrizione AS descrizione_9, 
  l0_.testo AS testo_10, 
  l0_.created_at AS created_at_11, 
  l0_.updated_at AS updated_at_12 
FROM 
  lmn_news_categoria l0_ 
WHERE 
  l0_.pubblico = ? 
ORDER BY 
  l0_.titolo ASC
 Parameters: [1]
[Display runnable query]
 [ + - Explain query ]
13 0.62 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_gallery l0_ WHERE l0_.pubblico = 1 ORDER BY l0_.titolo ASC 
SELECT 
  l0_.id AS id_0, 
  l0_.titolo_breve AS titolo_breve_1, 
  l0_.testoOM AS testoOM_2, 
  l0_.col_sx AS col_sx_3, 
  l0_.slug AS slug_4, 
  l0_.pubblico AS pubblico_5, 
  l0_.titolo AS titolo_6, 
  l0_.h1 AS h1_7, 
  l0_.h2 AS h2_8, 
  l0_.meta_title AS meta_title_9, 
  l0_.meta_keyword AS meta_keyword_10, 
  l0_.meta_description AS meta_description_11, 
  l0_.descrizione AS descrizione_12, 
  l0_.testo AS testo_13, 
  l0_.created_at AS created_at_14, 
  l0_.updated_at AS updated_at_15, 
  l0_.categoria_id AS categoria_id_16, 
  l0_.categoriaOM_id AS categoriaOM_id_17, 
  l0_.copertina_id AS copertina_id_18 
FROM 
  lmn_gallery l0_ 
WHERE 
  l0_.pubblico = 1 
ORDER BY 
  l0_.titolo ASC
 Parameters: { }
[Display runnable query]
 [ + - Explain query ]
14 0.74 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )
 Parameters: [2338, 1, vetrina_visibilita_telefono, '2025-04-03 04:18:58']
[Display runnable query]
 [ + - Explain query ]
15 0.63 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND (? [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  ) 
  AND l0_.quantity > l0_.used
 Parameters: [2338, '2025-04-03 04:18:58']
[Display runnable query]
 [ + - Explain query ]
16 0.55 ms
+ - Shrink query SELECT count(l0_.id) AS sclr_0 FROM lmn_offerte l0_ WHERE l0_.vetrina_id = ? AND [...] 
SELECT 
  count(l0_.id) AS sclr_0 
FROM 
  lmn_offerte l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND (
    l0_.data_fine > ? 
    OR l0_.data_fine IS NULL
  ) 
  AND l0_.pubblico = 1
 Parameters: [2338, '2025-04-03 04:18:58']
[Display runnable query]
 [ + - Explain query ]
17 0.56 ms
+ - Shrink query SELECT t0.id AS id_1, [...] FROM lmn_media_video t0 [...] WHERE lmn_vetrina_video_r [...] ORDER BY t0.posizione ASC 
SELECT 
  t0.id AS id_1, 
  t0.lenght AS lenght_2, 
  t0.titolo AS titolo_3, 
  t0.path AS path_4, 
  t0.tipologia AS tipologia_5, 
  t0.descrizione AS descrizione_6, 
  t0.mime AS mime_7, 
  t0.size AS size_8, 
  t0.created_at AS created_at_9, 
  t0.updated_at AS updated_at_10, 
  t0.name AS name_11, 
  t0.old_id AS old_id_12, 
  t0.posizione AS posizione_13 
FROM 
  lmn_media_video t0 
  INNER JOIN lmn_vetrina_video_rel ON t0.id = lmn_vetrina_video_rel.mediavideo_id 
WHERE 
  lmn_vetrina_video_rel.vetrina_id = ? 
ORDER BY 
  t0.posizione ASC
 Parameters: [2338]
[Display runnable query]
 [ + - Explain query ]
18 0.49 ms
+ - Shrink query SELECT count(l0_.id) AS sclr_0 FROM lmn_media_foto l0_ INNER [...] WHERE l1_.id = ? AND l0_.pubblico [...] 
SELECT 
  count(l0_.id) AS sclr_0 
FROM 
  lmn_media_foto l0_ 
  INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id 
  INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
WHERE 
  l1_.id = ? 
  AND l0_.pubblico = 1
 Parameters: [2338]
[Display runnable query]
 [ + - Explain query ]
19 0.54 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )
 Parameters: [2338, 1, vetrina_foto_limit, '2025-04-03 04:18:58']
[Display runnable query]
 [ + - Explain query ]
20 0.42 ms
+ - Shrink query SELECT t0.id AS id_1, t0.titolo AS [...] FROM lmn_vetrina_recapito t0 WHERE t0.vetrina_id = ? 
SELECT 
  t0.id AS id_1, 
  t0.titolo AS titolo_2, 
  t0.telefono AS telefono_3, 
  t0.cell AS cell_4, 
  t0.fax AS fax_5, 
  t0.cap AS cap_6, 
  t0.suggest AS suggest_7, 
  t0.lat AS lat_8, 
  t0.lon AS lon_9, 
  t0.indirizzo AS indirizzo_10, 
  t0.testo AS testo_11, 
  t0.old_id AS old_id_12, 
  t0.geo_id AS geo_id_13, 
  t0.vetrina_id AS vetrina_id_14 
FROM 
  lmn_vetrina_recapito t0 
WHERE 
  t0.vetrina_id = ?
 Parameters: [2338]
[Display runnable query]
 [ + - Explain query ]
21 0.46 ms
+ - Shrink query SELECT t0.id AS id_1, [...] FROM lmn_media_audio t0 [...] WHERE lmn_vetrina_audio_r [...] ORDER BY t0.posizione ASC 
SELECT 
  t0.id AS id_1, 
  t0.mime AS mime_2, 
  t0.size AS size_3, 
  t0.created_at AS created_at_4, 
  t0.updated_at AS updated_at_5, 
  t0.titolo AS titolo_6, 
  t0.name AS name_7, 
  t0.path AS path_8, 
  t0.old_id AS old_id_9, 
  t0.posizione AS posizione_10 
FROM 
  lmn_media_audio t0 
  INNER JOIN lmn_vetrina_audio_rel ON t0.id = lmn_vetrina_audio_rel.mediaaudio_id 
WHERE 
  lmn_vetrina_audio_rel.vetrina_id = ? 
ORDER BY 
  t0.posizione ASC
 Parameters: [2338]
[Display runnable query]
 [ + - Explain query ]
22 0.39 ms
+ - Shrink query SELECT t0.id AS id_1, t0.email AS [...] FROM lmn_cliente t0 WHERE t0.id = ? 
SELECT 
  t0.id AS id_1, 
  t0.email AS email_2, 
  t0.password AS password_3, 
  t0.attivo AS attivo_4, 
  t0.actkey AS actkey_5, 
  t0.wizard AS wizard_6, 
  t0.wizard_email AS wizard_email_7, 
  t0.account_crm AS account_crm_8, 
  t0.premium AS premium_9, 
  t0.azienda AS azienda_10, 
  t0.nome AS nome_11, 
  t0.cognome AS cognome_12, 
  t0.indirizzo AS indirizzo_13, 
  t0.telefono AS telefono_14, 
  t0.comune AS comune_15, 
  t0.cap AS cap_16, 
  t0.provincia AS provincia_17, 
  t0.partita_iva AS partita_iva_18, 
  t0.codice_fiscale AS codice_fiscale_19, 
  t0.access_token AS access_token_20, 
  t0.last_access AS last_access_21, 
  t0.newsletter AS newsletter_22, 
  t0.email_verificata AS email_verificata_23, 
  t0.verificata_il AS verificata_il_24 
FROM 
  lmn_cliente t0 
WHERE 
  t0.id = ?
 Parameters: [6183]
[Display runnable query]
 [ + - Explain query ]
23 0.72 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )
 Parameters: [2338, 1, vetrina_rimuovi_limitrofi, '2025-04-03 04:18:58']
[Display runnable query]
 [ + - Explain query ]
24 81.80 ms
+ - Shrink query SELECT DISTINCT(v.id) [...] FROM lmn_vetrina_re [...] WHERE v.pubblico = 1 [...] HAVING distance < 70 [...] ORDER BY premium DESC, [...] 
SELECT 
  DISTINCT(v.id) AS vetrina_id, 
  vtp.tipo as vtipo, 
  v.titolo, 
  v.geo_id AS geo_id, 
  v.categoria_id AS cat_id, 
  v.premium, 
  v.scadenza, 
  r.lat, 
  r.lon, 
  r.id AS recapito_id, 
  (
    6371 * ACOS(
      COS(
        RADIANS(42.1005702614)
      ) * COS(
        RADIANS(r.lat)
      ) * COS(
        RADIANS(r.lon) - RADIANS(12.457036972)
      ) + SIN(
        RADIANS(42.1005702614)
      ) * SIN(
        RADIANS(r.lat)
      )
    )
  ) AS distance 
FROM 
  lmn_vetrina_recapito r 
  LEFT JOIN lmn_vetrina v ON r.id = v.recapito_id 
  LEFT JOIN lmn_vetrina_tipi vtp ON v.vetrina_tipo_id = vtp.id 
WHERE 
  v.pubblico = 1 
  AND v.id != 2338 
HAVING 
  distance < 70 
ORDER BY 
  premium DESC, 
  distance ASC
 Parameters: { }
[Display runnable query]
 [ + - Explain query ]
25 3.87 ms
+ - Shrink query SELECT DISTINCT(v.id) AS [...] FROM lmn_vetrina v [...] WHERE grel.geo_id = 10402 [...] ORDER BY distance asc 
SELECT 
  DISTINCT(v.id) AS vetrina_id, 
  vtp.tipo as vtipo, 
  v.titolo, 
  v.geo_id AS geo_id, 
  v.categoria_id AS cat_id, 
  v.premium, 
  v.scadenza, 
  (
    6371 * ACOS(
      COS(
        RADIANS(41.085969)
      ) * COS(
        RADIANS(g.lat)
      ) * COS(
        RADIANS(g.lon) - RADIANS(16.786358)
      ) + SIN(
        RADIANS(41.085969)
      ) * SIN(
        RADIANS(g.lat)
      )
    )
  ) AS distance 
FROM 
  lmn_vetrina v 
  LEFT JOIN lmn_vetrina_geo_rel grel on grel.vetrina_id = v.id 
  INNER JOIN lmn_geo g on grel.geo_id = g.id 
  LEFT JOIN lmn_vetrina_tipi vtp on v.vetrina_tipo_id = vtp.id 
WHERE 
  grel.geo_id = 10402 
  and v.categoria_id = 8 
  and vtp.tipo = 3 
  and v.pubblico = 1 
ORDER by 
  distance asc
 Parameters: { }
[Display runnable query]
 [ + - Explain query ]
26 2.21 ms
+ - Shrink query SELECT l0_.id AS id_0, l1_.id AS [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE (l0_.pubblico = 1 AND [...] 
SELECT 
  l0_.id AS id_0, 
  l1_.id AS id_1 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_vetrina_tipi l2_ ON l0_.vetrina_tipo_id = l2_.id 
WHERE 
  (
    l0_.pubblico = 1 
    AND l0_.premium = 1 
    AND l2_.tipo IN (3)
  ) 
  AND l0_.geo_id = ? 
  AND l0_.id NOT IN (?)
 Parameters: [10399, ['13531', '123', '8966', '3099', '10965', '13520', '1007', '13039', 2338]]
[Display runnable query]
 [ + - Explain query ]
27 0.72 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE l0_.id = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.email AS email_2, 
  l0_.premium AS premium_3, 
  l0_.slug AS slug_4, 
  l0_.titolo AS titolo_5, 
  l0_.h1 AS h1_6, 
  l0_.meta_title AS meta_title_7, 
  l0_.descrizione AS descrizione_8, 
  l1_.id AS id_9, 
  l1_.pubblico AS pubblico_10, 
  l1_.height AS height_11, 
  l1_.width AS width_12, 
  l1_.mime AS mime_13, 
  l1_.size AS size_14, 
  l1_.created_at AS created_at_15, 
  l1_.updated_at AS updated_at_16, 
  l1_.titolo AS titolo_17, 
  l1_.name AS name_18, 
  l1_.path AS path_19, 
  l1_.old_id AS old_id_20, 
  l1_.posizione AS posizione_21, 
  l2_.id AS id_22, 
  l2_.tipo AS tipo_23, 
  l2_.url AS url_24, 
  l2_.slug AS slug_25, 
  l2_.titolo AS titolo_26, 
  l2_.h1 AS h1_27, 
  l3_.id AS id_28, 
  l3_.slug AS slug_29, 
  l3_.titolo AS titolo_30, 
  l3_.h1 AS h1_31, 
  l0_.categoria_id AS categoria_id_32, 
  l0_.geo_id AS geo_id_33, 
  l0_.cliente_id AS cliente_id_34, 
  l0_.recapito_id AS recapito_id_35, 
  l0_.listing_id AS listing_id_36, 
  l0_.boximage_id AS boximage_id_37, 
  l0_.logo_id AS logo_id_38, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_39, 
  l0_.copertina_id AS copertina_id_40, 
  l1_.album_id AS album_id_41, 
  l2_.regione_id AS regione_id_42, 
  l2_.provincia_id AS provincia_id_43, 
  l2_.copertina_id AS copertina_id_44, 
  l3_.padre_id AS padre_id_45, 
  l3_.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_media_foto l1_ ON l0_.boximage_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l0_.categoria_id = l3_.id 
WHERE 
  l0_.id = ?
 Parameters: ['13531']
[Display runnable query]
 [ + - Explain query ]
28 0.80 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE l0_.id = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.email AS email_2, 
  l0_.premium AS premium_3, 
  l0_.slug AS slug_4, 
  l0_.titolo AS titolo_5, 
  l0_.h1 AS h1_6, 
  l0_.meta_title AS meta_title_7, 
  l0_.descrizione AS descrizione_8, 
  l1_.id AS id_9, 
  l1_.pubblico AS pubblico_10, 
  l1_.height AS height_11, 
  l1_.width AS width_12, 
  l1_.mime AS mime_13, 
  l1_.size AS size_14, 
  l1_.created_at AS created_at_15, 
  l1_.updated_at AS updated_at_16, 
  l1_.titolo AS titolo_17, 
  l1_.name AS name_18, 
  l1_.path AS path_19, 
  l1_.old_id AS old_id_20, 
  l1_.posizione AS posizione_21, 
  l2_.id AS id_22, 
  l2_.tipo AS tipo_23, 
  l2_.url AS url_24, 
  l2_.slug AS slug_25, 
  l2_.titolo AS titolo_26, 
  l2_.h1 AS h1_27, 
  l3_.id AS id_28, 
  l3_.slug AS slug_29, 
  l3_.titolo AS titolo_30, 
  l3_.h1 AS h1_31, 
  l0_.categoria_id AS categoria_id_32, 
  l0_.geo_id AS geo_id_33, 
  l0_.cliente_id AS cliente_id_34, 
  l0_.recapito_id AS recapito_id_35, 
  l0_.listing_id AS listing_id_36, 
  l0_.boximage_id AS boximage_id_37, 
  l0_.logo_id AS logo_id_38, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_39, 
  l0_.copertina_id AS copertina_id_40, 
  l1_.album_id AS album_id_41, 
  l2_.regione_id AS regione_id_42, 
  l2_.provincia_id AS provincia_id_43, 
  l2_.copertina_id AS copertina_id_44, 
  l3_.padre_id AS padre_id_45, 
  l3_.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_media_foto l1_ ON l0_.boximage_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l0_.categoria_id = l3_.id 
WHERE 
  l0_.id = ?
 Parameters: ['123']
[Display runnable query]
 [ + - Explain query ]
29 0.66 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE l0_.id = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.email AS email_2, 
  l0_.premium AS premium_3, 
  l0_.slug AS slug_4, 
  l0_.titolo AS titolo_5, 
  l0_.h1 AS h1_6, 
  l0_.meta_title AS meta_title_7, 
  l0_.descrizione AS descrizione_8, 
  l1_.id AS id_9, 
  l1_.pubblico AS pubblico_10, 
  l1_.height AS height_11, 
  l1_.width AS width_12, 
  l1_.mime AS mime_13, 
  l1_.size AS size_14, 
  l1_.created_at AS created_at_15, 
  l1_.updated_at AS updated_at_16, 
  l1_.titolo AS titolo_17, 
  l1_.name AS name_18, 
  l1_.path AS path_19, 
  l1_.old_id AS old_id_20, 
  l1_.posizione AS posizione_21, 
  l2_.id AS id_22, 
  l2_.tipo AS tipo_23, 
  l2_.url AS url_24, 
  l2_.slug AS slug_25, 
  l2_.titolo AS titolo_26, 
  l2_.h1 AS h1_27, 
  l3_.id AS id_28, 
  l3_.slug AS slug_29, 
  l3_.titolo AS titolo_30, 
  l3_.h1 AS h1_31, 
  l0_.categoria_id AS categoria_id_32, 
  l0_.geo_id AS geo_id_33, 
  l0_.cliente_id AS cliente_id_34, 
  l0_.recapito_id AS recapito_id_35, 
  l0_.listing_id AS listing_id_36, 
  l0_.boximage_id AS boximage_id_37, 
  l0_.logo_id AS logo_id_38, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_39, 
  l0_.copertina_id AS copertina_id_40, 
  l1_.album_id AS album_id_41, 
  l2_.regione_id AS regione_id_42, 
  l2_.provincia_id AS provincia_id_43, 
  l2_.copertina_id AS copertina_id_44, 
  l3_.padre_id AS padre_id_45, 
  l3_.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_media_foto l1_ ON l0_.boximage_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l0_.categoria_id = l3_.id 
WHERE 
  l0_.id = ?
 Parameters: ['8966']
[Display runnable query]
 [ + - Explain query ]
30 0.62 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE l0_.id = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.email AS email_2, 
  l0_.premium AS premium_3, 
  l0_.slug AS slug_4, 
  l0_.titolo AS titolo_5, 
  l0_.h1 AS h1_6, 
  l0_.meta_title AS meta_title_7, 
  l0_.descrizione AS descrizione_8, 
  l1_.id AS id_9, 
  l1_.pubblico AS pubblico_10, 
  l1_.height AS height_11, 
  l1_.width AS width_12, 
  l1_.mime AS mime_13, 
  l1_.size AS size_14, 
  l1_.created_at AS created_at_15, 
  l1_.updated_at AS updated_at_16, 
  l1_.titolo AS titolo_17, 
  l1_.name AS name_18, 
  l1_.path AS path_19, 
  l1_.old_id AS old_id_20, 
  l1_.posizione AS posizione_21, 
  l2_.id AS id_22, 
  l2_.tipo AS tipo_23, 
  l2_.url AS url_24, 
  l2_.slug AS slug_25, 
  l2_.titolo AS titolo_26, 
  l2_.h1 AS h1_27, 
  l3_.id AS id_28, 
  l3_.slug AS slug_29, 
  l3_.titolo AS titolo_30, 
  l3_.h1 AS h1_31, 
  l0_.categoria_id AS categoria_id_32, 
  l0_.geo_id AS geo_id_33, 
  l0_.cliente_id AS cliente_id_34, 
  l0_.recapito_id AS recapito_id_35, 
  l0_.listing_id AS listing_id_36, 
  l0_.boximage_id AS boximage_id_37, 
  l0_.logo_id AS logo_id_38, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_39, 
  l0_.copertina_id AS copertina_id_40, 
  l1_.album_id AS album_id_41, 
  l2_.regione_id AS regione_id_42, 
  l2_.provincia_id AS provincia_id_43, 
  l2_.copertina_id AS copertina_id_44, 
  l3_.padre_id AS padre_id_45, 
  l3_.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_media_foto l1_ ON l0_.boximage_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l0_.categoria_id = l3_.id 
WHERE 
  l0_.id = ?
 Parameters: ['3099']
[Display runnable query]
 [ + - Explain query ]
31 0.61 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE l0_.id = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.email AS email_2, 
  l0_.premium AS premium_3, 
  l0_.slug AS slug_4, 
  l0_.titolo AS titolo_5, 
  l0_.h1 AS h1_6, 
  l0_.meta_title AS meta_title_7, 
  l0_.descrizione AS descrizione_8, 
  l1_.id AS id_9, 
  l1_.pubblico AS pubblico_10, 
  l1_.height AS height_11, 
  l1_.width AS width_12, 
  l1_.mime AS mime_13, 
  l1_.size AS size_14, 
  l1_.created_at AS created_at_15, 
  l1_.updated_at AS updated_at_16, 
  l1_.titolo AS titolo_17, 
  l1_.name AS name_18, 
  l1_.path AS path_19, 
  l1_.old_id AS old_id_20, 
  l1_.posizione AS posizione_21, 
  l2_.id AS id_22, 
  l2_.tipo AS tipo_23, 
  l2_.url AS url_24, 
  l2_.slug AS slug_25, 
  l2_.titolo AS titolo_26, 
  l2_.h1 AS h1_27, 
  l3_.id AS id_28, 
  l3_.slug AS slug_29, 
  l3_.titolo AS titolo_30, 
  l3_.h1 AS h1_31, 
  l0_.categoria_id AS categoria_id_32, 
  l0_.geo_id AS geo_id_33, 
  l0_.cliente_id AS cliente_id_34, 
  l0_.recapito_id AS recapito_id_35, 
  l0_.listing_id AS listing_id_36, 
  l0_.boximage_id AS boximage_id_37, 
  l0_.logo_id AS logo_id_38, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_39, 
  l0_.copertina_id AS copertina_id_40, 
  l1_.album_id AS album_id_41, 
  l2_.regione_id AS regione_id_42, 
  l2_.provincia_id AS provincia_id_43, 
  l2_.copertina_id AS copertina_id_44, 
  l3_.padre_id AS padre_id_45, 
  l3_.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_media_foto l1_ ON l0_.boximage_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l0_.categoria_id = l3_.id 
WHERE 
  l0_.id = ?
 Parameters: ['10965']
[Display runnable query]
 [ + - Explain query ]
32 0.60 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE l0_.id = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.email AS email_2, 
  l0_.premium AS premium_3, 
  l0_.slug AS slug_4, 
  l0_.titolo AS titolo_5, 
  l0_.h1 AS h1_6, 
  l0_.meta_title AS meta_title_7, 
  l0_.descrizione AS descrizione_8, 
  l1_.id AS id_9, 
  l1_.pubblico AS pubblico_10, 
  l1_.height AS height_11, 
  l1_.width AS width_12, 
  l1_.mime AS mime_13, 
  l1_.size AS size_14, 
  l1_.created_at AS created_at_15, 
  l1_.updated_at AS updated_at_16, 
  l1_.titolo AS titolo_17, 
  l1_.name AS name_18, 
  l1_.path AS path_19, 
  l1_.old_id AS old_id_20, 
  l1_.posizione AS posizione_21, 
  l2_.id AS id_22, 
  l2_.tipo AS tipo_23, 
  l2_.url AS url_24, 
  l2_.slug AS slug_25, 
  l2_.titolo AS titolo_26, 
  l2_.h1 AS h1_27, 
  l3_.id AS id_28, 
  l3_.slug AS slug_29, 
  l3_.titolo AS titolo_30, 
  l3_.h1 AS h1_31, 
  l0_.categoria_id AS categoria_id_32, 
  l0_.geo_id AS geo_id_33, 
  l0_.cliente_id AS cliente_id_34, 
  l0_.recapito_id AS recapito_id_35, 
  l0_.listing_id AS listing_id_36, 
  l0_.boximage_id AS boximage_id_37, 
  l0_.logo_id AS logo_id_38, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_39, 
  l0_.copertina_id AS copertina_id_40, 
  l1_.album_id AS album_id_41, 
  l2_.regione_id AS regione_id_42, 
  l2_.provincia_id AS provincia_id_43, 
  l2_.copertina_id AS copertina_id_44, 
  l3_.padre_id AS padre_id_45, 
  l3_.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_media_foto l1_ ON l0_.boximage_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l0_.categoria_id = l3_.id 
WHERE 
  l0_.id = ?
 Parameters: ['13520']
[Display runnable query]
 [ + - Explain query ]
33 0.58 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE l0_.id = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.email AS email_2, 
  l0_.premium AS premium_3, 
  l0_.slug AS slug_4, 
  l0_.titolo AS titolo_5, 
  l0_.h1 AS h1_6, 
  l0_.meta_title AS meta_title_7, 
  l0_.descrizione AS descrizione_8, 
  l1_.id AS id_9, 
  l1_.pubblico AS pubblico_10, 
  l1_.height AS height_11, 
  l1_.width AS width_12, 
  l1_.mime AS mime_13, 
  l1_.size AS size_14, 
  l1_.created_at AS created_at_15, 
  l1_.updated_at AS updated_at_16, 
  l1_.titolo AS titolo_17, 
  l1_.name AS name_18, 
  l1_.path AS path_19, 
  l1_.old_id AS old_id_20, 
  l1_.posizione AS posizione_21, 
  l2_.id AS id_22, 
  l2_.tipo AS tipo_23, 
  l2_.url AS url_24, 
  l2_.slug AS slug_25, 
  l2_.titolo AS titolo_26, 
  l2_.h1 AS h1_27, 
  l3_.id AS id_28, 
  l3_.slug AS slug_29, 
  l3_.titolo AS titolo_30, 
  l3_.h1 AS h1_31, 
  l0_.categoria_id AS categoria_id_32, 
  l0_.geo_id AS geo_id_33, 
  l0_.cliente_id AS cliente_id_34, 
  l0_.recapito_id AS recapito_id_35, 
  l0_.listing_id AS listing_id_36, 
  l0_.boximage_id AS boximage_id_37, 
  l0_.logo_id AS logo_id_38, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_39, 
  l0_.copertina_id AS copertina_id_40, 
  l1_.album_id AS album_id_41, 
  l2_.regione_id AS regione_id_42, 
  l2_.provincia_id AS provincia_id_43, 
  l2_.copertina_id AS copertina_id_44, 
  l3_.padre_id AS padre_id_45, 
  l3_.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_media_foto l1_ ON l0_.boximage_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l0_.categoria_id = l3_.id 
WHERE 
  l0_.id = ?
 Parameters: ['1007']
[Display runnable query]
 [ + - Explain query ]
34 0.60 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ LEFT JOIN [...] WHERE l0_.id = ? 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.email AS email_2, 
  l0_.premium AS premium_3, 
  l0_.slug AS slug_4, 
  l0_.titolo AS titolo_5, 
  l0_.h1 AS h1_6, 
  l0_.meta_title AS meta_title_7, 
  l0_.descrizione AS descrizione_8, 
  l1_.id AS id_9, 
  l1_.pubblico AS pubblico_10, 
  l1_.height AS height_11, 
  l1_.width AS width_12, 
  l1_.mime AS mime_13, 
  l1_.size AS size_14, 
  l1_.created_at AS created_at_15, 
  l1_.updated_at AS updated_at_16, 
  l1_.titolo AS titolo_17, 
  l1_.name AS name_18, 
  l1_.path AS path_19, 
  l1_.old_id AS old_id_20, 
  l1_.posizione AS posizione_21, 
  l2_.id AS id_22, 
  l2_.tipo AS tipo_23, 
  l2_.url AS url_24, 
  l2_.slug AS slug_25, 
  l2_.titolo AS titolo_26, 
  l2_.h1 AS h1_27, 
  l3_.id AS id_28, 
  l3_.slug AS slug_29, 
  l3_.titolo AS titolo_30, 
  l3_.h1 AS h1_31, 
  l0_.categoria_id AS categoria_id_32, 
  l0_.geo_id AS geo_id_33, 
  l0_.cliente_id AS cliente_id_34, 
  l0_.recapito_id AS recapito_id_35, 
  l0_.listing_id AS listing_id_36, 
  l0_.boximage_id AS boximage_id_37, 
  l0_.logo_id AS logo_id_38, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_39, 
  l0_.copertina_id AS copertina_id_40, 
  l1_.album_id AS album_id_41, 
  l2_.regione_id AS regione_id_42, 
  l2_.provincia_id AS provincia_id_43, 
  l2_.copertina_id AS copertina_id_44, 
  l3_.padre_id AS padre_id_45, 
  l3_.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_media_foto l1_ ON l0_.boximage_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l0_.categoria_id = l3_.id 
WHERE 
  l0_.id = ?
 Parameters: ['13039']
[Display runnable query]
 [ + - Explain query ]
35 0.72 ms
+ - Shrink query SELECT t0.id AS id_1, [...] FROM lmn_media_foto t0 [...] WHERE lmn_vetrina_foto_re [...] ORDER BY t0.posizione ASC 
SELECT 
  t0.id AS id_1, 
  t0.pubblico AS pubblico_2, 
  t0.height AS height_3, 
  t0.width AS width_4, 
  t0.mime AS mime_5, 
  t0.size AS size_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8, 
  t0.titolo AS titolo_9, 
  t0.name AS name_10, 
  t0.path AS path_11, 
  t0.old_id AS old_id_12, 
  t0.posizione AS posizione_13, 
  t0.album_id AS album_id_14 
FROM 
  lmn_media_foto t0 
  INNER JOIN lmn_vetrina_foto_rel ON t0.id = lmn_vetrina_foto_rel.mediafoto_id 
WHERE 
  lmn_vetrina_foto_rel.vetrina_id = ? 
ORDER BY 
  t0.posizione ASC
 Parameters: [123]
[Display runnable query]
 [ + - Explain query ]
36 0.34 ms
+ - Shrink query SELECT t0.id AS id_1, t0.pubblico [...] FROM lmn_media_foto t0 WHERE t0.id = ? 
SELECT 
  t0.id AS id_1, 
  t0.pubblico AS pubblico_2, 
  t0.height AS height_3, 
  t0.width AS width_4, 
  t0.mime AS mime_5, 
  t0.size AS size_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8, 
  t0.titolo AS titolo_9, 
  t0.name AS name_10, 
  t0.path AS path_11, 
  t0.old_id AS old_id_12, 
  t0.posizione AS posizione_13, 
  t0.album_id AS album_id_14 
FROM 
  lmn_media_foto t0 
WHERE 
  t0.id = ?
 Parameters: [10871]
[Display runnable query]
 [ + - Explain query ]
37 0.51 ms
+ - Shrink query SELECT t0.id AS id_1, [...] FROM lmn_media_foto t0 [...] WHERE lmn_vetrina_foto_re [...] ORDER BY t0.posizione ASC 
SELECT 
  t0.id AS id_1, 
  t0.pubblico AS pubblico_2, 
  t0.height AS height_3, 
  t0.width AS width_4, 
  t0.mime AS mime_5, 
  t0.size AS size_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8, 
  t0.titolo AS titolo_9, 
  t0.name AS name_10, 
  t0.path AS path_11, 
  t0.old_id AS old_id_12, 
  t0.posizione AS posizione_13, 
  t0.album_id AS album_id_14 
FROM 
  lmn_media_foto t0 
  INNER JOIN lmn_vetrina_foto_rel ON t0.id = lmn_vetrina_foto_rel.mediafoto_id 
WHERE 
  lmn_vetrina_foto_rel.vetrina_id = ? 
ORDER BY 
  t0.posizione ASC
 Parameters: [1007]
[Display runnable query]
 [ + - Explain query ]
38 6.27 ms
+ - Shrink query SELECT count(l0_.id) AS sclr_0 FROM lmn_vetrina l0_ WHERE l0_.pubblico = 1 
SELECT 
  count(l0_.id) AS sclr_0 
FROM 
  lmn_vetrina l0_ 
WHERE 
  l0_.pubblico = 1
 Parameters: { }
[Display runnable query]
 [ + - Explain query ]
39 56.44 ms
+ - Shrink query SELECT l0_.id AS [...] FROM lmn_geo l0_ [...] WHERE l1_.pubblico = [...] HAVING sclr_19 > 0 ORDER BY l0_.titolo ASC 
SELECT 
  l0_.id AS id_0, 
  l0_.tipo AS tipo_1, 
  l0_.lat AS lat_2, 
  l0_.lon AS lon_3, 
  l0_.old_id AS old_id_4, 
  l0_.url AS url_5, 
  l0_.main AS main_6, 
  l0_.slug AS slug_7, 
  l0_.pubblico AS pubblico_8, 
  l0_.titolo AS titolo_9, 
  l0_.h1 AS h1_10, 
  l0_.h2 AS h2_11, 
  l0_.meta_title AS meta_title_12, 
  l0_.meta_keyword AS meta_keyword_13, 
  l0_.meta_description AS meta_description_14, 
  l0_.descrizione AS descrizione_15, 
  l0_.testo AS testo_16, 
  l0_.created_at AS created_at_17, 
  l0_.updated_at AS updated_at_18, 
  COUNT(l1_.id) AS sclr_19 
FROM 
  lmn_geo l0_ 
  INNER JOIN lmn_vetrina_geo_rel l2_ ON l0_.id = l2_.geo_id 
  INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
WHERE 
  l1_.pubblico = 1 
  AND l0_.tipo = 3 
GROUP BY 
  l0_.id 
HAVING 
  sclr_19 > 0 
ORDER BY 
  l0_.titolo ASC
 Parameters: { }
[Display runnable query]
 [ + - Explain query ]
40 70.12 ms
+ - Shrink query SELECT DISTINCT [...] FROM wp_posts w0_ [...] WHERE w0_.post_statu [...] ORDER BY w0_.post_date [...] LIMIT 1 
SELECT 
  DISTINCT w0_.ID AS ID_0, 
  w0_.post_name AS post_name_1, 
  w0_.post_title AS post_title_2, 
  w0_.post_date AS post_date_3, 
  w0_.post_excerpt AS post_excerpt_4, 
  w1_.meta_value AS meta_value_5 
FROM 
  wp_posts w0_ 
  INNER JOIN wp_postmeta w1_ ON w0_.ID = w1_.post_id 
  AND (w1_.meta_key = 'thumb') 
  INNER JOIN wp_postmeta w2_ ON w0_.ID = w2_.post_id 
  AND (
    w2_.meta_key = 'is_news' 
    AND w2_.meta_value = 1
  ) 
  INNER JOIN wp_postmeta w3_ ON w0_.ID = w3_.post_id 
  AND (
    w3_.meta_key = 'sticky_hp' 
    AND w3_.meta_value = 1
  ) 
WHERE 
  w0_.post_status = ? 
ORDER BY 
  w0_.post_date DESC 
LIMIT 
  1
 Parameters: [publish]
[Display runnable query]
 [ + - Explain query ]
41 14.85 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_categoria l0_ [...] WHERE (l0_.pubblico = 1 [...] ORDER BY l0_.titolo ASC 
SELECT 
  l0_.id AS id_0, 
  l0_.slug AS slug_1, 
  l0_.titolo AS titolo_2, 
  l0_.h1 AS h1_3, 
  COUNT(l1_.id) AS sclr_4 
FROM 
  lmn_categoria l0_ 
  INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.categoria_id 
  INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
WHERE 
  (
    l0_.pubblico = 1 
    AND l0_.lvl = 2
  ) 
  AND l1_.pubblico = 1 
GROUP BY 
  l0_.id 
ORDER BY 
  l0_.titolo ASC
 Parameters: { }
[Display runnable query]
 [ + - Explain query ]
42 37.71 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_categoria l0_ [...] WHERE l0_.lvl = 1 AND [...] ORDER BY l0_.titolo ASC 
SELECT 
  l0_.id AS id_0, 
  l0_.old_id AS old_id_1, 
  l0_.limitrofi AS limitrofi_2, 
  l0_.lft AS lft_3, 
  l0_.lvl AS lvl_4, 
  l0_.rgt AS rgt_5, 
  l0_.root AS root_6, 
  l0_.slug AS slug_7, 
  l0_.pubblico AS pubblico_8, 
  l0_.titolo AS titolo_9, 
  l0_.h1 AS h1_10, 
  l0_.h2 AS h2_11, 
  l0_.meta_title AS meta_title_12, 
  l0_.meta_keyword AS meta_keyword_13, 
  l0_.meta_description AS meta_description_14, 
  l0_.descrizione AS descrizione_15, 
  l0_.testo AS testo_16, 
  l0_.created_at AS created_at_17, 
  l0_.updated_at AS updated_at_18, 
  COUNT(DISTINCT l1_.id) AS sclr_19 
FROM 
  lmn_categoria l0_ 
  INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.categoria_id 
  INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
  INNER JOIN lmn_vetrina_recapito l3_ ON l1_.id = l3_.vetrina_id 
  INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id 
  INNER JOIN lmn_geo l5_ ON l4_.provincia_id = l5_.id 
  INNER JOIN lmn_vetrina_geo_rel l7_ ON l1_.id = l7_.vetrina_id 
  INNER JOIN lmn_geo l6_ ON l6_.id = l7_.geo_id 
  INNER JOIN lmn_geo l8_ ON l1_.geo_id = l8_.id 
WHERE 
  l0_.lvl = 1 
  AND l1_.pubblico = 1 
  AND (
    l4_.tipo = 4 
    AND l5_.id = ?
  ) 
  AND (
    (l8_.id = ?) 
    OR (
      l6_.id = ? 
      AND l1_.premium = 1
    )
  ) 
GROUP BY 
  l0_.id 
ORDER BY 
  l0_.titolo ASC
 Parameters: ['10402', '10402', '10402']
[Display runnable query]
 [ + - Explain query ]
43 11.06 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_categoria l0_ [...] WHERE l0_.lvl = 2 AND [...] ORDER BY l0_.titolo ASC 
SELECT 
  l0_.id AS id_0, 
  l0_.old_id AS old_id_1, 
  l0_.limitrofi AS limitrofi_2, 
  l0_.lft AS lft_3, 
  l0_.lvl AS lvl_4, 
  l0_.rgt AS rgt_5, 
  l0_.root AS root_6, 
  l0_.slug AS slug_7, 
  l0_.pubblico AS pubblico_8, 
  l0_.titolo AS titolo_9, 
  l0_.h1 AS h1_10, 
  l0_.h2 AS h2_11, 
  l0_.meta_title AS meta_title_12, 
  l0_.meta_keyword AS meta_keyword_13, 
  l0_.meta_description AS meta_description_14, 
  l0_.descrizione AS descrizione_15, 
  l0_.testo AS testo_16, 
  l0_.created_at AS created_at_17, 
  l0_.updated_at AS updated_at_18, 
  COUNT(DISTINCT l1_.id) AS sclr_19 
FROM 
  lmn_categoria l0_ 
  LEFT JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.categoria_id 
  LEFT JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
WHERE 
  l0_.lvl = 2 
  AND l1_.pubblico = 1 
  AND l1_.geo_id = ? 
GROUP BY 
  l0_.id 
ORDER BY 
  l0_.titolo ASC
 Parameters: ['10402']
[Display runnable query]
 [ + - Explain query ]
44 0.48 ms
+ - Shrink query SELECT t0.id AS id_1, t0.tipo AS [...] FROM lmn_geo t0 WHERE t0.id = ? 
SELECT 
  t0.id AS id_1, 
  t0.tipo AS tipo_2, 
  t0.lat AS lat_3, 
  t0.lon AS lon_4, 
  t0.old_id AS old_id_5, 
  t0.url AS url_6, 
  t0.main AS main_7, 
  t0.slug AS slug_8, 
  t0.pubblico AS pubblico_9, 
  t0.titolo AS titolo_10, 
  t0.h1 AS h1_11, 
  t0.h2 AS h2_12, 
  t0.meta_title AS meta_title_13, 
  t0.meta_keyword AS meta_keyword_14, 
  t0.meta_description AS meta_description_15, 
  t0.descrizione AS descrizione_16, 
  t0.testo AS testo_17, 
  t0.created_at AS created_at_18, 
  t0.updated_at AS updated_at_19, 
  t0.regione_id AS regione_id_20, 
  t0.provincia_id AS provincia_id_21, 
  t0.copertina_id AS copertina_id_22 
FROM 
  lmn_geo t0 
WHERE 
  t0.id = ?
 Parameters: ['10402']
[Display runnable query]
 [ + - Explain query ]

Database Connections

Key Value
default 
doctrine.dbal.default_connection

Entity Managers

Key Value
default 
doctrine.orm.default_entity_manager

Second Level Cache

Key Value
hits 
0
misses 
0
puts 
0

Mapping

Manager default

Class Mapping errors
Lmn\Admin\AuthBundle\Entity\User Valid
Lmn\OperatoriBundle\Entity\Cliente Valid
Lmn\UserBundle\Entity\User Valid
Lmn\CoreBundle\Entity\Nodo Valid
Lmn\OperatoriBundle\Entity\Vetrina Valid
Lmn\OperatoriBundle\Entity\Categoria Valid
Lmn\OperatoriBundle\Entity\Geo Valid
Lmn\OperatoriBundle\Entity\VetrinaRecapito Valid
Lmn\Cliente\PremiumBundle\Entity\VetrinaPremium Valid
Lmn\MediaBundle\Entity\Media Valid
Lmn\MediaBundle\Entity\MediaFoto Valid
Lmn\OperatoriBundle\Entity\VetrinaTipi Valid
Lmn\OperatoriBundle\Entity\CategoriaGeo Valid
Lmn\OperatoriBundle\Entity\VetrinaTop Valid
Lmn\MediaBundle\Entity\MediaAudio Valid
Lmn\MediaBundle\Entity\MediaVideo Valid
Lmn\Admin\UtilityBundle\Entity\PopUp Valid
Lmn\OperatoriBundle\Entity\Limitrofi Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumOrderDetail Valid
Lmn\MediaBundle\Entity\MediaAlbum Valid
Lmn\Admin\AuthBundle\Entity\Role Valid
Lmn\CoreBundle\Entity\Tag Valid
Lmn\CoreBundle\Entity\Sezione Valid
Lmn\OrganizzazioneBundle\Entity\OrganizzazioneCategoria Valid
Lmn\Admin\UtilityBundle\Entity\PopUpUrl Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumOrder Valid
Lmn\CoreBundle\Entity\TagCategoria Valid
Lmn\CoreBundle\Entity\Gallery Valid
Lmn\OrganizzazioneBundle\Entity\Organizzazione Valid
Lmn\OrganizzazioneBundle\Entity\CategoriaPagina Valid
Lmn\OrganizzazioneBundle\Entity\NewsTag Valid
Lmn\OrganizzazioneBundle\Entity\ForumTag Valid
JMS\Payment\CoreBundle\Entity\PaymentInstruction Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumFattura Valid
Lmn\CoreBundle\Entity\GalleryColumnTitle Valid
Lmn\AppBundle\Entity\App Valid
JMS\Payment\CoreBundle\Entity\Credit Valid
JMS\Payment\CoreBundle\Entity\Payment Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumFatturaDettaglio Valid
JMS\Payment\CoreBundle\Entity\FinancialTransaction Valid
Lmn\WordpressBundle\Entity\CategoriaNews Valid
Lmn\OperatoriBundle\Entity\Offerta Valid
Lmn\OperatoriBundle\Entity\VetrinaOffertaCoupon Valid
Lmn\MediaBundle\Entity\MediaPdf Valid
Lmn\WordpressBundle\Entity\WpPosts Valid
Lmn\WordpressBundle\Entity\WpPostmeta Valid