1 |
0.84 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 = 'unoaerre-italian-jewellery'
Parameters: [unoaerre-italian-jewellery]
[Display runnable query]
[
Explain query
]
|
2 |
0.52 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 = 'foto-fedi-nuziali'
Parameters: [foto-fedi-nuziali]
[Display runnable query]
[
Explain query
]
|
3 |
0.94 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 = 99
Parameters: [1, 99]
[Display runnable query]
[
Explain query
]
|
4 |
1.01 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 = 99
Parameters: [0, 99]
[Display runnable query]
[
Explain query
]
|
5 |
0.48 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 = 'unoaerre-italian-jewellery'
Parameters: [unoaerre-italian-jewellery]
[Display runnable query]
[
Explain query
]
|
6 |
0.30 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 = 'foto-fedi-nuziali'
Parameters: [foto-fedi-nuziali]
[Display runnable query]
[
Explain query
]
|
7 |
0.99 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_tag l0_ INNER [...] WHERE l1_.id = ? ORDER BY l0_.livello_menu [...]
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
FROM
lmn_tag l0_
INNER JOIN lmn_gallery_tags_rel l2_ ON l0_.id = l2_.tag_id
INNER JOIN lmn_gallery l1_ ON l1_.id = l2_.gallery_id
WHERE
l1_.id = ?
ORDER BY
l0_.livello_menu ASC,
l0_.posizione ASC
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 FROM lmn_tag l0_ INNER JOIN lmn_gallery_tags_rel l2_ ON l0_.id = l2_.tag_id INNER JOIN lmn_gallery l1_ ON l1_.id = l2_.gallery_id WHERE l1_.id = 7 ORDER BY l0_.livello_menu ASC, l0_.posizione ASC
Parameters: [7]
[Display runnable query]
[
Explain query
]
|
8 |
0.29 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_gallery_col_tit [...] WHERE l1_.id = ? ORDER BY l0_.livello_menu ASC
SELECT
l0_.id AS id_0,
l0_.titolo AS titolo_1,
l0_.livello_menu AS livello_menu_2
FROM
lmn_gallery_col_titles l0_
INNER JOIN lmn_gallery l1_ ON l0_.gallery_id = l1_.id
WHERE
l1_.id = ?
ORDER BY
l0_.livello_menu ASC
SELECT l0_.id AS id_0, l0_.titolo AS titolo_1, l0_.livello_menu AS livello_menu_2 FROM lmn_gallery_col_titles l0_ INNER JOIN lmn_gallery l1_ ON l0_.gallery_id = l1_.id WHERE l1_.id = 7 ORDER BY l0_.livello_menu ASC
Parameters: [7]
[Display runnable query]
[
Explain query
]
|
9 |
0.23 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 109 AND l0_.premium = 1
Parameters: [109]
[Display runnable query]
[
Explain query
]
|
10 |
0.19 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 110 AND l0_.premium = 1
Parameters: [110]
[Display runnable query]
[
Explain query
]
|
11 |
0.19 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 87 AND l0_.premium = 1
Parameters: [87]
[Display runnable query]
[
Explain query
]
|
12 |
0.18 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 88 AND l0_.premium = 1
Parameters: [88]
[Display runnable query]
[
Explain query
]
|
13 |
0.18 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 89 AND l0_.premium = 1
Parameters: [89]
[Display runnable query]
[
Explain query
]
|
14 |
0.16 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 90 AND l0_.premium = 1
Parameters: [90]
[Display runnable query]
[
Explain query
]
|
15 |
0.18 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 91 AND l0_.premium = 1
Parameters: [91]
[Display runnable query]
[
Explain query
]
|
16 |
0.17 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 92 AND l0_.premium = 1
Parameters: [92]
[Display runnable query]
[
Explain query
]
|
17 |
0.14 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 93 AND l0_.premium = 1
Parameters: [93]
[Display runnable query]
[
Explain query
]
|
18 |
0.12 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 94 AND l0_.premium = 1
Parameters: [94]
[Display runnable query]
[
Explain query
]
|
19 |
0.11 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 95 AND l0_.premium = 1
Parameters: [95]
[Display runnable query]
[
Explain query
]
|
20 |
0.11 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 96 AND l0_.premium = 1
Parameters: [96]
[Display runnable query]
[
Explain query
]
|
21 |
0.11 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 97 AND l0_.premium = 1
Parameters: [97]
[Display runnable query]
[
Explain query
]
|
22 |
0.16 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 99 AND l0_.premium = 1
Parameters: [99]
[Display runnable query]
[
Explain query
]
|
23 |
0.16 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 101 AND l0_.premium = 1
Parameters: [101]
[Display runnable query]
[
Explain query
]
|
24 |
0.13 ms |
Shrink query
SELECT l0_.id AS id_0, l0_.stato [...] FROM lmn_tag l1_ INNER JOIN [...] WHERE l1_.id = ? AND l0_.premium = [...]
SELECT
l0_.id AS id_0,
l0_.stato AS stato_1
FROM
lmn_tag l1_
INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id
WHERE
l1_.id = ?
AND l0_.premium = 1
SELECT l0_.id AS id_0, l0_.stato AS stato_1 FROM lmn_tag l1_ INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id WHERE l1_.id = 102 AND l0_.premium = 1
Parameters: [102]
[Display runnable query]
[
Explain query
]
|
25 |
0.76 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
]
|
26 |
1.19 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
]
|
27 |
0.77 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
]
|
28 |
0.55 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
]
|