Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.61 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.00 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.presentation AS presentation_3, t0.image AS image_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.image_alt AS image_alt_8 FROM actualites_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.presentation AS presentation_3,
  t0.image AS image_4,
  t0.seo_title AS seo_title_5,
  t0.seo_description AS seo_description_6,
  t0.seo_keywords AS seo_keywords_7,
  t0.image_alt AS image_alt_8
FROM
  actualites_page t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.presentation AS presentation_3, t0.image AS image_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.image_alt AS image_alt_8 FROM actualites_page t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 24)
4	App\Controller\ArticleController->list (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.63 ms

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerGIJofkx\PaginatorProxy9cc2a8f->paginate (line 29)
16	App\Controller\ArticleController->list (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.46 ms

SELECT DISTINCT a0_.id AS id_0, a0_.updated_at AS updated_at_1 FROM article a0_ ORDER BY a0_.updated_at DESC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.updated_at AS updated_at_1
FROM
  article a0_
ORDER BY
  a0_.updated_at DESC
LIMIT
  6

SELECT DISTINCT a0_.id AS id_0, a0_.updated_at AS updated_at_1 FROM article a0_ ORDER BY a0_.updated_at DESC LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerGIJofkx\PaginatorProxy9cc2a8f->paginate (line 29)
16	App\Controller\ArticleController->list (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.53 ms

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.image AS image_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.image_alt AS image_alt_7, a0_.seo_title AS seo_title_8, a0_.seo_description AS seo_description_9, a0_.seo_keywords AS seo_keywords_10, a0_.slug AS slug_11 FROM article a0_ WHERE a0_.id IN (?) ORDER BY a0_.updated_at DESC

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.image AS image_3,
  a0_.content AS content_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.image_alt AS image_alt_7,
  a0_.seo_title AS seo_title_8,
  a0_.seo_description AS seo_description_9,
  a0_.seo_keywords AS seo_keywords_10,
  a0_.slug AS slug_11
FROM
  article a0_
WHERE
  a0_.id IN (?)
ORDER BY
  a0_.updated_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.image AS image_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.image_alt AS image_alt_7, a0_.seo_title AS seo_title_8, a0_.seo_description AS seo_description_9, a0_.seo_keywords AS seo_keywords_10, a0_.slug AS slug_11 FROM article a0_ WHERE a0_.id IN (9) ORDER BY a0_.updated_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerGIJofkx\PaginatorProxy9cc2a8f->paginate (line 29)
16	App\Controller\ArticleController->list (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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\ActualitesPage	No errors.
App\Entity\Article	No errors.

Symfony Profiler

GET https://preprod.ville-active.com-clients.fr/actualites

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping