Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

2.86 ms Query time

0 Invalid entities

35 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.01 ms
(35.22%)

SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = ? AND c0_.is_active = 1

Parameters:

[
  "legal_notice"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.document_key AS document_key_1,
  c0_.is_active AS is_active_2,
  c0_.texts AS texts_3
FROM
  content_legal_documents c0_
WHERE
  c0_.document_key = ?
  AND c0_.is_active = 1

SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = 'legal_notice' AND c0_.is_active = 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\Content\Infrastructure\Persistence\Doctrine\DoctrineLegalDocumentRepository->findActiveByKey (line 28)
7	App\Content\Infrastructure\Twig\LegalDocumentTwigExtension->getLegalDocumentUrl (line 49)
8	__TwigTemplate_702b8dfe61f5d6b4f2c6615ec7eb9a3f->doDisplay (line 283)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_2bbaad7e7928e57e1d02c86f2c8dfaeb->block_footer (line 701)
11	Twig\Template->yieldBlock (line 458)
12	__TwigTemplate_2bbaad7e7928e57e1d02c86f2c8dfaeb->doDisplay (line 413)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_021a91a1d80edce6d646042b01af6619->doDisplay (line 57)
15	Twig\Template->yield (line 411)
16	Twig\Template->display (line 366)
17	Twig\Template->render (line 381)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
23	App\UI\Transform\Controller\ShowTransformController->__invoke (line 34)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
26	Symfony\Component\HttpKernel\Kernel->handle (line 143)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
28	require_once (line 32)
29	require_once (line 5)

0.59 ms
(20.72%)

SELECT c0_.id AS id_0, c0_.page_key AS page_key_1, c0_.is_active AS is_active_2, c1_.id AS id_3, c1_.position AS position_4, c1_.is_active AS is_active_5, c1_.texts AS texts_6, c1_.image_key AS image_key_7, c1_.video_url AS video_url_8, c1_.video_thumb_key AS video_thumb_key_9, c1_.layout AS layout_10, c1_.variant AS variant_11, c1_.source AS source_12, c1_.interval_seconds AS interval_seconds_13, c1_.image_position AS image_position_14, c1_.cta_link_destination AS cta_link_destination_15, c1_.cta_link_route_name AS cta_link_route_name_16, c1_.cta_link_external_url AS cta_link_external_url_17, c1_.cta_link_fragment AS cta_link_fragment_18, c1_.type AS type_19, c1_.page_content_id AS page_content_id_20 FROM content_page_contents c0_ LEFT JOIN content_blocks c1_ ON c0_.id = c1_.page_content_id AND c1_.type IN ('hero', 'text', 'image_strip', 'cards', 'banner', 'carousel', 'logo_row', 'newsletter', 'questionnaires', 'contact_banner', 'instructors_grid', 'static_programs') WHERE c0_.page_key = ? AND c0_.is_active = 1 ORDER BY c1_.position ASC

Parameters:

[
  "transform"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.page_key AS page_key_1,
  c0_.is_active AS is_active_2,
  c1_.id AS id_3,
  c1_.position AS position_4,
  c1_.is_active AS is_active_5,
  c1_.texts AS texts_6,
  c1_.image_key AS image_key_7,
  c1_.video_url AS video_url_8,
  c1_.video_thumb_key AS video_thumb_key_9,
  c1_.layout AS layout_10,
  c1_.variant AS variant_11,
  c1_.source AS source_12,
  c1_.interval_seconds AS interval_seconds_13,
  c1_.image_position AS image_position_14,
  c1_.cta_link_destination AS cta_link_destination_15,
  c1_.cta_link_route_name AS cta_link_route_name_16,
  c1_.cta_link_external_url AS cta_link_external_url_17,
  c1_.cta_link_fragment AS cta_link_fragment_18,
  c1_.type AS type_19,
  c1_.page_content_id AS page_content_id_20
FROM
  content_page_contents c0_
  LEFT JOIN content_blocks c1_ ON c0_.id = c1_.page_content_id
  AND c1_.type IN (
    'hero', 'text', 'image_strip', 'cards',
    'banner', 'carousel', 'logo_row',
    'newsletter', 'questionnaires',
    'contact_banner', 'instructors_grid',
    'static_programs'
  )
WHERE
  c0_.page_key = ?
  AND c0_.is_active = 1
ORDER BY
  c1_.position ASC

SELECT c0_.id AS id_0, c0_.page_key AS page_key_1, c0_.is_active AS is_active_2, c1_.id AS id_3, c1_.position AS position_4, c1_.is_active AS is_active_5, c1_.texts AS texts_6, c1_.image_key AS image_key_7, c1_.video_url AS video_url_8, c1_.video_thumb_key AS video_thumb_key_9, c1_.layout AS layout_10, c1_.variant AS variant_11, c1_.source AS source_12, c1_.interval_seconds AS interval_seconds_13, c1_.image_position AS image_position_14, c1_.cta_link_destination AS cta_link_destination_15, c1_.cta_link_route_name AS cta_link_route_name_16, c1_.cta_link_external_url AS cta_link_external_url_17, c1_.cta_link_fragment AS cta_link_fragment_18, c1_.type AS type_19, c1_.page_content_id AS page_content_id_20 FROM content_page_contents c0_ LEFT JOIN content_blocks c1_ ON c0_.id = c1_.page_content_id AND c1_.type IN ('hero', 'text', 'image_strip', 'cards', 'banner', 'carousel', 'logo_row', 'newsletter', 'questionnaires', 'contact_banner', 'instructors_grid', 'static_programs') WHERE c0_.page_key = 'transform' AND c0_.is_active = 1 ORDER BY c1_.position 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->getOneOrNullResult (line 737)
6	App\Content\Infrastructure\Persistence\Doctrine\DoctrinePageContentRepository->findActiveByKey (line 30)
7	App\Content\Application\GetPageContent\GetPageContent->__invoke (line 23)
8	App\UI\Transform\Controller\ShowTransformController->__invoke (line 28)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
11	Symfony\Component\HttpKernel\Kernel->handle (line 143)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

0.48 ms
(16.77%)

SELECT c0_.id AS id_0, c0_.texts AS texts_1, c0_.position AS position_2, c1_.id AS id_3, c1_.texts AS texts_4, c1_.position AS position_5, c1_.destination AS destination_6, c1_.route_name AS route_name_7, c1_.external_url AS external_url_8, c1_.fragment AS fragment_9, c0_.footer_id AS footer_id_10, c1_.column_id AS column_id_11 FROM content_footer_columns c0_ LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id ORDER BY c0_.position ASC, c1_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.texts AS texts_1,
  c0_.position AS position_2,
  c1_.id AS id_3,
  c1_.texts AS texts_4,
  c1_.position AS position_5,
  c1_.destination AS destination_6,
  c1_.route_name AS route_name_7,
  c1_.external_url AS external_url_8,
  c1_.fragment AS fragment_9,
  c0_.footer_id AS footer_id_10,
  c1_.column_id AS column_id_11
FROM
  content_footer_columns c0_
  LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id
ORDER BY
  c0_.position ASC,
  c1_.position ASC

SELECT c0_.id AS id_0, c0_.texts AS texts_1, c0_.position AS position_2, c1_.id AS id_3, c1_.texts AS texts_4, c1_.position AS position_5, c1_.destination AS destination_6, c1_.route_name AS route_name_7, c1_.external_url AS external_url_8, c1_.fragment AS fragment_9, c0_.footer_id AS footer_id_10, c1_.column_id AS column_id_11 FROM content_footer_columns c0_ LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id ORDER BY c0_.position ASC, c1_.position 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\Content\Infrastructure\Persistence\Doctrine\DoctrineFooterColumnRepository->findOrdered (line 31)
7	App\Content\Application\GetFooter\GetFooterSettings->__invoke (line 26)
8	App\Content\Infrastructure\Twig\FooterTwigExtension->getFooterContext (line 28)
9	__TwigTemplate_702b8dfe61f5d6b4f2c6615ec7eb9a3f->doDisplay (line 52)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_2bbaad7e7928e57e1d02c86f2c8dfaeb->block_footer (line 701)
12	Twig\Template->yieldBlock (line 458)
13	__TwigTemplate_2bbaad7e7928e57e1d02c86f2c8dfaeb->doDisplay (line 413)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_021a91a1d80edce6d646042b01af6619->doDisplay (line 57)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
24	App\UI\Transform\Controller\ShowTransformController->__invoke (line 34)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
27	Symfony\Component\HttpKernel\Kernel->handle (line 143)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	require_once (line 5)

0.43 ms
(15.06%)

SELECT t0.id AS id_1, t0.icon_key AS icon_key_2, t0.url AS url_3, t0.label AS label_4, t0.position AS position_5, t0.footer_id AS footer_id_6 FROM content_footer_social_links t0 WHERE t0.footer_id = ? ORDER BY t0.position ASC

Parameters:

[
  b"\x01 úH…–wà¶\x01Ç\x07?£hè"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.icon_key AS icon_key_2,
  t0.url AS url_3,
  t0.label AS label_4,
  t0.position AS position_5,
  t0.footer_id AS footer_id_6
FROM
  content_footer_social_links t0
WHERE
  t0.footer_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.icon_key AS icon_key_2, t0.url AS url_3, t0.label AS label_4, t0.position AS position_5, t0.footer_id AS footer_id_6 FROM content_footer_social_links t0 WHERE t0.footer_id = 0x01A0FA48859677E0B601C7073FA368E8 ORDER BY t0.position ASC;

#	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 2746)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1281)
9	__TwigTemplate_702b8dfe61f5d6b4f2c6615ec7eb9a3f::doDisplay (line 139)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_2bbaad7e7928e57e1d02c86f2c8dfaeb->block_footer (line 701)
12	Twig\Template->yieldBlock (line 458)
13	__TwigTemplate_2bbaad7e7928e57e1d02c86f2c8dfaeb->doDisplay (line 413)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_021a91a1d80edce6d646042b01af6619->doDisplay (line 57)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
24	App\UI\Transform\Controller\ShowTransformController->__invoke (line 34)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
27	Symfony\Component\HttpKernel\Kernel->handle (line 143)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	require_once (line 5)

0.35 ms
(12.23%)

SELECT t0.id AS id_1, t0.texts AS texts_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4 FROM content_footer_settings t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.texts AS texts_2,
  t0.contact_email AS contact_email_3,
  t0.contact_phone AS contact_phone_4
FROM
  content_footer_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.texts AS texts_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4 FROM content_footer_settings t0 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Content\Infrastructure\Persistence\Doctrine\DoctrineFooterSettingsRepository->findOrCreate (line 22)
5	App\Content\Application\GetFooter\GetFooterSettings->__invoke (line 25)
6	App\Content\Infrastructure\Twig\FooterTwigExtension->getFooterContext (line 28)
7	__TwigTemplate_702b8dfe61f5d6b4f2c6615ec7eb9a3f->doDisplay (line 52)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_2bbaad7e7928e57e1d02c86f2c8dfaeb->block_footer (line 701)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_2bbaad7e7928e57e1d02c86f2c8dfaeb->doDisplay (line 413)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_021a91a1d80edce6d646042b01af6619->doDisplay (line 57)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
22	App\UI\Transform\Controller\ShowTransformController->__invoke (line 34)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
25	Symfony\Component\HttpKernel\Kernel->handle (line 143)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	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\Content\Domain\FooterLink	15
App\Content\Domain\Block	8
App\Content\Domain\FooterColumn	5
App\Content\Domain\FooterSocialLink	3
App\Content\Domain\LegalDocument	2
App\Content\Domain\PageContent	1
App\Content\Domain\FooterSettings	1

Entities Mapping

Class	Mapping errors
App\Content\Domain\PageContent	No errors.
App\Content\Domain\Link	No errors.
App\Content\Domain\Block	No errors.
App\Content\Domain\HeroBlock	No errors.
App\Content\Domain\TextBlock	No errors.
App\Content\Domain\ImageStripBlock	No errors.
App\Content\Domain\CardsBlock	No errors.
App\Content\Domain\BannerBlock	No errors.
App\Content\Domain\CarouselBlock	No errors.
App\Content\Domain\LogoRowBlock	No errors.
App\Content\Domain\NewsletterBlock	No errors.
App\Content\Domain\QuestionnairesBlock	No errors.
App\Content\Domain\ContactBannerBlock	No errors.
App\Content\Domain\InstructorsGridBlock	No errors.
App\Content\Domain\StaticProgramsBlock	No errors.
App\Content\Domain\FooterSettings	No errors.
App\Content\Domain\FooterSocialLink	No errors.
App\Content\Domain\FooterColumn	No errors.
App\Content\Domain\FooterLink	No errors.
App\Content\Domain\LegalDocument	No errors.

GET https://clinical-talent.isdeveloping.com/ca/transformar

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping