Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

2.48 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.97 ms
(39.01%)

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_ea621a8379b191f2362bea1655df1c64->doDisplay (line 56)
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\Identity\Controller\ForgotPasswordController->__invoke (line 55)
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)

0.75 ms
(30.32%)

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_ea621a8379b191f2362bea1655df1c64->doDisplay (line 56)
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\Identity\Controller\ForgotPasswordController->__invoke (line 55)
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.45 ms
(18.27%)

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_ea621a8379b191f2362bea1655df1c64->doDisplay (line 56)
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\Identity\Controller\ForgotPasswordController->__invoke (line 55)
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.31 ms
(12.40%)

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_ea621a8379b191f2362bea1655df1c64->doDisplay (line 56)
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\Identity\Controller\ForgotPasswordController->__invoke (line 55)
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)

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\FooterColumn	5
App\Content\Domain\FooterSocialLink	3
App\Content\Domain\LegalDocument	2
App\Content\Domain\FooterSettings	1

Entities Mapping

Class	Mapping errors
App\Content\Domain\FooterSettings	No errors.
App\Content\Domain\FooterSocialLink	No errors.
App\Content\Domain\FooterColumn	No errors.
App\Content\Domain\Link	No errors.
App\Content\Domain\FooterLink	No errors.
App\Content\Domain\LegalDocument	No errors.

GET https://clinical-talent.isdeveloping.com/ca/recuperar-contrasenya

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping