1
10.57 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
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 = 1 AND p0_ . type = 'page' ORDER BY p0_ . titre ASC ;
Copy
2
1.26 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
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 ;
Copy
3
1.35 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
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 = 1 ORDER BY l0_ . titre ASC ;
Copy
4
7.79 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
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 ;
Copy
5
3.35 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 = ?
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 = 'fr' ;
Copy
6
0.49 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 17:25:17 "
"2026-09-24 17:25:17 "
]
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 = 1 AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) ORDER BY p0_ . date_debut DESC LIMIT 1 ;
Copy
7
2.43 ms
SELECT p0_ . created AS created_0 , p0_ . updated AS updated_1 , p0_ . id AS id_2 , p0_ . visible AS visible_3 , p0_ . archive AS archive_4 , p0_ . exclude_columbus AS exclude_columbus_5 , p0_ . nouveau AS nouveau_6 , p0_ . precommande AS precommande_7 , p0_ . precommande_date AS precommande_date_8 , p0_ . offre_speciale AS offre_speciale_9 , p0_ . cadeau AS cadeau_10 , p0_ . goodie AS goodie_11 , p0_ . declinaison AS declinaison_12 , p0_ . declinaison_principale AS declinaison_principale_13 , p0_ . reference AS reference_14 , p0_ . titre AS titre_15 , p0_ . titre_brouillon AS titre_brouillon_16 , p0_ . contenu AS contenu_17 , p0_ . contenu_brouillon AS contenu_brouillon_18 , p0_ . contenu2 AS contenu2_19 , p0_ . contenu2_brouillon AS contenu2_brouillon_20 , p0_ . slug AS slug_21 , p0_ . prix_achat_ht AS prix_achat_ht_22 , p0_ . montantHT AS montantHT_23 , p0_ . montantTTC AS montantTTC_24 , p0_ . montantActuelTTC AS montantActuelTTC_25 , p0_ . tva AS tva_26 , p0_ . stock AS stock_27 , p0_ . alerte_stock AS alerte_stock_28 , p0_ . stock_emaplacement AS stock_emaplacement_29 , p0_ . poids AS poids_30 , p0_ . recherche_keyword AS recherche_keyword_31 , p0_ . recherche_slug AS recherche_slug_32 , p0_ . recherche_carac_attr_slug AS recherche_carac_attr_slug_33 , p0_ . produits_associes AS produits_associes_34 , p0_ . meta_title AS meta_title_35 , p0_ . meta_keyword AS meta_keyword_36 , p0_ . meta_description AS meta_description_37 , p0_ . note_avis AS note_avis_38 , p0_ . nb_avis AS nb_avis_39 , p0_ . image_panorama_name AS image_panorama_name_40 , p0_ . image_panorama_updated_at AS image_panorama_updated_at_41 , p0_ . image_portrait_name AS image_portrait_name_42 , p0_ . image_portrait_updated_at AS image_portrait_updated_at_43 , p0_ . image_name AS image_name_44 , p0_ . image_updated_at AS image_updated_at_45 , p0_ . image_alt AS image_alt_46 , p0_ . image_name_brouillon AS image_name_brouillon_47 , p0_ . image_updated_at_brouillon AS image_updated_at_brouillon_48 , p0_ . total_ca AS total_ca_49 , p0_ . count_commande AS count_commande_50 , p0_ . is_customizable AS is_customizable_51 , p0_ . parent_id AS parent_id_52 FROM produit p0_ WHERE p0_ . slug = ?
Parameters :
[
"protege-carnet-de-sante "
]
SELECT
p0_ . created AS created_0 ,
p0_ . updated AS updated_1 ,
p0_ . id AS id_2 ,
p0_ . visible AS visible_3 ,
p0_ . archive AS archive_4 ,
p0_ . exclude_columbus AS exclude_columbus_5 ,
p0_ . nouveau AS nouveau_6 ,
p0_ . precommande AS precommande_7 ,
p0_ . precommande_date AS precommande_date_8 ,
p0_ . offre_speciale AS offre_speciale_9 ,
p0_ . cadeau AS cadeau_10 ,
p0_ . goodie AS goodie_11 ,
p0_ . declinaison AS declinaison_12 ,
p0_ . declinaison_principale AS declinaison_principale_13 ,
p0_ . reference AS reference_14 ,
p0_ . titre AS titre_15 ,
p0_ . titre_brouillon AS titre_brouillon_16 ,
p0_ . contenu AS contenu_17 ,
p0_ . contenu_brouillon AS contenu_brouillon_18 ,
p0_ . contenu2 AS contenu2_19 ,
p0_ . contenu2_brouillon AS contenu2_brouillon_20 ,
p0_ . slug AS slug_21 ,
p0_ . prix_achat_ht AS prix_achat_ht_22 ,
p0_ . montantHT AS montantHT_23 ,
p0_ . montantTTC AS montantTTC_24 ,
p0_ . montantActuelTTC AS montantActuelTTC_25 ,
p0_ . tva AS tva_26 ,
p0_ . stock AS stock_27 ,
p0_ . alerte_stock AS alerte_stock_28 ,
p0_ . stock_emaplacement AS stock_emaplacement_29 ,
p0_ . poids AS poids_30 ,
p0_ . recherche_keyword AS recherche_keyword_31 ,
p0_ . recherche_slug AS recherche_slug_32 ,
p0_ . recherche_carac_attr_slug AS recherche_carac_attr_slug_33 ,
p0_ . produits_associes AS produits_associes_34 ,
p0_ . meta_title AS meta_title_35 ,
p0_ . meta_keyword AS meta_keyword_36 ,
p0_ . meta_description AS meta_description_37 ,
p0_ . note_avis AS note_avis_38 ,
p0_ . nb_avis AS nb_avis_39 ,
p0_ . image_panorama_name AS image_panorama_name_40 ,
p0_ . image_panorama_updated_at AS image_panorama_updated_at_41 ,
p0_ . image_portrait_name AS image_portrait_name_42 ,
p0_ . image_portrait_updated_at AS image_portrait_updated_at_43 ,
p0_ . image_name AS image_name_44 ,
p0_ . image_updated_at AS image_updated_at_45 ,
p0_ . image_alt AS image_alt_46 ,
p0_ . image_name_brouillon AS image_name_brouillon_47 ,
p0_ . image_updated_at_brouillon AS image_updated_at_brouillon_48 ,
p0_ . total_ca AS total_ca_49 ,
p0_ . count_commande AS count_commande_50 ,
p0_ . is_customizable AS is_customizable_51 ,
p0_ . parent_id AS parent_id_52
FROM
produit p0_
WHERE
p0_ . slug = ?
Copy
SELECT p0_ . created AS created_0 , p0_ . updated AS updated_1 , p0_ . id AS id_2 , p0_ . visible AS visible_3 , p0_ . archive AS archive_4 , p0_ . exclude_columbus AS exclude_columbus_5 , p0_ . nouveau AS nouveau_6 , p0_ . precommande AS precommande_7 , p0_ . precommande_date AS precommande_date_8 , p0_ . offre_speciale AS offre_speciale_9 , p0_ . cadeau AS cadeau_10 , p0_ . goodie AS goodie_11 , p0_ . declinaison AS declinaison_12 , p0_ . declinaison_principale AS declinaison_principale_13 , p0_ . reference AS reference_14 , p0_ . titre AS titre_15 , p0_ . titre_brouillon AS titre_brouillon_16 , p0_ . contenu AS contenu_17 , p0_ . contenu_brouillon AS contenu_brouillon_18 , p0_ . contenu2 AS contenu2_19 , p0_ . contenu2_brouillon AS contenu2_brouillon_20 , p0_ . slug AS slug_21 , p0_ . prix_achat_ht AS prix_achat_ht_22 , p0_ . montantHT AS montantHT_23 , p0_ . montantTTC AS montantTTC_24 , p0_ . montantActuelTTC AS montantActuelTTC_25 , p0_ . tva AS tva_26 , p0_ . stock AS stock_27 , p0_ . alerte_stock AS alerte_stock_28 , p0_ . stock_emaplacement AS stock_emaplacement_29 , p0_ . poids AS poids_30 , p0_ . recherche_keyword AS recherche_keyword_31 , p0_ . recherche_slug AS recherche_slug_32 , p0_ . recherche_carac_attr_slug AS recherche_carac_attr_slug_33 , p0_ . produits_associes AS produits_associes_34 , p0_ . meta_title AS meta_title_35 , p0_ . meta_keyword AS meta_keyword_36 , p0_ . meta_description AS meta_description_37 , p0_ . note_avis AS note_avis_38 , p0_ . nb_avis AS nb_avis_39 , p0_ . image_panorama_name AS image_panorama_name_40 , p0_ . image_panorama_updated_at AS image_panorama_updated_at_41 , p0_ . image_portrait_name AS image_portrait_name_42 , p0_ . image_portrait_updated_at AS image_portrait_updated_at_43 , p0_ . image_name AS image_name_44 , p0_ . image_updated_at AS image_updated_at_45 , p0_ . image_alt AS image_alt_46 , p0_ . image_name_brouillon AS image_name_brouillon_47 , p0_ . image_updated_at_brouillon AS image_updated_at_brouillon_48 , p0_ . total_ca AS total_ca_49 , p0_ . count_commande AS count_commande_50 , p0_ . is_customizable AS is_customizable_51 , p0_ . parent_id AS parent_id_52 FROM produit p0_ WHERE p0_ . slug = 'protege-carnet-de-sante' ;
Copy
8
0.65 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 . reference IN (? )
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 . reference IN (? )
Copy
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 . reference IN ('dc4040' );
Copy
9
0.36 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
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 = 693 ORDER BY t0 . ordre ASC ;
Copy
10
2.01 ms
SELECT c0_ . id AS id_0 , c0_ . ordre AS ordre_1 , c0_ . produit_id AS produit_id_2 , c0_ . categorie_id AS categorie_id_3 FROM categorie_produit c0_ INNER JOIN produit p1_ ON c0_ . produit_id = p1_ . id WHERE p1_ . visible = ? AND c0_ . categorie_id = ? AND c0_ . produit_id NOT IN (693 ) ORDER BY c0_ . ordre ASC
SELECT c0_ . id AS id_0 , c0_ . ordre AS ordre_1 , c0_ . produit_id AS produit_id_2 , c0_ . categorie_id AS categorie_id_3 FROM categorie_produit c0_ INNER JOIN produit p1_ ON c0_ . produit_id = p1_ . id WHERE p1_ . visible = 1 AND c0_ . categorie_id = 228 AND c0_ . produit_id NOT IN (693 ) ORDER BY c0_ . ordre ASC ;
Copy
11
0.55 ms
SELECT p0_ . id AS id_0 , p0_ . visible AS visible_1 , p0_ . created AS created_2 , p0_ . updated AS updated_3 , p0_ . date_debut AS date_debut_4 , p0_ . date_fin AS date_fin_5 , p0_ . remise AS remise_6 FROM pack p0_ LEFT JOIN pack_produit p2_ ON p0_ . id = p2_ . pack_id LEFT JOIN produit p1_ ON p1_ . id = p2_ . produit_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 = ? ORDER BY p0_ . created DESC
Parameters :
[
1
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
693
]
SELECT p0_ . id AS id_0 , p0_ . visible AS visible_1 , p0_ . created AS created_2 , p0_ . updated AS updated_3 , p0_ . date_debut AS date_debut_4 , p0_ . date_fin AS date_fin_5 , p0_ . remise AS remise_6 FROM pack p0_ LEFT JOIN pack_produit p2_ ON p0_ . id = p2_ . pack_id LEFT JOIN produit p1_ ON p1_ . id = p2_ . produit_id WHERE p0_ . visible = 1 AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND p1_ . id = 693 ORDER BY p0_ . created DESC ;
Copy
12
0.44 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 = ?
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 = ?
Copy
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 = 1059 ;
Copy
13
0.42 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . id = ?
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 = ?
Copy
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 = 652 ;
Copy
14
0.32 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 = ?
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 = ?
Copy
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 = 914 ;
Copy
15
0.33 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . id = ?
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 = ?
Copy
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 = 11 ;
Copy
16
0.36 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . id = ?
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 = ?
Copy
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 = 104 ;
Copy
17
0.56 ms
SELECT m0_ . id AS id_0 , m0_ . date_debut AS date_debut_1 , m0_ . date_fin AS date_fin_2 , m0_ . visible AS visible_3 , m0_ . hide_desktop AS hide_desktop_4 , m0_ . hide_tablet AS hide_tablet_5 , m0_ . hide_mobile AS hide_mobile_6 , m0_ . created AS created_7 , m0_ . updated AS updated_8 , m0_ . type AS type_9 , m0_ . class_name AS class_name_10 , m0_ . univer AS univer_11 , m0_ . nom AS nom_12 , m0_ . titre AS titre_13 , m0_ . soustitre AS soustitre_14 , m0_ . url AS url_15 , m0_ . color AS color_16 , m0_ . ancre AS ancre_17 , m0_ . contenu AS contenu_18 , m0_ . image_name AS image_name_19 , m0_ . image_updated_at AS image_updated_at_20 , m0_ . image_alt AS image_alt_21 , m0_ . ordre AS ordre_22 , m0_ . version AS version_23 , m0_ . page_id AS page_id_24 , m0_ . produit_id AS produit_id_25 , m0_ . module_page_id AS module_page_id_26 , m0_ . module_categorie_id AS module_categorie_id_27 , m0_ . module_produit_id AS module_produit_id_28 , m0_ . module_caracteristique_id AS module_caracteristique_id_29 , m0_ . module_attribut_id AS module_attribut_id_30 FROM module m0_ WHERE m0_ . produit_id = ? AND m0_ . version = ? ORDER BY m0_ . ordre ASC , m0_ . titre ASC
Parameters :
[
693
"production "
]
SELECT m0_ . id AS id_0 , m0_ . date_debut AS date_debut_1 , m0_ . date_fin AS date_fin_2 , m0_ . visible AS visible_3 , m0_ . hide_desktop AS hide_desktop_4 , m0_ . hide_tablet AS hide_tablet_5 , m0_ . hide_mobile AS hide_mobile_6 , m0_ . created AS created_7 , m0_ . updated AS updated_8 , m0_ . type AS type_9 , m0_ . class_name AS class_name_10 , m0_ . univer AS univer_11 , m0_ . nom AS nom_12 , m0_ . titre AS titre_13 , m0_ . soustitre AS soustitre_14 , m0_ . url AS url_15 , m0_ . color AS color_16 , m0_ . ancre AS ancre_17 , m0_ . contenu AS contenu_18 , m0_ . image_name AS image_name_19 , m0_ . image_updated_at AS image_updated_at_20 , m0_ . image_alt AS image_alt_21 , m0_ . ordre AS ordre_22 , m0_ . version AS version_23 , m0_ . page_id AS page_id_24 , m0_ . produit_id AS produit_id_25 , m0_ . module_page_id AS module_page_id_26 , m0_ . module_categorie_id AS module_categorie_id_27 , m0_ . module_produit_id AS module_produit_id_28 , m0_ . module_caracteristique_id AS module_caracteristique_id_29 , m0_ . module_attribut_id AS module_attribut_id_30 FROM module m0_ WHERE m0_ . produit_id = 693 AND m0_ . version = 'production' ORDER BY m0_ . ordre ASC , m0_ . titre ASC ;
Copy
18
3.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 (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 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
693
228
215
216
217
218
219
220
229
226
214
213
31
91
4
130
111
5
142
3
20
0.0
693
693
693
693
]
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
Copy
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 = 1 AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND (((p1_ . id = 693 ) OR (c3_ . id IN (228 , 215 , 216 , 217 , 218 , 219 , 220 , 229 , 226 , 214 , 213 , 31 , 91 , 4 , 130 , 111 , 5 , 142 , 3 , 20 ) AND c3_ . id IS NOT NULL ))) AND ((p0_ . montant_min IS NULL OR p0_ . montant_min < = 0 )) 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 = 693 OR p6_ . id = 693 ))))) 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 = 693 OR c11_ . produit_id = 693 )) WHERE p8_ . id = p0_ . id ))) ORDER BY p0_ . created DESC ;
Copy
19
0.35 ms
SELECT t0 . id AS id_1 , t0 . variable AS variable_2 , t0 . valeur AS valeur_3 , t0 . format AS format_4 , t0 . commentaire AS commentaire_5 FROM parametre t0 WHERE t0 . variable = ? LIMIT 1
Parameters :
[
"twitter-compte "
]
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 = 'twitter-compte' LIMIT 1 ;
Copy
20
1.34 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
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
Copy
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 = 1 ORDER BY s1_ . position ASC ;
Copy
21
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 . parent_id = ?
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 = ?
Copy
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 = 13 ;
Copy
22
0.36 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . parent_id = ?
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 = ?
Copy
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 = 30 ;
Copy
23
0.37 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . parent_id = ?
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 = ?
Copy
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 = 60 ;
Copy
24
0.33 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . parent_id = ?
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 = ?
Copy
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 = 9 ;
Copy
25
0.37 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . parent_id = ?
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 = ?
Copy
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 = 46 ;
Copy
26
0.56 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
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 = 13 ORDER BY t0 . ordre ASC ;
Copy
27
4.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 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
13
226
216
215
218
219
220
229
217
26
132
164
37
4
162
19
5
163
0.0
13
13
13
13
]
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
Copy
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 = 1 AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND (((p1_ . id = 13 ) OR (c3_ . id IN (226 , 216 , 215 , 218 , 219 , 220 , 229 , 217 , 26 , 132 , 164 , 37 , 4 , 162 , 19 , 5 , 163 ) AND c3_ . id IS NOT NULL ))) AND ((p0_ . montant_min IS NULL OR p0_ . montant_min < = 0 )) 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 = 13 OR p6_ . id = 13 ))))) 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 = 13 OR c11_ . produit_id = 13 )) WHERE p8_ . id = p0_ . id ))) ORDER BY p0_ . created DESC ;
Copy
28
0.37 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 = ?
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 = 226 ;
Copy
29
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
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 = 13 ORDER BY t0 . id ASC ;
Copy
30
0.48 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 = ?
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 = 1 ;
Copy
31
0.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
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 = 30 ORDER BY t0 . ordre ASC ;
Copy
32
4.44 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . visible AS visible_1 , p0_ . page AS page_2 , p0_ . created AS created_3 , p0_ . updated AS updated_4 , p0_ . date_debut AS date_debut_5 , p0_ . date_fin AS date_fin_6 , p0_ . titre AS titre_7 , p0_ . slug AS slug_8 , p0_ . contenu AS contenu_9 , p0_ . image_name AS image_name_10 , p0_ . image_updated_at AS image_updated_at_11 , p0_ . typage AS typage_12 , p0_ . montant AS montant_13 , p0_ . montant_min AS montant_min_14 , p0_ . customer_order_count_min AS customer_order_count_min_15 , p0_ . customer_order_count_max AS customer_order_count_max_16 , p0_ . customer_lifetime_spent_min AS customer_lifetime_spent_min_17 , p0_ . customer_lifetime_spent_max AS customer_lifetime_spent_max_18 , p0_ . customer_account_age_days_min AS customer_account_age_days_min_19 , p0_ . customer_account_age_days_max AS customer_account_age_days_max_20 , p0_ . y_offert AS y_offert_21 , p0_ . meta_title AS meta_title_22 , p0_ . meta_keyword AS meta_keyword_23 , p0_ . meta_description AS meta_description_24 , p0_ . produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_ . id = p2_ . promotion_id LEFT JOIN produit p1_ ON p1_ . id = p2_ . produit_id LEFT JOIN promotion_categorie p4_ ON p0_ . id = p4_ . promotion_id LEFT JOIN categorie c3_ ON c3_ . id = p4_ . categorie_id WHERE p0_ . visible = ? AND ((p0_ . date_fin > = ? OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = ? OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = ? OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = ? OR p0_ . date_debut IS NULL )) AND (((p1_ . id = ? ) OR (c3_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND c3_ . id IS NOT NULL ))) AND ((p0_ . montant_min IS NULL OR p0_ . montant_min < = ? )) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_ . id = p7_ . promotion_id INNER JOIN produit p6_ ON p6_ . id = p7_ . produit_id WHERE p5_ . id = p0_ . id AND ((p6_ . id = ? OR p6_ . id = ? ))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_ . id = p10_ . promotion_id INNER JOIN categorie c9_ ON c9_ . id = p10_ . categorie_id INNER JOIN categorie_produit c11_ ON (c11_ . categorie_id = c9_ . id AND (c11_ . produit_id = ? OR c11_ . produit_id = ? )) WHERE p8_ . id = p0_ . id ))) ORDER BY p0_ . created DESC
Parameters :
[
1
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
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
]
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
Copy
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 = 1 AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND (((p1_ . id = 30 ) OR (c3_ . id IN (64 , 226 , 215 , 216 , 217 , 218 , 219 , 220 , 229 , 181 , 185 , 26 , 190 , 175 , 174 , 46 , 37 , 19 , 4 , 5 , 59 ) AND c3_ . id IS NOT NULL ))) AND ((p0_ . montant_min IS NULL OR p0_ . montant_min < = 0 )) 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 = 30 OR p6_ . id = 30 ))))) 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 = 30 OR c11_ . produit_id = 30 )) WHERE p8_ . id = p0_ . id ))) ORDER BY p0_ . created DESC ;
Copy
33
0.35 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 = ?
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 = 64 ;
Copy
34
0.26 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 30 ORDER BY t0 . id ASC ;
Copy
35
0.30 ms
SELECT t0 . id AS id_1 , t0 . ordre AS ordre_2 , t0 . produit_id AS produit_id_3 , t0 . categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0 . produit_id = ? ORDER BY t0 . ordre ASC
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 = 9 ORDER BY t0 . ordre ASC ;
Copy
36
3.37 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 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
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
]
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
Copy
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 = 1 AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND (((p1_ . id = 9 ) OR (c3_ . id IN (65 , 226 , 229 , 220 , 219 , 218 , 217 , 216 , 215 , 214 , 21 , 58 , 83 , 19 , 5 , 2 , 9 , 59 ) AND c3_ . id IS NOT NULL ))) AND ((p0_ . montant_min IS NULL OR p0_ . montant_min < = 0 )) 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 = 9 OR p6_ . id = 9 ))))) 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 = 9 OR c11_ . produit_id = 9 )) WHERE p8_ . id = p0_ . id ))) ORDER BY p0_ . created DESC ;
Copy
37
0.33 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 = ?
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 = 65 ;
Copy
38
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
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 = 9 ORDER BY t0 . id ASC ;
Copy
39
0.23 ms
SELECT t0 . id AS id_1 , t0 . valeur AS valeur_2 , t0 . groupe AS groupe_3 , t0 . ordre AS ordre_4 , t0 . image_name AS image_name_5 , t0 . image_updated_at AS image_updated_at_6 , t0 . attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0 . id = ?
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 = 8 ;
Copy
40
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
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 = 46 ORDER BY t0 . ordre ASC ;
Copy
41
3.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 (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 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
"2026-09-24 17:25:17 "
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
]
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
Copy
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 = 1 AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:25:17' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:25:17' OR p0_ . date_debut IS NULL )) AND (((p1_ . id = 46 ) OR (c3_ . id IN (63 , 226 , 223 , 229 , 220 , 219 , 218 , 217 , 175 , 29 , 174 , 46 , 190 , 166 , 185 , 36 , 20 , 4 , 163 , 5 , 162 , 59 , 3 ) AND c3_ . id IS NOT NULL ))) AND ((p0_ . montant_min IS NULL OR p0_ . montant_min < = 0 )) 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 = 46 OR p6_ . id = 46 ))))) 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 = 46 OR c11_ . produit_id = 46 )) WHERE p8_ . id = p0_ . id ))) ORDER BY p0_ . created DESC ;
Copy
42
0.25 ms
SELECT t0 . id AS id_1 , t0 . created AS created_2 , t0 . updated AS updated_3 , t0 . color AS color_4 , t0 . with_associated_page AS with_associated_page_5 , t0 . system AS system_6 , t0 . auto AS auto_7 , t0 . show_in_search AS show_in_search_8 , t0 . total_ca AS total_ca_9 , t0 . count_commande AS count_commande_10 , t0 . titre AS titre_11 , t0 . slug AS slug_12 FROM categorie t0 WHERE t0 . id = ?
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 = 63 ;
Copy
43
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
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 = 46 ORDER BY t0 . id ASC ;
Copy
44
0.25 ms
SELECT t0 . id AS id_1 , t0 . valeur AS valeur_2 , t0 . groupe AS groupe_3 , t0 . ordre AS ordre_4 , t0 . image_name AS image_name_5 , t0 . image_updated_at AS image_updated_at_6 , t0 . attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0 . id = ?
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 = 12 ;
Copy