Symfony Profiler

Query Metrics

23 Database Queries

5 Different statements

15.55 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.58 ms
(55.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.participant_id = ?

Parameters:

[
  33
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.code AS code_4,
  t0.icon AS icon_5,
  t0.api_id AS api_id_6,
  t0.current_form AS current_form_7,
  t0.participant_id AS participant_id_8,
  t0.competition_id AS competition_id_9
FROM
  competitor t0
WHERE
  t0.participant_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.participant_id = 33;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 167)
8	Symfony\Component\Serializer\Serializer->normalize (line 226)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
11	Symfony\Component\Serializer\Serializer->normalize (line 168)
12	Symfony\Component\Serializer\Serializer->normalize (line 768)
13	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
15	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
17	Symfony\Component\Serializer\Serializer->normalize (line 226)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
20	Symfony\Component\Serializer\Serializer->normalize (line 768)
21	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
22	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
23	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
24	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
25	Symfony\Component\Serializer\Serializer->normalize (line 129)
26	Symfony\Component\Serializer\Serializer->serialize (line 44)
27	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
28	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
29	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

2.19 ms
(14.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.active AS active_6, t0.api_id AS api_id_7, t0.sport_id AS sport_id_8 FROM participant t0 WHERE t0.id = ?

Parameters:

[
  269
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.code AS code_4,
  t0.icon AS icon_5,
  t0.active AS active_6,
  t0.api_id AS api_id_7,
  t0.sport_id AS sport_id_8
FROM
  participant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.active AS active_6, t0.api_id AS api_id_7, t0.sport_id AS sport_id_8 FROM participant t0 WHERE t0.id = 269;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Participant::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Participant->__get (line 62)
8	App\Entity\Participant->getName (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 140)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 197)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 768)
15	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
16	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
17	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
19	Symfony\Component\Serializer\Serializer->normalize (line 129)
20	Symfony\Component\Serializer\Serializer->serialize (line 44)
21	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
22	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
23	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

2.04 ms
(13.11%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.code AS code_3, c0_.icon AS icon_4, c0_.api_id AS api_id_5, c0_.current_form AS current_form_6, c0_.participant_id AS participant_id_7, c0_.competition_id AS competition_id_8 FROM competitor c0_ WHERE c0_.id = ?

Parameters:

[
  170
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.code AS code_3,
  c0_.icon AS icon_4,
  c0_.api_id AS api_id_5,
  c0_.current_form AS current_form_6,
  c0_.participant_id AS participant_id_7,
  c0_.competition_id AS competition_id_8
FROM
  competitor c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.code AS code_3, c0_.icon AS icon_4, c0_.api_id AS api_id_5, c0_.current_form AS current_form_6, c0_.participant_id AS participant_id_7, c0_.competition_id AS competition_id_8 FROM competitor c0_ WHERE c0_.id = 170;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 87)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 79)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 86)
10	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 103)
11	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
14	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 87)
15	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

1.69 ms
(10.88%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.active AS active_6, t0.api_id AS api_id_7, t0.sport_id AS sport_id_8 FROM participant t0 WHERE t0.sport_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.code AS code_4,
  t0.icon AS icon_5,
  t0.active AS active_6,
  t0.api_id AS api_id_7,
  t0.sport_id AS sport_id_8
FROM
  participant t0
WHERE
  t0.sport_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.active AS active_6, t0.api_id AS api_id_7, t0.sport_id AS sport_id_8 FROM participant t0 WHERE t0.sport_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 167)
8	Symfony\Component\Serializer\Serializer->normalize (line 768)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
13	Symfony\Component\Serializer\Serializer->normalize (line 226)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
16	Symfony\Component\Serializer\Serializer->normalize (line 768)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
21	Symfony\Component\Serializer\Serializer->normalize (line 129)
22	Symfony\Component\Serializer\Serializer->serialize (line 44)
23	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
24	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
25	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

1.06 ms
(6.80%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.icon AS icon_4 FROM sport t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.icon AS icon_4
FROM
  sport t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.icon AS icon_4 FROM sport t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Sport::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Sport->__get (line 63)
8	App\Entity\Sport->getName (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 795)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
15	Symfony\Component\Serializer\Serializer->normalize (line 226)
16	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
18	Symfony\Component\Serializer\Serializer->normalize (line 768)
19	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
20	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
21	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
22	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
23	Symfony\Component\Serializer\Serializer->normalize (line 129)
24	Symfony\Component\Serializer\Serializer->serialize (line 44)
25	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
26	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
27	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	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.

Entities Mapping

Class	Mapping errors
App\Entity\Competitor	No errors.
App\Entity\Participant	No errors.
App\Entity\Competition	No errors.
App\Entity\Game	No errors.
App\Entity\Sport	No errors.

Symfony Profiler

GET https://operture.be/api/competitors/170

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping