Query Metrics

53 Database Queries
18 Different statements
54.96 ms Query time
0 Invalid entities
511 Managed entities

Queries

Group similar statements

#▲ Time Info
1 4.92 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_.slug = ?
Parameters:
[
  "lapin-bonbon"
]
2 1.34 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"
]
3 3.78 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:
[]
4 3.17 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
]
5 7.89 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:
[]
6 5.72 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"
]
7 3.64 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:23:36"
  "2026-09-24 16:23:36"
]
8 0.47 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 INNER JOIN listing_produit ON t0.id = listing_produit.produit_id WHERE listing_produit.listing_id = ?
Parameters:
[
  56
]
9 0.29 ms
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 INNER JOIN listing_categorie ON t0.id = listing_categorie.categorie_id WHERE listing_categorie.listing_id = ?
Parameters:
[
  56
]
10 7.16 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, COALESCE(MIN(c1_.ordre), 99999) AS sclr_52, p0_.parent_id AS parent_id_53 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id WHERE p0_.visible = ? AND ((p0_.cadeau IS NULL OR p0_.cadeau = 0)) AND ((p0_.declinaison IS NULL OR p0_.declinaison = 0)) AND (c1_.categorie_id IN (?)) GROUP BY p0_.id ORDER BY sclr_52 ASC, p0_.id DESC
Parameters:
[
  1
  56
]
11 0.59 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
]
12 1.28 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  346
]
13 0.42 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:
[
  330
]
14 0.28 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  330
]
15 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 = ? ORDER BY t0.id ASC
Parameters:
[
  341
]
16 0.21 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  341
]
17 0.19 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:
[
  338
]
18 0.23 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  338
]
19 0.19 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:
[
  343
]
20 0.18 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  343
]
21 0.20 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:
[
  333
]
22 0.23 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  333
]
23 0.18 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:
[
  337
]
24 0.19 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  337
]
25 0.21 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:
[
  339
]
26 0.21 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  339
]
27 0.19 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:
[
  327
]
28 0.19 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  327
]
29 0.22 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:
[
  328
]
30 0.19 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  328
]
31 0.18 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:
[
  329
]
32 0.22 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  329
]
33 0.19 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:
[
  336
]
34 0.20 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  336
]
35 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 = ? ORDER BY t0.id ASC
Parameters:
[
  340
]
36 0.19 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  340
]
37 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 = ? ORDER BY t0.id ASC
Parameters:
[
  386
]
38 0.22 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  386
]
39 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 = ? ORDER BY t0.id ASC
Parameters:
[
  383
]
40 0.21 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  383
]
41 0.20 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:
[
  384
]
42 0.18 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  384
]
43 0.21 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:
[
  385
]
44 0.19 ms
SELECT t0.id AS id_1, t0.produit_id AS produit_id_2, t0.caracteristique_id AS caracteristique_id_3, t0.caracteristique_valeur_id AS caracteristique_valeur_id_4 FROM produit_caracteristique t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC
Parameters:
[
  385
]
45 1.08 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
]
46 1.84 ms
SELECT COUNT(*) AS dctrn_count FROM (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, COALESCE(MIN(c1_.ordre), 99999) AS sclr_52 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id WHERE p0_.visible = ? AND ((p0_.cadeau IS NULL OR p0_.cadeau = 0)) AND ((p0_.declinaison IS NULL OR p0_.declinaison = 0)) AND (c1_.categorie_id IN (?)) GROUP BY p0_.id ORDER BY sclr_52 ASC, p0_.id DESC) dctrn_table
Parameters:
[
  1
  56
]
47 1.56 ms
SELECT DISTINCT id_2 FROM (SELECT DISTINCT id_2, sclr_52 FROM (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, COALESCE(MIN(c1_.ordre), 99999) AS sclr_52, c1_.id AS id_53, c1_.ordre AS ordre_54 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id WHERE p0_.visible = ? AND ((p0_.cadeau IS NULL OR p0_.cadeau = 0)) AND ((p0_.declinaison IS NULL OR p0_.declinaison = 0)) AND (c1_.categorie_id IN (?)) GROUP BY p0_.id ORDER BY c1_.ordre ASC) dctrn_result_inner ORDER BY sclr_52 ASC, id_2 DESC) dctrn_result LIMIT 10
Parameters:
[
  1
  56
]
48 1.25 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, COALESCE(MIN(c1_.ordre), 99999) AS sclr_52, p0_.parent_id AS parent_id_53 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id WHERE p0_.visible = ? AND ((p0_.cadeau IS NULL OR p0_.cadeau = 0)) AND ((p0_.declinaison IS NULL OR p0_.declinaison = 0)) AND (c1_.categorie_id IN (?)) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.id ORDER BY sclr_52 ASC, p0_.id DESC
Parameters:
[
  1
  56
  346
  330
  341
  338
  343
  333
  337
  339
  327
  328
]
49 0.40 ms
SELECT a0_.id AS id_0, a0_.valeur AS valeur_1, a0_.groupe AS groupe_2, a0_.ordre AS ordre_3, a0_.image_name AS image_name_4, a0_.image_updated_at AS image_updated_at_5, a0_.attribut_id AS attribut_id_6 FROM attribut_valeur a0_ WHERE a0_.attribut_id = ? ORDER BY a0_.ordre ASC
Parameters:
[
  "1"
]
50 0.50 ms
SELECT c0_.id AS id_0, c0_.valeur AS valeur_1, c0_.ordre AS ordre_2, c0_.color AS color_3, c0_.image_name AS image_name_4, c0_.image_updated_at AS image_updated_at_5, c0_.caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_.caracteristique_id = ? ORDER BY c0_.ordre ASC
Parameters:
[
  "3"
]
51 0.41 ms
SELECT c0_.id AS id_0, c0_.valeur AS valeur_1, c0_.ordre AS ordre_2, c0_.color AS color_3, c0_.image_name AS image_name_4, c0_.image_updated_at AS image_updated_at_5, c0_.caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_.caracteristique_id = ? ORDER BY c0_.ordre ASC
Parameters:
[
  "4"
]
52 0.34 ms
SELECT c0_.id AS id_0, c0_.valeur AS valeur_1, c0_.ordre AS ordre_2, c0_.color AS color_3, c0_.image_name AS image_name_4, c0_.image_updated_at AS image_updated_at_5, c0_.caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_.caracteristique_id = ? ORDER BY c0_.ordre ASC
Parameters:
[
  "1"
]
53 0.44 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\Listing 150
App\Entity\Parametre 102
App\Entity\CaracteristiqueValeur 71
App\Entity\Page 51
App\Entity\AttributValeur 48
App\Entity\ProduitAttribut 24
App\Entity\AvisVerifies 20
App\Entity\Produit 20
App\Entity\ProduitCaracteristique 20
App\Entity\Attribut 2
App\Entity\Caracteristique 2
App\Entity\Categorie 1