Query Metrics
36
Database Queries
14
Different statements
50.42 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.94 ms (25.66%) |
14 |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.titre AS titre_3, t0.placement AS placement_4, t0.descriptif AS descriptif_5, t0.url AS url_6, t0.date AS date_7, t0.seo_url AS seo_url_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.image_alt AS image_alt_11 FROM ambiance t0 INNER JOIN ambiance_sous_thematique_ambiance ON t0.id = ambiance_sous_thematique_ambiance.ambiance_id WHERE ambiance_sous_thematique_ambiance.ambiance_sous_thematique_id = ? ORDER BY t0.placement ASC
Parameters:
[
4
]
|
|
11.15 ms (22.12%) |
6 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seo_url AS seo_url_3, t0.image_en_tete AS image_en_tete_4, t0.vignette AS vignette_5, t0.date AS date_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.image_alt AS image_alt_9, t0.contenu1 AS contenu1_10, t0.contenu2 AS contenu2_11, t0.locale_mere_id AS locale_mere_id_12 FROM locale_fille t0 WHERE t0.locale_mere_id = ?
Parameters:
[
1
]
|
|
9.85 ms (19.54%) |
3 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.placement AS placement_3, t0.seo_url AS seo_url_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.navbar_text AS navbar_text_7, t0.url_image AS url_image_8, t0.url_image_entete AS url_image_entete_9, t0.date AS date_10, t0.description AS description_11, t0.description_fin AS description_fin_12, t0.thematique_id AS thematique_id_13 FROM ambiance_sous_thematique t0 WHERE t0.thematique_id = ? ORDER BY t0.placement ASC
Parameters:
[
2
]
|
|
5.94 ms (11.78%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seo_url AS seo_url_3, t0.image_en_tete AS image_en_tete_4, t0.date AS date_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.image_alt AS image_alt_8, t0.contenu1 AS contenu1_9, t0.contenu2 AS contenu2_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12 FROM locale_mere t0
Parameters:
[] |
|
3.83 ms (7.60%) |
1 |
SELECT t0.id AS id_1, t0.model_commercial AS model_commercial_2, t0.placement AS placement_3, t0.actif AS actif_4, t0.avantage AS avantage_5, t0.description AS description_6, t0.caracteristique AS caracteristique_7, t0.date AS date_8, t0.largeur_fixe AS largeur_fixe_9, t0.largeur_min AS largeur_min_10, t0.largeur_max AS largeur_max_11, t0.hauteur_fixe AS hauteur_fixe_12, t0.hauteur_min AS hauteur_min_13, t0.hauteur_max AS hauteur_max_14, t0.profondeur_fixe AS profondeur_fixe_15, t0.profondeur_min AS profondeur_min_16, t0.profondeur_max AS profondeur_max_17, t0.seo_url AS seo_url_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.preconfig_url_key AS preconfig_url_key_21, t0.partition_produit_id AS partition_produit_id_22, t0.sous_famille_id AS sous_famille_id_23, t0.configurateur_id AS configurateur_id_24 FROM produit t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
|
1.58 ms (3.14%) |
3 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.placement AS placement_4, t0.seo_url AS seo_url_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.url_image AS url_image_8, t0.updated_at AS updated_at_9, t0.image_alt AS image_alt_10, t0.date AS date_11, t0.date_fin AS date_fin_12, t0.dossier_parent_id AS dossier_parent_id_13 FROM dossier t0 WHERE t0.dossier_parent_id = ? ORDER BY t0.placement ASC
Parameters:
[
1
]
|
|
1.02 ms (2.03%) |
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.designation_collection_filtre AS designation_collection_filtre_3, t0.designation_collection_filtre_bis AS designation_collection_filtre_bis_4, t0.seo_url AS seo_url_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.navbar_text AS navbar_text_8, t0.placement AS placement_9, t0.url_image AS url_image_10, t0.url_image_entete AS url_image_entete_11, t0.date AS date_12, t0.description AS description_13, t0.description_fin AS description_fin_14, t0.configurateur AS configurateur_15, t0.famille_produit_id AS famille_produit_id_16 FROM sous_famille t0
Parameters:
[] |
|
0.91 ms (1.80%) |
1 |
SELECT a0_.id AS id_0, a0_.placement AS placement_1, a0_.titre AS titre_2, a0_.resume AS resume_3, a0_.date AS date_4, a0_.pdf AS pdf_5, a0_.image_url AS image_url_6, a0_.image_bis_url AS image_bis_url_7, a0_.image_ter_url AS image_ter_url_8, a0_.updated_at AS updated_at_9, a0_.seo_url AS seo_url_10, a0_.meta_title AS meta_title_11, a0_.meta_description AS meta_description_12, a0_.date_fin AS date_fin_13, a0_.image_alt AS image_alt_14, a0_.tag_id AS tag_id_15 FROM article a0_ WHERE a0_.date < ? AND (a0_.date_fin > ? OR a0_.date_fin IS NULL) ORDER BY a0_.placement DESC, a0_.date DESC
Parameters:
[ "2026-07-13 17:50:47" "2026-07-13 17:50:47" ] |
|
0.71 ms (1.41%) |
1 |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.placement AS placement_3, t0.url_image AS url_image_4, t0.url_image_entete AS url_image_entete_5, t0.date AS date_6, t0.designation AS designation_7, t0.configurateur AS configurateur_8, t0.seo_url AS seo_url_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.navbar_text AS navbar_text_12, t0.description AS description_13, t0.description_fin AS description_fin_14 FROM famille_produit t0
Parameters:
[] |
|
0.62 ms (1.23%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.placement AS placement_3, t0.seo_url AS seo_url_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.navbar_text AS navbar_text_7, t0.url_image AS url_image_8, t0.url_image_entete AS url_image_entete_9, t0.date AS date_10, t0.description AS description_11, t0.description_fin AS description_fin_12 FROM ambiance_thematique t0
Parameters:
[] |
|
0.50 ms (0.99%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seo_url AS seo_url_3, t0.sitemap AS sitemap_4, t0.image_en_tete AS image_en_tete_5, t0.date AS date_6, t0.navbar_active AS navbar_active_7, t0.navbar_top_active AS navbar_top_active_8, t0.footer_active AS footer_active_9, t0.navbar_sous_menu AS navbar_sous_menu_10, t0.navbar_position AS navbar_position_11, t0.navbar_titre AS navbar_titre_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.is_contact_form AS is_contact_form_15, t0.image_alt AS image_alt_16, t0.instant_expert AS instant_expert_17 FROM page t0 WHERE t0.sitemap = ?
Parameters:
[
1
]
|
|
0.49 ms (0.98%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.placement AS placement_3, t0.seo_url AS seo_url_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.navbar_text AS navbar_text_7, t0.url_image AS url_image_8, t0.url_image_entete AS url_image_entete_9, t0.date AS date_10, t0.description AS description_11, t0.description_fin AS description_fin_12 FROM categorie t0
Parameters:
[] |
|
0.45 ms (0.89%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.placement AS placement_3, t0.seo_url AS seo_url_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.navbar_text AS navbar_text_7, t0.url_image AS url_image_8, t0.url_image_entete AS url_image_entete_9, t0.date AS date_10, t0.description AS description_11, t0.description_fin AS description_fin_12, t0.categorie_id AS categorie_id_13 FROM sous_categorie t0 WHERE t0.categorie_id = ? ORDER BY t0.placement ASC
Parameters:
[
1
]
|
|
0.42 ms (0.83%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.placement AS placement_4, t0.seo_url AS seo_url_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.url_image AS url_image_8, t0.url_image_entete AS url_image_entete_9, t0.date AS date_10 FROM dossier_parent t0
Parameters:
[] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Produit\FamilleProduit | No errors. |
| App\Entity\Produit\SousFamille | No errors. |
| App\Entity\Produit\Produit |
|
| App\Entity\Produit\SousFamilleType | No errors. |
| App\Entity\Produit\PartitionProduit | No errors. |
| App\Entity\Volumiq\Configurateur | No errors. |
| App\Entity\Produit\Pdf | No errors. |
| App\Entity\Produit\Image | No errors. |
| App\Entity\Site\Ambiance | No errors. |
| App\Entity\Produit\FiltrePersonalise | No errors. |
| App\Entity\Produit\FiltrePersonaliseBis | No errors. |
| App\Entity\Produit\Notice | No errors. |
| App\Entity\Produit\Video | No errors. |
| App\Entity\Produit\ProfilGeometrie | No errors. |
| App\Entity\Produit\RemplissageNuancier | No errors. |
| App\Entity\Site\Article | No errors. |
| App\Entity\Site\ArticleTag | No errors. |
| App\Entity\Template\Row | No errors. |
| App\Entity\Site\ArticleTagProduit | No errors. |
| App\Entity\Site\AmbianceThematique | No errors. |
| App\Entity\Site\AmbianceSousThematique | No errors. |
| App\Entity\Template\Page | No errors. |
| App\Entity\Site\DossierParent | No errors. |
| App\Entity\Site\Dossier | No errors. |
| App\Entity\Volumiq\Categorie | No errors. |
| App\Entity\Volumiq\SousCategorie | No errors. |
| App\Entity\Site\LocaleMere | No errors. |
| App\Entity\Site\LocaleFille | No errors. |