Symfony Profiler

Query Metrics

154 Database Queries

2 Different statements

87.63 ms Query time

2 Invalid entities

152 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

81.18 ms
(92.63%)

152

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:

[
  "8"
  "de"
  "App\Entity\CourseMainCategory"
]

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 = '8' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseMainCategory';

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 105)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 525)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 56)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 95)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 55)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 3203)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 127)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 173)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
15	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
16	Doctrine\ORM\AbstractQuery->execute (line 689)
17	Doctrine\ORM\AbstractQuery->getResult (line 31)
18	App\Repository\CourseMainCategoryRepository->findAllActiveWithTree (line 18)
19	App\Twig\Components\FrontendSidebar->getCategories (line 1909)
20	Twig\Extension\CoreExtension::getAttribute (line 114)
21	__TwigTemplate_aac1ce770e27dc554f0998b3146b1bfe->doDisplay (line 402)
22	Twig\Template->yield (line 358)
23	Twig\Template->display (line 373)
24	Twig\Template->render (line 77)
25	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 250)
28	__TwigTemplate_f3772a9cc29cd572636b157f17142e2f->doDisplay (line 402)
29	Twig\Template->yield (line 223)
30	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->block_header (line 446)
31	Twig\Template->yieldBlock (line 80)
32	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->doDisplay (line 402)
33	Twig\Template->yield (line 54)
34	__TwigTemplate_e33497c9e0bd74c7c7404993e8e563d9->doDisplay (line 402)
35	Twig\Template->yield (line 358)
36	Twig\Template->display (line 373)
37	Twig\Template->render (line 51)
38	Twig\TemplateWrapper->render (line 333)
39	Twig\Environment->render (line 459)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 80)
43	App\Controller\FrontendCardReloadController->step1 (line 183)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
46	Symfony\Component\HttpKernel\Kernel->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 5)

6.46 ms
(7.37%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.icon AS icon_4, c0_.active AS active_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.name AS name_8, c1_.slug AS slug_9, c1_.description AS description_10, c1_.active AS active_11, c1_.sort_order AS sort_order_12, c2_.id AS id_13, c2_.name AS name_14, c2_.slug AS slug_15, c2_.description AS description_16, c2_.icon AS icon_17, c2_.active AS active_18, c2_.sort_order AS sort_order_19, c1_.main_category_id AS main_category_id_20, c2_.sub_category_id AS sub_category_id_21 FROM course_main_category c0_ LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id AND (c1_.active = ?) LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id AND (c2_.active = ?) WHERE c0_.active = ? ORDER BY c0_.sort_order ASC, c0_.name ASC, c1_.sort_order ASC, c1_.name ASC, c2_.sort_order ASC, c2_.name 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_.icon AS icon_4,
  c0_.active AS active_5,
  c0_.sort_order AS sort_order_6,
  c1_.id AS id_7,
  c1_.name AS name_8,
  c1_.slug AS slug_9,
  c1_.description AS description_10,
  c1_.active AS active_11,
  c1_.sort_order AS sort_order_12,
  c2_.id AS id_13,
  c2_.name AS name_14,
  c2_.slug AS slug_15,
  c2_.description AS description_16,
  c2_.icon AS icon_17,
  c2_.active AS active_18,
  c2_.sort_order AS sort_order_19,
  c1_.main_category_id AS main_category_id_20,
  c2_.sub_category_id AS sub_category_id_21
FROM
  course_main_category c0_
  LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id
  AND (c1_.active = ?)
  LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id
  AND (c2_.active = ?)
WHERE
  c0_.active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC,
  c1_.sort_order ASC,
  c1_.name ASC,
  c2_.sort_order ASC,
  c2_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.icon AS icon_4, c0_.active AS active_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.name AS name_8, c1_.slug AS slug_9, c1_.description AS description_10, c1_.active AS active_11, c1_.sort_order AS sort_order_12, c2_.id AS id_13, c2_.name AS name_14, c2_.slug AS slug_15, c2_.description AS description_16, c2_.icon AS icon_17, c2_.active AS active_18, c2_.sort_order AS sort_order_19, c1_.main_category_id AS main_category_id_20, c2_.sub_category_id AS sub_category_id_21 FROM course_main_category c0_ LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id AND (c1_.active = 1) LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id AND (c2_.active = 1) WHERE c0_.active = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC, c1_.sort_order ASC, c1_.name ASC, c2_.sort_order ASC, c2_.name 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 31)
7	App\Repository\CourseMainCategoryRepository->findAllActiveWithTree (line 18)
8	App\Twig\Components\FrontendSidebar->getCategories (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 114)
10	__TwigTemplate_aac1ce770e27dc554f0998b3146b1bfe->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 250)
17	__TwigTemplate_f3772a9cc29cd572636b157f17142e2f->doDisplay (line 402)
18	Twig\Template->yield (line 223)
19	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->block_header (line 446)
20	Twig\Template->yieldBlock (line 80)
21	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->doDisplay (line 402)
22	Twig\Template->yield (line 54)
23	__TwigTemplate_e33497c9e0bd74c7c7404993e8e563d9->doDisplay (line 402)
24	Twig\Template->yield (line 358)
25	Twig\Template->display (line 373)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 333)
28	Twig\Environment->render (line 459)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 80)
32	App\Controller\FrontendCardReloadController->step1 (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\CourseSubCategory	83
App\Entity\CourseTopic	57
App\Entity\CourseMainCategory	12

Entities Mapping

Class	Mapping errors
App\Entity\CourseMainCategory	The field App\Entity\CourseMainCategory#subCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CourseSubCategory#mainCategory does not contain the required 'inversedBy: "subCategories"' attribute.
App\Entity\CourseSubCategory	The field App\Entity\CourseSubCategory#topics is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CourseTopic#subCategory does not contain the required 'inversedBy: "topics"' attribute.
App\Entity\CourseTopic	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.

Symfony Profiler

GET https://dev.my-waycard.com/aufladen/schritt-1

Configuration Settings

Theme

Page Width