Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

31.14 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.31 ms

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.image_size AS image_size_3, t0.title AS title_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type_art AS type_art_8, t0.professionel_id AS professionel_id_9, t0.admin_id AS admin_id_10 FROM article t0 WHERE t0.id = ?

Parameters:

[
  "38"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.image_size AS image_size_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type_art AS type_art_8,
  t0.professionel_id AS professionel_id_9,
  t0.admin_id AS admin_id_10
FROM
  article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.image_size AS image_size_3, t0.title AS title_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type_art AS type_art_8, t0.professionel_id AS professionel_id_9, t0.admin_id AS admin_id_10 FROM article t0 WHERE t0.id = '38';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

30.83 ms

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?

Parameters:

[
  "38"
  "en"
  "App\Entity\Article"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '38' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Article';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 919)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 105)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 525)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 63)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 66)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 3981)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 55)
13	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 274)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 787)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
17	Doctrine\ORM\EntityManager->find (line 196)
18	Doctrine\ORM\EntityRepository->find (line 119)
19	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
20	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
21	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
22	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
23	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\Article	The association App\Entity\Article#professionel refers to the inverse side field App\Entity\Professionel#articles which does not exist.
App\Entity\User	The association App\Entity\User#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Professionel	The association App\Entity\Professionel#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist. The mappings App\Entity\Professionel#artilces and App\Entity\Article#professionel are inconsistent with each other.
App\Entity\Admin	The association App\Entity\Admin#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Comment	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.

Symfony Profiler

GET https://topautosntest.sn-topauto.com/en/actualit%C3%A9s/les-aides-a-la-conduite-38

Configuration Settings

Theme