Symfony Profiler

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Bugsnag\BugsnagBundle\EventListener\BugsnagListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerNMXFQVf\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 30
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "2026-09-24 16:23:58"
    3 => "2026-09-24 16:23:58"
    4 => "2026-09-24 16:23:58"
    5 => "2026-09-24 16:23:58"
    6 => 13
    7 => 226
    8 => 216
    9 => 215
    10 => 218
    11 => 219
    12 => 220
    13 => 229
    14 => 217
    15 => 26
    16 => 132
    17 => 164
    18 => 37
    19 => 4
    20 => 162
    21 => 19
    22 => 5
    23 => 163
    24 => 0.0
    25 => 13
    26 => 13
    27 => 13
    28 => 13
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 2
    25 => 1
    26 => 1
    27 => 1
    28 => 1
  ]
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 226
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 30
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "2026-09-24 16:23:58"
    3 => "2026-09-24 16:23:58"
    4 => "2026-09-24 16:23:58"
    5 => "2026-09-24 16:23:58"
    6 => 30
    7 => 64
    8 => 226
    9 => 215
    10 => 216
    11 => 217
    12 => 218
    13 => 219
    14 => 220
    15 => 229
    16 => 181
    17 => 185
    18 => 26
    19 => 190
    20 => 175
    21 => 174
    22 => 46
    23 => 37
    24 => 19
    25 => 4
    26 => 5
    27 => 59
    28 => 0.0
    29 => 30
    30 => 30
    31 => 30
    32 => 30
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 2
    29 => 1
    30 => 1
    31 => 1
    32 => 1
  ]
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "2026-09-24 16:23:58"
    3 => "2026-09-24 16:23:58"
    4 => "2026-09-24 16:23:58"
    5 => "2026-09-24 16:23:58"
    6 => 9
    7 => 65
    8 => 226
    9 => 229
    10 => 220
    11 => 219
    12 => 218
    13 => 217
    14 => 216
    15 => 215
    16 => 214
    17 => 21
    18 => 58
    19 => 83
    20 => 19
    21 => 5
    22 => 2
    23 => 9
    24 => 59
    25 => 0.0
    26 => 9
    27 => 9
    28 => 9
    29 => 9
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 2
    26 => 1
    27 => 1
    28 => 1
    29 => 1
  ]
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 65
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "2026-09-24 16:23:58"
    3 => "2026-09-24 16:23:58"
    4 => "2026-09-24 16:23:58"
    5 => "2026-09-24 16:23:58"
    6 => 46
    7 => 63
    8 => 226
    9 => 223
    10 => 229
    11 => 220
    12 => 219
    13 => 218
    14 => 217
    15 => 175
    16 => 29
    17 => 174
    18 => 46
    19 => 190
    20 => 166
    21 => 185
    22 => 36
    23 => 20
    24 => 4
    25 => 163
    26 => 5
    27 => 162
    28 => 59
    29 => 3
    30 => 0.0
    31 => 46
    32 => 46
    33 => 46
    34 => 46
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 2
    31 => 1
    32 => 1
    33 => 1
    34 => 1
  ]
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 63
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]