Symfony Profiler

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;

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;

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;

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;

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';

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

SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.visible AS visible_2, p0_.newsletter AS newsletter_3, p0_.date_debut AS date_debut_4, p0_.date_fin AS date_fin_5, p0_.url AS url_6, p0_.titre AS titre_7, p0_.contenu AS contenu_8 FROM popup p0_ WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:25:07' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:25:07' OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1;

SELECT
  p0_.created AS created_0,
  p0_.updated AS updated_1,
  p0_.id AS id_2,
  p0_.visible AS visible_3,
  p0_.archive AS archive_4,
  p0_.exclude_columbus AS exclude_columbus_5,
  p0_.nouveau AS nouveau_6,
  p0_.precommande AS precommande_7,
  p0_.precommande_date AS precommande_date_8,
  p0_.offre_speciale AS offre_speciale_9,
  p0_.cadeau AS cadeau_10,
  p0_.goodie AS goodie_11,
  p0_.declinaison AS declinaison_12,
  p0_.declinaison_principale AS declinaison_principale_13,
  p0_.reference AS reference_14,
  p0_.titre AS titre_15,
  p0_.titre_brouillon AS titre_brouillon_16,
  p0_.contenu AS contenu_17,
  p0_.contenu_brouillon AS contenu_brouillon_18,
  p0_.contenu2 AS contenu2_19,
  p0_.contenu2_brouillon AS contenu2_brouillon_20,
  p0_.slug AS slug_21,
  p0_.prix_achat_ht AS prix_achat_ht_22,
  p0_.montantHT AS montantHT_23,
  p0_.montantTTC AS montantTTC_24,
  p0_.montantActuelTTC AS montantActuelTTC_25,
  p0_.tva AS tva_26,
  p0_.stock AS stock_27,
  p0_.alerte_stock AS alerte_stock_28,
  p0_.stock_emaplacement AS stock_emaplacement_29,
  p0_.poids AS poids_30,
  p0_.recherche_keyword AS recherche_keyword_31,
  p0_.recherche_slug AS recherche_slug_32,
  p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33,
  p0_.produits_associes AS produits_associes_34,
  p0_.meta_title AS meta_title_35,
  p0_.meta_keyword AS meta_keyword_36,
  p0_.meta_description AS meta_description_37,
  p0_.note_avis AS note_avis_38,
  p0_.nb_avis AS nb_avis_39,
  p0_.image_panorama_name AS image_panorama_name_40,
  p0_.image_panorama_updated_at AS image_panorama_updated_at_41,
  p0_.image_portrait_name AS image_portrait_name_42,
  p0_.image_portrait_updated_at AS image_portrait_updated_at_43,
  p0_.image_name AS image_name_44,
  p0_.image_updated_at AS image_updated_at_45,
  p0_.image_alt AS image_alt_46,
  p0_.image_name_brouillon AS image_name_brouillon_47,
  p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48,
  p0_.total_ca AS total_ca_49,
  p0_.count_commande AS count_commande_50,
  p0_.is_customizable AS is_customizable_51,
  p0_.parent_id AS parent_id_52
FROM
  produit p0_
WHERE
  p0_.slug = ?

SELECT p0_.created AS created_0, p0_.updated AS updated_1, p0_.id AS id_2, p0_.visible AS visible_3, p0_.archive AS archive_4, p0_.exclude_columbus AS exclude_columbus_5, p0_.nouveau AS nouveau_6, p0_.precommande AS precommande_7, p0_.precommande_date AS precommande_date_8, p0_.offre_speciale AS offre_speciale_9, p0_.cadeau AS cadeau_10, p0_.goodie AS goodie_11, p0_.declinaison AS declinaison_12, p0_.declinaison_principale AS declinaison_principale_13, p0_.reference AS reference_14, p0_.titre AS titre_15, p0_.titre_brouillon AS titre_brouillon_16, p0_.contenu AS contenu_17, p0_.contenu_brouillon AS contenu_brouillon_18, p0_.contenu2 AS contenu2_19, p0_.contenu2_brouillon AS contenu2_brouillon_20, p0_.slug AS slug_21, p0_.prix_achat_ht AS prix_achat_ht_22, p0_.montantHT AS montantHT_23, p0_.montantTTC AS montantTTC_24, p0_.montantActuelTTC AS montantActuelTTC_25, p0_.tva AS tva_26, p0_.stock AS stock_27, p0_.alerte_stock AS alerte_stock_28, p0_.stock_emaplacement AS stock_emaplacement_29, p0_.poids AS poids_30, p0_.recherche_keyword AS recherche_keyword_31, p0_.recherche_slug AS recherche_slug_32, p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33, p0_.produits_associes AS produits_associes_34, p0_.meta_title AS meta_title_35, p0_.meta_keyword AS meta_keyword_36, p0_.meta_description AS meta_description_37, p0_.note_avis AS note_avis_38, p0_.nb_avis AS nb_avis_39, p0_.image_panorama_name AS image_panorama_name_40, p0_.image_panorama_updated_at AS image_panorama_updated_at_41, p0_.image_portrait_name AS image_portrait_name_42, p0_.image_portrait_updated_at AS image_portrait_updated_at_43, p0_.image_name AS image_name_44, p0_.image_updated_at AS image_updated_at_45, p0_.image_alt AS image_alt_46, p0_.image_name_brouillon AS image_name_brouillon_47, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48, p0_.total_ca AS total_ca_49, p0_.count_commande AS count_commande_50, p0_.is_customizable AS is_customizable_51, p0_.parent_id AS parent_id_52 FROM produit p0_ WHERE p0_.slug = 'marionnette-a-main-ours-25-cm';

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 = 11 ORDER BY t0.ordre ASC;

