Symfony Profiler

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

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_
  LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id
  LEFT JOIN produit p2_ ON p0_.parent_id = p2_.id
  LEFT JOIN categorie_produit c3_ ON p2_.id = c3_.produit_id
  LEFT JOIN produit p4_ ON p0_.parent_id = p4_.id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.declinaison IS NULL
      OR p0_.declinaison = 0
    )
  )
  AND (
    c1_.categorie_id IN (?)
    OR c3_.categorie_id IN (?)
  )
  AND p0_.id NOT IN (
    SELECT
      p5_.id
    FROM
      promotion p6_
      INNER JOIN promotion_produit_exclude p7_ ON p6_.id = p7_.promotion_id
      INNER JOIN produit p5_ ON p5_.id = p7_.produit_id
    WHERE
      p6_.id = ?
  )
  AND (
    p4_.id IS NULL
    OR p4_.id NOT IN (
      SELECT
        p8_.id
      FROM
        promotion p9_
        INNER JOIN promotion_produit_exclude p10_ ON p9_.id = p10_.promotion_id
        INNER JOIN produit p8_ ON p8_.id = p10_.produit_id
      WHERE
        p9_.id = ?
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_53
        FROM
          promotion p11_
          INNER JOIN promotion_categorie_exclude p13_ ON p11_.id = p13_.promotion_id
          INNER JOIN categorie c12_ ON c12_.id = p13_.categorie_id
          INNER JOIN categorie_produit c14_ ON (
            c14_.categorie_id = c12_.id
            AND c14_.produit_id = p0_.id
          )
        WHERE
          p11_.id = ?
      )
    )
  )
  AND (
    p4_.id IS NULL
    OR (
      NOT (
        EXISTS (
          SELECT
            1 AS sclr_54
          FROM
            promotion p15_
            INNER JOIN promotion_categorie_exclude p17_ ON p15_.id = p17_.promotion_id
            INNER JOIN categorie c16_ ON c16_.id = p17_.categorie_id
            INNER JOIN categorie_produit c18_ ON (
              c18_.categorie_id = c16_.id
              AND c18_.produit_id = p4_.id
            )
          WHERE
            p15_.id = ?
        )
      )
    )
  )

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_ LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id LEFT JOIN produit p2_ ON p0_.parent_id = p2_.id LEFT JOIN categorie_produit c3_ ON p2_.id = c3_.produit_id LEFT JOIN produit p4_ ON p0_.parent_id = p4_.id WHERE p0_.visible = 1 AND ((p0_.declinaison IS NULL OR p0_.declinaison = 0)) AND (c1_.categorie_id IN (204) OR c3_.categorie_id IN (204)) AND p0_.id NOT IN (SELECT p5_.id FROM promotion p6_ INNER JOIN promotion_produit_exclude p7_ ON p6_.id = p7_.promotion_id INNER JOIN produit p5_ ON p5_.id = p7_.produit_id WHERE p6_.id = 44) AND (p4_.id IS NULL OR p4_.id NOT IN (SELECT p8_.id FROM promotion p9_ INNER JOIN promotion_produit_exclude p10_ ON p9_.id = p10_.promotion_id INNER JOIN produit p8_ ON p8_.id = p10_.produit_id WHERE p9_.id = 44)) AND (NOT (EXISTS (SELECT 1 AS sclr_53 FROM promotion p11_ INNER JOIN promotion_categorie_exclude p13_ ON p11_.id = p13_.promotion_id INNER JOIN categorie c12_ ON c12_.id = p13_.categorie_id INNER JOIN categorie_produit c14_ ON (c14_.categorie_id = c12_.id AND c14_.produit_id = p0_.id) WHERE p11_.id = 44))) AND (p4_.id IS NULL OR (NOT (EXISTS (SELECT 1 AS sclr_54 FROM promotion p15_ INNER JOIN promotion_categorie_exclude p17_ ON p15_.id = p17_.promotion_id INNER JOIN categorie c16_ ON c16_.id = p17_.categorie_id INNER JOIN categorie_produit c18_ ON (c18_.categorie_id = c16_.id AND c18_.produit_id = p4_.id) WHERE p15_.id = 44))));

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:31:09' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:31:09' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:31:09' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:31:09' OR p0_.date_debut IS NULL)) AND (((p1_.id = 5) OR (c3_.id IN (72, 215, 214, 217, 226, 218, 219, 220, 229, 216, 58, 21, 83, 114, 204, 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 = 5 OR p6_.id = 5))))) 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 = 5 OR c11_.produit_id = 5)) 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 = ?
  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:31:09' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:31:09' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:31:09' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:31:09' OR p0_.date_debut IS NULL)) AND (((p1_.id = 6) OR (c3_.id IN (226, 215, 216, 217, 218, 214, 219, 220, 229, 58, 21, 83, 204, 38, 19, 5, 2, 60, 9, 4, 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 = 6 OR p6_.id = 6))))) 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 = 6 OR c11_.produit_id = 6)) 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 = ?
  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:31:09' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:31:09' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:31:09' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:31:09' OR p0_.date_debut IS NULL)) AND (((p1_.id = 814) OR (c3_.id IN (226, 229, 220, 219, 218, 217, 216, 204, 191, 185, 170, 10, 15) 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 = 814 OR p6_.id = 814))))) 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 = 814 OR c11_.produit_id = 814)) 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 = ?
  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