Query Metrics

7 Database Queries
6 Different statements
1.60 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.13 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.gauche AS gauche_3, t0.droite AS droite_4, t0.niveau AS niveau_5, t0.libelle AS libelle_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM division t0 WHERE t0.niveau = ? LIMIT 1
Parameters:
[
  0
]
2 0.14 ms
SELECT d0_.id AS id_0, d0_.intitule AS intitule_1, d0_.gauche AS gauche_2, d0_.droite AS droite_3, d0_.niveau AS niveau_4, d0_.libelle AS libelle_5, d0_.created_at AS created_at_6, d0_.updated_at AS updated_at_7 FROM division d0_ WHERE d0_.niveau <> 0 GROUP BY d0_.niveau ORDER BY d0_.niveau ASC
Parameters:
[]
3 0.08 ms
SELECT t0.id AS id_1, t0.sigle AS sigle_2, t0.signification AS signification_3, t0.dscription AS dscription_4, t0.adresse AS adresse_5, t0.email AS email_6, t0.telephone AS telephone_7, t0.siege AS siege_8, t0.logo AS logo_9 FROM systeme t0
Parameters:
[]
4 0.06 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.noms AS noms_5, t0.sexe AS sexe_6, t0.date_naissance AS date_naissance_7, t0.lieu_naissance AS lieu_naissance_8, t0.cni AS cni_9, t0.code_militant AS code_militant_10, t0.annee_adhesion AS annee_adhesion_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.division_id AS division_id_14 FROM user t0
Parameters:
[]
5 0.06 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.gauche AS gauche_3, t0.droite AS droite_4, t0.niveau AS niveau_5, t0.libelle AS libelle_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM division t0
Parameters:
[]
6 0.07 ms
SELECT d0_.id AS id_0, d0_.intitule AS intitule_1, d0_.gauche AS gauche_2, d0_.droite AS droite_3, d0_.niveau AS niveau_4, d0_.libelle AS libelle_5, d0_.created_at AS created_at_6, d0_.updated_at AS updated_at_7 FROM division d0_ WHERE d0_.niveau = ? ORDER BY d0_.intitule ASC
Parameters:
[
  1
]
7 0.06 ms
SELECT d0_.id AS id_0, d0_.intitule AS intitule_1, d0_.gauche AS gauche_2, d0_.droite AS droite_3, d0_.niveau AS niveau_4, d0_.libelle AS libelle_5, d0_.created_at AS created_at_6, d0_.updated_at AS updated_at_7 FROM division d0_ WHERE d0_.niveau = ? ORDER BY d0_.intitule ASC
Parameters:
[
  2
]

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\Division No errors.
App\Entity\Bureau No errors.
App\Entity\User No errors.
App\Entity\Systeme No errors.