Symfony Profiler

Query Metrics

28 Database Queries

10 Different statements

28.98 ms Query time

0 Invalid entities

47 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.61 ms
(15.92%)

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

Parameters:

[
  b".\t2|\x07 DC˜iŽZ¬¼í"
]

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
  equipment_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 equipment_translation t0 WHERE t0.translatable_id = 0x2E09327C0720444398698DAD5AACBCED;

#	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 2733)
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\Equipment->findTranslationByLocale (line 190)
9	App\Entity\Equipment->doTranslate (line 138)
10	App\Entity\Equipment->translate (line 75)
11	App\Entity\Equipment->getLabel (line 82)
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 199)
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 1049)
20	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
21	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
22	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
23	Symfony\Component\Serializer\Serializer->normalize (line 152)
24	Symfony\Component\Serializer\Serializer->normalize (line 170)
25	Symfony\Component\Serializer\Serializer->serialize (line 131)
26	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
28	App\Controller\Api\RoomController->__invoke (line 36)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

3.57 ms
(12.33%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.type AS type_5, t0.active AS active_6 FROM availability t0 INNER JOIN availability_room ON t0.id = availability_room.availability_id WHERE availability_room.room_id = ?

Parameters:

[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.type AS type_5,
  t0.active AS active_6
FROM
  availability t0
  INNER JOIN availability_room ON t0.id = availability_room.availability_id
WHERE
  availability_room.room_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.type AS type_5, t0.active AS active_6 FROM availability t0 INNER JOIN availability_room ON t0.id = availability_room.availability_id WHERE availability_room.room_id = 0x27667FBFBE82463BB78FEB588AD85857;

#	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 2737)
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	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1049)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
10	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 170)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
17	App\Controller\Api\RoomController->__invoke (line 36)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

3.45 ms
(11.91%)

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.active AS active_3 FROM equipment t0 INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id WHERE room_equipment.room_id = ?

Parameters:

[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.active AS active_3
FROM
  equipment t0
  INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id
WHERE
  room_equipment.room_id = ?

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.active AS active_3 FROM equipment t0 INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id WHERE room_equipment.room_id = 0x27667FBFBE82463BB78FEB588AD85857;

#	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 2737)
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	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1049)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
10	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 170)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
17	App\Controller\Api\RoomController->__invoke (line 36)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

3.14 ms
(10.85%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.view AS view_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM room_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]

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.view AS view_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.slug AS slug_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  room_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.view AS view_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM room_translation t0 WHERE t0.translatable_id = 0x27667FBFBE82463BB78FEB588AD85857;

#	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 2733)
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\Room->findTranslationByLocale (line 190)
9	App\Entity\Room->doTranslate (line 138)
10	App\Entity\Room->translate (line 75)
11	App\Entity\Room->getName (line 326)
12	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
13	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
14	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1074)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->normalize (line 170)
20	Symfony\Component\Serializer\Serializer->serialize (line 131)
21	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
23	App\Controller\Api\RoomController->__invoke (line 36)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

2.98 ms
(10.28%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.disabled_at AS disabled_at_6, t0.active AS active_7, t0.room_id AS room_id_8 FROM room_gallery t0 WHERE t0.room_id = ?

Parameters:

[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.main AS main_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.disabled_at AS disabled_at_6,
  t0.active AS active_7,
  t0.room_id AS room_id_8
FROM
  room_gallery t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.disabled_at AS disabled_at_6, t0.active AS active_7, t0.room_id AS room_id_8 FROM room_gallery t0 WHERE t0.room_id = 0x27667FBFBE82463BB78FEB588AD85857;

#	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 2733)
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	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1049)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
10	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 170)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
17	App\Controller\Api\RoomController->__invoke (line 36)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

2.95 ms
(10.17%)

SELECT t0.id AS id_1, t0.minimum_nights AS minimum_nights_2, t0.maximum_nights AS maximum_nights_3, t0.active AS active_4 FROM stay_duration t0 INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id WHERE stay_duration_room.room_id = ?

Parameters:

[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.minimum_nights AS minimum_nights_2,
  t0.maximum_nights AS maximum_nights_3,
  t0.active AS active_4
FROM
  stay_duration t0
  INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id
WHERE
  stay_duration_room.room_id = ?

SELECT t0.id AS id_1, t0.minimum_nights AS minimum_nights_2, t0.maximum_nights AS maximum_nights_3, t0.active AS active_4 FROM stay_duration t0 INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id WHERE stay_duration_room.room_id = 0x27667FBFBE82463BB78FEB588AD85857;

#	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 2737)
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	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1049)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
10	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 170)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
17	App\Controller\Api\RoomController->__invoke (line 36)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

