Symfony Profiler

Query Metrics

24 Database Queries

8 Different statements

10.11 ms Query time

0 Invalid entities

51 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.70 ms
(36.56%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.eyebrow_fr AS eyebrow_fr_2, c0_.eyebrow_en AS eyebrow_en_3, c0_.page_title_fr AS page_title_fr_4, c0_.page_title_en AS page_title_en_5, c0_.quote_fr AS quote_fr_6, c0_.quote_en AS quote_en_7, c0_.intro_text_fr AS intro_text_fr_8, c0_.intro_text_en AS intro_text_en_9, c0_.country_name_fr AS country_name_fr_10, c0_.country_name_en AS country_name_en_11, c0_.seat_fr AS seat_fr_12, c0_.seat_en AS seat_en_13, c0_.creation_year AS creation_year_14, c0_.incorporation_fr AS incorporation_fr_15, c0_.incorporation_en AS incorporation_en_16, c0_.registration_number_fr AS registration_number_fr_17, c0_.registration_number_en AS registration_number_en_18, c0_.objectives_intro_fr AS objectives_intro_fr_19, c0_.objectives_intro_en AS objectives_intro_en_20, c0_.objectives_list_fr AS objectives_list_fr_21, c0_.objectives_list_en AS objectives_list_en_22, c0_.leaders_text_fr AS leaders_text_fr_23, c0_.leaders_text_en AS leaders_text_en_24, c0_.leaders_button_label_fr AS leaders_button_label_fr_25, c0_.leaders_button_label_en AS leaders_button_label_en_26, c0_.leaders_button_route_token AS leaders_button_route_token_27, c0_.schedule_text_fr AS schedule_text_fr_28, c0_.schedule_text_en AS schedule_text_en_29, c0_.schedule_button_label_fr AS schedule_button_label_fr_30, c0_.schedule_button_label_en AS schedule_button_label_en_31, c0_.schedule_button_route_token AS schedule_button_route_token_32, c0_.involvement_text_fr AS involvement_text_fr_33, c0_.involvement_text_en AS involvement_text_en_34, c0_.contact_email AS contact_email_35, c0_.contact_address_fr AS contact_address_fr_36, c0_.contact_address_en AS contact_address_en_37, c0_.cta_label_fr AS cta_label_fr_38, c0_.cta_label_en AS cta_label_en_39, c0_.cta_route_token AS cta_route_token_40, c0_.sort_order AS sort_order_41, c0_.is_active AS is_active_42, c0_.created_at AS created_at_43, c0_.updated_at AS updated_at_44, c0_.media_id AS media_id_45 FROM cms_country_profile c0_ WHERE c0_.code = ? AND c0_.is_active = ? LIMIT 1

Parameters:

[
  "canada"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.eyebrow_fr AS eyebrow_fr_2,
  c0_.eyebrow_en AS eyebrow_en_3,
  c0_.page_title_fr AS page_title_fr_4,
  c0_.page_title_en AS page_title_en_5,
  c0_.quote_fr AS quote_fr_6,
  c0_.quote_en AS quote_en_7,
  c0_.intro_text_fr AS intro_text_fr_8,
  c0_.intro_text_en AS intro_text_en_9,
  c0_.country_name_fr AS country_name_fr_10,
  c0_.country_name_en AS country_name_en_11,
  c0_.seat_fr AS seat_fr_12,
  c0_.seat_en AS seat_en_13,
  c0_.creation_year AS creation_year_14,
  c0_.incorporation_fr AS incorporation_fr_15,
  c0_.incorporation_en AS incorporation_en_16,
  c0_.registration_number_fr AS registration_number_fr_17,
  c0_.registration_number_en AS registration_number_en_18,
  c0_.objectives_intro_fr AS objectives_intro_fr_19,
  c0_.objectives_intro_en AS objectives_intro_en_20,
  c0_.objectives_list_fr AS objectives_list_fr_21,
  c0_.objectives_list_en AS objectives_list_en_22,
  c0_.leaders_text_fr AS leaders_text_fr_23,
  c0_.leaders_text_en AS leaders_text_en_24,
  c0_.leaders_button_label_fr AS leaders_button_label_fr_25,
  c0_.leaders_button_label_en AS leaders_button_label_en_26,
  c0_.leaders_button_route_token AS leaders_button_route_token_27,
  c0_.schedule_text_fr AS schedule_text_fr_28,
  c0_.schedule_text_en AS schedule_text_en_29,
  c0_.schedule_button_label_fr AS schedule_button_label_fr_30,
  c0_.schedule_button_label_en AS schedule_button_label_en_31,
  c0_.schedule_button_route_token AS schedule_button_route_token_32,
  c0_.involvement_text_fr AS involvement_text_fr_33,
  c0_.involvement_text_en AS involvement_text_en_34,
  c0_.contact_email AS contact_email_35,
  c0_.contact_address_fr AS contact_address_fr_36,
  c0_.contact_address_en AS contact_address_en_37,
  c0_.cta_label_fr AS cta_label_fr_38,
  c0_.cta_label_en AS cta_label_en_39,
  c0_.cta_route_token AS cta_route_token_40,
  c0_.sort_order AS sort_order_41,
  c0_.is_active AS is_active_42,
  c0_.created_at AS created_at_43,
  c0_.updated_at AS updated_at_44,
  c0_.media_id AS media_id_45
FROM
  cms_country_profile c0_
WHERE
  c0_.code = ?
  AND c0_.is_active = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.eyebrow_fr AS eyebrow_fr_2, c0_.eyebrow_en AS eyebrow_en_3, c0_.page_title_fr AS page_title_fr_4, c0_.page_title_en AS page_title_en_5, c0_.quote_fr AS quote_fr_6, c0_.quote_en AS quote_en_7, c0_.intro_text_fr AS intro_text_fr_8, c0_.intro_text_en AS intro_text_en_9, c0_.country_name_fr AS country_name_fr_10, c0_.country_name_en AS country_name_en_11, c0_.seat_fr AS seat_fr_12, c0_.seat_en AS seat_en_13, c0_.creation_year AS creation_year_14, c0_.incorporation_fr AS incorporation_fr_15, c0_.incorporation_en AS incorporation_en_16, c0_.registration_number_fr AS registration_number_fr_17, c0_.registration_number_en AS registration_number_en_18, c0_.objectives_intro_fr AS objectives_intro_fr_19, c0_.objectives_intro_en AS objectives_intro_en_20, c0_.objectives_list_fr AS objectives_list_fr_21, c0_.objectives_list_en AS objectives_list_en_22, c0_.leaders_text_fr AS leaders_text_fr_23, c0_.leaders_text_en AS leaders_text_en_24, c0_.leaders_button_label_fr AS leaders_button_label_fr_25, c0_.leaders_button_label_en AS leaders_button_label_en_26, c0_.leaders_button_route_token AS leaders_button_route_token_27, c0_.schedule_text_fr AS schedule_text_fr_28, c0_.schedule_text_en AS schedule_text_en_29, c0_.schedule_button_label_fr AS schedule_button_label_fr_30, c0_.schedule_button_label_en AS schedule_button_label_en_31, c0_.schedule_button_route_token AS schedule_button_route_token_32, c0_.involvement_text_fr AS involvement_text_fr_33, c0_.involvement_text_en AS involvement_text_en_34, c0_.contact_email AS contact_email_35, c0_.contact_address_fr AS contact_address_fr_36, c0_.contact_address_en AS contact_address_en_37, c0_.cta_label_fr AS cta_label_fr_38, c0_.cta_label_en AS cta_label_en_39, c0_.cta_route_token AS cta_route_token_40, c0_.sort_order AS sort_order_41, c0_.is_active AS is_active_42, c0_.created_at AS created_at_43, c0_.updated_at AS updated_at_44, c0_.media_id AS media_id_45 FROM cms_country_profile c0_ WHERE c0_.code = 'canada' AND c0_.is_active = 1 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\Cms\CountryProfileRepository->findOneActiveByCode (line 30)
7	App\Controller\Frontend\CountryController->renderCountry (line 64)
8	App\Controller\Frontend\CountryController->canada (line 28)
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)

1.15 ms
(11.35%)

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = ? AND c0_.locale = ?

Parameters:

[
  "header.top_message"
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale = ?

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'header.top_message' AND c0_.locale = 'en';

#	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\Cms\SiteSettingRepository->findOneByKeyAndLocale (line 51)
7	App\Repository\Cms\SiteSettingRepository->findValue (line 33)
8	App\Service\AppSettings->getText (line 35)
9	App\Service\AppSettings->headerTopMessage (line 44)
10	Twig\Extension\CoreExtension->getAttribute (line 1911)
11	__TwigTemplate_8b62a4081067303ddfb76e5823407164::doDisplay (line 48)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b3df8a1d81aa8d7ac34f43b4c6d8cf98->doDisplay (line 90)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_0a49ae6c0b126f6e37e2297fe05f8f8e->doDisplay (line 60)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_9e6b2452691b4eb65daf23bfd7b7a38d->doDisplay (line 53)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\Frontend\CountryController->renderCountry (line 88)
27	App\Controller\Frontend\CountryController->canada (line 28)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

1.14 ms
(11.26%)

SELECT c0_.id AS id_0, c0_.enabled AS enabled_1, c0_.sort_order AS sort_order_2, c0_.platform AS platform_3, c0_.url AS url_4, c0_.icon_class AS icon_class_5, c0_.label_fr AS label_fr_6, c0_.label_en AS label_en_7 FROM cms_social_link c0_ WHERE c0_.enabled = ? AND c0_.url <> ? ORDER BY c0_.sort_order ASC, c0_.platform ASC

Parameters:

[
  1
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.enabled AS enabled_1,
  c0_.sort_order AS sort_order_2,
  c0_.platform AS platform_3,
  c0_.url AS url_4,
  c0_.icon_class AS icon_class_5,
  c0_.label_fr AS label_fr_6,
  c0_.label_en AS label_en_7
FROM
  cms_social_link c0_
WHERE
  c0_.enabled = ?
  AND c0_.url <> ?
ORDER BY
  c0_.sort_order ASC,
  c0_.platform ASC

SELECT c0_.id AS id_0, c0_.enabled AS enabled_1, c0_.sort_order AS sort_order_2, c0_.platform AS platform_3, c0_.url AS url_4, c0_.icon_class AS icon_class_5, c0_.label_fr AS label_fr_6, c0_.label_en AS label_en_7 FROM cms_social_link c0_ WHERE c0_.enabled = 1 AND c0_.url <> '' ORDER BY c0_.sort_order ASC, c0_.platform 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\Cms\SocialLinkRepository->findEnabledOrdered (line 34)
7	App\Service\AppSettings->socialLinks (line 125)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_8b62a4081067303ddfb76e5823407164::doDisplay (line 66)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b3df8a1d81aa8d7ac34f43b4c6d8cf98->doDisplay (line 90)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_0a49ae6c0b126f6e37e2297fe05f8f8e->doDisplay (line 60)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_9e6b2452691b4eb65daf23bfd7b7a38d->doDisplay (line 53)
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	App\Controller\Frontend\CountryController->renderCountry (line 88)
25	App\Controller\Frontend\CountryController->canada (line 28)
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)

1.06 ms
(10.53%)

SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.link_type AS link_type_2, c0_.route_token AS route_token_3, c0_.external_url AS external_url_4, c0_.open_in_new_tab AS open_in_new_tab_5, c0_.sort_order AS sort_order_6, c0_.is_enabled AS is_enabled_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.menu_id AS menu_id_10, c0_.parent_id AS parent_id_11 FROM cms_navigation_item c0_ WHERE c0_.menu_id = ? AND c0_.is_enabled = true ORDER BY c0_.sort_order ASC, c0_.label ASC

Parameters:

[
  Symfony\Component\Uid\Uuid {#1367
    __toString(): "10000000-0000-0000-0000-000000000002"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.label AS label_1,
  c0_.link_type AS link_type_2,
  c0_.route_token AS route_token_3,
  c0_.external_url AS external_url_4,
  c0_.open_in_new_tab AS open_in_new_tab_5,
  c0_.sort_order AS sort_order_6,
  c0_.is_enabled AS is_enabled_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.menu_id AS menu_id_10,
  c0_.parent_id AS parent_id_11
FROM
  cms_navigation_item c0_
WHERE
  c0_.menu_id = ?
  AND c0_.is_enabled = true
ORDER BY
  c0_.sort_order ASC,
  c0_.label ASC

SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.link_type AS link_type_2, c0_.route_token AS route_token_3, c0_.external_url AS external_url_4, c0_.open_in_new_tab AS open_in_new_tab_5, c0_.sort_order AS sort_order_6, c0_.is_enabled AS is_enabled_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.menu_id AS menu_id_10, c0_.parent_id AS parent_id_11 FROM cms_navigation_item c0_ WHERE c0_.menu_id = '10000000-0000-0000-0000-000000000002' AND c0_.is_enabled = true ORDER BY c0_.sort_order ASC, c0_.label 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\Cms\NavigationItemRepository->findEnabledByMenu (line 32)
7	App\Service\Navigation\SiteNavigation->buildTree (line 73)
8	App\Service\Navigation\SiteNavigation->menu (line 56)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_8b62a4081067303ddfb76e5823407164::doDisplay (line 68)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_b3df8a1d81aa8d7ac34f43b4c6d8cf98->doDisplay (line 90)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_0a49ae6c0b126f6e37e2297fe05f8f8e->doDisplay (line 60)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_9e6b2452691b4eb65daf23bfd7b7a38d->doDisplay (line 53)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\Frontend\CountryController->renderCountry (line 88)
26	App\Controller\Frontend\CountryController->canada (line 28)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.85 ms
(8.39%)

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.locale AS locale_3, t0.slug AS slug_4, t0.title_h1 AS title_h1_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.body_html AS body_html_8, t0.needs_translation AS needs_translation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM cms_page t0 WHERE t0.route_name = ? AND t0.locale = ? LIMIT 1

Parameters:

[
  "custom_canada"
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.route_name AS route_name_2,
  t0.locale AS locale_3,
  t0.slug AS slug_4,
  t0.title_h1 AS title_h1_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.body_html AS body_html_8,
  t0.needs_translation AS needs_translation_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  cms_page t0
WHERE
  t0.route_name = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.locale AS locale_3, t0.slug AS slug_4, t0.title_h1 AS title_h1_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.body_html AS body_html_8, t0.needs_translation AS needs_translation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM cms_page t0 WHERE t0.route_name = 'custom_canada' AND t0.locale = 'en' 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	App\Repository\Cms\PageRepository->findOneByRouteNameAndLocale (line 21)
5	App\Service\CmsPageService->renderPage (line 23)
6	App\Controller\Frontend\CountryController->renderCountry (line 76)
7	App\Controller\Frontend\CountryController->canada (line 28)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.83 ms
(8.17%)

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = ? AND c0_.locale IS NULL

Parameters:

[
  "contact.email"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale IS NULL

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'contact.email' AND c0_.locale IS NULL;

#	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\Cms\SiteSettingRepository->findOneByKeyAndLocale (line 51)
7	App\Repository\Cms\SiteSettingRepository->findValue (line 33)
8	App\Service\AppSettings->getText (line 35)
9	App\Service\AppSettings->contactEmail (line 49)
10	Twig\Extension\CoreExtension->getAttribute (line 1911)
11	__TwigTemplate_8b62a4081067303ddfb76e5823407164::doDisplay (line 50)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b3df8a1d81aa8d7ac34f43b4c6d8cf98->doDisplay (line 90)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_0a49ae6c0b126f6e37e2297fe05f8f8e->doDisplay (line 60)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_9e6b2452691b4eb65daf23bfd7b7a38d->doDisplay (line 53)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\Frontend\CountryController->renderCountry (line 88)
27	App\Controller\Frontend\CountryController->canada (line 28)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.81 ms
(7.97%)

SELECT c0_.id AS id_0, c0_.location AS location_1, c0_.locale AS locale_2, c0_.title AS title_3, c0_.is_enabled AS is_enabled_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_navigation_menu c0_ WHERE c0_.location = ? AND c0_.locale = ? AND c0_.is_enabled = true LIMIT 1

Parameters:

[
  "header_main"
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.location AS location_1,
  c0_.locale AS locale_2,
  c0_.title AS title_3,
  c0_.is_enabled AS is_enabled_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_navigation_menu c0_
WHERE
  c0_.location = ?
  AND c0_.locale = ?
  AND c0_.is_enabled = true
LIMIT
  1

SELECT c0_.id AS id_0, c0_.location AS location_1, c0_.locale AS locale_2, c0_.title AS title_3, c0_.is_enabled AS is_enabled_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_navigation_menu c0_ WHERE c0_.location = 'header_main' AND c0_.locale = 'en' AND c0_.is_enabled = true 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\Cms\NavigationMenuRepository->findOneEnabledByLocationAndLocale (line 29)
7	App\Service\Navigation\SiteNavigation->menu (line 45)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_8b62a4081067303ddfb76e5823407164::doDisplay (line 68)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b3df8a1d81aa8d7ac34f43b4c6d8cf98->doDisplay (line 90)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_0a49ae6c0b126f6e37e2297fe05f8f8e->doDisplay (line 60)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_9e6b2452691b4eb65daf23bfd7b7a38d->doDisplay (line 53)
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	App\Controller\Frontend\CountryController->renderCountry (line 88)
25	App\Controller\Frontend\CountryController->canada (line 28)
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.58 ms
(5.77%)

SELECT t0.id AS id_1, t0.asset_key AS asset_key_2, t0.asset_kind AS asset_kind_3, t0.page_id AS page_id_4, t0.media_id AS media_id_5 FROM cms_page_asset t0 WHERE t0.page_id = ?

Parameters:

[
  "019c9449-0065-7d4b-9589-f33fa785e91e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.asset_key AS asset_key_2,
  t0.asset_kind AS asset_kind_3,
  t0.page_id AS page_id_4,
  t0.media_id AS media_id_5
FROM
  cms_page_asset t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.asset_key AS asset_key_2, t0.asset_kind AS asset_kind_3, t0.page_id AS page_id_4, t0.media_id AS media_id_5 FROM cms_page_asset t0 WHERE t0.page_id = '019c9449-0065-7d4b-9589-f33fa785e91e';

#	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 313)
7	App\Service\CmsPageRenderer->buildAssetMap (line 848)
8	App\Service\CmsPageRenderer->render (line 43)
9	App\Service\CmsPageService->renderPage (line 34)
10	App\Controller\Frontend\CountryController->renderCountry (line 76)
11	App\Controller\Frontend\CountryController->canada (line 28)
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)

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\Cms\NavigationItem	28
App\Entity\Cms\SiteSetting	14
App\Entity\Cms\SocialLink	4
App\Entity\Cms\NavigationMenu	3
App\Entity\Cms\CountryProfile	1
App\Entity\Cms\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Cms\CountryProfile	No errors.
App\Entity\Cms\Media	No errors.
App\Entity\Cms\Page	No errors.
App\Entity\Cms\PageAsset	No errors.
App\Entity\Cms\SiteSetting	No errors.
App\Entity\Cms\SocialLink	No errors.
App\Entity\Cms\NavigationMenu	No errors.
App\Entity\Cms\NavigationItem	No errors.

Symfony Profiler

GET https://dev.griac.org/en/canada

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping