Symfony Profiler

Query Metrics

12 Database Queries

10 Different statements

10.78 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.14 ms
(19.86%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.image AS image_4, a0_.created_at AS created_at_5, a0_.is_enabled AS is_enabled_6, a0_.seo_title AS seo_title_7, a0_.seo_description AS seo_description_8, a0_.author_id AS author_id_9, a0_.category_id AS category_id_10 FROM article a0_ WHERE a0_.is_enabled = 1 AND a0_.id IN (?, ?, ?, ?, ?) ORDER BY a0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.content AS content_3,
  a0_.image AS image_4,
  a0_.created_at AS created_at_5,
  a0_.is_enabled AS is_enabled_6,
  a0_.seo_title AS seo_title_7,
  a0_.seo_description AS seo_description_8,
  a0_.author_id AS author_id_9,
  a0_.category_id AS category_id_10
FROM
  article a0_
WHERE
  a0_.is_enabled = 1
  AND a0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.image AS image_4, a0_.created_at AS created_at_5, a0_.is_enabled AS is_enabled_6, a0_.seo_title AS seo_title_7, a0_.seo_description AS seo_description_8, a0_.author_id AS author_id_9, a0_.category_id AS category_id_10 FROM article a0_ WHERE a0_.is_enabled = 1 AND a0_.id IN (7, 5, 4, 3, 1) ORDER BY a0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerSRT7Kkv\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\ArticleController->index (line 38)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.85 ms
(17.16%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7 FROM category t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7 FROM category t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Category::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Category->__get (line 153)
7	App\Entity\Category->getTitle (line 52)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_835263ffc139c8b0a4a997c13519e0f6::block_body (line 163)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_7332fd57bf8b302789b7cf40340aa648->doDisplay (line 348)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_835263ffc139c8b0a4a997c13519e0f6->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\ArticleController->index (line 50)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.49 ms
(13.83%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.is_enabled = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.is_enabled = 1

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.is_enabled = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerSRT7Kkv\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\ArticleController->index (line 38)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.34 ms
(12.45%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.image AS image_7 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.image AS image_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.image AS image_7 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\User::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\User->__get (line 153)
7	App\Entity\User->__toString (line 212)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_835263ffc139c8b0a4a997c13519e0f6->block_body (line 157)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_7332fd57bf8b302789b7cf40340aa648->doDisplay (line 348)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_835263ffc139c8b0a4a997c13519e0f6->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\ArticleController->index (line 50)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.85 ms
(7.89%)

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM article a0_ WHERE a0_.is_enabled = 1 ORDER BY a0_.created_at DESC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.created_at AS created_at_1
FROM
  article a0_
WHERE
  a0_.is_enabled = 1
ORDER BY
  a0_.created_at DESC
LIMIT
  6

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM article a0_ WHERE a0_.is_enabled = 1 ORDER BY a0_.created_at DESC LIMIT 6;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerSRT7Kkv\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\ArticleController->index (line 38)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.74 ms
(6.90%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.pole_id AS pole_id_8 FROM activite t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.pole_id AS pole_id_8
FROM
  activite t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.pole_id AS pole_id_8 FROM activite t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\ArticleController->index (line 45)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.71 ms
(6.61%)

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_logo AS site_logo_3, t0.site_url AS site_url_4, t0.site_urlfull AS site_urlfull_5, t0.site_email AS site_email_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_telephone AS site_telephone_10, t0.site_footerdescription AS site_footerdescription_11, t0.bgimage AS bgimage_12 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_logo AS site_logo_3,
  t0.site_url AS site_url_4,
  t0.site_urlfull AS site_urlfull_5,
  t0.site_email AS site_email_6,
  t0.site_adresse AS site_adresse_7,
  t0.site_cp AS site_cp_8,
  t0.site_ville AS site_ville_9,
  t0.site_telephone AS site_telephone_10,
  t0.site_footerdescription AS site_footerdescription_11,
  t0.bgimage AS bgimage_12
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_logo AS site_logo_3, t0.site_url AS site_url_4, t0.site_urlfull AS site_urlfull_5, t0.site_email AS site_email_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_telephone AS site_telephone_10, t0.site_footerdescription AS site_footerdescription_11, t0.bgimage AS bgimage_12 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\ArticleController->index (line 44)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.61 ms
(5.62%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7 FROM pole t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7
FROM
  pole t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7 FROM pole t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\ArticleController->index (line 46)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.54 ms
(5.04%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.image AS image_4, t0.is_enabled AS is_enabled_5 FROM social t0 WHERE t0.is_enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.image AS image_4,
  t0.is_enabled AS is_enabled_5
FROM
  social t0
WHERE
  t0.is_enabled = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.image AS image_4, t0.is_enabled AS is_enabled_5 FROM social t0 WHERE t0.is_enabled = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\ArticleController->index (line 47)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.50 ms
(4.64%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.main_title AS main_title_4, t0.description AS description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7 FROM article_page t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.main_title AS main_title_4,
  t0.description AS description_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7
FROM
  article_page t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.main_title AS main_title_4, t0.description AS description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7 FROM article_page t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\ArticleController->index (line 48)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Activite	9
App\Entity\Article	5
App\Entity\Pole	4
App\Entity\Category	3
App\Entity\Social	2
App\Entity\User	1
App\Entity\Setting	1
App\Entity\ArticlePage	1

Entities Mapping

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\User	No errors.
App\Entity\Category	No errors.
App\Entity\Setting	No errors.
App\Entity\Activite	No errors.
App\Entity\Pole	No errors.
App\Entity\Social	No errors.
App\Entity\ArticlePage	No errors.

Symfony Profiler

GET https://preprod.afp-loasis.fr/articles

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping