http://cts-web.sports.gouv.fr/api/liste_qualification_utilisateur_admin

Query Metrics

4 Database Queries
4 Different statements
9.72 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.08 ms
(41.95%)
1
SELECT r0_.id_fop AS id_fop_0, r0_.libelle_fop AS libelle_fop_1 FROM ref_fop r0_ WHERE (r0_.date_activation <= ? OR r0_.date_activation IS NULL) AND (r0_.date_desactivation > ? OR r0_.date_desactivation IS NULL) ORDER BY r0_.libelle_fop ASC
Parameters:
[
  "2025-06-13 15:17:35"
  "2025-06-13 15:17:35"
]
2.62 ms
(26.95%)
1
SELECT t0.id_information_personnelle AS id_information_personnelle_1, t0.id_utilisateur AS id_utilisateur_2, t0.civilite AS civilite_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.date_de_naissance AS date_de_naissance_6, t0.login AS login_7, t0.mot_de_passe AS mot_de_passe_8, t0.utilisateur_actif AS utilisateur_actif_9, t0.fonction AS fonction_10, t0.date_fin_droits AS date_fin_droits_11, t0.tentative AS tentative_12, t0.adresse AS adresse_13, t0.grade AS grade_14, t0.indice_majore AS indice_majore_15, t0.date_blocage AS date_blocage_16, t0.token AS token_17, t0.jeton_mdp AS jeton_mdp_18, t0.courriel_mdp AS courriel_mdp_19, t0.navigation AS navigation_20, t0.date_maj_mdp AS date_maj_mdp_21, t0.id_utilisateur AS id_utilisateur_22, t0.id_affectation AS id_affectation_23, t0.id_federation AS id_federation_24, t0.id_fop AS id_fop_25, t0.id_foprinci AS id_foprinci_26, t0.id_lieu AS id_lieu_27, t0.id_odm_cadre_general AS id_odm_cadre_general_28, t0.id_poste AS id_poste_29, t0.id_scan AS id_scan_30 FROM utilisateur_information t0 WHERE t0.id_information_personnelle = ?
Parameters:
[
  2347
]
2.25 ms
(23.18%)
1
SELECT r0_.id_odm_cadre_general AS id_odm_cadre_general_0, r0_.libelle_odm_cadre_general AS libelle_odm_cadre_general_1 FROM ref_odm_cadre_general r0_ ORDER BY r0_.id_odm_cadre_general ASC
Parameters:
[]
0.77 ms
(7.92%)
1
SELECT t0.id_role AS id_role_1, t0.libelle_role AS libelle_role_2, t0.description_role AS description_role_3, t0.ref_rh AS ref_rh_4 FROM ref_role 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\UtilisateurInformation No errors.
App\Entity\Utilisateur
  • The mappings App\Entity\Utilisateur#documents and App\Entity\Document#utilisateur are inconsistent with each other.
App\Entity\RefAffectation No errors.
App\Entity\RefFederation No errors.
App\Entity\RefFop No errors.
App\Entity\RefLieu No errors.
App\Entity\RefOdmCadreGeneral No errors.
App\Entity\RefPoste No errors.
App\Entity\ScanSignature No errors.
App\Entity\RefRole No errors.
App\Entity\Perimetre No errors.
App\Entity\Workflow No errors.
App\Entity\Droit No errors.