http://cts-web.sports.gouv.fr/api/conges/archive/2198

Query Metrics

10 Database Queries
7 Different statements
8.01 ms Query time
3 Invalid entities

Queries

Group similar statements

# 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
  • 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\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.