Symfony Profiler

Query Metrics

36 Database Queries

8 Different statements

11.49 ms Query time

0 Invalid entities

55 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.33 ms
(37.68%)

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:

[
  "programs.page.eyebrow"
  "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 = 'programs.page.eyebrow' 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\Cms\ProgramsContentSettingsManager->read (line 45)
9	App\Service\Cms\ProgramsContentSettingsManager->frontendData (line 71)
10	App\Controller\Frontend\ServicesController->index (line 30)
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)

1.99 ms
(17.36%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name_fr AS name_fr_2, c0_.name_en AS name_en_3, c0_.tagline_fr AS tagline_fr_4, c0_.tagline_en AS tagline_en_5, c0_.scripture_fr AS scripture_fr_6, c0_.scripture_en AS scripture_en_7, c0_.description_fr AS description_fr_8, c0_.description_en AS description_en_9, c0_.activities_fr AS activities_fr_10, c0_.activities_en AS activities_en_11, c0_.contact_text_fr AS contact_text_fr_12, c0_.contact_text_en AS contact_text_en_13, c0_.contact_email AS contact_email_14, c0_.cta_label_fr AS cta_label_fr_15, c0_.cta_label_en AS cta_label_en_16, c0_.cta_route_token AS cta_route_token_17, c0_.cta_url AS cta_url_18, c0_.sort_order AS sort_order_19, c0_.is_active AS is_active_20, c0_.created_at AS created_at_21, c0_.updated_at AS updated_at_22, c0_.media_id AS media_id_23 FROM cms_program c0_ WHERE c0_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.name_fr ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_fr AS name_fr_2,
  c0_.name_en AS name_en_3,
  c0_.tagline_fr AS tagline_fr_4,
  c0_.tagline_en AS tagline_en_5,
  c0_.scripture_fr AS scripture_fr_6,
  c0_.scripture_en AS scripture_en_7,
  c0_.description_fr AS description_fr_8,
  c0_.description_en AS description_en_9,
  c0_.activities_fr AS activities_fr_10,
  c0_.activities_en AS activities_en_11,
  c0_.contact_text_fr AS contact_text_fr_12,
  c0_.contact_text_en AS contact_text_en_13,
  c0_.contact_email AS contact_email_14,
  c0_.cta_label_fr AS cta_label_fr_15,
  c0_.cta_label_en AS cta_label_en_16,
  c0_.cta_route_token AS cta_route_token_17,
  c0_.cta_url AS cta_url_18,
  c0_.sort_order AS sort_order_19,
  c0_.is_active AS is_active_20,
  c0_.created_at AS created_at_21,
  c0_.updated_at AS updated_at_22,
  c0_.media_id AS media_id_23
FROM
  cms_program c0_
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name_fr ASC

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name_fr AS name_fr_2, c0_.name_en AS name_en_3, c0_.tagline_fr AS tagline_fr_4, c0_.tagline_en AS tagline_en_5, c0_.scripture_fr AS scripture_fr_6, c0_.scripture_en AS scripture_en_7, c0_.description_fr AS description_fr_8, c0_.description_en AS description_en_9, c0_.activities_fr AS activities_fr_10, c0_.activities_en AS activities_en_11, c0_.contact_text_fr AS contact_text_fr_12, c0_.contact_text_en AS contact_text_en_13, c0_.contact_email AS contact_email_14, c0_.cta_label_fr AS cta_label_fr_15, c0_.cta_label_en AS cta_label_en_16, c0_.cta_route_token AS cta_route_token_17, c0_.cta_url AS cta_url_18, c0_.sort_order AS sort_order_19, c0_.is_active AS is_active_20, c0_.created_at AS created_at_21, c0_.updated_at AS updated_at_22, c0_.media_id AS media_id_23 FROM cms_program c0_ WHERE c0_.is_active = 1 ORDER BY c0_.sort_order ASC, c0_.name_fr 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\ProgramRepository->findActiveOrdered (line 32)
7	App\Controller\Frontend\ServicesController->index (line 44)
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)

1.21 ms
(10.50%)

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:

[
  "app_services"
  "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 = 'app_services' 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\ServicesController->index (line 33)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

1.06 ms
(9.21%)

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 {#1354
    __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_ee97d290de80bd009da3704833ad4547->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\ServicesController->index (line 51)
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.89 ms
(7.77%)

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_ee97d290de80bd009da3704833ad4547->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\ServicesController->index (line 51)
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.82 ms
(7.13%)

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_ee97d290de80bd009da3704833ad4547->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\ServicesController->index (line 51)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.62 ms
(5.36%)

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:

[
  "019b6a92-8b58-7b08-9266-18b067daa25f"
]

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 = '019b6a92-8b58-7b08-9266-18b067daa25f';

#	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\ServicesController->index (line 33)
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.57 ms
(4.99%)

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_ee97d290de80bd009da3704833ad4547->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\ServicesController->index (line 51)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	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\Program	5
App\Entity\Cms\SocialLink	4
App\Entity\Cms\NavigationMenu	3
App\Entity\Cms\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Cms\SiteSetting	No errors.
App\Entity\Cms\Page	No errors.
App\Entity\Cms\PageAsset	No errors.
App\Entity\Cms\Media	No errors.
App\Entity\Cms\Program	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/services

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping