Symfony Profiler

Query Metrics

13 Database Queries

13 Different statements

3.69 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.42 ms
(38.47%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\PointageService->flush (line 134)
4	App\Controller\Api\CoureurParPcBatchController->__invoke (line 92)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.51 ms
(13.88%)

SELECT t0.IDCoureurParPC AS IDCoureurParPC_1, t0.Date AS Date_2, t0.HeureDePassage AS HeureDePassage_3, t0.IDPointControle AS IDPointControle_4, t0.IDParticipant AS IDParticipant_5, t0.IDUserResponsable AS IDUserResponsable_6 FROM CoureurParPC t0 WHERE t0.IDPointControle = ? AND t0.IDParticipant = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDCoureurParPC AS IDCoureurParPC_1,
  t0.Date AS Date_2,
  t0.HeureDePassage AS HeureDePassage_3,
  t0.IDPointControle AS IDPointControle_4,
  t0.IDParticipant AS IDParticipant_5,
  t0.IDUserResponsable AS IDUserResponsable_6
FROM
  CoureurParPC t0
WHERE
  t0.IDPointControle = ?
  AND t0.IDParticipant = ?
LIMIT
  1

SELECT t0.IDCoureurParPC AS IDCoureurParPC_1, t0.Date AS Date_2, t0.HeureDePassage AS HeureDePassage_3, t0.IDPointControle AS IDPointControle_4, t0.IDParticipant AS IDParticipant_5, t0.IDUserResponsable AS IDUserResponsable_6 FROM CoureurParPC t0 WHERE t0.IDPointControle = 3 AND t0.IDParticipant = 5 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\PointageService->processPointage (line 79)
4	App\Controller\Api\CoureurParPcBatchController->__invoke (line 70)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.32 ms
(8.57%)

DELETE FROM CoureurParPC WHERE IDCoureurParPC = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  CoureurParPC
WHERE
  IDCoureurParPC = ?

DELETE FROM CoureurParPC WHERE IDCoureurParPC = 7;

#	File/Call
1	Doctrine\DBAL\Connection->delete (line 402)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->delete (line 567)
3	Doctrine\ORM\UnitOfWork->executeDeletions (line 1167)
4	Doctrine\ORM\UnitOfWork->commit (line 428)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\PointageService->flush (line 134)
7	App\Controller\Api\CoureurParPcBatchController->__invoke (line 92)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.24 ms
(6.45%)

INSERT INTO CoureurParPC (Date, HeureDePassage, IDPointControle, IDParticipant, IDUserResponsable) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "2026-03-13"
  "14:00:18"
  3
  5
  4
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO CoureurParPC (
  Date, HeureDePassage, IDPointControle,
  IDParticipant, IDUserResponsable
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO CoureurParPC (Date, HeureDePassage, IDPointControle, IDParticipant, IDUserResponsable) VALUES ('2026-03-13', '14:00:18', 3, 5, 4);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\PointageService->flush (line 134)
7	App\Controller\Api\CoureurParPcBatchController->__invoke (line 92)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.18 ms
(4.91%)

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.NumDossard = ? LIMIT 1

Parameters:

[
  "1004"
]

View formatted query View runnable query Explain query View query backtrace

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.NumDossard = ?
LIMIT
  1

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.NumDossard = '1004' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\PointageService->processPointage (line 29)
4	App\Controller\Api\CoureurParPcBatchController->__invoke (line 70)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.18 ms
(4.82%)

SELECT t0.IDParticipant AS IDParticipant_1, t0.HeureDepart AS HeureDepart_2, t0.HeureArrivee AS HeureArrivee_3, t0.TempsTotal AS TempsTotal_4, t0.Emargement AS Emargement_5, t0.IDCoureur AS IDCoureur_6, t0.IDEtatCoureur AS IDEtatCoureur_7, t0.IDCourse AS IDCourse_8, t0.IDDossard AS IDDossard_9 FROM Participant t0 WHERE t0.IDDossard = ? LIMIT 1

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDParticipant AS IDParticipant_1,
  t0.HeureDepart AS HeureDepart_2,
  t0.HeureArrivee AS HeureArrivee_3,
  t0.TempsTotal AS TempsTotal_4,
  t0.Emargement AS Emargement_5,
  t0.IDCoureur AS IDCoureur_6,
  t0.IDEtatCoureur AS IDEtatCoureur_7,
  t0.IDCourse AS IDCourse_8,
  t0.IDDossard AS IDDossard_9
FROM
  Participant t0
WHERE
  t0.IDDossard = ?
LIMIT
  1

SELECT t0.IDParticipant AS IDParticipant_1, t0.HeureDepart AS HeureDepart_2, t0.HeureArrivee AS HeureArrivee_3, t0.TempsTotal AS TempsTotal_4, t0.Emargement AS Emargement_5, t0.IDCoureur AS IDCoureur_6, t0.IDEtatCoureur AS IDEtatCoureur_7, t0.IDCourse AS IDCourse_8, t0.IDDossard AS IDDossard_9 FROM Participant t0 WHERE t0.IDDossard = 8 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\PointageService->processPointage (line 37)
4	App\Controller\Api\CoureurParPcBatchController->__invoke (line 70)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.16 ms
(4.40%)

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)

0.14 ms
(3.82%)

SELECT t0.IDPointControle AS IDPointControle_1, t0.Libelle AS Libelle_2, t0.Code AS Code_3, t0.TelPC AS TelPC_4, t0.EstCloture AS EstCloture_5, t0.DateCloture AS DateCloture_6, t0.HeureCloture AS HeureCloture_7 FROM PointControle t0 WHERE t0.IDPointControle = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDPointControle AS IDPointControle_1,
  t0.Libelle AS Libelle_2,
  t0.Code AS Code_3,
  t0.TelPC AS TelPC_4,
  t0.EstCloture AS EstCloture_5,
  t0.DateCloture AS DateCloture_6,
  t0.HeureCloture AS HeureCloture_7
FROM
  PointControle t0
WHERE
  t0.IDPointControle = ?

SELECT t0.IDPointControle AS IDPointControle_1, t0.Libelle AS Libelle_2, t0.Code AS Code_3, t0.TelPC AS TelPC_4, t0.EstCloture AS EstCloture_5, t0.DateCloture AS DateCloture_6, t0.HeureCloture AS HeureCloture_7 FROM PointControle t0 WHERE t0.IDPointControle = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	App\Service\PointageService->processPointage (line 46)
6	App\Controller\Api\CoureurParPcBatchController->__invoke (line 70)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.12 ms
(3.23%)

SELECT t0.IDCourse AS IDCourse_1, t0.Code AS Code_2, t0.Nom AS Nom_3, t0.PrixEnAriary AS PrixEnAriary_4, t0.PrixEnEuro AS PrixEnEuro_5, t0.DepartOK AS DepartOK_6, t0.DateDepart AS DateDepart_7, t0.HeureDepart AS HeureDepart_8, t0.DateFin AS DateFin_9, t0.HeureFin AS HeureFin_10, t0.CodeCouleur AS CodeCouleur_11, t0.LieuCourse AS LieuCourse_12, t0.DateCourse AS DateCourse_13, t0.DistanceEnKm AS DistanceEnKm_14, t0.Lieu AS Lieu_15, t0.AgeMinimum AS AgeMinimum_16, t0.AgeMaximum AS AgeMaximum_17, t0.WithScratch AS WithScratch_18, t0.BarriereHor AS BarriereHor_19, t0.DistanceCourse AS DistanceCourse_20 FROM rd_course t0 WHERE t0.IDCourse = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDCourse AS IDCourse_1,
  t0.Code AS Code_2,
  t0.Nom AS Nom_3,
  t0.PrixEnAriary AS PrixEnAriary_4,
  t0.PrixEnEuro AS PrixEnEuro_5,
  t0.DepartOK AS DepartOK_6,
  t0.DateDepart AS DateDepart_7,
  t0.HeureDepart AS HeureDepart_8,
  t0.DateFin AS DateFin_9,
  t0.HeureFin AS HeureFin_10,
  t0.CodeCouleur AS CodeCouleur_11,
  t0.LieuCourse AS LieuCourse_12,
  t0.DateCourse AS DateCourse_13,
  t0.DistanceEnKm AS DistanceEnKm_14,
  t0.Lieu AS Lieu_15,
  t0.AgeMinimum AS AgeMinimum_16,
  t0.AgeMaximum AS AgeMaximum_17,
  t0.WithScratch AS WithScratch_18,
  t0.BarriereHor AS BarriereHor_19,
  t0.DistanceCourse AS DistanceCourse_20
FROM
  rd_course t0
WHERE
  t0.IDCourse = ?

SELECT t0.IDCourse AS IDCourse_1, t0.Code AS Code_2, t0.Nom AS Nom_3, t0.PrixEnAriary AS PrixEnAriary_4, t0.PrixEnEuro AS PrixEnEuro_5, t0.DepartOK AS DepartOK_6, t0.DateDepart AS DateDepart_7, t0.HeureDepart AS HeureDepart_8, t0.DateFin AS DateFin_9, t0.HeureFin AS HeureFin_10, t0.CodeCouleur AS CodeCouleur_11, t0.LieuCourse AS LieuCourse_12, t0.DateCourse AS DateCourse_13, t0.DistanceEnKm AS DistanceEnKm_14, t0.Lieu AS Lieu_15, t0.AgeMinimum AS AgeMinimum_16, t0.AgeMaximum AS AgeMaximum_17, t0.WithScratch AS WithScratch_18, t0.BarriereHor AS BarriereHor_19, t0.DistanceCourse AS DistanceCourse_20 FROM rd_course t0 WHERE t0.IDCourse = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Course::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Course->__get (line 153)
7	App\Entity\Course->getPcParCourses (line 381)
8	App\Service\PointageService->processPointage (line 53)
9	App\Controller\Api\CoureurParPcBatchController->__invoke (line 70)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.12 ms
(3.23%)

SELECT t0.IDPCParCourse AS IDPCParCourse_1, t0.numero AS numero_2, t0.IDPointControle AS IDPointControle_3, t0.IDCourse AS IDCourse_4 FROM PCParCourse t0 WHERE t0.IDCourse = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDPCParCourse AS IDPCParCourse_1,
  t0.numero AS numero_2,
  t0.IDPointControle AS IDPointControle_3,
  t0.IDCourse AS IDCourse_4
FROM
  PCParCourse t0
WHERE
  t0.IDCourse = ?

SELECT t0.IDPCParCourse AS IDPCParCourse_1, t0.numero AS numero_2, t0.IDPointControle AS IDPointControle_3, t0.IDCourse AS IDCourse_4 FROM PCParCourse t0 WHERE t0.IDCourse = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Service\PointageService->processPointage (line 53)
8	App\Controller\Api\CoureurParPcBatchController->__invoke (line 70)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.11 ms
(2.90%)

SELECT t0.IDEtatCoureur AS IDEtatCoureur_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3 FROM EtatCoureur t0 WHERE t0.Code = ? LIMIT 1

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDEtatCoureur AS IDEtatCoureur_1,
  t0.Code AS Code_2,
  t0.Libelle AS Libelle_3
FROM
  EtatCoureur t0
WHERE
  t0.Code = ?
LIMIT
  1

SELECT t0.IDEtatCoureur AS IDEtatCoureur_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3 FROM EtatCoureur t0 WHERE t0.Code = 2 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\PointageService->processPointage (line 114)
4	App\Controller\Api\CoureurParPcBatchController->__invoke (line 70)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.10 ms
(2.73%)

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 INNER JOIN responsable_pc ON t0.id = responsable_pc.id_user WHERE responsable_pc.IDPointControle = ?

Parameters:

[
  3
]

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
  INNER JOIN responsable_pc ON t0.id = responsable_pc.id_user
WHERE
  responsable_pc.IDPointControle = ?

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 INNER JOIN responsable_pc ON t0.id = responsable_pc.id_user WHERE responsable_pc.IDPointControle = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->exists (line 219)
7	App\Service\PointageService->processPointage (line 67)
8	App\Controller\Api\CoureurParPcBatchController->__invoke (line 70)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.10 ms
(2.60%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\PointageService->flush (line 134)
4	App\Controller\Api\CoureurParPcBatchController->__invoke (line 92)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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	2
App\Entity\Dossard	1
App\Entity\Course	1
App\Entity\Participant	1
App\Entity\Coureur	1
App\Entity\EtatCoureur	1
App\Entity\PointControle	1
App\Entity\PcParCourse	1
App\Entity\CoureurParPc	1

Entities Mapping

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

Symfony Profiler

POST https://coli.preprod.devsoft-pro.net/api/coureur_par_pcs/pointage/multiple

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping