Query Metrics

24 Database Queries
18 Different statements
28.82 ms Query time
0 Invalid entities
1780 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.37 ms
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"
]
2 0.50 ms
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:
[]
3 1.42 ms
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
]
4 7.08 ms
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:
[]
5 3.18 ms
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"
]
6 0.33 ms
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 16:59:32"
  "2026-09-24 16:59:32"
]
7 2.47 ms
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:
[
  "peluche-lapin-bonbon-taupe-30-cm"
]
8 0.42 ms
SELECT a0_.id AS id_0, a0_.created AS created_1, a0_.updated AS updated_2, a0_.ordre AS ordre_3, a0_.affichage AS affichage_4, a0_.titre AS titre_5, a0_.slug AS slug_6 FROM attribut a0_ LEFT JOIN produit_attribut p1_ ON a0_.id = p1_.attribut_id WHERE p1_.produit_parent_id = ? ORDER BY a0_.ordre ASC
Parameters:
[
  342
]
9 0.32 ms
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:
[
  346
]
10 0.35 ms
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ WHERE p0_.produit_parent_id = ? AND p0_.attribut_id = ? AND p0_.attribut_valeur_id = ?
Parameters:
[
  342
  3
  49
]
11 0.23 ms
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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters:
[
  346
  1
]
12 0.37 ms
SELECT p0_.id AS id_0, p0_.produit_parent_id AS produit_parent_id_1, p0_.produit_id AS produit_id_2, p0_.attribut_id AS attribut_id_3, p0_.attribut_valeur_id AS attribut_valeur_id_4 FROM produit_attribut p0_ WHERE p0_.produit_parent_id = ? AND p0_.attribut_id = ? AND p0_.attribut_valeur_id = ?
Parameters:
[
  342
  1
  31
]
13 0.27 ms
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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters:
[
  343
  3
]
14 0.25 ms
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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters:
[
  344
  3
]
15 0.26 ms
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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters:
[
  345
  3
]
16 0.24 ms
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 = ? AND t0.attribut_id = ? LIMIT 1
Parameters:
[
  346
  3
]
17 0.48 ms
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:
[
  342
]
18 0.31 ms
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:
[
  342
]
19 3.15 ms
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 (346) ORDER BY c0_.ordre ASC
Parameters:
[
  1
  226
]
20 0.75 ms
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 = ? OR p1_.id = ?)) ORDER BY p0_.created DESC
Parameters:
[
  1
  "2026-09-24 16:59:33"
  "2026-09-24 16:59:33"
  "2026-09-24 16:59:33"
  "2026-09-24 16:59:33"
  346
  342
]
21 0.56 ms
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:
[
  342
  "production"
]
22 0.53 ms
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:
[
  346
]
23 3.56 ms
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 16:59:33"
  "2026-09-24 16:59:33"
  "2026-09-24 16:59:33"
  "2026-09-24 16:59:33"
  346
  342
  219
  220
  229
  224
  226
  56
  118
  2
  10
  59
  15
  9
  3
  60
  0.0
  346
  342
  346
  342
]
24 0.41 ms
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"
]

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 719
App\Entity\Produit 705
App\Entity\Listing 150
App\Entity\Parametre 102
App\Entity\Page 51
App\Entity\AvisVerifies 20
App\Entity\Categorie 14
App\Entity\ProduitAttribut 8
App\Entity\AttributValeur 5
App\Entity\Promotion 3
App\Entity\Attribut 2
App\Entity\Module 1