Query Metrics
137
Database Queries
34
Different statements
171.53 ms
Query time
0
Invalid entities
992
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.12 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.ordre_general AS ordre_general_3, t0.ordre_brouillon AS ordre_brouillon_4, t0.visible AS visible_5, t0.is_page AS is_page_6, t0.created AS created_7, t0.updated AS updated_8, t0.published AS published_9, t0.template AS template_10, t0.titre AS titre_11, t0.titre_brouillon AS titre_brouillon_12, t0.slug AS slug_13, t0.body_id AS body_id_14, t0.meta_title AS meta_title_15, t0.meta_keyword AS meta_keyword_16, t0.meta_description AS meta_description_17, t0.introduction AS introduction_18, t0.contenu AS contenu_19, t0.type AS type_20, t0.url AS url_21, t0.url_brouillon AS url_brouillon_22, t0.image_name AS image_name_23, t0.image_updated_at AS image_updated_at_24, t0.image_name_brouillon AS image_name_brouillon_25, t0.image_updated_at_brouillon AS image_updated_at_brouillon_26, t0.parent_id AS parent_id_27 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"idees-cadeaux-naissance"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.77 ms |
SELECT p0_.id AS id_0, p0_.ordre AS ordre_1, p0_.ordre_general AS ordre_general_2, p0_.ordre_brouillon AS ordre_brouillon_3, p0_.visible AS visible_4, p0_.is_page AS is_page_5, p0_.created AS created_6, p0_.updated AS updated_7, p0_.published AS published_8, p0_.template AS template_9, p0_.titre AS titre_10, p0_.titre_brouillon AS titre_brouillon_11, p0_.slug AS slug_12, p0_.body_id AS body_id_13, p0_.meta_title AS meta_title_14, p0_.meta_keyword AS meta_keyword_15, p0_.meta_description AS meta_description_16, p0_.introduction AS introduction_17, p0_.contenu AS contenu_18, p0_.type AS type_19, p0_.url AS url_20, p0_.url_brouillon AS url_brouillon_21, p0_.image_name AS image_name_22, p0_.image_updated_at AS image_updated_at_23, p0_.image_name_brouillon AS image_name_brouillon_24, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_25, p0_.parent_id AS parent_id_26 FROM page p0_ WHERE p0_.visible = ? AND p0_.type = ? ORDER BY p0_.titre ASC
Parameters:
[ 1 "page" ]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.56 ms |
SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 4 | 1.58 ms |
SELECT l0_.image_updated_at AS image_updated_at_0, l0_.image2_updated_at AS image2_updated_at_1, l0_.image_bannniere_updated_at AS image_bannniere_updated_at_2, l0_.image_bannniere_illu_updated_at AS image_bannniere_illu_updated_at_3, l0_.id AS id_4, l0_.visible AS visible_5, l0_.archive AS archive_6, l0_.banniere AS banniere_7, l0_.created AS created_8, l0_.updated AS updated_9, l0_.color AS color_10, l0_.redirection AS redirection_11, l0_.titre AS titre_12, l0_.introduction AS introduction_13, l0_.contenu AS contenu_14, l0_.slug AS slug_15, l0_.banniere_titre AS banniere_titre_16, l0_.banniere_soustitre AS banniere_soustitre_17, l0_.banniere_color AS banniere_color_18, l0_.banniere_color_bouton AS banniere_color_bouton_19, l0_.banniere_text_bouton AS banniere_text_bouton_20, l0_.meta_title AS meta_title_21, l0_.meta_keyword AS meta_keyword_22, l0_.meta_description AS meta_description_23, l0_.image_name AS image_name_24, l0_.image_alt AS image_alt_25, l0_.image2_name AS image2_name_26, l0_.image_banniere_name AS image_banniere_name_27, l0_.image_banniere_illu_name AS image_banniere_illu_name_28 FROM listing l0_ WHERE l0_.visible = ? ORDER BY l0_.titre ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 5 | 5.94 ms |
SELECT a0_.id AS id_0, a0_.created AS created_1, a0_.review_id AS review_id_2, a0_.review_product_id AS review_product_id_3, a0_.review_date AS review_date_4, a0_.nom AS nom_5, a0_.prenom AS prenom_6, a0_.note AS note_7, a0_.commentaire AS commentaire_8, a0_.reponses AS reponses_9, a0_.produit_id AS produit_id_10, a0_.commande_id AS commande_id_11 FROM avis_verifies a0_ WHERE a0_.produit_id IS NULL ORDER BY a0_.review_date DESC LIMIT 20
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 6 | 2.72 ms |
SELECT t0_.variable AS variable_0, t1_.variable AS variable_1, t1_.rubrique AS rubrique_2 FROM traduction_valeur t0_ INNER JOIN traduction t1_ ON t0_.traduction_id = t1_.id WHERE t0_.locale = ?
Parameters:
[
"fr"
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.42 ms |
SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.visible AS visible_2, p0_.newsletter AS newsletter_3, p0_.date_debut AS date_debut_4, p0_.date_fin AS date_fin_5, p0_.url AS url_6, p0_.titre AS titre_7, p0_.contenu AS contenu_8 FROM popup p0_ WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" ]
|
||||||||||||||||||||||||||||||||||
| 8 | 2.13 ms |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.visible AS visible_4, t0.hide_desktop AS hide_desktop_5, t0.hide_tablet AS hide_tablet_6, t0.hide_mobile AS hide_mobile_7, t0.created AS created_8, t0.updated AS updated_9, t0.type AS type_10, t0.class_name AS class_name_11, t0.univer AS univer_12, t0.nom AS nom_13, t0.titre AS titre_14, t0.soustitre AS soustitre_15, t0.url AS url_16, t0.color AS color_17, t0.ancre AS ancre_18, t0.contenu AS contenu_19, t0.image_name AS image_name_20, t0.image_updated_at AS image_updated_at_21, t0.image_alt AS image_alt_22, t0.ordre AS ordre_23, t0.version AS version_24, t0.page_id AS page_id_25, t0.produit_id AS produit_id_26, t0.module_page_id AS module_page_id_27, t0.module_categorie_id AS module_categorie_id_28, t0.module_produit_id AS module_produit_id_29, t0.module_caracteristique_id AS module_caracteristique_id_30, t0.module_attribut_id AS module_attribut_id_31 FROM module t0 WHERE t0.page_id = ? ORDER BY t0.ordre ASC
Parameters:
[
99
]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.76 ms |
SELECT m0_.id AS id_0, m0_.date_debut AS date_debut_1, m0_.date_fin AS date_fin_2, m0_.visible AS visible_3, m0_.hide_desktop AS hide_desktop_4, m0_.hide_tablet AS hide_tablet_5, m0_.hide_mobile AS hide_mobile_6, m0_.created AS created_7, m0_.updated AS updated_8, m0_.type AS type_9, m0_.class_name AS class_name_10, m0_.univer AS univer_11, m0_.nom AS nom_12, m0_.titre AS titre_13, m0_.soustitre AS soustitre_14, m0_.url AS url_15, m0_.color AS color_16, m0_.ancre AS ancre_17, m0_.contenu AS contenu_18, m0_.image_name AS image_name_19, m0_.image_updated_at AS image_updated_at_20, m0_.image_alt AS image_alt_21, m0_.ordre AS ordre_22, m0_.version AS version_23, m0_.page_id AS page_id_24, m0_.produit_id AS produit_id_25, m0_.module_page_id AS module_page_id_26, m0_.module_categorie_id AS module_categorie_id_27, m0_.module_produit_id AS module_produit_id_28, m0_.module_caracteristique_id AS module_caracteristique_id_29, m0_.module_attribut_id AS module_attribut_id_30 FROM module m0_ WHERE m0_.page_id = ? AND m0_.version = ? ORDER BY m0_.ordre ASC, m0_.titre ASC
Parameters:
[ 99 "production" ]
|
||||||||||||||||||||||||||||||||||
| 10 | 0.35 ms |
SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0 WHERE t0.variable = ? LIMIT 1
Parameters:
[
"twitter-compte"
]
|
||||||||||||||||||||||||||||||||||
| 11 | 1.16 ms |
SELECT s0_.id AS id_0, s0_.frequent_search_entries AS frequent_search_entries_1, s1_.id AS id_2, s1_.position AS position_3, p2_.created AS created_4, p2_.updated AS updated_5, p2_.id AS id_6, p2_.visible AS visible_7, p2_.archive AS archive_8, p2_.exclude_columbus AS exclude_columbus_9, p2_.nouveau AS nouveau_10, p2_.precommande AS precommande_11, p2_.precommande_date AS precommande_date_12, p2_.offre_speciale AS offre_speciale_13, p2_.cadeau AS cadeau_14, p2_.goodie AS goodie_15, p2_.declinaison AS declinaison_16, p2_.declinaison_principale AS declinaison_principale_17, p2_.reference AS reference_18, p2_.titre AS titre_19, p2_.titre_brouillon AS titre_brouillon_20, p2_.contenu AS contenu_21, p2_.contenu_brouillon AS contenu_brouillon_22, p2_.contenu2 AS contenu2_23, p2_.contenu2_brouillon AS contenu2_brouillon_24, p2_.slug AS slug_25, p2_.prix_achat_ht AS prix_achat_ht_26, p2_.montantHT AS montantHT_27, p2_.montantTTC AS montantTTC_28, p2_.montantActuelTTC AS montantActuelTTC_29, p2_.tva AS tva_30, p2_.stock AS stock_31, p2_.alerte_stock AS alerte_stock_32, p2_.stock_emaplacement AS stock_emaplacement_33, p2_.poids AS poids_34, p2_.recherche_keyword AS recherche_keyword_35, p2_.recherche_slug AS recherche_slug_36, p2_.recherche_carac_attr_slug AS recherche_carac_attr_slug_37, p2_.produits_associes AS produits_associes_38, p2_.meta_title AS meta_title_39, p2_.meta_keyword AS meta_keyword_40, p2_.meta_description AS meta_description_41, p2_.note_avis AS note_avis_42, p2_.nb_avis AS nb_avis_43, p2_.image_panorama_name AS image_panorama_name_44, p2_.image_panorama_updated_at AS image_panorama_updated_at_45, p2_.image_portrait_name AS image_portrait_name_46, p2_.image_portrait_updated_at AS image_portrait_updated_at_47, p2_.image_name AS image_name_48, p2_.image_updated_at AS image_updated_at_49, p2_.image_alt AS image_alt_50, p2_.image_name_brouillon AS image_name_brouillon_51, p2_.image_updated_at_brouillon AS image_updated_at_brouillon_52, p2_.total_ca AS total_ca_53, p2_.count_commande AS count_commande_54, p2_.is_customizable AS is_customizable_55, s1_.search_editorial_id AS search_editorial_id_56, s1_.produit_id AS produit_id_57, p2_.parent_id AS parent_id_58 FROM search_editorial s0_ LEFT JOIN search_editorial_produit s1_ ON s0_.id = s1_.search_editorial_id LEFT JOIN produit p2_ ON s1_.produit_id = p2_.id WHERE s0_.id = ? ORDER BY s1_.position ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 12 | 0.41 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?
Parameters:
[
13
]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.31 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?
Parameters:
[
30
]
|
||||||||||||||||||||||||||||||||||
| 14 | 0.36 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?
Parameters:
[
60
]
|
||||||||||||||||||||||||||||||||||
| 15 | 0.29 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?
Parameters:
[
9
]
|
||||||||||||||||||||||||||||||||||
| 16 | 0.31 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?
Parameters:
[
46
]
|
||||||||||||||||||||||||||||||||||
| 17 | 0.33 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
13
]
|
||||||||||||||||||||||||||||||||||
| 18 | 3.22 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 13 226 216 215 218 219 220 229 217 26 132 164 37 4 162 19 5 163 0.0 13 13 13 13 ] |
||||||||||||||||||||||||||||||||||
| 19 | 0.30 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
226
]
|
||||||||||||||||||||||||||||||||||
| 20 | 0.22 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
13
]
|
||||||||||||||||||||||||||||||||||
| 21 | 0.27 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 22 | 0.27 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
30
]
|
||||||||||||||||||||||||||||||||||
| 23 | 3.02 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 30 64 226 215 216 217 218 219 220 229 181 185 26 190 175 174 46 37 19 4 5 59 0.0 30 30 30 30 ] |
||||||||||||||||||||||||||||||||||
| 24 | 0.21 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
64
]
|
||||||||||||||||||||||||||||||||||
| 25 | 0.27 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
30
]
|
||||||||||||||||||||||||||||||||||
| 26 | 0.27 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
9
]
|
||||||||||||||||||||||||||||||||||
| 27 | 5.91 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 9 65 226 229 220 219 218 217 216 215 214 21 58 83 19 5 2 9 59 0.0 9 9 9 9 ] |
||||||||||||||||||||||||||||||||||
| 28 | 1.25 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
65
]
|
||||||||||||||||||||||||||||||||||
| 29 | 0.40 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
9
]
|
||||||||||||||||||||||||||||||||||
| 30 | 0.26 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
8
]
|
||||||||||||||||||||||||||||||||||
| 31 | 0.28 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
46
]
|
||||||||||||||||||||||||||||||||||
| 32 | 2.29 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 46 63 226 223 229 220 219 218 217 175 29 174 46 190 166 185 36 20 4 163 5 162 59 3 0.0 46 46 46 46 ] |
||||||||||||||||||||||||||||||||||
| 33 | 0.23 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
63
]
|
||||||||||||||||||||||||||||||||||
| 34 | 0.21 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
46
]
|
||||||||||||||||||||||||||||||||||
| 35 | 0.18 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
12
]
|
||||||||||||||||||||||||||||||||||
| 36 | 0.62 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.visible AS visible_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.nom AS nom_8, t0.univer AS univer_9, t0.format AS format_10, t0.ancre AS ancre_11, t0.titre AS titre_12, t0.soustitre AS soustitre_13, t0.bouton_texte AS bouton_texte_14, t0.bouton_color AS bouton_color_15, t0.color AS color_16, t0.intro AS intro_17, t0.contenu AS contenu_18, t0.image_name AS image_name_19, t0.image_updated_at AS image_updated_at_20, t0.image_name2 AS image_name2_21, t0.image_updated_at2 AS image_updated_at2_22, t0.image_alt AS image_alt_23, t0.url AS url_24, t0.module_id AS module_id_25, t0.page_id AS page_id_26, t0.categorie_id AS categorie_id_27, t0.produit_id AS produit_id_28 FROM bloc t0 WHERE t0.module_id = ? ORDER BY t0.ordre ASC
Parameters:
[
1324
]
|
||||||||||||||||||||||||||||||||||
| 37 | 6.46 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
931
]
|
||||||||||||||||||||||||||||||||||
| 38 | 0.94 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
931
]
|
||||||||||||||||||||||||||||||||||
| 39 | 6.09 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 931 229 225 226 125 37 83 134 6 61 0.0 931 931 931 931 ] |
||||||||||||||||||||||||||||||||||
| 40 | 4.94 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
229
]
|
||||||||||||||||||||||||||||||||||
| 41 | 0.54 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
931
]
|
||||||||||||||||||||||||||||||||||
| 42 | 0.28 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||||||||
| 43 | 0.26 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||||
| 44 | 0.51 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
930
]
|
||||||||||||||||||||||||||||||||||
| 45 | 1.83 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
930
]
|
||||||||||||||||||||||||||||||||||
| 46 | 4.44 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 930 226 225 229 69 194 37 83 134 6 60 0.0 930 930 930 930 ] |
||||||||||||||||||||||||||||||||||
| 47 | 3.26 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
930
]
|
||||||||||||||||||||||||||||||||||
| 48 | 0.23 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
17
]
|
||||||||||||||||||||||||||||||||||
| 49 | 0.21 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||||
| 50 | 0.37 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
929
]
|
||||||||||||||||||||||||||||||||||
| 51 | 0.35 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
929
]
|
||||||||||||||||||||||||||||||||||
| 52 | 10.78 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 929 229 225 62 37 167 83 134 6 60 0.0 929 929 929 929 ] |
||||||||||||||||||||||||||||||||||
| 53 | 0.42 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
929
]
|
||||||||||||||||||||||||||||||||||
| 54 | 0.29 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
15
]
|
||||||||||||||||||||||||||||||||||
| 55 | 1.70 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
908
]
|
||||||||||||||||||||||||||||||||||
| 56 | 0.48 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
908
]
|
||||||||||||||||||||||||||||||||||
| 57 | 6.09 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 908 226 223 229 220 219 218 217 26 196 37 12 11 187 151 134 6 60 185 0.0 908 908 908 908 ] |
||||||||||||||||||||||||||||||||||
| 58 | 0.47 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
908
]
|
||||||||||||||||||||||||||||||||||
| 59 | 0.48 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
167
]
|
||||||||||||||||||||||||||||||||||
| 60 | 0.35 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
167
]
|
||||||||||||||||||||||||||||||||||
| 61 | 3.32 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 167 63 223 229 220 219 218 226 144 28 130 135 188 43 37 13 4 20 185 9 2 59 3 5 0.0 167 167 167 167 ] |
||||||||||||||||||||||||||||||||||
| 62 | 0.86 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
167
]
|
||||||||||||||||||||||||||||||||||
| 63 | 0.30 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
26
]
|
||||||||||||||||||||||||||||||||||
| 64 | 0.60 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.visible AS visible_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.nom AS nom_8, t0.univer AS univer_9, t0.format AS format_10, t0.ancre AS ancre_11, t0.titre AS titre_12, t0.soustitre AS soustitre_13, t0.bouton_texte AS bouton_texte_14, t0.bouton_color AS bouton_color_15, t0.color AS color_16, t0.intro AS intro_17, t0.contenu AS contenu_18, t0.image_name AS image_name_19, t0.image_updated_at AS image_updated_at_20, t0.image_name2 AS image_name2_21, t0.image_updated_at2 AS image_updated_at2_22, t0.image_alt AS image_alt_23, t0.url AS url_24, t0.module_id AS module_id_25, t0.page_id AS page_id_26, t0.categorie_id AS categorie_id_27, t0.produit_id AS produit_id_28 FROM bloc t0 WHERE t0.module_id = ? ORDER BY t0.ordre ASC
Parameters:
[
1329
]
|
||||||||||||||||||||||||||||||||||
| 65 | 0.53 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
694
]
|
||||||||||||||||||||||||||||||||||
| 66 | 0.47 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
694
]
|
||||||||||||||||||||||||||||||||||
| 67 | 5.28 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 694 226 225 229 153 145 130 168 111 163 3 134 0.0 694 694 694 694 ] |
||||||||||||||||||||||||||||||||||
| 68 | 0.52 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
694
]
|
||||||||||||||||||||||||||||||||||
| 69 | 0.58 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
169
]
|
||||||||||||||||||||||||||||||||||
| 70 | 0.48 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
169
]
|
||||||||||||||||||||||||||||||||||
| 71 | 3.20 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 169 63 226 225 229 130 25 135 188 43 139 138 145 90 91 36 19 4 185 59 3 5 0.0 169 169 169 169 ] |
||||||||||||||||||||||||||||||||||
| 72 | 0.38 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
169
]
|
||||||||||||||||||||||||||||||||||
| 73 | 0.46 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
697
]
|
||||||||||||||||||||||||||||||||||
| 74 | 0.35 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
697
]
|
||||||||||||||||||||||||||||||||||
| 75 | 2.98 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" "2026-09-24 16:23:28" 697 226 225 229 27 168 198 41 138 145 130 5 163 3 0.0 697 697 697 697 ] |
||||||||||||||||||||||||||||||||||
| 76 | 0.28 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
697
]
|
||||||||||||||||||||||||||||||||||
| 77 | 0.25 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
7
]
|
||||||||||||||||||||||||||||||||||
| 78 | 0.56 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
691
]
|
||||||||||||||||||||||||||||||||||
| 79 | 0.30 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
691
]
|
||||||||||||||||||||||||||||||||||
| 80 | 3.52 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 691 226 225 229 43 152 181 130 168 3 163 0.0 691 691 691 691 ] |
||||||||||||||||||||||||||||||||||
| 81 | 0.27 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
691
]
|
||||||||||||||||||||||||||||||||||
| 82 | 0.40 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
689
]
|
||||||||||||||||||||||||||||||||||
| 83 | 0.29 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
689
]
|
||||||||||||||||||||||||||||||||||
| 84 | 3.08 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 689 226 225 229 152 188 41 168 138 91 130 144 163 3 185 0.0 689 689 689 689 ] |
||||||||||||||||||||||||||||||||||
| 85 | 0.29 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
689
]
|
||||||||||||||||||||||||||||||||||
| 86 | 4.25 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.visible AS visible_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.nom AS nom_8, t0.univer AS univer_9, t0.format AS format_10, t0.ancre AS ancre_11, t0.titre AS titre_12, t0.soustitre AS soustitre_13, t0.bouton_texte AS bouton_texte_14, t0.bouton_color AS bouton_color_15, t0.color AS color_16, t0.intro AS intro_17, t0.contenu AS contenu_18, t0.image_name AS image_name_19, t0.image_updated_at AS image_updated_at_20, t0.image_name2 AS image_name2_21, t0.image_updated_at2 AS image_updated_at2_22, t0.image_alt AS image_alt_23, t0.url AS url_24, t0.module_id AS module_id_25, t0.page_id AS page_id_26, t0.categorie_id AS categorie_id_27, t0.produit_id AS produit_id_28 FROM bloc t0 WHERE t0.module_id = ? ORDER BY t0.ordre ASC
Parameters:
[
1333
]
|
||||||||||||||||||||||||||||||||||
| 87 | 0.46 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.visible AS visible_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.nom AS nom_8, t0.univer AS univer_9, t0.format AS format_10, t0.ancre AS ancre_11, t0.titre AS titre_12, t0.soustitre AS soustitre_13, t0.bouton_texte AS bouton_texte_14, t0.bouton_color AS bouton_color_15, t0.color AS color_16, t0.intro AS intro_17, t0.contenu AS contenu_18, t0.image_name AS image_name_19, t0.image_updated_at AS image_updated_at_20, t0.image_name2 AS image_name2_21, t0.image_updated_at2 AS image_updated_at2_22, t0.image_alt AS image_alt_23, t0.url AS url_24, t0.module_id AS module_id_25, t0.page_id AS page_id_26, t0.categorie_id AS categorie_id_27, t0.produit_id AS produit_id_28 FROM bloc t0 WHERE t0.module_id = ? ORDER BY t0.ordre ASC
Parameters:
[
1332
]
|
||||||||||||||||||||||||||||||||||
| 88 | 0.32 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 INNER JOIN bloc_categorie ON t0.id = bloc_categorie.categorie_id WHERE bloc_categorie.bloc_id = ?
Parameters:
[
526
]
|
||||||||||||||||||||||||||||||||||
| 89 | 0.25 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 INNER JOIN bloc_categorie ON t0.id = bloc_categorie.categorie_id WHERE bloc_categorie.bloc_id = ?
Parameters:
[
527
]
|
||||||||||||||||||||||||||||||||||
| 90 | 0.26 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 INNER JOIN bloc_categorie ON t0.id = bloc_categorie.categorie_id WHERE bloc_categorie.bloc_id = ?
Parameters:
[
528
]
|
||||||||||||||||||||||||||||||||||
| 91 | 0.24 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 INNER JOIN bloc_categorie ON t0.id = bloc_categorie.categorie_id WHERE bloc_categorie.bloc_id = ?
Parameters:
[
529
]
|
||||||||||||||||||||||||||||||||||
| 92 | 0.34 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.visible AS visible_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.nom AS nom_8, t0.univer AS univer_9, t0.format AS format_10, t0.ancre AS ancre_11, t0.titre AS titre_12, t0.soustitre AS soustitre_13, t0.bouton_texte AS bouton_texte_14, t0.bouton_color AS bouton_color_15, t0.color AS color_16, t0.intro AS intro_17, t0.contenu AS contenu_18, t0.image_name AS image_name_19, t0.image_updated_at AS image_updated_at_20, t0.image_name2 AS image_name2_21, t0.image_updated_at2 AS image_updated_at2_22, t0.image_alt AS image_alt_23, t0.url AS url_24, t0.module_id AS module_id_25, t0.page_id AS page_id_26, t0.categorie_id AS categorie_id_27, t0.produit_id AS produit_id_28 FROM bloc t0 WHERE t0.module_id = ? ORDER BY t0.ordre ASC
Parameters:
[
1335
]
|
||||||||||||||||||||||||||||||||||
| 93 | 0.41 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
170
]
|
||||||||||||||||||||||||||||||||||
| 94 | 0.28 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
170
]
|
||||||||||||||||||||||||||||||||||
| 95 | 3.00 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 170 63 226 215 216 217 218 219 220 229 214 92 140 22 43 19 134 38 59 3 5 0.0 170 170 170 170 ] |
||||||||||||||||||||||||||||||||||
| 96 | 0.26 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
170
]
|
||||||||||||||||||||||||||||||||||
| 97 | 0.42 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
824
]
|
||||||||||||||||||||||||||||||||||
| 98 | 0.28 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
824
]
|
||||||||||||||||||||||||||||||||||
| 99 | 3.02 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 824 226 217 216 215 214 219 218 220 229 38 82 159 5 3 19 12 2 204 11 9 0.0 824 824 824 824 ] |
||||||||||||||||||||||||||||||||||
| 100 | 1.93 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
824
]
|
||||||||||||||||||||||||||||||||||
| 101 | 0.40 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
181
]
|
||||||||||||||||||||||||||||||||||
| 102 | 0.39 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?
Parameters:
[
181
]
|
||||||||||||||||||||||||||||||||||
| 103 | 0.28 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
183
]
|
||||||||||||||||||||||||||||||||||
| 104 | 0.26 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
181
]
|
||||||||||||||||||||||||||||||||||
| 105 | 2.49 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ? OR p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 183 181 226 218 219 220 229 223 193 47 23 167 19 5 60 4 163 3 59 118 0.0 183 181 183 181 ] |
||||||||||||||||||||||||||||||||||
| 106 | 0.24 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
183
]
|
||||||||||||||||||||||||||||||||||
| 107 | 0.36 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||||||||
| 108 | 0.30 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
19
]
|
||||||||||||||||||||||||||||||||||
| 109 | 2.49 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 19 64 226 214 215 216 217 218 219 220 229 190 181 58 185 175 21 174 167 46 163 19 38 5 4 59 3 0.0 19 19 19 19 ] |
||||||||||||||||||||||||||||||||||
| 110 | 0.43 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
573
]
|
||||||||||||||||||||||||||||||||||
| 111 | 0.76 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?
Parameters:
[
573
]
|
||||||||||||||||||||||||||||||||||
| 112 | 0.27 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
574
]
|
||||||||||||||||||||||||||||||||||
| 113 | 0.28 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
573
]
|
||||||||||||||||||||||||||||||||||
| 114 | 2.91 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ? OR p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 574 573 226 229 220 219 218 217 216 215 214 82 38 19 87 5 12 0.0 574 573 574 573 ] |
||||||||||||||||||||||||||||||||||
| 115 | 0.24 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
574
]
|
||||||||||||||||||||||||||||||||||
| 116 | 0.22 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
41
]
|
||||||||||||||||||||||||||||||||||
| 117 | 0.45 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.visible AS visible_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.nom AS nom_8, t0.univer AS univer_9, t0.format AS format_10, t0.ancre AS ancre_11, t0.titre AS titre_12, t0.soustitre AS soustitre_13, t0.bouton_texte AS bouton_texte_14, t0.bouton_color AS bouton_color_15, t0.color AS color_16, t0.intro AS intro_17, t0.contenu AS contenu_18, t0.image_name AS image_name_19, t0.image_updated_at AS image_updated_at_20, t0.image_name2 AS image_name2_21, t0.image_updated_at2 AS image_updated_at2_22, t0.image_alt AS image_alt_23, t0.url AS url_24, t0.module_id AS module_id_25, t0.page_id AS page_id_26, t0.categorie_id AS categorie_id_27, t0.produit_id AS produit_id_28 FROM bloc t0 WHERE t0.module_id = ? ORDER BY t0.ordre ASC
Parameters:
[
1338
]
|
||||||||||||||||||||||||||||||||||
| 118 | 0.36 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
566
]
|
||||||||||||||||||||||||||||||||||
| 119 | 0.32 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
566
]
|
||||||||||||||||||||||||||||||||||
| 120 | 3.63 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 566 226 223 229 220 219 218 217 75 193 111 23 201 134 19 87 5 3 59 0.0 566 566 566 566 ] |
||||||||||||||||||||||||||||||||||
| 121 | 0.24 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
566
]
|
||||||||||||||||||||||||||||||||||
| 122 | 0.39 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
829
]
|
||||||||||||||||||||||||||||||||||
| 123 | 0.55 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?
Parameters:
[
829
]
|
||||||||||||||||||||||||||||||||||
| 124 | 0.31 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
830
]
|
||||||||||||||||||||||||||||||||||
| 125 | 0.31 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
829
]
|
||||||||||||||||||||||||||||||||||
| 126 | 5.18 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ? OR p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 830 829 226 223 229 220 219 218 217 193 24 187 19 151 6 60 185 23 3 5 0.0 830 829 830 829 ] |
||||||||||||||||||||||||||||||||||
| 127 | 0.31 ms |
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
830
]
|
||||||||||||||||||||||||||||||||||
| 128 | 0.42 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
568
]
|
||||||||||||||||||||||||||||||||||
| 129 | 0.28 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
568
]
|
||||||||||||||||||||||||||||||||||
| 130 | 3.33 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 568 226 223 229 220 219 218 217 193 23 111 61 19 87 5 3 59 0.0 568 568 568 568 ] |
||||||||||||||||||||||||||||||||||
| 131 | 0.35 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
372
]
|
||||||||||||||||||||||||||||||||||
| 132 | 0.31 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
372
]
|
||||||||||||||||||||||||||||||||||
| 133 | 2.64 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 372 226 223 229 220 219 218 165 193 24 19 59 5 163 87 0.0 372 372 372 372 ] |
||||||||||||||||||||||||||||||||||
| 134 | 0.33 ms |
SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?
Parameters:
[
23
]
|
||||||||||||||||||||||||||||||||||
| 135 | 0.29 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
23
]
|
||||||||||||||||||||||||||||||||||
| 136 | 2.60 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[ 1 "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" "2026-09-24 16:23:29" 23 73 226 215 216 217 218 219 220 229 190 181 175 185 174 46 24 193 166 19 4 163 5 3 59 0.0 23 23 23 23 ] |
||||||||||||||||||||||||||||||||||
| 137 | 0.42 ms |
SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0 WHERE t0.variable = ? LIMIT 1
Parameters:
[
"body-tracking-script"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\CategorieProduit | 442 |
| App\Entity\Listing | 150 |
| App\Entity\Parametre | 102 |
| App\Entity\Categorie | 93 |
| App\Entity\Page | 51 |
| App\Entity\Produit | 39 |
| App\Entity\Bloc | 24 |
| App\Entity\ProduitAttribut | 22 |
| App\Entity\AvisVerifies | 20 |
| App\Entity\Module | 18 |
| App\Entity\Promotion | 13 |
| App\Entity\AttributValeur | 11 |
| App\Entity\SearchEditorialProduit | 5 |
| App\Entity\SearchEditorial | 1 |
| App\Entity\Attribut | 1 |