Query Metrics
4
Database Queries
4
Different statements
8.22 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.28 ms (64.15%) |
1 |
SELECT l0_.id_lm AS id_lm_0, l0_.saison_sportive AS saison_sportive_1, l0_.ordre_de_mission_general AS ordre_de_mission_general_2, r1_.libelle_role AS libelle_role_3, p2_.parent_id_projet_lm AS sclr_4, p2_.id_projet_lm AS id_projet_lm_5, p2_.identifiant_plm AS identifiant_plm_6, p2_.date_debut AS date_debut_7, p2_.date_fin AS date_fin_8, r3_.libelle_fop AS libelle_fop_9, w4_.etape AS etape_10, r5_.r_adm_diside AS r_adm_diside_11, r6_.libelle_long AS libelle_long_12 FROM lettre_mission l0_ LEFT JOIN utilisateur u7_ ON l0_.id_utilisateur = u7_.id_utilisateur LEFT JOIN ref_role r1_ ON (r1_.id_role = u7_.id_role) LEFT JOIN projet_lettre_mission p2_ ON (p2_.id_lm = l0_.id_lm) LEFT JOIN ref_fop r3_ ON l0_.id_fop = r3_.id_fop LEFT JOIN workflow w4_ ON (p2_.id_workflow = w4_.id_workflow) LEFT JOIN utilisateur_information u8_ ON (u7_.id_utilisateur = u8_.id_utilisateur) INNER JOIN ref_federation r5_ ON u8_.id_federation = r5_.id_federation LEFT JOIN ref_affectation r6_ ON u8_.id_affectation = r6_.id_affectation WHERE 1 = 1 AND l0_.id_utilisateur = ? AND p2_.id_workflow = 7 AND p2_.date_debut <= ? AND p2_.date_fin >= ? ORDER BY l0_.id_lm DESC LIMIT 1
Parameters:
[ 3890 "2024-09-19" "2024-09-19" ] |
1.63 ms (19.77%) |
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:
[
761
]
|
0.69 ms (8.38%) |
1 |
SELECT r0_.r_ser_libl AS r_ser_libl_0 FROM r_federation r0_ WHERE r0_.r_adm_diside = ?
Parameters:
[
"HOC"
]
|
0.63 ms (7.70%) |
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:
[
3890
]
|
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\ProjetLettreMission | No errors. |
App\Entity\Workflow | No errors. |
App\Entity\RFederation | No errors. |