Symfony Profiler

Query Metrics

9 Database Queries

8 Different statements

12.62 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.24 ms
(25.68%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.pre_title AS pre_title_4, t0.description AS description_5, t0.show_in_header AS show_in_header_6, t0.show_in_footer AS show_in_footer_7, t0.icon AS icon_8, t0.tenant_id AS tenant_id_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = ? AND ((t0.tenant_id = '1'))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.pre_title AS pre_title_4,
  t0.description AS description_5,
  t0.show_in_header AS show_in_header_6,
  t0.show_in_footer AS show_in_footer_7,
  t0.icon AS icon_8,
  t0.tenant_id AS tenant_id_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.id = ?
  AND (
    (t0.tenant_id = '1')
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.pre_title AS pre_title_4, t0.description AS description_5, t0.show_in_header AS show_in_header_6, t0.show_in_footer AS show_in_footer_7, t0.icon AS icon_8, t0.tenant_id AS tenant_id_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = 1 AND ((t0.tenant_id = '1'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Category::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Category->__get (line 87)
8	App\Entity\Category->getName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 175)
10	__TwigTemplate_faff63990eb925e36877c8fa6e03a151->block_body (line 432)
11	Twig\Template->yieldBlock (line 300)
12	__TwigTemplate_6231eac2696988d4c645e7c1cfff618d->doDisplay (line 388)
13	Twig\Template->yield (line 57)
14	__TwigTemplate_faff63990eb925e36877c8fa6e03a151->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
23	App\Controller\pub\WabPublicController->pageShow (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

2.61 ms
(20.65%)

SELECT t0.id AS id_1, t0.title_part1 AS title_part1_2, t0.title_part2 AS title_part2_3, t0.position AS position_4, t0.active AS active_5, t0.bg_type AS bg_type_6, t0.bg_color AS bg_color_7, t0.bg_gradient AS bg_gradient_8, t0.bg_image AS bg_image_9, t0.bg_image_opacity AS bg_image_opacity_10, t0.bg_image_position AS bg_image_position_11, t0.bg_video AS bg_video_12, t0.updated_at AS updated_at_13, t0.page_id AS page_id_14, t0.category_id AS category_id_15 FROM page_section t0 WHERE t0.page_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_part1 AS title_part1_2,
  t0.title_part2 AS title_part2_3,
  t0.position AS position_4,
  t0.active AS active_5,
  t0.bg_type AS bg_type_6,
  t0.bg_color AS bg_color_7,
  t0.bg_gradient AS bg_gradient_8,
  t0.bg_image AS bg_image_9,
  t0.bg_image_opacity AS bg_image_opacity_10,
  t0.bg_image_position AS bg_image_position_11,
  t0.bg_video AS bg_video_12,
  t0.updated_at AS updated_at_13,
  t0.page_id AS page_id_14,
  t0.category_id AS category_id_15
FROM
  page_section t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title_part1 AS title_part1_2, t0.title_part2 AS title_part2_3, t0.position AS position_4, t0.active AS active_5, t0.bg_type AS bg_type_6, t0.bg_color AS bg_color_7, t0.bg_gradient AS bg_gradient_8, t0.bg_image AS bg_image_9, t0.bg_image_opacity AS bg_image_opacity_10, t0.bg_image_position AS bg_image_position_11, t0.bg_video AS bg_video_12, t0.updated_at AS updated_at_13, t0.page_id AS page_id_14, t0.category_id AS category_id_15 FROM page_section t0 WHERE t0.page_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 124)
9	__TwigTemplate_8e2fb9e087d2c67616a18f73f37d8409->doDisplay (line 388)
10	Twig\Template->yield (line 266)
11	__TwigTemplate_6231eac2696988d4c645e7c1cfff618d->doDisplay (line 388)
12	Twig\Template->yield (line 57)
13	__TwigTemplate_faff63990eb925e36877c8fa6e03a151->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
22	App\Controller\pub\WabPublicController->pageShow (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.68 ms
(13.28%)

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.logo AS logo_4, t0.dark_logo AS dark_logo_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.primary_color_dark AS primary_color_dark_8, t0.secondary_color_dark AS secondary_color_dark_9, t0.bg_color_light1 AS bg_color_light1_10, t0.bg_color_light2 AS bg_color_light2_11, t0.bg_color_dark1 AS bg_color_dark1_12, t0.bg_color_dark2 AS bg_color_dark2_13, t0.contact_email AS contact_email_14, t0.youtube_link AS youtube_link_15, t0.instagram_link AS instagram_link_16, t0.facebook_link AS facebook_link_17, t0.whatsapp_link AS whatsapp_link_18, t0.linkedin_link AS linkedin_link_19, t0.about_text AS about_text_20, t0.about_full_text AS about_full_text_21, t0.about_image AS about_image_22, t0.address AS address_23, t0.phone AS phone_24, t0.maps_embed_url AS maps_embed_url_25, t0.theme AS theme_26, t0.favicon AS favicon_27, t0.seo_title AS seo_title_28, t0.seo_description AS seo_description_29, t0.seo_keywords AS seo_keywords_30, t0.og_image AS og_image_31, t0.font_settings AS font_settings_32, t0.navigation_settings AS navigation_settings_33, t0.show_section_titles AS show_section_titles_34, t0.landing_page_mode AS landing_page_mode_35, t0.updated_at AS updated_at_36, t0.home_page_id AS home_page_id_37 FROM tenant t0 WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "site.wab.com.br"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.name AS name_3,
  t0.logo AS logo_4,
  t0.dark_logo AS dark_logo_5,
  t0.primary_color AS primary_color_6,
  t0.secondary_color AS secondary_color_7,
  t0.primary_color_dark AS primary_color_dark_8,
  t0.secondary_color_dark AS secondary_color_dark_9,
  t0.bg_color_light1 AS bg_color_light1_10,
  t0.bg_color_light2 AS bg_color_light2_11,
  t0.bg_color_dark1 AS bg_color_dark1_12,
  t0.bg_color_dark2 AS bg_color_dark2_13,
  t0.contact_email AS contact_email_14,
  t0.youtube_link AS youtube_link_15,
  t0.instagram_link AS instagram_link_16,
  t0.facebook_link AS facebook_link_17,
  t0.whatsapp_link AS whatsapp_link_18,
  t0.linkedin_link AS linkedin_link_19,
  t0.about_text AS about_text_20,
  t0.about_full_text AS about_full_text_21,
  t0.about_image AS about_image_22,
  t0.address AS address_23,
  t0.phone AS phone_24,
  t0.maps_embed_url AS maps_embed_url_25,
  t0.theme AS theme_26,
  t0.favicon AS favicon_27,
  t0.seo_title AS seo_title_28,
  t0.seo_description AS seo_description_29,
  t0.seo_keywords AS seo_keywords_30,
  t0.og_image AS og_image_31,
  t0.font_settings AS font_settings_32,
  t0.navigation_settings AS navigation_settings_33,
  t0.show_section_titles AS show_section_titles_34,
  t0.landing_page_mode AS landing_page_mode_35,
  t0.updated_at AS updated_at_36,
  t0.home_page_id AS home_page_id_37
FROM
  tenant t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.logo AS logo_4, t0.dark_logo AS dark_logo_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.primary_color_dark AS primary_color_dark_8, t0.secondary_color_dark AS secondary_color_dark_9, t0.bg_color_light1 AS bg_color_light1_10, t0.bg_color_light2 AS bg_color_light2_11, t0.bg_color_dark1 AS bg_color_dark1_12, t0.bg_color_dark2 AS bg_color_dark2_13, t0.contact_email AS contact_email_14, t0.youtube_link AS youtube_link_15, t0.instagram_link AS instagram_link_16, t0.facebook_link AS facebook_link_17, t0.whatsapp_link AS whatsapp_link_18, t0.linkedin_link AS linkedin_link_19, t0.about_text AS about_text_20, t0.about_full_text AS about_full_text_21, t0.about_image AS about_image_22, t0.address AS address_23, t0.phone AS phone_24, t0.maps_embed_url AS maps_embed_url_25, t0.theme AS theme_26, t0.favicon AS favicon_27, t0.seo_title AS seo_title_28, t0.seo_description AS seo_description_29, t0.seo_keywords AS seo_keywords_30, t0.og_image AS og_image_31, t0.font_settings AS font_settings_32, t0.navigation_settings AS navigation_settings_33, t0.show_section_titles AS show_section_titles_34, t0.landing_page_mode AS landing_page_mode_35, t0.updated_at AS updated_at_36, t0.home_page_id AS home_page_id_37 FROM tenant t0 WHERE t0.domain = 'site.wab.com.br' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 21)
5	App\Repository\TenantRepository->findByDomain (line 48)
6	App\EventSubscriber\TenantSubscriber->onKernelRequest (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.21 ms
(9.58%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.show_in_header AS show_in_header_4, t0.show_in_footer AS show_in_footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.cover_image AS cover_image_8, t0.position AS position_9, t0.show_title AS show_title_10, t0.updated_at AS updated_at_11, t0.tenant_id AS tenant_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.slug = ? AND ((t0.tenant_id = '1')) LIMIT 1

Parameters:

[
  "direito-do-consumidor"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.show_in_header AS show_in_header_4,
  t0.show_in_footer AS show_in_footer_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.cover_image AS cover_image_8,
  t0.position AS position_9,
  t0.show_title AS show_title_10,
  t0.updated_at AS updated_at_11,
  t0.tenant_id AS tenant_id_12,
  t0.category_id AS category_id_13
FROM
  page t0
WHERE
  t0.slug = ?
  AND (
    (t0.tenant_id = '1')
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.show_in_header AS show_in_header_4, t0.show_in_footer AS show_in_footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.cover_image AS cover_image_8, t0.position AS position_9, t0.show_title AS show_title_10, t0.updated_at AS updated_at_11, t0.tenant_id AS tenant_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.slug = 'direito-do-consumidor' AND ((t0.tenant_id = '1')) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 64)
5	App\Controller\pub\WabPublicController->pageShow (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.07 ms
(8.49%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.show_in_header AS show_in_header_4, t0.show_in_footer AS show_in_footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.cover_image AS cover_image_8, t0.position AS position_9, t0.show_title AS show_title_10, t0.updated_at AS updated_at_11, t0.tenant_id AS tenant_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.id = ? AND ((t0.tenant_id = '1'))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.show_in_header AS show_in_header_4,
  t0.show_in_footer AS show_in_footer_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.cover_image AS cover_image_8,
  t0.position AS position_9,
  t0.show_title AS show_title_10,
  t0.updated_at AS updated_at_11,
  t0.tenant_id AS tenant_id_12,
  t0.category_id AS category_id_13
FROM
  page t0
WHERE
  t0.id = ?
  AND (
    (t0.tenant_id = '1')
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.show_in_header AS show_in_header_4, t0.show_in_footer AS show_in_footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.cover_image AS cover_image_8, t0.position AS position_9, t0.show_title AS show_title_10, t0.updated_at AS updated_at_11, t0.tenant_id AS tenant_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.id = 1 AND ((t0.tenant_id = '1'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Page::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Page->__get (line 125)
8	App\Entity\Page->getSections (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 116)
10	__TwigTemplate_8e2fb9e087d2c67616a18f73f37d8409->doDisplay (line 388)
11	Twig\Template->yield (line 266)
12	__TwigTemplate_6231eac2696988d4c645e7c1cfff618d->doDisplay (line 388)
13	Twig\Template->yield (line 57)
14	__TwigTemplate_faff63990eb925e36877c8fa6e03a151->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
23	App\Controller\pub\WabPublicController->pageShow (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.01 ms
(8.01%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.pre_title AS pre_title_3, c0_.description AS description_4, c0_.show_in_header AS show_in_header_5, c0_.show_in_footer AS show_in_footer_6, c0_.icon AS icon_7, c0_.tenant_id AS tenant_id_8, c0_.parent_id AS parent_id_9 FROM category c0_ WHERE (c0_.parent_id IS NULL AND c0_.show_in_header = 1) AND (c0_.tenant_id = '1') ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.pre_title AS pre_title_3,
  c0_.description AS description_4,
  c0_.show_in_header AS show_in_header_5,
  c0_.show_in_footer AS show_in_footer_6,
  c0_.icon AS icon_7,
  c0_.tenant_id AS tenant_id_8,
  c0_.parent_id AS parent_id_9
FROM
  category c0_
WHERE
  (
    c0_.parent_id IS NULL
    AND c0_.show_in_header = 1
  )
  AND (c0_.tenant_id = '1')
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.pre_title AS pre_title_3, c0_.description AS description_4, c0_.show_in_header AS show_in_header_5, c0_.show_in_footer AS show_in_footer_6, c0_.icon AS icon_7, c0_.tenant_id AS tenant_id_8, c0_.parent_id AS parent_id_9 FROM category c0_ WHERE (c0_.parent_id IS NULL AND c0_.show_in_header = 1) AND (c0_.tenant_id = '1') ORDER BY c0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\CategoryRepository->findForHeader (line 30)
8	App\Twig\TenantExtension->getGlobals (line 340)
9	Twig\ExtensionSet->getGlobals (line 892)
10	Twig\Environment->getGlobals (line 384)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
19	App\Controller\pub\WabPublicController->pageShow (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.97 ms
(7.70%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.pre_title AS pre_title_3, c0_.description AS description_4, c0_.show_in_header AS show_in_header_5, c0_.show_in_footer AS show_in_footer_6, c0_.icon AS icon_7, c0_.tenant_id AS tenant_id_8, c0_.parent_id AS parent_id_9 FROM category c0_ WHERE (c0_.parent_id IS NULL AND c0_.show_in_footer = 1) AND (c0_.tenant_id = '1') ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.pre_title AS pre_title_3,
  c0_.description AS description_4,
  c0_.show_in_header AS show_in_header_5,
  c0_.show_in_footer AS show_in_footer_6,
  c0_.icon AS icon_7,
  c0_.tenant_id AS tenant_id_8,
  c0_.parent_id AS parent_id_9
FROM
  category c0_
WHERE
  (
    c0_.parent_id IS NULL
    AND c0_.show_in_footer = 1
  )
  AND (c0_.tenant_id = '1')
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.pre_title AS pre_title_3, c0_.description AS description_4, c0_.show_in_header AS show_in_header_5, c0_.show_in_footer AS show_in_footer_6, c0_.icon AS icon_7, c0_.tenant_id AS tenant_id_8, c0_.parent_id AS parent_id_9 FROM category c0_ WHERE (c0_.parent_id IS NULL AND c0_.show_in_footer = 1) AND (c0_.tenant_id = '1') ORDER BY c0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 66)
7	App\Repository\CategoryRepository->findForFooter (line 32)
8	App\Twig\TenantExtension->getGlobals (line 340)
9	Twig\ExtensionSet->getGlobals (line 892)
10	Twig\Environment->getGlobals (line 384)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
19	App\Controller\pub\WabPublicController->pageShow (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.83 ms
(6.61%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.show_in_header AS show_in_header_4, t0.show_in_footer AS show_in_footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.cover_image AS cover_image_8, t0.position AS position_9, t0.show_title AS show_title_10, t0.updated_at AS updated_at_11, t0.tenant_id AS tenant_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.show_in_footer = ? AND ((t0.tenant_id = '1'))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.show_in_header AS show_in_header_4,
  t0.show_in_footer AS show_in_footer_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.cover_image AS cover_image_8,
  t0.position AS position_9,
  t0.show_title AS show_title_10,
  t0.updated_at AS updated_at_11,
  t0.tenant_id AS tenant_id_12,
  t0.category_id AS category_id_13
FROM
  page t0
WHERE
  t0.show_in_footer = ?
  AND (
    (t0.tenant_id = '1')
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.show_in_header AS show_in_header_4, t0.show_in_footer AS show_in_footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.cover_image AS cover_image_8, t0.position AS position_9, t0.show_title AS show_title_10, t0.updated_at AS updated_at_11, t0.tenant_id AS tenant_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.show_in_footer = 1 AND ((t0.tenant_id = '1'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 18)
5	App\Repository\PageRepository->findForFooter (line 31)
6	App\Twig\TenantExtension->getGlobals (line 340)
7	Twig\ExtensionSet->getGlobals (line 892)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
17	App\Controller\pub\WabPublicController->pageShow (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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.

Entities Mapping

Class	Mapping errors
App\Entity\Tenant	No errors.
App\Entity\Page	No errors.
App\Entity\Category	No errors.
App\Entity\PageSection	No errors.
App\Entity\PageBlock	No errors.

Symfony Profiler

GET https://site.wab.com.br/p/direito-do-consumidor

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping