Symfony Profiler

select
  ra.id_action as idac,
  ra.num_action as num_action,
  ra.libelle_action_long as libelle_action_long,
  rsa.id_sous_action as SOUSACTION,
  rsa.libelle_sous_action_long as lib_sous_action,
  u.p_civ_matcle as u_p_civ_matcle,
  lm.id_lm as lm_id_lm,
  u.id_utilisateur as u_id_utilisateur,
  sum(paa.quotite_regionale) as quo_reg,
  sum(paa.quotite_nationale) as quo_nat
from
  lettre_mission lm
  inner join projet_lettre_mission plm on plm.id_lm = lm.id_lm
  inner join utilisateur u on u.id_utilisateur = plm.id_utilisateur
  inner join mission paa on paa.id_projet_lm = plm.id_projet_lm
  inner join ref_activite_ref_sous_action refaa on refaa.id_activite = paa.id_activite
  left join ref_action ra on ra.id_action = refaa.id_action
  left join ref_sous_action rsa on rsa.id_sous_action = refaa.id_sous_action
  INNER JOIN ref_sous_action_ref_action rsara ON refaa.id_sous_action = rsara.id_sous_action
  and rsara.sous_action_active = true
where
  plm.id_projet_lm = 48227
  and refaa.activite_active = true
group by
  idac,
  SOUSACTION,
  libelle_action_long,
  lib_sous_action,
  u_p_civ_matcle,
  u_id_utilisateur,
  lm_id_lm
union all
select
  ra.id_action as idAc,
  ra.num_action as num_action,
  ra.libelle_action_long as libelle_action_long,
  rsa.id_sous_action as SOUSACTION,
  rsa.libelle_sous_action_long as lib_sous_action,
  u.p_civ_matcle as u_p_civ_matcle,
  lm.id_lm as lm_id_lm,
  u.id_utilisateur as u_id_utilisateur,
  sum(paa.quotite_reg_autre) as q_reg,
  sum(paa.quotite_nat_autre) as q_nat
from
  lettre_mission lm
  inner join projet_lettre_mission plm on plm.id_lm = lm.id_lm
  inner join utilisateur u on u.id_utilisateur = plm.id_utilisateur
  inner join plm_activite_autre paa on paa.id_projet_lm = plm.id_projet_lm
  left join ref_action ra on ra.id_action = paa.id_action
  left join ref_sous_action rsa on rsa.id_sous_action = paa.id_sous_action
where
  plm.id_projet_lm = 48227
  and rsa.date_desactivation IS NULL
group by
  idac,
  SOUSACTION,
  libelle_action_long,
  lib_sous_action,
  u_p_civ_matcle,
  u_id_utilisateur,
  lm_id_lm
order by
  num_action ASC,
  idac ASC,
  SOUSACTION ASC

select ra.id_action as idac
                      ,ra.num_action as num_action
                      ,ra.libelle_action_long as libelle_action_long
                      ,rsa.id_sous_action as SOUSACTION
                      ,rsa.libelle_sous_action_long as lib_sous_action
                      ,u.p_civ_matcle   as    u_p_civ_matcle
                      ,lm.id_lm   as lm_id_lm
                      ,u.id_utilisateur as u_id_utilisateur
                      ,sum(paa.quotite_regionale) as quo_reg
                       ,sum(paa.quotite_nationale) as quo_nat
                from lettre_mission lm
                  inner join projet_lettre_mission plm on plm.id_lm = lm.id_lm
                  inner join utilisateur u on u.id_utilisateur = plm.id_utilisateur
                  inner join mission paa on paa.id_projet_lm = plm.id_projet_lm
                  inner join ref_activite_ref_sous_action refaa on refaa.id_activite = paa.id_activite
                  left join ref_action ra on ra.id_action = refaa.id_action
                  left join ref_sous_action rsa on rsa.id_sous_action = refaa.id_sous_action
                  INNER JOIN ref_sous_action_ref_action rsara ON  refaa.id_sous_action = rsara.id_sous_action and rsara.sous_action_active = true
                where plm.id_projet_lm = 48227 and refaa.activite_active = true
                group by idac
                        ,SOUSACTION
                        ,libelle_action_long
                        ,lib_sous_action
                        ,u_p_civ_matcle
                        ,u_id_utilisateur
                        ,lm_id_lm
                union all
                select ra.id_action as idAc
                      ,ra.num_action as num_action
                      ,ra.libelle_action_long as libelle_action_long
                      ,rsa.id_sous_action as SOUSACTION
                      ,rsa.libelle_sous_action_long as lib_sous_action
                      ,u.p_civ_matcle   as          u_p_civ_matcle
                      ,lm.id_lm         as          lm_id_lm
                      ,u.id_utilisateur as u_id_utilisateur
                      ,sum(paa.quotite_reg_autre) as q_reg
                       ,sum(paa.quotite_nat_autre) as q_nat
                from lettre_mission lm
                  inner join projet_lettre_mission plm on plm.id_lm = lm.id_lm
                  inner join utilisateur u on u.id_utilisateur = plm.id_utilisateur
                  inner join plm_activite_autre paa on paa.id_projet_lm = plm.id_projet_lm
                  left join ref_action ra on ra.id_action = paa.id_action
                  left join ref_sous_action rsa on rsa.id_sous_action = paa.id_sous_action
                where plm.id_projet_lm = 48227 and rsa.date_desactivation IS NULL
                group by idac
                        ,SOUSACTION
                        ,libelle_action_long
                        ,lib_sous_action
                        ,u_p_civ_matcle
                        ,u_id_utilisateur
                        ,lm_id_lm
                order by num_action ASC, idac ASC, SOUSACTION ASC;

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

SELECT
  t0.id_projet_lm AS id_projet_lm_1,
  t0.identifiant_plm AS identifiant_plm_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.contenu_encart AS contenu_encart_5,
  t0.contenu_champ_libre AS contenu_champ_libre_6,
  t0.contenu_precision_dtn AS contenu_precision_dtn_7,
  t0.contenu_precision_sh AS contenu_precision_sh_8,
  t0.adresse_activite AS adresse_activite_9,
  t0.ordre_de_mission_general AS ordre_de_mission_general_10,
  t0.localisation AS localisation_11,
  t0.fonctcomplementaire AS fonctcomplementaire_12,
  t0.ordre_de_mission_specifique AS ordre_de_mission_specifique_13,
  t0.droit_cts AS droit_cts_14,
  t0.version AS version_15,
  t0.date AS date_16,
  t0.saison_sportive AS saison_sportive_17,
  t0.validation AS validation_18,
  t0.id_utilisateur AS id_utilisateur_19,
  t0.parent_id_projet_lm AS parent_id_projet_lm_20,
  t0.id_lm AS id_lm_21,
  t0.id_utilisateur AS id_utilisateur_22,
  t0.id_fop AS id_fop_23,
  t0.id_workflow AS id_workflow_24,
  t0.parent_id_projet_lm AS parent_id_projet_lm_25,
  t0.id_lieu AS id_lieu_26,
  t0.id_discipline AS id_discipline_27
FROM
  projet_lettre_mission t0
WHERE
  t0.id_projet_lm = ?

SELECT t0.id_projet_lm AS id_projet_lm_1, t0.identifiant_plm AS identifiant_plm_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.contenu_encart AS contenu_encart_5, t0.contenu_champ_libre AS contenu_champ_libre_6, t0.contenu_precision_dtn AS contenu_precision_dtn_7, t0.contenu_precision_sh AS contenu_precision_sh_8, t0.adresse_activite AS adresse_activite_9, t0.ordre_de_mission_general AS ordre_de_mission_general_10, t0.localisation AS localisation_11, t0.fonctcomplementaire AS fonctcomplementaire_12, t0.ordre_de_mission_specifique AS ordre_de_mission_specifique_13, t0.droit_cts AS droit_cts_14, t0.version AS version_15, t0.date AS date_16, t0.saison_sportive AS saison_sportive_17, t0.validation AS validation_18, t0.id_utilisateur AS id_utilisateur_19, t0.parent_id_projet_lm AS parent_id_projet_lm_20, t0.id_lm AS id_lm_21, t0.id_utilisateur AS id_utilisateur_22, t0.id_fop AS id_fop_23, t0.id_workflow AS id_workflow_24, t0.parent_id_projet_lm AS parent_id_projet_lm_25, t0.id_lieu AS id_lieu_26, t0.id_discipline AS id_discipline_27 FROM projet_lettre_mission t0 WHERE t0.id_projet_lm = 48227;

SELECT
  t0.id_lm AS id_lm_1,
  t0.id_gabarit AS id_gabarit_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.contenu_encart AS contenu_encart_5,
  t0.contenu_champ_libre AS contenu_champ_libre_6,
  t0.ordre_de_mission_general AS ordre_de_mission_general_7,
  t0.ordre_de_mission_specifique AS ordre_de_mission_specifique_8,
  t0.date_de_signature AS date_de_signature_9,
  t0.signature_electronique AS signature_electronique_10,
  t0.saison_sportive AS saison_sportive_11,
  t0.signataire_validationfonctionelle AS signataire_validationfonctionelle_12,
  t0.date_changement_administratif AS date_changement_administratif_13,
  t0.id_olympiade AS id_olympiade_14,
  t0.id_utilisateur AS id_utilisateur_15,
  t0.id_fop AS id_fop_16,
  t0.signataire AS signataire_17,
  t0.id_lieu AS id_lieu_18,
  t0.id_discipline AS id_discipline_19
FROM
  lettre_mission t0
WHERE
  t0.id_lm = ?

SELECT t0.id_lm AS id_lm_1, t0.id_gabarit AS id_gabarit_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.contenu_encart AS contenu_encart_5, t0.contenu_champ_libre AS contenu_champ_libre_6, t0.ordre_de_mission_general AS ordre_de_mission_general_7, t0.ordre_de_mission_specifique AS ordre_de_mission_specifique_8, t0.date_de_signature AS date_de_signature_9, t0.signature_electronique AS signature_electronique_10, t0.saison_sportive AS saison_sportive_11, t0.signataire_validationfonctionelle AS signataire_validationfonctionelle_12, t0.date_changement_administratif AS date_changement_administratif_13, t0.id_olympiade AS id_olympiade_14, t0.id_utilisateur AS id_utilisateur_15, t0.id_fop AS id_fop_16, t0.signataire AS signataire_17, t0.id_lieu AS id_lieu_18, t0.id_discipline AS id_discipline_19 FROM lettre_mission t0 WHERE t0.id_lm = 8988;

SELECT
  t0.id_fop AS id_fop_1,
  t0.libelle_fop AS libelle_fop_2,
  t0.date_activation AS date_activation_3,
  t0.date_desactivation AS date_desactivation_4
FROM
  ref_fop t0
WHERE
  t0.id_fop = ?
LIMIT
  1

SELECT t0.id_fop AS id_fop_1, t0.libelle_fop AS libelle_fop_2, t0.date_activation AS date_activation_3, t0.date_desactivation AS date_desactivation_4 FROM ref_fop t0 WHERE t0.id_fop = 4 LIMIT 1;

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

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_utilisateur = ?
LIMIT
  1

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_utilisateur = 4595 LIMIT 1;

SELECT
  t0.id_projet_lm AS id_projet_lm_1,
  t0.identifiant_plm AS identifiant_plm_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.contenu_encart AS contenu_encart_5,
  t0.contenu_champ_libre AS contenu_champ_libre_6,
  t0.contenu_precision_dtn AS contenu_precision_dtn_7,
  t0.contenu_precision_sh AS contenu_precision_sh_8,
  t0.adresse_activite AS adresse_activite_9,
  t0.ordre_de_mission_general AS ordre_de_mission_general_10,
  t0.localisation AS localisation_11,
  t0.fonctcomplementaire AS fonctcomplementaire_12,
  t0.ordre_de_mission_specifique AS ordre_de_mission_specifique_13,
  t0.droit_cts AS droit_cts_14,
  t0.version AS version_15,
  t0.date AS date_16,
  t0.saison_sportive AS saison_sportive_17,
  t0.validation AS validation_18,
  t0.id_utilisateur AS id_utilisateur_19,
  t0.parent_id_projet_lm AS parent_id_projet_lm_20,
  t0.id_lm AS id_lm_21,
  t0.id_utilisateur AS id_utilisateur_22,
  t0.id_fop AS id_fop_23,
  t0.id_workflow AS id_workflow_24,
  t0.parent_id_projet_lm AS parent_id_projet_lm_25,
  t0.id_lieu AS id_lieu_26,
  t0.id_discipline AS id_discipline_27
FROM
  projet_lettre_mission t0
WHERE
  t0.id_projet_lm = ?
LIMIT
  1

SELECT t0.id_projet_lm AS id_projet_lm_1, t0.identifiant_plm AS identifiant_plm_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.contenu_encart AS contenu_encart_5, t0.contenu_champ_libre AS contenu_champ_libre_6, t0.contenu_precision_dtn AS contenu_precision_dtn_7, t0.contenu_precision_sh AS contenu_precision_sh_8, t0.adresse_activite AS adresse_activite_9, t0.ordre_de_mission_general AS ordre_de_mission_general_10, t0.localisation AS localisation_11, t0.fonctcomplementaire AS fonctcomplementaire_12, t0.ordre_de_mission_specifique AS ordre_de_mission_specifique_13, t0.droit_cts AS droit_cts_14, t0.version AS version_15, t0.date AS date_16, t0.saison_sportive AS saison_sportive_17, t0.validation AS validation_18, t0.id_utilisateur AS id_utilisateur_19, t0.parent_id_projet_lm AS parent_id_projet_lm_20, t0.id_lm AS id_lm_21, t0.id_utilisateur AS id_utilisateur_22, t0.id_fop AS id_fop_23, t0.id_workflow AS id_workflow_24, t0.parent_id_projet_lm AS parent_id_projet_lm_25, t0.id_lieu AS id_lieu_26, t0.id_discipline AS id_discipline_27 FROM projet_lettre_mission t0 WHERE t0.id_projet_lm = 48227 LIMIT 1;

SELECT
  t0.id_lieu AS id_lieu_1,
  t0.libelle_lieu AS libelle_lieu_2,
  t0.date_activation AS date_activation_3,
  t0.date_desactivation AS date_desactivation_4
FROM
  ref_lieu t0
WHERE
  t0.id_lieu = ?

SELECT t0.id_lieu AS id_lieu_1, t0.libelle_lieu AS libelle_lieu_2, t0.date_activation AS date_activation_3, t0.date_desactivation AS date_desactivation_4 FROM ref_lieu t0 WHERE t0.id_lieu = 1;

SELECT
  r0_.id_fop AS id_fop_0,
  r0_.libelle_fop AS libelle_fop_1,
  r0_.date_activation AS date_activation_2,
  r0_.date_desactivation AS date_desactivation_3
FROM
  ref_fop r0_
WHERE
  r0_.id_fop IN (?)

SELECT r0_.id_fop AS id_fop_0, r0_.libelle_fop AS libelle_fop_1, r0_.date_activation AS date_activation_2, r0_.date_desactivation AS date_desactivation_3 FROM ref_fop r0_ WHERE r0_.id_fop IN ('18');