Symfony Profiler

Query Metrics

12 Database Queries

8 Different statements

14.26 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.91 ms
(34.43%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.pre_title AS pre_title_3, t0.title AS title_4, t0.text AS text_5, t0.image AS image_6, t0.config AS config_7, t0.embed_url AS embed_url_8, t0.item_count AS item_count_9, t0.position AS position_10, t0.updated_at AS updated_at_11, t0.section_id AS section_id_12, t0.related_category_id AS related_category_id_13 FROM page_block t0 WHERE t0.section_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.type AS type_2,
  t0.pre_title AS pre_title_3,
  t0.title AS title_4,
  t0.text AS text_5,
  t0.image AS image_6,
  t0.config AS config_7,
  t0.embed_url AS embed_url_8,
  t0.item_count AS item_count_9,
  t0.position AS position_10,
  t0.updated_at AS updated_at_11,
  t0.section_id AS section_id_12,
  t0.related_category_id AS related_category_id_13
FROM
  page_block t0
WHERE
  t0.section_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.pre_title AS pre_title_3, t0.title AS title_4, t0.text AS text_5, t0.image AS image_6, t0.config AS config_7, t0.embed_url AS embed_url_8, t0.item_count AS item_count_9, t0.position AS position_10, t0.updated_at AS updated_at_11, t0.section_id AS section_id_12, t0.related_category_id AS related_category_id_13 FROM page_block t0 WHERE t0.section_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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 222)
8	__TwigTemplate_faff63990eb925e36877c8fa6e03a151->block_body (line 432)
9	Twig\Template->yieldBlock (line 300)
10	__TwigTemplate_6231eac2696988d4c645e7c1cfff618d->doDisplay (line 388)
11	Twig\Template->yield (line 57)
12	__TwigTemplate_faff63990eb925e36877c8fa6e03a151->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
21	App\Controller\pub\WabPublicController->pageShow (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

2.11 ms
(14.80%)

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.contact_email AS contact_email_10, t0.youtube_link AS youtube_link_11, t0.instagram_link AS instagram_link_12, t0.facebook_link AS facebook_link_13, t0.whatsapp_link AS whatsapp_link_14, t0.linkedin_link AS linkedin_link_15, t0.about_text AS about_text_16, t0.about_full_text AS about_full_text_17, t0.about_image AS about_image_18, t0.address AS address_19, t0.phone AS phone_20, t0.maps_embed_url AS maps_embed_url_21, t0.theme AS theme_22, t0.favicon AS favicon_23, t0.seo_title AS seo_title_24, t0.seo_description AS seo_description_25, t0.seo_keywords AS seo_keywords_26, t0.og_image AS og_image_27, t0.font_settings AS font_settings_28, t0.navigation_settings AS navigation_settings_29, t0.show_section_titles AS show_section_titles_30, t0.landing_page_mode AS landing_page_mode_31, t0.updated_at AS updated_at_32, t0.home_page_id AS home_page_id_33 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.contact_email AS contact_email_10,
  t0.youtube_link AS youtube_link_11,
  t0.instagram_link AS instagram_link_12,
  t0.facebook_link AS facebook_link_13,
  t0.whatsapp_link AS whatsapp_link_14,
  t0.linkedin_link AS linkedin_link_15,
  t0.about_text AS about_text_16,
  t0.about_full_text AS about_full_text_17,
  t0.about_image AS about_image_18,
  t0.address AS address_19,
  t0.phone AS phone_20,
  t0.maps_embed_url AS maps_embed_url_21,
  t0.theme AS theme_22,
  t0.favicon AS favicon_23,
  t0.seo_title AS seo_title_24,
  t0.seo_description AS seo_description_25,
  t0.seo_keywords AS seo_keywords_26,
  t0.og_image AS og_image_27,
  t0.font_settings AS font_settings_28,
  t0.navigation_settings AS navigation_settings_29,
  t0.show_section_titles AS show_section_titles_30,
  t0.landing_page_mode AS landing_page_mode_31,
  t0.updated_at AS updated_at_32,
  t0.home_page_id AS home_page_id_33
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.contact_email AS contact_email_10, t0.youtube_link AS youtube_link_11, t0.instagram_link AS instagram_link_12, t0.facebook_link AS facebook_link_13, t0.whatsapp_link AS whatsapp_link_14, t0.linkedin_link AS linkedin_link_15, t0.about_text AS about_text_16, t0.about_full_text AS about_full_text_17, t0.about_image AS about_image_18, t0.address AS address_19, t0.phone AS phone_20, t0.maps_embed_url AS maps_embed_url_21, t0.theme AS theme_22, t0.favicon AS favicon_23, t0.seo_title AS seo_title_24, t0.seo_description AS seo_description_25, t0.seo_keywords AS seo_keywords_26, t0.og_image AS og_image_27, t0.font_settings AS font_settings_28, t0.navigation_settings AS navigation_settings_29, t0.show_section_titles AS show_section_titles_30, t0.landing_page_mode AS landing_page_mode_31, t0.updated_at AS updated_at_32, t0.home_page_id AS home_page_id_33 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.61 ms
(11.30%)

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)

1.44 ms
(10.08%)

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)

1.14 ms
(7.96%)

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:

[
  "home"
]

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 = 'home' 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.10 ms
(7.68%)

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)

1.07 ms
(7.49%)

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)

0.89 ms
(6.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.bio AS bio_4, t0.image AS image_5, t0.linkedin_url AS linkedin_url_6, t0.facebook_url AS facebook_url_7, t0.instagram_url AS instagram_url_8, t0.whatsapp_url AS whatsapp_url_9, t0.phone AS phone_10, t0.email AS email_11, t0.position AS position_12, t0.updated_at AS updated_at_13, t0.block_id AS block_id_14 FROM page_block_team_member t0 WHERE t0.block_id = ? ORDER BY t0.position ASC

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.role AS role_3,
  t0.bio AS bio_4,
  t0.image AS image_5,
  t0.linkedin_url AS linkedin_url_6,
  t0.facebook_url AS facebook_url_7,
  t0.instagram_url AS instagram_url_8,
  t0.whatsapp_url AS whatsapp_url_9,
  t0.phone AS phone_10,
  t0.email AS email_11,
  t0.position AS position_12,
  t0.updated_at AS updated_at_13,
  t0.block_id AS block_id_14
FROM
  page_block_team_member t0
WHERE
  t0.block_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.bio AS bio_4, t0.image AS image_5, t0.linkedin_url AS linkedin_url_6, t0.facebook_url AS facebook_url_7, t0.instagram_url AS instagram_url_8, t0.whatsapp_url AS whatsapp_url_9, t0.phone AS phone_10, t0.email AS email_11, t0.position AS position_12, t0.updated_at AS updated_at_13, t0.block_id AS block_id_14 FROM page_block_team_member t0 WHERE t0.block_id = 10 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 1241)
9	Twig\Extension\CoreExtension::length (line 50)
10	__TwigTemplate_aaec3ebd2d6f6bc16378f279f8494ad9->doDisplay (line 388)
11	Twig\Template->yield (line 113)
12	__TwigTemplate_0ad5e04d46a876889215d10d0bb80d00->doDisplay (line 388)
13	Twig\Template->yield (line 415)
14	__TwigTemplate_faff63990eb925e36877c8fa6e03a151->block_body (line 432)
15	Twig\Template->yieldBlock (line 300)
16	__TwigTemplate_6231eac2696988d4c645e7c1cfff618d->doDisplay (line 388)
17	Twig\Template->yield (line 57)
18	__TwigTemplate_faff63990eb925e36877c8fa6e03a151->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
27	App\Controller\pub\WabPublicController->pageShow (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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.
App\Entity\PageBlockImage	No errors.
App\Entity\PageBlockTestimonial	No errors.
App\Entity\PageBlockPartnerLogo	No errors.
App\Entity\PageBlockTeamMember	No errors.

Symfony Profiler

GET https://site.wab.com.br/p/home

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping