Query Metrics
10
Database Queries
10
Different statements
23.20 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.61 ms (28.51%) |
1 |
SELECT u0_.civilite AS civilite_0, u0_.nom AS nom_1, u0_.prenom AS prenom_2, r1_.id_affectation AS id_affectation_3, r2_.id_federation AS id_federation_4, r1_.libelle_affectation AS libelle_affectation_5, r3_.libelle_poste AS libelle_poste_6, r4_.r_ser_libl AS r_ser_libl_7, c5_.id AS id_8, c5_.date_debut AS date_debut_9, c5_.date_fin AS date_fin_10, c5_.nb_jour AS nb_jour_11, w6_.libelle_action AS libelle_action_12, c5_.avis_dtn AS avis_dtn_13, c7_.libelle AS libelle_14, c8_.libelle AS libelle_15, c9_.libelle AS libelle_16, w6_.id_workflow AS id_workflow_17, c5_.piece_motif AS piece_motif_18, c5_.motif_conge AS motif_conge_19, c5_.commentaire_sh AS commentaire_sh_20, c5_.commentaire_dtn AS commentaire_dtn_21 FROM conge c5_ INNER JOIN conge_type c7_ ON c5_.id_conge_type = c7_.id INNER JOIN conge_date_type c8_ ON c5_.id_date_debut_type = c8_.id INNER JOIN conge_date_type c9_ ON c5_.id_date_fin_type = c9_.id INNER JOIN workflow w6_ ON c5_.id_workflow = w6_.id_workflow INNER JOIN utilisateur u10_ ON c5_.id_utilisateur = u10_.id_utilisateur INNER JOIN utilisateur_information u0_ ON (c5_.id_utilisateur = u0_.id_utilisateur) INNER JOIN ref_affectation r1_ ON u0_.id_affectation = r1_.id_affectation INNER JOIN ref_federation r2_ ON u0_.id_federation = r2_.id_federation INNER JOIN r_federation r4_ ON (r2_.r_adm_diside = r4_.r_adm_diside) INNER JOIN ref_poste r3_ ON u0_.id_poste = r3_.id_poste WHERE ((w6_.id_workflow = ?) OR (w6_.id_workflow = ?)) AND r2_.r_adm_diside = ? AND c5_.avis_dtn IS NULL
Parameters:
[ 16 17 "JUD" ] |
5.67 ms (24.43%) |
1 |
SELECT COUNT(p0_.id_projet_lm) AS sclr_0 FROM projet_lettre_mission p0_ INNER JOIN utilisateur_information u1_ ON (u1_.id_utilisateur = p0_.id_utilisateur) WHERE p0_.id_utilisateur IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id_workflow IN (4) AND u1_.id_poste <> 3 AND p0_.version = (SELECT MAX(p2_.version) AS sclr_1 FROM projet_lettre_mission p2_ WHERE p2_.id_lm = p0_.id_lm AND p2_.id_utilisateur IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND u1_.utilisateur_actif = true
Parameters:
[ 5036 3218 3057 2283 5051 4362 5013 2703 3853 4765 2976 4769 2978 4771 3766 4774 4655 4775 4292 1977 3145 2866 3811 2472 3546 3022 2613 3855 3236 2770 2553 4928 2117 3806 3757 2471 2441 2449 4061 3495 4855 4744 4223 2630 2570 2740 3028 4217 4376 3127 2516 3239 4103 2229 3929 2621 1987 3444 2651 2918 4469 3862 2927 2519 2226 2439 2438 2351 2824 3099 3375 3562 3964 4366 2061 4965 4964 3768 2641 5036 3218 3057 2283 5051 4362 5013 2703 3853 4765 2976 4769 2978 4771 3766 4774 4655 4775 4292 1977 3145 2866 3811 2472 3546 3022 2613 3855 3236 2770 2553 4928 2117 3806 3757 2471 2441 2449 4061 3495 4855 4744 4223 2630 2570 2740 3028 4217 4376 3127 2516 3239 4103 2229 3929 2621 1987 3444 2651 2918 4469 3862 2927 2519 2226 2439 2438 2351 2824 3099 3375 3562 3964 4366 2061 4965 4964 3768 2641 ] |
3.18 ms (13.70%) |
1 |
SELECT COUNT(o0_.id_odm) AS sclr_0 FROM odm o0_ INNER JOIN evenement e1_ ON o0_.id_odm = e1_.id_odm LEFT JOIN utilisateur_information u2_ ON (e1_.id_utilisateur = u2_.id_utilisateur) LEFT JOIN ref_federation r3_ ON u2_.id_federation = r3_.id_federation INNER JOIN utilisateur u4_ ON (u2_.id_utilisateur = u4_.id_utilisateur) WHERE o0_.id_workflow = ? AND u2_.utilisateur_actif = true AND r3_.federation_active = true AND o0_.avis_dtn IS NULL AND o0_.date_de_depart >= ? AND u4_.id_role = ? AND u2_.id_federation = ?
Parameters:
[ 10 "2024-09-19 16:11:46" 2 36 ] |
2.73 ms (11.78%) |
1 |
SELECT fs.id_formation_session, ui.id_utilisateur, ui.civilite, ui.nom,ui.prenom, ui.adresse,ra.id_affectation, ui.id_affectation as affectation_id, ra.libelle_affectation, rf.id_federation, r_f.r_ser_libl, rp.libelle_poste, fs.titre, ft.libelle_formation, fs.libelle_organisme, ft.id_formation_type, w.id_workflow, w.libelle_action, fs.date_debut, fs.date_fin, fs.nb_jours,commentaire_sh,commentaire_dtn,date_avis_dtn,date_sgn_sh, fs.avis_dtn, fs.avis_sh, fs.nom_responsable, fs.prenom_responsable, fs.mail_responsable, fs.telephone_responsable, fs.lien, fs.presentation, fs.titre_session, fs.lieu_formation, fs.titre, u.id_role, u.courriel,u.telephone_portable as telephonePortable FROM formation_session fs INNER JOIN utilisateur_information ui ON fs.id_utilisateur = ui.id_utilisateur INNER JOIN ref_affectation ra on ui.id_affectation = ra.id_affectation INNER JOIN ref_federation rf ON ui.id_federation = rf.id_federation INNER JOIN r_federation r_f ON rf.r_adm_diside = r_f.r_adm_diside INNER JOIN ref_poste rp ON rp.id_poste = ui.id_poste INNER JOIN formation_type ft ON fs.id_formation_type = ft.id_formation_type INNER JOIN workflow w ON fs.id_workflow = w.id_workflow INNER JOIN utilisateur u ON ui.id_utilisateur = u.id_utilisateur WHERE ui.id_federation = 36 and fs.id_workflow IN (23) AND fs.avis_dtn IS NULL ORDER BY fs.id_formation_session DESC
Parameters:
[] |
1.49 ms (6.43%) |
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
]
|
1.03 ms (4.43%) |
1 |
SELECT COUNT(l0_.id) AS sclr_0 FROM liste_diffusion_sup l0_ INNER JOIN article a1_ ON l0_.id_article = a1_.id WHERE a1_.DateFinPublication >= ? AND a1_.datePublication <= ? AND l0_.id_utilisateur = ? AND a1_.Statut = true AND l0_.lu = false
Parameters:
[ "2024-09-19" "2024-09-19" 4855 ] |
0.91 ms (3.90%) |
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_federation = ?
Parameters:
[
36
]
|
0.66 ms (2.85%) |
1 |
select * from documentservice ds where ds.type ='DS' or ds.type ='DR' or (ds.type='FD' and ds.id_federation=36)
Parameters:
[] |
0.58 ms (2.50%) |
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.34 ms (1.45%) |
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\Odm | No errors. |
App\Entity\ListeDiffusion | No errors. |
App\Entity\ListeDiffusionSup | No errors. |
App\Entity\ProjetLettreMission | No errors. |
App\Entity\FormationSession | No errors. |
App\Entity\DocumentService | No errors. |
App\Entity\RefRole | 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\Evenement | No errors. |
App\Entity\Conge | No errors. |
App\Entity\RefDiscipline | No errors. |
App\Entity\CongeType | No errors. |
App\Entity\CongeDateType | No errors. |
App\Entity\Workflow | No errors. |
App\Entity\RFederation | No errors. |