Query Metrics
10
Database Queries
7
Different statements
8.01 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.98 ms |
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:
[
618
]
|
2 | 0.83 ms |
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:
[
2198
]
|
3 | 1.41 ms |
SELECT t0.id AS id_1, t0.date_demande AS date_demande_2, t0.date_derniere_modification AS date_derniere_modification_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.nb_jour AS nb_jour_6, t0.avis_dtn AS avis_dtn_7, t0.motif_conge AS motif_conge_8, t0.piece_motif AS piece_motif_9, t0.commentaire_sh AS commentaire_sh_10, t0.commentaire_dtn AS commentaire_dtn_11, t0.id_utilisateur AS id_utilisateur_12, t0.id_workflow AS id_workflow_13, t0.id_conge_type AS id_conge_type_14, t0.id_date_debut_type AS id_date_debut_type_15, t0.id_date_fin_type AS id_date_fin_type_16 FROM conge t0 WHERE t0.id_workflow IN (?, ?, ?) AND t0.id_utilisateur = ? ORDER BY t0.date_debut DESC
Parameters:
[ 21 18 22 2198 ] |
4 | 0.68 ms |
SELECT t0.id AS id_1, t0.date_demande AS date_demande_2, t0.date_derniere_modification AS date_derniere_modification_3, t0.nb_jour AS nb_jour_4, t0.commentaires AS commentaires_5, t0.type_calendrier AS type_calendrier_6, t0.annee AS annee_7, t0.type AS type_8, t0.utilisateur AS utilisateur_9, t0.workflow AS workflow_10, t0.affectation AS affectation_11 FROM demande_report t0 WHERE t0.workflow IN (?, ?, ?) AND t0.utilisateur = ?
Parameters:
[ 31 32 33 2198 ] |
5 | 0.55 ms |
SELECT t0.id_workflow AS id_workflow_1, t0.libelle_action AS libelle_action_2, t0.description_action AS description_action_3, t0.categorie AS categorie_4, t0.population AS population_5, t0.etape AS etape_6, t0.acteur AS acteur_7 FROM workflow t0 WHERE t0.id_workflow = ?
Parameters:
[
21
]
|
6 | 0.61 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.code AS code_4, t0.rempli_sup_hiera AS rempli_sup_hiera_5 FROM conge_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
7 | 0.60 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM conge_date_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
8 | 0.43 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.code AS code_4, t0.rempli_sup_hiera AS rempli_sup_hiera_5 FROM conge_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
9 | 0.46 ms |
SELECT t0.id_workflow AS id_workflow_1, t0.libelle_action AS libelle_action_2, t0.description_action AS description_action_3, t0.categorie AS categorie_4, t0.population AS population_5, t0.etape AS etape_6, t0.acteur AS acteur_7 FROM workflow t0 WHERE t0.id_workflow = ?
Parameters:
[
22
]
|
10 | 0.46 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM conge_date_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\Conge | No errors. |
App\Entity\Workflow | No errors. |
App\Entity\CongeType | No errors. |
App\Entity\CongeDateType | No errors. |
App\Entity\DemandeReport | No errors. |
App\Entity\ProjetLettreMission | No errors. |
App\Entity\Odm | No errors. |