| 1 |
2.14 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
)
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 = 'fotografie_e_video' AND (l2_.url = 'lodi' AND l2_.tipo = 3)
Parameters: [fotografie_e_video, lodi]
[Display runnable query]
[
Explain query
]
|
| 2 |
1.79 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
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 <= '2025-07-05 00:00:00' AND l4_.data_fine >= '2025-07-05 00:00:00' AND l7_.id = 12 AND l8_.id = 11598 ORDER BY l4_.posizione ASC
Parameters: ['2025-07-05 00:00:00', '2025-07-05 00:00:00', 12, 11598]
[Display runnable query]
[
Explain query
]
|
| 3 |
1.58 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
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 = 12 AND l4_.id = 11598 ORDER BY l0_.id DESC
Parameters: [12, 11598]
[Display runnable query]
[
Explain query
]
|
| 4 |
8.85 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
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 = 12 AND l5_.id = 11598 AND l0_.updated_at > '2014-02-01 00:00:00' ORDER BY l0_.id DESC
Parameters: [12, 11598, '2014-02-01 00:00:00']
[Display runnable query]
[
Explain query
]
|
| 5 |
7.91 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
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 = 12 AND l4_.id = 11598 AND l0_.updated_at < '2014-02-01 00:00:00' ORDER BY l0_.id DESC
Parameters: [12, 11598, '2014-02-01 00:00:00']
[Display runnable query]
[
Explain query
]
|
| 6 |
6.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
WHERE
l0_.pubblico = 1
AND l3_.tipo IN (2, 3)
AND l1_.id = ?
AND l0_.geo_id = 10399
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 = 12 AND l0_.geo_id = 10399 ORDER BY l0_.id DESC
Parameters: [12]
[Display runnable query]
[
Explain query
]
|
| 7 |
1.28 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
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 = '13513' ORDER BY l10_.titolo ASC
Parameters: ['13513']
[Display runnable query]
[
Explain query
]
|
| 8 |
1.00 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
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 = '14148' ORDER BY l10_.titolo ASC
Parameters: ['14148']
[Display runnable query]
[
Explain query
]
|
| 9 |
0.95 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
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 = '9484' ORDER BY l10_.titolo ASC
Parameters: ['9484']
[Display runnable query]
[
Explain query
]
|
| 10 |
1.00 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
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 = '10708' ORDER BY l10_.titolo ASC
Parameters: ['10708']
[Display runnable query]
[
Explain query
]
|
| 11 |
1.23 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
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 = '7578' ORDER BY l10_.titolo ASC
Parameters: ['7578']
[Display runnable query]
[
Explain query
]
|
Search
Admin