Profiler

View last 10 Profile for: GET https://i.lmnstatic.com/app_dev.php/_fragment?_path=_format%3Dhtml%26_locale%3Dit%26_controller%3DLmnCoreBundle%253ALayout%253AboxMiniTop by 3.147.195.139 at Tue, 18 Mar 2025 15:07:49 +0100

Queries

Connection default


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, 
  l1_.id AS id_19, 
  l1_.old_id AS old_id_20, 
  l1_.limitrofi AS limitrofi_21, 
  l1_.lft AS lft_22, 
  l1_.lvl AS lvl_23, 
  l1_.rgt AS rgt_24, 
  l1_.root AS root_25, 
  l1_.slug AS slug_26, 
  l1_.pubblico AS pubblico_27, 
  l1_.titolo AS titolo_28, 
  l1_.h1 AS h1_29, 
  l1_.h2 AS h2_30, 
  l1_.meta_title AS meta_title_31, 
  l1_.meta_keyword AS meta_keyword_32, 
  l1_.meta_description AS meta_description_33, 
  l1_.descrizione AS descrizione_34, 
  l1_.testo AS testo_35, 
  l1_.created_at AS created_at_36, 
  l1_.updated_at AS updated_at_37, 
  l0_.padre_id AS padre_id_38, 
  l0_.copertina_id AS copertina_id_39, 
  l1_.padre_id AS padre_id_40, 
  l1_.copertina_id AS copertina_id_41 
FROM 
  lmn_categoria l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.padre_id = l1_.id 
WHERE 
  l0_.slug = ?
SELECT 
  DISTINCT (l0_.id) AS sclr_0 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id 
  INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id 
  LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id 
  INNER JOIN lmn_vetrina_top l4_ ON l0_.id = l4_.vetrina_id 
  INNER JOIN lmn_categoria_topposition_rel l6_ ON l4_.id = l6_.vetrinatop_id 
  INNER JOIN lmn_categoria l5_ ON l5_.id = l6_.categoria_id 
WHERE 
  l0_.pubblico = 1 
  AND l4_.data_inizio <= ? 
  AND l4_.data_fine >= ? 
  AND l5_.id = ? 
ORDER BY 
  l4_.posizione ASC
SELECT 
  DISTINCT (l0_.id) AS sclr_0 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id 
  INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id 
  LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id 
WHERE 
  l0_.pubblico = 1 
  AND l3_.tipo IN (2, 3) 
  AND l1_.id = ? 
ORDER BY 
  l0_.id DESC
SELECT 
  DISTINCT (l0_.id) AS sclr_0, 
  l1_.id AS id_1 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_vetrina_categoria_rel l3_ ON l0_.id = l3_.vetrina_id 
  INNER JOIN lmn_categoria l2_ ON l2_.id = l3_.categoria_id 
  LEFT JOIN lmn_vetrina_tipi l4_ ON l0_.vetrina_tipo_id = l4_.id 
  LEFT JOIN lmn_media_foto l1_ ON l0_.copertina_id = l1_.id 
WHERE 
  l0_.pubblico = 1 
  AND l4_.tipo NOT IN (2, 3) 
  AND l2_.id = ? 
  AND l0_.updated_at > ? 
ORDER BY 
  l0_.id DESC
SELECT 
  DISTINCT (l0_.id) AS sclr_0 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id 
  INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id 
  LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id 
WHERE 
  l0_.pubblico = 1 
  AND l3_.tipo NOT IN (2, 3) 
  AND l1_.id = ? 
  AND l0_.updated_at < ? 
ORDER BY 
  l0_.id DESC
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 = ?
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
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
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
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_.lvl = 1 
  AND l1_.pubblico = 1 
GROUP BY 
  l0_.id 
ORDER BY 
  l0_.titolo ASC
