http://cts-web.sports.gouv.fr/api/getCategories

Query Metrics

10 Database Queries
3 Different statements
11.82 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.42 ms
(62.74%)
8
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
]
3.64 ms
(30.78%)
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:
[
  437
]
0.77 ms
(6.48%)
1
SELECT t0.id AS id_1, t0.nomCategorie AS nomcategorie_2 FROM categorie t0
Parameters:
[]

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
  • The mappings App\Entity\Utilisateur#documents and App\Entity\Document#utilisateur are inconsistent with each other.
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\Categorie No errors.
App\Entity\Media
  • The mappings App\Entity\Media#articlecategorie and App\Entity\Article#medias are inconsistent with each other.
App\Entity\Article
  • The mappings App\Entity\Article#mediasCategorie and App\Entity\Media#articlecategorie are inconsistent with each other.
App\Entity\Document
  • The association App\Entity\Document#utilisateur refers to the inverse side field App\Entity\Utilisateur#Documents which does not exist.
  • The association App\Entity\Document#auteur refers to the inverse side field App\Entity\Utilisateur#Documents which does not exist.
App\Entity\DocumentService No errors.