http://cts-web.sports.gouv.fr/login_check Return to referer URL

Query Metrics

4 Database Queries
4 Different statements
4.78 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

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
  • 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\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
  • The mappings App\Entity\Article#mediasCategorie and App\Entity\Media#articlecategorie are inconsistent with each other.
App\Entity\Document
  • The association App\Entity\Document#utilisateur refers to the inverse side field App\Entity\Utilisateur#Documents which does not exist.
  • The association App\Entity\Document#auteur refers to the inverse side field App\Entity\Utilisateur#Documents which does not exist.
App\Entity\LettreMission No errors.
App\Entity\RefDiscipline No errors.