| 1 |
1.32 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.slug AS [...] FROM lmn_categoriageo l0_ LEFT [...] WHERE l2_.slug = ? AND l1_.slug = [...]
SELECT
l0_.id AS id_0,
l0_.slug AS slug_1,
l0_.pubblico AS pubblico_2,
l0_.titolo AS titolo_3,
l0_.h1 AS h1_4,
l0_.h2 AS h2_5,
l0_.meta_title AS meta_title_6,
l0_.meta_keyword AS meta_keyword_7,
l0_.meta_description AS meta_description_8,
l0_.descrizione AS descrizione_9,
l0_.testo AS testo_10,
l0_.created_at AS created_at_11,
l0_.updated_at AS updated_at_12,
l1_.id AS id_13,
l1_.old_id AS old_id_14,
l1_.limitrofi AS limitrofi_15,
l1_.lft AS lft_16,
l1_.lvl AS lvl_17,
l1_.rgt AS rgt_18,
l1_.root AS root_19,
l1_.slug AS slug_20,
l1_.pubblico AS pubblico_21,
l1_.titolo AS titolo_22,
l1_.h1 AS h1_23,
l1_.h2 AS h2_24,
l1_.meta_title AS meta_title_25,
l1_.meta_keyword AS meta_keyword_26,
l1_.meta_description AS meta_description_27,
l1_.descrizione AS descrizione_28,
l1_.testo AS testo_29,
l1_.created_at AS created_at_30,
l1_.updated_at AS updated_at_31,
l2_.id AS id_32,
l2_.tipo AS tipo_33,
l2_.lat AS lat_34,
l2_.lon AS lon_35,
l2_.old_id AS old_id_36,
l2_.url AS url_37,
l2_.main AS main_38,
l2_.slug AS slug_39,
l2_.pubblico AS pubblico_40,
l2_.titolo AS titolo_41,
l2_.h1 AS h1_42,
l2_.h2 AS h2_43,
l2_.meta_title AS meta_title_44,
l2_.meta_keyword AS meta_keyword_45,
l2_.meta_description AS meta_description_46,
l2_.descrizione AS descrizione_47,
l2_.testo AS testo_48,
l2_.created_at AS created_at_49,
l2_.updated_at AS updated_at_50,
l0_.geo_id AS geo_id_51,
l0_.categoria_id AS categoria_id_52,
l0_.copertina_id AS copertina_id_53,
l1_.padre_id AS padre_id_54,
l1_.copertina_id AS copertina_id_55,
l2_.regione_id AS regione_id_56,
l2_.provincia_id AS provincia_id_57,
l2_.copertina_id AS copertina_id_58
FROM
lmn_categoriageo l0_
LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id
LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id
LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id
WHERE
l2_.slug = ?
AND l1_.slug = ?
SELECT l0_.id AS id_0, l0_.slug AS slug_1, l0_.pubblico AS pubblico_2, l0_.titolo AS titolo_3, l0_.h1 AS h1_4, l0_.h2 AS h2_5, l0_.meta_title AS meta_title_6, l0_.meta_keyword AS meta_keyword_7, l0_.meta_description AS meta_description_8, l0_.descrizione AS descrizione_9, l0_.testo AS testo_10, l0_.created_at AS created_at_11, l0_.updated_at AS updated_at_12, l1_.id AS id_13, l1_.old_id AS old_id_14, l1_.limitrofi AS limitrofi_15, l1_.lft AS lft_16, l1_.lvl AS lvl_17, l1_.rgt AS rgt_18, l1_.root AS root_19, l1_.slug AS slug_20, l1_.pubblico AS pubblico_21, l1_.titolo AS titolo_22, l1_.h1 AS h1_23, l1_.h2 AS h2_24, l1_.meta_title AS meta_title_25, l1_.meta_keyword AS meta_keyword_26, l1_.meta_description AS meta_description_27, l1_.descrizione AS descrizione_28, l1_.testo AS testo_29, l1_.created_at AS created_at_30, l1_.updated_at AS updated_at_31, l2_.id AS id_32, l2_.tipo AS tipo_33, l2_.lat AS lat_34, l2_.lon AS lon_35, l2_.old_id AS old_id_36, l2_.url AS url_37, l2_.main AS main_38, l2_.slug AS slug_39, l2_.pubblico AS pubblico_40, l2_.titolo AS titolo_41, l2_.h1 AS h1_42, l2_.h2 AS h2_43, l2_.meta_title AS meta_title_44, l2_.meta_keyword AS meta_keyword_45, l2_.meta_description AS meta_description_46, l2_.descrizione AS descrizione_47, l2_.testo AS testo_48, l2_.created_at AS created_at_49, l2_.updated_at AS updated_at_50, l0_.geo_id AS geo_id_51, l0_.categoria_id AS categoria_id_52, l0_.copertina_id AS copertina_id_53, l1_.padre_id AS padre_id_54, l1_.copertina_id AS copertina_id_55, l2_.regione_id AS regione_id_56, l2_.provincia_id AS provincia_id_57, l2_.copertina_id AS copertina_id_58 FROM lmn_categoriageo l0_ LEFT JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id LEFT JOIN lmn_categoria l3_ ON l1_.padre_id = l3_.id LEFT JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id WHERE l2_.slug = 'provincia_ragusa' AND l1_.slug = 'wedding_planner'
Parameters: [provincia_ragusa, wedding_planner]
[Display runnable query]
[
Explain query
]
|
| 2 |
0.65 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.tipo AS [...] FROM lmn_geo l0_ LEFT JOIN [...] WHERE l0_.slug = ?
SELECT
l0_.id AS id_0,
l0_.tipo AS tipo_1,
l0_.lat AS lat_2,
l0_.lon AS lon_3,
l0_.old_id AS old_id_4,
l0_.url AS url_5,
l0_.main AS main_6,
l0_.slug AS slug_7,
l0_.pubblico AS pubblico_8,
l0_.titolo AS titolo_9,
l0_.h1 AS h1_10,
l0_.h2 AS h2_11,
l0_.meta_title AS meta_title_12,
l0_.meta_keyword AS meta_keyword_13,
l0_.meta_description AS meta_description_14,
l0_.descrizione AS descrizione_15,
l0_.testo AS testo_16,
l0_.created_at AS created_at_17,
l0_.updated_at AS updated_at_18,
l1_.id AS id_19,
l1_.tipo AS tipo_20,
l1_.lat AS lat_21,
l1_.lon AS lon_22,
l1_.old_id AS old_id_23,
l1_.url AS url_24,
l1_.main AS main_25,
l1_.slug AS slug_26,
l1_.pubblico AS pubblico_27,
l1_.titolo AS titolo_28,
l1_.h1 AS h1_29,
l1_.h2 AS h2_30,
l1_.meta_title AS meta_title_31,
l1_.meta_keyword AS meta_keyword_32,
l1_.meta_description AS meta_description_33,
l1_.descrizione AS descrizione_34,
l1_.testo AS testo_35,
l1_.created_at AS created_at_36,
l1_.updated_at AS updated_at_37,
l2_.id AS id_38,
l2_.tipo AS tipo_39,
l2_.lat AS lat_40,
l2_.lon AS lon_41,
l2_.old_id AS old_id_42,
l2_.url AS url_43,
l2_.main AS main_44,
l2_.slug AS slug_45,
l2_.pubblico AS pubblico_46,
l2_.titolo AS titolo_47,
l2_.h1 AS h1_48,
l2_.h2 AS h2_49,
l2_.meta_title AS meta_title_50,
l2_.meta_keyword AS meta_keyword_51,
l2_.meta_description AS meta_description_52,
l2_.descrizione AS descrizione_53,
l2_.testo AS testo_54,
l2_.created_at AS created_at_55,
l2_.updated_at AS updated_at_56,
l0_.regione_id AS regione_id_57,
l0_.provincia_id AS provincia_id_58,
l0_.copertina_id AS copertina_id_59,
l1_.regione_id AS regione_id_60,
l1_.provincia_id AS provincia_id_61,
l1_.copertina_id AS copertina_id_62,
l2_.regione_id AS regione_id_63,
l2_.provincia_id AS provincia_id_64,
l2_.copertina_id AS copertina_id_65
FROM
lmn_geo l0_
LEFT JOIN lmn_geo l1_ ON l0_.provincia_id = l1_.id
LEFT JOIN lmn_geo l2_ ON l0_.regione_id = l2_.id
WHERE
l0_.slug = ?
SELECT l0_.id AS id_0, l0_.tipo AS tipo_1, l0_.lat AS lat_2, l0_.lon AS lon_3, l0_.old_id AS old_id_4, l0_.url AS url_5, l0_.main AS main_6, l0_.slug AS slug_7, l0_.pubblico AS pubblico_8, l0_.titolo AS titolo_9, l0_.h1 AS h1_10, l0_.h2 AS h2_11, l0_.meta_title AS meta_title_12, l0_.meta_keyword AS meta_keyword_13, l0_.meta_description AS meta_description_14, l0_.descrizione AS descrizione_15, l0_.testo AS testo_16, l0_.created_at AS created_at_17, l0_.updated_at AS updated_at_18, l1_.id AS id_19, l1_.tipo AS tipo_20, l1_.lat AS lat_21, l1_.lon AS lon_22, l1_.old_id AS old_id_23, l1_.url AS url_24, l1_.main AS main_25, l1_.slug AS slug_26, l1_.pubblico AS pubblico_27, l1_.titolo AS titolo_28, l1_.h1 AS h1_29, l1_.h2 AS h2_30, l1_.meta_title AS meta_title_31, l1_.meta_keyword AS meta_keyword_32, l1_.meta_description AS meta_description_33, l1_.descrizione AS descrizione_34, l1_.testo AS testo_35, l1_.created_at AS created_at_36, l1_.updated_at AS updated_at_37, l2_.id AS id_38, l2_.tipo AS tipo_39, l2_.lat AS lat_40, l2_.lon AS lon_41, l2_.old_id AS old_id_42, l2_.url AS url_43, l2_.main AS main_44, l2_.slug AS slug_45, l2_.pubblico AS pubblico_46, l2_.titolo AS titolo_47, l2_.h1 AS h1_48, l2_.h2 AS h2_49, l2_.meta_title AS meta_title_50, l2_.meta_keyword AS meta_keyword_51, l2_.meta_description AS meta_description_52, l2_.descrizione AS descrizione_53, l2_.testo AS testo_54, l2_.created_at AS created_at_55, l2_.updated_at AS updated_at_56, l0_.regione_id AS regione_id_57, l0_.provincia_id AS provincia_id_58, l0_.copertina_id AS copertina_id_59, l1_.regione_id AS regione_id_60, l1_.provincia_id AS provincia_id_61, l1_.copertina_id AS copertina_id_62, l2_.regione_id AS regione_id_63, l2_.provincia_id AS provincia_id_64, l2_.copertina_id AS copertina_id_65 FROM lmn_geo l0_ LEFT JOIN lmn_geo l1_ ON l0_.provincia_id = l1_.id LEFT JOIN lmn_geo l2_ ON l0_.regione_id = l2_.id WHERE l0_.slug = 'comune_ragusa'
Parameters: [comune_ragusa]
[Display runnable query]
[
Explain query
]
|
| 3 |
1.01 ms |
Shrink query
SELECT DISTINCT (l0_.id) [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l4_.posizione ASC
SELECT
DISTINCT (l0_.id) AS sclr_0
FROM
lmn_vetrina l0_
INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id
INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id
LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id
INNER JOIN lmn_vetrina_top l4_ ON l0_.id = l4_.vetrina_id
INNER JOIN lmn_categoria_geo_topposition_rel l6_ ON l4_.id = l6_.vetrinatop_id
INNER JOIN lmn_categoriageo l5_ ON l5_.id = l6_.categoriageo_id
INNER JOIN lmn_categoria l7_ ON l5_.categoria_id = l7_.id
INNER JOIN lmn_geo l8_ ON l5_.geo_id = l8_.id
WHERE
l0_.pubblico = 1
AND l4_.data_inizio <= ?
AND l4_.data_fine >= ?
AND l7_.id = ?
AND l8_.id = ?
ORDER BY
l4_.posizione ASC
SELECT DISTINCT (l0_.id) AS sclr_0 FROM lmn_vetrina l0_ INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id INNER JOIN lmn_vetrina_top l4_ ON l0_.id = l4_.vetrina_id INNER JOIN lmn_categoria_geo_topposition_rel l6_ ON l4_.id = l6_.vetrinatop_id INNER JOIN lmn_categoriageo l5_ ON l5_.id = l6_.categoriageo_id INNER JOIN lmn_categoria l7_ ON l5_.categoria_id = l7_.id INNER JOIN lmn_geo l8_ ON l5_.geo_id = l8_.id WHERE l0_.pubblico = 1 AND l4_.data_inizio <= '2025-04-04 00:00:00' AND l4_.data_fine >= '2025-04-04 00:00:00' AND l7_.id = 16 AND l8_.id = 12350 ORDER BY l4_.posizione ASC
Parameters: ['2025-04-04 00:00:00', '2025-04-04 00:00:00', 16, 12350]
[Display runnable query]
[
Explain query
]
|
| 4 |
1.13 ms |
Shrink query
SELECT DISTINCT l0_.id AS [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC
SELECT
DISTINCT l0_.id AS id_0
FROM
lmn_vetrina l0_
INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id
INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id
INNER JOIN lmn_vetrina_recapito l3_ ON l0_.id = l3_.vetrina_id
INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id
INNER JOIN lmn_premiums_vetrina l5_ ON l0_.listing_id = l5_.id
AND (
l5_.attivo = 1
AND (
? BETWEEN l5_.data_start
AND l5_.data_end
)
)
WHERE
l0_.pubblico = 1
AND l1_.id = ?
AND l4_.id = ?
ORDER BY
l0_.id DESC
SELECT DISTINCT l0_.id AS id_0 FROM lmn_vetrina l0_ INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id INNER JOIN lmn_vetrina_recapito l3_ ON l0_.id = l3_.vetrina_id INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id INNER JOIN lmn_premiums_vetrina l5_ ON l0_.listing_id = l5_.id AND (l5_.attivo = 1 AND ('2025-04-04 09:29:42' BETWEEN l5_.data_start AND l5_.data_end)) WHERE l0_.pubblico = 1 AND l1_.id = 16 AND l4_.id = 12351 ORDER BY l0_.id DESC
Parameters: ['2025-04-04 09:29:42', 16, 12351]
[Display runnable query]
[
Explain query
]
|
| 5 |
1.00 ms |
Shrink query
SELECT DISTINCT l0_.id AS [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC
SELECT
DISTINCT l0_.id AS id_0
FROM
lmn_vetrina l0_
INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id
INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id
INNER JOIN lmn_vetrina_recapito l3_ ON l0_.recapito_id = l3_.id
INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id
WHERE
l0_.pubblico = 1
AND l0_.listing_id IS NULL
AND l1_.id = ?
AND l4_.id = ?
AND l0_.updated_at > ?
ORDER BY
l0_.id DESC
SELECT DISTINCT l0_.id AS id_0 FROM lmn_vetrina l0_ INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id INNER JOIN lmn_vetrina_recapito l3_ ON l0_.recapito_id = l3_.id INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id WHERE l0_.pubblico = 1 AND l0_.listing_id IS NULL AND l1_.id = 16 AND l4_.id = 12351 AND l0_.updated_at > '2014-02-01 00:00:00' ORDER BY l0_.id DESC
Parameters: [16, 12351, '2014-02-01 00:00:00']
[Display runnable query]
[
Explain query
]
|
| 6 |
0.87 ms |
Shrink query
SELECT DISTINCT l0_.id AS [...] FROM lmn_vetrina l0_ [...] WHERE l0_.pubblico = 1 [...] ORDER BY l0_.id DESC
SELECT
DISTINCT l0_.id AS id_0
FROM
lmn_vetrina l0_
INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id
INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id
INNER JOIN lmn_vetrina_recapito l3_ ON l0_.recapito_id = l3_.id
INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id
WHERE
l0_.pubblico = 1
AND l0_.listing_id IS NULL
AND l1_.id = ?
AND l4_.id = ?
AND l0_.updated_at < ?
ORDER BY
l0_.id DESC
SELECT DISTINCT l0_.id AS id_0 FROM lmn_vetrina l0_ INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id INNER JOIN lmn_vetrina_recapito l3_ ON l0_.recapito_id = l3_.id INNER JOIN lmn_geo l4_ ON l3_.geo_id = l4_.id WHERE l0_.pubblico = 1 AND l0_.listing_id IS NULL AND l1_.id = 16 AND l4_.id = 12351 AND l0_.updated_at < '2014-02-01 00:00:00' ORDER BY l0_.id DESC
Parameters: [16, 12351, '2014-02-01 00:00:00']
[Display runnable query]
[
Explain query
]
|
| 7 |
1.33 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 = 2312 ORDER BY l10_.titolo ASC
Parameters: [2312]
[Display runnable query]
[
Explain query
]
|
| 8 |
1.38 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 = 1207 ORDER BY l10_.titolo ASC
Parameters: [1207]
[Display runnable query]
[
Explain query
]
|
| 9 |
1.36 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 = 7462 ORDER BY l10_.titolo ASC
Parameters: [7462]
[Display runnable query]
[
Explain query
]
|
Search
Admin