Query Metrics
6
Database Queries
6
Different statements
211.99 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
171.00 ms (80.67%) |
1 |
Select ui.civilite,ui.nom,ui.prenom,u.id_role,poste.libelle_poste,plm.id_projet_lm,plm.id_utilisateur,plm.date_fin,plm.date_debut, u.p_civ_matcle as matricule_agent, ui.grade, ui.indice_majore, ui.adresse, ui_fop.libelle_fop as ui_fonction_compl, ui_cg.libelle_odm_cadre_general as ui_cadre_general, affectation.libelle_long,plm.id_workflow,wf.libelle_action,ui.id_federation,ui.id_affectation,rf.r_ser_libl, plm.id_lieu, plm.ordre_de_mission_general, plm.saison_sportive, rf.r_adm_diside,rf.r_ser_libc, rfop.id_fop, rfop.libelle_fop, plm.date,lm.date_changement_administratif from utilisateur_information ui INNER JOIN projet_lettre_mission plm ON ui.id_utilisateur = plm.id_utilisateur INNER JOIN ref_affectation affectation ON ui.id_affectation = affectation.id_affectation INNER JOIN ref_federation federation ON ui.id_federation = federation.id_federation INNER JOIN ref_poste poste ON ui.id_poste = poste.id_poste INNER JOIN r_federation rf ON federation.r_adm_diside = rf.r_adm_diside INNER JOIN workflow wf ON plm.id_workflow = wf.id_workflow INNER JOIN ref_fop rfop ON plm.id_fop = rfop.id_fop LEFT JOIN ref_fop ui_fop ON ui.id_fop = ui_fop.id_fop LEFT JOIN ref_odm_cadre_general ui_cg ON ui.id_odm_cadre_general = ui_cg.id_odm_cadre_general INNER JOIN utilisateur u ON ui.id_utilisateur = u.id_utilisateur INNER JOIN lettre_mission lm ON plm.id_lm = lm.id_lm where plm.id_projet_lm = (SELECT Max(plm2.id_projet_lm) from projet_lettre_mission plm2 INNER JOIN projet_lettre_mission plm3 ON plm2.id_lm = plm3.id_lm where plm3.id_workflow != 8 AND plm2.id_utilisateur = plm.id_utilisateur ) AND ui.utilisateur_actif = true AND federation.federation_active = true AND u.droit_lm_utilisateur = true AND ui.id_federation = 36 and plm.id_workflow IN (2,3,4,5,6,7) and ui.id_poste != 3 and u.id_role != 8 UNION Select ui.civilite,ui.nom,ui.prenom,u.id_role,poste.libelle_poste,plm.id_projet_lm,plm.id_utilisateur,plm.date_fin,plm.date_debut, u.p_civ_matcle as matricule_agent, ui.grade, ui.indice_majore, ui.adresse, ui_fop.libelle_fop as ui_fonction_compl, ui_cg.libelle_odm_cadre_general as ui_cadre_general, affectation.libelle_long,plm.id_workflow,wf.libelle_action,ui.id_federation,ui.id_affectation,rf.r_ser_libl, plm.id_lieu, plm.ordre_de_mission_general, plm.saison_sportive, rf.r_adm_diside,rf.r_ser_libc, rfop.id_fop, rfop.libelle_fop, plm.date,lm.date_changement_administratif from utilisateur_information ui INNER JOIN projet_lettre_mission plm ON ui.id_utilisateur = plm.id_utilisateur INNER JOIN ref_affectation affectation ON ui.id_affectation = affectation.id_affectation INNER JOIN ref_federation federation ON ui.id_federation = federation.id_federation INNER JOIN ref_poste poste ON ui.id_poste = poste.id_poste INNER JOIN r_federation rf ON federation.r_adm_diside = rf.r_adm_diside INNER JOIN workflow wf ON plm.id_workflow = wf.id_workflow INNER JOIN ref_fop rfop ON plm.id_fop = rfop.id_fop LEFT JOIN ref_fop ui_fop ON ui.id_fop = ui_fop.id_fop LEFT JOIN ref_odm_cadre_general ui_cg ON ui.id_odm_cadre_general = ui_cg.id_odm_cadre_general INNER JOIN utilisateur u ON ui.id_utilisateur = u.id_utilisateur INNER JOIN lettre_mission lm ON plm.id_lm = lm.id_lm where plm.id_projet_lm = (SELECT Max(plm2.id_projet_lm) FROM projet_lettre_mission plm2 where plm2.id_utilisateur = ui.id_utilisateur ) and plm.id_utilisateur = 4855 and u.droit_lm_utilisateur = true and plm.id_workflow NOT IN (7,8) and ui.utilisateur_actif = true AND federation.federation_active = true order by nom
Parameters:
[] |
32.50 ms (15.33%) |
1 |
Select ui.id_utilisateur,ui.civilite,ui.nom,u.id_role,ui.prenom,poste.libelle_poste,affectation.libelle_long, ui.id_federation,ui.id_affectation, u.p_civ_matcle as matricule_agent, ui.grade, ui.indice_majore, ui.adresse, ui_fop.libelle_fop as ui_fonction_compl, ui_cg.libelle_odm_cadre_general as ui_cadre_general, rf.r_ser_libl,rf.r_adm_diside,rf.r_ser_libc from utilisateur_information ui LEFT JOIN ref_fop ui_fop ON ui.id_fop = ui_fop.id_fop LEFT JOIN ref_odm_cadre_general ui_cg ON ui.id_odm_cadre_general = ui_cg.id_odm_cadre_general INNER JOIN utilisateur u ON ui.id_utilisateur = u.id_utilisateur INNER JOIN ref_affectation affectation ON ui.id_affectation = affectation.id_affectation INNER JOIN ref_federation federation ON ui.id_federation = federation.id_federation INNER JOIN ref_poste poste ON ui.id_poste = poste.id_poste INNER JOIN r_federation rf ON federation.r_adm_diside = rf.r_adm_diside WHERE ui.utilisateur_actif = true AND federation.federation_active = true AND ui.id_utilisateur NOT IN (SELECT plm3.id_utilisateur FROM projet_lettre_mission plm3) AND ui.id_federation = 36 and poste.id_poste != 3 and u.droit_lm_utilisateur = true UNION SELECT Distinct(ui2.id_utilisateur),ui2.civilite,ui2.nom,u.id_role,ui2.prenom,poste.libelle_poste,affectation.libelle_long, ui2.id_federation,ui2.id_affectation, u.p_civ_matcle as matricule_agent, ui2.grade, ui2.indice_majore, ui2.adresse, ui_fop.libelle_fop as ui_fonction_compl, ui_cg.libelle_odm_cadre_general as ui_cadre_general, rf.r_ser_libl,rf.r_adm_diside,rf.r_ser_libc from utilisateur_information ui2 LEFT JOIN ref_fop ui_fop ON ui2.id_fop = ui_fop.id_fop LEFT JOIN ref_odm_cadre_general ui_cg ON ui2.id_odm_cadre_general = ui_cg.id_odm_cadre_general INNER JOIN projet_lettre_mission plm ON ui2.id_utilisateur = plm.id_utilisateur INNER JOIN utilisateur u ON ui2.id_utilisateur = u.id_utilisateur INNER JOIN ref_affectation affectation ON ui2.id_affectation = affectation.id_affectation INNER JOIN ref_federation federation ON ui2.id_federation = federation.id_federation INNER JOIN ref_poste poste ON ui2.id_poste = poste.id_poste INNER JOIN r_federation rf ON federation.r_adm_diside = rf.r_adm_diside INNER JOIN lettre_mission lm ON plm.id_lm = lm.id_lm AND ui2.utilisateur_actif = true AND federation.federation_active = true and u.droit_lm_utilisateur = true and poste.id_poste != 3 and ui2.id_federation = 36 and exists (select * from projet_lettre_mission plm2 where plm2.id_utilisateur = ui2.id_utilisateur and plm2.id_workflow = 8 and not exists (select * from projet_lettre_mission plm3 where plm3.id_utilisateur = ui2.id_utilisateur and plm3.id_workflow != 8 and plm2.id_projet_lm < plm3.id_projet_lm))
Parameters:
[] |
5.43 ms (2.56%) |
1 |
SELECT p0_.id_utilisateur AS id_utilisateur_0 FROM projet_lettre_mission p0_ INNER JOIN utilisateur_information u1_ ON (u1_.id_utilisateur = p0_.id_utilisateur) WHERE p0_.id_workflow = ? AND p0_.date_fin >= ? AND p0_.id_utilisateur IS NOT NULL AND u1_.id_federation = ?
Parameters:
[ 7 "2024-09-19 16:44:14" 36 ] |
1.68 ms (0.79%) |
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:
[
2446
]
|
0.74 ms (0.35%) |
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.64 ms (0.30%) |
1 |
SELECT p0_.value AS value_0 FROM parametre p0_ WHERE p0_.id_parametre = 3
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\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\Parametre | No errors. |