Query Metrics

69 Database Queries
5 Different statements
11.30 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.92 ms
(61.27%)
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
]
3.33 ms
(29.44%)
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.42 ms
(3.68%)
1
SELECT d0_.id AS id_0, d0_.nom AS nom_1 FROM departement d0_ ORDER BY d0_.nom ASC
Parameters:
[]
0.35 ms
(3.07%)
1
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.statut AS statut_2, s0_.contact AS contact_3, s0_.adresse AS adresse_4, s0_.code_postal AS code_postal_5, s0_.ville AS ville_6, s0_.latitude AS latitude_7, s0_.longitude AS longitude_8, s0_.is_visible_carte_jeune AS is_visible_carte_jeune_9, s0_.role_information AS role_information_10, s0_.role_accompagnement AS role_accompagnement_11, s0_.organise_mobilite AS organise_mobilite_12, s0_.is_visible_carte_professionnel AS is_visible_carte_professionnel_13, s0_.image AS image_14, s0_.updated_image_at AS updated_image_at_15, s0_.so_mobilite AS so_mobilite_16, s0_.slug AS slug_17, s0_.created_date AS created_date_18, s0_.update_date AS update_date_19, s0_.created_by AS created_by_20, s0_.updated_by AS updated_by_21 FROM structure s0_ WHERE s0_.is_visible_carte_jeune = ? AND s0_.statut = ? ORDER BY s0_.nom ASC
Parameters:
[
  1
  1
]
0.29 ms
(2.54%)
1
SELECT d0_.id AS id_0, d0_.nom AS nom_1 FROM domaine_information d0_ WHERE d0_.id <> ? ORDER BY d0_.id ASC
Parameters:
[
  1
]

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.