Query Metrics

70 Database Queries
6 Different statements
11.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.12 ms
(63.83%)
33
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.updated_image_at AS updated_image_at_4, t0.contenu AS contenu_5, t0.date_debut_publication AS date_debut_publication_6, t0.date_fin_publication AS date_fin_publication_7, t0.visible_page_accueil AS visible_page_accueil_8, t0.slug AS slug_9, t0.created_date AS created_date_10, t0.update_date AS update_date_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.publication AS publication_14, t0.cible_id AS cible_id_15 FROM article t0 WHERE t0.id = ?
Parameters:
[
  3
]
2.80 ms
(25.11%)
33
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.parent_id AS parent_id_4, t0.article_id AS article_id_5 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  0
]
0.47 ms
(4.18%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.statut AS statut_3, t0.contact AS contact_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_visible_carte_jeune AS is_visible_carte_jeune_10, t0.role_information AS role_information_11, t0.role_accompagnement AS role_accompagnement_12, t0.organise_mobilite AS organise_mobilite_13, t0.is_visible_carte_professionnel AS is_visible_carte_professionnel_14, t0.image AS image_15, t0.updated_image_at AS updated_image_at_16, t0.so_mobilite AS so_mobilite_17, t0.slug AS slug_18, t0.created_date AS created_date_19, t0.update_date AS update_date_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22 FROM structure t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "maison-des-jeunes-arcachon-les-reservoirs"
]
0.30 ms
(2.73%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM departement t0 INNER JOIN departement_structure ON t0.id = departement_structure.departement_id WHERE departement_structure.structure_id = ?
Parameters:
[
  "aa481dee-f61f-4a56-b47f-2308a94d6782"
]
0.24 ms
(2.19%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM reseaux t0 INNER JOIN structure_reseaux ON t0.id = structure_reseaux.reseaux_id WHERE structure_reseaux.structure_id = ?
Parameters:
[
  "aa481dee-f61f-4a56-b47f-2308a94d6782"
]
0.22 ms
(1.96%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM domaine_information t0 INNER JOIN structure_domaine_information ON t0.id = structure_domaine_information.domaine_information_id WHERE structure_domaine_information.structure_id = ?
Parameters:
[
  "aa481dee-f61f-4a56-b47f-2308a94d6782"
]

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.