Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

0.85 ms Query time

0 Invalid entities

104 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.23 ms
(27.35%)

SELECT t0.id AS id_1, t0.mandatory AS mandatory_2, t0.module_id AS module_id_3, t0.product_id AS product_id_4, t0.periode_id AS periode_id_5 FROM module_product t0 WHERE t0.module_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.mandatory AS mandatory_2,
  t0.module_id AS module_id_3,
  t0.product_id AS product_id_4,
  t0.periode_id AS periode_id_5
FROM
  module_product t0
WHERE
  t0.module_id = ?

SELECT t0.id AS id_1, t0.mandatory AS mandatory_2, t0.module_id AS module_id_3, t0.product_id AS product_id_4, t0.periode_id AS periode_id_5 FROM module_product t0 WHERE t0.module_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\CollectionConfigurator->formatCollection (line 95)
8	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\CollectionConfigurator->configure (line 82)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 106)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 132)
11	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 158)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 191)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.20 ms
(23.00%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.image_name AS image_name_4, s0_.image_size AS image_size_5, s0_.image_dark_name AS image_dark_name_6, s0_.image_dark_size AS image_dark_size_7, s0_.active AS active_8, s0_.position AS position_9, s0_.roles_hide AS roles_hide_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12 FROM site s0_ WHERE s0_.active = ? ORDER BY s0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.description AS description_3,
  s0_.image_name AS image_name_4,
  s0_.image_size AS image_size_5,
  s0_.image_dark_name AS image_dark_name_6,
  s0_.image_dark_size AS image_dark_size_7,
  s0_.active AS active_8,
  s0_.position AS position_9,
  s0_.roles_hide AS roles_hide_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12
FROM
  site s0_
WHERE
  s0_.active = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.image_name AS image_name_4, s0_.image_size AS image_size_5, s0_.image_dark_name AS image_dark_name_6, s0_.image_dark_size AS image_dark_size_7, s0_.active AS active_8, s0_.position AS position_9, s0_.roles_hide AS roles_hide_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12 FROM site s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	Doctrine\DBAL\Connection->executeQuery (line 789)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\SiteRepository->findAllWithOrder (line 31)
9	App\Service\SelectedSiteContext->getAllActiveSites (line 37)
10	App\EventListener\SiteSlugListener->onKernelRequest (line 38)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

0.16 ms
(19.45%)

SELECT DISTINCT m0_.id AS id_0, m0_.image AS image_1 FROM module m0_ ORDER BY m0_.image DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.image AS image_1
FROM
  module m0_
ORDER BY
  m0_.image DESC
LIMIT
  20

SELECT DISTINCT m0_.id AS id_0, m0_.image AS image_1 FROM module m0_ ORDER BY m0_.image DESC LIMIT 20;

#	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	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 147)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.10 ms
(12.03%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.image_size AS image_size_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5 FROM module m0_ WHERE m0_.id IN (?, ?, ?) ORDER BY m0_.image DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.image AS image_2,
  m0_.image_size AS image_size_3,
  m0_.created_at AS created_at_4,
  m0_.updated_at AS updated_at_5
FROM
  module m0_
WHERE
  m0_.id IN (?, ?, ?)
ORDER BY
  m0_.image DESC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.image_size AS image_size_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5 FROM module m0_ WHERE m0_.id IN (1, 2, 3) ORDER BY m0_.image 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	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 147)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.10 ms
(11.33%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.image_name AS image_name_4, s0_.image_size AS image_size_5, s0_.image_dark_name AS image_dark_name_6, s0_.image_dark_size AS image_dark_size_7, s0_.active AS active_8, s0_.position AS position_9, s0_.roles_hide AS roles_hide_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12 FROM site s0_ ORDER BY s0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.description AS description_3,
  s0_.image_name AS image_name_4,
  s0_.image_size AS image_size_5,
  s0_.image_dark_name AS image_dark_name_6,
  s0_.image_dark_size AS image_dark_size_7,
  s0_.active AS active_8,
  s0_.position AS position_9,
  s0_.roles_hide AS roles_hide_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12
FROM
  site s0_
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.image_name AS image_name_4, s0_.image_size AS image_size_5, s0_.image_dark_name AS image_dark_name_6, s0_.image_dark_size AS image_dark_size_7, s0_.active AS active_8, s0_.position AS position_9, s0_.roles_hide AS roles_hide_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12 FROM site s0_ ORDER BY s0_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	Doctrine\DBAL\Connection->executeQuery (line 789)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\SiteRepository->findAllWithOrder (line 31)
9	App\Service\SelectedSiteContext->getAllActiveSites (line 37)
10	App\Twig\SiteContextExtension->getAllActiveSites (line 35)
11	__TwigTemplate_6c5fd5a72a5c7d1c7f85a04e52b2ee8b->doDisplay (line 76)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
18	__TwigTemplate_78cc7d051801dae7a0124a57b8fbd881->block_sidebar (line 205)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_9e6efe8e2a7b447aa57bb4aaf3fe56e2->block_wrapper (line 942)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_9e6efe8e2a7b447aa57bb4aaf3fe56e2->block_wrapper_wrapper (line 780)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_9e6efe8e2a7b447aa57bb4aaf3fe56e2->block_body (line 506)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_9e6efe8e2a7b447aa57bb4aaf3fe56e2->doDisplay (line 157)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_78cc7d051801dae7a0124a57b8fbd881->doDisplay (line 54)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_1b4ae689870f1e38c55448dbab3a6b37->doDisplay (line 81)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 49)
37	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
38	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
39	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
40	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 191)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
45	require_once (line 32)
46	require_once (line 5)

0.06 ms
(6.83%)

SELECT count(*) AS sclr_0 FROM module m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  module m0_

SELECT count(*) AS sclr_0 FROM module m0_;

#	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	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 72)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 147)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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\ModuleProduct	51
App\Entity\Product	49
App\Entity\Module	3
App\Entity\Periode	1

Entities Mapping

Class	Mapping errors
App\Entity\Site	No errors.
App\Entity\Module	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\User	No errors.
App\Entity\ModuleProduct	No errors.
App\Entity\Product	No errors.
App\Entity\Periode	No errors.

Symfony Profiler

GET https://adidas.toofoot.com/admin/module?page=1&sort%5Bimage%5D=DESC

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping