Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.03 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.18 ms
(71.85%)

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.type_art = ? LIMIT 1

Parameters:

[
  "Entretien"
]

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.type_art = ?
LIMIT
  1

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.type_art = 'Entretien' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 147)
4	App\Controller\ArticleController->articleByType (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.55 ms
(18.26%)

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 60)
10	__TwigTemplate_b4106f4e148f5121f1c41e2234362b44->doDisplay (line 388)
11	Twig\Template->yield (line 160)
12	__TwigTemplate_446ab3f329039a9da7d6330eb1a3b001->block_body (line 432)
13	Twig\Template->yieldBlock (line 100)
14	__TwigTemplate_4d0e21a9134068d550e5879f9ad8f08b->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_b05030c9229ab1feaad5a2a16295ffda->doDisplay (line 388)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_446ab3f329039a9da7d6330eb1a3b001->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
27	App\Controller\ArticleController->articleByType (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.30 ms
(9.89%)

SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.commenter_id AS commenter_id_3 FROM comment t0 WHERE t0.article_id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.article_id AS article_id_2,
  t0.commenter_id AS commenter_id_3
FROM
  comment t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.commenter_id AS commenter_id_3 FROM comment t0 WHERE t0.article_id = 22;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 111)
10	__TwigTemplate_b4106f4e148f5121f1c41e2234362b44->doDisplay (line 388)
11	Twig\Template->yield (line 160)
12	__TwigTemplate_446ab3f329039a9da7d6330eb1a3b001->block_body (line 432)
13	Twig\Template->yieldBlock (line 100)
14	__TwigTemplate_4d0e21a9134068d550e5879f9ad8f08b->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_b05030c9229ab1feaad5a2a16295ffda->doDisplay (line 388)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_446ab3f329039a9da7d6330eb1a3b001->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
27	App\Controller\ArticleController->articleByType (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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.
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\PubInfos	No errors.
App\Entity\Portrait	No errors.
App\Entity\Commenter	No errors.

Symfony Profiler

GET https://topautosntest.sn-topauto.com/fr/article/Entretien

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping