Query Metrics
45
Database Queries
13
Different statements
47.30 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
21.10 ms (44.62%) |
4 |
SELECT u0_.id_utilisateur AS id_utilisateur_0, u0_.civilite AS civilite_1, u1_.id_role AS id_role_2, u0_.nom AS nom_3, u0_.prenom AS prenom_4, u0_.date_de_naissance AS date_de_naissance_5, u1_.courriel AS courriel_6, u1_.telephone_bureau AS telephone_bureau_7, u1_.telephone_portable AS telephone_portable_8, u0_.adresse AS adresse_9, u0_.login AS login_10, u1_.p_civ_matcle AS p_civ_matcle_11, r2_.id_poste AS id_poste_12, r2_.libelle_poste AS libelle_poste_13, u0_.fonction AS fonction_14, u0_.grade AS grade_15, u0_.indice_majore AS indice_majore_16, u0_.date_fin_droits AS date_fin_droits_17, r3_.libelle_fop AS libelle_fop_18, r4_.libelle_fop AS libelle_fop_19, r5_.libelle_fop AS libelle_fop_20, r6_.libelle_affectation AS libelle_affectation_21, r6_.libelle_long AS libelle_long_22, r7_.r_ser_libl AS r_ser_libl_23, r6_.id_affectation AS id_affectation_24, u0_.token AS token_25, r8_.id_odm_cadre_general AS id_odm_cadre_general_26, r8_.libelle_odm_cadre_general AS libelle_odm_cadre_general_27, r9_.id_federation AS id_federation_28, r9_.saison_sportive_federation AS saison_sportive_federation_29, r10_.libelle_role AS libelle_role_30, u0_.grade AS grade_31, u0_.indice_majore AS indice_majore_32, r9_.droit_ref_federation AS droit_ref_federation_33, s11_.path AS path_34, s11_.id AS id_35, r12_.id_lieu AS id_lieu_36, l13_.date_fin AS date_fin_37, l13_.date_de_signature AS date_de_signature_38 FROM utilisateur_information u0_ INNER JOIN utilisateur u1_ ON u0_.id_utilisateur = u1_.id_utilisateur INNER JOIN ref_role r10_ ON u1_.id_role = r10_.id_role LEFT JOIN lettre_mission l13_ ON (l13_.id_utilisateur = u0_.id_utilisateur AND l13_.signataire IS NOT NULL) LEFT JOIN ref_fop r4_ ON l13_.id_fop = r4_.id_fop LEFT JOIN ref_fop r3_ ON u0_.id_fop = r3_.id_fop LEFT JOIN ref_fop r5_ ON u0_.id_foprinci = r5_.id_fop LEFT JOIN ref_odm_cadre_general r8_ ON u0_.id_odm_cadre_general = r8_.id_odm_cadre_general LEFT JOIN ref_lieu r12_ ON u0_.id_lieu = r12_.id_lieu LEFT JOIN ref_federation r9_ ON u0_.id_federation = r9_.id_federation LEFT JOIN r_federation r7_ ON (r7_.r_adm_diside = r9_.r_adm_diside) LEFT JOIN ref_affectation r6_ ON u0_.id_affectation = r6_.id_affectation LEFT JOIN ref_poste r2_ ON u0_.id_poste = r2_.id_poste LEFT JOIN scan_signature s11_ ON u0_.id_scan = s11_.id WHERE u0_.id_utilisateur = ? ORDER BY l13_.date_de_signature DESC
Parameters:
[
4756
]
|
5.93 ms (12.54%) |
8 |
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 = 1 ORDER BY r0_.id_gabarit ASC
Parameters:
[] |
2.35 ms (4.97%) |
1 |
SELECT article.id, article.titre, article.resume, article.contenu, article.datepublication, article.datefinpublication, article.statut, article.created, article.updated, article.slug, article.id_categorie, article.id_action, article.path FROM article INNER JOIN article_rfede fed ON article.id = fed.id_article INNER JOIN r_federation rfed ON rfed.r_adm_discipline_id = fed.r_adm_discipline_id INNER JOIN ref_federation reffed ON reffed.r_adm_diside = rfed.r_adm_diside AND reffed.id_federation = 43 AND '2025-03-15 12:20:00' BETWEEN article.datePublication AND article.dateFinPublication AND article.statut = true ORDER BY datePublication DESC
Parameters:
[] |
2.22 ms (4.70%) |
1 |
SELECT article.id, article.titre, article.resume, article.contenu, article.datepublication, article.datefinpublication, article.statut, article.created, article.updated, article.slug, article.id_categorie, article.id_action, article.path, affe.id_affectation AS id_affectation_article FROM article INNER JOIN article_affectation affe ON article.id = affe.id_article AND affe.id_affectation = 11 AND '2025-03-15 12:20:00' BETWEEN article.datePublication AND article.dateFinPublication AND article.statut = true ORDER BY datePublication DESC
Parameters:
[] |
1.93 ms (4.07%) |
4 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.path AS path_3, t0.resume AS resume_4, t0.contenu AS contenu_5, t0.datePublication AS datepublication_6, t0.DateFinPublication AS datefinpublication_7, t0.Statut AS statut_8, t0.created AS created_9, t0.updated AS updated_10, t0.slug AS slug_11, t0.id_categorie AS id_categorie_12, t0.id_utilisateur AS id_utilisateur_13, t0.id_action AS id_action_14 FROM article t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
138
]
|
1.88 ms (3.97%) |
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:
[
4756
]
|
1.88 ms (3.97%) |
4 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.created AS created_4, t0.updated AS updated_5, t0.id_article AS id_article_6, t0.id_categorie AS id_categorie_7, t0.id_article_categorie AS id_article_categorie_8, t0.id_document AS id_document_9, t0.id_documentservice AS id_documentservice_10 FROM media t0 WHERE t0.id_article = ?
Parameters:
[
138
]
|
1.87 ms (3.96%) |
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:
[
2046
]
|
1.86 ms (3.93%) |
4 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.created AS created_4, t0.updated AS updated_5, t0.id_article AS id_article_6, t0.id_categorie AS id_categorie_7, t0.id_article_categorie AS id_article_categorie_8, t0.id_document AS id_document_9, t0.id_documentservice AS id_documentservice_10 FROM media t0 WHERE t0.id_article_categorie = ?
Parameters:
[
138
]
|
1.78 ms (3.77%) |
4 |
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
]
|
1.59 ms (3.37%) |
3 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.created AS created_4, t0.updated AS updated_5, t0.id_article AS id_article_6, t0.id_categorie AS id_categorie_7, t0.id_article_categorie AS id_article_categorie_8, t0.id_document AS id_document_9, t0.id_documentservice AS id_documentservice_10 FROM media t0 WHERE t0.id_categorie = ?
Parameters:
[
1
]
|
1.53 ms (3.24%) |
3 |
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:
[
4464
]
|
1.37 ms (2.90%) |
4 |
SELECT t0.id AS id_1, t0.nomCategorie AS nomcategorie_2 FROM categorie t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
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\ListeDiffusionSup | No errors. |
App\Entity\RefRole | No errors. |
App\Entity\ListeDiffusion | 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\RefAction | No errors. |
App\Entity\RFederation | No errors. |
App\Entity\RefSousAction | No errors. |
App\Entity\Media |
|
App\Entity\RefGabarit | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\DocumentService | No errors. |