Symfony Profiler

Query Metrics

10 Database Queries

7 Different statements

7.99 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.08 ms
(26.08%)

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.53 ms
(19.17%)

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)

1.50 ms
(18.73%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.position AS position_8 FROM workshop t0 WHERE t0.id = ?

Parameters:

[
  57
]

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_name AS image_name_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.position AS position_8
FROM
  workshop 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_name AS image_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.position AS position_8 FROM workshop t0 WHERE t0.id = 57;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 244)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 322)
5	Proxies\__CG__\App\Entity\Workshop::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 99)
7	Proxies\__CG__\App\Entity\Workshop->initializeLazyObject (line 20)
8	Proxies\__CG__\App\Entity\Workshop->__load (line 79)
9	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromField (line 138)
10	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 68)
11	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 35)
12	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 28)
13	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 74)
14	__TwigTemplate_3eaf341fd0cb35e7a2a93385b6ce2f2c->doDisplay (line 402)
15	Twig\Template->yield (line 146)
16	__TwigTemplate_01f268848a9ff7ab47ed94fdf890c199->block_content (line 446)
17	Twig\Template->yieldBlock (line 223)
18	__TwigTemplate_44820d08c2d85b43d0ae384ad2f5d3f0->doDisplay (line 402)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_01f268848a9ff7ab47ed94fdf890c199->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 35)
29	App\Controller\AgendaPageController->indexByFormat (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.85 ms
(10.64%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.icone_file AS icone_file_3 FROM social_network t0 WHERE t0.id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icone_file AS icone_file_3
FROM
  social_network t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icone_file AS icone_file_3 FROM social_network t0 WHERE t0.id = 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 244)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 322)
5	Proxies\__CG__\App\Entity\SocialNetwork::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\SocialNetwork->__get (line 90)
8	App\Entity\SocialNetwork->getIconeFile (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 294)
10	__TwigTemplate_44820d08c2d85b43d0ae384ad2f5d3f0->doDisplay (line 402)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_01f268848a9ff7ab47ed94fdf890c199->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 333)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 35)
21	App\Controller\AgendaPageController->indexByFormat (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.77 ms
(9.61%)

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

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

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;

#	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)

0.68 ms
(8.49%)

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"
  51
  55
  50
  61
  56
]

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 (51, 55, 50, 61, 56) 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.58 ms
(7.28%)

SELECT t0.id AS id_1, t0.link AS link_2, t0.network_id AS network_id_3 FROM social_node t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.link AS link_2,
  t0.network_id AS network_id_3
FROM
  social_node t0

SELECT t0.id AS id_1, t0.link AS link_2, t0.network_id AS network_id_3 FROM social_node 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 27)
6	App\Twig\SocialNodeExtension->getSocialNodes (line 284)
7	__TwigTemplate_44820d08c2d85b43d0ae384ad2f5d3f0->doDisplay (line 402)
8	Twig\Template->yield (line 54)
9	__TwigTemplate_01f268848a9ff7ab47ed94fdf890c199->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 35)
18	App\Controller\AgendaPageController->indexByFormat (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Event	5
App\Entity\Format	4
App\Entity\Workshop	3
App\Entity\SocialNode	2
App\Entity\SocialNetwork	2

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.
App\Entity\SocialNode	No errors.
App\Entity\SocialNetwork	No errors.

Symfony Profiler

GET https://staging.atelierdelaspirale.be/agenda/presentiel-a-walhain

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping