Query Metrics
3
Database Queries
3
Different statements
3.60 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.29 ms (63.63%) |
1 |
SELECT u0_.id_information_personnelle AS id_information_personnelle_0, u0_.id_utilisateur AS id_utilisateur_1, u0_.civilite AS civilite_2, u0_.prenom AS prenom_3, u0_.nom AS nom_4, u0_.date_de_naissance AS date_de_naissance_5, u0_.login AS login_6, u0_.mot_de_passe AS mot_de_passe_7, u0_.utilisateur_actif AS utilisateur_actif_8, u0_.fonction AS fonction_9, u0_.date_fin_droits AS date_fin_droits_10, u0_.tentative AS tentative_11, u0_.adresse AS adresse_12, u0_.grade AS grade_13, u0_.indice_majore AS indice_majore_14, u0_.date_blocage AS date_blocage_15, u0_.token AS token_16, u0_.jeton_mdp AS jeton_mdp_17, u0_.courriel_mdp AS courriel_mdp_18, u0_.navigation AS navigation_19, u0_.date_maj_mdp AS date_maj_mdp_20, u0_.id_utilisateur AS id_utilisateur_21, u0_.id_affectation AS id_affectation_22, u0_.id_federation AS id_federation_23, u0_.id_fop AS id_fop_24, u0_.id_foprinci AS id_foprinci_25, u0_.id_lieu AS id_lieu_26, u0_.id_odm_cadre_general AS id_odm_cadre_general_27, u0_.id_poste AS id_poste_28, u0_.id_scan AS id_scan_29 FROM utilisateur_information u0_ WHERE u0_.login = ? AND u0_.utilisateur_actif = true
Parameters:
[
"BOYEVALEROA"
]
|
0.79 ms (21.89%) |
1 |
SELECT t0.id_utilisateur AS id_utilisateur_1, t0.id_role AS id_role_2, t0.courriel AS courriel_3, t0.p_civ_matcle AS p_civ_matcle_4, t0.date_connexion AS date_connexion_5, t0.date_creation AS date_creation_6, t0.droit_lm_utilisateur AS droit_lm_utilisateur_7, t0.telephone_bureau AS telephone_bureau_8, t0.telephone_portable AS telephone_portable_9, t0.alerte_identifiant AS alerte_identifiant_10, t0.restitution_cache AS restitution_cache_11, t0.first_pwd AS first_pwd_12, t0.fl_superieur_hierarchique AS fl_superieur_hierarchique_13, t0.id_role AS id_role_14 FROM utilisateur t0 WHERE t0.id_utilisateur = ?
Parameters:
[
4855
]
|
0.52 ms (14.49%) |
1 |
SELECT t0.id_federation AS id_federation_1, t0.saison_sportive_federation AS saison_sportive_federation_2, t0.sport_federation AS sport_federation_3, t0.r_adm_diside AS r_adm_diside_4, t0.federation_active AS federation_active_5, t0.droit_ref_federation AS droit_ref_federation_6, t0.text_DTG_dtn AS text_dtg_dtn_7 FROM ref_federation t0 WHERE t0.id_federation = ?
Parameters:
[
36
]
|
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\ListeDiffusion | No errors. |
App\Entity\ListeDiffusionSup | No errors. |
App\Entity\HistoFederation | No errors. |
App\Entity\HistoAffectation | No errors. |
App\Entity\HistoPoste | No errors. |
App\Entity\Article |
|
App\Entity\Document |
|
App\Entity\LettreMission | No errors. |
App\Entity\RefDiscipline | No errors. |