Symfony Profiler

SELECT 
  t0.username AS username_1, 
  t0.username_canonical AS username_canonical_2, 
  t0.email AS email_3, 
  t0.email_canonical AS email_canonical_4, 
  t0.enabled AS enabled_5, 
  t0.salt AS salt_6, 
  t0.password AS password_7, 
  t0.last_login AS last_login_8, 
  t0.confirmation_token AS confirmation_token_9, 
  t0.password_requested_at AS password_requested_at_10, 
  t0.roles AS roles_11, 
  t0.iid_user AS iid_user_12, 
  t0.ctype_res AS ctype_res_13, 
  t0.iid_res AS iid_res_14, 
  t0.lpeutchangerprofil AS lpeutchangerprofil_15 
FROM 
  Paa_Securite.Users t0 
WHERE 
  t0.iid_user = ? 
LIMIT 
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.iid_user AS iid_user_12, t0.ctype_res AS ctype_res_13, t0.iid_res AS iid_res_14, t0.lpeutchangerprofil AS lpeutchangerprofil_15 FROM Paa_Securite.Users t0 WHERE t0.iid_user = 1 LIMIT 1;

Select 
  R.cType_Res, 
  R.iId_Res, 
  R.iRang, 
  R.cNomCourt, 
  R.cNom, 
  R.iGroupeParent, 
  false As bIntervenantPermanent 
From 
  Paa.RtvCurRessourcesFiltreeParGereFiltreAvecData(
    '                Select $cType_Res$E$cType_Res$::Text As cType_Res
                        , ''2024-11-18''::Date As iSem
                        , ''2024-11-24''::Date As iSemFin
                        , False::Boolean As lAffiche_Sortis
                        , True::Boolean As lAffiche_Présents
                        , False::Boolean As lAffiche_PasEntrés
                        , True::Boolean As lAffiche_Remplacants
                        , True::Boolean As lAffiche_Extérieurs
                        , True::Boolean As lGroupePourPériodeDemandée
                        , null::Integer As iSpécialité
                        , null::Integer As iService
                        , -1::Integer As iEtablissement
                        , -1::Integer As iActi_SsGpe
                        , $iGroupe$$iGroupe$::Text As iGroupe
                        , $iParentDuSousGroupe$$iParentDuSousGroupe$::Text As iParentDuSousGroupe
                        , $cIntervenant_Libre1$$cIntervenant_Libre1$::Text As cIntervenant_Libre1
                        , $cIntervenant_Libre2$$cIntervenant_Libre2$::Text As cIntervenant_Libre2
                        , null::Integer As iActiBaseCompetence
                        , null::Integer As iActiviteCompetence
                        , False::Boolean As EstGroupes
                        , False::Boolean As EstUsagers
                        , False::Boolean As EstIntervenants
                        , False::Boolean As EstEquipements
                        , False::Boolean As EstActivitésDeBase
                        , False::Boolean As EstSousGroupeActivitésDeBase
                        , False::Boolean As EstGroupeActivitésDeBase
                        , $cWhereAdditionnel$$cWhereAdditionnel$::Text As cWhereAdditionnel
                        , $cWhereAdditionnel_Interne$$cWhereAdditionnel_Interne$::Text As cWhereAdditionnel_Interne
                        , $cLstResForcées$$cLstResForcées$::Text As cLstResForcées
                        , False::Boolean As bExclGroupesA0Heures        -- LG 20241105
                    ;'
  ) As R 
WHERE 
  (
    R.cType_Res != 'G' 
    or iGroupeParent Is Null
  ) 
Order by 
  Case When cType_Res = 'I' 
  And false Then '0' When cType_Res = 'I' Then '1' When cType_Res = 'U' Then '2' When cType_Res = 'G' Then '3' When cType_Res = 'S' Then '4' Else cType_Res End, 
  R.iRang, 
  R.cNomCourt, 
  R.cNom, 
  R.iGroupeParent;

Select R.cType_Res, R.iId_Res, R.iRang, R.cNomCourt, R.cNom, R.iGroupeParent, false As bIntervenantPermanent
 From Paa.RtvCurRessourcesFiltreeParGereFiltreAvecData('                Select $cType_Res$E$cType_Res$::Text As cType_Res
                        , ''2024-11-18''::Date As iSem
                        , ''2024-11-24''::Date As iSemFin
                        , False::Boolean As lAffiche_Sortis
                        , True::Boolean As lAffiche_Présents
                        , False::Boolean As lAffiche_PasEntrés
                        , True::Boolean As lAffiche_Remplacants
                        , True::Boolean As lAffiche_Extérieurs
                        , True::Boolean As lGroupePourPériodeDemandée
                        , null::Integer As iSpécialité
                        , null::Integer As iService
                        , -1::Integer As iEtablissement
                        , -1::Integer As iActi_SsGpe
                        , $iGroupe$$iGroupe$::Text As iGroupe
                        , $iParentDuSousGroupe$$iParentDuSousGroupe$::Text As iParentDuSousGroupe
                        , $cIntervenant_Libre1$$cIntervenant_Libre1$::Text As cIntervenant_Libre1
                        , $cIntervenant_Libre2$$cIntervenant_Libre2$::Text As cIntervenant_Libre2
                        , null::Integer As iActiBaseCompetence
                        , null::Integer As iActiviteCompetence
                        , False::Boolean As EstGroupes
                        , False::Boolean As EstUsagers
                        , False::Boolean As EstIntervenants
                        , False::Boolean As EstEquipements
                        , False::Boolean As EstActivitésDeBase
                        , False::Boolean As EstSousGroupeActivitésDeBase
                        , False::Boolean As EstGroupeActivitésDeBase
                        , $cWhereAdditionnel$$cWhereAdditionnel$::Text As cWhereAdditionnel
                        , $cWhereAdditionnel_Interne$$cWhereAdditionnel_Interne$::Text As cWhereAdditionnel_Interne
                        , $cLstResForcées$$cLstResForcées$::Text As cLstResForcées
                        , False::Boolean As bExclGroupesA0Heures        -- LG 20241105
                    ;') As R 
   WHERE (R.cType_Res != 'G' or iGroupeParent Is Null)
 Order by Case When cType_Res = 'I' And false Then '0' When cType_Res = 'I' Then '1' When cType_Res = 'U' Then '2' When cType_Res = 'G' Then '3' When cType_Res = 'S' Then '4' Else cType_Res End, R.iRang, R.cNomCourt, R.cNom, R.iGroupeParent ;;