Symfony Profiler

Query Metrics

68 Database Queries

23 Different statements

16.67 ms Query time

2 Invalid entities

118 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.08 ms
(12.49%)

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.`condition` AS condition_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.name AS name_10, t0.position AS position_11, t0.id AS id_12 FROM orm_routes t0 INNER JOIN page_route ON t0.id = page_route.route_id WHERE page_route.page_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.`condition` AS condition_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.name AS name_10,
  t0.position AS position_11,
  t0.id AS id_12
FROM
  orm_routes t0
  INNER JOIN page_route ON t0.id = page_route.route_id
WHERE
  page_route.page_id = ?

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.`condition` AS condition_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.name AS name_10, t0.position AS position_11, t0.id AS id_12 FROM orm_routes t0 INNER JOIN page_route ON t0.id = page_route.route_id WHERE page_route.page_id = 13;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 34)
9	Vweb\PharmaNexusBundle\Modules\Page\Application\Service\PageUrlGenerator::generate (line 34)
10	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Presenter\PageViewModelFactory->createPageView (line 37)
11	Vweb\PharmaNexusBundle\Modules\Page\Application\Service\PageService->getPageViewDto (line 37)
12	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 39)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

1.99 ms
(11.96%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.page_type AS page_type_6, t0.page_config AS page_config_7, t0.parent_id AS parent_id_8, t0.hero_image_id AS hero_image_id_9 FROM page t0 WHERE t0.id = ?

Parameters:

[
  "13"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.alias AS alias_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.page_type AS page_type_6,
  t0.page_config AS page_config_7,
  t0.parent_id AS parent_id_8,
  t0.hero_image_id AS hero_image_id_9
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.page_type AS page_type_6, t0.page_config AS page_config_7, t0.parent_id AS parent_id_8, t0.hero_image_id AS hero_image_id_9 FROM page t0 WHERE t0.id = '13';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Cmf\Bundle\RoutingBundle\Doctrine\Orm\ContentRepository->findById (line 46)
7	Symfony\Cmf\Component\Routing\Enhancer\ContentRepositoryEnhancer->enhance (line 56)
8	Symfony\Cmf\Component\Routing\DynamicRouter->applyRouteEnhancers (line 40)
9	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 206)
10	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
11	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
12	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
13	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

1.65 ms
(9.93%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.root_node_id AS root_node_id_2 FROM menu m0_ WHERE m0_.name = ?

Parameters:

[
  "main"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.root_node_id AS root_node_id_2
FROM
  menu m0_
WHERE
  m0_.name = ?

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.root_node_id AS root_node_id_2 FROM menu m0_ WHERE m0_.name = 'main';

#	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	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\Repository\MenuRepository->findByName (line 28)
7	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\MenuProvider->has (line 47)
8	Knp\Menu\Provider\ChainProvider->get (line 28)
9	Knp\Menu\Twig\Helper->get (line 43)
10	Knp\Menu\Twig\Helper->castMenu (line 138)
11	Knp\Menu\Twig\Helper->render (line 71)
12	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
13	__TwigTemplate_e52c32ddcf84b4b515c8dfead08526f9->doDisplay (line 56)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
18	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
19	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
20	__TwigTemplate_b11cae4e3e02e1c768cf3b3538f71667->doDisplay (line 132)
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_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 113)
28	Twig\Template->yieldBlock (line 446)
29	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
30	Twig\Template->yield (line 402)
31	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
32	Twig\Template->yield (line 402)
33	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
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 467)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
42	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
43	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
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 32)
49	require_once (line 5)

1.47 ms
(8.80%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.alias AS alias_2, p0_.domain AS domain_3, p0_.business AS business_4, p0_.status AS status_5, p0_.name_in_logo AS name_in_logo_6, p0_.slogan AS slogan_7, p0_.introduction AS introduction_8, p0_.usp_title AS usp_title_9, p0_.usps AS usps_10, p0_.about_us AS about_us_11, p0_.contact_email AS contact_email_12, p0_.contact_phone AS contact_phone_13, p0_.contact_phone_notes AS contact_phone_notes_14, p0_.agb_code AS agb_code_15, p0_.facebook_slug AS facebook_slug_16, p0_.instagram_slug AS instagram_slug_17, p0_.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_18, p0_.terms_and_conditions AS terms_and_conditions_19, p0_.privacy_policy AS privacy_policy_20, p0_.settings AS settings_21, p0_.gtm_id AS gtm_id_22, p1_.id AS id_23, p1_.short_description_override AS short_description_override_24, p1_.medium_description_override AS medium_description_override_25, p1_.long_description_override AS long_description_override_26, p1_.extra_info AS extra_info_27, p1_.active AS active_28, p2_.id AS id_29, p2_.name AS name_30, p2_.short_description AS short_description_31, p2_.medium_description AS medium_description_32, p2_.long_description AS long_description_33, p2_.cta_label AS cta_label_34, p2_.icon AS icon_35, p2_.page_content AS page_content_36, p2_.meta_title AS meta_title_37, p2_.meta_description AS meta_description_38, p2_.status AS status_39, p2_.product_variant AS product_variant_40, p2_.engagement_method AS engagement_method_41, p2_.config AS config_42, p3_.id AS id_43, p3_.extra_info AS extra_info_44, p3_.active AS active_45, l4_.id AS id_46, l4_.type AS type_47, l4_.name AS name_48, l4_.contact_email AS contact_email_49, l4_.contact_phone AS contact_phone_50, l4_.opening_hours AS opening_hours_51, l4_.alt_opening_hours AS alt_opening_hours_52, l4_.street AS street_53, l4_.number AS number_54, l4_.number_addition AS number_addition_55, l4_.complement AS complement_56, l4_.neighborhood AS neighborhood_57, l4_.city AS city_58, l4_.province AS province_59, l4_.state AS state_60, l4_.zip AS zip_61, l4_.country AS country_62, p0_.logo_id AS logo_id_63, p0_.hero_image_id AS hero_image_id_64, p0_.introduction_image_id AS introduction_image_id_65, p0_.hkz_qr_code_id AS hkz_qr_code_id_66, p0_.main_location_id AS main_location_id_67, p0_.specialist_role_id AS specialist_role_id_68, p0_.main_menu_id AS main_menu_id_69, p0_.theme_id AS theme_id_70, p1_.portal_id AS portal_id_71, p1_.product_id AS product_id_72, p2_.image_id AS image_id_73, p2_.downloadable_form_id AS downloadable_form_id_74, p3_.portal_id AS portal_id_75, p3_.location_id AS location_id_76 FROM portal p0_ LEFT JOIN portal_product p1_ ON p0_.id = p1_.portal_id LEFT JOIN product p2_ ON p1_.product_id = p2_.id LEFT JOIN portal_location p3_ ON p0_.id = p3_.portal_id LEFT JOIN location l4_ ON p3_.location_id = l4_.id WHERE p0_.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.alias AS alias_2,
  p0_.domain AS domain_3,
  p0_.business AS business_4,
  p0_.status AS status_5,
  p0_.name_in_logo AS name_in_logo_6,
  p0_.slogan AS slogan_7,
  p0_.introduction AS introduction_8,
  p0_.usp_title AS usp_title_9,
  p0_.usps AS usps_10,
  p0_.about_us AS about_us_11,
  p0_.contact_email AS contact_email_12,
  p0_.contact_phone AS contact_phone_13,
  p0_.contact_phone_notes AS contact_phone_notes_14,
  p0_.agb_code AS agb_code_15,
  p0_.facebook_slug AS facebook_slug_16,
  p0_.instagram_slug AS instagram_slug_17,
  p0_.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_18,
  p0_.terms_and_conditions AS terms_and_conditions_19,
  p0_.privacy_policy AS privacy_policy_20,
  p0_.settings AS settings_21,
  p0_.gtm_id AS gtm_id_22,
  p1_.id AS id_23,
  p1_.short_description_override AS short_description_override_24,
  p1_.medium_description_override AS medium_description_override_25,
  p1_.long_description_override AS long_description_override_26,
  p1_.extra_info AS extra_info_27,
  p1_.active AS active_28,
  p2_.id AS id_29,
  p2_.name AS name_30,
  p2_.short_description AS short_description_31,
  p2_.medium_description AS medium_description_32,
  p2_.long_description AS long_description_33,
  p2_.cta_label AS cta_label_34,
  p2_.icon AS icon_35,
  p2_.page_content AS page_content_36,
  p2_.meta_title AS meta_title_37,
  p2_.meta_description AS meta_description_38,
  p2_.status AS status_39,
  p2_.product_variant AS product_variant_40,
  p2_.engagement_method AS engagement_method_41,
  p2_.config AS config_42,
  p3_.id AS id_43,
  p3_.extra_info AS extra_info_44,
  p3_.active AS active_45,
  l4_.id AS id_46,
  l4_.type AS type_47,
  l4_.name AS name_48,
  l4_.contact_email AS contact_email_49,
  l4_.contact_phone AS contact_phone_50,
  l4_.opening_hours AS opening_hours_51,
  l4_.alt_opening_hours AS alt_opening_hours_52,
  l4_.street AS street_53,
  l4_.number AS number_54,
  l4_.number_addition AS number_addition_55,
  l4_.complement AS complement_56,
  l4_.neighborhood AS neighborhood_57,
  l4_.city AS city_58,
  l4_.province AS province_59,
  l4_.state AS state_60,
  l4_.zip AS zip_61,
  l4_.country AS country_62,
  p0_.logo_id AS logo_id_63,
  p0_.hero_image_id AS hero_image_id_64,
  p0_.introduction_image_id AS introduction_image_id_65,
  p0_.hkz_qr_code_id AS hkz_qr_code_id_66,
  p0_.main_location_id AS main_location_id_67,
  p0_.specialist_role_id AS specialist_role_id_68,
  p0_.main_menu_id AS main_menu_id_69,
  p0_.theme_id AS theme_id_70,
  p1_.portal_id AS portal_id_71,
  p1_.product_id AS product_id_72,
  p2_.image_id AS image_id_73,
  p2_.downloadable_form_id AS downloadable_form_id_74,
  p3_.portal_id AS portal_id_75,
  p3_.location_id AS location_id_76
FROM
  portal p0_
  LEFT JOIN portal_product p1_ ON p0_.id = p1_.portal_id
  LEFT JOIN product p2_ ON p1_.product_id = p2_.id
  LEFT JOIN portal_location p3_ ON p0_.id = p3_.portal_id
  LEFT JOIN location l4_ ON p3_.location_id = l4_.id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.alias AS alias_2, p0_.domain AS domain_3, p0_.business AS business_4, p0_.status AS status_5, p0_.name_in_logo AS name_in_logo_6, p0_.slogan AS slogan_7, p0_.introduction AS introduction_8, p0_.usp_title AS usp_title_9, p0_.usps AS usps_10, p0_.about_us AS about_us_11, p0_.contact_email AS contact_email_12, p0_.contact_phone AS contact_phone_13, p0_.contact_phone_notes AS contact_phone_notes_14, p0_.agb_code AS agb_code_15, p0_.facebook_slug AS facebook_slug_16, p0_.instagram_slug AS instagram_slug_17, p0_.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_18, p0_.terms_and_conditions AS terms_and_conditions_19, p0_.privacy_policy AS privacy_policy_20, p0_.settings AS settings_21, p0_.gtm_id AS gtm_id_22, p1_.id AS id_23, p1_.short_description_override AS short_description_override_24, p1_.medium_description_override AS medium_description_override_25, p1_.long_description_override AS long_description_override_26, p1_.extra_info AS extra_info_27, p1_.active AS active_28, p2_.id AS id_29, p2_.name AS name_30, p2_.short_description AS short_description_31, p2_.medium_description AS medium_description_32, p2_.long_description AS long_description_33, p2_.cta_label AS cta_label_34, p2_.icon AS icon_35, p2_.page_content AS page_content_36, p2_.meta_title AS meta_title_37, p2_.meta_description AS meta_description_38, p2_.status AS status_39, p2_.product_variant AS product_variant_40, p2_.engagement_method AS engagement_method_41, p2_.config AS config_42, p3_.id AS id_43, p3_.extra_info AS extra_info_44, p3_.active AS active_45, l4_.id AS id_46, l4_.type AS type_47, l4_.name AS name_48, l4_.contact_email AS contact_email_49, l4_.contact_phone AS contact_phone_50, l4_.opening_hours AS opening_hours_51, l4_.alt_opening_hours AS alt_opening_hours_52, l4_.street AS street_53, l4_.number AS number_54, l4_.number_addition AS number_addition_55, l4_.complement AS complement_56, l4_.neighborhood AS neighborhood_57, l4_.city AS city_58, l4_.province AS province_59, l4_.state AS state_60, l4_.zip AS zip_61, l4_.country AS country_62, p0_.logo_id AS logo_id_63, p0_.hero_image_id AS hero_image_id_64, p0_.introduction_image_id AS introduction_image_id_65, p0_.hkz_qr_code_id AS hkz_qr_code_id_66, p0_.main_location_id AS main_location_id_67, p0_.specialist_role_id AS specialist_role_id_68, p0_.main_menu_id AS main_menu_id_69, p0_.theme_id AS theme_id_70, p1_.portal_id AS portal_id_71, p1_.product_id AS product_id_72, p2_.image_id AS image_id_73, p2_.downloadable_form_id AS downloadable_form_id_74, p3_.portal_id AS portal_id_75, p3_.location_id AS location_id_76 FROM portal p0_ LEFT JOIN portal_product p1_ ON p0_.id = p1_.portal_id LEFT JOIN product p2_ ON p1_.product_id = p2_.id LEFT JOIN portal_location p3_ ON p0_.id = p3_.portal_id LEFT JOIN location l4_ ON p3_.location_id = l4_.id WHERE p0_.id = 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	Vweb\PharmaNexusBundle\Modules\Portal\Infrastructure\Persistence\Doctrine\Repository\PortalRepository->findWithAllData (line 45)
7	Vweb\PharmaNexusBundle\Application\EventSubscriber\ContextSetter->resolvePortal (line 102)
8	Vweb\PharmaNexusBundle\Application\EventSubscriber\ContextSetter->onKernelRequest (line 54)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

1.25 ms
(7.48%)

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.initials AS initials_2, t0_.last_name AS last_name_3, t0_.professional_registration AS professional_registration_4, t1_.id AS id_5, t1_.title AS title_6, t1_.specialist AS specialist_7, m2_.id AS id_8, m2_.name AS name_9, m2_.type AS type_10, m2_.mime_type AS mime_type_11, m2_.locator AS locator_12, m2_.storage AS storage_13 FROM portal_location p3_ LEFT JOIN location l4_ ON p3_.location_id = l4_.id LEFT JOIN team_member_location_assignment t5_ ON l4_.id = t5_.location_id INNER JOIN team_member t0_ ON t5_.team_member_id = t0_.id LEFT JOIN team_role t1_ ON t0_.role_id = t1_.id LEFT JOIN media m2_ ON t0_.portrait_media_id = m2_.id WHERE p3_.portal_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.initials AS initials_2,
  t0_.last_name AS last_name_3,
  t0_.professional_registration AS professional_registration_4,
  t1_.id AS id_5,
  t1_.title AS title_6,
  t1_.specialist AS specialist_7,
  m2_.id AS id_8,
  m2_.name AS name_9,
  m2_.type AS type_10,
  m2_.mime_type AS mime_type_11,
  m2_.locator AS locator_12,
  m2_.storage AS storage_13
FROM
  portal_location p3_
  LEFT JOIN location l4_ ON p3_.location_id = l4_.id
  LEFT JOIN team_member_location_assignment t5_ ON l4_.id = t5_.location_id
  INNER JOIN team_member t0_ ON t5_.team_member_id = t0_.id
  LEFT JOIN team_role t1_ ON t0_.role_id = t1_.id
  LEFT JOIN media m2_ ON t0_.portrait_media_id = m2_.id
WHERE
  p3_.portal_id = ?

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.initials AS initials_2, t0_.last_name AS last_name_3, t0_.professional_registration AS professional_registration_4, t1_.id AS id_5, t1_.title AS title_6, t1_.specialist AS specialist_7, m2_.id AS id_8, m2_.name AS name_9, m2_.type AS type_10, m2_.mime_type AS mime_type_11, m2_.locator AS locator_12, m2_.storage AS storage_13 FROM portal_location p3_ LEFT JOIN location l4_ ON p3_.location_id = l4_.id LEFT JOIN team_member_location_assignment t5_ ON l4_.id = t5_.location_id INNER JOIN team_member t0_ ON t5_.team_member_id = t0_.id LEFT JOIN team_role t1_ ON t0_.role_id = t1_.id LEFT JOIN media m2_ ON t0_.portrait_media_id = m2_.id WHERE p3_.portal_id = 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->getResult (line 688)
6	Vweb\PharmaNexusBundle\Modules\PortalBinding\Application\Query\TeamMembersOfPortalQuery->getTeamMembersOfPortal (line 60)
7	Vweb\PharmaNexusBundle\Modules\Team\Presentation\Component\TeamComponent->getTeamViewModel (line 59)
8	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
9	iterator_to_array (line 50)
10	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
15	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->block_below (line 219)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 137)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
32	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
33	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

1.17 ms
(7.02%)

SELECT s0_.`key` AS key_0, s0_.value AS value_1 FROM settings s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.`key` AS key_0,
  s0_.value AS value_1
FROM
  settings s0_

SELECT s0_.`key` AS key_0, s0_.value AS value_1 FROM settings s0_;

#	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	Vweb\PharmaNexusBundle\Shared\Infrastructure\Repository\SettingRepository->findAllIndexed (line 22)
7	Vweb\PharmaNexusBundle\Application\Service\SettingsService->getSetting (line 55)
8	Vweb\PharmaNexusBundle\Application\Service\SettingsService->get (line 27)
9	Vweb\PharmaNexusBundle\Modules\Setup\Infrastructure\Symfony\EventSubscriber\SetupCheckSubscriber->checkSetupState (line 33)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.79 ms
(4.73%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.checksum AS checksum_3, t0.type AS type_4, t0.mime_type AS mime_type_5, t0.locator AS locator_6, t0.storage AS storage_7, t0.strategy_signature AS strategy_signature_8 FROM media t0 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.checksum AS checksum_3,
  t0.type AS type_4,
  t0.mime_type AS mime_type_5,
  t0.locator AS locator_6,
  t0.storage AS storage_7,
  t0.strategy_signature AS strategy_signature_8
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.checksum AS checksum_3, t0.type AS type_4, t0.mime_type AS mime_type_5, t0.locator AS locator_6, t0.storage AS storage_7, t0.strategy_signature AS strategy_signature_8 FROM media t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Media\Domain\Model\Media::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Media\Domain\Model\Media->__get (line 153)
7	Vweb\PharmaNexusBundle\Modules\Media\Domain\Model\Media->getStorage (line 122)
8	Vweb\PharmaNexusBundle\Modules\Media\Application\Service\StorageResolver->getStorageForMedia (line 23)
9	Vweb\PharmaNexusBundle\Modules\Media\Application\Service\MediaUrlGenerator->generateUrl (line 23)
10	Vweb\PharmaNexusBundle\Modules\Media\Infrastructure\Twig\MediaExtension->getMediaUrl (line 37)
11	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 96)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
25	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.69 ms
(4.14%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.alias AS alias_2, p0_.meta_title AS meta_title_3, p0_.meta_description AS meta_description_4, p0_.page_type AS page_type_5, p0_.page_config AS page_config_6, p0_.parent_id AS parent_id_7, p0_.hero_image_id AS hero_image_id_8 FROM page p0_ WHERE p0_.page_type = ? AND JSON_EXTRACT(p0_.page_config, '$.product') = ?

Parameters:

[
  "Vweb\PharmaNexusBundle\Modules\Page\Domain\Model\PageVariant\ProductPageVariant"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.alias AS alias_2,
  p0_.meta_title AS meta_title_3,
  p0_.meta_description AS meta_description_4,
  p0_.page_type AS page_type_5,
  p0_.page_config AS page_config_6,
  p0_.parent_id AS parent_id_7,
  p0_.hero_image_id AS hero_image_id_8
FROM
  page p0_
WHERE
  p0_.page_type = ?
  AND JSON_EXTRACT(p0_.page_config, '$.product') = ?

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.alias AS alias_2, p0_.meta_title AS meta_title_3, p0_.meta_description AS meta_description_4, p0_.page_type AS page_type_5, p0_.page_config AS page_config_6, p0_.parent_id AS parent_id_7, p0_.hero_image_id AS hero_image_id_8 FROM page p0_ WHERE p0_.page_type = 'Vweb\\PharmaNexusBundle\\Modules\\Page\\Domain\\Model\\PageVariant\\ProductPageVariant' AND JSON_EXTRACT(p0_.page_config, '$.product') = 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	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Repository\PageRepository->findPageForProduct (line 45)
7	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Twig\PageExtension->loadPageForProduct (line 112)
8	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Twig\PageExtension->isNavigable (line 57)
9	__TwigTemplate_767f795e6eba9aabd80e25b43b102720->doDisplay (line 62)
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_f778c7f7ce93099c7e0a61f899c1843b->block_aside (line 215)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 131)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
33	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
34	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

0.66 ms
(3.94%)

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.`condition` AS condition_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.name AS name_10, t0.position AS position_11, t0.id AS id_12 FROM orm_routes t0 WHERE t0.staticPrefix IN (?, ?) ORDER BY t0.position ASC

Parameters:

[
  "/over-ons"
  "/"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.`condition` AS condition_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.name AS name_10,
  t0.position AS position_11,
  t0.id AS id_12
FROM
  orm_routes t0
WHERE
  t0.staticPrefix IN (?, ?)
ORDER BY
  t0.position ASC

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.`condition` AS condition_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.name AS name_10, t0.position AS position_11, t0.id AS id_12 FROM orm_routes t0 WHERE t0.staticPrefix IN ('/over-ons', '/') ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 154)
5	Symfony\Cmf\Bundle\RoutingBundle\Doctrine\Orm\RouteProvider->getRouteCollectionForRequest (line 52)
6	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
7	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
8	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
9	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
10	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
11	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.64 ms
(3.81%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.alias AS alias_2, p0_.meta_title AS meta_title_3, p0_.meta_description AS meta_description_4, p0_.page_type AS page_type_5, p0_.page_config AS page_config_6, p0_.parent_id AS parent_id_7, p0_.hero_image_id AS hero_image_id_8 FROM page p0_ WHERE p0_.page_type = ?

Parameters:

[
  "Vweb\PharmaNexusBundle\Modules\Page\Domain\Model\PageVariant\ContactPageVariant"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.alias AS alias_2,
  p0_.meta_title AS meta_title_3,
  p0_.meta_description AS meta_description_4,
  p0_.page_type AS page_type_5,
  p0_.page_config AS page_config_6,
  p0_.parent_id AS parent_id_7,
  p0_.hero_image_id AS hero_image_id_8
FROM
  page p0_
WHERE
  p0_.page_type = ?

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.alias AS alias_2, p0_.meta_title AS meta_title_3, p0_.meta_description AS meta_description_4, p0_.page_type AS page_type_5, p0_.page_config AS page_config_6, p0_.parent_id AS parent_id_7, p0_.hero_image_id AS hero_image_id_8 FROM page p0_ WHERE p0_.page_type = 'Vweb\\PharmaNexusBundle\\Modules\\Page\\Domain\\Model\\PageVariant\\ContactPageVariant';

#	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	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Repository\PageRepository->findPagesOfPageType (line 58)
7	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Twig\PageExtension->loadPagesForType (line 127)
8	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Twig\PageExtension->isNavigable (line 61)
9	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Twig\PageExtension->renderProductPagePath (line 76)
10	__TwigTemplate_767f795e6eba9aabd80e25b43b102720->doDisplay (line 65)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
17	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_aside (line 215)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 131)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
34	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
35	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	require_once (line 5)

0.55 ms
(3.28%)

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.`condition` AS condition_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.name AS name_10, t0.position AS position_11, t0.id AS id_12 FROM orm_routes t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "vweb_pharma_nexus_home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.`condition` AS condition_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.name AS name_10,
  t0.position AS position_11,
  t0.id AS id_12
FROM
  orm_routes t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.`condition` AS condition_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.name AS name_10, t0.position AS position_11, t0.id AS id_12 FROM orm_routes t0 WHERE t0.name = 'vweb_pharma_nexus_home' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Symfony\Cmf\Bundle\RoutingBundle\Doctrine\Orm\RouteProvider->getRouteByName (line 67)
4	Vweb\PharmaNexusBundle\Routing\PharmaNexusUrlGenerator->getRouteByName (line 92)
5	Vweb\PharmaNexusBundle\Routing\PharmaNexusUrlGenerator->generate (line 79)
6	Symfony\Cmf\Component\Routing\DynamicRouter->generate (line 129)
7	Symfony\Cmf\Component\Routing\ChainRouter->generate (line 201)
8	Vweb\PharmaNexusBundle\Modules\Page\Application\Service\PageUrlGenerator->generate (line 31)
9	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Presenter\PageViewModelFactory->createPageView (line 37)
10	Vweb\PharmaNexusBundle\Modules\Page\Application\Service\PageService->getPageViewDto (line 37)
11	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 39)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.52 ms
(3.11%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.root_node_id AS root_node_id_3, t4.id AS id_5, t4.name AS name_6, t4.action AS action_7, t4.label AS label_8, t4.options AS options_9, t4.position AS position_10, t4.menu_id AS menu_id_11, t4.parent_id AS parent_id_12 FROM menu t0 LEFT JOIN menu_node t4 ON t0.root_node_id = t4.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.root_node_id AS root_node_id_3,
  t4.id AS id_5,
  t4.name AS name_6,
  t4.action AS action_7,
  t4.label AS label_8,
  t4.options AS options_9,
  t4.position AS position_10,
  t4.menu_id AS menu_id_11,
  t4.parent_id AS parent_id_12
FROM
  menu t0
  LEFT JOIN menu_node t4 ON t0.root_node_id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.root_node_id AS root_node_id_3, t4.id AS id_5, t4.name AS name_6, t4.action AS action_7, t4.label AS label_8, t4.options AS options_9, t4.position AS position_10, t4.menu_id AS menu_id_11, t4.parent_id AS parent_id_12 FROM menu t0 LEFT JOIN menu_node t4 ON t0.root_node_id = t4.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu->__get (line 153)
7	Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu->getName (line 54)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_b11cae4e3e02e1c768cf3b3538f71667::doDisplay (line 132)
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_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 113)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
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 467)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
31	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
32	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
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 32)
38	require_once (line 5)

0.50 ms
(2.99%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.alias AS alias_2, p0_.meta_title AS meta_title_3, p0_.meta_description AS meta_description_4, p0_.page_type AS page_type_5, p0_.page_config AS page_config_6, p0_.parent_id AS parent_id_7, p0_.hero_image_id AS hero_image_id_8 FROM page p0_ INNER JOIN page_closure p1_ ON (p0_.id = p1_.parent) WHERE p1_.child = ? ORDER BY p1_.depth ASC

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.alias AS alias_2,
  p0_.meta_title AS meta_title_3,
  p0_.meta_description AS meta_description_4,
  p0_.page_type AS page_type_5,
  p0_.page_config AS page_config_6,
  p0_.parent_id AS parent_id_7,
  p0_.hero_image_id AS hero_image_id_8
FROM
  page p0_
  INNER JOIN page_closure p1_ ON (p0_.id = p1_.parent)
WHERE
  p1_.child = ?
ORDER BY
  p1_.depth ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.alias AS alias_2, p0_.meta_title AS meta_title_3, p0_.meta_description AS meta_description_4, p0_.page_type AS page_type_5, p0_.page_config AS page_config_6, p0_.parent_id AS parent_id_7, p0_.hero_image_id AS hero_image_id_8 FROM page p0_ INNER JOIN page_closure p1_ ON (p0_.id = p1_.parent) WHERE p1_.child = 13 ORDER BY p1_.depth 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	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Repository\PageRepository->findPageJoinParents (line 81)
7	Vweb\PharmaNexusBundle\Modules\Page\Application\Service\PageService->getPageViewDto (line 32)
8	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 39)
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 32)
14	require_once (line 5)

0.49 ms
(2.95%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.domain AS domain_4, t0.business AS business_5, t0.status AS status_6, t0.name_in_logo AS name_in_logo_7, t0.slogan AS slogan_8, t0.introduction AS introduction_9, t0.usp_title AS usp_title_10, t0.usps AS usps_11, t0.about_us AS about_us_12, t0.contact_email AS contact_email_13, t0.contact_phone AS contact_phone_14, t0.contact_phone_notes AS contact_phone_notes_15, t0.agb_code AS agb_code_16, t0.facebook_slug AS facebook_slug_17, t0.instagram_slug AS instagram_slug_18, t0.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_19, t0.terms_and_conditions AS terms_and_conditions_20, t0.privacy_policy AS privacy_policy_21, t0.settings AS settings_22, t0.gtm_id AS gtm_id_23, t0.logo_id AS logo_id_24, t0.hero_image_id AS hero_image_id_25, t0.introduction_image_id AS introduction_image_id_26, t0.hkz_qr_code_id AS hkz_qr_code_id_27, t0.main_location_id AS main_location_id_28, t0.specialist_role_id AS specialist_role_id_29, t0.main_menu_id AS main_menu_id_30, t0.theme_id AS theme_id_31 FROM portal t0 WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "www.v3.pharmanexus.nl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.domain AS domain_4,
  t0.business AS business_5,
  t0.status AS status_6,
  t0.name_in_logo AS name_in_logo_7,
  t0.slogan AS slogan_8,
  t0.introduction AS introduction_9,
  t0.usp_title AS usp_title_10,
  t0.usps AS usps_11,
  t0.about_us AS about_us_12,
  t0.contact_email AS contact_email_13,
  t0.contact_phone AS contact_phone_14,
  t0.contact_phone_notes AS contact_phone_notes_15,
  t0.agb_code AS agb_code_16,
  t0.facebook_slug AS facebook_slug_17,
  t0.instagram_slug AS instagram_slug_18,
  t0.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_19,
  t0.terms_and_conditions AS terms_and_conditions_20,
  t0.privacy_policy AS privacy_policy_21,
  t0.settings AS settings_22,
  t0.gtm_id AS gtm_id_23,
  t0.logo_id AS logo_id_24,
  t0.hero_image_id AS hero_image_id_25,
  t0.introduction_image_id AS introduction_image_id_26,
  t0.hkz_qr_code_id AS hkz_qr_code_id_27,
  t0.main_location_id AS main_location_id_28,
  t0.specialist_role_id AS specialist_role_id_29,
  t0.main_menu_id AS main_menu_id_30,
  t0.theme_id AS theme_id_31
FROM
  portal t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.domain AS domain_4, t0.business AS business_5, t0.status AS status_6, t0.name_in_logo AS name_in_logo_7, t0.slogan AS slogan_8, t0.introduction AS introduction_9, t0.usp_title AS usp_title_10, t0.usps AS usps_11, t0.about_us AS about_us_12, t0.contact_email AS contact_email_13, t0.contact_phone AS contact_phone_14, t0.contact_phone_notes AS contact_phone_notes_15, t0.agb_code AS agb_code_16, t0.facebook_slug AS facebook_slug_17, t0.instagram_slug AS instagram_slug_18, t0.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_19, t0.terms_and_conditions AS terms_and_conditions_20, t0.privacy_policy AS privacy_policy_21, t0.settings AS settings_22, t0.gtm_id AS gtm_id_23, t0.logo_id AS logo_id_24, t0.hero_image_id AS hero_image_id_25, t0.introduction_image_id AS introduction_image_id_26, t0.hkz_qr_code_id AS hkz_qr_code_id_27, t0.main_location_id AS main_location_id_28, t0.specialist_role_id AS specialist_role_id_29, t0.main_menu_id AS main_menu_id_30, t0.theme_id AS theme_id_31 FROM portal t0 WHERE t0.domain = 'www.v3.pharmanexus.nl' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Vweb\PharmaNexusBundle\Application\EventSubscriber\ContextSetter->resolvePortal (line 84)
5	Vweb\PharmaNexusBundle\Application\EventSubscriber\ContextSetter->onKernelRequest (line 54)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.45 ms
(2.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (?) ORDER BY t0.position ASC

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.action AS action_3,
  t0.label AS label_4,
  t0.options AS options_5,
  t0.position AS position_6,
  t0.menu_id AS menu_id_7,
  t0.parent_id AS parent_id_8
FROM
  menu_node t0
WHERE
  t0.parent_id IN (?)
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (11) ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
8	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
9	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu::Doctrine\ORM\Proxy\{closure} (line 373)
10	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
11	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu->__get (line 153)
12	Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu->getName (line 54)
13	Twig\Extension\CoreExtension->getAttribute (line 1911)
14	__TwigTemplate_b11cae4e3e02e1c768cf3b3538f71667::doDisplay (line 132)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
19	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
20	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
21	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 113)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
37	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 32)
43	require_once (line 5)

0.38 ms
(2.30%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.message AS message_2, n0_.popup AS popup_3, n0_.publish_up_at AS publish_up_at_4, n0_.publish_down_at AS publish_down_at_5, n0_.updated_at AS updated_at_6 FROM notification n0_ WHERE n0_.popup = 1 AND (? BETWEEN n0_.publish_up_at AND n0_.publish_down_at) ORDER BY n0_.publish_up_at DESC

Parameters:

[
  "2026-02-05 20:10:17"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.message AS message_2,
  n0_.popup AS popup_3,
  n0_.publish_up_at AS publish_up_at_4,
  n0_.publish_down_at AS publish_down_at_5,
  n0_.updated_at AS updated_at_6
FROM
  notification n0_
WHERE
  n0_.popup = 1
  AND (
    ? BETWEEN n0_.publish_up_at
    AND n0_.publish_down_at
  )
ORDER BY
  n0_.publish_up_at DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.message AS message_2, n0_.popup AS popup_3, n0_.publish_up_at AS publish_up_at_4, n0_.publish_down_at AS publish_down_at_5, n0_.updated_at AS updated_at_6 FROM notification n0_ WHERE n0_.popup = 1 AND ('2026-02-05 20:10:17' BETWEEN n0_.publish_up_at AND n0_.publish_down_at) ORDER BY n0_.publish_up_at DESC;

#	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	Vweb\PharmaNexusBundle\Modules\Notification\Infrastructure\Repository\NotificationRepository->findActivePopupNotifications (line 35)
7	Vweb\PharmaNexusBundle\Modules\Notification\Application\Service\NotificationService->getNotificationsForPopup (line 31)
8	Vweb\PharmaNexusBundle\Modules\Notification\Presentation\Component\PopupNotifications->getNotifications (line 34)
9	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
10	iterator_to_array (line 50)
11	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
12	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_b11cae4e3e02e1c768cf3b3538f71667->doDisplay (line 80)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
21	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
22	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
23	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 113)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
38	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
39	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 5)

0.30 ms
(1.83%)

SELECT t0.id AS id_1, t0.notes AS notes_2, t0.holiday AS holiday_3, t0.exact_date AS exact_date_4, t0.open AS open_5, t0.open24_hours AS open24_hours_6, t0.disallow_closed_overwriting AS disallow_closed_overwriting_7, t0.shifts AS shifts_8, t0.location_id AS location_id_9 FROM special_opening_hours t0 WHERE t0.location_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.notes AS notes_2,
  t0.holiday AS holiday_3,
  t0.exact_date AS exact_date_4,
  t0.open AS open_5,
  t0.open24_hours AS open24_hours_6,
  t0.disallow_closed_overwriting AS disallow_closed_overwriting_7,
  t0.shifts AS shifts_8,
  t0.location_id AS location_id_9
FROM
  special_opening_hours t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.notes AS notes_2, t0.holiday AS holiday_3, t0.exact_date AS exact_date_4, t0.open AS open_5, t0.open24_hours AS open24_hours_6, t0.disallow_closed_overwriting AS disallow_closed_overwriting_7, t0.shifts AS shifts_8, t0.location_id AS location_id_9 FROM special_opening_hours t0 WHERE t0.location_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Vweb\PharmaNexusBundle\Modules\Location\Domain\Service\OpeningHoursCalculator->calculateSchedule (line 80)
8	Vweb\PharmaNexusBundle\Modules\Location\Infrastructure\Twig\LocationExtension->renderShortOpeningHoursState (line 38)
9	__TwigTemplate_b11cae4e3e02e1c768cf3b3538f71667->doDisplay (line 75)
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_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 113)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
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 467)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
31	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
32	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
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 32)
38	require_once (line 5)

0.25 ms
(1.52%)

SELECT p0_.id AS id_0, p0_.short_description_override AS short_description_override_1, p0_.medium_description_override AS medium_description_override_2, p0_.long_description_override AS long_description_override_3, p0_.extra_info AS extra_info_4, p0_.active AS active_5, p0_.portal_id AS portal_id_6, p0_.product_id AS product_id_7 FROM portal_product p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.product_variant = ? AND p0_.portal_id = ?

Parameters:

[
  "Vweb\PharmaNexusBundle\Modules\Product\Domain\Model\ProductVariant\Signup"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.short_description_override AS short_description_override_1,
  p0_.medium_description_override AS medium_description_override_2,
  p0_.long_description_override AS long_description_override_3,
  p0_.extra_info AS extra_info_4,
  p0_.active AS active_5,
  p0_.portal_id AS portal_id_6,
  p0_.product_id AS product_id_7
FROM
  portal_product p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p1_.product_variant = ?
  AND p0_.portal_id = ?

SELECT p0_.id AS id_0, p0_.short_description_override AS short_description_override_1, p0_.medium_description_override AS medium_description_override_2, p0_.long_description_override AS long_description_override_3, p0_.extra_info AS extra_info_4, p0_.active AS active_5, p0_.portal_id AS portal_id_6, p0_.product_id AS product_id_7 FROM portal_product p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.product_variant = 'Vweb\\PharmaNexusBundle\\Modules\\Product\\Domain\\Model\\ProductVariant\\Signup' AND p0_.portal_id = 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->getResult (line 688)
6	Vweb\PharmaNexusBundle\Modules\Product\Infrastructure\Persistance\Doctrine\Repository\PortalProductRepository->findByProductVariantAndPortal (line 83)
7	Vweb\PharmaNexusBundle\Common\UI\Component\Footer->getPortalProduct (line 28)
8	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 90)
9	iterator_to_array (line 50)
10	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
15	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 142)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
30	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
31	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

0.19 ms
(1.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.default_theme AS default_theme_3, t0.theme AS theme_4, t0.theme_config AS theme_config_5, t0.brand_color AS brand_color_6, t0.accent_color AS accent_color_7, t0.gray_color AS gray_color_8 FROM theme t0 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.default_theme AS default_theme_3,
  t0.theme AS theme_4,
  t0.theme_config AS theme_config_5,
  t0.brand_color AS brand_color_6,
  t0.accent_color AS accent_color_7,
  t0.gray_color AS gray_color_8
FROM
  theme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.default_theme AS default_theme_3, t0.theme AS theme_4, t0.theme_config AS theme_config_5, t0.brand_color AS brand_color_6, t0.accent_color AS accent_color_7, t0.gray_color AS gray_color_8 FROM theme t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Theme\Domain\Model\ConfiguredTheme::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Theme\Domain\Model\ConfiguredTheme->__get (line 153)
7	Vweb\PharmaNexusBundle\Modules\Theme\Domain\Model\ConfiguredTheme->getTheme (line 109)
8	Vweb\PharmaNexusBundle\Modules\Theme\Application\Service\ThemeResolver->resolveView (line 89)
9	Vweb\PharmaNexusBundle\Modules\Page\Infrastructure\Twig\TemplateResolver->resolve (line 35)
10	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 47)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.19 ms
(1.16%)

SELECT t0.settings AS settings_1, t0.configured_theme_id AS configured_theme_id_2, t0.portal_id AS portal_id_3 FROM portal_theme_config t0 WHERE t0.configured_theme_id = ? AND t0.portal_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.settings AS settings_1,
  t0.configured_theme_id AS configured_theme_id_2,
  t0.portal_id AS portal_id_3
FROM
  portal_theme_config t0
WHERE
  t0.configured_theme_id = ?
  AND t0.portal_id = ?

SELECT t0.settings AS settings_1, t0.configured_theme_id AS configured_theme_id_2, t0.portal_id AS portal_id_3 FROM portal_theme_config t0 WHERE t0.configured_theme_id = 1 AND t0.portal_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Vweb\PharmaNexusBundle\Modules\Theme\Application\Service\ThemeResolver->resolveViewAndParams (line 64)
7	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 37)
8	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
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 32)
14	require_once (line 5)

0.18 ms
(1.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.action AS action_3,
  t0.label AS label_4,
  t0.options AS options_5,
  t0.position AS position_6,
  t0.menu_id AS menu_id_7,
  t0.parent_id AS parent_id_8
FROM
  menu_node t0
WHERE
  t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (2, 3, 4, 5, 6, 7, 8, 9, 10) ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
7	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
13	Doctrine\ORM\EntityManager->find (line 366)
14	Doctrine\ORM\EntityRepository->find (line 86)
15	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
16	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\NodeLoader->processSubmenuNode (line 81)
17	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\NodeLoader->load (line 57)
18	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\NodeLoader->load (line 63)
19	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\MenuProvider->get (line 34)
20	Knp\Menu\Provider\ChainProvider->get (line 29)
21	Knp\Menu\Twig\Helper->get (line 43)
22	Knp\Menu\Twig\Helper->castMenu (line 138)
23	Knp\Menu\Twig\Helper->render (line 71)
24	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
25	__TwigTemplate_e52c32ddcf84b4b515c8dfead08526f9->doDisplay (line 56)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
30	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
31	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
32	__TwigTemplate_b11cae4e3e02e1c768cf3b3538f71667->doDisplay (line 132)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
37	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
38	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
39	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 113)
40	Twig\Template->yieldBlock (line 446)
41	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
42	Twig\Template->yield (line 402)
43	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
44	Twig\Template->yield (line 402)
45	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
46	Twig\Template->yield (line 402)
47	Twig\Template->display (line 358)
48	Twig\Template->render (line 373)
49	Twig\TemplateWrapper->render (line 51)
50	Twig\Environment->render (line 333)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
54	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
55	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
56	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
57	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
58	Symfony\Component\HttpKernel\Kernel->handle (line 193)
59	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
60	require_once (line 32)
61	require_once (line 5)

0.14 ms
(0.84%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?) ORDER BY t0.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.action AS action_3,
  t0.label AS label_4,
  t0.options AS options_5,
  t0.position AS position_6,
  t0.menu_id AS menu_id_7,
  t0.parent_id AS parent_id_8
FROM
  menu_node t0
WHERE
  t0.parent_id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (12, 20, 13, 19, 14, 18) ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
7	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
13	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
14	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu::Doctrine\ORM\Proxy\{closure} (line 373)
15	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
16	Proxies\__CG__\Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu->__get (line 153)
17	Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu->getName (line 54)
18	Twig\Extension\CoreExtension->getAttribute (line 1911)
19	__TwigTemplate_b11cae4e3e02e1c768cf3b3538f71667::doDisplay (line 132)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
24	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
25	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
26	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 113)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
31	Twig\Template->yield (line 402)
32	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
41	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
42	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
45	Symfony\Component\HttpKernel\Kernel->handle (line 193)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
47	require_once (line 32)
48	require_once (line 5)

0.13 ms
(0.79%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (?, ?) ORDER BY t0.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.action AS action_3,
  t0.label AS label_4,
  t0.options AS options_5,
  t0.position AS position_6,
  t0.menu_id AS menu_id_7,
  t0.parent_id AS parent_id_8
FROM
  menu_node t0
WHERE
  t0.parent_id IN (?, ?)
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (16, 17) ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
7	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
13	Doctrine\ORM\EntityManager->find (line 366)
14	Doctrine\ORM\EntityRepository->find (line 86)
15	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
16	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\NodeLoader->processSubmenuNode (line 81)
17	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\NodeLoader->load (line 57)
18	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\NodeLoader->load (line 63)
19	Vweb\PharmaNexusBundle\Modules\Menu\Infrastructure\KnpMenu\MenuProvider->get (line 34)
20	Knp\Menu\Provider\ChainProvider->get (line 29)
21	Knp\Menu\Twig\Helper->get (line 43)
22	Knp\Menu\Twig\Helper->castMenu (line 138)
23	Knp\Menu\Twig\Helper->render (line 71)
24	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
25	__TwigTemplate_e52c32ddcf84b4b515c8dfead08526f9->doDisplay (line 56)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
30	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
31	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
32	__TwigTemplate_b11cae4e3e02e1c768cf3b3538f71667->doDisplay (line 132)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
37	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
38	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
39	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->block_body (line 113)
40	Twig\Template->yieldBlock (line 446)
41	__TwigTemplate_1a5dcb3670cf03de2332ffb7a89f528a->doDisplay (line 132)
42	Twig\Template->yield (line 402)
43	__TwigTemplate_f778c7f7ce93099c7e0a61f899c1843b->doDisplay (line 58)
44	Twig\Template->yield (line 402)
45	__TwigTemplate_40f936441020efb1ad269afb7b2cb0ee->doDisplay (line 59)
46	Twig\Template->yield (line 402)
47	Twig\Template->display (line 358)
48	Twig\Template->render (line 373)
49	Twig\TemplateWrapper->render (line 51)
50	Twig\Environment->render (line 333)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
54	Vweb\PharmaNexusBundle\Common\AbstractController->renderTheme (line 39)
55	Vweb\PharmaNexusBundle\Modules\Page\Presentation\Controller\PageController->show (line 49)
56	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
57	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
58	Symfony\Component\HttpKernel\Kernel->handle (line 193)
59	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
60	require_once (line 32)
61	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
Symfony\Cmf\Bundle\RoutingBundle\Doctrine\Orm\Route	28
Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\MenuNode	20
Vweb\PharmaNexusBundle\Modules\Page\Domain\Model\Page	15
Vweb\PharmaNexusBundle\Modules\Location\Domain\Model\SpecialOpeningHours	12
Vweb\PharmaNexusBundle\Modules\PortalBinding\Domain\Model\PortalProduct	9
Vweb\PharmaNexusBundle\Modules\Product\Domain\Model\Product	9
Vweb\PharmaNexusBundle\Modules\Media\Domain\Model\Media	7
Vweb\PharmaNexusBundle\Modules\PortalBinding\Domain\Model\PortalLocation	5
Vweb\PharmaNexusBundle\Modules\Location\Domain\Model\Location	5
Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu	3
Vweb\PharmaNexusBundle\Shared\Domain\Model\Setting	2
Vweb\PharmaNexusBundle\Modules\Portal\Domain\Model\Portal	1
Vweb\PharmaNexusBundle\Modules\Theme\Domain\Model\ConfiguredTheme	1
Vweb\PharmaNexusBundle\Modules\Theme\Domain\Model\PortalThemeConfig	1

Entities Mapping

Class	Mapping errors
Vweb\PharmaNexusBundle\Shared\Domain\Model\Setting	No errors.
Vweb\PharmaNexusBundle\MappedSuperclass\AbstractPortal	No errors.
Vweb\PharmaNexusBundle\Modules\Portal\Domain\Model\Portal	No errors.
Vweb\PharmaNexusBundle\Modules\Media\Domain\Model\Media	No errors.
Vweb\PharmaNexusBundle\MappedSuperclass\AbstractPortalLocation	No errors.
Vweb\PharmaNexusBundle\Modules\PortalBinding\Domain\Model\PortalLocation	No errors.
Vweb\PharmaNexusBundle\Modules\Team\Domain\Model\TeamRole	No errors.
Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\Menu	No errors.
Vweb\PharmaNexusBundle\Modules\Theme\Domain\Model\ConfiguredTheme	No errors.
Vweb\PharmaNexusBundle\MappedSuperclass\AbstractPortalProduct	No errors.
Vweb\PharmaNexusBundle\Modules\PortalBinding\Domain\Model\PortalProduct	No errors.
Vweb\PharmaNexusBundle\MappedSuperclass\AbstractProduct	No errors.
Vweb\PharmaNexusBundle\Modules\Product\Domain\Model\Product	No errors.
Vweb\PharmaNexusBundle\MappedSuperclass\AbstractLocation	No errors.
Vweb\PharmaNexusBundle\Modules\Location\Domain\Model\Address	No errors.
Vweb\PharmaNexusBundle\Modules\Location\Domain\Model\Location	No errors.
Vweb\PharmaNexusBundle\Modules\Location\Domain\Model\SpecialOpeningHours	No errors.
Vweb\PharmaNexusBundle\Modules\Team\Domain\Model\TeamMemberLocationAssignment	The association Vweb\PharmaNexusBundle\Modules\Team\Domain\Model\TeamMemberLocationAssignment#teamMember refers to the inverse side field Vweb\PharmaNexusBundle\Modules\Team\Domain\Model\TeamMember#locations which does not exist.
Symfony\Component\Routing\Route	No errors.
Symfony\Cmf\Bundle\RoutingBundle\Model\Route	No errors.
Symfony\Cmf\Bundle\RoutingBundle\Doctrine\Orm\Route	No errors.
Vweb\PharmaNexusBundle\Modules\Page\Domain\Model\Page	No errors.
Vweb\PharmaNexusBundle\Modules\Page\Domain\Model\PageClosure	No errors.
Vweb\PharmaNexusBundle\Modules\Theme\Domain\Model\PortalThemeConfig	No errors.
Vweb\PharmaNexusBundle\Modules\Notification\Domain\Model\Notification	No errors.
Vweb\PharmaNexusBundle\Modules\Menu\Domain\Model\MenuNode	No errors.
Vweb\PharmaNexusBundle\MappedSuperclass\AbstractTeamMember	No errors.
Vweb\PharmaNexusBundle\Modules\Team\Domain\Model\TeamMember	The mappings Vweb\PharmaNexusBundle\Modules\Team\Domain\Model\TeamMember#assignments and Vweb\PharmaNexusBundle\Modules\Team\Domain\Model\TeamMemberLocationAssignment#teamMember are inconsistent with each other.

Symfony Profiler

GET https://www.v3.pharmanexus.nl/over-ons

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping