Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.27 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.02 ms
(38.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.slug AS slug_4, t0.updated_at AS updated_at_5 FROM format t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.slug AS slug_4,
  t0.updated_at AS updated_at_5
FROM
  format t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.slug AS slug_4, t0.updated_at AS updated_at_5 FROM format t0;

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

1.70 ms
(32.18%)

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = ?

Parameters:

[
  "presentiel-a-walhain"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  event e0_
  LEFT JOIN format f1_ ON e0_.format_id = f1_.id
WHERE
  f1_.slug = ?

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = 'presentiel-a-walhain';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
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 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerUk8qgcm\PaginatorProxyBa079e5->paginate (line 49)
16	App\Repository\EventRepository->paginateEventByFormat (line 36)
17	App\Controller\AgendaPageController->indexByFormat (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.82 ms
(15.61%)

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.cover_image AS cover_image_6, e0_.start_at AS start_at_7, e0_.schedule AS schedule_8, e0_.active AS active_9, e0_.soldout AS soldout_10, e0_.format_id AS format_id_11, e0_.workshop_id AS workshop_id_12 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = ? AND e0_.id IN (?, ?, ?, ?) ORDER BY e0_.start_at ASC

Parameters:

[
  "presentiel-a-walhain"
  65
  58
  67
  68
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.slug AS slug_2,
  e0_.description AS description_3,
  e0_.created_at AS created_at_4,
  e0_.updated_at AS updated_at_5,
  e0_.cover_image AS cover_image_6,
  e0_.start_at AS start_at_7,
  e0_.schedule AS schedule_8,
  e0_.active AS active_9,
  e0_.soldout AS soldout_10,
  e0_.format_id AS format_id_11,
  e0_.workshop_id AS workshop_id_12
FROM
  event e0_
  LEFT JOIN format f1_ ON e0_.format_id = f1_.id
WHERE
  f1_.slug = ?
  AND e0_.id IN (?, ?, ?, ?)
ORDER BY
  e0_.start_at ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.cover_image AS cover_image_6, e0_.start_at AS start_at_7, e0_.schedule AS schedule_8, e0_.active AS active_9, e0_.soldout AS soldout_10, e0_.format_id AS format_id_11, e0_.workshop_id AS workshop_id_12 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = 'presentiel-a-walhain' AND e0_.id IN (65, 58, 67, 68) ORDER BY e0_.start_at ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
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 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerUk8qgcm\PaginatorProxyBa079e5->paginate (line 49)
16	App\Repository\EventRepository->paginateEventByFormat (line 36)
17	App\Controller\AgendaPageController->indexByFormat (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.74 ms
(13.96%)

SELECT DISTINCT e0_.id AS id_0, e0_.start_at AS start_at_1 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = ? ORDER BY e0_.start_at ASC LIMIT 5 OFFSET 10

Parameters:

[
  "presentiel-a-walhain"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.start_at AS start_at_1
FROM
  event e0_
  LEFT JOIN format f1_ ON e0_.format_id = f1_.id
WHERE
  f1_.slug = ?
ORDER BY
  e0_.start_at ASC
LIMIT
  5
OFFSET
  10

SELECT DISTINCT e0_.id AS id_0, e0_.start_at AS start_at_1 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = 'presentiel-a-walhain' ORDER BY e0_.start_at ASC LIMIT 5 OFFSET 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
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 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerUk8qgcm\PaginatorProxyBa079e5->paginate (line 49)
16	App\Repository\EventRepository->paginateEventByFormat (line 36)
17	App\Controller\AgendaPageController->indexByFormat (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Format	4
App\Entity\Event	4
App\Entity\Workshop	3

Entities Mapping

Class	Mapping errors
App\Entity\Format	No errors.
App\Entity\Event	No errors.
App\Entity\Workshop	No errors.
App\Entity\Article	No errors.

Symfony Profiler

GET https://www.staging.atelierdelaspirale.be/agenda/presentiel-a-walhain?page=3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping