Symfony Profiler

Query Metrics

137 Database Queries

5 Different statements

29.54 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.26 ms
(51.65%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.left_id AS left_id_4, t0.right_id AS right_id_5, t0.level AS level_6, t0.business_key AS business_key_7, t0.show_in_main_page AS show_in_main_page_8, t0.is_enabled AS is_enabled_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.media_id AS media_id_13 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.left_id ASC

Parameters:

[
  120
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.left_id AS left_id_4,
  t0.right_id AS right_id_5,
  t0.level AS level_6,
  t0.business_key AS business_key_7,
  t0.show_in_main_page AS show_in_main_page_8,
  t0.is_enabled AS is_enabled_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.parent_id AS parent_id_12,
  t0.media_id AS media_id_13
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.left_id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.left_id AS left_id_4, t0.right_id AS right_id_5, t0.level AS level_6, t0.business_key AS business_key_7, t0.show_in_main_page AS show_in_main_page_8, t0.is_enabled AS is_enabled_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.media_id AS media_id_13 FROM category t0 WHERE t0.parent_id = 120 ORDER BY t0.left_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 88)
8	App\Repository\CategoryRepository->filterDisabledParents (line 75)
9	App\Repository\CategoryRepository->buildTree (line 32)
10	App\Repository\CategoryRepository->findTree (line 19)
11	App\Service\CategoryService->getAllCategories (line 21)
12	App\Twig\AppExtension->getGlobals (line 352)
13	Twig\ExtensionSet->getGlobals (line 901)
14	Twig\Environment->getGlobals (line 384)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
23	App\Controller\SecurityUserController->register (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

13.05 ms
(44.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.description AS description_5, t0.seo_text AS seo_text_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM category_translations t0 WHERE t0.translatable_id = ?

Parameters:

[
  120
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.description AS description_5,
  t0.seo_text AS seo_text_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  category_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.description AS description_5, t0.seo_text AS seo_text_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM category_translations t0 WHERE t0.translatable_id = 120;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Category->findTranslationByLocale (line 138)
10	App\Entity\Category->doTranslate (line 75)
11	App\Entity\Category->translate (line 1882)
12	Twig\Extension\CoreExtension::getAttribute (line 139)
13	__TwigTemplate_a43439a6a51f76aa38670cdb87bdd671->doDisplay (line 388)
14	Twig\Template->yield (line 53)
15	__TwigTemplate_86878b813e8698fc65aa25e9499e99c1->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
24	App\Controller\SecurityUserController->register (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.57 ms
(1.94%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.left_id AS left_id_3, c0_.right_id AS right_id_4, c0_.level AS level_5, c0_.business_key AS business_key_6, c0_.show_in_main_page AS show_in_main_page_7, c0_.is_enabled AS is_enabled_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.parent_id AS parent_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.is_enabled = ? ORDER BY c0_.left_id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.left_id AS left_id_3,
  c0_.right_id AS right_id_4,
  c0_.level AS level_5,
  c0_.business_key AS business_key_6,
  c0_.show_in_main_page AS show_in_main_page_7,
  c0_.is_enabled AS is_enabled_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.parent_id AS parent_id_11,
  c0_.media_id AS media_id_12
FROM
  category c0_
WHERE
  c0_.is_enabled = ?
ORDER BY
  c0_.left_id ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.left_id AS left_id_3, c0_.right_id AS right_id_4, c0_.level AS level_5, c0_.business_key AS business_key_6, c0_.show_in_main_page AS show_in_main_page_7, c0_.is_enabled AS is_enabled_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.parent_id AS parent_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.is_enabled = 1 ORDER BY c0_.left_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 30)
7	App\Repository\CategoryRepository->findTree (line 19)
8	App\Service\CategoryService->getAllCategories (line 21)
9	App\Twig\AppExtension->getGlobals (line 352)
10	Twig\ExtensionSet->getGlobals (line 901)
11	Twig\Environment->getGlobals (line 384)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
20	App\Controller\SecurityUserController->register (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.41 ms
(1.39%)

SELECT t0.id AS id_1, t0.invoice_amount AS invoice_amount_2, t0.invoice_amount_net AS invoice_amount_net_3, t0.order_time AS order_time_4, t0.transaction_id AS transaction_id_5, t0.comment AS comment_6, t0.is_quick_buy AS is_quick_buy_7, t0.user_id AS user_id_8, t0.order_billing_address_id AS order_billing_address_id_9, t0.coupon_id AS coupon_id_10 FROM `order` t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.invoice_amount AS invoice_amount_2,
  t0.invoice_amount_net AS invoice_amount_net_3,
  t0.order_time AS order_time_4,
  t0.transaction_id AS transaction_id_5,
  t0.comment AS comment_6,
  t0.is_quick_buy AS is_quick_buy_7,
  t0.user_id AS user_id_8,
  t0.order_billing_address_id AS order_billing_address_id_9,
  t0.coupon_id AS coupon_id_10
FROM
  `order` t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.invoice_amount AS invoice_amount_2, t0.invoice_amount_net AS invoice_amount_net_3, t0.order_time AS order_time_4, t0.transaction_id AS transaction_id_5, t0.comment AS comment_6, t0.is_quick_buy AS is_quick_buy_7, t0.user_id AS user_id_8, t0.order_billing_address_id AS order_billing_address_id_9, t0.coupon_id AS coupon_id_10 FROM `order` t0 WHERE t0.id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 143)
4	App\Controller\CartController->countAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 318)
12	__TwigTemplate_a43439a6a51f76aa38670cdb87bdd671->doDisplay (line 388)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_86878b813e8698fc65aa25e9499e99c1->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
23	App\Controller\SecurityUserController->register (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.25 ms
(0.86%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.left_id AS left_id_3, c0_.right_id AS right_id_4, c0_.level AS level_5, c0_.business_key AS business_key_6, c0_.show_in_main_page AS show_in_main_page_7, c0_.is_enabled AS is_enabled_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.parent_id AS parent_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_enabled = ? ORDER BY c0_.left_id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.left_id AS left_id_3,
  c0_.right_id AS right_id_4,
  c0_.level AS level_5,
  c0_.business_key AS business_key_6,
  c0_.show_in_main_page AS show_in_main_page_7,
  c0_.is_enabled AS is_enabled_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.parent_id AS parent_id_11,
  c0_.media_id AS media_id_12
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.is_enabled = ?
ORDER BY
  c0_.left_id ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.left_id AS left_id_3, c0_.right_id AS right_id_4, c0_.level AS level_5, c0_.business_key AS business_key_6, c0_.show_in_main_page AS show_in_main_page_7, c0_.is_enabled AS is_enabled_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.parent_id AS parent_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_enabled = 1 ORDER BY c0_.left_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 43)
7	App\Repository\CategoryRepository->findTopLevelCategories (line 24)
8	App\Service\CategoryService->getTopLevelCategories (line 22)
9	App\Twig\AppExtension->getGlobals (line 352)
10	Twig\ExtensionSet->getGlobals (line 901)
11	Twig\Environment->getGlobals (line 384)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
20	App\Controller\SecurityUserController->register (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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.

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
Sonata\MediaBundle\Entity\BaseMedia	No errors.
App\Entity\SonataMediaMedia	No errors.
App\Entity\Product	No errors.
App\Entity\CategoryTranslation	No errors.
App\Entity\Order	The mappings App\Entity\Order#user and App\Entity\User#orders are inconsistent with each other.
App\Entity\User	The association App\Entity\User#orders refers to the owning side field App\Entity\Order#User which does not exist.
App\Entity\OrderBillingAddress	No errors.
App\Entity\Coupon	No errors.
Sonata\MediaBundle\Entity\BaseGalleryItem	No errors.
App\Entity\SonataMediaGalleryItem	No errors.
App\Entity\Brand	No errors.
App\Entity\ProductGallery	No errors.
App\Entity\ProductVariant	No errors.
App\Entity\OrderDetails	No errors.
App\Entity\ProductTranslation	No errors.

Symfony Profiler

GET https://mytepp.com/register

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping