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

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

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

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 >= '2024-09-19 16:16:12' AND p0_.id_utilisateur IS NOT NULL AND u1_.id_federation = 36;

Select
  ui.civilite,
  ui.nom,
  ui.prenom,
  u.id_role,
  poste.libelle_poste,
  plm.id_projet_lm,
  plm.id_utilisateur,
  plm.date_fin,
  plm.date_debut,
  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,
  affectation.libelle_long,
  plm.id_workflow,
  wf.libelle_action,
  ui.id_federation,
  ui.id_affectation,
  rf.r_ser_libl,
  plm.id_lieu,
  plm.ordre_de_mission_general,
  plm.saison_sportive,
  rf.r_adm_diside,
  rf.r_ser_libc,
  rfop.id_fop,
  rfop.libelle_fop,
  plm.date,
  lm.date_changement_administratif
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
      INNER JOIN projet_lettre_mission plm3 ON plm2.id_lm = plm3.id_lm
    where
      plm3.id_workflow != 8
      AND plm2.id_utilisateur = plm.id_utilisateur
  )
  AND ui.utilisateur_actif = true
  AND federation.federation_active = true
  AND u.droit_lm_utilisateur = true
  AND ui.id_federation = 36
  and plm.id_workflow IN (2, 3, 4, 5, 6, 7)
  and ui.id_poste != 3
  and u.id_role != 8
UNION
Select
  ui.civilite,
  ui.nom,
  ui.prenom,
  u.id_role,
  poste.libelle_poste,
  plm.id_projet_lm,
  plm.id_utilisateur,
  plm.date_fin,
  plm.date_debut,
  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,
  affectation.libelle_long,
  plm.id_workflow,
  wf.libelle_action,
  ui.id_federation,
  ui.id_affectation,
  rf.r_ser_libl,
  plm.id_lieu,
  plm.ordre_de_mission_general,
  plm.saison_sportive,
  rf.r_adm_diside,
  rf.r_ser_libc,
  rfop.id_fop,
  rfop.libelle_fop,
  plm.date,
  lm.date_changement_administratif
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 plm.id_utilisateur = 4855
  and u.droit_lm_utilisateur = true
  and plm.id_workflow NOT IN (7, 8)
  and ui.utilisateur_actif = true
  AND federation.federation_active = true
order by
  nom

Select ui.civilite,ui.nom,ui.prenom,u.id_role,poste.libelle_poste,plm.id_projet_lm,plm.id_utilisateur,plm.date_fin,plm.date_debut,
            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,
            affectation.libelle_long,plm.id_workflow,wf.libelle_action,ui.id_federation,ui.id_affectation,rf.r_ser_libl,
            plm.id_lieu, plm.ordre_de_mission_general,
            plm.saison_sportive, rf.r_adm_diside,rf.r_ser_libc, rfop.id_fop, rfop.libelle_fop, plm.date,lm.date_changement_administratif 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 
            INNER JOIN projet_lettre_mission plm3 ON plm2.id_lm = plm3.id_lm  where plm3.id_workflow != 8 AND plm2.id_utilisateur = plm.id_utilisateur )
            AND ui.utilisateur_actif = true AND federation.federation_active = true AND u.droit_lm_utilisateur = true AND ui.id_federation = 36 and plm.id_workflow IN (2,3,4,5,6,7) and ui.id_poste != 3 and  u.id_role != 8
        UNION
        Select ui.civilite,ui.nom,ui.prenom,u.id_role,poste.libelle_poste,plm.id_projet_lm,plm.id_utilisateur,plm.date_fin,plm.date_debut,
            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,
            affectation.libelle_long,plm.id_workflow,wf.libelle_action,ui.id_federation,ui.id_affectation,rf.r_ser_libl,
            plm.id_lieu, plm.ordre_de_mission_general,
            plm.saison_sportive, rf.r_adm_diside,rf.r_ser_libc, rfop.id_fop, rfop.libelle_fop, plm.date,lm.date_changement_administratif 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 plm.id_utilisateur = 4855 and u.droit_lm_utilisateur = true
            and plm.id_workflow NOT IN (7,8)
            and ui.utilisateur_actif = true AND federation.federation_active = true
        order by 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;

Select
  ui.id_utilisateur,
  ui.civilite,
  ui.nom,
  u.id_role,
  ui.prenom,
  poste.libelle_poste,
  affectation.libelle_long,
  ui.id_federation,
  ui.id_affectation,
  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,
  rf.r_ser_libl,
  rf.r_adm_diside,
  rf.r_ser_libc
from
  utilisateur_information ui
  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 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
WHERE
  ui.utilisateur_actif = true
  AND federation.federation_active = true
  AND ui.id_utilisateur NOT IN (
    SELECT
      plm3.id_utilisateur
    FROM
      projet_lettre_mission plm3
  )
  AND ui.id_federation = 36
  and poste.id_poste != 3
  and u.droit_lm_utilisateur = true
