Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

0.94 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.38 ms
(40.23%)

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:

[
  "32"
  "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 = '32' 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 530)
17	Doctrine\ORM\EntityManager->find (line 3125)
18	Doctrine\ORM\UnitOfWork->createEntity (line 181)
19	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 66)
20	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 272)
21	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 787)
22	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
23	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
24	Doctrine\ORM\EntityManager->find (line 196)
25	Doctrine\ORM\EntityRepository->find (line 119)
26	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
27	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
28	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
29	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
30	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.32 ms
(34.58%)

SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.nom_an AS nom_an_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.logo AS logo_6, t0.image_size AS image_size_7, t0.email AS email_8, t0.address AS address_9, t0.website AS website_10, t0.updated_at AS updated_at_11, t0.user_an_id AS user_an_id_12 FROM annuaire t0 WHERE t0.id = ?

Parameters:

[
  "9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.categorie AS categorie_2,
  t0.nom_an AS nom_an_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.logo AS logo_6,
  t0.image_size AS image_size_7,
  t0.email AS email_8,
  t0.address AS address_9,
  t0.website AS website_10,
  t0.updated_at AS updated_at_11,
  t0.user_an_id AS user_an_id_12
FROM
  annuaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.nom_an AS nom_an_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.logo AS logo_6, t0.image_size AS image_size_7, t0.email AS email_8, t0.address AS address_9, t0.website AS website_10, t0.updated_at AS updated_at_11, t0.user_an_id AS user_an_id_12 FROM annuaire t0 WHERE t0.id = '9';

#	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.24 ms
(25.19%)

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.logo AS logo_24, t0.nom_professionel AS nom_professionel_25, t0.addresse AS addresse_26, t0.marques AS marques_27, t0.website AS website_28, t0.image_size AS image_size_29, t0.updated_at AS updated_at_30, t0.description AS description_31, t1.compte FROM professionel t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  32
]

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.logo AS logo_24,
  t0.nom_professionel AS nom_professionel_25,
  t0.addresse AS addresse_26,
  t0.marques AS marques_27,
  t0.website AS website_28,
  t0.image_size AS image_size_29,
  t0.updated_at AS updated_at_30,
  t0.description AS description_31,
  t1.compte
FROM
  professionel 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.logo AS logo_24, t0.nom_professionel AS nom_professionel_25, t0.addresse AS addresse_26, t0.marques AS marques_27, t0.website AS website_28, t0.image_size AS image_size_29, t0.updated_at AS updated_at_30, t0.description AS description_31, t1.compte FROM professionel t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 32;

#	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 3125)
5	Doctrine\ORM\UnitOfWork->createEntity (line 181)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 66)
7	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 787)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
11	Doctrine\ORM\EntityManager->find (line 196)
12	Doctrine\ORM\EntityRepository->find (line 119)
13	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
14	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
16	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
17	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\Annuaire	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\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\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\Vitrine	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\Contact	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.

Symfony Profiler

GET https://topautosntest.sn-topauto.com/en/annuaires/pro/details/9/Concessionnaires

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping