Symfony Profiler

SELECT
  DISTINCT u0_.id_utilisateur AS id_utilisateur_0,
  u1_.civilite AS civilite_1,
  u1_.nom AS nom_2,
  u1_.prenom AS prenom_3,
  r2_.r_ser_libl AS r_ser_libl_4,
  r2_.r_ser_libc AS r_ser_libc_5,
  r2_.r_adm_diside AS r_adm_diside_6,
  u0_.p_civ_matcle AS p_civ_matcle_7,
  r3_.libelle_poste AS libelle_poste_8,
  r4_.libelle_affectation AS libelle_affectation_9,
  r4_.libelle_long AS libelle_long_10,
  r4_.r_ser_ident AS r_ser_ident_11,
  u0_.courriel AS courriel_12,
  u0_.droit_lm_utilisateur AS droit_lm_utilisateur_13,
  r5_.id_federation AS id_federation_14,
  r4_.id_affectation AS id_affectation_15,
  r6_.id_role AS id_role_16
FROM
  utilisateur_information u1_
  INNER JOIN utilisateur u0_ ON u1_.id_utilisateur = u0_.id_utilisateur
  INNER JOIN ref_role r6_ ON u0_.id_role = r6_.id_role
  INNER JOIN ref_poste r3_ ON u1_.id_poste = r3_.id_poste
  INNER JOIN ref_federation r5_ ON u1_.id_federation = r5_.id_federation
  INNER JOIN ref_affectation r4_ ON u1_.id_affectation = r4_.id_affectation
  LEFT JOIN r_federation r2_ ON (
    r5_.r_adm_diside = r2_.r_adm_diside
  )
WHERE
  u1_.id_poste IS NOT NULL
  AND u0_.date_creation <= ?
  AND u1_.utilisateur_actif = true
  AND r5_.federation_active = true

SELECT DISTINCT u0_.id_utilisateur AS id_utilisateur_0, u1_.civilite AS civilite_1, u1_.nom AS nom_2, u1_.prenom AS prenom_3, r2_.r_ser_libl AS r_ser_libl_4, r2_.r_ser_libc AS r_ser_libc_5, r2_.r_adm_diside AS r_adm_diside_6, u0_.p_civ_matcle AS p_civ_matcle_7, r3_.libelle_poste AS libelle_poste_8, r4_.libelle_affectation AS libelle_affectation_9, r4_.libelle_long AS libelle_long_10, r4_.r_ser_ident AS r_ser_ident_11, u0_.courriel AS courriel_12, u0_.droit_lm_utilisateur AS droit_lm_utilisateur_13, r5_.id_federation AS id_federation_14, r4_.id_affectation AS id_affectation_15, r6_.id_role AS id_role_16 FROM utilisateur_information u1_ INNER JOIN utilisateur u0_ ON u1_.id_utilisateur = u0_.id_utilisateur INNER JOIN ref_role r6_ ON u0_.id_role = r6_.id_role INNER JOIN ref_poste r3_ ON u1_.id_poste = r3_.id_poste INNER JOIN ref_federation r5_ ON u1_.id_federation = r5_.id_federation INNER JOIN ref_affectation r4_ ON u1_.id_affectation = r4_.id_affectation LEFT JOIN r_federation r2_ ON (r5_.r_adm_diside = r2_.r_adm_diside) WHERE u1_.id_poste IS NOT NULL AND u0_.date_creation <= '2025-06-07 00:00:00' AND u1_.utilisateur_actif = true AND r5_.federation_active = true;

select
  plm.id_projet_lm,
  ui.id_utilisateur,
  ref.r_adm_diside as libelle_court_federation,
  plm.date_debut,
  plm.date_fin,
  plm.id_workflow
from
  projet_lettre_mission plm
  INNER JOIN utilisateur_information ui ON plm.id_utilisateur = ui.id_utilisateur
  INNER JOIN ref_federation ref ON ui.id_federation = ref.id_federation
where
  plm.id_workflow = 7
  and '2025-06-07' BETWEEN date_debut
  and date_fin
  and ref.federation_active = true

select plm.id_projet_lm,ui.id_utilisateur,ref.r_adm_diside as libelle_court_federation,plm.date_debut,plm.date_fin,plm.id_workflow from projet_lettre_mission plm
        INNER JOIN utilisateur_information ui ON plm.id_utilisateur = ui.id_utilisateur
        INNER JOIN ref_federation ref ON ui.id_federation = ref.id_federation
        where plm.id_workflow = 7
        and '2025-06-07' BETWEEN date_debut and date_fin
        and ref.federation_active = true;

SELECT
  id_federation,
  ref.r_adm_diside,
  rf.r_ser_libl
FROM
  ref_federation ref
  INNER JOIN r_federation rf ON rf.r_adm_diside = ref.r_adm_diside
WHERE
  federation_active = TRUE

SELECT id_federation,ref.r_adm_diside,rf.r_ser_libl 
        FROM ref_federation ref 
        INNER JOIN r_federation rf ON  rf.r_adm_diside = ref.r_adm_diside WHERE federation_active = TRUE
        ;