1 |
1.65 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ INNER JOIN [...] WHERE l0_.url_scheda = ? AND [...]
SELECT
l0_.id AS id_0,
l0_.created_by AS created_by_1,
l0_.updated_by AS updated_by_2,
l0_.url_scheda AS url_scheda_3,
l0_.stato AS stato_4,
l0_.email AS email_5,
l0_.premium AS premium_6,
l0_.testo AS testo_7,
l0_.info_recapito AS info_recapito_8,
l0_.fattura AS fattura_9,
l0_.edit AS edit_10,
l0_.website AS website_11,
l0_.data_attivazione AS data_attivazione_12,
l0_.stat_user AS stat_user_13,
l0_.stat_pwd AS stat_pwd_14,
l0_.preview AS preview_15,
l0_.nuovo AS nuovo_16,
l0_.no_rinnovo AS no_rinnovo_17,
l0_.ritardo_pagamento AS ritardo_pagamento_18,
l0_.data_pubblicazione AS data_pubblicazione_19,
l0_.scadenza AS scadenza_20,
l0_.link_scambio AS link_scambio_21,
l0_.link_url AS link_url_22,
l0_.link_checked AS link_checked_23,
l0_.vetrina_tipo_id AS vetrina_tipo_id_24,
l0_.data_conferma AS data_conferma_25,
l0_.slug AS slug_26,
l0_.pubblico AS pubblico_27,
l0_.titolo AS titolo_28,
l0_.h1 AS h1_29,
l0_.h2 AS h2_30,
l0_.meta_title AS meta_title_31,
l0_.meta_keyword AS meta_keyword_32,
l0_.meta_description AS meta_description_33,
l0_.descrizione AS descrizione_34,
l0_.created_at AS created_at_35,
l0_.updated_at AS updated_at_36,
l1_.id AS id_37,
l1_.old_id AS old_id_38,
l1_.limitrofi AS limitrofi_39,
l1_.lft AS lft_40,
l1_.lvl AS lvl_41,
l1_.rgt AS rgt_42,
l1_.root AS root_43,
l1_.slug AS slug_44,
l1_.pubblico AS pubblico_45,
l1_.titolo AS titolo_46,
l1_.h1 AS h1_47,
l1_.h2 AS h2_48,
l1_.meta_title AS meta_title_49,
l1_.meta_keyword AS meta_keyword_50,
l1_.meta_description AS meta_description_51,
l1_.descrizione AS descrizione_52,
l1_.testo AS testo_53,
l1_.created_at AS created_at_54,
l1_.updated_at AS updated_at_55,
l2_.id AS id_56,
l2_.tipo AS tipo_57,
l2_.lat AS lat_58,
l2_.lon AS lon_59,
l2_.old_id AS old_id_60,
l2_.url AS url_61,
l2_.main AS main_62,
l2_.slug AS slug_63,
l2_.pubblico AS pubblico_64,
l2_.titolo AS titolo_65,
l2_.h1 AS h1_66,
l2_.h2 AS h2_67,
l2_.meta_title AS meta_title_68,
l2_.meta_keyword AS meta_keyword_69,
l2_.meta_description AS meta_description_70,
l2_.descrizione AS descrizione_71,
l2_.testo AS testo_72,
l2_.created_at AS created_at_73,
l2_.updated_at AS updated_at_74,
l0_.categoria_id AS categoria_id_75,
l0_.geo_id AS geo_id_76,
l0_.cliente_id AS cliente_id_77,
l0_.recapito_id AS recapito_id_78,
l0_.listing_id AS listing_id_79,
l0_.boximage_id AS boximage_id_80,
l0_.logo_id AS logo_id_81,
l0_.vetrina_tipo_id AS vetrina_tipo_id_82,
l0_.copertina_id AS copertina_id_83,
l1_.padre_id AS padre_id_84,
l1_.copertina_id AS copertina_id_85,
l2_.regione_id AS regione_id_86,
l2_.provincia_id AS provincia_id_87,
l2_.copertina_id AS copertina_id_88
FROM
lmn_vetrina l0_
INNER JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id
INNER JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id
WHERE
l0_.url_scheda = ?
AND l1_.slug = ?
SELECT l0_.id AS id_0, l0_.created_by AS created_by_1, l0_.updated_by AS updated_by_2, l0_.url_scheda AS url_scheda_3, l0_.stato AS stato_4, l0_.email AS email_5, l0_.premium AS premium_6, l0_.testo AS testo_7, l0_.info_recapito AS info_recapito_8, l0_.fattura AS fattura_9, l0_.edit AS edit_10, l0_.website AS website_11, l0_.data_attivazione AS data_attivazione_12, l0_.stat_user AS stat_user_13, l0_.stat_pwd AS stat_pwd_14, l0_.preview AS preview_15, l0_.nuovo AS nuovo_16, l0_.no_rinnovo AS no_rinnovo_17, l0_.ritardo_pagamento AS ritardo_pagamento_18, l0_.data_pubblicazione AS data_pubblicazione_19, l0_.scadenza AS scadenza_20, l0_.link_scambio AS link_scambio_21, l0_.link_url AS link_url_22, l0_.link_checked AS link_checked_23, l0_.vetrina_tipo_id AS vetrina_tipo_id_24, l0_.data_conferma AS data_conferma_25, l0_.slug AS slug_26, l0_.pubblico AS pubblico_27, l0_.titolo AS titolo_28, l0_.h1 AS h1_29, l0_.h2 AS h2_30, l0_.meta_title AS meta_title_31, l0_.meta_keyword AS meta_keyword_32, l0_.meta_description AS meta_description_33, l0_.descrizione AS descrizione_34, l0_.created_at AS created_at_35, l0_.updated_at AS updated_at_36, l1_.id AS id_37, l1_.old_id AS old_id_38, l1_.limitrofi AS limitrofi_39, l1_.lft AS lft_40, l1_.lvl AS lvl_41, l1_.rgt AS rgt_42, l1_.root AS root_43, l1_.slug AS slug_44, l1_.pubblico AS pubblico_45, l1_.titolo AS titolo_46, l1_.h1 AS h1_47, l1_.h2 AS h2_48, l1_.meta_title AS meta_title_49, l1_.meta_keyword AS meta_keyword_50, l1_.meta_description AS meta_description_51, l1_.descrizione AS descrizione_52, l1_.testo AS testo_53, l1_.created_at AS created_at_54, l1_.updated_at AS updated_at_55, l2_.id AS id_56, l2_.tipo AS tipo_57, l2_.lat AS lat_58, l2_.lon AS lon_59, l2_.old_id AS old_id_60, l2_.url AS url_61, l2_.main AS main_62, l2_.slug AS slug_63, l2_.pubblico AS pubblico_64, l2_.titolo AS titolo_65, l2_.h1 AS h1_66, l2_.h2 AS h2_67, l2_.meta_title AS meta_title_68, l2_.meta_keyword AS meta_keyword_69, l2_.meta_description AS meta_description_70, l2_.descrizione AS descrizione_71, l2_.testo AS testo_72, l2_.created_at AS created_at_73, l2_.updated_at AS updated_at_74, l0_.categoria_id AS categoria_id_75, l0_.geo_id AS geo_id_76, l0_.cliente_id AS cliente_id_77, l0_.recapito_id AS recapito_id_78, l0_.listing_id AS listing_id_79, l0_.boximage_id AS boximage_id_80, l0_.logo_id AS logo_id_81, l0_.vetrina_tipo_id AS vetrina_tipo_id_82, l0_.copertina_id AS copertina_id_83, l1_.padre_id AS padre_id_84, l1_.copertina_id AS copertina_id_85, l2_.regione_id AS regione_id_86, l2_.provincia_id AS provincia_id_87, l2_.copertina_id AS copertina_id_88 FROM lmn_vetrina l0_ INNER JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id INNER JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id WHERE l0_.url_scheda = 'foto-mary' AND l1_.slug = 'fotografie_e_video'
Parameters: [foto-mary, fotografie_e_video]
[Display runnable query]
[
Explain query
]
|
2 |
0.65 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND (? [...]
SELECT
l0_.id AS id_0,
l0_.service_id AS service_id_1,
l0_.quantity AS quantity_2,
l0_.used AS used_3,
l0_.data_start AS data_start_4,
l0_.data_end AS data_end_5,
l0_.attivo AS attivo_6,
l0_.vetrina_id AS vetrina_id_7,
l0_.orderDetail_id AS orderDetail_id_8
FROM
lmn_premiums_vetrina l0_
WHERE
l0_.vetrina_id = ?
AND (
? BETWEEN l0_.data_start
AND l0_.data_end
)
AND l0_.quantity > l0_.used
SELECT l0_.id AS id_0, l0_.service_id AS service_id_1, l0_.quantity AS quantity_2, l0_.used AS used_3, l0_.data_start AS data_start_4, l0_.data_end AS data_end_5, l0_.attivo AS attivo_6, l0_.vetrina_id AS vetrina_id_7, l0_.orderDetail_id AS orderDetail_id_8 FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = 9818 AND ('2025-04-05 15:40:30' BETWEEN l0_.data_start AND l0_.data_end) AND l0_.quantity > l0_.used
Parameters: [9818, '2025-04-05 15:40:30']
[Display runnable query]
[
Explain query
]
|
3 |
0.59 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...]
SELECT
l0_.id AS id_0,
l0_.service_id AS service_id_1,
l0_.quantity AS quantity_2,
l0_.used AS used_3,
l0_.data_start AS data_start_4,
l0_.data_end AS data_end_5,
l0_.attivo AS attivo_6,
l0_.vetrina_id AS vetrina_id_7,
l0_.orderDetail_id AS orderDetail_id_8
FROM
lmn_premiums_vetrina l0_
WHERE
l0_.vetrina_id = ?
AND l0_.attivo = ?
AND l0_.service_id = ?
AND l0_.used < l0_.quantity
AND (
? BETWEEN l0_.data_start
AND l0_.data_end
)
SELECT l0_.id AS id_0, l0_.service_id AS service_id_1, l0_.quantity AS quantity_2, l0_.used AS used_3, l0_.data_start AS data_start_4, l0_.data_end AS data_end_5, l0_.attivo AS attivo_6, l0_.vetrina_id AS vetrina_id_7, l0_.orderDetail_id AS orderDetail_id_8 FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = 9818 AND l0_.attivo = 1 AND l0_.service_id = 'vetrina_foto_limit' AND l0_.used < l0_.quantity AND ('2025-04-05 15:40:30' BETWEEN l0_.data_start AND l0_.data_end)
Parameters: [9818, 1, vetrina_foto_limit, '2025-04-05 15:40:30']
[Display runnable query]
[
Explain query
]
|
4 |
0.81 ms |
Shrink query
SELECT l0_.id AS [...] FROM lmn_media_foto [...] WHERE l1_.id = ? AND [...] ORDER BY l0_.posizione [...] LIMIT 12 OFFSET 0
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
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
WHERE
l1_.id = ?
AND l0_.pubblico = ?
ORDER BY
l0_.posizione ASC
LIMIT
12 OFFSET 0
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 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 WHERE l1_.id = 9818 AND l0_.pubblico = 1 ORDER BY l0_.posizione ASC LIMIT 12 OFFSET 0
Parameters: [9818, 1]
[Display runnable query]
[
Explain query
]
|
5 |
0.84 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...]
SELECT
l0_.id AS id_0,
l0_.service_id AS service_id_1,
l0_.quantity AS quantity_2,
l0_.used AS used_3,
l0_.data_start AS data_start_4,
l0_.data_end AS data_end_5,
l0_.attivo AS attivo_6,
l0_.vetrina_id AS vetrina_id_7,
l0_.orderDetail_id AS orderDetail_id_8
FROM
lmn_premiums_vetrina l0_
WHERE
l0_.vetrina_id = ?
AND l0_.attivo = ?
AND l0_.service_id = ?
AND l0_.used < l0_.quantity
AND (
? BETWEEN l0_.data_start
AND l0_.data_end
)
SELECT l0_.id AS id_0, l0_.service_id AS service_id_1, l0_.quantity AS quantity_2, l0_.used AS used_3, l0_.data_start AS data_start_4, l0_.data_end AS data_end_5, l0_.attivo AS attivo_6, l0_.vetrina_id AS vetrina_id_7, l0_.orderDetail_id AS orderDetail_id_8 FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = 9818 AND l0_.attivo = 1 AND l0_.service_id = 'vetrina_foto_limit' AND l0_.used < l0_.quantity AND ('2025-04-05 15:40:30' BETWEEN l0_.data_start AND l0_.data_end)
Parameters: [9818, 1, vetrina_foto_limit, '2025-04-05 15:40:30']
[Display runnable query]
[
Explain query
]
|
6 |
0.64 ms |
Shrink query
SELECT count(l0_.id) AS sclr_0 FROM lmn_media_foto l0_ INNER [...] WHERE l1_.id = ? AND l0_.pubblico [...]
SELECT
count(l0_.id) AS sclr_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
WHERE
l1_.id = ?
AND l0_.pubblico = 1
SELECT count(l0_.id) AS sclr_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 WHERE l1_.id = 9818 AND l0_.pubblico = 1
Parameters: [9818]
[Display runnable query]
[
Explain query
]
|
7 |
0.53 ms |
Shrink query
SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...]
SELECT
l0_.id AS id_0,
l0_.service_id AS service_id_1,
l0_.quantity AS quantity_2,
l0_.used AS used_3,
l0_.data_start AS data_start_4,
l0_.data_end AS data_end_5,
l0_.attivo AS attivo_6,
l0_.vetrina_id AS vetrina_id_7,
l0_.orderDetail_id AS orderDetail_id_8
FROM
lmn_premiums_vetrina l0_
WHERE
l0_.vetrina_id = ?
AND l0_.attivo = ?
AND l0_.service_id = ?
AND l0_.used < l0_.quantity
AND (
? BETWEEN l0_.data_start
AND l0_.data_end
)
SELECT l0_.id AS id_0, l0_.service_id AS service_id_1, l0_.quantity AS quantity_2, l0_.used AS used_3, l0_.data_start AS data_start_4, l0_.data_end AS data_end_5, l0_.attivo AS attivo_6, l0_.vetrina_id AS vetrina_id_7, l0_.orderDetail_id AS orderDetail_id_8 FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = 9818 AND l0_.attivo = 1 AND l0_.service_id = 'vetrina_foto_limit' AND l0_.used < l0_.quantity AND ('2025-04-05 15:40:30' BETWEEN l0_.data_start AND l0_.data_end)
Parameters: [9818, 1, vetrina_foto_limit, '2025-04-05 15:40:30']
[Display runnable query]
[
Explain query
]
|
8 |
0.62 ms |
Shrink query
SELECT t0.id AS id_1, t0.titolo AS [...] FROM lmn_vetrina_recapito t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.titolo AS titolo_2,
t0.telefono AS telefono_3,
t0.cell AS cell_4,
t0.fax AS fax_5,
t0.cap AS cap_6,
t0.suggest AS suggest_7,
t0.lat AS lat_8,
t0.lon AS lon_9,
t0.indirizzo AS indirizzo_10,
t0.testo AS testo_11,
t0.old_id AS old_id_12,
t0.geo_id AS geo_id_13,
t0.vetrina_id AS vetrina_id_14
FROM
lmn_vetrina_recapito t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.telefono AS telefono_3, t0.cell AS cell_4, t0.fax AS fax_5, t0.cap AS cap_6, t0.suggest AS suggest_7, t0.lat AS lat_8, t0.lon AS lon_9, t0.indirizzo AS indirizzo_10, t0.testo AS testo_11, t0.old_id AS old_id_12, t0.geo_id AS geo_id_13, t0.vetrina_id AS vetrina_id_14 FROM lmn_vetrina_recapito t0 WHERE t0.id = 31531
Parameters: [31531]
[Display runnable query]
[
Explain query
]
|
9 |
0.66 ms |
Shrink query
SELECT t0.id AS id_1, t0.tipo AS [...] FROM lmn_geo t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.tipo AS tipo_2,
t0.lat AS lat_3,
t0.lon AS lon_4,
t0.old_id AS old_id_5,
t0.url AS url_6,
t0.main AS main_7,
t0.slug AS slug_8,
t0.pubblico AS pubblico_9,
t0.titolo AS titolo_10,
t0.h1 AS h1_11,
t0.h2 AS h2_12,
t0.meta_title AS meta_title_13,
t0.meta_keyword AS meta_keyword_14,
t0.meta_description AS meta_description_15,
t0.descrizione AS descrizione_16,
t0.testo AS testo_17,
t0.created_at AS created_at_18,
t0.updated_at AS updated_at_19,
t0.regione_id AS regione_id_20,
t0.provincia_id AS provincia_id_21,
t0.copertina_id AS copertina_id_22
FROM
lmn_geo t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.old_id AS old_id_5, t0.url AS url_6, t0.main AS main_7, t0.slug AS slug_8, t0.pubblico AS pubblico_9, t0.titolo AS titolo_10, t0.h1 AS h1_11, t0.h2 AS h2_12, t0.meta_title AS meta_title_13, t0.meta_keyword AS meta_keyword_14, t0.meta_description AS meta_description_15, t0.descrizione AS descrizione_16, t0.testo AS testo_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.regione_id AS regione_id_20, t0.provincia_id AS provincia_id_21, t0.copertina_id AS copertina_id_22 FROM lmn_geo t0 WHERE t0.id = 10630
Parameters: [10630]
[Display runnable query]
[
Explain query
]
|
10 |
0.46 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
]
|
11 |
0.59 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
]
|
12 |
0.90 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
]
|
13 |
0.61 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
]
|