2.73 ms
(9.41%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.week_day AS week_day_3, t0.active AS active_4 FROM stay_day t0 INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id WHERE stay_day_room.room_id = ?

Parameters:

[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.week_day AS week_day_3,
  t0.active AS active_4
FROM
  stay_day t0
  INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id
WHERE
  stay_day_room.room_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.week_day AS week_day_3, t0.active AS active_4 FROM stay_day t0 INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id WHERE stay_day_room.room_id = 0x27667FBFBE82463BB78FEB588AD85857;

#	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 2737)
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	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1049)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
10	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 170)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
17	App\Controller\Api\RoomController->__invoke (line 36)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

2.16 ms
(7.46%)

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

Parameters:

[
  b"\x13BÁ"¨\x07L\x03"\eœóËm6"
]

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
  bed_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 bed_translation t0 WHERE t0.translatable_id = 0x1342C122A8074C039D221B9CF3CB6D36;

#	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 2733)
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\Bed->findTranslationByLocale (line 190)
9	App\Entity\Bed->doTranslate (line 138)
10	App\Entity\Bed->translate (line 75)
11	App\Entity\Bed->getLabel (line 81)
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 199)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Serializer->normalize (line 152)
18	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1049)
19	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
20	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
21	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
22	Symfony\Component\Serializer\Serializer->normalize (line 152)
23	Symfony\Component\Serializer\Serializer->normalize (line 170)
24	Symfony\Component\Serializer\Serializer->serialize (line 131)
25	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
27	App\Controller\Api\RoomController->__invoke (line 36)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

2.04 ms
(7.04%)

SELECT t0.id AS id_1, t0.active AS active_2 FROM bed t0 WHERE t0.id = ?

Parameters:

[
  b"\x13BÁ"¨\x07L\x03"\eœóËm6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active AS active_2
FROM
  bed t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.active AS active_2 FROM bed t0 WHERE t0.id = 0x1342C122A8074C039D221B9CF3CB6D36;

#	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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Bed::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Bed->__get (line 153)
7	App\Entity\Bed->getCurrentLocale (line 107)
8	App\Entity\Bed->doTranslate (line 135)
9	App\Entity\Bed->translate (line 75)
10	App\Entity\Bed->getLabel (line 81)
11	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
12	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
13	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 118)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Serializer->normalize (line 152)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1049)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
21	Symfony\Component\Serializer\Serializer->normalize (line 152)
22	Symfony\Component\Serializer\Serializer->normalize (line 170)
23	Symfony\Component\Serializer\Serializer->serialize (line 131)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
26	App\Controller\Api\RoomController->__invoke (line 36)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

1.34 ms
(4.62%)

SELECT t0.id AS id_1, t0.size AS size_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.disabled_at AS disabled_at_5, t0.active AS active_6, t0.bed_id AS bed_id_7, t0.tax_rule_id AS tax_rule_id_8 FROM room t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.disabled_at AS disabled_at_5,
  t0.active AS active_6,
  t0.bed_id AS bed_id_7,
  t0.tax_rule_id AS tax_rule_id_8
FROM
  room t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.size AS size_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.disabled_at AS disabled_at_5, t0.active AS active_6, t0.bed_id AS bed_id_7, t0.tax_rule_id AS tax_rule_id_8 FROM room t0 WHERE t0.active = 1;

#	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\Controller\Api\RoomController->__invoke (line 27)
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\RoomGallery	14
App\Entity\EquipmentTranslation	10
App\Entity\RoomTranslation	6
App\Entity\Equipment	5
App\Entity\BedTranslation	4
App\Entity\Room	3
App\Entity\Bed	2
App\Entity\Availability	2
App\Entity\TaxRule	1

Entities Mapping

Class	Mapping errors
App\Entity\Room	No errors.
App\Entity\Bed	No errors.
App\Entity\TaxRule	No errors.
App\Entity\Equipment	No errors.
App\Entity\RoomGallery	No errors.
App\Entity\Availability	No errors.
App\Entity\StayDuration	No errors.
App\Entity\StayDay	No errors.
App\Entity\Booking	No errors.
App\Entity\Pricing	No errors.
App\Entity\RoomTranslation	No errors.
App\Entity\BedTranslation	No errors.
App\Entity\EquipmentTranslation	No errors.

Symfony Profiler

GET https://api-ongi.nathandierickx.com/fr/rooms

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping