Forms 1
Symfony 2.5.12
Symfony 2.5.12
Symfony Documentation
PHP
PHP7.1.33
PHP Extensionsxdebugaccel
PHP SAPIfpm-fcgi
Environment 355b0c app dev
Nameapp
Environmentdev
Token355b0c
Request 200 ComuneCatController indexAction on operatori_matrimonio_categoria_comune
Status200 OK
ControllerComuneCatController indexAction
Route nameoperatori_matrimonio_categoria_comune
Has sessionyes
Logs 28
Deprecated Calls 28
Time 984 ms
Total time 984 ms
Memory Usage 2.0 MB
Memory usage 2.0 / 128.0 MB
Security
anon.
Logged in as anon.
Authenticated Yes
Token class AnonymousToken
Database 34 in 186.94 ms
DB Queries 34
Query time 186.94 ms
Invalid entities 0

Queries

Connection default

#▲ Time Info
1 1.61 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_bologna, servizi_e_novita_per_il_matrimonio]
[Display runnable query]
 [ + - Explain query ]
2 0.99 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.tipo AS [...] FROM lmn_geo l0_ LEFT JOIN [...] WHERE l0_.slug = ? 
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, 
  l1_.id AS id_19, 
  l1_.tipo AS tipo_20, 
  l1_.lat AS lat_21, 
  l1_.lon AS lon_22, 
  l1_.old_id AS old_id_23, 
  l1_.url AS url_24, 
  l1_.main AS main_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, 
  l2_.id AS id_38, 
  l2_.tipo AS tipo_39, 
  l2_.lat AS lat_40, 
  l2_.lon AS lon_41, 
  l2_.old_id AS old_id_42, 
  l2_.url AS url_43, 
  l2_.main AS main_44, 
  l2_.slug AS slug_45, 
  l2_.pubblico AS pubblico_46, 
  l2_.titolo AS titolo_47, 
  l2_.h1 AS h1_48, 
  l2_.h2 AS h2_49, 
  l2_.meta_title AS meta_title_50, 
  l2_.meta_keyword AS meta_keyword_51, 
  l2_.meta_description AS meta_description_52, 
  l2_.descrizione AS descrizione_53, 
  l2_.testo AS testo_54, 
  l2_.created_at AS created_at_55, 
  l2_.updated_at AS updated_at_56, 
  l0_.regione_id AS regione_id_57, 
  l0_.provincia_id AS provincia_id_58, 
  l0_.copertina_id AS copertina_id_59, 
  l1_.regione_id AS regione_id_60, 
  l1_.provincia_id AS provincia_id_61, 
  l1_.copertina_id AS copertina_id_62, 
  l2_.regione_id AS regione_id_63, 
  l2_.provincia_id AS provincia_id_64, 
  l2_.copertina_id AS copertina_id_65 
FROM 
  lmn_geo l0_ 
  LEFT JOIN lmn_geo l1_ ON l0_.provincia_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.regione_id = l2_.id 
WHERE 
  l0_.slug = ?
 Parameters: [comune_zola-predosa]
[Display runnable query]
 [ + - Explain query ]
3 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_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-03-31 00:00:00', '2025-03-31 00:00:00', 18, 10456]
[Display runnable query]
 [ + - Explain query ]
