GET https://tender-noether.87-106-247-125.plesk.page/fr/recherche?search=Lapin

Response
200 OK
IP
216.73.216.54
Profiled on
Token
33198f

Query Metrics

176 Database Queries
41 Different statements
731.88 ms Query time
0 Invalid entities
1061 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.72 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 2.84 ms 
SELECT c0_.id AS id_0 FROM categorie c0_ WHERE c0_.show_in_search = ? AND c0_.system = ? AND c0_.auto = ?
Parameters: 
[
  1
  0
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
3 2.04 ms 
SELECT DISTINCT c0_.id AS id_0 FROM listing l1_ INNER JOIN module_listing_link m2_ ON (m2_.listing_id = l1_.id) INNER JOIN module m3_ ON m2_.module_id = m3_.id INNER JOIN listing_categorie l4_ ON l1_.id = l4_.listing_id INNER JOIN categorie c0_ ON c0_.id = l4_.categorie_id WHERE m3_.id = ? AND l1_.visible = ? AND c0_.system = ? AND c0_.auto = ?
Parameters: 
[
  1191
  1
  0
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
4 2.18 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 IN (?)
Parameters: 
[
  578
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.59 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 IN (?)
Parameters: 
[
  110
]
View formatted query    View runnable query    Explain query    View query backtrace
6 2.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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  106
  110
  575
  578
  579
  71
  72
  81
  82
  83
  101
  386
  793
  794
  795
  796
  797
  798
  799
  800
  801
  802
  803
  804
]
View formatted query    View runnable query    Explain query    View query backtrace
7 4.87 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 6.71 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
]
View formatted query    View runnable query    Explain query    View query backtrace
9 13.29 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10 12.86 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 1.25 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:24:06"
  "2026-09-24 16:24:06"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.40 ms 
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.created AS created_3, t0.updated AS updated_4, t0.titre AS titre_5, t0.ancre AS ancre_6, t0.url AS url_7, t0.image_name AS image_name_8, t0.image_updated_at AS image_updated_at_9, t0.image_alt AS image_alt_10 FROM benefice t0 WHERE t0.id IN (?, ?, ?)
Parameters: 
[
  1
  2
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.44 ms 
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.ordre AS ordre_3, t0.color AS color_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.caracteristique_id AS caracteristique_id_7 FROM caracteristique_valeur t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  11
  26
  6
  109
  110
  111
  112
  113
  114
  134
  135
  140
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.49 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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  15
  17
  20
  22
  23
  24
  25
  29
  3
  31
  32
  34
  35
  40
  41
  5
  52
  54
  56
  6
  7
  8
  46
  47
  48
  49
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.77 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.affichage AS affichage_5, t0.titre AS titre_6, t0.slug AS slug_7 FROM attribut t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
16 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.affichage AS affichage_5, t0.titre AS titre_6, t0.slug AS slug_7 FROM attribut t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.48 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.affichage AS affichage_5, t0.titre AS titre_6, t0.slug AS slug_7 FROM caracteristique t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.31 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.ordre AS ordre_4, t0.affichage AS affichage_5, t0.titre AS titre_6, t0.slug AS slug_7 FROM caracteristique t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.54 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 12.53 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
]
View formatted query    View runnable query    Explain query    View query backtrace
21 31.30 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
]
View formatted query    View runnable query    Explain query    View query backtrace
22 3.75 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
]
View formatted query    View runnable query    Explain query    View query backtrace
23 3.01 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
]
View formatted query    View runnable query    Explain query    View query backtrace
24 1.71 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
]
View formatted query    View runnable query    Explain query    View query backtrace
25 3.79 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
]
View formatted query    View runnable query    Explain query    View query backtrace
26 3.38 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
]
View formatted query    View runnable query    Explain query    View query backtrace
27 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:24:06"
  "2026-09-24 16:24:06"
  "2026-09-24 16:24:06"
  "2026-09-24 16:24:06"
  13
  226
  216
  215
  218
  219
  220
  229
  217
  26
  132
  164
  37
  4
  162
  19
  5
  163
  0.0
  13
  13
  13
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.41 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
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.41 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
]
View formatted query    View runnable query    Explain query    View query backtrace
31 17.83 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:24:06"
  "2026-09-24 16:24:06"
  "2026-09-24 16:24:06"
  "2026-09-24 16:24:06"
  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
]
View formatted query    View runnable query    Explain query    View query backtrace
32 5.61 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
]
View formatted query    View runnable query    Explain query    View query backtrace
33 1.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: 
[
  30
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.90 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
]
View formatted query    View runnable query    Explain query    View query backtrace
35 13.61 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:24:06"
  "2026-09-24 16:24:06"
  "2026-09-24 16:24:06"
  "2026-09-24 16:24:06"
  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
]
View formatted query    View runnable query    Explain query    View query backtrace
36 3.61 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
]
View formatted query    View runnable query    Explain query    View query backtrace
37 1.96 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
]
View formatted query    View runnable query    Explain query    View query backtrace
38 3.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: 
[
  46
]
View formatted query    View runnable query    Explain query    View query backtrace
39 10.53 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:24:06"
  "2026-09-24 16:24:06"
  "2026-09-24 16:24:06"
  "2026-09-24 16:24:06"
  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
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.28 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
]
View formatted query    View runnable query    Explain query    View query backtrace
41 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: 
[
  46
]
View formatted query    View runnable query    Explain query    View query backtrace
42 6.15 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
]
View formatted query    View runnable query    Explain query    View query backtrace
43 8.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: 
[
  106
]
View formatted query    View runnable query    Explain query    View query backtrace
44 9.54 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  106
  226
  215
  216
  217
  218
  219
  220
  229
  166
  173
  188
  37
  4
  162
  185
  163
  11
  60
  2
  9
  3
  59
  0.0
  106
  106
  106
  106
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.55 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: 
[
  106
]
View formatted query    View runnable query    Explain query    View query backtrace
46 8.85 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: 
[
  110
]
View formatted query    View runnable query    Explain query    View query backtrace
47 6.26 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  110
  226
  216
  217
  218
  219
  220
  229
  118
  173
  193
  143
  23
  83
  162
  135
  19
  60
  5
  3
  59
  0.0
  110
  110
  110
  110
]
View formatted query    View runnable query    Explain query    View query backtrace
48 2.51 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: 
[
  110
]
View formatted query    View runnable query    Explain query    View query backtrace
49 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: 
[
  575
]
View formatted query    View runnable query    Explain query    View query backtrace
50 6.89 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
]
View formatted query    View runnable query    Explain query    View query backtrace
51 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: 
[
  573
]
View formatted query    View runnable query    Explain query    View query backtrace
52 3.48 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  575
  573
  226
  229
  220
  219
  218
  217
  216
  215
  214
  82
  38
  4
  19
  87
  5
  12
  0.0
  575
  573
  575
  573
]
View formatted query    View runnable query    Explain query    View query backtrace
53 1.90 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: 
[
  575
]
View formatted query    View runnable query    Explain query    View query backtrace
54 2.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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  575
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.71 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  573
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.77 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  575
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.54 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: 
[
  18
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.39 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: 
[
  578
]
View formatted query    View runnable query    Explain query    View query backtrace
59 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: 
[
  577
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.66 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: 
[
  577
]
View formatted query    View runnable query    Explain query    View query backtrace
61 4.13 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  578
  577
  226
  229
  220
  219
  218
  217
  216
  215
  214
  111
  82
  134
  19
  87
  5
  3
  0.0
  578
  577
  578
  577
]
View formatted query    View runnable query    Explain query    View query backtrace
62 1.46 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: 
[
  578
]
View formatted query    View runnable query    Explain query    View query backtrace
63 1.39 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  578
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
64 1.38 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  577
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
65 3.63 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  578
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
66 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: 
[
  55
]
View formatted query    View runnable query    Explain query    View query backtrace
67 2.84 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: 
[
  579
]
View formatted query    View runnable query    Explain query    View query backtrace
68 27.05 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  579
  577
  226
  229
  220
  219
  218
  217
  216
  215
  214
  82
  111
  134
  19
  87
  3
  0.0
  579
  577
  579
  577
]
View formatted query    View runnable query    Explain query    View query backtrace
69 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: 
[
  579
]
View formatted query    View runnable query    Explain query    View query backtrace
70 5.34 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  579
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
71 4.56 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  577
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
72 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  579
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
73 1.72 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: 
[
  71
]
View formatted query    View runnable query    Explain query    View query backtrace
74 5.86 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  71
  226
  229
  220
  216
  217
  219
  218
  137
  86
  48
  143
  114
  165
  13
  135
  12
  162
  83
  163
  59
  60
  3
  9
  2
  4
  0.0
  71
  71
  71
  71
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.32 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: 
[
  71
]
View formatted query    View runnable query    Explain query    View query backtrace
76 1.44 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: 
[
  72
]
View formatted query    View runnable query    Explain query    View query backtrace
77 5.99 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  72
  226
  218
  219
  220
  223
  229
  118
  86
  48
  165
  18
  13
  162
  10
  83
  163
  59
  60
  3
  2
  9
  0.0
  72
  72
  72
  72
]
View formatted query    View runnable query    Explain query    View query backtrace
78 4.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: 
[
  72
]
View formatted query    View runnable query    Explain query    View query backtrace
79 4.93 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: 
[
  81
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.45 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: 
[
  80
]
View formatted query    View runnable query    Explain query    View query backtrace
81 1.01 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: 
[
  80
]
View formatted query    View runnable query    Explain query    View query backtrace
82 29.73 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  81
  80
  226
  219
  220
  218
  229
  223
  48
  86
  165
  15
  60
  163
  10
  2
  3
  59
  137
  118
  36
  162
  4
  83
  0.0
  81
  80
  81
  80
]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.33 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: 
[
  81
]
View formatted query    View runnable query    Explain query    View query backtrace
84 6.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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  81
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.67 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  80
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
86 0.23 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  81
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
87 5.01 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: 
[
  82
]
View formatted query    View runnable query    Explain query    View query backtrace
88 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 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  82
  80
  226
  218
  219
  220
  229
  223
  48
  165
  86
  36
  162
  83
  15
  60
  163
  10
  2
  3
  59
  137
  118
  4
  0.0
  82
  80
  82
  80
]
View formatted query    View runnable query    Explain query    View query backtrace
89 6.90 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: 
[
  82
]
View formatted query    View runnable query    Explain query    View query backtrace
90 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  82
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.41 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  80
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
92 9.74 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  82
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.43 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: 
[
  83
]
View formatted query    View runnable query    Explain query    View query backtrace
94 9.05 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  83
  80
  226
  218
  219
  220
  229
  223
  137
  118
  48
  165
  36
  86
  15
  83
  4
  60
  163
  10
  2
  3
  59
  162
  0.0
  83
  80
  83
  80
]
View formatted query    View runnable query    Explain query    View query backtrace
95 1.05 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: 
[
  83
]
View formatted query    View runnable query    Explain query    View query backtrace
96 0.32 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  83
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
97 6.37 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  80
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
98 1.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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  83
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
99 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: 
[
  101
]
View formatted query    View runnable query    Explain query    View query backtrace
100 24.81 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  101
  226
  214
  215
  216
  217
  218
  219
  220
  229
  213
  114
  204
  142
  38
  4
  12
  60
  2
  9
  59
  0.0
  101
  101
  101
  101
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.74 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: 
[
  101
]
View formatted query    View runnable query    Explain query    View query backtrace
102 6.88 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: 
[
  386
]
View formatted query    View runnable query    Explain query    View query backtrace
103 5.99 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  386
  226
  225
  229
  130
  153
  92
  164
  56
  20
  59
  60
  5
  3
  83
  163
  0.0
  386
  386
  386
  386
]
View formatted query    View runnable query    Explain query    View query backtrace
104 4.01 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: 
[
  386
]
View formatted query    View runnable query    Explain query    View query backtrace
105 4.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: 
[
  793
]
View formatted query    View runnable query    Explain query    View query backtrace
106 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: 
[
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
107 0.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: 
[
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
108 5.14 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  793
  792
  226
  215
  216
  217
  218
  219
  220
  229
  161
  187
  3
  151
  2
  201
  9
  10
  6
  60
  15
  185
  0.0
  793
  792
  793
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
109 2.87 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: 
[
  793
]
View formatted query    View runnable query    Explain query    View query backtrace
110 24.56 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  793
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
111 3.47 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  792
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
112 0.88 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  793
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
113 0.39 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: 
[
  794
]
View formatted query    View runnable query    Explain query    View query backtrace
114 6.31 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  794
  792
  226
  229
  220
  219
  218
  217
  216
  215
  198
  187
  3
  134
  201
  151
  185
  6
  60
  0.0
  794
  792
  794
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
115 0.35 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: 
[
  794
]
View formatted query    View runnable query    Explain query    View query backtrace
116 6.51 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  794
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
117 0.44 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  792
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
118 0.25 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  794
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
119 6.45 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: 
[
  795
]
View formatted query    View runnable query    Explain query    View query backtrace
120 3.15 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  795
  792
  226
  229
  220
  219
  218
  217
  216
  215
  187
  3
  151
  201
  134
  185
  6
  60
  0.0
  795
  792
  795
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
121 7.37 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: 
[
  795
]
View formatted query    View runnable query    Explain query    View query backtrace
122 7.57 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  795
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
123 0.52 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  792
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
124 2.01 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  795
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
125 22.08 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: 
[
  796
]
View formatted query    View runnable query    Explain query    View query backtrace
126 10.89 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  796
  792
  226
  229
  220
  219
  218
  217
  216
  215
  171
  187
  3
  201
  151
  134
  185
  6
  60
  0.0
  796
  792
  796
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  796
]
View formatted query    View runnable query    Explain query    View query backtrace
128 0.25 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  796
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
129 6.77 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  792
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
130 0.23 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  796
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
131 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: 
[
  797
]
View formatted query    View runnable query    Explain query    View query backtrace
132 12.23 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  797
  792
  226
  229
  220
  219
  218
  217
  216
  215
  196
  187
  3
  151
  201
  134
  185
  6
  60
  0.0
  797
  792
  797
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
133 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: 
[
  797
]
View formatted query    View runnable query    Explain query    View query backtrace
134 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  797
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
135 6.79 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  792
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
136 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  797
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
137 7.03 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: 
[
  798
]
View formatted query    View runnable query    Explain query    View query backtrace
138 3.05 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  798
  792
  226
  229
  220
  219
  218
  217
  216
  215
  196
  187
  171
  3
  201
  151
  134
  185
  6
  60
  0.0
  798
  792
  798
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
139 2.20 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: 
[
  798
]
View formatted query    View runnable query    Explain query    View query backtrace
140 2.51 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  798
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
141 0.93 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  792
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
142 3.56 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  798
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
143 1.91 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: 
[
  799
]
View formatted query    View runnable query    Explain query    View query backtrace
144 5.27 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  799
  226
  229
  220
  219
  218
  217
  216
  11
  2
  151
  9
  6
  0.0
  799
  799
  799
  799
]
View formatted query    View runnable query    Explain query    View query backtrace
145 18.62 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: 
[
  799
]
View formatted query    View runnable query    Explain query    View query backtrace
146 0.45 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: 
[
  800
]
View formatted query    View runnable query    Explain query    View query backtrace
147 6.40 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  800
  799
  226
  229
  220
  219
  218
  217
  216
  187
  11
  3
  2
  151
  9
  185
  6
  0.0
  800
  799
  800
  799
]
View formatted query    View runnable query    Explain query    View query backtrace
148 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: 
[
  800
]
View formatted query    View runnable query    Explain query    View query backtrace
149 3.60 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  800
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
150 0.37 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  799
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
151 0.33 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  800
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
152 2.72 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: 
[
  801
]
View formatted query    View runnable query    Explain query    View query backtrace
153 3.12 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  801
  799
  226
  229
  220
  219
  218
  217
  216
  187
  151
  185
  11
  2
  9
  6
  0.0
  801
  799
  801
  799
]
View formatted query    View runnable query    Explain query    View query backtrace
154 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: 
[
  801
]
View formatted query    View runnable query    Explain query    View query backtrace
155 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  801
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
156 0.38 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  799
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
157 0.23 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  801
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
158 0.92 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: 
[
  802
]
View formatted query    View runnable query    Explain query    View query backtrace
159 9.55 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  802
  799
  226
  229
  220
  219
  218
  217
  216
  187
  60
  151
  185
  11
  2
  9
  6
  0.0
  802
  799
  802
  799
]
View formatted query    View runnable query    Explain query    View query backtrace
160 3.08 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: 
[
  802
]
View formatted query    View runnable query    Explain query    View query backtrace
161 21.76 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  802
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
162 3.76 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  799
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
163 3.76 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  802
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
164 2.44 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: 
[
  803
]
View formatted query    View runnable query    Explain query    View query backtrace
165 4.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 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  803
  799
  226
  229
  220
  219
  218
  217
  216
  196
  187
  3
  151
  185
  11
  2
  9
  6
  0.0
  803
  799
  803
  799
]
View formatted query    View runnable query    Explain query    View query backtrace
166 3.15 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: 
[
  803
]
View formatted query    View runnable query    Explain query    View query backtrace
167 12.61 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  803
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
168 0.43 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  799
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
169 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  803
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
170 3.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: 
[
  804
]
View formatted query    View runnable query    Explain query    View query backtrace
171 4.94 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:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  "2026-09-24 16:24:07"
  804
  799
  226
  229
  220
  219
  218
  217
  216
  187
  198
  196
  3
  6
  151
  60
  185
  11
  2
  9
  0.0
  804
  799
  804
  799
]
View formatted query    View runnable query    Explain query    View query backtrace
172 2.77 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: 
[
  804
]
View formatted query    View runnable query    Explain query    View query backtrace
173 2.55 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  804
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
174 0.41 ms 
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN attribut_valeur a2_ ON p0_.attribut_valeur_id = a2_.id WHERE p1_.visible = 1 AND p0_.produit_parent_id = ? AND p0_.attribut_id = ? GROUP BY p0_.attribut_valeur_id ORDER BY a2_.ordre ASC
Parameters: 
[
  799
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
175 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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters: 
[
  804
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
176 1.45 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"
]
View formatted query    View runnable query    Explain query    View query backtrace

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 523
App\Entity\Listing 150
App\Entity\Parametre 102
App\Entity\Categorie 79
App\Entity\Page 51
App\Entity\Produit 39
App\Entity\ProduitAttribut 31
App\Entity\AttributValeur 30
App\Entity\AvisVerifies 20
App\Entity\CaracteristiqueValeur 12
App\Entity\Promotion 11
App\Entity\SearchEditorialProduit 5
App\Entity\Benefice 3
App\Entity\Caracteristique 2
App\Entity\Attribut 2
App\Entity\SearchEditorial 1

Entities Mapping

Class Mapping errors
App\Entity\Parametre No errors.
App\Entity\Categorie No errors.
App\Entity\Listing No errors.
App\Entity\ModuleListing No errors.
App\Entity\Module No errors.
App\Entity\Produit No errors.
App\Entity\Pack No errors.
App\Entity\Bloc No errors.
App\Entity\CategorieProduit No errors.
App\Entity\Benefice No errors.
App\Entity\ProduitAttribut No errors.
App\Entity\ProduitCaracteristique No errors.
App\Entity\ProduitImage No errors.
App\Entity\AvisVerifies No errors.
App\Entity\CodePromo No errors.
App\Entity\Promotion No errors.
App\Entity\CommandeProduit No errors.
App\Entity\CommandeRetour No errors.
App\Entity\ProduitAlerteStock No errors.
App\Entity\User No errors.
App\Entity\Commande No errors.
App\Entity\InstashopProduit No errors.
App\Entity\Page No errors.
App\Entity\Menu No errors.
App\Entity\AttributValeur No errors.
App\Entity\CaracteristiqueValeur No errors.
App\Entity\Presse No errors.
App\Entity\TraductionValeur No errors.
App\Entity\Traduction No errors.
App\Entity\Popup No errors.
App\Entity\Caracteristique No errors.
App\Entity\Attribut No errors.
App\Entity\Adresse No errors.
App\Entity\Paiement No errors.
App\Entity\Facture No errors.
App\Entity\Transporteur No errors.
App\Entity\Reglement No errors.
App\Entity\Zone No errors.
App\Entity\Instashop No errors.
App\Entity\MenuListing No errors.
App\Entity\Pays No errors.
App\Entity\TransporteurTarif No errors.
App\Entity\SearchEditorial No errors.
App\Entity\SearchEditorialProduit No errors.
App\Entity\Collectmail No errors.
App\Entity\CommandeStatistique No errors.
App\Entity\Email No errors.
App\Entity\Cron No errors.
App\Entity\Fichier No errors.
App\Entity\Magasin No errors.
App\Entity\Faq No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
Gedmo\Translator\Entity\Translation No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure No errors.
Vich\UploaderBundle\Entity\File No errors.
Meilisearch\Bundle\Entity\Aggregator No errors.