Symfony Profiler

Query Metrics

23 Database Queries

7 Different statements

9.56 ms Query time

0 Invalid entities

53 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.53 ms
(36.96%)

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.slug AS slug_2, c0_.title AS title_3, c0_.category_label AS category_label_4, c0_.short_description AS short_description_5, c0_.detail_lead_paragraph1 AS detail_lead_paragraph1_6, c0_.detail_lead_paragraph2 AS detail_lead_paragraph2_7, c0_.detail_section2_title AS detail_section2_title_8, c0_.detail_section2_body AS detail_section2_body_9, c0_.detail_section3_title AS detail_section3_title_10, c0_.detail_section3_body AS detail_section3_body_11, c0_.detail_section4_title AS detail_section4_title_12, c0_.detail_section4_body AS detail_section4_body_13, c0_.detail_challenge_title AS detail_challenge_title_14, c0_.detail_challenge_body AS detail_challenge_body_15, c0_.donation_enabled AS donation_enabled_16, c0_.donation_goal_cents AS donation_goal_cents_17, c0_.donation_raised_cents AS donation_raised_cents_18, c0_.donation_preset_amounts AS donation_preset_amounts_19, c0_.donation_default_amount AS donation_default_amount_20, c0_.donation_min_amount AS donation_min_amount_21, c0_.donation_allow_custom_amount AS donation_allow_custom_amount_22, c0_.donation_offline_enabled AS donation_offline_enabled_23, c0_.donation_offline_instructions AS donation_offline_instructions_24, c0_.donation_button_label AS donation_button_label_25, c0_.is_featured AS is_featured_26, c0_.sort_order AS sort_order_27, c0_.is_active AS is_active_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.list_media_id AS list_media_id_31, c0_.detail_media_id AS detail_media_id_32 FROM cms_cause c0_ WHERE c0_.locale = ? AND c0_.slug = ? AND c0_.is_active = ? LIMIT 1

Parameters:

[
  "fr"
  "logement-abri"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.locale AS locale_1,
  c0_.slug AS slug_2,
  c0_.title AS title_3,
  c0_.category_label AS category_label_4,
  c0_.short_description AS short_description_5,
  c0_.detail_lead_paragraph1 AS detail_lead_paragraph1_6,
  c0_.detail_lead_paragraph2 AS detail_lead_paragraph2_7,
  c0_.detail_section2_title AS detail_section2_title_8,
  c0_.detail_section2_body AS detail_section2_body_9,
  c0_.detail_section3_title AS detail_section3_title_10,
  c0_.detail_section3_body AS detail_section3_body_11,
  c0_.detail_section4_title AS detail_section4_title_12,
  c0_.detail_section4_body AS detail_section4_body_13,
  c0_.detail_challenge_title AS detail_challenge_title_14,
  c0_.detail_challenge_body AS detail_challenge_body_15,
  c0_.donation_enabled AS donation_enabled_16,
  c0_.donation_goal_cents AS donation_goal_cents_17,
  c0_.donation_raised_cents AS donation_raised_cents_18,
  c0_.donation_preset_amounts AS donation_preset_amounts_19,
  c0_.donation_default_amount AS donation_default_amount_20,
  c0_.donation_min_amount AS donation_min_amount_21,
  c0_.donation_allow_custom_amount AS donation_allow_custom_amount_22,
  c0_.donation_offline_enabled AS donation_offline_enabled_23,
  c0_.donation_offline_instructions AS donation_offline_instructions_24,
  c0_.donation_button_label AS donation_button_label_25,
  c0_.is_featured AS is_featured_26,
  c0_.sort_order AS sort_order_27,
  c0_.is_active AS is_active_28,
  c0_.created_at AS created_at_29,
  c0_.updated_at AS updated_at_30,
  c0_.list_media_id AS list_media_id_31,
  c0_.detail_media_id AS detail_media_id_32
FROM
  cms_cause c0_
WHERE
  c0_.locale = ?
  AND c0_.slug = ?
  AND c0_.is_active = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.slug AS slug_2, c0_.title AS title_3, c0_.category_label AS category_label_4, c0_.short_description AS short_description_5, c0_.detail_lead_paragraph1 AS detail_lead_paragraph1_6, c0_.detail_lead_paragraph2 AS detail_lead_paragraph2_7, c0_.detail_section2_title AS detail_section2_title_8, c0_.detail_section2_body AS detail_section2_body_9, c0_.detail_section3_title AS detail_section3_title_10, c0_.detail_section3_body AS detail_section3_body_11, c0_.detail_section4_title AS detail_section4_title_12, c0_.detail_section4_body AS detail_section4_body_13, c0_.detail_challenge_title AS detail_challenge_title_14, c0_.detail_challenge_body AS detail_challenge_body_15, c0_.donation_enabled AS donation_enabled_16, c0_.donation_goal_cents AS donation_goal_cents_17, c0_.donation_raised_cents AS donation_raised_cents_18, c0_.donation_preset_amounts AS donation_preset_amounts_19, c0_.donation_default_amount AS donation_default_amount_20, c0_.donation_min_amount AS donation_min_amount_21, c0_.donation_allow_custom_amount AS donation_allow_custom_amount_22, c0_.donation_offline_enabled AS donation_offline_enabled_23, c0_.donation_offline_instructions AS donation_offline_instructions_24, c0_.donation_button_label AS donation_button_label_25, c0_.is_featured AS is_featured_26, c0_.sort_order AS sort_order_27, c0_.is_active AS is_active_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.list_media_id AS list_media_id_31, c0_.detail_media_id AS detail_media_id_32 FROM cms_cause c0_ WHERE c0_.locale = 'fr' AND c0_.slug = 'logement-abri' 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\CauseRepository->findOneActiveByLocaleAndSlug (line 48)
7	App\Controller\Frontend\CauseController->show (line 76)
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.22 ms
(12.71%)

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"
  "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 = 'header.top_message' 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\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_02f30d1190fc8b2df715b7d72bca22e8->doDisplay (line 64)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_e157c4818481eac2414a4ffabf79ab7a->doDisplay (line 58)
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\CauseController->show (line 88)
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.18 ms
(12.31%)

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 {#1180
    __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_02f30d1190fc8b2df715b7d72bca22e8->doDisplay (line 64)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_e157c4818481eac2414a4ffabf79ab7a->doDisplay (line 58)
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\CauseController->show (line 88)
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.13 ms
(11.77%)

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.slug AS slug_2, c0_.title AS title_3, c0_.category_label AS category_label_4, c0_.short_description AS short_description_5, c0_.detail_lead_paragraph1 AS detail_lead_paragraph1_6, c0_.detail_lead_paragraph2 AS detail_lead_paragraph2_7, c0_.detail_section2_title AS detail_section2_title_8, c0_.detail_section2_body AS detail_section2_body_9, c0_.detail_section3_title AS detail_section3_title_10, c0_.detail_section3_body AS detail_section3_body_11, c0_.detail_section4_title AS detail_section4_title_12, c0_.detail_section4_body AS detail_section4_body_13, c0_.detail_challenge_title AS detail_challenge_title_14, c0_.detail_challenge_body AS detail_challenge_body_15, c0_.donation_enabled AS donation_enabled_16, c0_.donation_goal_cents AS donation_goal_cents_17, c0_.donation_raised_cents AS donation_raised_cents_18, c0_.donation_preset_amounts AS donation_preset_amounts_19, c0_.donation_default_amount AS donation_default_amount_20, c0_.donation_min_amount AS donation_min_amount_21, c0_.donation_allow_custom_amount AS donation_allow_custom_amount_22, c0_.donation_offline_enabled AS donation_offline_enabled_23, c0_.donation_offline_instructions AS donation_offline_instructions_24, c0_.donation_button_label AS donation_button_label_25, c0_.is_featured AS is_featured_26, c0_.sort_order AS sort_order_27, c0_.is_active AS is_active_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.list_media_id AS list_media_id_31, c0_.detail_media_id AS detail_media_id_32 FROM cms_cause c0_ WHERE c0_.locale = ? AND c0_.is_active = ? AND c0_.id <> ? ORDER BY c0_.sort_order ASC, c0_.title ASC LIMIT 3

Parameters:

[
  "fr"
  1
  Symfony\Component\Uid\Uuid {#777
    __toString(): "42000000-0000-0000-0000-000000000003"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.locale AS locale_1,
  c0_.slug AS slug_2,
  c0_.title AS title_3,
  c0_.category_label AS category_label_4,
  c0_.short_description AS short_description_5,
  c0_.detail_lead_paragraph1 AS detail_lead_paragraph1_6,
  c0_.detail_lead_paragraph2 AS detail_lead_paragraph2_7,
  c0_.detail_section2_title AS detail_section2_title_8,
  c0_.detail_section2_body AS detail_section2_body_9,
  c0_.detail_section3_title AS detail_section3_title_10,
  c0_.detail_section3_body AS detail_section3_body_11,
  c0_.detail_section4_title AS detail_section4_title_12,
  c0_.detail_section4_body AS detail_section4_body_13,
  c0_.detail_challenge_title AS detail_challenge_title_14,
  c0_.detail_challenge_body AS detail_challenge_body_15,
  c0_.donation_enabled AS donation_enabled_16,
  c0_.donation_goal_cents AS donation_goal_cents_17,
  c0_.donation_raised_cents AS donation_raised_cents_18,
  c0_.donation_preset_amounts AS donation_preset_amounts_19,
  c0_.donation_default_amount AS donation_default_amount_20,
  c0_.donation_min_amount AS donation_min_amount_21,
  c0_.donation_allow_custom_amount AS donation_allow_custom_amount_22,
  c0_.donation_offline_enabled AS donation_offline_enabled_23,
  c0_.donation_offline_instructions AS donation_offline_instructions_24,
  c0_.donation_button_label AS donation_button_label_25,
  c0_.is_featured AS is_featured_26,
  c0_.sort_order AS sort_order_27,
  c0_.is_active AS is_active_28,
  c0_.created_at AS created_at_29,
  c0_.updated_at AS updated_at_30,
  c0_.list_media_id AS list_media_id_31,
  c0_.detail_media_id AS detail_media_id_32
FROM
  cms_cause c0_
WHERE
  c0_.locale = ?
  AND c0_.is_active = ?
  AND c0_.id <> ?
ORDER BY
  c0_.sort_order ASC,
  c0_.title ASC
LIMIT
  3

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.slug AS slug_2, c0_.title AS title_3, c0_.category_label AS category_label_4, c0_.short_description AS short_description_5, c0_.detail_lead_paragraph1 AS detail_lead_paragraph1_6, c0_.detail_lead_paragraph2 AS detail_lead_paragraph2_7, c0_.detail_section2_title AS detail_section2_title_8, c0_.detail_section2_body AS detail_section2_body_9, c0_.detail_section3_title AS detail_section3_title_10, c0_.detail_section3_body AS detail_section3_body_11, c0_.detail_section4_title AS detail_section4_title_12, c0_.detail_section4_body AS detail_section4_body_13, c0_.detail_challenge_title AS detail_challenge_title_14, c0_.detail_challenge_body AS detail_challenge_body_15, c0_.donation_enabled AS donation_enabled_16, c0_.donation_goal_cents AS donation_goal_cents_17, c0_.donation_raised_cents AS donation_raised_cents_18, c0_.donation_preset_amounts AS donation_preset_amounts_19, c0_.donation_default_amount AS donation_default_amount_20, c0_.donation_min_amount AS donation_min_amount_21, c0_.donation_allow_custom_amount AS donation_allow_custom_amount_22, c0_.donation_offline_enabled AS donation_offline_enabled_23, c0_.donation_offline_instructions AS donation_offline_instructions_24, c0_.donation_button_label AS donation_button_label_25, c0_.is_featured AS is_featured_26, c0_.sort_order AS sort_order_27, c0_.is_active AS is_active_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.list_media_id AS list_media_id_31, c0_.detail_media_id AS detail_media_id_32 FROM cms_cause c0_ WHERE c0_.locale = 'fr' AND c0_.is_active = 1 AND c0_.id <> '42000000-0000-0000-0000-000000000003' ORDER BY c0_.sort_order ASC, c0_.title ASC LIMIT 3;

#	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\CauseRepository->findRelatedActiveByLocale (line 96)
7	App\Controller\Frontend\CauseController->show (line 90)
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.10 ms
(11.46%)

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_02f30d1190fc8b2df715b7d72bca22e8->doDisplay (line 64)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_e157c4818481eac2414a4ffabf79ab7a->doDisplay (line 58)
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\CauseController->show (line 88)
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.86 ms
(9.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"
  "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_02f30d1190fc8b2df715b7d72bca22e8->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_e157c4818481eac2414a4ffabf79ab7a->doDisplay (line 58)
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\CauseController->show (line 88)
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.55 ms
(5.76%)

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_02f30d1190fc8b2df715b7d72bca22e8->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_e157c4818481eac2414a4ffabf79ab7a->doDisplay (line 58)
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\CauseController->show (line 88)
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\Cause	4
App\Entity\Cms\SocialLink	4
App\Entity\Cms\NavigationMenu	3

Entities Mapping

Class	Mapping errors
App\Entity\Cms\Cause	No errors.
App\Entity\Cms\Media	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/fr/cause/logement-abri

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping