Symfony Profiler

Query Metrics

21 Database Queries

3 Different statements

16.60 ms Query time

0 Invalid entities

21 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.62 ms
(63.95%)

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_25d7c0a8cb29cc0e8cbd33d0fd74a92c->doDisplay (line 58)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_b1e242883768c9c6e1458f6d326335b4->doDisplay (line 54)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
27	App\Controller\UserSecurityController->login (line 42)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

3.73 ms
(22.47%)

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_25d7c0a8cb29cc0e8cbd33d0fd74a92c->doDisplay (line 58)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_b1e242883768c9c6e1458f6d326335b4->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\UserSecurityController->login (line 42)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

2.25 ms
(13.58%)

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_25d7c0a8cb29cc0e8cbd33d0fd74a92c->doDisplay (line 58)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_b1e242883768c9c6e1458f6d326335b4->doDisplay (line 54)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
27	App\Controller\UserSecurityController->login (line 42)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	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\User	1

Entities Mapping

Class	Mapping errors
App\Entity\MenuLink	No errors.
App\Entity\User	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/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping