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

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

SELECT
  p0_.id_utilisateur AS id_utilisateur_0
FROM
  projet_lettre_mission p0_
  INNER JOIN utilisateur_information u1_ ON (
    u1_.id_utilisateur = p0_.id_utilisateur
  )
WHERE
  p0_.id_workflow = ?
  AND p0_.date_fin >= ?
  AND p0_.id_utilisateur IS NOT NULL
  AND u1_.id_affectation = ?

SELECT p0_.id_utilisateur AS id_utilisateur_0 FROM projet_lettre_mission p0_ INNER JOIN utilisateur_information u1_ ON (u1_.id_utilisateur = p0_.id_utilisateur) WHERE p0_.id_workflow = 7 AND p0_.date_fin >= '2025-06-14 06:28:05' AND p0_.id_utilisateur IS NOT NULL AND u1_.id_affectation = 31;

SELECT
  ui.civilite,
  ui.nom,
  ui.prenom,
  u.id_role,
  poste.libelle_poste,
  u.p_civ_matcle as matricule_agent,
  ui.grade,
  ui.indice_majore,
  ui.adresse,
  ui_fop.libelle_fop as ui_fonction_compl,
  ui_cg.libelle_odm_cadre_general as ui_cadre_general,
  plm.id_projet_lm,
  plm.id_utilisateur,
  plm.date_fin,
  plm.date_debut,
  affectation.libelle_long,
  plm.id_workflow,
  plm.id_lieu,
  plm.ordre_de_mission_general,
  plm.saison_sportive,
  wf.libelle_action,
  ui.id_federation,
  ui.id_affectation,
  rf.r_ser_libl,
  rf.r_adm_diside,
  rf.r_ser_libc,
  rfop.id_fop,
  rfop.libelle_fop,
  lm.date_changement_administratif,
  plm.date
from
  utilisateur_information ui
  INNER JOIN projet_lettre_mission plm ON ui.id_utilisateur = plm.id_utilisateur
  INNER JOIN ref_affectation affectation ON ui.id_affectation = affectation.id_affectation
  INNER JOIN ref_federation federation ON ui.id_federation = federation.id_federation
  INNER JOIN ref_poste poste ON ui.id_poste = poste.id_poste
  INNER JOIN r_federation rf ON federation.r_adm_diside = rf.r_adm_diside
  INNER JOIN workflow wf ON plm.id_workflow = wf.id_workflow
  INNER JOIN ref_fop rfop ON plm.id_fop = rfop.id_fop
  LEFT JOIN ref_fop ui_fop ON ui.id_fop = ui_fop.id_fop
  LEFT JOIN ref_odm_cadre_general ui_cg ON ui.id_odm_cadre_general = ui_cg.id_odm_cadre_general
  INNER JOIN utilisateur u ON ui.id_utilisateur = u.id_utilisateur
  INNER JOIN lettre_mission lm ON plm.id_lm = lm.id_lm
where
  plm.id_projet_lm = (
    SELECT
      MAX(plm2.id_projet_lm)
    FROM
      projet_lettre_mission plm2
    where
      plm2.id_utilisateur = ui.id_utilisateur
  )
  AND ui.utilisateur_actif = true
  AND federation.federation_active = true
  AND federation.federation_active = true
  AND u.droit_lm_utilisateur = true
  AND ui.id_affectation = 31
  and plm.id_workflow IN (2, 4, 3, 5, 6)
order by
  ui.nom

SELECT ui.civilite,ui.nom,ui.prenom,u.id_role,poste.libelle_poste,
        u.p_civ_matcle as matricule_agent, ui.grade, ui.indice_majore, ui.adresse, ui_fop.libelle_fop as ui_fonction_compl, ui_cg.libelle_odm_cadre_general as ui_cadre_general,
        plm.id_projet_lm,plm.id_utilisateur,plm.date_fin,plm.date_debut,affectation.libelle_long,plm.id_workflow,
        plm.id_lieu, plm.ordre_de_mission_general,
        plm.saison_sportive, wf.libelle_action,ui.id_federation,ui.id_affectation,rf.r_ser_libl,
        rf.r_adm_diside,rf.r_ser_libc,rfop.id_fop,rfop.libelle_fop,lm.date_changement_administratif,plm.date from utilisateur_information ui
        INNER JOIN projet_lettre_mission plm ON ui.id_utilisateur = plm.id_utilisateur
        INNER JOIN ref_affectation affectation ON ui.id_affectation = affectation.id_affectation
        INNER JOIN ref_federation federation ON ui.id_federation = federation.id_federation
        INNER JOIN ref_poste poste ON ui.id_poste = poste.id_poste
        INNER JOIN r_federation rf ON federation.r_adm_diside = rf.r_adm_diside
        INNER JOIN workflow wf ON plm.id_workflow = wf.id_workflow
        INNER JOIN ref_fop rfop ON plm.id_fop = rfop.id_fop
        LEFT JOIN ref_fop ui_fop ON ui.id_fop = ui_fop.id_fop
        LEFT JOIN ref_odm_cadre_general ui_cg ON ui.id_odm_cadre_general = ui_cg.id_odm_cadre_general
        INNER JOIN utilisateur u ON ui.id_utilisateur = u.id_utilisateur
        INNER JOIN lettre_mission lm ON plm.id_lm = lm.id_lm
        where  plm.id_projet_lm = (SELECT MAX(plm2.id_projet_lm) FROM projet_lettre_mission plm2 where plm2.id_utilisateur = ui.id_utilisateur )
        AND ui.utilisateur_actif = true AND federation.federation_active = true AND federation.federation_active = true AND u.droit_lm_utilisateur = true AND ui.id_affectation = 31 and plm.id_workflow IN (2,4,3,5,6)
        order by ui.nom;

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;