http://cts-web.sports.gouv.fr/api/getDonneesPlm/47872

Query Metrics

22 Database Queries
19 Different statements
19.12 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.64 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:
[
  2031
]
2 0.74 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:
[
  4449
]
3 1.18 ms
SELECT t0.id_projet_lm AS id_projet_lm_1, t0.identifiant_plm AS identifiant_plm_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.contenu_encart AS contenu_encart_5, t0.contenu_champ_libre AS contenu_champ_libre_6, t0.contenu_precision_dtn AS contenu_precision_dtn_7, t0.contenu_precision_sh AS contenu_precision_sh_8, t0.adresse_activite AS adresse_activite_9, t0.ordre_de_mission_general AS ordre_de_mission_general_10, t0.localisation AS localisation_11, t0.fonctcomplementaire AS fonctcomplementaire_12, t0.ordre_de_mission_specifique AS ordre_de_mission_specifique_13, t0.droit_cts AS droit_cts_14, t0.version AS version_15, t0.date AS date_16, t0.saison_sportive AS saison_sportive_17, t0.validation AS validation_18, t0.id_utilisateur AS id_utilisateur_19, t0.parent_id_projet_lm AS parent_id_projet_lm_20, t0.id_lm AS id_lm_21, t0.id_utilisateur AS id_utilisateur_22, t0.id_fop AS id_fop_23, t0.id_workflow AS id_workflow_24, t0.parent_id_projet_lm AS parent_id_projet_lm_25, t0.id_lieu AS id_lieu_26, t0.id_discipline AS id_discipline_27 FROM projet_lettre_mission t0 WHERE t0.id_projet_lm = ?
Parameters:
[
  "47872"
]
4 1.19 ms
SELECT p0_.id_projet_lm AS id_projet_lm_0, p0_.identifiant_plm AS identifiant_plm_1, p0_.date_debut AS date_debut_2, p0_.date_fin AS date_fin_3, p0_.contenu_encart AS contenu_encart_4, p0_.contenu_champ_libre AS contenu_champ_libre_5, p0_.contenu_precision_dtn AS contenu_precision_dtn_6, p0_.contenu_precision_sh AS contenu_precision_sh_7, p0_.adresse_activite AS adresse_activite_8, p0_.ordre_de_mission_general AS ordre_de_mission_general_9, p0_.localisation AS localisation_10, p0_.fonctcomplementaire AS fonctcomplementaire_11, p0_.ordre_de_mission_specifique AS ordre_de_mission_specifique_12, p0_.droit_cts AS droit_cts_13, p0_.version AS version_14, p0_.date AS date_15, p0_.saison_sportive AS saison_sportive_16, p0_.validation AS validation_17, p0_.id_utilisateur AS id_utilisateur_18, p0_.parent_id_projet_lm AS parent_id_projet_lm_19, p0_.id_lm AS id_lm_20, p0_.id_utilisateur AS id_utilisateur_21, p0_.id_fop AS id_fop_22, p0_.id_workflow AS id_workflow_23, p0_.parent_id_projet_lm AS parent_id_projet_lm_24, p0_.id_lieu AS id_lieu_25, p0_.id_discipline AS id_discipline_26 FROM projet_lettre_mission p0_ INNER JOIN workflow w1_ ON p0_.id_workflow = w1_.id_workflow WHERE p0_.id_utilisateur = ? ORDER BY p0_.id_projet_lm DESC LIMIT 1
Parameters:
[
  5103
]
5 0.47 ms
SELECT p0_.value AS value_0 FROM parametre p0_ WHERE p0_.id_parametre = 3
Parameters:
[]
6 7.50 ms
SELECT u0_.id_utilisateur AS id_utilisateur_0, u0_.civilite AS civilite_1, u1_.id_role AS id_role_2, u0_.nom AS nom_3, u0_.prenom AS prenom_4, u0_.date_de_naissance AS date_de_naissance_5, u1_.courriel AS courriel_6, u1_.telephone_bureau AS telephone_bureau_7, u1_.telephone_portable AS telephone_portable_8, u0_.adresse AS adresse_9, u0_.login AS login_10, u1_.p_civ_matcle AS p_civ_matcle_11, r2_.id_poste AS id_poste_12, r2_.libelle_poste AS libelle_poste_13, u0_.fonction AS fonction_14, u0_.grade AS grade_15, u0_.indice_majore AS indice_majore_16, u0_.date_fin_droits AS date_fin_droits_17, r3_.libelle_fop AS libelle_fop_18, r4_.libelle_fop AS libelle_fop_19, r5_.libelle_fop AS libelle_fop_20, r6_.libelle_affectation AS libelle_affectation_21, r6_.libelle_long AS libelle_long_22, r7_.r_ser_libl AS r_ser_libl_23, r6_.id_affectation AS id_affectation_24, u0_.token AS token_25, r8_.id_odm_cadre_general AS id_odm_cadre_general_26, r8_.libelle_odm_cadre_general AS libelle_odm_cadre_general_27, r9_.id_federation AS id_federation_28, r9_.saison_sportive_federation AS saison_sportive_federation_29, r10_.libelle_role AS libelle_role_30, u0_.grade AS grade_31, u0_.indice_majore AS indice_majore_32, r9_.droit_ref_federation AS droit_ref_federation_33, s11_.path AS path_34, s11_.id AS id_35, r12_.id_lieu AS id_lieu_36, l13_.date_fin AS date_fin_37, l13_.date_de_signature AS date_de_signature_38 FROM utilisateur_information u0_ INNER JOIN utilisateur u1_ ON u0_.id_utilisateur = u1_.id_utilisateur INNER JOIN ref_role r10_ ON u1_.id_role = r10_.id_role LEFT JOIN lettre_mission l13_ ON (l13_.id_utilisateur = u0_.id_utilisateur AND l13_.signataire IS NOT NULL) LEFT JOIN ref_fop r4_ ON l13_.id_fop = r4_.id_fop LEFT JOIN ref_fop r3_ ON u0_.id_fop = r3_.id_fop LEFT JOIN ref_fop r5_ ON u0_.id_foprinci = r5_.id_fop LEFT JOIN ref_odm_cadre_general r8_ ON u0_.id_odm_cadre_general = r8_.id_odm_cadre_general LEFT JOIN ref_lieu r12_ ON u0_.id_lieu = r12_.id_lieu LEFT JOIN ref_federation r9_ ON u0_.id_federation = r9_.id_federation LEFT JOIN r_federation r7_ ON (r7_.r_adm_diside = r9_.r_adm_diside) LEFT JOIN ref_affectation r6_ ON u0_.id_affectation = r6_.id_affectation LEFT JOIN ref_poste r2_ ON u0_.id_poste = r2_.id_poste LEFT JOIN scan_signature s11_ ON u0_.id_scan = s11_.id WHERE u0_.id_utilisateur = ? ORDER BY l13_.date_de_signature DESC
Parameters:
[
  5103
]
7 0.64 ms
SELECT p0_.id_projet_lm AS id_projet_lm_0, p0_.identifiant_plm AS identifiant_plm_1, p0_.date_debut AS date_debut_2, p0_.date_fin AS date_fin_3, p0_.contenu_encart AS contenu_encart_4, p0_.contenu_champ_libre AS contenu_champ_libre_5, p0_.contenu_precision_dtn AS contenu_precision_dtn_6, p0_.contenu_precision_sh AS contenu_precision_sh_7, p0_.adresse_activite AS adresse_activite_8, p0_.ordre_de_mission_general AS ordre_de_mission_general_9, p0_.localisation AS localisation_10, p0_.fonctcomplementaire AS fonctcomplementaire_11, p0_.ordre_de_mission_specifique AS ordre_de_mission_specifique_12, p0_.droit_cts AS droit_cts_13, p0_.version AS version_14, p0_.date AS date_15, p0_.saison_sportive AS saison_sportive_16, p0_.validation AS validation_17, p0_.id_utilisateur AS id_utilisateur_18, p0_.parent_id_projet_lm AS parent_id_projet_lm_19, p0_.id_lm AS id_lm_20, p0_.id_utilisateur AS id_utilisateur_21, p0_.id_fop AS id_fop_22, p0_.id_workflow AS id_workflow_23, p0_.parent_id_projet_lm AS parent_id_projet_lm_24, p0_.id_lieu AS id_lieu_25, p0_.id_discipline AS id_discipline_26 FROM projet_lettre_mission p0_ INNER JOIN workflow w1_ ON p0_.id_workflow = w1_.id_workflow WHERE p0_.id_utilisateur = ? AND w1_.id_workflow = 7 ORDER BY p0_.id_projet_lm DESC LIMIT 1
Parameters:
[
  5103
]
8 0.33 ms
SELECT t0.id_fop AS id_fop_1, t0.libelle_fop AS libelle_fop_2, t0.date_activation AS date_activation_3, t0.date_desactivation AS date_desactivation_4 FROM ref_fop t0 WHERE t0.id_fop = ? LIMIT 1
Parameters:
[
  9
]
9 0.42 ms
SELECT t0.id_affectation AS id_affectation_1, t0.libelle_affectation AS libelle_affectation_2, t0.code_region AS code_region_3, t0.dom AS dom_4, t0.tom AS tom_5, t0.date_activation AS date_activation_6, t0.date_desactivation AS date_desactivation_7, t0.r_ser_ident AS r_ser_ident_8, t0.libelle_long AS libelle_long_9, t0.text_DGCS_dr_ds AS text_dgcs_dr_ds_10, t0.calendrier_scolaire AS calendrier_scolaire_11, t0.date_bascule AS date_bascule_12, t0.date_debut_credit AS date_debut_credit_13, t0.date_fin_credit AS date_fin_credit_14, t0.date_fin_debit AS date_fin_debit_15, t0.date_debut_debit AS date_debut_debit_16 FROM ref_affectation t0 WHERE t0.id_affectation = ? LIMIT 1
Parameters:
[
  36
]
10 0.36 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:
[
  5103
]
11 0.42 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_utilisateur = ? LIMIT 1
Parameters:
[
  5103
]
12 0.60 ms
SELECT u0_.id_information_personnelle AS id_information_personnelle_0, u0_.id_utilisateur AS id_utilisateur_1, u0_.civilite AS civilite_2, u0_.prenom AS prenom_3, u0_.nom AS nom_4, u0_.date_de_naissance AS date_de_naissance_5, u0_.login AS login_6, u0_.mot_de_passe AS mot_de_passe_7, u0_.utilisateur_actif AS utilisateur_actif_8, u0_.fonction AS fonction_9, u0_.date_fin_droits AS date_fin_droits_10, u0_.tentative AS tentative_11, u0_.adresse AS adresse_12, u0_.grade AS grade_13, u0_.indice_majore AS indice_majore_14, u0_.date_blocage AS date_blocage_15, u0_.token AS token_16, u0_.jeton_mdp AS jeton_mdp_17, u0_.courriel_mdp AS courriel_mdp_18, u0_.navigation AS navigation_19, u0_.date_maj_mdp AS date_maj_mdp_20, u0_.id_utilisateur AS id_utilisateur_21, u0_.id_affectation AS id_affectation_22, u0_.id_federation AS id_federation_23, u0_.id_fop AS id_fop_24, u0_.id_foprinci AS id_foprinci_25, u0_.id_lieu AS id_lieu_26, u0_.id_odm_cadre_general AS id_odm_cadre_general_27, u0_.id_poste AS id_poste_28, u0_.id_scan AS id_scan_29 FROM utilisateur_information u0_ INNER JOIN ref_federation r1_ ON u0_.id_federation = r1_.id_federation INNER JOIN ref_poste r2_ ON u0_.id_poste = r2_.id_poste WHERE r1_.id_federation = ? AND r2_.id_poste = 3 LIMIT 1
Parameters:
[
  31
]
13 0.57 ms
SELECT t0.id_discipline AS id_discipline_1, t0.id_lm AS id_lm_2, t0.id_plm AS id_plm_3 FROM ref_discipline_lm t0 WHERE t0.id_plm = ?
Parameters:
[
  47872
]
14 0.46 ms
SELECT t0.id_discipline AS id_discipline_1, t0.libelle_discipline AS libelle_discipline_2, t0.olympique AS olympique_3, t0.haut_niveau AS haut_niveau_4, t0.autre AS autre_5, t0.date_activation AS date_activation_6, t0.date_desactivation AS date_desactivation_7, t0.id_federation AS id_federation_8 FROM ref_discipline t0 WHERE t0.id_discipline = ?
Parameters:
[
  69
]
15 0.30 ms
SELECT t0.id_discipline AS id_discipline_1, t0.libelle_discipline AS libelle_discipline_2, t0.olympique AS olympique_3, t0.haut_niveau AS haut_niveau_4, t0.autre AS autre_5, t0.date_activation AS date_activation_6, t0.date_desactivation AS date_desactivation_7, t0.id_federation AS id_federation_8 FROM ref_discipline t0 WHERE t0.id_discipline = ?
Parameters:
[
  68
]
16 0.29 ms
SELECT t0.id_discipline AS id_discipline_1, t0.libelle_discipline AS libelle_discipline_2, t0.olympique AS olympique_3, t0.haut_niveau AS haut_niveau_4, t0.autre AS autre_5, t0.date_activation AS date_activation_6, t0.date_desactivation AS date_desactivation_7, t0.id_federation AS id_federation_8 FROM ref_discipline t0 WHERE t0.id_discipline = ?
Parameters:
[
  208
]
17 0.28 ms
SELECT t0.id_fop AS id_fop_1, t0.libelle_fop AS libelle_fop_2, t0.date_activation AS date_activation_3, t0.date_desactivation AS date_desactivation_4 FROM ref_fop t0 WHERE t0.id_fop = ?
Parameters:
[
  18
]
18 0.28 ms
SELECT t0.id_lieu AS id_lieu_1, t0.libelle_lieu AS libelle_lieu_2, t0.date_activation AS date_activation_3, t0.date_desactivation AS date_desactivation_4 FROM ref_lieu t0 WHERE t0.id_lieu = ?
Parameters:
[
  4
]
19 0.29 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:
[
  2
]
20 0.33 ms
SELECT t0.id_fop AS id_fop_1, t0.libelle_fop AS libelle_fop_2, t0.date_activation AS date_activation_3, t0.date_desactivation AS date_desactivation_4 FROM ref_fop t0
Parameters:
[]
21 0.44 ms
SELECT r0_.id_lieu AS id_lieu_0, r0_.libelle_lieu AS libelle_lieu_1 FROM ref_lieu r0_ WHERE (r0_.date_activation <= ? OR r0_.date_activation IS NULL) AND (r0_.date_desactivation > ? OR r0_.date_desactivation IS NULL) ORDER BY r0_.libelle_lieu ASC
Parameters:
[
  "2025-03-14 17:22:50"
  "2025-03-14 17:22:50"
]
22 0.38 ms
SELECT r0_.id_discipline AS id_discipline_0, r0_.libelle_discipline AS libelle_discipline_1 FROM ref_discipline r0_ WHERE (r0_.date_activation <= ? OR r0_.date_activation IS NULL) AND (r0_.id_federation = 31) AND (r0_.date_desactivation > ? OR r0_.date_desactivation IS NULL) ORDER BY r0_.libelle_discipline ASC
Parameters:
[
  "2025-03-14 17:22:50"
  "2025-03-14 17:22:50"
]

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\ProjetLettreMission No errors.
App\Entity\Workflow No errors.
App\Entity\RefDiscipline No errors.
App\Entity\Mission No errors.
App\Entity\PlmActiviteIndic No errors.
App\Entity\PlmIndicateurAutre No errors.
App\Entity\PlmActiviteAutre No errors.
App\Entity\Parametre No errors.
App\Entity\RFederation No errors.
App\Entity\RefDisciplineLm No errors.
App\Entity\Odm No errors.