Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.97 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.82 ms
(84.12%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\State\CoureurParPcCollectionProvider->provide (line 39)
7	ApiPlatform\State\CallableProvider->provide (line 43)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
9	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
13	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 92)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.15 ms
(15.88%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'wirus@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->{closure:Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator::authenticate():105} (line 105)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width