Symfony Profiler

Query Metrics

14 Database Queries

2 Different statements

15.49 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.86 ms
(83.02%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.lien AS lien_3 FROM images t0 INNER JOIN actualites_images ON t0.id = actualites_images.images_id WHERE actualites_images.actualites_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.lien AS lien_3
FROM
  images t0
  INNER JOIN actualites_images ON t0.id = actualites_images.images_id
WHERE
  actualites_images.actualites_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.lien AS lien_3 FROM images t0 INNER JOIN actualites_images ON t0.id = actualites_images.images_id WHERE actualites_images.actualites_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
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 811)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 708)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 174)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 136)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 91)
15	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 110)
16	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
17	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 92)
18	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
20	Symfony\Component\Serializer\Serializer->normalize (line 129)
21	Symfony\Component\Serializer\Serializer->serialize (line 43)
22	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
23	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
24	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

2.63 ms
(16.98%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.created_at AS created_at_3, a0_.image AS image_4 FROM actualites a0_ ORDER BY a0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.created_at AS created_at_3,
  a0_.image AS image_4
FROM
  actualites a0_
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.created_at AS created_at_3, a0_.image AS image_4 FROM actualites a0_ ORDER BY a0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 81)
7	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 76)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 87)
10	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
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 95)
14	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Actualites	No errors.
App\Entity\Images	No errors.
App\Entity\Realisation	No errors.

Symfony Profiler

GET https://api.duterque-maupetit.fr/api/actualitess

Configuration Settings

Theme