4 1.28 ms
+ - Shrink query SELECT DISTINCT l0_.id AS [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC 
SELECT 
  DISTINCT l0_.id AS id_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 
  INNER JOIN lmn_vetrina_recapito l3_ ON l0_.id = l3_.vetrina_id 
  INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id 
  INNER JOIN lmn_premiums_vetrina l5_ ON l0_.listing_id = l5_.id 
  AND (
    l5_.attivo = 1 
    AND (
      ? BETWEEN l5_.data_start 
      AND l5_.data_end
    )
  ) 
WHERE 
  l0_.pubblico = 1 
  AND l1_.id = ? 
  AND l4_.id = ? 
ORDER BY 
  l0_.id DESC
 Parameters: ['2025-03-31 23:53:09', 18, 13613]
[Display runnable query]
 [ + - Explain query ]
5 1.00 ms
+ - Shrink query SELECT DISTINCT l0_.id AS [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC 
SELECT 
  DISTINCT l0_.id AS id_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 
  INNER JOIN lmn_vetrina_recapito l3_ ON l0_.recapito_id = l3_.id 
  INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id 
WHERE 
  l0_.pubblico = 1 
  AND l0_.listing_id IS NULL 
  AND l1_.id = ? 
  AND l4_.id = ? 
  AND l0_.updated_at > ? 
ORDER BY 
  l0_.id DESC
 Parameters: [18, 13613, '2014-02-01 00:00:00']
[Display runnable query]
 [ + - Explain query ]
6 0.91 ms
+ - Shrink query SELECT DISTINCT l0_.id AS [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC 
SELECT 
  DISTINCT l0_.id AS id_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 
  INNER JOIN lmn_vetrina_recapito l3_ ON l0_.recapito_id = l3_.id 
  INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id 
WHERE 
  l0_.pubblico = 1 
  AND l0_.listing_id IS NULL 
  AND l1_.id = ? 
  AND l4_.id = ? 
  AND l0_.updated_at < ? 
ORDER BY 
  l0_.id DESC
 Parameters: [18, 13613, '2014-02-01 00:00:00']
[Display runnable query]
 [ + - Explain query ]
7 1.68 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ [...] WHERE l0_.id = ? ORDER BY l10_.titolo ASC 
SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.premium AS premium_2, 
  l0_.slug AS slug_3, 
  l0_.titolo AS titolo_4, 
  l0_.h1 AS h1_5, 
  l0_.descrizione AS descrizione_6, 
  l1_.id AS id_7, 
  l2_.id AS id_8, 
  l2_.tipo AS tipo_9, 
  l2_.url AS url_10, 
  l2_.titolo AS titolo_11, 
  l2_.h1 AS h1_12, 
  l3_.id AS id_13, 
  l3_.tipo AS tipo_14, 
  l3_.url AS url_15, 
  l3_.titolo AS titolo_16, 
  l3_.h1 AS h1_17, 
  l4_.id AS id_18, 
  l5_.id AS id_19, 
  l5_.titolo AS titolo_20, 
  l6_.id AS id_21, 
  l6_.titolo AS titolo_22, 
  l7_.id AS id_23, 
  l7_.attivo AS attivo_24, 
  l8_.id AS id_25, 
  l8_.tipo AS tipo_26, 
  l9_.id AS id_27, 
  l9_.slug AS slug_28, 
  l9_.titolo AS titolo_29, 
  l9_.h1 AS h1_30, 
  l10_.id AS id_31, 
  l10_.titolo AS titolo_32, 
  l11_.id AS id_33, 
  l11_.tipo AS tipo_34, 
  l11_.url AS url_35, 
  l11_.titolo AS titolo_36, 
  l11_.h1 AS h1_37, 
  l12_.id AS id_38, 
  l12_.name AS name_39, 
  l13_.id AS id_40, 
  l13_.name AS name_41 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_vetrina_recapito l1_ ON l0_.recapito_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l1_.geo_id = l2_.id 
  INNER JOIN lmn_geo l3_ ON l2_.provincia_id = l3_.id 
  LEFT JOIN lmn_vetrina_recapito l4_ ON l0_.id = l4_.vetrina_id 
  LEFT JOIN lmn_geo l5_ ON l4_.geo_id = l5_.id 
  INNER JOIN lmn_geo l6_ ON l5_.provincia_id = l6_.id 
  LEFT JOIN lmn_premiums_vetrina l7_ ON l0_.listing_id = l7_.id 
  LEFT JOIN lmn_vetrina_tipi l8_ ON l0_.vetrina_tipo_id = l8_.id 
  INNER JOIN lmn_categoria l9_ ON l0_.categoria_id = l9_.id 
  LEFT JOIN lmn_vetrina_geo_rel l14_ ON l0_.id = l14_.vetrina_id 
  LEFT JOIN lmn_geo l10_ ON l10_.id = l14_.geo_id 
  INNER JOIN lmn_geo l11_ ON l0_.geo_id = l11_.id 
  LEFT JOIN lmn_media_foto l12_ ON l0_.boximage_id = l12_.id 
  LEFT JOIN lmn_media_foto l13_ ON l0_.copertina_id = l13_.id 
WHERE 
  l0_.id = ? 
ORDER BY 
  l10_.titolo ASC
 Parameters: [14875]
[Display runnable query]
 [ + - Explain query ]
8 0.65 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 ]
9 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 ]
10 0.89 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 ]
11 0.70 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 ]
12 20.33 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: [10456, 10456, 10456]
[Display runnable query]
 [ + - Explain query ]
