Query Metrics
4
Database Queries
4
Different statements
9.72 ms
Query time
1
Invalid entities
Grouped Statements
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 |
|
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. |