https://preprod.sogal.com/sitemap.xml

Query Metrics

36 Database Queries
14 Different statements
50.42 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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
  • The mappings App\Entity\Produit\Produit#sousFamille and App\Entity\Produit\SousFamille#produits are inconsistent with each other.
  • If association App\Entity\Produit\Produit#sousFamille is many-to-one, then the inversed side App\Entity\Produit\SousFamille#produits has to be one-to-many.
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.