Symfony Profiler

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 = ?

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 = 2031;

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 = ?

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 = 4449;

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 = ?

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 = '47872';

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

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 = 5103 ORDER BY p0_.id_projet_lm DESC LIMIT 1;

SELECT
  p0_.value AS value_0
FROM
  parametre p0_
WHERE
  p0_.id_parametre = 3

SELECT p0_.value AS value_0 FROM parametre p0_ WHERE p0_.id_parametre = 3;

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

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 = 5103 ORDER BY l13_.date_de_signature DESC;

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

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 = 5103 AND w1_.id_workflow = 7 ORDER BY p0_.id_projet_lm DESC LIMIT 1;

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

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 = 9 LIMIT 1;

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

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 = 36 LIMIT 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 = ?

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 = 5103;

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

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 = 5103 LIMIT 1;

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

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 = 31 AND r2_.id_poste = 3 LIMIT 1;

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 = ?

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 = 47872;

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 = ?

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 = 69;

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 = ?

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 = 68;

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 = ?

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 = 208;

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 = ?

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 = 18;

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 = ?

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 = 4;

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 = ?

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 = 2;

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

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;

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

SELECT r0_.id_lieu AS id_lieu_0, r0_.libelle_lieu AS libelle_lieu_1 FROM ref_lieu r0_ WHERE (r0_.date_activation <= '2025-03-14 17:22:50' OR r0_.date_activation IS NULL) AND (r0_.date_desactivation > '2025-03-14 17:22:50' OR r0_.date_desactivation IS NULL) ORDER BY r0_.libelle_lieu ASC;

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

SELECT r0_.id_discipline AS id_discipline_0, r0_.libelle_discipline AS libelle_discipline_1 FROM ref_discipline r0_ WHERE (r0_.date_activation <= '2025-03-14 17:22:50' OR r0_.date_activation IS NULL) AND (r0_.id_federation = 31) AND (r0_.date_desactivation > '2025-03-14 17:22:50' OR r0_.date_desactivation IS NULL) ORDER BY r0_.libelle_discipline ASC;