| 1 |
0.99 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_tag l0_ INNER JOIN [...] WHERE l0_.slug = ?
SELECT
l0_.id AS id_0,
l0_.posizione AS posizione_1,
l0_.livello_menu AS livello_menu_2,
l0_.home AS home_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,
l1_.id AS id_16,
l1_.slug AS slug_17,
l0_.categoriaTag_id AS categoriaTag_id_18,
l0_.vetrina_id AS vetrina_id_19,
l0_.categoria_id AS categoria_id_20,
l0_.categoriaOM_id AS categoriaOM_id_21,
l0_.copertina_id AS copertina_id_22
FROM
lmn_tag l0_
INNER JOIN lmn_tag_categoria l1_ ON l0_.categoriaTag_id = l1_.id
WHERE
l0_.slug = ?
SELECT l0_.id AS id_0, l0_.posizione AS posizione_1, l0_.livello_menu AS livello_menu_2, l0_.home AS home_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, l1_.id AS id_16, l1_.slug AS slug_17, l0_.categoriaTag_id AS categoriaTag_id_18, l0_.vetrina_id AS vetrina_id_19, l0_.categoria_id AS categoria_id_20, l0_.categoriaOM_id AS categoriaOM_id_21, l0_.copertina_id AS copertina_id_22 FROM lmn_tag l0_ INNER JOIN lmn_tag_categoria l1_ ON l0_.categoriaTag_id = l1_.id WHERE l0_.slug = 'matrimonio-in-bianco'
Parameters: [matrimonio-in-bianco]
[Display runnable query]
[
Explain query
]
|
| 2 |
0.68 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_gallery l0_ WHERE l0_.slug = ?
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_.slug = ?
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_.slug = 'torte-nuziali-foto'
Parameters: [torte-nuziali-foto]
[Display runnable query]
[
Explain query
]
|
| 3 |
5.11 ms |
Shrink query
SELECT l0_.id AS id_0 FROM lmn_media_foto l0_ INNER [...] WHERE l1_.premium = ? AND l3_.id = [...]
SELECT
l0_.id AS id_0
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id
INNER JOIN lmn_tag_immagine_rel l4_ ON l0_.id = l4_.mediafoto_id
INNER JOIN lmn_tag l3_ ON l3_.id = l4_.tag_id
WHERE
l1_.premium = ?
AND l3_.id = ?
SELECT l0_.id AS id_0 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id INNER JOIN lmn_tag_immagine_rel l4_ ON l0_.id = l4_.mediafoto_id INNER JOIN lmn_tag l3_ ON l3_.id = l4_.tag_id WHERE l1_.premium = 1 AND l3_.id = 36
Parameters: [1, 36]
[Display runnable query]
[
Explain query
]
|
| 4 |
7.46 ms |
Shrink query
SELECT l0_.id AS id_0 FROM lmn_media_foto l0_ INNER [...] WHERE l1_.premium = ? AND l3_.id = [...]
SELECT
l0_.id AS id_0
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id
INNER JOIN lmn_tag_immagine_rel l4_ ON l0_.id = l4_.mediafoto_id
INNER JOIN lmn_tag l3_ ON l3_.id = l4_.tag_id
WHERE
l1_.premium = ?
AND l3_.id = ?
SELECT l0_.id AS id_0 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id INNER JOIN lmn_tag_immagine_rel l4_ ON l0_.id = l4_.mediafoto_id INNER JOIN lmn_tag l3_ ON l3_.id = l4_.tag_id WHERE l1_.premium = 0 AND l3_.id = 36
Parameters: [0, 36]
[Display runnable query]
[
Explain query
]
|