SELECT
  c0_.id AS id_0,
  c0_.ordre AS ordre_1,
  c0_.produit_id AS produit_id_2,
  c0_.categorie_id AS categorie_id_3
FROM
  categorie_produit c0_
  INNER JOIN produit p1_ ON c0_.produit_id = p1_.id
WHERE
  p1_.visible = ?
  AND c0_.categorie_id = ?
  AND c0_.produit_id NOT IN (11)
ORDER BY
  c0_.ordre ASC

SELECT c0_.id AS id_0, c0_.ordre AS ordre_1, c0_.produit_id AS produit_id_2, c0_.categorie_id AS categorie_id_3 FROM categorie_produit c0_ INNER JOIN produit p1_ ON c0_.produit_id = p1_.id WHERE p1_.visible = 1 AND c0_.categorie_id = 226 AND c0_.produit_id NOT IN (11) ORDER BY c0_.ordre ASC;

SELECT
  p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.created AS created_2,
  p0_.updated AS updated_3,
  p0_.date_debut AS date_debut_4,
  p0_.date_fin AS date_fin_5,
  p0_.remise AS remise_6
FROM
  pack p0_
  LEFT JOIN pack_produit p2_ ON p0_.id = p2_.pack_id
  LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND p1_.id = ?
ORDER BY
  p0_.created DESC

SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.created AS created_2, p0_.updated AS updated_3, p0_.date_debut AS date_debut_4, p0_.date_fin AS date_fin_5, p0_.remise AS remise_6 FROM pack p0_ LEFT JOIN pack_produit p2_ ON p0_.id = p2_.pack_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:25:07' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:25:07' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:25:07' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:25:07' OR p0_.date_debut IS NULL)) AND p1_.id = 11 ORDER BY p0_.created DESC;

SELECT
  t0.created AS created_1,
  t0.updated AS updated_2,
  t0.id AS id_3,
  t0.visible AS visible_4,
  t0.archive AS archive_5,
  t0.exclude_columbus AS exclude_columbus_6,
  t0.nouveau AS nouveau_7,
  t0.precommande AS precommande_8,
  t0.precommande_date AS precommande_date_9,
  t0.offre_speciale AS offre_speciale_10,
  t0.cadeau AS cadeau_11,
  t0.goodie AS goodie_12,
  t0.declinaison AS declinaison_13,
  t0.declinaison_principale AS declinaison_principale_14,
  t0.reference AS reference_15,
  t0.titre AS titre_16,
  t0.titre_brouillon AS titre_brouillon_17,
  t0.contenu AS contenu_18,
  t0.contenu_brouillon AS contenu_brouillon_19,
  t0.contenu2 AS contenu2_20,
  t0.contenu2_brouillon AS contenu2_brouillon_21,
  t0.slug AS slug_22,
  t0.prix_achat_ht AS prix_achat_ht_23,
  t0.montantHT AS montantHT_24,
  t0.montantTTC AS montantTTC_25,
  t0.montantActuelTTC AS montantActuelTTC_26,
  t0.tva AS tva_27,
  t0.stock AS stock_28,
  t0.alerte_stock AS alerte_stock_29,
  t0.stock_emaplacement AS stock_emaplacement_30,
  t0.poids AS poids_31,
  t0.recherche_keyword AS recherche_keyword_32,
  t0.recherche_slug AS recherche_slug_33,
  t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34,
  t0.produits_associes AS produits_associes_35,
  t0.meta_title AS meta_title_36,
  t0.meta_keyword AS meta_keyword_37,
  t0.meta_description AS meta_description_38,
  t0.note_avis AS note_avis_39,
  t0.nb_avis AS nb_avis_40,
  t0.image_panorama_name AS image_panorama_name_41,
  t0.image_panorama_updated_at AS image_panorama_updated_at_42,
  t0.image_portrait_name AS image_portrait_name_43,
  t0.image_portrait_updated_at AS image_portrait_updated_at_44,
  t0.image_name AS image_name_45,
  t0.image_updated_at AS image_updated_at_46,
  t0.image_alt AS image_alt_47,
  t0.image_name_brouillon AS image_name_brouillon_48,
  t0.image_updated_at_brouillon AS image_updated_at_brouillon_49,
  t0.total_ca AS total_ca_50,
  t0.count_commande AS count_commande_51,
  t0.is_customizable AS is_customizable_52,
  t0.parent_id AS parent_id_53
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = 981;

