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
  COUNT(o0_.id_odm) AS sclr_0
FROM
  odm o0_
  INNER JOIN evenement e1_ ON o0_.id_odm = e1_.id_odm
  LEFT JOIN utilisateur_information u2_ ON (
    e1_.id_utilisateur = u2_.id_utilisateur
  )
  LEFT JOIN ref_federation r3_ ON u2_.id_federation = r3_.id_federation
  INNER JOIN utilisateur u4_ ON (
    u2_.id_utilisateur = u4_.id_utilisateur
  )
WHERE
  o0_.id_workflow = ?
  AND u2_.utilisateur_actif = true
  AND r3_.federation_active = true
  AND o0_.avis_dtn IS NULL
  AND o0_.date_de_depart >= ?
  AND u4_.id_role = ?
  AND u2_.id_federation = ?

SELECT COUNT(o0_.id_odm) AS sclr_0 FROM odm o0_ INNER JOIN evenement e1_ ON o0_.id_odm = e1_.id_odm LEFT JOIN utilisateur_information u2_ ON (e1_.id_utilisateur = u2_.id_utilisateur) LEFT JOIN ref_federation r3_ ON u2_.id_federation = r3_.id_federation INNER JOIN utilisateur u4_ ON (u2_.id_utilisateur = u4_.id_utilisateur) WHERE o0_.id_workflow = 10 AND u2_.utilisateur_actif = true AND r3_.federation_active = true AND o0_.avis_dtn IS NULL AND o0_.date_de_depart >= '2024-09-19 16:11:46' AND u4_.id_role = 2 AND u2_.id_federation = 36;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  liste_diffusion_sup l0_
  INNER JOIN article a1_ ON l0_.id_article = a1_.id
WHERE
  a1_.DateFinPublication >= ?
  AND a1_.datePublication <= ?
  AND l0_.id_utilisateur = ?
  AND a1_.Statut = true
  AND l0_.lu = false

SELECT COUNT(l0_.id) AS sclr_0 FROM liste_diffusion_sup l0_ INNER JOIN article a1_ ON l0_.id_article = a1_.id WHERE a1_.DateFinPublication >= '2024-09-19' AND a1_.datePublication <= '2024-09-19' AND l0_.id_utilisateur = 4855 AND a1_.Statut = true AND l0_.lu = false;

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

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_federation = 36;

SELECT
  COUNT(p0_.id_projet_lm) AS sclr_0
FROM
  projet_lettre_mission p0_
  INNER JOIN utilisateur_information u1_ ON (
    u1_.id_utilisateur = p0_.id_utilisateur
  )
WHERE
  p0_.id_utilisateur IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )
  AND p0_.id_workflow IN (4)
  AND u1_.id_poste <> 3
  AND p0_.version = (
    SELECT
      MAX(p2_.version) AS sclr_1
    FROM
      projet_lettre_mission p2_
    WHERE
      p2_.id_lm = p0_.id_lm
      AND p2_.id_utilisateur IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?
      )
  )
  AND u1_.utilisateur_actif = true

SELECT COUNT(p0_.id_projet_lm) AS sclr_0 FROM projet_lettre_mission p0_ INNER JOIN utilisateur_information u1_ ON (u1_.id_utilisateur = p0_.id_utilisateur) WHERE p0_.id_utilisateur IN (5036, 3218, 3057, 2283, 5051, 4362, 5013, 2703, 3853, 4765, 2976, 4769, 2978, 4771, 3766, 4774, 4655, 4775, 4292, 1977, 3145, 2866, 3811, 2472, 3546, 3022, 2613, 3855, 3236, 2770, 2553, 4928, 2117, 3806, 3757, 2471, 2441, 2449, 4061, 3495, 4855, 4744, 4223, 2630, 2570, 2740, 3028, 4217, 4376, 3127, 2516, 3239, 4103, 2229, 3929, 2621, 1987, 3444, 2651, 2918, 4469, 3862, 2927, 2519, 2226, 2439, 2438, 2351, 2824, 3099, 3375, 3562, 3964, 4366, 2061, 4965, 4964, 3768, 2641) AND p0_.id_workflow IN (4) AND u1_.id_poste <> 3 AND p0_.version = (SELECT MAX(p2_.version) AS sclr_1 FROM projet_lettre_mission p2_ WHERE p2_.id_lm = p0_.id_lm AND p2_.id_utilisateur IN (5036, 3218, 3057, 2283, 5051, 4362, 5013, 2703, 3853, 4765, 2976, 4769, 2978, 4771, 3766, 4774, 4655, 4775, 4292, 1977, 3145, 2866, 3811, 2472, 3546, 3022, 2613, 3855, 3236, 2770, 2553, 4928, 2117, 3806, 3757, 2471, 2441, 2449, 4061, 3495, 4855, 4744, 4223, 2630, 2570, 2740, 3028, 4217, 4376, 3127, 2516, 3239, 4103, 2229, 3929, 2621, 1987, 3444, 2651, 2918, 4469, 3862, 2927, 2519, 2226, 2439, 2438, 2351, 2824, 3099, 3375, 3562, 3964, 4366, 2061, 4965, 4964, 3768, 2641)) AND u1_.utilisateur_actif = true;

select
  *
from
  documentservice ds
where
  ds.type = 'DS'
  or ds.type = 'DR'
  or (
    ds.type = 'FD'
    and ds.id_federation = 36
  )

select * from documentservice ds where ds.type ='DS' or ds.type ='DR' or (ds.type='FD' and ds.id_federation=36);

SELECT
  t0.id_federation AS id_federation_1,
  t0.saison_sportive_federation AS saison_sportive_federation_2,
  t0.sport_federation AS sport_federation_3,
  t0.r_adm_diside AS r_adm_diside_4,
  t0.federation_active AS federation_active_5,
  t0.droit_ref_federation AS droit_ref_federation_6,
  t0.text_DTG_dtn AS text_dtg_dtn_7
FROM
  ref_federation t0
WHERE
  t0.id_federation = ?

SELECT t0.id_federation AS id_federation_1, t0.saison_sportive_federation AS saison_sportive_federation_2, t0.sport_federation AS sport_federation_3, t0.r_adm_diside AS r_adm_diside_4, t0.federation_active AS federation_active_5, t0.droit_ref_federation AS droit_ref_federation_6, t0.text_DTG_dtn AS text_dtg_dtn_7 FROM ref_federation t0 WHERE t0.id_federation = 36;

SELECT
  u0_.civilite AS civilite_0,
  u0_.nom AS nom_1,
  u0_.prenom AS prenom_2,
  r1_.id_affectation AS id_affectation_3,
  r2_.id_federation AS id_federation_4,
  r1_.libelle_affectation AS libelle_affectation_5,
  r3_.libelle_poste AS libelle_poste_6,
  r4_.r_ser_libl AS r_ser_libl_7,
  c5_.id AS id_8,
  c5_.date_debut AS date_debut_9,
  c5_.date_fin AS date_fin_10,
  c5_.nb_jour AS nb_jour_11,
  w6_.libelle_action AS libelle_action_12,
  c5_.avis_dtn AS avis_dtn_13,
  c7_.libelle AS libelle_14,
  c8_.libelle AS libelle_15,
  c9_.libelle AS libelle_16,
  w6_.id_workflow AS id_workflow_17,
  c5_.piece_motif AS piece_motif_18,
  c5_.motif_conge AS motif_conge_19,
  c5_.commentaire_sh AS commentaire_sh_20,
  c5_.commentaire_dtn AS commentaire_dtn_21
FROM
  conge c5_
  INNER JOIN conge_type c7_ ON c5_.id_conge_type = c7_.id
  INNER JOIN conge_date_type c8_ ON c5_.id_date_debut_type = c8_.id
  INNER JOIN conge_date_type c9_ ON c5_.id_date_fin_type = c9_.id
  INNER JOIN workflow w6_ ON c5_.id_workflow = w6_.id_workflow
  INNER JOIN utilisateur u10_ ON c5_.id_utilisateur = u10_.id_utilisateur
  INNER JOIN utilisateur_information u0_ ON (
    c5_.id_utilisateur = u0_.id_utilisateur
  )
  INNER JOIN ref_affectation r1_ ON u0_.id_affectation = r1_.id_affectation
  INNER JOIN ref_federation r2_ ON u0_.id_federation = r2_.id_federation
  INNER JOIN r_federation r4_ ON (
    r2_.r_adm_diside = r4_.r_adm_diside
  )
  INNER JOIN ref_poste r3_ ON u0_.id_poste = r3_.id_poste
WHERE
  (
    (w6_.id_workflow = ?)
    OR (w6_.id_workflow = ?)
  )
  AND r2_.r_adm_diside = ?
  AND c5_.avis_dtn IS NULL

SELECT u0_.civilite AS civilite_0, u0_.nom AS nom_1, u0_.prenom AS prenom_2, r1_.id_affectation AS id_affectation_3, r2_.id_federation AS id_federation_4, r1_.libelle_affectation AS libelle_affectation_5, r3_.libelle_poste AS libelle_poste_6, r4_.r_ser_libl AS r_ser_libl_7, c5_.id AS id_8, c5_.date_debut AS date_debut_9, c5_.date_fin AS date_fin_10, c5_.nb_jour AS nb_jour_11, w6_.libelle_action AS libelle_action_12, c5_.avis_dtn AS avis_dtn_13, c7_.libelle AS libelle_14, c8_.libelle AS libelle_15, c9_.libelle AS libelle_16, w6_.id_workflow AS id_workflow_17, c5_.piece_motif AS piece_motif_18, c5_.motif_conge AS motif_conge_19, c5_.commentaire_sh AS commentaire_sh_20, c5_.commentaire_dtn AS commentaire_dtn_21 FROM conge c5_ INNER JOIN conge_type c7_ ON c5_.id_conge_type = c7_.id INNER JOIN conge_date_type c8_ ON c5_.id_date_debut_type = c8_.id INNER JOIN conge_date_type c9_ ON c5_.id_date_fin_type = c9_.id INNER JOIN workflow w6_ ON c5_.id_workflow = w6_.id_workflow INNER JOIN utilisateur u10_ ON c5_.id_utilisateur = u10_.id_utilisateur INNER JOIN utilisateur_information u0_ ON (c5_.id_utilisateur = u0_.id_utilisateur) INNER JOIN ref_affectation r1_ ON u0_.id_affectation = r1_.id_affectation INNER JOIN ref_federation r2_ ON u0_.id_federation = r2_.id_federation INNER JOIN r_federation r4_ ON (r2_.r_adm_diside = r4_.r_adm_diside) INNER JOIN ref_poste r3_ ON u0_.id_poste = r3_.id_poste WHERE ((w6_.id_workflow = 16) OR (w6_.id_workflow = 17)) AND r2_.r_adm_diside = 'JUD' AND c5_.avis_dtn IS NULL;

SELECT
  fs.id_formation_session,
  ui.id_utilisateur,
  ui.civilite,
  ui.nom,
  ui.prenom,
  ui.adresse,
  ra.id_affectation,
  ui.id_affectation as affectation_id,
  ra.libelle_affectation,
  rf.id_federation,
  r_f.r_ser_libl,
  rp.libelle_poste,
  fs.titre,
  ft.libelle_formation,
  fs.libelle_organisme,
  ft.id_formation_type,
  w.id_workflow,
  w.libelle_action,
  fs.date_debut,
  fs.date_fin,
  fs.nb_jours,
  commentaire_sh,
  commentaire_dtn,
  date_avis_dtn,
  date_sgn_sh,
  fs.avis_dtn,
  fs.avis_sh,
  fs.nom_responsable,
  fs.prenom_responsable,
  fs.mail_responsable,
  fs.telephone_responsable,
  fs.lien,
  fs.presentation,
  fs.titre_session,
  fs.lieu_formation,
  fs.titre,
  u.id_role,
  u.courriel,
  u.telephone_portable as telephonePortable
FROM
  formation_session fs
  INNER JOIN utilisateur_information ui ON fs.id_utilisateur = ui.id_utilisateur
  INNER JOIN ref_affectation ra on ui.id_affectation = ra.id_affectation
  INNER JOIN ref_federation rf ON ui.id_federation = rf.id_federation
  INNER JOIN r_federation r_f ON rf.r_adm_diside = r_f.r_adm_diside
  INNER JOIN ref_poste rp ON rp.id_poste = ui.id_poste
  INNER JOIN formation_type ft ON fs.id_formation_type = ft.id_formation_type
  INNER JOIN workflow w ON fs.id_workflow = w.id_workflow
  INNER JOIN utilisateur u ON ui.id_utilisateur = u.id_utilisateur
WHERE
  ui.id_federation = 36
  and fs.id_workflow IN (23)
  AND fs.avis_dtn IS NULL
ORDER BY
  fs.id_formation_session DESC

SELECT fs.id_formation_session, ui.id_utilisateur, ui.civilite, ui.nom,ui.prenom, ui.adresse,ra.id_affectation, ui.id_affectation as affectation_id,
                    ra.libelle_affectation, rf.id_federation, r_f.r_ser_libl,
                    rp.libelle_poste, fs.titre, ft.libelle_formation, fs.libelle_organisme, ft.id_formation_type,
                    w.id_workflow, w.libelle_action, fs.date_debut, fs.date_fin, fs.nb_jours,commentaire_sh,commentaire_dtn,date_avis_dtn,date_sgn_sh,
                    fs.avis_dtn, fs.avis_sh, fs.nom_responsable, fs.prenom_responsable, 
                    fs.mail_responsable, fs.telephone_responsable, fs.lien, fs.presentation, fs.titre_session, fs.lieu_formation, fs.titre, u.id_role, u.courriel,u.telephone_portable as telephonePortable
                FROM formation_session fs
                INNER JOIN utilisateur_information ui ON fs.id_utilisateur = ui.id_utilisateur
                INNER JOIN ref_affectation ra on ui.id_affectation = ra.id_affectation
                INNER JOIN ref_federation rf ON ui.id_federation = rf.id_federation
                INNER JOIN r_federation r_f ON rf.r_adm_diside = r_f.r_adm_diside
                INNER JOIN ref_poste rp ON rp.id_poste = ui.id_poste
                INNER JOIN formation_type ft ON fs.id_formation_type = ft.id_formation_type
                INNER JOIN workflow w ON fs.id_workflow = w.id_workflow
                INNER JOIN utilisateur u ON ui.id_utilisateur = u.id_utilisateur WHERE  ui.id_federation = 36 and fs.id_workflow IN (23) AND fs.avis_dtn IS NULL ORDER BY fs.id_formation_session DESC;