Query Metrics
4
Database Queries
4
Different statements
4.78 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.96 ms (41.13%) |
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:
[
1426
]
|
1.43 ms (29.99%) |
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:
[
"MARTIND"
]
|
0.76 ms (15.83%) |
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:
[
3044
]
|
0.62 ms (13.05%) |
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:
[
79
]
|
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. |