SELECT
  m0_.id AS id_0,
  m0_.date_debut AS date_debut_1,
  m0_.date_fin AS date_fin_2,
  m0_.visible AS visible_3,
  m0_.hide_desktop AS hide_desktop_4,
  m0_.hide_tablet AS hide_tablet_5,
  m0_.hide_mobile AS hide_mobile_6,
  m0_.created AS created_7,
  m0_.updated AS updated_8,
  m0_.type AS type_9,
  m0_.class_name AS class_name_10,
  m0_.univer AS univer_11,
  m0_.nom AS nom_12,
  m0_.titre AS titre_13,
  m0_.soustitre AS soustitre_14,
  m0_.url AS url_15,
  m0_.color AS color_16,
  m0_.ancre AS ancre_17,
  m0_.contenu AS contenu_18,
  m0_.image_name AS image_name_19,
  m0_.image_updated_at AS image_updated_at_20,
  m0_.image_alt AS image_alt_21,
  m0_.ordre AS ordre_22,
  m0_.version AS version_23,
  m0_.page_id AS page_id_24,
  m0_.produit_id AS produit_id_25,
  m0_.module_page_id AS module_page_id_26,
  m0_.module_categorie_id AS module_categorie_id_27,
  m0_.module_produit_id AS module_produit_id_28,
  m0_.module_caracteristique_id AS module_caracteristique_id_29,
  m0_.module_attribut_id AS module_attribut_id_30
FROM
  module m0_
WHERE
  m0_.produit_id = ?
  AND m0_.version = ?
ORDER BY
  m0_.ordre ASC,
  m0_.titre ASC

SELECT m0_.id AS id_0, m0_.date_debut AS date_debut_1, m0_.date_fin AS date_fin_2, m0_.visible AS visible_3, m0_.hide_desktop AS hide_desktop_4, m0_.hide_tablet AS hide_tablet_5, m0_.hide_mobile AS hide_mobile_6, m0_.created AS created_7, m0_.updated AS updated_8, m0_.type AS type_9, m0_.class_name AS class_name_10, m0_.univer AS univer_11, m0_.nom AS nom_12, m0_.titre AS titre_13, m0_.soustitre AS soustitre_14, m0_.url AS url_15, m0_.color AS color_16, m0_.ancre AS ancre_17, m0_.contenu AS contenu_18, m0_.image_name AS image_name_19, m0_.image_updated_at AS image_updated_at_20, m0_.image_alt AS image_alt_21, m0_.ordre AS ordre_22, m0_.version AS version_23, m0_.page_id AS page_id_24, m0_.produit_id AS produit_id_25, m0_.module_page_id AS module_page_id_26, m0_.module_categorie_id AS module_categorie_id_27, m0_.module_produit_id AS module_produit_id_28, m0_.module_caracteristique_id AS module_caracteristique_id_29, m0_.module_attribut_id AS module_attribut_id_30 FROM module m0_ WHERE m0_.produit_id = 11 AND m0_.version = 'production' ORDER BY m0_.ordre ASC, m0_.titre ASC;

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

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:25:07' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:25:07' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:25:07' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:25:07' OR p0_.date_debut IS NULL)) AND (((p1_.id = 11) OR (c3_.id IN (226, 229, 220, 219, 218, 217, 216, 215, 214, 58, 83, 21, 61, 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 = 11 OR p6_.id = 11))))) 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 = 11 OR c11_.produit_id = 11)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC;