Query Metrics
52
Database Queries
19
Different statements
51.42 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
29.75 ms (57.86%) |
14 |
select plmactindc.id_activite as ID_ACTIVITE, refindic.id_indicateur as ID_INDICATEUR, refindic.libelle_indicateur as LIB_INDICATEUR from plm_activite_indic plmactindc, ref_indicateur refindic where id_projet_lm = 46973 AND refindic.id_indicateur = plmactindc.id_indicateur UNION select pia.id_activite as id_activite, paia.id_plm_act_ind_autre as id_plm_ind_autre, paia.libelle_indicateur_autre as libelle_indicateur_autre from plm_indicateur_autre pia, plm_activite_indic_autre paia where pia.id_projet_lm = 46973 AND pia.id_plm_ind_autre = paia.id_plm_ind_autre
Parameters:
[] |
7.46 ms (14.51%) |
1 |
select ra.id_action as ACTION ,ra.libelle_action_long as LIB_ACTION ,ra.libelle_action_court as COD_ACTION ,ra.num_action as num_action ,rsa.id_sous_action as SOUSACTION ,rsa.libelle_sous_action_long as LIB_SOUSACTION ,lm.id_lm as lm_id_lm ,u.id_utilisateur as u_id_utilisateur ,(paa.quotite_regionale) as quo_reg ,(paa.quotite_nationale) as quo_nat ,refact.libelle_activite as activite ,refact.masquer_libelle as masquer ,refact.id_activite as id_activite ,'-1' as id_activite_autre ,plm.version as version_plm 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 inner join ref_activite refact on refact.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 = 46973 and refaa.activite_active = true union all select ra.id_action as ACTION ,ra.libelle_action_long as LIB_ACTION ,ra.libelle_action_court as COD_ACTION ,ra.num_action as num_action ,rsa.id_sous_action as SOUSACTION ,rsa.libelle_sous_action_long as LIB_SOUSACTION ,lm.id_lm as lm_id_lm ,u.id_utilisateur as u_id_utilisateur ,(paa.quotite_reg_autre) as q_reg ,(paa.quotite_nat_autre) as q_nat , paa.libelle_act_autre as activite , false as masquer ,'-1' as id_activite ,paa.id_act_autre as id_activite_autre ,plm.version as version_plm 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 = 46973 and rsa.date_desactivation IS NULL order by num_action asc;
Parameters:
[] |
2.84 ms (5.53%) |
12 |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.texte AS texte_2 FROM parametrage_texte p0_ WHERE p0_.code LIKE ?
Parameters:
[
"LM_CADRE_GENERAL"
]
|
1.61 ms (3.13%) |
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_information_personnelle = ?
Parameters:
[
2652
]
|
1.33 ms (2.58%) |
2 |
SELECT r0_.r_adm_discipline_id AS r_adm_discipline_id_0, r0_.r_adm_diside AS r_adm_diside_1, r0_.r_adm_disdde AS r_adm_disdde_2, r0_.r_adm_disdfn AS r_adm_disdfn_3, r0_.r_adm_disact AS r_adm_disact_4, r0_.r_ser_libl AS r_ser_libl_5, r0_.r_ser_libc AS r_ser_libc_6, r0_.libelle_sport AS libelle_sport_7 FROM r_federation r0_ INNER JOIN ref_federation r1_ ON (r1_.r_adm_diside = r0_.r_adm_diside) WHERE r1_.id_federation = ?
Parameters:
[
24
]
|
1.33 ms (2.58%) |
4 |
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
Parameters:
[
5061
]
|
1.13 ms (2.19%) |
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 = ?
Parameters:
[
"46973"
]
|
0.88 ms (1.70%) |
4 |
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
Parameters:
[
6
]
|
0.72 ms (1.41%) |
1 |
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 = ?
Parameters:
[
9049
]
|
0.65 ms (1.27%) |
2 |
SELECT t0.id_affectation AS id_affectation_1, t0.libelle_affectation AS libelle_affectation_2, t0.code_region AS code_region_3, t0.dom AS dom_4, t0.tom AS tom_5, t0.date_activation AS date_activation_6, t0.date_desactivation AS date_desactivation_7, t0.r_ser_ident AS r_ser_ident_8, t0.libelle_long AS libelle_long_9, t0.text_DGCS_dr_ds AS text_dgcs_dr_ds_10, t0.calendrier_scolaire AS calendrier_scolaire_11, t0.date_bascule AS date_bascule_12, t0.date_debut_credit AS date_debut_credit_13, t0.date_fin_credit AS date_fin_credit_14, t0.date_fin_debit AS date_fin_debit_15, t0.date_debut_debit AS date_debut_debit_16 FROM ref_affectation t0 WHERE t0.libelle_long = ? LIMIT 1
Parameters:
[
"Ile-de-France"
]
|
0.64 ms (1.24%) |
1 |
SELECT r0_.id_gabarit AS id_gabarit_0, r0_.logo AS logo_1, r0_.entete AS entete_2, r0_.direction AS direction_3, r0_.adresse AS adresse_4, r0_.adresse_suite AS adresse_suite_5, r0_.cp AS cp_6, r0_.ville AS ville_7, r0_.tel AS tel_8, r0_.fax AS fax_9, r0_.email AS email_10, r0_.emailOdm AS emailodm_11, r0_.emailConges AS emailconges_12, r0_.emailLm AS emaillm_13, r0_.emailFo AS emailfo_14, r0_.site_web AS site_web_15, r0_.date_desactivation AS date_desactivation_16, r0_.id_affectation AS id_affectation_17, r0_.id_federation AS id_federation_18 FROM ref_gabarit r0_ WHERE r0_.id_federation IS NULL AND r0_.date_desactivation IS NULL AND r0_.id_affectation = 11 ORDER BY r0_.id_gabarit ASC
Parameters:
[] |
0.61 ms (1.19%) |
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 = ?
Parameters:
[
5061
]
|
0.51 ms (1.00%) |
1 |
SELECT t0.id_affectation AS id_affectation_1, t0.libelle_affectation AS libelle_affectation_2, t0.code_region AS code_region_3, t0.dom AS dom_4, t0.tom AS tom_5, t0.date_activation AS date_activation_6, t0.date_desactivation AS date_desactivation_7, t0.r_ser_ident AS r_ser_ident_8, t0.libelle_long AS libelle_long_9, t0.text_DGCS_dr_ds AS text_dgcs_dr_ds_10, t0.calendrier_scolaire AS calendrier_scolaire_11, t0.date_bascule AS date_bascule_12, t0.date_debut_credit AS date_debut_credit_13, t0.date_fin_credit AS date_fin_credit_14, t0.date_fin_debit AS date_fin_debit_15, t0.date_debut_debit AS date_debut_debit_16 FROM ref_affectation t0 WHERE t0.id_affectation = ?
Parameters:
[
11
]
|
0.45 ms (0.87%) |
2 |
SELECT t0.id_affectation AS id_affectation_1, t0.libelle_affectation AS libelle_affectation_2, t0.code_region AS code_region_3, t0.dom AS dom_4, t0.tom AS tom_5, t0.date_activation AS date_activation_6, t0.date_desactivation AS date_desactivation_7, t0.r_ser_ident AS r_ser_ident_8, t0.libelle_long AS libelle_long_9, t0.text_DGCS_dr_ds AS text_dgcs_dr_ds_10, t0.calendrier_scolaire AS calendrier_scolaire_11, t0.date_bascule AS date_bascule_12, t0.date_debut_credit AS date_debut_credit_13, t0.date_fin_credit AS date_fin_credit_14, t0.date_fin_debit AS date_fin_debit_15, t0.date_debut_debit AS date_debut_debit_16 FROM ref_affectation t0 WHERE t0.id_affectation = ? LIMIT 1
Parameters:
[
1
]
|
0.44 ms (0.85%) |
1 |
SELECT t0.id_discipline AS id_discipline_1, t0.id_lm AS id_lm_2, t0.id_plm AS id_plm_3 FROM ref_discipline_lm t0 WHERE t0.id_lm = ?
Parameters:
[
9049
]
|
0.34 ms (0.66%) |
1 |
SELECT t0.id_poste AS id_poste_1, t0.libelle_poste AS libelle_poste_2 FROM ref_poste t0 WHERE t0.id_poste = ?
Parameters:
[
2
]
|
0.27 ms (0.52%) |
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 = ?
Parameters:
[
4
]
|
0.24 ms (0.47%) |
1 |
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.r_adm_diside = ? LIMIT 1
Parameters:
[
"FCO"
]
|
0.23 ms (0.44%) |
1 |
SELECT t0.r_adm_discipline_id AS r_adm_discipline_id_1, t0.r_adm_diside AS r_adm_diside_2, t0.r_adm_disdde AS r_adm_disdde_3, t0.r_adm_disdfn AS r_adm_disdfn_4, t0.r_adm_disact AS r_adm_disact_5, t0.r_ser_libl AS r_ser_libl_6, t0.r_ser_libc AS r_ser_libc_7, t0.libelle_sport AS libelle_sport_8 FROM r_federation t0 WHERE t0.r_ser_libl = ? LIMIT 1
Parameters:
[
"Fédération française des clubs omnisports"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\UtilisateurInformation | No errors. |
App\Entity\Utilisateur |
|
App\Entity\RefAffectation | No errors. |
App\Entity\RefFederation | No errors. |
App\Entity\RefFop | No errors. |
App\Entity\RefLieu | No errors. |
App\Entity\RefOdmCadreGeneral | No errors. |
App\Entity\RefPoste | No errors. |
App\Entity\ScanSignature | No errors. |
App\Entity\RefRole | No errors. |
App\Entity\ListeDiffusion | No errors. |
App\Entity\ListeDiffusionSup | No errors. |
App\Entity\HistoFederation | No errors. |
App\Entity\HistoAffectation | No errors. |
App\Entity\HistoPoste | No errors. |
App\Entity\Article |
|
App\Entity\Document |
|
App\Entity\LettreMission | No errors. |
App\Entity\ProjetLettreMission | No errors. |
App\Entity\Workflow | No errors. |
App\Entity\RefDiscipline | No errors. |
App\Entity\Mission | No errors. |
App\Entity\PlmActiviteIndic | No errors. |
App\Entity\PlmIndicateurAutre | No errors. |
App\Entity\PlmActiviteAutre | No errors. |
App\Entity\RapportActivite | No errors. |
App\Entity\RFederation | No errors. |
App\Entity\ParametrageTexte | No errors. |
App\Entity\RefDisciplineLm | No errors. |
App\Entity\RefGabarit | No errors. |