UNION
SELECT
  Distinct(ui2.id_utilisateur),
  ui2.civilite,
  ui2.nom,
  u.id_role,
  ui2.prenom,
  poste.libelle_poste,
  affectation.libelle_long,
  ui2.id_federation,
  ui2.id_affectation,
  u.p_civ_matcle as matricule_agent,
  ui2.grade,
  ui2.indice_majore,
  ui2.adresse,
  ui_fop.libelle_fop as ui_fonction_compl,
  ui_cg.libelle_odm_cadre_general as ui_cadre_general,
  rf.r_ser_libl,
  rf.r_adm_diside,
  rf.r_ser_libc
from
  utilisateur_information ui2
  LEFT JOIN ref_fop ui_fop ON ui2.id_fop = ui_fop.id_fop
  LEFT JOIN ref_odm_cadre_general ui_cg ON ui2.id_odm_cadre_general = ui_cg.id_odm_cadre_general
  INNER JOIN projet_lettre_mission plm ON ui2.id_utilisateur = plm.id_utilisateur
  INNER JOIN utilisateur u ON ui2.id_utilisateur = u.id_utilisateur
  INNER JOIN ref_affectation affectation ON ui2.id_affectation = affectation.id_affectation
  INNER JOIN ref_federation federation ON ui2.id_federation = federation.id_federation
  INNER JOIN ref_poste poste ON ui2.id_poste = poste.id_poste
  INNER JOIN r_federation rf ON federation.r_adm_diside = rf.r_adm_diside
  INNER JOIN lettre_mission lm ON plm.id_lm = lm.id_lm
  AND ui2.utilisateur_actif = true
  AND federation.federation_active = true
  and u.droit_lm_utilisateur = true
  and poste.id_poste != 3
  and ui2.id_federation = 36
  and exists (
    select
      *
    from
      projet_lettre_mission plm2
    where
      plm2.id_utilisateur = ui2.id_utilisateur
      and plm2.id_workflow = 8
      and not exists (
        select
          *
        from
          projet_lettre_mission plm3
        where
          plm3.id_utilisateur = ui2.id_utilisateur
          and plm3.id_workflow != 8
          and plm2.id_projet_lm < plm3.id_projet_lm
      )
  )

Select ui.id_utilisateur,ui.civilite,ui.nom,u.id_role,ui.prenom,poste.libelle_poste,affectation.libelle_long, ui.id_federation,ui.id_affectation,
        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,
        rf.r_ser_libl,rf.r_adm_diside,rf.r_ser_libc
        from utilisateur_information ui
        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 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
        WHERE ui.utilisateur_actif = true AND federation.federation_active = true AND ui.id_utilisateur NOT IN (SELECT plm3.id_utilisateur FROM projet_lettre_mission plm3)
        AND ui.id_federation = 36 
        and poste.id_poste != 3
        and u.droit_lm_utilisateur = true
        UNION
        SELECT Distinct(ui2.id_utilisateur),ui2.civilite,ui2.nom,u.id_role,ui2.prenom,poste.libelle_poste,affectation.libelle_long, ui2.id_federation,ui2.id_affectation,
        u.p_civ_matcle as matricule_agent, ui2.grade, ui2.indice_majore, ui2.adresse, ui_fop.libelle_fop as ui_fonction_compl, ui_cg.libelle_odm_cadre_general as ui_cadre_general,
        rf.r_ser_libl,rf.r_adm_diside,rf.r_ser_libc from utilisateur_information ui2
        LEFT JOIN ref_fop ui_fop ON ui2.id_fop = ui_fop.id_fop
        LEFT JOIN ref_odm_cadre_general ui_cg ON ui2.id_odm_cadre_general = ui_cg.id_odm_cadre_general
        INNER JOIN projet_lettre_mission plm ON ui2.id_utilisateur = plm.id_utilisateur
        INNER JOIN utilisateur u ON ui2.id_utilisateur = u.id_utilisateur
        INNER JOIN ref_affectation affectation ON ui2.id_affectation = affectation.id_affectation
        INNER JOIN ref_federation federation ON ui2.id_federation = federation.id_federation
        INNER JOIN ref_poste poste ON ui2.id_poste = poste.id_poste
        INNER JOIN r_federation rf ON federation.r_adm_diside = rf.r_adm_diside
        INNER JOIN lettre_mission lm ON plm.id_lm = lm.id_lm AND ui2.utilisateur_actif = true AND federation.federation_active = true and u.droit_lm_utilisateur = true
        and poste.id_poste != 3
        and ui2.id_federation = 36        
        and exists (select * from projet_lettre_mission plm2 where plm2.id_utilisateur = ui2.id_utilisateur and plm2.id_workflow = 8 
        	and not exists (select * from projet_lettre_mission plm3 where plm3.id_utilisateur = ui2.id_utilisateur and plm3.id_workflow != 8 and plm2.id_projet_lm < plm3.id_projet_lm))  

        ;