Profiler

View last 10 Profile for: GET http://i.lmnstatic.com/app_dev.php/_fragment?_path=_format%3Dhtml%26_locale%3Dit%26_controller%3DLmnCoreBundle%253ASocial%253AsocialBar by 3.140.207.29 at Mon, 07 Apr 2025 13:57:52 +0200

Queries

Connection default


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, 
  l1_.id AS id_13, 
  l1_.old_id AS old_id_14, 
  l1_.limitrofi AS limitrofi_15, 
  l1_.lft AS lft_16, 
  l1_.lvl AS lvl_17, 
  l1_.rgt AS rgt_18, 
  l1_.root AS root_19, 
  l1_.slug AS slug_20, 
  l1_.pubblico AS pubblico_21, 
  l1_.titolo AS titolo_22, 
  l1_.h1 AS h1_23, 
  l1_.h2 AS h2_24, 
  l1_.meta_title AS meta_title_25, 
  l1_.meta_keyword AS meta_keyword_26, 
  l1_.meta_description AS meta_description_27, 
  l1_.descrizione AS descrizione_28, 
  l1_.testo AS testo_29, 
  l1_.created_at AS created_at_30, 
  l1_.updated_at AS updated_at_31, 
  l2_.id AS id_32, 
  l2_.tipo AS tipo_33, 
  l2_.lat AS lat_34, 
  l2_.lon AS lon_35, 
  l2_.old_id AS old_id_36, 
  l2_.url AS url_37, 
  l2_.main AS main_38, 
  l2_.slug AS slug_39, 
  l2_.pubblico AS pubblico_40, 
  l2_.titolo AS titolo_41, 
  l2_.h1 AS h1_42, 
  l2_.h2 AS h2_43, 
  l2_.meta_title AS meta_title_44, 
  l2_.meta_keyword AS meta_keyword_45, 
  l2_.meta_description AS meta_description_46, 
  l2_.descrizione AS descrizione_47, 
  l2_.testo AS testo_48, 
  l2_.created_at AS created_at_49, 
  l2_.updated_at AS updated_at_50, 
  l3_.id AS id_51, 
  l3_.old_id AS old_id_52, 
  l3_.limitrofi AS limitrofi_53, 
  l3_.lft AS lft_54, 
  l3_.lvl AS lvl_55, 
  l3_.rgt AS rgt_56, 
  l3_.root AS root_57, 
  l3_.slug AS slug_58, 
  l3_.pubblico AS pubblico_59, 
  l3_.titolo AS titolo_60, 
  l3_.h1 AS h1_61, 
  l3_.h2 AS h2_62, 
  l3_.meta_title AS meta_title_63, 
  l3_.meta_keyword AS meta_keyword_64, 
  l3_.meta_description AS meta_description_65, 
  l3_.descrizione AS descrizione_66, 
  l3_.testo AS testo_67, 
  l3_.created_at AS created_at_68, 
  l3_.updated_at AS updated_at_69, 
  l0_.geo_id AS geo_id_70, 
  l0_.categoria_id AS categoria_id_71, 
  l0_.copertina_id AS copertina_id_72, 
  l1_.padre_id AS padre_id_73, 
  l1_.copertina_id AS copertina_id_74, 
  l2_.regione_id AS regione_id_75, 
  l2_.provincia_id AS provincia_id_76, 
  l2_.copertina_id AS copertina_id_77, 
  l3_.padre_id AS padre_id_78, 
  l3_.copertina_id AS copertina_id_79 
FROM 
  lmn_categoriageo l0_ 
  INNER JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  INNER JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
WHERE 
  l1_.slug = ? 
  AND (
    l2_.url = ? 
    AND l2_.tipo = 3
  )
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_geo_topposition_rel l6_ ON l4_.id = l6_.vetrinatop_id 
  INNER JOIN lmn_categoriageo l5_ ON l5_.id = l6_.categoriageo_id 
  INNER JOIN lmn_categoria l7_ ON l5_.categoria_id = l7_.id 
  INNER JOIN lmn_geo l8_ ON l5_.geo_id = l8_.id 
WHERE 
  l0_.pubblico = 1 
  AND l4_.data_inizio <= ? 
  AND l4_.data_fine >= ? 
  AND l7_.id = ? 
  AND l8_.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 
  INNER JOIN lmn_vetrina_geo_rel l5_ ON l0_.id = l5_.vetrina_id 
  INNER JOIN lmn_geo l4_ ON l4_.id = l5_.geo_id 
WHERE 
  l0_.pubblico = 1 
  AND l3_.tipo IN (2, 3) 
  AND l1_.id = ? 
  AND l4_.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 
  INNER JOIN lmn_geo l5_ ON l0_.geo_id = l5_.id 
WHERE 
  l0_.pubblico = 1 
  AND l4_.tipo NOT IN (2, 3) 
  AND l2_.id = ? 
  AND l5_.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 
  INNER JOIN lmn_geo l4_ ON l0_.geo_id = l4_.id 
WHERE 
  l0_.pubblico = 1 
  AND l3_.tipo NOT IN (2, 3) 
  AND l1_.id = ? 
  AND l4_.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 IN (2, 3) 
  AND l1_.id = ? 
  AND l0_.geo_id = 10399 
ORDER BY 
  l0_.id DESC

