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

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

SELECT
  l0_.id_lm AS id_lm_0,
  l0_.saison_sportive AS saison_sportive_1,
  l0_.ordre_de_mission_general AS ordre_de_mission_general_2,
  r1_.libelle_role AS libelle_role_3,
  p2_.parent_id_projet_lm AS sclr_4,
  p2_.id_projet_lm AS id_projet_lm_5,
  p2_.identifiant_plm AS identifiant_plm_6,
  p2_.date_debut AS date_debut_7,
  p2_.date_fin AS date_fin_8,
  r3_.libelle_fop AS libelle_fop_9,
  w4_.etape AS etape_10,
  r5_.r_adm_diside AS r_adm_diside_11,
  r6_.libelle_long AS libelle_long_12
FROM
  lettre_mission l0_
  LEFT JOIN utilisateur u7_ ON l0_.id_utilisateur = u7_.id_utilisateur
  LEFT JOIN ref_role r1_ ON (r1_.id_role = u7_.id_role)
  LEFT JOIN projet_lettre_mission p2_ ON (p2_.id_lm = l0_.id_lm)
  LEFT JOIN ref_fop r3_ ON l0_.id_fop = r3_.id_fop
  LEFT JOIN workflow w4_ ON (
    p2_.id_workflow = w4_.id_workflow
  )
  LEFT JOIN utilisateur_information u8_ ON (
    u7_.id_utilisateur = u8_.id_utilisateur
  )
  INNER JOIN ref_federation r5_ ON u8_.id_federation = r5_.id_federation
  LEFT JOIN ref_affectation r6_ ON u8_.id_affectation = r6_.id_affectation
WHERE
  1 = 1
  AND l0_.id_utilisateur = ?
  AND p2_.id_workflow = 7
  AND p2_.date_debut <= ?
  AND p2_.date_fin >= ?
ORDER BY
  l0_.id_lm DESC
LIMIT
  1

SELECT l0_.id_lm AS id_lm_0, l0_.saison_sportive AS saison_sportive_1, l0_.ordre_de_mission_general AS ordre_de_mission_general_2, r1_.libelle_role AS libelle_role_3, p2_.parent_id_projet_lm AS sclr_4, p2_.id_projet_lm AS id_projet_lm_5, p2_.identifiant_plm AS identifiant_plm_6, p2_.date_debut AS date_debut_7, p2_.date_fin AS date_fin_8, r3_.libelle_fop AS libelle_fop_9, w4_.etape AS etape_10, r5_.r_adm_diside AS r_adm_diside_11, r6_.libelle_long AS libelle_long_12 FROM lettre_mission l0_ LEFT JOIN utilisateur u7_ ON l0_.id_utilisateur = u7_.id_utilisateur LEFT JOIN ref_role r1_ ON (r1_.id_role = u7_.id_role) LEFT JOIN projet_lettre_mission p2_ ON (p2_.id_lm = l0_.id_lm) LEFT JOIN ref_fop r3_ ON l0_.id_fop = r3_.id_fop LEFT JOIN workflow w4_ ON (p2_.id_workflow = w4_.id_workflow) LEFT JOIN utilisateur_information u8_ ON (u7_.id_utilisateur = u8_.id_utilisateur) INNER JOIN ref_federation r5_ ON u8_.id_federation = r5_.id_federation LEFT JOIN ref_affectation r6_ ON u8_.id_affectation = r6_.id_affectation WHERE 1 = 1 AND l0_.id_utilisateur = 3890 AND p2_.id_workflow = 7 AND p2_.date_debut <= '2024-09-19' AND p2_.date_fin >= '2024-09-19' ORDER BY l0_.id_lm DESC LIMIT 1;

SELECT
  r0_.r_ser_libl AS r_ser_libl_0
FROM
  r_federation r0_
WHERE
  r0_.r_adm_diside = ?

SELECT r0_.r_ser_libl AS r_ser_libl_0 FROM r_federation r0_ WHERE r0_.r_adm_diside = 'HOC';