Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.04 ms Query time

0 Invalid entities

Time▼

Count

Info

2.43 ms
(79.91%)

SELECT id, name, parent_id FROM goods.category

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name,
  parent_id
FROM
  goods.category

SELECT id, name, parent_id FROM goods.category;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 1260)
3	App\Service\CatalogService->generateCategoryTree (line 59)
4	App\Service\CatalogService->__construct (line 44)
5	ContainerX31rIfS\getCatalogServiceService::do (line 612)
6	ContainerX31rIfS\App_KernelDevDebugContainer->load (line 403)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 60)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
11	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
12	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.61 ms
(20.09%)

SELECT id, name FROM goods.category WHERE parent_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name
FROM
  goods.category
WHERE
  parent_id IS NULL

SELECT id, name FROM goods.category WHERE parent_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1315)
3	App\Service\CatalogService->getTopCategories (line 528)
4	App\Service\CatalogService->getSectionsData (line 23)
5	App\Controller\CatalogController->indexAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.