Symfony Profiler

Query Metrics

38 Database Queries

8 Different statements

14.59 ms Query time

0 Invalid entities

56 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.78 ms
(32.79%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.title_fr AS title_fr_2, c0_.title_en AS title_en_3, c0_.subtitle_fr AS subtitle_fr_4, c0_.subtitle_en AS subtitle_en_5, c0_.sort_order AS sort_order_6, c0_.is_active AS is_active_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c1_.id AS id_10, c1_.full_name AS full_name_11, c1_.role_fr AS role_fr_12, c1_.role_en AS role_en_13, c1_.bio_fr AS bio_fr_14, c1_.bio_en AS bio_en_15, c1_.email AS email_16, c1_.facebook_url AS facebook_url_17, c1_.instagram_url AS instagram_url_18, c1_.linkedin_url AS linkedin_url_19, c1_.youtube_url AS youtube_url_20, c1_.sort_order AS sort_order_21, c1_.is_active AS is_active_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, c1_.photo_media_id AS photo_media_id_25 FROM cms_leadership_team c0_ LEFT JOIN cms_leadership_team_member c2_ ON c0_.id = c2_.team_id LEFT JOIN cms_leadership_member c1_ ON c1_.id = c2_.member_id AND (c1_.is_active = ?) WHERE c0_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.code ASC, c1_.sort_order ASC, c1_.full_name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.title_fr AS title_fr_2,
  c0_.title_en AS title_en_3,
  c0_.subtitle_fr AS subtitle_fr_4,
  c0_.subtitle_en AS subtitle_en_5,
  c0_.sort_order AS sort_order_6,
  c0_.is_active AS is_active_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c1_.id AS id_10,
  c1_.full_name AS full_name_11,
  c1_.role_fr AS role_fr_12,
  c1_.role_en AS role_en_13,
  c1_.bio_fr AS bio_fr_14,
  c1_.bio_en AS bio_en_15,
  c1_.email AS email_16,
  c1_.facebook_url AS facebook_url_17,
  c1_.instagram_url AS instagram_url_18,
  c1_.linkedin_url AS linkedin_url_19,
  c1_.youtube_url AS youtube_url_20,
  c1_.sort_order AS sort_order_21,
  c1_.is_active AS is_active_22,
  c1_.created_at AS created_at_23,
  c1_.updated_at AS updated_at_24,
  c1_.photo_media_id AS photo_media_id_25
FROM
  cms_leadership_team c0_
  LEFT JOIN cms_leadership_team_member c2_ ON c0_.id = c2_.team_id
  LEFT JOIN cms_leadership_member c1_ ON c1_.id = c2_.member_id
  AND (c1_.is_active = ?)
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.code ASC,
  c1_.sort_order ASC,
  c1_.full_name ASC

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.title_fr AS title_fr_2, c0_.title_en AS title_en_3, c0_.subtitle_fr AS subtitle_fr_4, c0_.subtitle_en AS subtitle_en_5, c0_.sort_order AS sort_order_6, c0_.is_active AS is_active_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c1_.id AS id_10, c1_.full_name AS full_name_11, c1_.role_fr AS role_fr_12, c1_.role_en AS role_en_13, c1_.bio_fr AS bio_fr_14, c1_.bio_en AS bio_en_15, c1_.email AS email_16, c1_.facebook_url AS facebook_url_17, c1_.instagram_url AS instagram_url_18, c1_.linkedin_url AS linkedin_url_19, c1_.youtube_url AS youtube_url_20, c1_.sort_order AS sort_order_21, c1_.is_active AS is_active_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, c1_.photo_media_id AS photo_media_id_25 FROM cms_leadership_team c0_ LEFT JOIN cms_leadership_team_member c2_ ON c0_.id = c2_.team_id LEFT JOIN cms_leadership_member c1_ ON c1_.id = c2_.member_id AND (c1_.is_active = 1) WHERE c0_.is_active = 1 ORDER BY c0_.sort_order ASC, c0_.code ASC, c1_.sort_order ASC, c1_.full_name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Cms\LeadershipTeamRepository->findActiveOrderedWithMembers (line 37)
7	App\Controller\Frontend\LeadershipController->index (line 42)
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)

4.62 ms
(31.69%)

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:

[
  "leadership.page.eyebrow"
  "fr"
]

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 = 'leadership.page.eyebrow' AND c0_.locale = 'fr';

#	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\LeadershipContentSettingsManager->read (line 47)
9	App\Service\Cms\LeadershipContentSettingsManager->frontendData (line 73)
10	App\Controller\Frontend\LeadershipController->index (line 28)
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.08 ms
(7.40%)

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 {#1381
    __toString(): "10000000-0000-0000-0000-000000000001"
  }
]

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-000000000001' 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_9e9b63753ddbce4eb632837a7b009da4->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\LeadershipController->index (line 40)
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.05 ms
(7.17%)

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_equipe_dirigeante"
  "fr"
]

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_equipe_dirigeante' AND t0.locale = 'fr' 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\LeadershipController->index (line 31)
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.00 ms
(6.85%)

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_9e9b63753ddbce4eb632837a7b009da4->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\LeadershipController->index (line 40)
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
(5.64%)

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"
  "fr"
]

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 = 'fr' 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_9e9b63753ddbce4eb632837a7b009da4->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\LeadershipController->index (line 40)
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.64 ms
(4.38%)

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-0067-7ada-adbf-3c85ee4fee44"
]

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-0067-7ada-adbf-3c85ee4fee44';

#	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\LeadershipController->index (line 31)
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.59 ms
(4.07%)

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_9e9b63753ddbce4eb632837a7b009da4->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\LeadershipController->index (line 40)
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\LeadershipTeam	4
App\Entity\Cms\SocialLink	4
App\Entity\Cms\NavigationMenu	3
App\Entity\Cms\LeadershipMember	2
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\LeadershipTeam	No errors.
App\Entity\Cms\LeadershipMember	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/fr/equipe-dirigeante

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping