Redirect 301 redirect from GET @front_categorie_produit (861807)

Query Metrics

84 Database Queries
31 Different statements
165.17 ms Query time
0 Invalid entities
2067 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
23.28 ms
(14.10%)
12
SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  13
]
12.54 ms
(7.59%)
2
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  13
  226
  216
  215
  218
  219
  220
  229
  217
  26
  132
  164
  37
  4
  162
  19
  5
  163
  0.0
  13
  13
  13
  13
]
9.61 ms
(5.82%)
8
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?
Parameters:
[
  1
]
8.84 ms
(5.35%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  30
  64
  226
  215
  216
  217
  218
  219
  220
  229
  181
  185
  26
  190
  175
  174
  46
  37
  19
  4
  5
  59
  0.0
  30
  30
  30
  30
]
8.76 ms
(5.30%)
1
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
Parameters:
[
  66
  "production"
]
8.36 ms
(5.06%)
7
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 = ?
Parameters:
[
  13
]
8.33 ms
(5.04%)
14
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
Parameters:
[
  66
]
7.73 ms
(4.68%)
1
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
Parameters:
[]
7.71 ms
(4.67%)
7
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 = ?
Parameters:
[
  226
]
7.19 ms
(4.35%)
2
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  46
  63
  226
  223
  229
  220
  219
  218
  217
  175
  29
  174
  46
  190
  166
  185
  36
  20
  4
  163
  5
  162
  59
  3
  0.0
  46
  46
  46
  46
]
7.02 ms
(4.25%)
2
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  1076
  228
  226
  229
  220
  219
  218
  217
  216
  215
  214
  207
  87
  6
  0.0
  1076
  1076
  1076
  1076
]
6.35 ms
(3.84%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  66
  226
  216
  218
  219
  220
  229
  217
  118
  80
  18
  165
  61
  83
  162
  163
  10
  2
  9
  59
  3
  0.0
  66
  66
  66
  66
]
6.15 ms
(3.72%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  9
  65
  226
  229
  220
  219
  218
  217
  216
  215
  214
  21
  58
  83
  19
  5
  2
  9
  59
  0.0
  9
  9
  9
  9
]
4.49 ms
(2.72%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  1073
  227
  226
  223
  229
  220
  219
  218
  217
  87
  11
  0.0
  1073
  1073
  1073
  1073
]
3.91 ms
(2.37%)
1
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
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  66
]
3.51 ms
(2.12%)
1
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 p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  713
  712
  226
  225
  229
  144
  135
  187
  163
  162
  167
  185
  41
  118
  16
  3
  15
  60
  0.0
  713
  712
  713
  712
]
3.46 ms
(2.09%)
1
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
Parameters:
[
  1
]
3.39 ms
(2.06%)
1
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 p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  "2026-09-24 18:15:00"
  125
  124
  226
  217
  219
  220
  229
  223
  218
  51
  23
  193
  19
  5
  162
  60
  59
  3
  167
  163
  0.0
  125
  124
  125
  124
]
3.35 ms
(2.03%)
1
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.created AS created_3, t0.titre AS titre_4, t0.contenu AS contenu_5, t0.image_name AS image_name_6, t0.image_updated_at AS image_updated_at_7, t0.produit_id AS produit_id_8 FROM produit_image t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  66
]
3.21 ms
(1.94%)
7
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 = ?
Parameters:
[
  60
]
3.18 ms
(1.93%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.review_id AS review_id_3, t0.review_product_id AS review_product_id_4, t0.review_date AS review_date_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.note AS note_8, t0.commentaire AS commentaire_9, t0.reponses AS reponses_10, t0.produit_id AS produit_id_11, t0.commande_id AS commande_id_12 FROM avis_verifies t0 WHERE t0.produit_id = ? ORDER BY t0.review_date DESC
Parameters:
[
  66
]
2.66 ms
(1.61%)
1
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 = ?
Parameters:
[
  "fr"
]
2.60 ms
(1.58%)
1
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 (66) ORDER BY c0_.ordre ASC
Parameters:
[
  1
  226
]
2.51 ms
(1.52%)
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 = ?
Parameters:
[
  "doudou-ours-marron-avec-cape-papillotte-3-en-1"
]
2.28 ms
(1.38%)
1
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
Parameters:
[]
1.30 ms
(0.79%)
1
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
Parameters:
[
  1
  "page"
]
1.05 ms
(0.64%)
2
SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0 WHERE t0.variable = ? LIMIT 1
Parameters:
[
  "twitter-compte"
]
1.01 ms
(0.61%)
1
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
Parameters:
[
  1
]
0.54 ms
(0.33%)
1
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.created AS created_3, t0.updated AS updated_4, t0.titre AS titre_5, t0.ancre AS ancre_6, t0.url AS url_7, t0.image_name AS image_name_8, t0.image_updated_at AS image_updated_at_9, t0.image_alt AS image_alt_10 FROM benefice t0 INNER JOIN produit_benefice ON t0.id = produit_benefice.benefice_id WHERE produit_benefice.produit_id = ?
Parameters:
[
  66
]
0.48 ms
(0.29%)
1
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.reference IN (?, ?)
Parameters:
[
  "DC3952"
  "DC3953"
]
0.37 ms
(0.22%)
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 = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1
Parameters:
[
  1
  "2026-09-24 18:14:59"
  "2026-09-24 18:14:59"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CategorieProduit 912
App\Entity\Produit 705
App\Entity\Listing 150
App\Entity\Parametre 102
App\Entity\Categorie 73
App\Entity\Page 51
App\Entity\AvisVerifies 28
App\Entity\ProduitAttribut 13
App\Entity\Promotion 11
App\Entity\AttributValeur 8
App\Entity\SearchEditorialProduit 5
App\Entity\ProduitImage 4
App\Entity\Attribut 2
App\Entity\Module 1
App\Entity\SearchEditorial 1
App\Entity\Benefice 1

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\Module No errors.
App\Entity\Menu No errors.
App\Entity\Bloc No errors.
App\Entity\Produit No errors.
App\Entity\ProduitAttribut No errors.
App\Entity\AttributValeur No errors.
App\Entity\CaracteristiqueValeur No errors.
App\Entity\Presse No errors.
App\Entity\Listing No errors.
App\Entity\Parametre No errors.
App\Entity\Categorie No errors.
App\Entity\AvisVerifies No errors.
App\Entity\Commande No errors.
App\Entity\TraductionValeur No errors.
App\Entity\Traduction No errors.
App\Entity\Popup No errors.
App\Entity\Pack No errors.
App\Entity\CategorieProduit No errors.
App\Entity\Benefice No errors.
App\Entity\ProduitCaracteristique No errors.
App\Entity\ProduitImage No errors.
App\Entity\CodePromo No errors.
App\Entity\Promotion No errors.
App\Entity\CommandeProduit No errors.
App\Entity\CommandeRetour No errors.
App\Entity\ProduitAlerteStock No errors.
App\Entity\User No errors.
App\Entity\InstashopProduit No errors.
App\Entity\Caracteristique No errors.
App\Entity\Attribut No errors.
App\Entity\ModuleListing No errors.
App\Entity\MenuListing No errors.
App\Entity\Facture No errors.
App\Entity\Adresse No errors.
App\Entity\Transporteur No errors.
App\Entity\Reglement No errors.
App\Entity\Zone No errors.
App\Entity\Paiement No errors.
App\Entity\Instashop No errors.
App\Entity\Pays No errors.
App\Entity\TransporteurTarif No errors.
App\Entity\SearchEditorial No errors.
App\Entity\SearchEditorialProduit No errors.
App\Entity\Collectmail No errors.
App\Entity\CommandeStatistique No errors.
App\Entity\Email No errors.
App\Entity\Cron No errors.
App\Entity\Fichier No errors.
App\Entity\Magasin No errors.
App\Entity\Faq No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
Gedmo\Translator\Entity\Translation No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure No errors.
Vich\UploaderBundle\Entity\File No errors.
Meilisearch\Bundle\Entity\Aggregator No errors.