13 0.54 ms
+ - Shrink query SELECT t0.id AS id_1, [...] FROM lmn_geo_limitrofi [...] WHERE t0.geo_id = ? ORDER BY t0.distanza ASC 
SELECT 
  t0.id AS id_1, 
  t0.distanza AS distanza_2, 
  t0.geo_id AS geo_id_3, 
  t0.geo_limitrofo_id AS geo_limitrofo_id_4 
FROM 
  lmn_geo_limitrofi t0 
WHERE 
  t0.geo_id = ? 
ORDER BY 
  t0.distanza ASC
 Parameters: [10456]
[Display runnable query]
 [ + - Explain query ]
14 0.30 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: [10464]
[Display runnable query]
 [ + - Explain query ]
15 1.28 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_modena, 18]
[Display runnable query]
 [ + - Explain query ]
16 0.37 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: [10461]
[Display runnable query]
 [ + - Explain query ]
17 1.14 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_ferrara, 18]
[Display runnable query]
 [ + - Explain query ]
18 0.37 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: [10480]
[Display runnable query]
 [ + - Explain query ]
19 1.20 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_reggio-emilia, 18]
[Display runnable query]
 [ + - Explain query ]
20 0.35 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: [10471]
[Display runnable query]
 [ + - Explain query ]
21 1.13 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_ravenna, 18]
[Display runnable query]
 [ + - Explain query ]
22 0.34 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: [10667]
[Display runnable query]
 [ + - Explain query ]
23 1.15 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_pistoia, 18]
[Display runnable query]
 [ + - Explain query ]
24 0.36 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: [10672]
[Display runnable query]
 [ + - Explain query ]
25 1.14 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_prato, 18]
[Display runnable query]
 [ + - Explain query ]
26 0.36 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: [10732]
[Display runnable query]
 [ + - Explain query ]
27 1.17 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_rovigo, 18]
[Display runnable query]
 [ + - Explain query ]
28 0.36 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: [11889]
[Display runnable query]
 [ + - Explain query ]
29 1.13 ms
+ - Shrink query SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...] 
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, 
  l0_.geo_id AS geo_id_51, 
  l0_.categoria_id AS categoria_id_52, 
  l0_.copertina_id AS copertina_id_53, 
  l1_.padre_id AS padre_id_54, 
  l1_.copertina_id AS copertina_id_55, 
  l2_.regione_id AS regione_id_56, 
  l2_.provincia_id AS provincia_id_57, 
  l2_.copertina_id AS copertina_id_58 
FROM 
  lmn_categoriageo l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id 
  LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l2_.slug = ? 
  AND l1_.slug = ?
 Parameters: [provincia_forli-cesena, 18]
[Display runnable query]
 [ + - Explain query ]
30 5.24 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_geo l0_ INNER [...] WHERE l1_.pubblico = 1 [...] 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(DISTINCT l1_.id) AS sclr_19 
FROM 
  lmn_geo l0_ 
  INNER JOIN lmn_geo l2_ ON l0_.provincia_id = l2_.id 
  INNER JOIN lmn_vetrina_recapito l3_ ON l0_.id = l3_.geo_id 
  INNER JOIN lmn_vetrina l1_ ON l3_.vetrina_id = l1_.id 
  INNER JOIN lmn_vetrina_categoria_rel l5_ ON l1_.id = l5_.vetrina_id 
  INNER JOIN lmn_categoria l4_ ON l4_.id = l5_.categoria_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 
  l1_.pubblico = 1 
  AND l4_.id = ? 
  AND (
    l0_.tipo = 4 
    AND l2_.id = ?
  ) 
  AND (
    (l8_.id = ?) 
    OR (
      l6_.id = ? 
      AND l1_.premium = 1
    )
  ) 
GROUP BY 
  l0_.id 
ORDER BY 
  l0_.titolo ASC
 Parameters: [18, 10456, 10456, 10456]
[Display runnable query]
 [ + - Explain query ]
31 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 ]
32 50.67 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 ]
33 64.92 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 ]
34 14.64 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\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
Lmn\Cliente\PremiumBundle\Entity\VetrinaPremium Valid
Lmn\Admin\AuthBundle\Entity\Role Valid
Lmn\MediaBundle\Entity\MediaAlbum Valid
Lmn\CoreBundle\Entity\Tag 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\Cliente\PremiumBundle\Entity\PremiumOrderDetail 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
Lmn\Cliente\PremiumBundle\Entity\PremiumOrder Valid
Lmn\CoreBundle\Entity\GalleryColumnTitle 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