Symfony Profiler

Query Metrics

9 Database Queries

5 Different statements

8.57 ms Query time

0 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.72 ms
(43.35%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM opening_hours_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  b"\x01 lÌá%|gš~„ôâ!ˆš"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  opening_hours_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM opening_hours_translation t0 WHERE t0.translatable_id = 0x01A06CCCE1257C679A7E84F4E221889A;

#	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 2746)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\OpeningHours->findTranslationByLocale (line 190)
9	App\Entity\OpeningHours->doTranslate (line 138)
10	App\Entity\OpeningHours->translate (line 75)
11	App\Entity\OpeningHours->getTranslateLabel (line 110)
12	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
13	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
14	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 118)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Serializer->normalize (line 152)
18	Symfony\Component\Serializer\Serializer->normalize (line 170)
19	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1102)
20	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
21	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 204)
22	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
23	Symfony\Component\Serializer\Serializer->normalize (line 152)
24	Symfony\Component\Serializer\Serializer->serialize (line 131)
25	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
26	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
27	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
28	ApiPlatform\Symfony\Validator\State\ValidateProcessor->process (line 40)
29	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
34	require_once (line 32)
35	require_once (line 5)

2.31 ms
(26.91%)

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.position AS position_4, t0.opening_hours_id AS opening_hours_id_5 FROM opening_hours_slot t0 WHERE t0.opening_hours_id = ?

Parameters:

[
  b"\x01 lÌá%|gš~„ôâ!ˆš"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_time AS start_time_2,
  t0.end_time AS end_time_3,
  t0.position AS position_4,
  t0.opening_hours_id AS opening_hours_id_5
FROM
  opening_hours_slot t0
WHERE
  t0.opening_hours_id = ?

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.position AS position_4, t0.opening_hours_id AS opening_hours_id_5 FROM opening_hours_slot t0 WHERE t0.opening_hours_id = 0x01A06CCCE1257C679A7E84F4E221889A;

#	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 2746)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 228)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1102)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
14	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 204)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Serializer->normalize (line 152)
17	Symfony\Component\Serializer\Serializer->serialize (line 131)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
19	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
20	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
21	ApiPlatform\Symfony\Validator\State\ValidateProcessor->process (line 40)
22	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.96 ms
(11.15%)

SELECT t0.id AS id_1, t0.address AS address_2, t0.phone AS phone_3, t0.email AS email_4, t0.instagram_url AS instagram_url_5, t0.facebook_url AS facebook_url_6, t0.map AS map_7 FROM restaurant t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.instagram_url AS instagram_url_5,
  t0.facebook_url AS facebook_url_6,
  t0.map AS map_7
FROM
  restaurant t0
LIMIT
  1

SELECT t0.id AS id_1, t0.address AS address_2, t0.phone AS phone_3, t0.email AS email_4, t0.instagram_url AS instagram_url_5, t0.facebook_url AS facebook_url_6, t0.map AS map_7 FROM restaurant t0 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	App\State\Provider\RestaurantItemProvider->provide (line 24)
5	ApiPlatform\State\CallableProvider->provide (line 43)
6	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
7	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
8	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
9	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
10	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
11	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
12	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
13	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
15	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 102)
16	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
17	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
18	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.85 ms
(9.96%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.subname AS subname_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM restaurant_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  b"\x01 lÌá\x04qñ†GÊÒr¸&q"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.subname AS subname_3,
  t0.description AS description_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  restaurant_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.subname AS subname_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM restaurant_translation t0 WHERE t0.translatable_id = 0x01A06CCCE10471F18647CAD272B82671;

#	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 2746)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\Restaurant->findTranslationByLocale (line 190)
9	App\Entity\Restaurant->doTranslate (line 138)
10	App\Entity\Restaurant->translate (line 75)
11	App\Entity\Restaurant->getTranslateName (line 147)
12	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
13	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
14	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1116)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 204)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
22	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
23	ApiPlatform\Symfony\Validator\State\ValidateProcessor->process (line 40)
24	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	require_once (line 5)

0.74 ms
(8.62%)

SELECT t0.id AS id_1, t0.closed AS closed_2, t0.position AS position_3 FROM opening_hours t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.closed AS closed_2,
  t0.position AS position_3
FROM
  opening_hours t0

SELECT t0.id AS id_1, t0.closed AS closed_2, t0.position AS position_3 FROM opening_hours t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\State\Provider\RestaurantItemProvider->provide (line 25)
5	ApiPlatform\State\CallableProvider->provide (line 43)
6	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
7	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
8	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
9	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
10	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
11	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
12	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
13	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
15	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 102)
16	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
17	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
18	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	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\OpeningHoursTranslation	9
App\Entity\OpeningHours	3
App\Entity\OpeningHoursSlot	3
App\Entity\RestaurantTranslation	3
App\Entity\Restaurant	1

Entities Mapping

Class	Mapping errors
App\Entity\Restaurant	No errors.
App\Entity\RestaurantTranslation	No errors.
App\Entity\OpeningHours	No errors.
App\Entity\OpeningHoursSlot	No errors.
App\Entity\OpeningHoursTranslation	No errors.

Symfony Profiler

GET https://api-a-la-carte.wevoria.com/fr/restaurants

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping