Symfony Profiler

Query Metrics

22 Database Queries

4 Different statements

25.30 ms Query time

0 Invalid entities

22 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.75 ms
(66.23%)

SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.url_alias AS url_alias_0,
  a0_.id AS id_1
FROM
  activity_domain a0_
  INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id)
  INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id)
WHERE
  a0_.id = ?
LIMIT
  1

SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = 8 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\Service\EntityGetAlias->generateUrlByEntity (line 31)
7	App\Twig\AppExtension->generateUrlByEntity (line 112)
8	__TwigTemplate_f01d7fef6e4b5f5251846cbf32939011->doDisplay (line 79)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1520)
14	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e::doDisplay (line 103)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_a00ee6f4c1c1728d519d933ab1926518->doDisplay (line 57)
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 459)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
25	App\Controller\PageContentController->show (line 23)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

3.54 ms
(14.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sous_titre AS sous_titre_3, t0.description AS description_4, t0.description2 AS description2_5, t0.description3 AS description3_6, t0.class_affichable AS class_affichable_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.url_alias AS url_alias_10, t0.auto_generate_alias AS auto_generate_alias_11, t0.uuid AS uuid_12, t0.status AS status_13, t0.image_id AS image_id_14, t0.user_id AS user_id_15 FROM page_content t0 WHERE t0.id = ?

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sous_titre AS sous_titre_3,
  t0.description AS description_4,
  t0.description2 AS description2_5,
  t0.description3 AS description3_6,
  t0.class_affichable AS class_affichable_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.url_alias AS url_alias_10,
  t0.auto_generate_alias AS auto_generate_alias_11,
  t0.uuid AS uuid_12,
  t0.status AS status_13,
  t0.image_id AS image_id_14,
  t0.user_id AS user_id_15
FROM
  page_content t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sous_titre AS sous_titre_3, t0.description AS description_4, t0.description2 AS description2_5, t0.description3 AS description3_6, t0.class_affichable AS class_affichable_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.url_alias AS url_alias_10, t0.auto_generate_alias AS auto_generate_alias_11, t0.uuid AS uuid_12, t0.status AS status_13, t0.image_id AS image_id_14, t0.user_id AS user_id_15 FROM page_content t0 WHERE t0.id = '4';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

3.21 ms
(12.71%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.region AS region_2, m0_.link AS link_3, m0_.weight AS weight_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.uuid AS uuid_7, m0_.status AS status_8, m0_.user_id AS user_id_9 FROM menu_link m0_ WHERE m0_.status = ? AND m0_.region = ? ORDER BY m0_.id ASC, m0_.weight DESC

Parameters:

[
  1
  "header"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.region AS region_2,
  m0_.link AS link_3,
  m0_.weight AS weight_4,
  m0_.created_at AS created_at_5,
  m0_.updated_at AS updated_at_6,
  m0_.uuid AS uuid_7,
  m0_.status AS status_8,
  m0_.user_id AS user_id_9
FROM
  menu_link m0_
WHERE
  m0_.status = ?
  AND m0_.region = ?
ORDER BY
  m0_.id ASC,
  m0_.weight DESC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.region AS region_2, m0_.link AS link_3, m0_.weight AS weight_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.uuid AS uuid_7, m0_.status AS status_8, m0_.user_id AS user_id_9 FROM menu_link m0_ WHERE m0_.status = 1 AND m0_.region = 'header' ORDER BY m0_.id ASC, m0_.weight DESC;

#	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\MenuLinkRepository->loadLinksByRegionDisplay (line 25)
7	App\Service\EntitiesLoad->loadHeaderLinks (line 31)
8	App\Twig\AppExtension->loadHeaderLinks (line 80)
9	__TwigTemplate_256e29d11d333021db4edb894360fee5->doDisplay (line 61)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1520)
15	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e::doDisplay (line 91)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_a00ee6f4c1c1728d519d933ab1926518->doDisplay (line 57)
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 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
26	App\Controller\PageContentController->show (line 23)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

1.79 ms
(7.06%)

SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.name AS name_2, a0_.description AS description_3, a0_.icon AS icon_4, a0_.level AS level_5, a0_.url_alias AS url_alias_6, a0_.auto_generate_alias AS auto_generate_alias_7, a0_.status AS status_8, a0_.parent_id AS parent_id_9 FROM activity_domain a0_ WHERE a0_.status = ? AND a0_.parent_id IS NULL ORDER BY a0_.name ASC LIMIT 9

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.uuid AS uuid_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_.icon AS icon_4,
  a0_.level AS level_5,
  a0_.url_alias AS url_alias_6,
  a0_.auto_generate_alias AS auto_generate_alias_7,
  a0_.status AS status_8,
  a0_.parent_id AS parent_id_9
FROM
  activity_domain a0_
WHERE
  a0_.status = ?
  AND a0_.parent_id IS NULL
ORDER BY
  a0_.name ASC
LIMIT
  9

SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.name AS name_2, a0_.description AS description_3, a0_.icon AS icon_4, a0_.level AS level_5, a0_.url_alias AS url_alias_6, a0_.auto_generate_alias AS auto_generate_alias_7, a0_.status AS status_8, a0_.parent_id AS parent_id_9 FROM activity_domain a0_ WHERE a0_.status = 1 AND a0_.parent_id IS NULL ORDER BY a0_.name ASC LIMIT 9;

#	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\ActivityDomainRepository->findActiveActivityDomain (line 37)
7	App\Service\ActivityDomainLoader->getActiveDomains (line 15)
8	__TwigTemplate_f01d7fef6e4b5f5251846cbf32939011->doDisplay (line 73)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1520)
14	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e::doDisplay (line 103)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_a00ee6f4c1c1728d519d933ab1926518->doDisplay (line 57)
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 459)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
25	App\Controller\PageContentController->show (line 23)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	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\MenuLink	11
App\Entity\ActivityDomain	9
App\Entity\PageContent	1
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\PageContent	No errors.
App\Entity\Files	No errors.
App\Entity\User	No errors.
App\Entity\MenuLink	No errors.
App\Entity\ActivityDomain	No errors.
App\Entity\Prestataire	No errors.
App\Entity\Prestation	No errors.
App\Entity\AppelOffre	No errors.
App\Entity\EntityUrlAlias	No errors.
App\Entity\EntityTypeAlias	No errors.

Symfony Profiler

GET https://preprod.linko.ci/page/4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping