Symfony Profiler

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
  fs.id_utilisateur = 4780
  AND fs.id_workflow IN (27, 28)
  AND date_fin >= current_date - interval '6' month
ORDER BY
  fs.date_fin ASC,
  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 fs.id_utilisateur = 4780 AND  fs.id_workflow IN (27, 28)
          AND date_fin >= current_date - interval '6' month  ORDER BY fs.date_fin ASC, fs.id_formation_session DESC;

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

SELECT
  fmt.libelle_motivation,
  fsm.valeur
FROM
  formation_session_motivation fsm
  INNER JOIN formation_motivation_type fmt ON fsm.id_formation_motivation = fmt.id_formation_motivation
  INNER JOIN formation_session fs ON fs.id_formation_session = fsm.id_formation_session
  INNER JOIN utilisateur_information ui ON ui.id_utilisateur = fs.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
WHERE
  fs.id_utilisateur = 4780
  AND fs.id_workflow IN (27, 28)
  AND date_fin >= current_date - interval '6' month
ORDER BY
  fs.id_formation_session DESC,
  fsm.id_formation_motivation

SELECT fmt.libelle_motivation, fsm.valeur
                FROM formation_session_motivation fsm 
                INNER JOIN formation_motivation_type fmt
                ON fsm.id_formation_motivation = fmt.id_formation_motivation
                INNER JOIN formation_session fs ON fs.id_formation_session = fsm.id_formation_session
                INNER JOIN utilisateur_information ui ON ui.id_utilisateur = fs.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 WHERE fs.id_utilisateur = 4780 AND  fs.id_workflow IN (27, 28)
          AND date_fin >= current_date - interval '6' month  ORDER BY fs.id_formation_session DESC, fsm.id_formation_motivation;

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

SELECT
  COUNT(*) AS count
FROM
  formation_motivation_type

SELECT COUNT(*) AS count FROM formation_motivation_type;