SELECT 
  COUNT(l0_.id) AS sclr_0, 
  l1_.id AS id_1, 
  l1_.slug AS slug_2, 
  l1_.pubblico AS pubblico_3, 
  l1_.titolo AS titolo_4, 
  l1_.h1 AS h1_5, 
  l1_.h2 AS h2_6, 
  l1_.meta_title AS meta_title_7, 
  l1_.meta_keyword AS meta_keyword_8, 
  l1_.meta_description AS meta_description_9, 
  l1_.descrizione AS descrizione_10, 
  l1_.testo AS testo_11, 
  l1_.created_at AS created_at_12, 
  l1_.updated_at AS updated_at_13, 
  l2_.id AS id_14, 
  l2_.old_id AS old_id_15, 
  l2_.limitrofi AS limitrofi_16, 
  l2_.lft AS lft_17, 
  l2_.lvl AS lvl_18, 
  l2_.rgt AS rgt_19, 
  l2_.root AS root_20, 
  l2_.slug AS slug_21, 
  l2_.pubblico AS pubblico_22, 
  l2_.titolo AS titolo_23, 
  l2_.h1 AS h1_24, 
  l2_.h2 AS h2_25, 
  l2_.meta_title AS meta_title_26, 
  l2_.meta_keyword AS meta_keyword_27, 
  l2_.meta_description AS meta_description_28, 
  l2_.descrizione AS descrizione_29, 
  l2_.testo AS testo_30, 
  l2_.created_at AS created_at_31, 
  l2_.updated_at AS updated_at_32, 
  l3_.id AS id_33, 
  l3_.tipo AS tipo_34, 
  l3_.lat AS lat_35, 
  l3_.lon AS lon_36, 
  l3_.old_id AS old_id_37, 
  l3_.url AS url_38, 
  l3_.main AS main_39, 
  l3_.slug AS slug_40, 
  l3_.pubblico AS pubblico_41, 
  l3_.titolo AS titolo_42, 
  l3_.h1 AS h1_43, 
  l3_.h2 AS h2_44, 
  l3_.meta_title AS meta_title_45, 
  l3_.meta_keyword AS meta_keyword_46, 
  l3_.meta_description AS meta_description_47, 
  l3_.descrizione AS descrizione_48, 
  l3_.testo AS testo_49, 
  l3_.created_at AS created_at_50, 
  l3_.updated_at AS updated_at_51 
FROM 
  lmn_categoriageo l1_ 
  INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id 
  AND (l1_.categoria_id = 18) 
  INNER JOIN lmn_geo l3_ ON l1_.geo_id = l3_.id 
  INNER JOIN lmn_vetrina_geo_rel l4_ ON l3_.id = l4_.geo_id 
  INNER JOIN lmn_vetrina l0_ ON l0_.id = l4_.vetrina_id 
  INNER JOIN lmn_vetrina_categoria_rel l6_ ON l0_.id = l6_.vetrina_id 
  INNER JOIN lmn_categoria l5_ ON l5_.id = l6_.categoria_id 
WHERE 
  l3_.tipo = ? 
  AND l0_.pubblico = 1 
  AND l0_.categoria_id = ? 
GROUP BY 
  l3_.id 
ORDER BY 
  l3_.titolo ASC
SELECT 
  count(l0_.id) AS sclr_0 
FROM 
  lmn_vetrina l0_ 
WHERE 
  l0_.pubblico = 1
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
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
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

#▲	Time	Info
1	0.92 ms	Shrink query SELECT l0_.id AS id_0, l0_.old_id [...] FROM lmn_categoria l0_ LEFT JOIN [...] WHERE l0_.slug = ? 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, l1_.id AS id_19, l1_.old_id AS old_id_20, l1_.limitrofi AS limitrofi_21, l1_.lft AS lft_22, l1_.lvl AS lvl_23, l1_.rgt AS rgt_24, l1_.root AS root_25, l1_.slug AS slug_26, l1_.pubblico AS pubblico_27, l1_.titolo AS titolo_28, l1_.h1 AS h1_29, l1_.h2 AS h2_30, l1_.meta_title AS meta_title_31, l1_.meta_keyword AS meta_keyword_32, l1_.meta_description AS meta_description_33, l1_.descrizione AS descrizione_34, l1_.testo AS testo_35, l1_.created_at AS created_at_36, l1_.updated_at AS updated_at_37, l0_.padre_id AS padre_id_38, l0_.copertina_id AS copertina_id_39, l1_.padre_id AS padre_id_40, l1_.copertina_id AS copertina_id_41 FROM lmn_categoria l0_ LEFT JOIN lmn_categoria l1_ ON l0_.padre_id = l1_.id WHERE l0_.slug = ? Parameters: [servizi_e_novita_per_il_matrimonio] [Display runnable query] [ Explain query ]
2	1.62 ms	Shrink query SELECT DISTINCT (l0_.id) [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l4_.posizione ASC SELECT DISTINCT (l0_.id) AS sclr_0 FROM lmn_vetrina l0_ INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id INNER JOIN lmn_vetrina_top l4_ ON l0_.id = l4_.vetrina_id INNER JOIN lmn_categoria_topposition_rel l6_ ON l4_.id = l6_.vetrinatop_id INNER JOIN lmn_categoria l5_ ON l5_.id = l6_.categoria_id WHERE l0_.pubblico = 1 AND l4_.data_inizio <= ? AND l4_.data_fine >= ? AND l5_.id = ? ORDER BY l4_.posizione ASC Parameters: ['2025-03-18 00:00:00', '2025-03-18 00:00:00', 18] [Display runnable query] [ Explain query ]
3	3.16 ms	Shrink query SELECT DISTINCT (l0_.id) [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC `SELECT DISTINCT (l0_.id) AS sclr_0 FROM lmn_vetrina l0_ INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id WHERE l0_.pubblico = 1 AND l3_.tipo IN (2, 3) AND l1_.id = ? ORDER BY l0_.id DESC` Parameters: [18] [Display runnable query] [ Explain query ]
4	4.47 ms	Shrink query SELECT DISTINCT (l0_.id) [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC `SELECT DISTINCT (l0_.id) AS sclr_0, l1_.id AS id_1 FROM lmn_vetrina l0_ INNER JOIN lmn_vetrina_categoria_rel l3_ ON l0_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l2_.id = l3_.categoria_id LEFT JOIN lmn_vetrina_tipi l4_ ON l0_.vetrina_tipo_id = l4_.id LEFT JOIN lmn_media_foto l1_ ON l0_.copertina_id = l1_.id WHERE l0_.pubblico = 1 AND l4_.tipo NOT IN (2, 3) AND l2_.id = ? AND l0_.updated_at > ? ORDER BY l0_.id DESC` Parameters: [18, '2014-02-01 00:00:00'] [Display runnable query] [ Explain query ]
5	2.74 ms	Shrink query SELECT DISTINCT (l0_.id) [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC `SELECT DISTINCT (l0_.id) AS sclr_0 FROM lmn_vetrina l0_ INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id WHERE l0_.pubblico = 1 AND l3_.tipo NOT IN (2, 3) AND l1_.id = ? AND l0_.updated_at < ? ORDER BY l0_.id DESC` Parameters: [18, '2014-02-01 00:00:00'] [Display runnable query] [ Explain query ]
6	0.76 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 ]
7	0.85 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 ]
8	0.91 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 ]
9	0.68 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 ]
10	45.92 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_.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_.lvl = 1 AND l1_.pubblico = 1 GROUP BY l0_.id ORDER BY l0_.titolo ASC` Parameters: { } [Display runnable query] [ Explain query ]
11	47.29 ms	Shrink query SELECT COUNT(l0_.id) AS [...] FROM lmn_categoriageo [...] WHERE l3_.tipo = ? AND [...] ORDER BY l3_.titolo ASC SELECT COUNT(l0_.id) AS sclr_0, l1_.id AS id_1, l1_.slug AS slug_2, l1_.pubblico AS pubblico_3, l1_.titolo AS titolo_4, l1_.h1 AS h1_5, l1_.h2 AS h2_6, l1_.meta_title AS meta_title_7, l1_.meta_keyword AS meta_keyword_8, l1_.meta_description AS meta_description_9, l1_.descrizione AS descrizione_10, l1_.testo AS testo_11, l1_.created_at AS created_at_12, l1_.updated_at AS updated_at_13, l2_.id AS id_14, l2_.old_id AS old_id_15, l2_.limitrofi AS limitrofi_16, l2_.lft AS lft_17, l2_.lvl AS lvl_18, l2_.rgt AS rgt_19, l2_.root AS root_20, l2_.slug AS slug_21, l2_.pubblico AS pubblico_22, l2_.titolo AS titolo_23, l2_.h1 AS h1_24, l2_.h2 AS h2_25, l2_.meta_title AS meta_title_26, l2_.meta_keyword AS meta_keyword_27, l2_.meta_description AS meta_description_28, l2_.descrizione AS descrizione_29, l2_.testo AS testo_30, l2_.created_at AS created_at_31, l2_.updated_at AS updated_at_32, l3_.id AS id_33, l3_.tipo AS tipo_34, l3_.lat AS lat_35, l3_.lon AS lon_36, l3_.old_id AS old_id_37, l3_.url AS url_38, l3_.main AS main_39, l3_.slug AS slug_40, l3_.pubblico AS pubblico_41, l3_.titolo AS titolo_42, l3_.h1 AS h1_43, l3_.h2 AS h2_44, l3_.meta_title AS meta_title_45, l3_.meta_keyword AS meta_keyword_46, l3_.meta_description AS meta_description_47, l3_.descrizione AS descrizione_48, l3_.testo AS testo_49, l3_.created_at AS created_at_50, l3_.updated_at AS updated_at_51 FROM lmn_categoriageo l1_ INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id AND (l1_.categoria_id = 18) INNER JOIN lmn_geo l3_ ON l1_.geo_id = l3_.id INNER JOIN lmn_vetrina_geo_rel l4_ ON l3_.id = l4_.geo_id INNER JOIN lmn_vetrina l0_ ON l0_.id = l4_.vetrina_id INNER JOIN lmn_vetrina_categoria_rel l6_ ON l0_.id = l6_.vetrina_id INNER JOIN lmn_categoria l5_ ON l5_.id = l6_.categoria_id WHERE l3_.tipo = ? AND l0_.pubblico = 1 AND l0_.categoria_id = ? GROUP BY l3_.id ORDER BY l3_.titolo ASC Parameters: [3, 18] [Display runnable query] [ Explain query ]
12	4.15 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 ]
13	47.45 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 ]
14	64.14 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 ]
15	11.16 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 ]

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\Categoria	Valid
Lmn\MediaBundle\Entity\Media	Valid
Lmn\MediaBundle\Entity\MediaFoto	Valid
Lmn\OperatoriBundle\Entity\Vetrina	Valid
Lmn\Admin\UtilityBundle\Entity\PopUp	Valid
Lmn\OperatoriBundle\Entity\VetrinaTipi	Valid
Lmn\OperatoriBundle\Entity\VetrinaTop	Valid
Lmn\Admin\AuthBundle\Entity\Role	Valid
Lmn\OperatoriBundle\Entity\Geo	Valid
Lmn\MediaBundle\Entity\MediaAlbum	Valid
Lmn\CoreBundle\Entity\Tag	Valid
Lmn\OperatoriBundle\Entity\VetrinaRecapito	Valid
Lmn\Cliente\PremiumBundle\Entity\VetrinaPremium	Valid
Lmn\OperatoriBundle\Entity\CategoriaGeo	Valid
Lmn\MediaBundle\Entity\MediaAudio	Valid
Lmn\MediaBundle\Entity\MediaVideo	Valid
Lmn\Admin\UtilityBundle\Entity\PopUpUrl	Valid
Lmn\CoreBundle\Entity\Sezione	Valid
Lmn\OrganizzazioneBundle\Entity\OrganizzazioneCategoria	Valid
Lmn\OperatoriBundle\Entity\Limitrofi	Valid
Lmn\CoreBundle\Entity\TagCategoria	Valid
Lmn\CoreBundle\Entity\Gallery	Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumOrderDetail	Valid
Lmn\OrganizzazioneBundle\Entity\Organizzazione	Valid
Lmn\OrganizzazioneBundle\Entity\CategoriaPagina	Valid
Lmn\OrganizzazioneBundle\Entity\NewsTag	Valid
Lmn\OrganizzazioneBundle\Entity\ForumTag	Valid
Lmn\CoreBundle\Entity\GalleryColumnTitle	Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumOrder	Valid
Lmn\AppBundle\Entity\App	Valid
JMS\Payment\CoreBundle\Entity\PaymentInstruction	Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumFattura	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\WordpressBundle\Entity\WpPosts	Valid
Lmn\WordpressBundle\Entity\WpPostmeta	Valid