#▲	Time	Info
1	2.13 ms	Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ INNER [...] WHERE l1_.slug = ? AND (l2_.url = [...] 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, l1_.id AS id_13, l1_.old_id AS old_id_14, l1_.limitrofi AS limitrofi_15, l1_.lft AS lft_16, l1_.lvl AS lvl_17, l1_.rgt AS rgt_18, l1_.root AS root_19, l1_.slug AS slug_20, l1_.pubblico AS pubblico_21, l1_.titolo AS titolo_22, l1_.h1 AS h1_23, l1_.h2 AS h2_24, l1_.meta_title AS meta_title_25, l1_.meta_keyword AS meta_keyword_26, l1_.meta_description AS meta_description_27, l1_.descrizione AS descrizione_28, l1_.testo AS testo_29, l1_.created_at AS created_at_30, l1_.updated_at AS updated_at_31, l2_.id AS id_32, l2_.tipo AS tipo_33, l2_.lat AS lat_34, l2_.lon AS lon_35, l2_.old_id AS old_id_36, l2_.url AS url_37, l2_.main AS main_38, l2_.slug AS slug_39, l2_.pubblico AS pubblico_40, l2_.titolo AS titolo_41, l2_.h1 AS h1_42, l2_.h2 AS h2_43, l2_.meta_title AS meta_title_44, l2_.meta_keyword AS meta_keyword_45, l2_.meta_description AS meta_description_46, l2_.descrizione AS descrizione_47, l2_.testo AS testo_48, l2_.created_at AS created_at_49, l2_.updated_at AS updated_at_50, l3_.id AS id_51, l3_.old_id AS old_id_52, l3_.limitrofi AS limitrofi_53, l3_.lft AS lft_54, l3_.lvl AS lvl_55, l3_.rgt AS rgt_56, l3_.root AS root_57, l3_.slug AS slug_58, l3_.pubblico AS pubblico_59, l3_.titolo AS titolo_60, l3_.h1 AS h1_61, l3_.h2 AS h2_62, l3_.meta_title AS meta_title_63, l3_.meta_keyword AS meta_keyword_64, l3_.meta_description AS meta_description_65, l3_.descrizione AS descrizione_66, l3_.testo AS testo_67, l3_.created_at AS created_at_68, l3_.updated_at AS updated_at_69, l0_.geo_id AS geo_id_70, l0_.categoria_id AS categoria_id_71, l0_.copertina_id AS copertina_id_72, l1_.padre_id AS padre_id_73, l1_.copertina_id AS copertina_id_74, l2_.regione_id AS regione_id_75, l2_.provincia_id AS provincia_id_76, l2_.copertina_id AS copertina_id_77, l3_.padre_id AS padre_id_78, l3_.copertina_id AS copertina_id_79 FROM lmn_categoriageo l0_ INNER JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id INNER JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id WHERE l1_.slug = ? AND ( l2_.url = ? AND l2_.tipo = 3 ) Parameters: [viaggi_di_nozze, ascoli-piceno] [Display runnable query] [ Explain query ]
2	2.17 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_geo_topposition_rel l6_ ON l4_.id = l6_.vetrinatop_id INNER JOIN lmn_categoriageo l5_ ON l5_.id = l6_.categoriageo_id INNER JOIN lmn_categoria l7_ ON l5_.categoria_id = l7_.id INNER JOIN lmn_geo l8_ ON l5_.geo_id = l8_.id WHERE l0_.pubblico = 1 AND l4_.data_inizio <= ? AND l4_.data_fine >= ? AND l7_.id = ? AND l8_.id = ? ORDER BY l4_.posizione ASC Parameters: ['2025-04-07 00:00:00', '2025-04-07 00:00:00', 10, 10583] [Display runnable query] [ Explain query ]
3	2.12 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 INNER JOIN lmn_vetrina_geo_rel l5_ ON l0_.id = l5_.vetrina_id INNER JOIN lmn_geo l4_ ON l4_.id = l5_.geo_id WHERE l0_.pubblico = 1 AND l3_.tipo IN (2, 3) AND l1_.id = ? AND l4_.id = ? ORDER BY l0_.id DESC` Parameters: [10, 10583] [Display runnable query] [ Explain query ]
4	10.38 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 INNER JOIN lmn_geo l5_ ON l0_.geo_id = l5_.id WHERE l0_.pubblico = 1 AND l4_.tipo NOT IN (2, 3) AND l2_.id = ? AND l5_.id = ? AND l0_.updated_at > ? ORDER BY l0_.id DESC` Parameters: [10, 10583, '2014-02-01 00:00:00'] [Display runnable query] [ Explain query ]
5	4.79 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 INNER JOIN lmn_geo l4_ ON l0_.geo_id = l4_.id WHERE l0_.pubblico = 1 AND l3_.tipo NOT IN (2, 3) AND l1_.id = ? AND l4_.id = ? AND l0_.updated_at < ? ORDER BY l0_.id DESC` Parameters: [10, 10583, '2014-02-01 00:00:00'] [Display runnable query] [ Explain query ]
6	1.66 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 = ? AND l0_.geo_id = 10399 ORDER BY l0_.id DESC` Parameters: [10] [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\CategoriaGeo	Valid
Lmn\OperatoriBundle\Entity\Categoria	Valid
Lmn\OperatoriBundle\Entity\Geo	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\Limitrofi	Valid
Lmn\OperatoriBundle\Entity\VetrinaRecapito	Valid
Lmn\OperatoriBundle\Entity\VetrinaTipi	Valid
Lmn\OperatoriBundle\Entity\VetrinaTop	Valid