1 |
1.44 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.tipo AS [...] FROM lmn_geo l0_ INNER JOIN [...] WHERE l0_.tipo = 3 AND l0_.url = ?
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,
l0_.regione_id AS regione_id_38,
l0_.provincia_id AS provincia_id_39,
l0_.copertina_id AS copertina_id_40,
l1_.regione_id AS regione_id_41,
l1_.provincia_id AS provincia_id_42,
l1_.copertina_id AS copertina_id_43
FROM
lmn_geo l0_
INNER JOIN lmn_geo l1_ ON l0_.regione_id = l1_.id
WHERE
l0_.tipo = 3
AND l0_.url = ?
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, l0_.regione_id AS regione_id_38, l0_.provincia_id AS provincia_id_39, l0_.copertina_id AS copertina_id_40, l1_.regione_id AS regione_id_41, l1_.provincia_id AS provincia_id_42, l1_.copertina_id AS copertina_id_43 FROM lmn_geo l0_ INNER JOIN lmn_geo l1_ ON l0_.regione_id = l1_.id WHERE l0_.tipo = 3 AND l0_.url = 'reggio-emilia'
Parameters: [reggio-emilia]
[Display runnable query]
[
Explain query
]
|
2 |
1.42 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_geo_topposition_rel l6_ ON l4_.id = l6_.vetrinatop_id
INNER JOIN lmn_geo l5_ ON l5_.id = l6_.geo_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 INNER JOIN lmn_vetrina_top l4_ ON l0_.id = l4_.vetrina_id INNER JOIN lmn_geo_topposition_rel l6_ ON l4_.id = l6_.vetrinatop_id INNER JOIN lmn_geo l5_ ON l5_.id = l6_.geo_id WHERE l0_.pubblico = 1 AND l4_.data_inizio <= '2025-04-03 00:00:00' AND l4_.data_fine >= '2025-04-03 00:00:00' AND l5_.id = 10480 ORDER BY l4_.posizione ASC
Parameters: ['2025-04-03 00:00:00', '2025-04-03 00:00:00', 10480]
[Display runnable query]
[
Explain query
]
|
3 |
1.78 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 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 l4_.id = 10480 ORDER BY l0_.id DESC
Parameters: [10480]
[Display runnable query]
[
Explain query
]
|
4 |
9.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,
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 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 l5_.id = 10480 AND l0_.updated_at > '2014-02-01 00:00:00' ORDER BY l0_.id DESC
Parameters: [10480, '2014-02-01 00:00:00']
[Display runnable query]
[
Explain query
]
|
5 |
7.09 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 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 l4_.id = 10480 AND l0_.updated_at < '2014-02-01 00:00:00' ORDER BY l0_.id DESC
Parameters: [10480, '2014-02-01 00:00:00']
[Display runnable query]
[
Explain query
]
|
6 |
30.95 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_recapito l4_ ON l0_.recapito_id = l4_.id
WHERE
l0_.pubblico = 1
AND l3_.tipo IN (2, 3)
AND l1_.limitrofi = 1
AND (
l4_.lat <= ?
AND l4_.lon <= ?
AND l4_.lat >= ?
AND l4_.lon >= ?
)
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_recapito l4_ ON l0_.recapito_id = l4_.id WHERE l0_.pubblico = 1 AND l3_.tipo IN (2, 3) AND l1_.limitrofi = 1 AND (l4_.lat <= 45.355030630631 AND l4_.lon <= 11.530027862578 AND l4_.lat >= 44.093769369369 AND l4_.lon >= 9.7599721374217) ORDER BY l0_.id DESC
Parameters: [45.355030630631, 11.530027862578, 44.093769369369, 9.7599721374217]
[Display runnable query]
[
Explain query
]
|
7 |
1.14 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 = '7434' ORDER BY l10_.titolo ASC
Parameters: ['7434']
[Display runnable query]
[
Explain query
]
|
8 |
0.78 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 = '11186' ORDER BY l10_.titolo ASC
Parameters: ['11186']
[Display runnable query]
[
Explain query
]
|
9 |
0.76 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 = '10994' ORDER BY l10_.titolo ASC
Parameters: ['10994']
[Display runnable query]
[
Explain query
]
|
10 |
0.71 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 = '14893' ORDER BY l10_.titolo ASC
Parameters: ['14893']
[Display runnable query]
[
Explain query
]
|
11 |
0.87 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 = '14968' ORDER BY l10_.titolo ASC
Parameters: ['14968']
[Display runnable query]
[
Explain query
]
|
12 |
0.89 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 = '13743' ORDER BY l10_.titolo ASC
Parameters: ['13743']
[Display runnable query]
[
Explain query
]
|
13 |
0.87 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 = '10920' ORDER BY l10_.titolo ASC
Parameters: ['10920']
[Display runnable query]
[
Explain query
]
|
14 |
0.88 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 = '11185' ORDER BY l10_.titolo ASC
Parameters: ['11185']
[Display runnable query]
[
Explain query
]
|
15 |
0.86 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 = '12385' ORDER BY l10_.titolo ASC
Parameters: ['12385']
[Display runnable query]
[
Explain query
]
|
16 |
0.86 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 = '3164' ORDER BY l10_.titolo ASC
Parameters: ['3164']
[Display runnable query]
[
Explain query
]
|
17 |
0.85 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 = '14057' ORDER BY l10_.titolo ASC
Parameters: ['14057']
[Display runnable query]
[
Explain query
]
|
18 |
1.08 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 = '11189' ORDER BY l10_.titolo ASC
Parameters: ['11189']
[Display runnable query]
[
Explain query
]
|
19 |
1.11 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 = '13638' ORDER BY l10_.titolo ASC
Parameters: ['13638']
[Display runnable query]
[
Explain query
]
|
20 |
1.18 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 = '13773' ORDER BY l10_.titolo ASC
Parameters: ['13773']
[Display runnable query]
[
Explain query
]
|
21 |
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 = '12380' ORDER BY l10_.titolo ASC
Parameters: ['12380']
[Display runnable query]
[
Explain query
]
|
22 |
1.11 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 = '14448' ORDER BY l10_.titolo ASC
Parameters: ['14448']
[Display runnable query]
[
Explain query
]
|
23 |
0.80 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 = ?
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 = 'organizzazione-matrimonio'
Parameters: [organizzazione-matrimonio]
[Display runnable query]
[
Explain query
]
|
24 |
0.87 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
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 = 1 ORDER BY l0_.titolo ASC
Parameters: [1]
[Display runnable query]
[
Explain query
]
|
25 |
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
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 = 1 ORDER BY l0_.titolo ASC
Parameters: [1]
[Display runnable query]
[
Explain query
]
|
26 |
0.73 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
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
]
|
27 |
12.62 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
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 = 10480) AND ((l8_.id = 10480) OR (l6_.id = 10480 AND l1_.premium = 1)) GROUP BY l0_.id ORDER BY l0_.titolo ASC
Parameters: [10480, 10480, 10480]
[Display runnable query]
[
Explain query
]
|
28 |
3.88 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_geo l0_ INNER [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.url 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_geo l2_ ON l0_.provincia_id = l2_.id
AND (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
AND (
l1_.pubblico = 1
AND (
l1_.premium = 1
OR (l1_.recapito_id = l3_.id)
)
)
WHERE
l0_.pubblico = 1
GROUP BY
l0_.id
ORDER BY
l0_.url 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_geo l2_ ON l0_.provincia_id = l2_.id AND (l2_.id = 10480) INNER JOIN lmn_vetrina_recapito l3_ ON l0_.id = l3_.geo_id INNER JOIN lmn_vetrina l1_ ON l3_.vetrina_id = l1_.id AND (l1_.pubblico = 1 AND (l1_.premium = 1 OR (l1_.recapito_id = l3_.id))) WHERE l0_.pubblico = 1 GROUP BY l0_.id ORDER BY l0_.url ASC
Parameters: [10480]
[Display runnable query]
[
Explain query
]
|
29 |
0.78 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_geo_limitrofi [...] WHERE l1_.geo_id = ? ORDER BY l1_.distanza ASC
SELECT
l0_.id AS id_0,
l0_.url AS url_1,
l0_.titolo AS titolo_2,
l1_.distanza AS distanza_3
FROM
lmn_geo_limitrofi l1_
INNER JOIN lmn_geo l0_ ON l1_.geo_limitrofo_id = l0_.id
WHERE
l1_.geo_id = ?
ORDER BY
l1_.distanza ASC
SELECT l0_.id AS id_0, l0_.url AS url_1, l0_.titolo AS titolo_2, l1_.distanza AS distanza_3 FROM lmn_geo_limitrofi l1_ INNER JOIN lmn_geo l0_ ON l1_.geo_limitrofo_id = l0_.id WHERE l1_.geo_id = 10480 ORDER BY l1_.distanza ASC
Parameters: [10480]
[Display runnable query]
[
Explain query
]
|
30 |
6.23 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
SELECT count(l0_.id) AS sclr_0 FROM lmn_vetrina l0_ WHERE l0_.pubblico = 1
Parameters: { }
[Display runnable query]
[
Explain query
]
|
31 |
50.86 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
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
]
|
32 |
62.75 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 = 'id_provincia'
AND w3_.meta_value = ?
)
WHERE
w0_.post_status = ?
ORDER BY
w0_.post_date DESC
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 = 'id_provincia' AND w3_.meta_value = 10480) WHERE w0_.post_status = 'publish' ORDER BY w0_.post_date DESC LIMIT 1
Parameters: [10480, publish]
[Display runnable query]
[
Explain query
]
|
33 |
64.43 ms |
Shrink query
SELECT w0_.ID AS [...] FROM lmn_geo l4_ [...] WHERE w0_.post_statu [...] ORDER BY w1_.meta_value [...] LIMIT 3 OFFSET 0
SELECT
w0_.ID AS ID_0,
w0_.post_name AS post_name_1,
w0_.post_title AS post_title_2,
w0_.post_content AS post_content_3,
w0_.post_excerpt AS post_excerpt_4,
w0_.post_date AS post_date_5,
w1_.meta_value AS meta_value_6,
w2_.meta_value AS meta_value_7,
w3_.meta_value AS meta_value_8,
l4_.titolo AS titolo_9,
l4_.slug AS slug_10
FROM
lmn_geo l4_
INNER JOIN lmn_geo l5_ ON l4_.regione_id = l5_.id,
wp_posts w0_
INNER JOIN wp_postmeta w1_ ON w0_.ID = w1_.post_id
INNER JOIN wp_postmeta w2_ ON w0_.ID = w2_.post_id
INNER JOIN wp_postmeta w3_ ON w0_.ID = w3_.post_id
WHERE
w0_.post_status = 'publish'
AND w1_.meta_key = 'data_inizio_evento'
AND w2_.meta_key = 'data_fine_evento'
AND w3_.meta_key = 'id_provincia_evento'
AND w3_.meta_value = l4_.id
AND l5_.url = ?
AND l5_.tipo = 2
ORDER BY
w1_.meta_value DESC
LIMIT
3 OFFSET 0
SELECT w0_.ID AS ID_0, w0_.post_name AS post_name_1, w0_.post_title AS post_title_2, w0_.post_content AS post_content_3, w0_.post_excerpt AS post_excerpt_4, w0_.post_date AS post_date_5, w1_.meta_value AS meta_value_6, w2_.meta_value AS meta_value_7, w3_.meta_value AS meta_value_8, l4_.titolo AS titolo_9, l4_.slug AS slug_10 FROM lmn_geo l4_ INNER JOIN lmn_geo l5_ ON l4_.regione_id = l5_.id, wp_posts w0_ INNER JOIN wp_postmeta w1_ ON w0_.ID = w1_.post_id INNER JOIN wp_postmeta w2_ ON w0_.ID = w2_.post_id INNER JOIN wp_postmeta w3_ ON w0_.ID = w3_.post_id WHERE w0_.post_status = 'publish' AND w1_.meta_key = 'data_inizio_evento' AND w2_.meta_key = 'data_fine_evento' AND w3_.meta_key = 'id_provincia_evento' AND w3_.meta_value = l4_.id AND l5_.url = 'emilia-romagna' AND l5_.tipo = 2 ORDER BY w1_.meta_value DESC LIMIT 3 OFFSET 0
Parameters: [emilia-romagna]
[Display runnable query]
[
Explain query
]
|
34 |
11.41 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
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
]
|
35 |
1.44 ms |
Shrink query
SELECT DISTINCT [...] FROM lmn_vetrina [...] WHERE l0_.pubblico = [...] ORDER BY l0_.id DESC LIMIT 6
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 l4_.id = ?
ORDER BY
l0_.id DESC
LIMIT
6
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 l4_.id = 10480 ORDER BY l0_.id DESC LIMIT 6
Parameters: [10480]
[Display runnable query]
[
Explain query
]
|
36 |
1.13 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 = '14765' ORDER BY l10_.titolo ASC
Parameters: ['14765']
[Display runnable query]
[
Explain query
]
|
37 |
1.02 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 = '14750' ORDER BY l10_.titolo ASC
Parameters: ['14750']
[Display runnable query]
[
Explain query
]
|
38 |
0.97 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 = '14599' ORDER BY l10_.titolo ASC
Parameters: ['14599']
[Display runnable query]
[
Explain query
]
|
39 |
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 = '14525' ORDER BY l10_.titolo ASC
Parameters: ['14525']
[Display runnable query]
[
Explain query
]
|