Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.79 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.75 ms
(62.85%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.slug AS slug_6, t0.link_label AS link_label_7, t0.subtitle AS subtitle_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM page_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  b"""
    A\n
    +9!,@ˆ´\v\x1FÛ,\x11˜
    """
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.slug AS slug_6,
  t0.link_label AS link_label_7,
  t0.subtitle AS subtitle_8,
  t0.locale AS locale_9,
  t0.translatable_id AS translatable_id_10
FROM
  page_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.slug AS slug_6, t0.link_label AS link_label_7, t0.subtitle AS subtitle_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM page_translation t0 WHERE t0.translatable_id = 0x410A2B39212C4088ADB40B1FDB2C1198;

#	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	App\Entity\Page->getSlug (line 93)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1058)
11	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
12	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 203)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 170)
16	Symfony\Component\Serializer\Serializer->serialize (line 131)
17	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
19	App\Controller\Api\PageController->__invoke (line 36)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

1.03 ms
(37.15%)

SELECT t0.id AS id_1, t0.active AS active_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.disabled_at AS disabled_at_5 FROM page t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.disabled_at AS disabled_at_5
FROM
  page t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.disabled_at AS disabled_at_5 FROM page 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\PageController->__invoke (line 25)
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\PageTranslation	2
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\PageTranslation	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width