Symfony Profiler

Query Metrics

389 Database Queries

3 Different statements

220.76 ms Query time

0 Invalid entities

387 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

208.40 ms
(94.40%)

386

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:

[
  "23"
  "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 = '23' 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 117)
21	__TwigTemplate_280686e739cb841a1cd3dab322692871->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 209)
28	__TwigTemplate_f3772a9cc29cd572636b157f17142e2f->doDisplay (line 402)
29	Twig\Template->yield (line 254)
30	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->block_header (line 446)
31	Twig\Template->yieldBlock (line 84)
32	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->doDisplay (line 402)
33	Twig\Template->yield (line 54)
34	__TwigTemplate_15fc303766f3fc8ac2cc2c463e47cd73->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 58)
43	App\Controller\FrontendCardOrderController->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)

10.03 ms
(4.54%)

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 117)
10	__TwigTemplate_280686e739cb841a1cd3dab322692871->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 209)
17	__TwigTemplate_f3772a9cc29cd572636b157f17142e2f->doDisplay (line 402)
18	Twig\Template->yield (line 254)
19	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->block_header (line 446)
20	Twig\Template->yieldBlock (line 84)
21	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->doDisplay (line 402)
22	Twig\Template->yield (line 54)
23	__TwigTemplate_15fc303766f3fc8ac2cc2c463e47cd73->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 58)
32	App\Controller\FrontendCardOrderController->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)

2.33 ms
(1.06%)

SELECT f0_.id AS id_0, f0_.session_id AS session_id_1, f0_.status AS status_2, f0_.customer_type AS customer_type_3, f0_.amount AS amount_4, f0_.bonus_amount AS bonus_amount_5, f0_.card_type AS card_type_6, f0_.greeting_title AS greeting_title_7, f0_.greeting_message AS greeting_message_8, f0_.first_name AS first_name_9, f0_.last_name AS last_name_10, f0_.email AS email_11, f0_.phone AS phone_12, f0_.company_name AS company_name_13, f0_.vat_number AS vat_number_14, f0_.shipping_same_as_billing AS shipping_same_as_billing_15, f0_.stripe_session_id AS stripe_session_id_16, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_17, f0_.accepted_terms AS accepted_terms_18, f0_.accepted_privacy AS accepted_privacy_19, f0_.resume_token AS resume_token_20, f0_.resume_token_sent_at AS resume_token_sent_at_21, f0_.created_at AS created_at_22, f0_.updated_at AS updated_at_23, f0_.completed_at AS completed_at_24, f0_.product_digital_id AS product_digital_id_25, f0_.product_analog_id AS product_analog_id_26, f0_.product_template_id AS product_template_id_27, f0_.billing_address_id AS billing_address_id_28, f0_.shipping_address_id AS shipping_address_id_29, f0_.shipping_option_id AS shipping_option_id_30, f0_.gift_card_id AS gift_card_id_31 FROM frontend_card_order f0_ WHERE f0_.session_id = ? AND f0_.status NOT IN (?, ?) ORDER BY f0_.created_at DESC LIMIT 1

Parameters:

[
  "58dc57b83420d9df82e72a0f0c493d9d"
  "completed"
  "abandoned"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.session_id AS session_id_1,
  f0_.status AS status_2,
  f0_.customer_type AS customer_type_3,
  f0_.amount AS amount_4,
  f0_.bonus_amount AS bonus_amount_5,
  f0_.card_type AS card_type_6,
  f0_.greeting_title AS greeting_title_7,
  f0_.greeting_message AS greeting_message_8,
  f0_.first_name AS first_name_9,
  f0_.last_name AS last_name_10,
  f0_.email AS email_11,
  f0_.phone AS phone_12,
  f0_.company_name AS company_name_13,
  f0_.vat_number AS vat_number_14,
  f0_.shipping_same_as_billing AS shipping_same_as_billing_15,
  f0_.stripe_session_id AS stripe_session_id_16,
  f0_.stripe_payment_intent_id AS stripe_payment_intent_id_17,
  f0_.accepted_terms AS accepted_terms_18,
  f0_.accepted_privacy AS accepted_privacy_19,
  f0_.resume_token AS resume_token_20,
  f0_.resume_token_sent_at AS resume_token_sent_at_21,
  f0_.created_at AS created_at_22,
  f0_.updated_at AS updated_at_23,
  f0_.completed_at AS completed_at_24,
  f0_.product_digital_id AS product_digital_id_25,
  f0_.product_analog_id AS product_analog_id_26,
  f0_.product_template_id AS product_template_id_27,
  f0_.billing_address_id AS billing_address_id_28,
  f0_.shipping_address_id AS shipping_address_id_29,
  f0_.shipping_option_id AS shipping_option_id_30,
  f0_.gift_card_id AS gift_card_id_31
FROM
  frontend_card_order f0_
WHERE
  f0_.session_id = ?
  AND f0_.status NOT IN (?, ?)
ORDER BY
  f0_.created_at DESC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.session_id AS session_id_1, f0_.status AS status_2, f0_.customer_type AS customer_type_3, f0_.amount AS amount_4, f0_.bonus_amount AS bonus_amount_5, f0_.card_type AS card_type_6, f0_.greeting_title AS greeting_title_7, f0_.greeting_message AS greeting_message_8, f0_.first_name AS first_name_9, f0_.last_name AS last_name_10, f0_.email AS email_11, f0_.phone AS phone_12, f0_.company_name AS company_name_13, f0_.vat_number AS vat_number_14, f0_.shipping_same_as_billing AS shipping_same_as_billing_15, f0_.stripe_session_id AS stripe_session_id_16, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_17, f0_.accepted_terms AS accepted_terms_18, f0_.accepted_privacy AS accepted_privacy_19, f0_.resume_token AS resume_token_20, f0_.resume_token_sent_at AS resume_token_sent_at_21, f0_.created_at AS created_at_22, f0_.updated_at AS updated_at_23, f0_.completed_at AS completed_at_24, f0_.product_digital_id AS product_digital_id_25, f0_.product_analog_id AS product_analog_id_26, f0_.product_template_id AS product_template_id_27, f0_.billing_address_id AS billing_address_id_28, f0_.shipping_address_id AS shipping_address_id_29, f0_.shipping_option_id AS shipping_option_id_30, f0_.gift_card_id AS gift_card_id_31 FROM frontend_card_order f0_ WHERE f0_.session_id = '58dc57b83420d9df82e72a0f0c493d9d' AND f0_.status NOT IN ('completed', 'abandoned') ORDER BY f0_.created_at DESC LIMIT 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 35)
7	App\Repository\FrontendCardOrderRepository->findBySessionId (line 45)
8	App\Service\FrontendCardOrderService->getOrCreateOrder (line 311)
9	App\Controller\FrontendCardOrderController->getOrder (line 47)
10	App\Controller\FrontendCardOrderController->step1 (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\CourseTopic	331
App\Entity\CourseSubCategory	47
App\Entity\CourseMainCategory	8
App\Entity\FrontendCardOrder	1

Entities Mapping

Class	Mapping errors
App\Entity\FrontendCardOrder	No errors.
App\Entity\ProductDigital	No errors.
App\Entity\ProductAnalog	No errors.
App\Entity\ProductTemplate	No errors.
App\Entity\FrontendAddress	No errors.
App\Entity\ShippingOption	No errors.
App\Entity\GiftCard	No errors.
App\Entity\CourseMainCategory	No errors.
App\Entity\CourseSubCategory	No errors.
App\Entity\CourseTopic	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.

Symfony Profiler

GET https://staging.my-waycard.com/kaufen/schritt-1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping