Query Metrics

71 Database Queries
5 Different statements
12.66 ms Query time
0 Invalid entities
184 Managed entities

Grouped Statements

Show all queries

Time Count Info
8.00 ms
(63.21%)
34
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
]
4.02 ms
(31.73%)
34
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.35 ms
(2.77%)
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.15 ms
(1.21%)
1
SELECT d0_.id AS id_0, d0_.nom AS nom_1 FROM departement d0_ ORDER BY d0_.nom ASC
Parameters:
[]
0.14 ms
(1.08%)
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Structure 92
App\Entity\Menu 35
App\Entity\Article 34
App\Entity\Departement 12
App\Entity\DomaineInformation 10
App\Entity\CiblePublic 1

Entities Mapping