Symfony Profiler

Query Metrics

442 Database Queries

5 Different statements

475.50 ms Query time

0 Invalid entities

Show all queries

Time▼

Count

Info

381.08 ms
(80.14%)

361

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?

Parameters:

  0 of 0   
[▼
  "1"
  "de"
  "App\Entity\Category"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\Category';

#	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 913)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 104)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 527)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 63)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 66)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 3980)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 54)
13	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 272)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
16	Doctrine\ORM\EntityRepository->findBy (line 207)
17	Doctrine\ORM\EntityRepository->findAll (line 184)
18	App\Controller\PagesController->policies (line 163)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

85.94 ms
(18.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = ?

Parameters:

  0 of 0   
[▼
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.parent_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 114)
8	__TwigTemplate_3fba88c191a170c56f29f9db58f28911->doDisplay (line 360)
9	Twig\Template->yield (line 196)
10	__TwigTemplate_b1de3407865558955068ce958e91d3b0->block_header (line 430)
11	Twig\Template->yieldBlock (line 132)
12	__TwigTemplate_b1de3407865558955068ce958e91d3b0->block_body (line 430)
13	Twig\Template->yieldBlock (line 78)
14	__TwigTemplate_b1de3407865558955068ce958e91d3b0->doDisplay (line 360)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_7d7e2e153f530b8cb847fd415beb9f5b->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 299)
20	Twig\Environment->render (line 242)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 216)
23	App\Controller\PagesController->policies (line 163)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

5.51 ms
(1.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category 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.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 184)
5	App\Controller\PagesController->policies (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.84 ms
(0.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.level = ?

Parameters:

  0 of 0   
[▼
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.level = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.level = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 186)
4	App\Controller\PagesController->policies (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.13 ms
(0.24%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = ? AND t0.level = ?

Parameters:

  0 of 0   
[▼
  1
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.parent_category_id = ?
  AND t0.level = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = 1 AND t0.level = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 190)
4	App\Controller\PagesController->policies (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\CategoryMatching	No errors.
App\Entity\Product	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Entity\NewsletterSubscriber	No errors.

Symfony Profiler

GET https://selectwears.com/de/mens/policies/refund

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

GET https://selectwears.com/de/mens/policies/refund

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping