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:31:00' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:31:00' OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1;

SELECT
  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_
WHERE
  p0_.slug = ?

SELECT 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_ WHERE p0_.slug = '30-vp';

SELECT
  p0_.id AS id_0
FROM
  promotion p1_
  INNER JOIN promotion_produit p2_ ON p1_.id = p2_.promotion_id
  INNER JOIN produit p0_ ON p0_.id = p2_.produit_id
WHERE
  p1_.id = ?

SELECT p0_.id AS id_0 FROM promotion p1_ INNER JOIN promotion_produit p2_ ON p1_.id = p2_.promotion_id INNER JOIN produit p0_ ON p0_.id = p2_.produit_id WHERE p1_.id = 5;

SELECT
  c0_.id AS id_0
FROM
  promotion p1_
  INNER JOIN promotion_categorie p2_ ON p1_.id = p2_.promotion_id
  INNER JOIN categorie c0_ ON c0_.id = p2_.categorie_id
WHERE
  p1_.id = ?

SELECT c0_.id AS id_0 FROM promotion p1_ INNER JOIN promotion_categorie p2_ ON p1_.id = p2_.promotion_id INNER JOIN categorie c0_ ON c0_.id = p2_.categorie_id WHERE p1_.id = 5;

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 produit p1_ ON p0_.parent_id = p1_.id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.declinaison IS NULL
      OR p0_.declinaison = 0
    )
  )
  AND p0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND p0_.id NOT IN (
    SELECT
      p2_.id
    FROM
      promotion p3_
      INNER JOIN promotion_produit_exclude p4_ ON p3_.id = p4_.promotion_id
      INNER JOIN produit p2_ ON p2_.id = p4_.produit_id
    WHERE
      p3_.id = ?
  )
  AND (
    p1_.id IS NULL
    OR p1_.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 (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_53
        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 = p0_.id
          )
        WHERE
          p8_.id = ?
      )
    )
  )
  AND (
    p1_.id IS NULL
    OR (
      NOT (
        EXISTS (
          SELECT
            1 AS sclr_54
          FROM
            promotion p12_
            INNER JOIN promotion_categorie_exclude p14_ ON p12_.id = p14_.promotion_id
            INNER JOIN categorie c13_ ON c13_.id = p14_.categorie_id
            INNER JOIN categorie_produit c15_ ON (
              c15_.categorie_id = c13_.id
              AND c15_.produit_id = p1_.id
            )
          WHERE
            p12_.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 produit p1_ ON p0_.parent_id = p1_.id WHERE p0_.visible = 1 AND ((p0_.declinaison IS NULL OR p0_.declinaison = 0)) AND p0_.id IN (13, 14, 15, 17, 19, 22, 24, 28, 34, 38, 42, 45, 46, 47, 48, 71, 72, 73, 74, 75, 76, 77, 78, 79, 81, 82, 83, 88, 102, 103, 106, 109, 110, 112, 120, 126, 127, 129, 173, 174, 175, 176, 178, 179, 180, 181, 182, 183, 184, 186, 187, 188, 207, 215, 219, 238, 239, 243, 244, 258, 273, 274, 275, 276, 277, 291, 292, 293, 297, 314, 350, 352, 359, 365, 366, 445, 447, 450, 455, 467, 470, 493, 498, 500, 505, 507, 546, 550, 609, 610, 612, 613, 614, 622, 629, 630, 631, 632, 633, 651, 653, 655, 661, 687, 688, 689, 690, 691, 692, 694, 695, 696, 697, 698, 700, 701, 712, 738, 742, 806, 874, 875, 876, 877, 878, 881, 892, 893, 894, 895, 915, 929, 930, 931) AND p0_.id NOT IN (SELECT p2_.id FROM promotion p3_ INNER JOIN promotion_produit_exclude p4_ ON p3_.id = p4_.promotion_id INNER JOIN produit p2_ ON p2_.id = p4_.produit_id WHERE p3_.id = 5) AND (p1_.id IS NULL OR p1_.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 = 5)) AND (NOT (EXISTS (SELECT 1 AS sclr_53 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 = p0_.id) WHERE p8_.id = 5))) AND (p1_.id IS NULL OR (NOT (EXISTS (SELECT 1 AS sclr_54 FROM promotion p12_ INNER JOIN promotion_categorie_exclude p14_ ON p12_.id = p14_.promotion_id INNER JOIN categorie c13_ ON c13_.id = p14_.categorie_id INNER JOIN categorie_produit c15_ ON (c15_.categorie_id = c13_.id AND c15_.produit_id = p1_.id) WHERE p12_.id = 5))));

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;

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