Symfony Profiler

Query Metrics

506 Database Queries

5 Different statements

322.74 ms Query time

0 Invalid entities

696 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

297.13 ms
(92.07%)

500

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\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 105)
7	Gedmo\Translatable\TranslatableListener->postLoad (line 525)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
15	Doctrine\ORM\AbstractQuery->execute (line 886)
16	Doctrine\ORM\AbstractQuery->getResult (line 688)
17	App\Repository\CourseMainCategoryRepository->findAllActiveWithTree (line 31)
18	App\Twig\Components\FrontendSidebar->getCategories (line 18)
19	Twig\Extension\CoreExtension->getAttribute (line 1909)
20	__TwigTemplate_280686e739cb841a1cd3dab322692871::doDisplay (line 141)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_f3772a9cc29cd572636b157f17142e2f->doDisplay (line 243)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->block_header (line 259)
30	Twig\Template->yieldBlock (line 446)
31	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->doDisplay (line 84)
32	Twig\Template->yield (line 402)
33	__TwigTemplate_30f17c4e08c4b7e4013b4a40bdb134fb->doDisplay (line 57)
34	Twig\Template->yield (line 402)
35	Twig\Template->display (line 358)
36	Twig\Template->render (line 373)
37	Twig\TemplateWrapper->render (line 51)
38	Twig\Environment->render (line 333)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
42	App\Controller\FrontendCardReloadController->renderWizard (line 479)
43	App\Controller\FrontendCardReloadController->start (line 141)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Component\HttpKernel\Kernel->handle (line 193)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
48	require_once (line 29)
49	require_once (line 5)

20.80 ms
(6.44%)

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, c0_.image_id AS image_id_20, c1_.main_category_id AS main_category_id_21, c2_.sub_category_id AS sub_category_id_22 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,
  c0_.image_id AS image_id_20,
  c1_.main_category_id AS main_category_id_21,
  c2_.sub_category_id AS sub_category_id_22
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, c0_.image_id AS image_id_20, c1_.main_category_id AS main_category_id_21, c2_.sub_category_id AS sub_category_id_22 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\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CourseMainCategoryRepository->findAllActiveWithTree (line 31)
7	App\Twig\Components\FrontendSidebar->getCategories (line 18)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_280686e739cb841a1cd3dab322692871::doDisplay (line 141)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_f3772a9cc29cd572636b157f17142e2f->doDisplay (line 243)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->block_header (line 259)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_f9917cfc9cf3573866965937b55fa48c->doDisplay (line 84)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_30f17c4e08c4b7e4013b4a40bdb134fb->doDisplay (line 57)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
31	App\Controller\FrontendCardReloadController->renderWizard (line 479)
32	App\Controller\FrontendCardReloadController->start (line 141)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

2.57 ms
(0.80%)

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_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.email AS email_8, f0_.phone AS phone_9, f0_.company_name AS company_name_10, f0_.vat_number AS vat_number_11, f0_.accepted_terms AS accepted_terms_12, f0_.accepted_privacy AS accepted_privacy_13, f0_.stripe_session_id AS stripe_session_id_14, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_15, f0_.stripe_paid_at AS stripe_paid_at_16, f0_.stripe_payment_method AS stripe_payment_method_17, f0_.confirmation_mail_sent_at AS confirmation_mail_sent_at_18, f0_.locked_at AS locked_at_19, f0_.completed_at AS completed_at_20, f0_.created_at AS created_at_21, f0_.updated_at AS updated_at_22, f0_.gift_card_id AS gift_card_id_23, f0_.billing_address_id AS billing_address_id_24 FROM frontend_card_reload f0_ WHERE f0_.session_id = ? AND f0_.status NOT IN (?, ?, ?) ORDER BY f0_.created_at DESC LIMIT 1

Parameters:

[
  ""
  "completed"
  "abandoned"
  "cancelled"
]

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_.first_name AS first_name_6,
  f0_.last_name AS last_name_7,
  f0_.email AS email_8,
  f0_.phone AS phone_9,
  f0_.company_name AS company_name_10,
  f0_.vat_number AS vat_number_11,
  f0_.accepted_terms AS accepted_terms_12,
  f0_.accepted_privacy AS accepted_privacy_13,
  f0_.stripe_session_id AS stripe_session_id_14,
  f0_.stripe_payment_intent_id AS stripe_payment_intent_id_15,
  f0_.stripe_paid_at AS stripe_paid_at_16,
  f0_.stripe_payment_method AS stripe_payment_method_17,
  f0_.confirmation_mail_sent_at AS confirmation_mail_sent_at_18,
  f0_.locked_at AS locked_at_19,
  f0_.completed_at AS completed_at_20,
  f0_.created_at AS created_at_21,
  f0_.updated_at AS updated_at_22,
  f0_.gift_card_id AS gift_card_id_23,
  f0_.billing_address_id AS billing_address_id_24
FROM
  frontend_card_reload 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_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.email AS email_8, f0_.phone AS phone_9, f0_.company_name AS company_name_10, f0_.vat_number AS vat_number_11, f0_.accepted_terms AS accepted_terms_12, f0_.accepted_privacy AS accepted_privacy_13, f0_.stripe_session_id AS stripe_session_id_14, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_15, f0_.stripe_paid_at AS stripe_paid_at_16, f0_.stripe_payment_method AS stripe_payment_method_17, f0_.confirmation_mail_sent_at AS confirmation_mail_sent_at_18, f0_.locked_at AS locked_at_19, f0_.completed_at AS completed_at_20, f0_.created_at AS created_at_21, f0_.updated_at AS updated_at_22, f0_.gift_card_id AS gift_card_id_23, f0_.billing_address_id AS billing_address_id_24 FROM frontend_card_reload f0_ WHERE f0_.session_id = '' AND f0_.status NOT IN ('completed', 'abandoned', 'cancelled') ORDER BY f0_.created_at DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\FrontendCardReloadRepository->findActiveBySessionId (line 36)
7	App\Service\FrontendCardReloadService->getOrCreateReload (line 29)
8	App\Controller\FrontendCardReloadController->start (line 48)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.31 ms
(0.41%)

SELECT t0.id AS id_1, t0.min_amount AS min_amount_2, t0.bonus_percent AS bonus_percent_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM frontend_bonus_tier t0 WHERE t0.is_active = ? ORDER BY t0.min_amount ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.min_amount AS min_amount_2,
  t0.bonus_percent AS bonus_percent_3,
  t0.is_active AS is_active_4,
  t0.sort_order AS sort_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  frontend_bonus_tier t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.min_amount ASC

SELECT t0.id AS id_1, t0.min_amount AS min_amount_2, t0.bonus_percent AS bonus_percent_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM frontend_bonus_tier t0 WHERE t0.is_active = 1 ORDER BY t0.min_amount ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\FrontendCardReloadController->renderWizard (line 483)
5	App\Controller\FrontendCardReloadController->start (line 141)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.93 ms
(0.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM country t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  country t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM country t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Form\FrontendAddressType->buildForm (line 76)
6	Symfony\Component\Form\ResolvedFormType->buildForm (line 96)
7	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
8	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
9	Symfony\Component\Form\FormBuilder->create (line 80)
10	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
11	Symfony\Component\Form\FormBuilder->getForm (line 160)
12	Symfony\Component\Form\FormFactory->create (line 26)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 355)
14	App\Controller\FrontendCardReloadController->start (line 73)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	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	433
App\Entity\Country	194
App\Entity\CourseSubCategory	60
App\Entity\CourseMainCategory	7
App\Entity\FrontendCardReload	1
App\Entity\FrontendBonusTier	1

Entities Mapping

Class	Mapping errors
App\Entity\FrontendCardReload	No errors.
App\Entity\GiftCard	No errors.
App\Entity\FrontendAddress	No errors.
App\Entity\Country	No errors.
App\Entity\FrontendBonusTier	No errors.
App\Entity\CourseMainCategory	No errors.
App\Entity\CourseSubCategory	No errors.
App\Entity\CourseTopic	No errors.
App\Entity\Image	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.

Symfony Profiler

GET https://staging.my-waycard.com/aufladen

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping