Symfony Profiler

Query Metrics

59 Database Queries

9 Different statements

17.45 ms Query time

0 Invalid entities

55 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.38 ms
(48.05%)

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:

[
  "formation.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 = 'formation.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\FormationContentSettingsManager->read (line 67)
9	App\Service\Cms\FormationContentSettingsManager->frontendData (line 93)
10	App\Controller\Frontend\FormationController->index (line 35)
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)

2.23 ms
(12.77%)

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_.objective_fr AS objective_fr_4, c0_.objective_en AS objective_en_5, c0_.highlights_fr AS highlights_fr_6, c0_.highlights_en AS highlights_en_7, c0_.verse_fr AS verse_fr_8, c0_.verse_en AS verse_en_9, c0_.presentation_fr AS presentation_fr_10, c0_.presentation_en AS presentation_en_11, c0_.mission_items_fr AS mission_items_fr_12, c0_.mission_items_en AS mission_items_en_13, c0_.goals_items_fr AS goals_items_fr_14, c0_.goals_items_en AS goals_items_en_15, c0_.registration_steps_fr AS registration_steps_fr_16, c0_.registration_steps_en AS registration_steps_en_17, c0_.contact_email AS contact_email_18, c0_.cta_label_fr AS cta_label_fr_19, c0_.cta_label_en AS cta_label_en_20, c0_.cta_route_token AS cta_route_token_21, c0_.cta_url AS cta_url_22, c0_.sort_order AS sort_order_23, c0_.is_active AS is_active_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c0_.media_id AS media_id_27 FROM cms_training_school 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_.objective_fr AS objective_fr_4,
  c0_.objective_en AS objective_en_5,
  c0_.highlights_fr AS highlights_fr_6,
  c0_.highlights_en AS highlights_en_7,
  c0_.verse_fr AS verse_fr_8,
  c0_.verse_en AS verse_en_9,
  c0_.presentation_fr AS presentation_fr_10,
  c0_.presentation_en AS presentation_en_11,
  c0_.mission_items_fr AS mission_items_fr_12,
  c0_.mission_items_en AS mission_items_en_13,
  c0_.goals_items_fr AS goals_items_fr_14,
  c0_.goals_items_en AS goals_items_en_15,
  c0_.registration_steps_fr AS registration_steps_fr_16,
  c0_.registration_steps_en AS registration_steps_en_17,
  c0_.contact_email AS contact_email_18,
  c0_.cta_label_fr AS cta_label_fr_19,
  c0_.cta_label_en AS cta_label_en_20,
  c0_.cta_route_token AS cta_route_token_21,
  c0_.cta_url AS cta_url_22,
  c0_.sort_order AS sort_order_23,
  c0_.is_active AS is_active_24,
  c0_.created_at AS created_at_25,
  c0_.updated_at AS updated_at_26,
  c0_.media_id AS media_id_27
FROM
  cms_training_school 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_.objective_fr AS objective_fr_4, c0_.objective_en AS objective_en_5, c0_.highlights_fr AS highlights_fr_6, c0_.highlights_en AS highlights_en_7, c0_.verse_fr AS verse_fr_8, c0_.verse_en AS verse_en_9, c0_.presentation_fr AS presentation_fr_10, c0_.presentation_en AS presentation_en_11, c0_.mission_items_fr AS mission_items_fr_12, c0_.mission_items_en AS mission_items_en_13, c0_.goals_items_fr AS goals_items_fr_14, c0_.goals_items_en AS goals_items_en_15, c0_.registration_steps_fr AS registration_steps_fr_16, c0_.registration_steps_en AS registration_steps_en_17, c0_.contact_email AS contact_email_18, c0_.cta_label_fr AS cta_label_fr_19, c0_.cta_label_en AS cta_label_en_20, c0_.cta_route_token AS cta_route_token_21, c0_.cta_url AS cta_url_22, c0_.sort_order AS sort_order_23, c0_.is_active AS is_active_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c0_.media_id AS media_id_27 FROM cms_training_school 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\TrainingSchoolRepository->findActiveOrdered (line 32)
7	App\Controller\Frontend\FormationController->index (line 49)
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.46 ms
(8.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 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_e87398ccd1f46dede449312f0a19be93->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\FormationController->index (line 55)
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)

1.15 ms
(6.61%)

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 {#1517
    __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_e87398ccd1f46dede449312f0a19be93->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\FormationController->index (line 55)
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.04 ms
(5.95%)

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_formation"
  "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_formation' 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\FormationController->index (line 38)
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)

0.88 ms
(5.02%)

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_e87398ccd1f46dede449312f0a19be93->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\FormationController->index (line 55)
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.86 ms
(4.95%)

SELECT c0_.id AS id_0, c0_.question_fr AS question_fr_1, c0_.question_en AS question_en_2, c0_.answer_fr AS answer_fr_3, c0_.answer_en AS answer_en_4, c0_.sort_order AS sort_order_5, c0_.is_active AS is_active_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8 FROM cms_training_faq c0_ WHERE c0_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.question_fr AS question_fr_1,
  c0_.question_en AS question_en_2,
  c0_.answer_fr AS answer_fr_3,
  c0_.answer_en AS answer_en_4,
  c0_.sort_order AS sort_order_5,
  c0_.is_active AS is_active_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8
FROM
  cms_training_faq c0_
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.question_fr AS question_fr_1, c0_.question_en AS question_en_2, c0_.answer_fr AS answer_fr_3, c0_.answer_en AS answer_en_4, c0_.sort_order AS sort_order_5, c0_.is_active AS is_active_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8 FROM cms_training_faq c0_ WHERE c0_.is_active = 1 ORDER BY c0_.sort_order ASC, c0_.id 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\TrainingFaqRepository->findActiveOrdered (line 32)
7	App\Controller\Frontend\FormationController->index (line 58)
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.81 ms
(4.62%)

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_e87398ccd1f46dede449312f0a19be93->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\FormationController->index (line 55)
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
(3.69%)

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-006a-7716-b960-545d7bb0fa7b"
]

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-006a-7716-b960-545d7bb0fa7b';

#	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\FormationController->index (line 38)
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)

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\TrainingFaq	3
App\Entity\Cms\NavigationMenu	3
App\Entity\Cms\TrainingSchool	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\TrainingSchool	No errors.
App\Entity\Cms\TrainingFaq	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/formation

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping