GET https://coli.preprod.devsoft-pro.net/api/courses/with-participants

Query Metrics

7 Database Queries
5 Different statements
1.35 ms Query time
0 Invalid entities
14 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.44 ms
(32.65%)
2
SELECT t0.IDCoureur AS IDCoureur_1, t0.Date AS Date_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.DateNais AS DateNais_5, t0.Sexe AS Sexe_6, t0.Adresse AS Adresse_7, t0.Telephone AS Telephone_8, t0.Licencie AS Licencie_9, t0.NumLicence AS NumLicence_10, t0.Ville AS Ville_11, t0.Region AS Region_12, t0.Commune AS Commune_13, t0.PersonneAcontatcter AS PersonneAcontatcter_14, t0.NumPersonneAcontacter AS NumPersonneAcontacter_15, t0.NomTeam AS NomTeam_16, t0.Email AS Email_17, t0.Particulier AS Particulier_18, t0.NomClub AS NomClub_19, t0.Paye AS Paye_20, t0.CIN AS CIN_21, t0.linkcin AS linkcin_22, t0.LinkAutorisation AS LinkAutorisation_23, t0.linkcertificat AS linkcertificat_24, t0.profil AS profil_25, t0.PointureTshirt AS PointureTshirt_26, t0.remarque AS remarque_27, t0.StatusResidence AS StatusResidence_28, t0.Navette AS Navette_29, t0.IDCategorie AS IDCategorie_30, t0.IDNationalite AS IDNationalite_31, t0.IDCourse AS IDCourse_32 FROM rd_coureur t0 WHERE t0.IDCoureur = ?
Parameters:
[
  1
]
0.35 ms
(25.76%)
1
SELECT r0_.IDCourse AS IDCourse_0, r0_.Code AS Code_1, r0_.Nom AS Nom_2, r0_.PrixEnAriary AS PrixEnAriary_3, r0_.PrixEnEuro AS PrixEnEuro_4, r0_.DepartOK AS DepartOK_5, r0_.DateDepart AS DateDepart_6, r0_.HeureDepart AS HeureDepart_7, r0_.LieuCourse AS LieuCourse_8, r0_.DateCourse AS DateCourse_9, r0_.DistanceEnKm AS DistanceEnKm_10, r0_.Lieu AS Lieu_11, r0_.AgeMinimum AS AgeMinimum_12, r0_.AgeMaximum AS AgeMaximum_13, r0_.WithScratch AS WithScratch_14, r0_.BarriereHor AS BarriereHor_15, r0_.DistanceCourse AS DistanceCourse_16, p1_.IDParticipant AS IDParticipant_17, p1_.HeureDepart AS HeureDepart_18, p1_.HeureArrivee AS HeureArrivee_19, p1_.TempsTotal AS TempsTotal_20, p1_.Emargement AS Emargement_21, p1_.IDCoureur AS IDCoureur_22, p1_.IDEtatCoureur AS IDEtatCoureur_23, p1_.IDCourse AS IDCourse_24, p1_.IDDossard AS IDDossard_25 FROM rd_course r0_ LEFT JOIN Participant p1_ ON r0_.IDCourse = p1_.IDCourse ORDER BY r0_.IDCourse ASC
Parameters:
[]
0.22 ms
(16.06%)
2
SELECT t0.IDDossard AS IDDossard_1, t0.NumDossard AS NumDossard_2, t0.QRcode AS QRcode_3, t0.IDCourse AS IDCourse_4 FROM Dossard t0 WHERE t0.IDDossard = ?
Parameters:
[
  1
]
0.19 ms
(14.13%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.EstResponsable AS EstResponsable_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "responsable@gmail.com"
]
0.15 ms
(11.40%)
1
SELECT t0.IDEtatCoureur AS IDEtatCoureur_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3 FROM EtatCoureur t0 WHERE t0.IDEtatCoureur = ?
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Course 3
App\Entity\Participant 2
App\Entity\Coureur 2
App\Entity\Dossard 2
App\Entity\Categorie 2
App\Entity\User 1
App\Entity\EtatCoureur 1
App\Entity\Nationalite 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Course No errors.
App\Entity\Participant No errors.
App\Entity\Coureur No errors.
App\Entity\EtatCoureur No errors.
App\Entity\Dossard No errors.
App\Entity\PcParCourse No errors.
App\Entity\Categorie No errors.
App\Entity\Nationalite No errors.