| 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
]
|
| 5 |
1.01 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
]
|
| 6 |
0.31 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
]
|
| 7 |
1.05 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 = 6 ORDER BY l0_.livello_menu ASC, l0_.posizione ASC
Parameters: [6]
[Display runnable query]
[
Explain query
]
|
| 8 |
0.36 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 = 6 ORDER BY l0_.livello_menu ASC
Parameters: [6]
[Display runnable query]
[
Explain query
]
|
| 9 |
0.26 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 = 73 AND l0_.premium = 1
Parameters: [73]
[Display runnable query]
[
Explain query
]
|
| 10 |
0.22 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 = 74 AND l0_.premium = 1
Parameters: [74]
[Display runnable query]
[
Explain query
]
|
| 11 |
0.20 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 = 75 AND l0_.premium = 1
Parameters: [75]
[Display runnable query]
[
Explain query
]
|
| 12 |
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 = 76 AND l0_.premium = 1
Parameters: [76]
[Display runnable query]
[
Explain query
]
|
| 13 |
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 = 77 AND l0_.premium = 1
Parameters: [77]
[Display runnable query]
[
Explain query
]
|
| 14 |
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 = 78 AND l0_.premium = 1
Parameters: [78]
[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 = 79 AND l0_.premium = 1
Parameters: [79]
[Display runnable query]
[
Explain query
]
|
| 16 |
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 = 80 AND l0_.premium = 1
Parameters: [80]
[Display runnable query]
[
Explain query
]
|
| 17 |
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 = 81 AND l0_.premium = 1
Parameters: [81]
[Display runnable query]
[
Explain query
]
|
| 18 |
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 = 82 AND l0_.premium = 1
Parameters: [82]
[Display runnable query]
[
Explain query
]
|
| 19 |
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 = 83 AND l0_.premium = 1
Parameters: [83]
[Display runnable query]
[
Explain query
]
|
| 20 |
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 = 84 AND l0_.premium = 1
Parameters: [84]
[Display runnable query]
[
Explain query
]
|
| 21 |
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 = 85 AND l0_.premium = 1
Parameters: [85]
[Display runnable query]
[
Explain query
]
|
| 22 |
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 = 86 AND l0_.premium = 1
Parameters: [86]
[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.88 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.98 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.71 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 |
0.82 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
]
|
| 28 |
0.39 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
]
|
| 29 |
1.02 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 7711
Parameters: [7711]
[Display runnable query]
[
Explain query
]
|
| 30 |
0.88 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 26259
Parameters: [26259]
[Display runnable query]
[
Explain query
]
|
| 31 |
0.85 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 74477
Parameters: [74477]
[Display runnable query]
[
Explain query
]
|
| 32 |
0.84 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 31671
Parameters: [31671]
[Display runnable query]
[
Explain query
]
|
| 33 |
0.85 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 93941
Parameters: [93941]
[Display runnable query]
[
Explain query
]
|
| 34 |
0.86 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 24722
Parameters: [24722]
[Display runnable query]
[
Explain query
]
|
| 35 |
0.86 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 44691
Parameters: [44691]
[Display runnable query]
[
Explain query
]
|
| 36 |
0.86 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 7583
Parameters: [7583]
[Display runnable query]
[
Explain query
]
|
| 37 |
0.84 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 22661
Parameters: [22661]
[Display runnable query]
[
Explain query
]
|
| 38 |
0.82 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 26901
Parameters: [26901]
[Display runnable query]
[
Explain query
]
|
| 39 |
0.83 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 27813
Parameters: [27813]
[Display runnable query]
[
Explain query
]
|
| 40 |
0.84 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 4688
Parameters: [4688]
[Display runnable query]
[
Explain query
]
|
| 41 |
0.86 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 12264
Parameters: [12264]
[Display runnable query]
[
Explain query
]
|
| 42 |
0.78 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 31229
Parameters: [31229]
[Display runnable query]
[
Explain query
]
|
| 43 |
0.78 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_media_foto l0_ INNER [...] WHERE l0_.id = ?
SELECT
l0_.id AS id_0,
l0_.pubblico AS pubblico_1,
l0_.height AS height_2,
l0_.width AS width_3,
l0_.mime AS mime_4,
l0_.size AS size_5,
l0_.created_at AS created_at_6,
l0_.updated_at AS updated_at_7,
l0_.titolo AS titolo_8,
l0_.name AS name_9,
l0_.path AS path_10,
l0_.old_id AS old_id_11,
l0_.posizione AS posizione_12,
l1_.id AS id_13,
l1_.created_by AS created_by_14,
l1_.updated_by AS updated_by_15,
l1_.url_scheda AS url_scheda_16,
l1_.stato AS stato_17,
l1_.email AS email_18,
l1_.premium AS premium_19,
l1_.testo AS testo_20,
l1_.info_recapito AS info_recapito_21,
l1_.fattura AS fattura_22,
l1_.edit AS edit_23,
l1_.website AS website_24,
l1_.data_attivazione AS data_attivazione_25,
l1_.stat_user AS stat_user_26,
l1_.stat_pwd AS stat_pwd_27,
l1_.preview AS preview_28,
l1_.nuovo AS nuovo_29,
l1_.no_rinnovo AS no_rinnovo_30,
l1_.ritardo_pagamento AS ritardo_pagamento_31,
l1_.data_pubblicazione AS data_pubblicazione_32,
l1_.scadenza AS scadenza_33,
l1_.link_scambio AS link_scambio_34,
l1_.link_url AS link_url_35,
l1_.link_checked AS link_checked_36,
l1_.vetrina_tipo_id AS vetrina_tipo_id_37,
l1_.data_conferma AS data_conferma_38,
l1_.slug AS slug_39,
l1_.pubblico AS pubblico_40,
l1_.titolo AS titolo_41,
l1_.h1 AS h1_42,
l1_.h2 AS h2_43,
l1_.meta_title AS meta_title_44,
l1_.meta_keyword AS meta_keyword_45,
l1_.meta_description AS meta_description_46,
l1_.descrizione AS descrizione_47,
l1_.created_at AS created_at_48,
l1_.updated_at AS updated_at_49,
l2_.id AS id_50,
l2_.old_id AS old_id_51,
l2_.limitrofi AS limitrofi_52,
l2_.lft AS lft_53,
l2_.lvl AS lvl_54,
l2_.rgt AS rgt_55,
l2_.root AS root_56,
l2_.slug AS slug_57,
l2_.pubblico AS pubblico_58,
l2_.titolo AS titolo_59,
l2_.h1 AS h1_60,
l2_.h2 AS h2_61,
l2_.meta_title AS meta_title_62,
l2_.meta_keyword AS meta_keyword_63,
l2_.meta_description AS meta_description_64,
l2_.descrizione AS descrizione_65,
l2_.testo AS testo_66,
l2_.created_at AS created_at_67,
l2_.updated_at AS updated_at_68
FROM
lmn_media_foto l0_
INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id
INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id
INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id
WHERE
l0_.id = ?
SELECT l0_.id AS id_0, l0_.pubblico AS pubblico_1, l0_.height AS height_2, l0_.width AS width_3, l0_.mime AS mime_4, l0_.size AS size_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.titolo AS titolo_8, l0_.name AS name_9, l0_.path AS path_10, l0_.old_id AS old_id_11, l0_.posizione AS posizione_12, l1_.id AS id_13, l1_.created_by AS created_by_14, l1_.updated_by AS updated_by_15, l1_.url_scheda AS url_scheda_16, l1_.stato AS stato_17, l1_.email AS email_18, l1_.premium AS premium_19, l1_.testo AS testo_20, l1_.info_recapito AS info_recapito_21, l1_.fattura AS fattura_22, l1_.edit AS edit_23, l1_.website AS website_24, l1_.data_attivazione AS data_attivazione_25, l1_.stat_user AS stat_user_26, l1_.stat_pwd AS stat_pwd_27, l1_.preview AS preview_28, l1_.nuovo AS nuovo_29, l1_.no_rinnovo AS no_rinnovo_30, l1_.ritardo_pagamento AS ritardo_pagamento_31, l1_.data_pubblicazione AS data_pubblicazione_32, l1_.scadenza AS scadenza_33, l1_.link_scambio AS link_scambio_34, l1_.link_url AS link_url_35, l1_.link_checked AS link_checked_36, l1_.vetrina_tipo_id AS vetrina_tipo_id_37, l1_.data_conferma AS data_conferma_38, l1_.slug AS slug_39, l1_.pubblico AS pubblico_40, l1_.titolo AS titolo_41, l1_.h1 AS h1_42, l1_.h2 AS h2_43, l1_.meta_title AS meta_title_44, l1_.meta_keyword AS meta_keyword_45, l1_.meta_description AS meta_description_46, l1_.descrizione AS descrizione_47, l1_.created_at AS created_at_48, l1_.updated_at AS updated_at_49, l2_.id AS id_50, l2_.old_id AS old_id_51, l2_.limitrofi AS limitrofi_52, l2_.lft AS lft_53, l2_.lvl AS lvl_54, l2_.rgt AS rgt_55, l2_.root AS root_56, l2_.slug AS slug_57, l2_.pubblico AS pubblico_58, l2_.titolo AS titolo_59, l2_.h1 AS h1_60, l2_.h2 AS h2_61, l2_.meta_title AS meta_title_62, l2_.meta_keyword AS meta_keyword_63, l2_.meta_description AS meta_description_64, l2_.descrizione AS descrizione_65, l2_.testo AS testo_66, l2_.created_at AS created_at_67, l2_.updated_at AS updated_at_68 FROM lmn_media_foto l0_ INNER JOIN lmn_vetrina_foto_rel l3_ ON l0_.id = l3_.mediafoto_id INNER JOIN lmn_vetrina l1_ ON l1_.id = l3_.vetrina_id INNER JOIN lmn_categoria l2_ ON l1_.categoria_id = l2_.id WHERE l0_.id = 4689
Parameters: [4689]
[Display runnable query]
[
Explain query
]
|
| 44 |
0.72 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
]
|
| 45 |
0.51 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
]
|
| 46 |
6.39 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
]
|
| 47 |
52.57 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
]
|