Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

6.41 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.23 ms
(34.78%)

SELECT DISTINCT v0_.id AS id_0, v0_.name AS name_1 FROM ville_active v0_ ORDER BY v0_.name ASC LIMIT 6 OFFSET 24

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.name AS name_1
FROM
  ville_active v0_
ORDER BY
  v0_.name ASC
LIMIT
  6 OFFSET 24

SELECT DISTINCT v0_.id AS id_0, v0_.name AS name_1 FROM ville_active v0_ ORDER BY v0_.name ASC LIMIT 6 OFFSET 24;

#	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 39)
16	App\Controller\VillesLabelliseesController->index (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)

1.54 ms
(23.95%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.presentation AS presentation_3, t0.image AS image_4, t0.image_alt AS image_alt_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.presentation_image AS presentation_image_9, t0.presentation_image_alt AS presentation_image_alt_10 FROM villes_labelisees_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.image_alt AS image_alt_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_keywords AS seo_keywords_8,
  t0.presentation_image AS presentation_image_9,
  t0.presentation_image_alt AS presentation_image_alt_10
FROM
  villes_labelisees_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.image_alt AS image_alt_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.presentation_image AS presentation_image_9, t0.presentation_image_alt AS presentation_image_alt_10 FROM villes_labelisees_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 28)
4	App\Controller\VillesLabelliseesController->index (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)

1.16 ms
(18.05%)

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM ville_active v0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT v0_.id) AS sclr_0
FROM
  ville_active v0_

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM ville_active v0_;

#	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 39)
16	App\Controller\VillesLabelliseesController->index (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.87 ms
(13.64%)

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.top_image AS top_image_2, v0_.site_link AS site_link_3, v0_.text AS text_4, v0_.coordinates AS coordinates_5, v0_.slug AS slug_6, v0_.top_image_alt AS top_image_alt_7, v0_.bottom_image AS bottom_image_8, v0_.bottom_image_alt AS bottom_image_alt_9, v0_.annee_label AS annee_label_10, v0_.departement_id AS departement_id_11, v0_.label_id AS label_id_12 FROM ville_active v0_ WHERE v0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY v0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.top_image AS top_image_2,
  v0_.site_link AS site_link_3,
  v0_.text AS text_4,
  v0_.coordinates AS coordinates_5,
  v0_.slug AS slug_6,
  v0_.top_image_alt AS top_image_alt_7,
  v0_.bottom_image AS bottom_image_8,
  v0_.bottom_image_alt AS bottom_image_alt_9,
  v0_.annee_label AS annee_label_10,
  v0_.departement_id AS departement_id_11,
  v0_.label_id AS label_id_12
FROM
  ville_active v0_
WHERE
  v0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  v0_.name ASC

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.top_image AS top_image_2, v0_.site_link AS site_link_3, v0_.text AS text_4, v0_.coordinates AS coordinates_5, v0_.slug AS slug_6, v0_.top_image_alt AS top_image_alt_7, v0_.bottom_image AS bottom_image_8, v0_.bottom_image_alt AS bottom_image_alt_9, v0_.annee_label AS annee_label_10, v0_.departement_id AS departement_id_11, v0_.label_id AS label_id_12 FROM ville_active v0_ WHERE v0_.id IN (37, 38, 39, 40, 41, 42) ORDER BY v0_.name ASC;

#	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 39)
16	App\Controller\VillesLabelliseesController->index (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.61 ms
(9.58%)

SELECT l0_.id AS id_0, l0_.slug AS slug_1, l0_.name AS name_2, l0_.image AS image_3 FROM label l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.slug AS slug_1,
  l0_.name AS name_2,
  l0_.image AS image_3
FROM
  label l0_

SELECT l0_.id AS id_0, l0_.slug AS slug_1, l0_.name AS name_2, l0_.image AS image_3 FROM label l0_;

#	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 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 183)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 209)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 473)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 440)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
24	App\Controller\VillesLabelliseesController->index (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\VillesLabeliseesPage	No errors.
App\Entity\Label	No errors.
App\Entity\VilleActive	No errors.
App\Entity\Departement	No errors.

Symfony Profiler

GET https://preprod.ville-active.com-clients.fr/villes?page=5

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping