Symfony Profiler

Query Metrics

36 Database Queries

3 Different statements

9.18 ms Query time

0 Invalid entities

42 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.74 ms
(84.32%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.position AS position_6, t0.level AS level_7, t0.need_customer_image AS need_customer_image_8, t0.is_gift_card_category AS is_gift_card_category_9, t0.media_id AS media_id_10, t0.lft AS lft_11, t0.rght AS rght_12, t0.visible AS visible_13, t0.featured AS featured_14, t0.url_path AS url_path_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.meta_robots AS meta_robots_18, t0.description_seo AS description_seo_19, t0.data AS data_20, t0.sort_method AS sort_method_21, t0.parent_id AS parent_id_22, t0.shop_id AS shop_id_23 FROM category t0 WHERE t0.parent_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.position AS position_6,
  t0.level AS level_7,
  t0.need_customer_image AS need_customer_image_8,
  t0.is_gift_card_category AS is_gift_card_category_9,
  t0.media_id AS media_id_10,
  t0.lft AS lft_11,
  t0.rght AS rght_12,
  t0.visible AS visible_13,
  t0.featured AS featured_14,
  t0.url_path AS url_path_15,
  t0.meta_title AS meta_title_16,
  t0.meta_description AS meta_description_17,
  t0.meta_robots AS meta_robots_18,
  t0.description_seo AS description_seo_19,
  t0.data AS data_20,
  t0.sort_method AS sort_method_21,
  t0.parent_id AS parent_id_22,
  t0.shop_id AS shop_id_23
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.position AS position_6, t0.level AS level_7, t0.need_customer_image AS need_customer_image_8, t0.is_gift_card_category AS is_gift_card_category_9, t0.media_id AS media_id_10, t0.lft AS lft_11, t0.rght AS rght_12, t0.visible AS visible_13, t0.featured AS featured_14, t0.url_path AS url_path_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.meta_robots AS meta_robots_18, t0.description_seo AS description_seo_19, t0.data AS data_20, t0.sort_method AS sort_method_21, t0.parent_id AS parent_id_22, t0.shop_id AS shop_id_23 FROM category t0 WHERE t0.parent_id = 39;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 793)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 198)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 138)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 825)
15	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 805)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 198)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 138)
20	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 50)
21	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
22	Symfony\Component\Serializer\Serializer->normalize (line 87)
23	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
24	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
25	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
26	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
27	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
28	Symfony\Component\Serializer\Serializer->normalize (line 131)
29	Symfony\Component\Serializer\Serializer->serialize (line 44)
30	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
31	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
32	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
33	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 14)

1.02 ms
(11.05%)

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_.media_id AS media_id_9, c0_.lft AS lft_10, c0_.rght AS rght_11, c0_.visible AS visible_12, c0_.featured AS featured_13, c0_.url_path AS url_path_14, c0_.meta_title AS meta_title_15, c0_.meta_description AS meta_description_16, c0_.meta_robots AS meta_robots_17, c0_.description_seo AS description_seo_18, c0_.data AS data_19, c0_.sort_method AS sort_method_20, c1_.id AS id_21, c1_.name AS name_22, c1_.slug AS slug_23, c1_.description AS description_24, c1_.short_description AS short_description_25, c1_.position AS position_26, c1_.level AS level_27, c1_.need_customer_image AS need_customer_image_28, c1_.is_gift_card_category AS is_gift_card_category_29, c1_.media_id AS media_id_30, c1_.lft AS lft_31, c1_.rght AS rght_32, c1_.visible AS visible_33, c1_.featured AS featured_34, c1_.url_path AS url_path_35, c1_.meta_title AS meta_title_36, c1_.meta_description AS meta_description_37, c1_.meta_robots AS meta_robots_38, c1_.description_seo AS description_seo_39, c1_.data AS data_40, c1_.sort_method AS sort_method_41, c0_.parent_id AS parent_id_42, c0_.shop_id AS shop_id_43, c1_.parent_id AS parent_id_44, c1_.shop_id AS shop_id_45 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.shop_id = ? AND c0_.visible = 1 ORDER BY c0_.position ASC, c1_.position ASC

Parameters:

[
  1
]

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_.media_id AS media_id_9,
  c0_.lft AS lft_10,
  c0_.rght AS rght_11,
  c0_.visible AS visible_12,
  c0_.featured AS featured_13,
  c0_.url_path AS url_path_14,
  c0_.meta_title AS meta_title_15,
  c0_.meta_description AS meta_description_16,
  c0_.meta_robots AS meta_robots_17,
  c0_.description_seo AS description_seo_18,
  c0_.data AS data_19,
  c0_.sort_method AS sort_method_20,
  c1_.id AS id_21,
  c1_.name AS name_22,
  c1_.slug AS slug_23,
  c1_.description AS description_24,
  c1_.short_description AS short_description_25,
  c1_.position AS position_26,
  c1_.level AS level_27,
  c1_.need_customer_image AS need_customer_image_28,
  c1_.is_gift_card_category AS is_gift_card_category_29,
  c1_.media_id AS media_id_30,
  c1_.lft AS lft_31,
  c1_.rght AS rght_32,
  c1_.visible AS visible_33,
  c1_.featured AS featured_34,
  c1_.url_path AS url_path_35,
  c1_.meta_title AS meta_title_36,
  c1_.meta_description AS meta_description_37,
  c1_.meta_robots AS meta_robots_38,
  c1_.description_seo AS description_seo_39,
  c1_.data AS data_40,
  c1_.sort_method AS sort_method_41,
  c0_.parent_id AS parent_id_42,
  c0_.shop_id AS shop_id_43,
  c1_.parent_id AS parent_id_44,
  c1_.shop_id AS shop_id_45
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
WHERE
  c0_.parent_id IS NULL
  AND c0_.shop_id = ?
  AND c0_.visible = 1
ORDER BY
  c0_.position ASC,
  c1_.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_.media_id AS media_id_9, c0_.lft AS lft_10, c0_.rght AS rght_11, c0_.visible AS visible_12, c0_.featured AS featured_13, c0_.url_path AS url_path_14, c0_.meta_title AS meta_title_15, c0_.meta_description AS meta_description_16, c0_.meta_robots AS meta_robots_17, c0_.description_seo AS description_seo_18, c0_.data AS data_19, c0_.sort_method AS sort_method_20, c1_.id AS id_21, c1_.name AS name_22, c1_.slug AS slug_23, c1_.description AS description_24, c1_.short_description AS short_description_25, c1_.position AS position_26, c1_.level AS level_27, c1_.need_customer_image AS need_customer_image_28, c1_.is_gift_card_category AS is_gift_card_category_29, c1_.media_id AS media_id_30, c1_.lft AS lft_31, c1_.rght AS rght_32, c1_.visible AS visible_33, c1_.featured AS featured_34, c1_.url_path AS url_path_35, c1_.meta_title AS meta_title_36, c1_.meta_description AS meta_description_37, c1_.meta_robots AS meta_robots_38, c1_.description_seo AS description_seo_39, c1_.data AS data_40, c1_.sort_method AS sort_method_41, c0_.parent_id AS parent_id_42, c0_.shop_id AS shop_id_43, c1_.parent_id AS parent_id_44, c1_.shop_id AS shop_id_45 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.shop_id = 1 AND c0_.visible = 1 ORDER BY c0_.position ASC, c1_.position 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 192)
7	App\Repository\CategoryRepository->findMainCategoriesWithChildren (line 27)
8	App\State\MainCategoriesWithChildrenProvider->provide (line 43)
9	ApiPlatform\State\CallableProvider->provide (line 79)
10	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
11	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
12	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
13	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
14	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
16	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
18	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
19	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
20	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
21	ApiPlatform\Symfony\Controller\MainController->__invoke (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 14)

0.43 ms
(4.63%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t5.id AS id_6, t5.text AS text_7, t5.link AS link_8, t5.text_color AS text_color_9, t5.bg_color AS bg_color_10, t5.display AS display_11, t5.start_at AS start_at_12, t5.end_at AS end_at_13, t5.shop_id AS shop_id_14 FROM shop t0 LEFT JOIN banner t5 ON t5.shop_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t5.id AS id_6,
  t5.text AS text_7,
  t5.link AS link_8,
  t5.text_color AS text_color_9,
  t5.bg_color AS bg_color_10,
  t5.display AS display_11,
  t5.start_at AS start_at_12,
  t5.end_at AS end_at_13,
  t5.shop_id AS shop_id_14
FROM
  shop t0
  LEFT JOIN banner t5 ON t5.shop_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t5.id AS id_6, t5.text AS text_7, t5.link AS link_8, t5.text_color AS text_color_9, t5.bg_color AS bg_color_10, t5.display AS display_11, t5.start_at AS start_at_12, t5.end_at AS end_at_13, t5.shop_id AS shop_id_14 FROM shop t0 LEFT JOIN banner t5 ON t5.shop_id = t0.id WHERE t0.id = 1;

#	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 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 21)
7	App\State\MainCategoriesWithChildrenProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 79)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 14)

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	40
App\Entity\Shop	1
App\Entity\Banner	1

Entities Mapping

Class	Mapping errors
App\Entity\Shop	No errors.
App\Entity\Banner	No errors.
App\Entity\EmployeProfile	No errors.
App\Entity\Product	No errors.
App\Entity\Order	No errors.
App\Entity\Invoice	No errors.
App\Entity\CustomerProfil	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://www.arcanes-labo.btov-dev.fr/api/main-categories-with-children/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping