GET https://coli.preprod.devsoft-pro.net/api/coureur_par_pcs/bytoken

Query Metrics

2 Database Queries
2 Different statements
0.97 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0.15 ms
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:
[
  "wirus@gmail.com"
]
2 0.82 ms
SELECT c0_.IDCoureurParPC AS IDCoureurParPC_0, c0_.Date AS Date_1, c0_.HeureDePassage AS HeureDePassage_2, p1_.IDPointControle AS IDPointControle_3, p1_.Libelle AS Libelle_4, p1_.Code AS Code_5, p1_.TelPC AS TelPC_6, p1_.EstCloture AS EstCloture_7, p1_.DateCloture AS DateCloture_8, p1_.HeureCloture AS HeureCloture_9, p2_.IDParticipant AS IDParticipant_10, p2_.HeureDepart AS HeureDepart_11, p2_.HeureArrivee AS HeureArrivee_12, p2_.TempsTotal AS TempsTotal_13, p2_.Emargement AS Emargement_14, r3_.IDCoureur AS IDCoureur_15, r3_.Date AS Date_16, r3_.Nom AS Nom_17, r3_.Prenom AS Prenom_18, r3_.DateNais AS DateNais_19, r3_.Sexe AS Sexe_20, r3_.Adresse AS Adresse_21, r3_.Telephone AS Telephone_22, r3_.Licencie AS Licencie_23, r3_.NumLicence AS NumLicence_24, r3_.Ville AS Ville_25, r3_.Region AS Region_26, r3_.Commune AS Commune_27, r3_.PersonneAcontatcter AS PersonneAcontatcter_28, r3_.NumPersonneAcontacter AS NumPersonneAcontacter_29, r3_.NomTeam AS NomTeam_30, r3_.Email AS Email_31, r3_.Particulier AS Particulier_32, r3_.NomClub AS NomClub_33, r3_.Paye AS Paye_34, r3_.CIN AS CIN_35, r3_.linkcin AS linkcin_36, r3_.LinkAutorisation AS LinkAutorisation_37, r3_.linkcertificat AS linkcertificat_38, r3_.profil AS profil_39, r3_.PointureTshirt AS PointureTshirt_40, r3_.remarque AS remarque_41, r3_.StatusResidence AS StatusResidence_42, r3_.Navette AS Navette_43, d4_.IDDossard AS IDDossard_44, d4_.NumDossard AS NumDossard_45, d4_.QRcode AS QRcode_46, c0_.IDPointControle AS IDPointControle_47, c0_.IDParticipant AS IDParticipant_48, c0_.IDUserResponsable AS IDUserResponsable_49, p2_.IDCoureur AS IDCoureur_50, p2_.IDEtatCoureur AS IDEtatCoureur_51, p2_.IDCourse AS IDCourse_52, p2_.IDDossard AS IDDossard_53, r3_.IDCategorie AS IDCategorie_54, r3_.IDNationalite AS IDNationalite_55, r3_.IDCourse AS IDCourse_56, d4_.IDCourse AS IDCourse_57 FROM CoureurParPC c0_ INNER JOIN PointControle p1_ ON c0_.IDPointControle = p1_.IDPointControle INNER JOIN responsable_pc r6_ ON p1_.IDPointControle = r6_.IDPointControle INNER JOIN `user` u5_ ON u5_.id = r6_.id_user INNER JOIN Participant p2_ ON c0_.IDParticipant = p2_.IDParticipant INNER JOIN rd_coureur r3_ ON p2_.IDCoureur = r3_.IDCoureur INNER JOIN Dossard d4_ ON p2_.IDDossard = d4_.IDDossard WHERE u5_.id = ?
Parameters:
[
  4
]

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\User 1

Entities Mapping

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