Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

75.76 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲

Time

Info

74.57 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.role AS role_3, t0.year AS year_4, t0.logo AS logo_5, t0.image_size AS image_size_6, t0.updated_at AS updated_at_7, t0.description AS description_8, t0.created_at AS created_at_9, t0.theme_portrait AS theme_portrait_10, t0.admin_id AS admin_id_11 FROM portrait t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.role AS role_3,
  t0.year AS year_4,
  t0.logo AS logo_5,
  t0.image_size AS image_size_6,
  t0.updated_at AS updated_at_7,
  t0.description AS description_8,
  t0.created_at AS created_at_9,
  t0.theme_portrait AS theme_portrait_10,
  t0.admin_id AS admin_id_11
FROM
  portrait t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.role AS role_3, t0.year AS year_4, t0.logo AS logo_5, t0.image_size AS image_size_6, t0.updated_at AS updated_at_7, t0.description AS description_8, t0.created_at AS created_at_9, t0.theme_portrait AS theme_portrait_10, t0.admin_id AS admin_id_11 FROM portrait t0 WHERE t0.id = '2';

#	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)

0.33 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:

[
  "2"
  "en"
  "App\Entity\Portrait"
]

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 = '2' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Portrait';

#	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)

0.52 ms

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.type_compte AS type_compte_6, t1.is_verified AS is_verified_7, t1.tel AS tel_8, t1.approve AS approve_9, t1.facebook_id AS facebook_id_10, t1.is_super_admin AS is_super_admin_11, t1.facebook AS facebook_12, t1.twitter AS twitter_13, t1.instagram AS instagram_14, t1.linkedin AS linkedin_15, t1.youtube AS youtube_16, t1.whatsapp AS whatsapp_17, t1.pinterest AS pinterest_18, t1.facebook_access_token AS facebook_access_token_19, t1.twitter_id AS twitter_id_20, t1.twitter_access_token AS twitter_access_token_21, t1.google_id AS google_id_22, t1.google_access_token AS google_access_token_23, t0.photo AS photo_24, t0.image_size AS image_size_25, t0.updated_at AS updated_at_26, t1.compte FROM admin t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.type_compte AS type_compte_6,
  t1.is_verified AS is_verified_7,
  t1.tel AS tel_8,
  t1.approve AS approve_9,
  t1.facebook_id AS facebook_id_10,
  t1.is_super_admin AS is_super_admin_11,
  t1.facebook AS facebook_12,
  t1.twitter AS twitter_13,
  t1.instagram AS instagram_14,
  t1.linkedin AS linkedin_15,
  t1.youtube AS youtube_16,
  t1.whatsapp AS whatsapp_17,
  t1.pinterest AS pinterest_18,
  t1.facebook_access_token AS facebook_access_token_19,
  t1.twitter_id AS twitter_id_20,
  t1.twitter_access_token AS twitter_access_token_21,
  t1.google_id AS google_id_22,
  t1.google_access_token AS google_access_token_23,
  t0.photo AS photo_24,
  t0.image_size AS image_size_25,
  t0.updated_at AS updated_at_26,
  t1.compte
FROM
  admin t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.type_compte AS type_compte_6, t1.is_verified AS is_verified_7, t1.tel AS tel_8, t1.approve AS approve_9, t1.facebook_id AS facebook_id_10, t1.is_super_admin AS is_super_admin_11, t1.facebook AS facebook_12, t1.twitter AS twitter_13, t1.instagram AS instagram_14, t1.linkedin AS linkedin_15, t1.youtube AS youtube_16, t1.whatsapp AS whatsapp_17, t1.pinterest AS pinterest_18, t1.facebook_access_token AS facebook_access_token_19, t1.twitter_id AS twitter_id_20, t1.twitter_access_token AS twitter_access_token_21, t1.google_id AS google_id_22, t1.google_access_token AS google_access_token_23, t0.photo AS photo_24, t0.image_size AS image_size_25, t0.updated_at AS updated_at_26, t1.compte FROM admin t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 4;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Admin::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Admin->__get (line 149)
8	App\Entity\User->getEmail (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 170)
10	__TwigTemplate_e83fde5cf53b8e440d34c0f5a9406b79->block_body (line 432)
11	Twig\Template->yieldBlock (line 100)
12	__TwigTemplate_4d0e21a9134068d550e5879f9ad8f08b->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_b05030c9229ab1feaad5a2a16295ffda->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_e83fde5cf53b8e440d34c0f5a9406b79->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 83)
25	App\Controller\PortraitController->showPortrait (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.34 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:

[
  "4"
  "en"
  "App\Entity\User"
]

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 = '4' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\User';

#	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 365)
17	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
18	Proxies\__CG__\App\Entity\Admin::Doctrine\ORM\Proxy\{closure} (line 100)
19	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
20	Proxies\__CG__\App\Entity\Admin->__get (line 149)
21	App\Entity\User->getEmail (line 1882)
22	Twig\Extension\CoreExtension::getAttribute (line 170)
23	__TwigTemplate_e83fde5cf53b8e440d34c0f5a9406b79->block_body (line 432)
24	Twig\Template->yieldBlock (line 100)
25	__TwigTemplate_4d0e21a9134068d550e5879f9ad8f08b->doDisplay (line 388)
26	Twig\Template->yield (line 54)
27	__TwigTemplate_b05030c9229ab1feaad5a2a16295ffda->doDisplay (line 388)
28	Twig\Template->yield (line 54)
29	__TwigTemplate_e83fde5cf53b8e440d34c0f5a9406b79->doDisplay (line 388)
30	Twig\Template->yield (line 344)
31	Twig\Template->display (line 359)
32	Twig\Template->render (line 51)
33	Twig\TemplateWrapper->render (line 334)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 83)
38	App\Controller\PortraitController->showPortrait (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	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\Portrait	No errors.
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\Admin	The association App\Entity\Admin#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Entity\Annonce	No errors.
App\Entity\Boutique	No errors.
App\Entity\Code	No errors.
App\Entity\Avis	No errors.
App\Entity\OffreCredit	No errors.
App\Entity\JournalCredit	No errors.
App\Entity\Message	No 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\PubInfos	No errors.

Symfony Profiler

GET https://topautosntest.sn-topauto.com/en/portrait/show/2

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping