1
1.41 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_ . slug = ?
Parameters :
[
"cadeau-a-moins-de-20-eur "
]
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_ . slug = 'cadeau-a-moins-de-20-eur' ;
Copy
2
0.93 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
3
5.28 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
4
15.36 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
5
9.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
6
3.07 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
7
0.36 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:33:51 "
"2026-09-24 17:33:51 "
]
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:33:51' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:51' OR p0_ . date_debut IS NULL )) ORDER BY p0_ . date_debut DESC LIMIT 1 ;
Copy
8
0.81 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 INNER JOIN listing_produit ON t0 . id = listing_produit . produit_id WHERE listing_produit . listing_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
INNER JOIN listing_produit ON t0 . id = listing_produit . produit_id
WHERE
listing_produit . listing_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 INNER JOIN listing_produit ON t0 . id = listing_produit . produit_id WHERE listing_produit . listing_id = 38 ;
Copy
9
0.36 ms
SELECT t0 . id AS id_1 , t0 . created AS created_2 , t0 . updated AS updated_3 , t0 . color AS color_4 , t0 . with_associated_page AS with_associated_page_5 , t0 . system AS system_6 , t0 . auto AS auto_7 , t0 . show_in_search AS show_in_search_8 , t0 . total_ca AS total_ca_9 , t0 . count_commande AS count_commande_10 , t0 . titre AS titre_11 , t0 . slug AS slug_12 FROM categorie t0 INNER JOIN listing_categorie ON t0 . id = listing_categorie . categorie_id WHERE listing_categorie . listing_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 INNER JOIN listing_categorie ON t0 . id = listing_categorie . categorie_id WHERE listing_categorie . listing_id = 38 ;
Copy
10
2.36 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 , COALESCE (MIN (c1_ . ordre ), 99999 ) AS sclr_52 , p0_ . parent_id AS parent_id_53 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id WHERE p0_ . visible = ? AND ((p0_ . cadeau IS NULL OR p0_ . cadeau = 0 )) AND ((p0_ . declinaison IS NULL OR p0_ . declinaison = 0 )) AND (c1_ . categorie_id IN (? )) GROUP BY p0_ . id ORDER BY sclr_52 ASC , p0_ . id DESC
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 ,
COALESCE (
MIN (c1_ . ordre ),
99999
) AS sclr_52 ,
p0_ . parent_id AS parent_id_53
FROM
produit p0_
LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id
WHERE
p0_ . visible = ?
AND (
(
p0_ . cadeau IS NULL
OR p0_ . cadeau = 0
)
)
AND (
(
p0_ . declinaison IS NULL
OR p0_ . declinaison = 0
)
)
AND (
c1_ . categorie_id IN (? )
)
GROUP BY
p0_ . id
ORDER BY
sclr_52 ASC ,
p0_ . id DESC
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 , COALESCE (MIN (c1_ . ordre ), 99999 ) AS sclr_52 , p0_ . parent_id AS parent_id_53 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id WHERE p0_ . visible = 1 AND ((p0_ . cadeau IS NULL OR p0_ . cadeau = 0 )) AND ((p0_ . declinaison IS NULL OR p0_ . declinaison = 0 )) AND (c1_ . categorie_id IN (38 )) GROUP BY p0_ . id ORDER BY sclr_52 ASC , p0_ . id DESC ;
Copy
11
0.45 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 = 949 ORDER BY t0 . id ASC ;
Copy
12
0.37 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 949 ORDER BY t0 . id ASC ;
Copy
13
0.33 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 858 ORDER BY t0 . id ASC ;
Copy
14
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 858 ORDER BY t0 . id ASC ;
Copy
15
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 857 ORDER BY t0 . id ASC ;
Copy
16
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 857 ORDER BY t0 . id ASC ;
Copy
17
5.11 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 = 822 ORDER BY t0 . id ASC ;
Copy
18
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 822 ORDER BY t0 . id ASC ;
Copy
19
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 = 824 ORDER BY t0 . id ASC ;
Copy
20
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 824 ORDER BY t0 . id ASC ;
Copy
21
0.22 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 828 ORDER BY t0 . id ASC ;
Copy
22
0.27 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 828 ORDER BY t0 . id ASC ;
Copy
23
0.27 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 825 ORDER BY t0 . id ASC ;
Copy
24
0.30 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 825 ORDER BY t0 . id ASC ;
Copy
25
0.27 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 827 ORDER BY t0 . id ASC ;
Copy
26
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 827 ORDER BY t0 . id ASC ;
Copy
27
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 826 ORDER BY t0 . id ASC ;
Copy
28
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 826 ORDER BY t0 . id ASC ;
Copy
29
0.62 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 787 ORDER BY t0 . id ASC ;
Copy
30
1.38 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 787 ORDER BY t0 . id ASC ;
Copy
31
0.22 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 729 ORDER BY t0 . id ASC ;
Copy
32
0.28 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 729 ORDER BY t0 . id ASC ;
Copy
33
0.30 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 = 704 ORDER BY t0 . id ASC ;
Copy
34
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 704 ORDER BY t0 . id ASC ;
Copy
35
3.27 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 703 ORDER BY t0 . id ASC ;
Copy
36
0.44 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 703 ORDER BY t0 . id ASC ;
Copy
37
0.28 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 702 ORDER BY t0 . id ASC ;
Copy
38
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 702 ORDER BY t0 . id ASC ;
Copy
39
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 = 663 ORDER BY t0 . id ASC ;
Copy
40
0.26 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 663 ORDER BY t0 . id ASC ;
Copy
41
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 655 ORDER BY t0 . id ASC ;
Copy
42
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 655 ORDER BY t0 . id ASC ;
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 = 654 ORDER BY t0 . id ASC ;
Copy
44
1.80 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 654 ORDER BY t0 . id ASC ;
Copy
45
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 = 652 ORDER BY t0 . id ASC ;
Copy
46
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 652 ORDER BY t0 . id ASC ;
Copy
47
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 = 644 ORDER BY t0 . id ASC ;
Copy
48
0.22 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 644 ORDER BY t0 . id ASC ;
Copy
49
6.11 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 = 643 ORDER BY t0 . id ASC ;
Copy
50
0.33 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 643 ORDER BY t0 . id ASC ;
Copy
51
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 = 617 ORDER BY t0 . id ASC ;
Copy
52
6.12 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 617 ORDER BY t0 . id ASC ;
Copy
53
0.53 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 = 631 ORDER BY t0 . id ASC ;
Copy
54
0.30 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 631 ORDER BY t0 . id ASC ;
Copy
55
0.38 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 627 ORDER BY t0 . id ASC ;
Copy
56
0.78 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 627 ORDER BY t0 . id ASC ;
Copy
57
1.77 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 596 ORDER BY t0 . id ASC ;
Copy
58
0.47 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 596 ORDER BY t0 . id ASC ;
Copy
59
1.67 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 = 595 ORDER BY t0 . id ASC ;
Copy
60
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 595 ORDER BY t0 . id ASC ;
Copy
61
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 = 594 ORDER BY t0 . id ASC ;
Copy
62
0.28 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 594 ORDER BY t0 . id ASC ;
Copy
63
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 576 ORDER BY t0 . id ASC ;
Copy
64
0.22 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 576 ORDER BY t0 . id ASC ;
Copy
65
1.80 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 = 575 ORDER BY t0 . id ASC ;
Copy
66
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 575 ORDER BY t0 . id ASC ;
Copy
67
0.19 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 = 574 ORDER BY t0 . id ASC ;
Copy
68
0.24 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 574 ORDER BY t0 . id ASC ;
Copy
69
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 = 560 ORDER BY t0 . id ASC ;
Copy
70
0.90 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 560 ORDER BY t0 . id ASC ;
Copy
71
0.51 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 559 ORDER BY t0 . id ASC ;
Copy
72
1.59 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 559 ORDER BY t0 . id ASC ;
Copy
73
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 564 ORDER BY t0 . id ASC ;
Copy
74
11.20 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 564 ORDER BY t0 . id ASC ;
Copy
75
0.35 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 563 ORDER BY t0 . id ASC ;
Copy
76
3.26 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 563 ORDER BY t0 . id ASC ;
Copy
77
0.28 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 562 ORDER BY t0 . id ASC ;
Copy
78
0.26 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 562 ORDER BY t0 . id ASC ;
Copy
79
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 561 ORDER BY t0 . id ASC ;
Copy
80
0.28 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 561 ORDER BY t0 . id ASC ;
Copy
81
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 96 ORDER BY t0 . id ASC ;
Copy
82
0.20 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 96 ORDER BY t0 . id ASC ;
Copy
83
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 97 ORDER BY t0 . id ASC ;
Copy
84
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 97 ORDER BY t0 . id ASC ;
Copy
85
0.19 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 = 98 ORDER BY t0 . id ASC ;
Copy
86
0.99 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 98 ORDER BY t0 . id ASC ;
Copy
87
0.61 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 99 ORDER BY t0 . id ASC ;
Copy
88
1.86 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 99 ORDER BY t0 . id ASC ;
Copy
89
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 100 ORDER BY t0 . id ASC ;
Copy
90
0.20 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 100 ORDER BY t0 . id ASC ;
Copy
91
0.20 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 101 ORDER BY t0 . id ASC ;
Copy
92
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 101 ORDER BY t0 . id ASC ;
Copy
93
1.52 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 26 ORDER BY t0 . id ASC ;
Copy
94
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 26 ORDER BY t0 . id ASC ;
Copy
95
0.20 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 21 ORDER BY t0 . id ASC ;
Copy
96
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 21 ORDER BY t0 . id ASC ;
Copy
97
0.19 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 = 31 ORDER BY t0 . id ASC ;
Copy
98
0.19 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 31 ORDER BY t0 . id ASC ;
Copy
99
5.97 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 = 43 ORDER BY t0 . id ASC ;
Copy
100
0.29 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 43 ORDER BY t0 . id ASC ;
Copy
101
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 = 115 ORDER BY t0 . id ASC ;
Copy
102
0.26 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 115 ORDER BY t0 . id ASC ;
Copy
103
0.40 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 120 ORDER BY t0 . id ASC ;
Copy
104
0.24 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 120 ORDER BY t0 . id ASC ;
Copy
105
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 50 ORDER BY t0 . id ASC ;
Copy
106
0.19 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 50 ORDER BY t0 . id ASC ;
Copy
107
0.21 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 51 ORDER BY t0 . id ASC ;
Copy
108
0.45 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 51 ORDER BY t0 . id ASC ;
Copy
109
4.39 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 52 ORDER BY t0 . id ASC ;
Copy
110
0.28 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 52 ORDER BY t0 . id ASC ;
Copy
111
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 = 6 ORDER BY t0 . id ASC ;
Copy
112
0.91 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 6 ORDER BY t0 . id ASC ;
Copy
113
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 94 ORDER BY t0 . id ASC ;
Copy
114
3.38 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 94 ORDER BY t0 . id ASC ;
Copy
115
0.28 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 95 ORDER BY t0 . id ASC ;
Copy
116
0.39 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 95 ORDER BY t0 . id ASC ;
Copy
117
0.92 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 = 114 ORDER BY t0 . id ASC ;
Copy
118
0.24 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 114 ORDER BY t0 . id ASC ;
Copy
119
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 = 129 ORDER BY t0 . id ASC ;
Copy
120
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 129 ORDER BY t0 . id ASC ;
Copy
121
1.46 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 128 ORDER BY t0 . id ASC ;
Copy
122
0.24 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 128 ORDER BY t0 . id ASC ;
Copy
123
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 = 170 ORDER BY t0 . id ASC ;
Copy
124
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 170 ORDER BY t0 . id ASC ;
Copy
125
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 221 ORDER BY t0 . id ASC ;
Copy
126
2.76 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 221 ORDER BY t0 . id ASC ;
Copy
127
0.30 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 = 222 ORDER BY t0 . id ASC ;
Copy
128
0.38 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 222 ORDER BY t0 . id ASC ;
Copy
129
0.30 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 = 268 ORDER BY t0 . id ASC ;
Copy
130
0.24 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 268 ORDER BY t0 . id ASC ;
Copy
131
0.29 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 269 ORDER BY t0 . id ASC ;
Copy
132
0.28 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 269 ORDER BY t0 . id ASC ;
Copy
133
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 = 270 ORDER BY t0 . id ASC ;
Copy
134
2.48 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 270 ORDER BY t0 . id ASC ;
Copy
135
1.09 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 = 271 ORDER BY t0 . id ASC ;
Copy
136
0.27 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 271 ORDER BY t0 . id ASC ;
Copy
137
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 327 ORDER BY t0 . id ASC ;
Copy
138
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 327 ORDER BY t0 . id ASC ;
Copy
139
0.33 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 332 ORDER BY t0 . id ASC ;
Copy
140
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 332 ORDER BY t0 . id ASC ;
Copy
141
1.61 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 2 ORDER BY t0 . id ASC ;
Copy
142
0.26 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 2 ORDER BY t0 . id ASC ;
Copy
143
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 19 ORDER BY t0 . id ASC ;
Copy
144
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 19 ORDER BY t0 . id ASC ;
Copy
145
0.22 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 8 ORDER BY t0 . id ASC ;
Copy
146
3.15 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 8 ORDER BY t0 . id ASC ;
Copy
147
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 = 10 ORDER BY t0 . id ASC ;
Copy
148
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 10 ORDER BY t0 . id ASC ;
Copy
149
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 12 ORDER BY t0 . id ASC ;
Copy
150
0.27 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 12 ORDER BY t0 . id ASC ;
Copy
151
0.27 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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 = 49 ORDER BY t0 . id ASC ;
Copy
152
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 49 ORDER BY t0 . id ASC ;
Copy
153
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 383 ORDER BY t0 . id ASC ;
Copy
154
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 383 ORDER BY t0 . id ASC ;
Copy
155
0.23 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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 = 384 ORDER BY t0 . id ASC ;
Copy
156
1.75 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 384 ORDER BY t0 . id ASC ;
Copy
157
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 = 385 ORDER BY t0 . id ASC ;
Copy
158
0.27 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 385 ORDER BY t0 . id ASC ;
Copy
159
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 = 598 ORDER BY t0 . id ASC ;
Copy
160
0.29 ms
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . produit_id AS produit_id_2 , t0 . caracteristique_id AS caracteristique_id_3 , t0 . caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0 . produit_id = 598 ORDER BY t0 . id ASC ;
Copy
161
3.33 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
162
3.45 ms
SELECT COUNT (* ) AS dctrn_count FROM (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 , COALESCE (MIN (c1_ . ordre ), 99999 ) AS sclr_52 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id WHERE p0_ . visible = ? AND ((p0_ . cadeau IS NULL OR p0_ . cadeau = 0 )) AND ((p0_ . declinaison IS NULL OR p0_ . declinaison = 0 )) AND (c1_ . categorie_id IN (? )) GROUP BY p0_ . id ORDER BY sclr_52 ASC , p0_ . id DESC ) dctrn_table
SELECT
COUNT (* ) AS dctrn_count
FROM
(
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 ,
COALESCE (
MIN (c1_ . ordre ),
99999
) AS sclr_52
FROM
produit p0_
LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id
WHERE
p0_ . visible = ?
AND (
(
p0_ . cadeau IS NULL
OR p0_ . cadeau = 0
)
)
AND (
(
p0_ . declinaison IS NULL
OR p0_ . declinaison = 0
)
)
AND (
c1_ . categorie_id IN (? )
)
GROUP BY
p0_ . id
ORDER BY
sclr_52 ASC ,
p0_ . id DESC
) dctrn_table
Copy
SELECT COUNT (* ) AS dctrn_count FROM (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 , COALESCE (MIN (c1_ . ordre ), 99999 ) AS sclr_52 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id WHERE p0_ . visible = 1 AND ((p0_ . cadeau IS NULL OR p0_ . cadeau = 0 )) AND ((p0_ . declinaison IS NULL OR p0_ . declinaison = 0 )) AND (c1_ . categorie_id IN (38 )) GROUP BY p0_ . id ORDER BY sclr_52 ASC , p0_ . id DESC ) dctrn_table ;
Copy
163
3.52 ms
SELECT DISTINCT id_2 FROM (SELECT DISTINCT id_2 , sclr_52 FROM (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 , COALESCE (MIN (c1_ . ordre ), 99999 ) AS sclr_52 , c1_ . id AS id_53 , c1_ . ordre AS ordre_54 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id WHERE p0_ . visible = ? AND ((p0_ . cadeau IS NULL OR p0_ . cadeau = 0 )) AND ((p0_ . declinaison IS NULL OR p0_ . declinaison = 0 )) AND (c1_ . categorie_id IN (? )) GROUP BY p0_ . id ORDER BY c1_ . ordre ASC ) dctrn_result_inner ORDER BY sclr_52 ASC , id_2 DESC ) dctrn_result LIMIT 40
SELECT
DISTINCT id_2
FROM
(
SELECT
DISTINCT id_2 ,
sclr_52
FROM
(
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 ,
COALESCE (
MIN (c1_ . ordre ),
99999
) AS sclr_52 ,
c1_ . id AS id_53 ,
c1_ . ordre AS ordre_54
FROM
produit p0_
LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id
WHERE
p0_ . visible = ?
AND (
(
p0_ . cadeau IS NULL
OR p0_ . cadeau = 0
)
)
AND (
(
p0_ . declinaison IS NULL
OR p0_ . declinaison = 0
)
)
AND (
c1_ . categorie_id IN (? )
)
GROUP BY
p0_ . id
ORDER BY
c1_ . ordre ASC
) dctrn_result_inner
ORDER BY
sclr_52 ASC ,
id_2 DESC
) dctrn_result
LIMIT
40
Copy
SELECT DISTINCT id_2 FROM (SELECT DISTINCT id_2 , sclr_52 FROM (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 , COALESCE (MIN (c1_ . ordre ), 99999 ) AS sclr_52 , c1_ . id AS id_53 , c1_ . ordre AS ordre_54 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id WHERE p0_ . visible = 1 AND ((p0_ . cadeau IS NULL OR p0_ . cadeau = 0 )) AND ((p0_ . declinaison IS NULL OR p0_ . declinaison = 0 )) AND (c1_ . categorie_id IN (38 )) GROUP BY p0_ . id ORDER BY c1_ . ordre ASC ) dctrn_result_inner ORDER BY sclr_52 ASC , id_2 DESC ) dctrn_result LIMIT 40 ;
Copy
164
5.16 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 , COALESCE (MIN (c1_ . ordre ), 99999 ) AS sclr_52 , p0_ . parent_id AS parent_id_53 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id WHERE p0_ . visible = ? AND ((p0_ . cadeau IS NULL OR p0_ . cadeau = 0 )) AND ((p0_ . declinaison IS NULL OR p0_ . declinaison = 0 )) AND (c1_ . categorie_id IN (? )) AND p0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) GROUP BY p0_ . id ORDER BY sclr_52 ASC , p0_ . id DESC
Parameters :
[
1
38
949
858
857
822
824
828
825
827
826
787
729
704
703
702
663
655
654
652
644
643
617
631
627
596
595
594
576
575
574
560
559
564
563
562
561
96
97
98
99
100
]
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 ,
COALESCE (
MIN (c1_ . ordre ),
99999
) AS sclr_52 ,
p0_ . parent_id AS parent_id_53
FROM
produit p0_
LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id
WHERE
p0_ . visible = ?
AND (
(
p0_ . cadeau IS NULL
OR p0_ . cadeau = 0
)
)
AND (
(
p0_ . declinaison IS NULL
OR p0_ . declinaison = 0
)
)
AND (
c1_ . categorie_id IN (? )
)
AND p0_ . id IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ?
)
GROUP BY
p0_ . id
ORDER BY
sclr_52 ASC ,
p0_ . id DESC
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 , COALESCE (MIN (c1_ . ordre ), 99999 ) AS sclr_52 , p0_ . parent_id AS parent_id_53 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_ . id = c1_ . produit_id WHERE p0_ . visible = 1 AND ((p0_ . cadeau IS NULL OR p0_ . cadeau = 0 )) AND ((p0_ . declinaison IS NULL OR p0_ . declinaison = 0 )) AND (c1_ . categorie_id IN (38 )) AND p0_ . id IN (949 , 858 , 857 , 822 , 824 , 828 , 825 , 827 , 826 , 787 , 729 , 704 , 703 , 702 , 663 , 655 , 654 , 652 , 644 , 643 , 617 , 631 , 627 , 596 , 595 , 594 , 576 , 575 , 574 , 560 , 559 , 564 , 563 , 562 , 561 , 96 , 97 , 98 , 99 , 100 ) GROUP BY p0_ . id ORDER BY sclr_52 ASC , p0_ . id DESC ;
Copy
165
2.60 ms
SELECT a0_ . id AS id_0 , a0_ . valeur AS valeur_1 , a0_ . groupe AS groupe_2 , a0_ . ordre AS ordre_3 , a0_ . image_name AS image_name_4 , a0_ . image_updated_at AS image_updated_at_5 , a0_ . attribut_id AS attribut_id_6 FROM attribut_valeur a0_ WHERE a0_ . attribut_id = ? ORDER BY a0_ . ordre ASC
SELECT a0_ . id AS id_0 , a0_ . valeur AS valeur_1 , a0_ . groupe AS groupe_2 , a0_ . ordre AS ordre_3 , a0_ . image_name AS image_name_4 , a0_ . image_updated_at AS image_updated_at_5 , a0_ . attribut_id AS attribut_id_6 FROM attribut_valeur a0_ WHERE a0_ . attribut_id = '1' ORDER BY a0_ . ordre ASC ;
Copy
166
1.83 ms
SELECT c0_ . id AS id_0 , c0_ . valeur AS valeur_1 , c0_ . ordre AS ordre_2 , c0_ . color AS color_3 , c0_ . image_name AS image_name_4 , c0_ . image_updated_at AS image_updated_at_5 , c0_ . caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_ . caracteristique_id = ? ORDER BY c0_ . ordre ASC
SELECT c0_ . id AS id_0 , c0_ . valeur AS valeur_1 , c0_ . ordre AS ordre_2 , c0_ . color AS color_3 , c0_ . image_name AS image_name_4 , c0_ . image_updated_at AS image_updated_at_5 , c0_ . caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_ . caracteristique_id = '3' ORDER BY c0_ . ordre ASC ;
Copy
167
0.44 ms
SELECT c0_ . id AS id_0 , c0_ . valeur AS valeur_1 , c0_ . ordre AS ordre_2 , c0_ . color AS color_3 , c0_ . image_name AS image_name_4 , c0_ . image_updated_at AS image_updated_at_5 , c0_ . caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_ . caracteristique_id = ? ORDER BY c0_ . ordre ASC
SELECT c0_ . id AS id_0 , c0_ . valeur AS valeur_1 , c0_ . ordre AS ordre_2 , c0_ . color AS color_3 , c0_ . image_name AS image_name_4 , c0_ . image_updated_at AS image_updated_at_5 , c0_ . caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_ . caracteristique_id = '4' ORDER BY c0_ . ordre ASC ;
Copy
168
0.24 ms
SELECT c0_ . id AS id_0 , c0_ . valeur AS valeur_1 , c0_ . ordre AS ordre_2 , c0_ . color AS color_3 , c0_ . image_name AS image_name_4 , c0_ . image_updated_at AS image_updated_at_5 , c0_ . caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_ . caracteristique_id = ? ORDER BY c0_ . ordre ASC
SELECT c0_ . id AS id_0 , c0_ . valeur AS valeur_1 , c0_ . ordre AS ordre_2 , c0_ . color AS color_3 , c0_ . image_name AS image_name_4 , c0_ . image_updated_at AS image_updated_at_5 , c0_ . caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_ . caracteristique_id = '1' ORDER BY c0_ . ordre ASC ;
Copy
169
0.42 ms
SELECT t0 . id AS id_1 , t0 . variable AS variable_2 , t0 . valeur AS valeur_3 , t0 . format AS format_4 , t0 . commentaire AS commentaire_5 FROM parametre t0 WHERE t0 . variable = ? LIMIT 1
Parameters :
[
"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
170
1.18 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
171
4.49 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
172
11.73 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
173
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 = 60 ;
Copy
174
0.41 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . parent_id = ?
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
175
0.39 ms
SELECT t0 . created AS created_1 , t0 . updated AS updated_2 , t0 . id AS id_3 , t0 . visible AS visible_4 , t0 . archive AS archive_5 , t0 . exclude_columbus AS exclude_columbus_6 , t0 . nouveau AS nouveau_7 , t0 . precommande AS precommande_8 , t0 . precommande_date AS precommande_date_9 , t0 . offre_speciale AS offre_speciale_10 , t0 . cadeau AS cadeau_11 , t0 . goodie AS goodie_12 , t0 . declinaison AS declinaison_13 , t0 . declinaison_principale AS declinaison_principale_14 , t0 . reference AS reference_15 , t0 . titre AS titre_16 , t0 . titre_brouillon AS titre_brouillon_17 , t0 . contenu AS contenu_18 , t0 . contenu_brouillon AS contenu_brouillon_19 , t0 . contenu2 AS contenu2_20 , t0 . contenu2_brouillon AS contenu2_brouillon_21 , t0 . slug AS slug_22 , t0 . prix_achat_ht AS prix_achat_ht_23 , t0 . montantHT AS montantHT_24 , t0 . montantTTC AS montantTTC_25 , t0 . montantActuelTTC AS montantActuelTTC_26 , t0 . tva AS tva_27 , t0 . stock AS stock_28 , t0 . alerte_stock AS alerte_stock_29 , t0 . stock_emaplacement AS stock_emaplacement_30 , t0 . poids AS poids_31 , t0 . recherche_keyword AS recherche_keyword_32 , t0 . recherche_slug AS recherche_slug_33 , t0 . recherche_carac_attr_slug AS recherche_carac_attr_slug_34 , t0 . produits_associes AS produits_associes_35 , t0 . meta_title AS meta_title_36 , t0 . meta_keyword AS meta_keyword_37 , t0 . meta_description AS meta_description_38 , t0 . note_avis AS note_avis_39 , t0 . nb_avis AS nb_avis_40 , t0 . image_panorama_name AS image_panorama_name_41 , t0 . image_panorama_updated_at AS image_panorama_updated_at_42 , t0 . image_portrait_name AS image_portrait_name_43 , t0 . image_portrait_updated_at AS image_portrait_updated_at_44 , t0 . image_name AS image_name_45 , t0 . image_updated_at AS image_updated_at_46 , t0 . image_alt AS image_alt_47 , t0 . image_name_brouillon AS image_name_brouillon_48 , t0 . image_updated_at_brouillon AS image_updated_at_brouillon_49 , t0 . total_ca AS total_ca_50 , t0 . count_commande AS count_commande_51 , t0 . is_customizable AS is_customizable_52 , t0 . parent_id AS parent_id_53 FROM produit t0 WHERE t0 . parent_id = ?
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
176
0.40 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
177
2.80 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:33:52 "
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
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:33:52' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:52' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:33:52' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:52' 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
178
3.76 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
179
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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
180
0.31 ms
SELECT t0 . id AS id_1 , t0 . ordre AS ordre_2 , t0 . produit_id AS produit_id_3 , t0 . categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0 . produit_id = ? ORDER BY t0 . ordre ASC
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
181
3.05 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . visible AS visible_1 , p0_ . page AS page_2 , p0_ . created AS created_3 , p0_ . updated AS updated_4 , p0_ . date_debut AS date_debut_5 , p0_ . date_fin AS date_fin_6 , p0_ . titre AS titre_7 , p0_ . slug AS slug_8 , p0_ . contenu AS contenu_9 , p0_ . image_name AS image_name_10 , p0_ . image_updated_at AS image_updated_at_11 , p0_ . typage AS typage_12 , p0_ . montant AS montant_13 , p0_ . montant_min AS montant_min_14 , p0_ . customer_order_count_min AS customer_order_count_min_15 , p0_ . customer_order_count_max AS customer_order_count_max_16 , p0_ . customer_lifetime_spent_min AS customer_lifetime_spent_min_17 , p0_ . customer_lifetime_spent_max AS customer_lifetime_spent_max_18 , p0_ . customer_account_age_days_min AS customer_account_age_days_min_19 , p0_ . customer_account_age_days_max AS customer_account_age_days_max_20 , p0_ . y_offert AS y_offert_21 , p0_ . meta_title AS meta_title_22 , p0_ . meta_keyword AS meta_keyword_23 , p0_ . meta_description AS meta_description_24 , p0_ . produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_ . id = p2_ . promotion_id LEFT JOIN produit p1_ ON p1_ . id = p2_ . produit_id LEFT JOIN promotion_categorie p4_ ON p0_ . id = p4_ . promotion_id LEFT JOIN categorie c3_ ON c3_ . id = p4_ . categorie_id WHERE p0_ . visible = ? AND ((p0_ . date_fin > = ? OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = ? OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = ? OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = ? OR p0_ . date_debut IS NULL )) AND (((p1_ . id = ? ) OR (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:33:52 "
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
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:33:52' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:52' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:33:52' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:52' 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
182
3.59 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
183
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
184
0.27 ms
SELECT t0 . id AS id_1 , t0 . ordre AS ordre_2 , t0 . produit_id AS produit_id_3 , t0 . categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0 . produit_id = ? ORDER BY t0 . ordre ASC
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
185
9.59 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:33:52 "
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
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:33:52' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:52' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:33:52' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:52' 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
186
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 = 65 ;
Copy
187
0.25 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? 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
188
0.32 ms
SELECT t0 . id AS id_1 , t0 . ordre AS ordre_2 , t0 . produit_id AS produit_id_3 , t0 . categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0 . produit_id = ? ORDER BY t0 . ordre ASC
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
189
2.53 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . visible AS visible_1 , p0_ . page AS page_2 , p0_ . created AS created_3 , p0_ . updated AS updated_4 , p0_ . date_debut AS date_debut_5 , p0_ . date_fin AS date_fin_6 , p0_ . titre AS titre_7 , p0_ . slug AS slug_8 , p0_ . contenu AS contenu_9 , p0_ . image_name AS image_name_10 , p0_ . image_updated_at AS image_updated_at_11 , p0_ . typage AS typage_12 , p0_ . montant AS montant_13 , p0_ . montant_min AS montant_min_14 , p0_ . customer_order_count_min AS customer_order_count_min_15 , p0_ . customer_order_count_max AS customer_order_count_max_16 , p0_ . customer_lifetime_spent_min AS customer_lifetime_spent_min_17 , p0_ . customer_lifetime_spent_max AS customer_lifetime_spent_max_18 , p0_ . customer_account_age_days_min AS customer_account_age_days_min_19 , p0_ . customer_account_age_days_max AS customer_account_age_days_max_20 , p0_ . y_offert AS y_offert_21 , p0_ . meta_title AS meta_title_22 , p0_ . meta_keyword AS meta_keyword_23 , p0_ . meta_description AS meta_description_24 , p0_ . produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_ . id = p2_ . promotion_id LEFT JOIN produit p1_ ON p1_ . id = p2_ . produit_id LEFT JOIN promotion_categorie p4_ ON p0_ . id = p4_ . promotion_id LEFT JOIN categorie c3_ ON c3_ . id = p4_ . categorie_id WHERE p0_ . visible = ? AND ((p0_ . date_fin > = ? OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = ? OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = ? OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = ? OR p0_ . date_debut IS NULL )) AND (((p1_ . id = ? ) OR (c3_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND c3_ . id IS NOT NULL ))) AND ((p0_ . montant_min IS NULL OR p0_ . montant_min < = ? )) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_ . id = p7_ . promotion_id INNER JOIN produit p6_ ON p6_ . id = p7_ . produit_id WHERE p5_ . id = p0_ . id AND ((p6_ . id = ? OR p6_ . id = ? ))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_ . id = p10_ . promotion_id INNER JOIN categorie c9_ ON c9_ . id = p10_ . categorie_id INNER JOIN categorie_produit c11_ ON (c11_ . categorie_id = c9_ . id AND (c11_ . produit_id = ? OR c11_ . produit_id = ? )) WHERE p8_ . id = p0_ . id ))) ORDER BY p0_ . created DESC
Parameters :
[
1
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
"2026-09-24 17:33:52 "
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:33:52' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:52' OR p0_ . date_debut IS NULL )) AND ((p0_ . date_fin > = '2026-09-24 17:33:52' OR p0_ . date_fin IS NULL )) AND ((p0_ . date_debut < = '2026-09-24 17:33:52' 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
190
0.26 ms
SELECT t0 . id AS id_1 , t0 . created AS created_2 , t0 . updated AS updated_3 , t0 . color AS color_4 , t0 . with_associated_page AS with_associated_page_5 , t0 . system AS system_6 , t0 . auto AS auto_7 , t0 . show_in_search AS show_in_search_8 , t0 . total_ca AS total_ca_9 , t0 . count_commande AS count_commande_10 , t0 . titre AS titre_11 , t0 . slug AS slug_12 FROM categorie t0 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
191
0.22 ms
SELECT t0 . id AS id_1 , t0 . produit_parent_id AS produit_parent_id_2 , t0 . produit_id AS produit_id_3 , t0 . attribut_id AS attribut_id_4 , t0 . attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0 . produit_id = ? ORDER BY t0 . id ASC
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