Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.25 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.25 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.short_description AS short_description_4, c0_.position AS position_5, c0_.level AS level_6, c0_.need_customer_image AS need_customer_image_7, c0_.is_gift_card_category AS is_gift_card_category_8, c0_.parent_id AS parent_id_9 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.short_description AS short_description_4,
  c0_.position AS position_5,
  c0_.level AS level_6,
  c0_.need_customer_image AS need_customer_image_7,
  c0_.is_gift_card_category AS is_gift_card_category_8,
  c0_.parent_id AS parent_id_9
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.short_description AS short_description_4, c0_.position AS position_5, c0_.level AS level_6, c0_.need_customer_image AS need_customer_image_7, c0_.is_gift_card_category AS is_gift_card_category_8, c0_.parent_id AS parent_id_9 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\CategoryRepository->findRootCategories (line 28)
7	App\State\MainCategoriesProvider->provide (line 18)
8	ApiPlatform\State\CallableProvider->provide (line 43)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 79)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 56)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 102)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 99)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 51)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 83)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 11)

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\Category	5

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Product	No errors.

Symfony Profiler

GET https://admin.atelier-des-prompts.fr/api/main-categories

Configuration Settings

Theme

Page Width