Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

19.94 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

18.79 ms

SELECT c0_.`key` AS key_0, c0_.value AS value_1, c0_.`group` AS group_2, c0_.type AS type_3 FROM `configuration` c0_ WHERE LOWER(c0_.`key`) LIKE LOWER(?)

Parameters:

[
  "bandeau"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.`key` AS key_0,
  c0_.value AS value_1,
  c0_.`group` AS group_2,
  c0_.type AS type_3
FROM
  `configuration` c0_
WHERE
  LOWER(c0_.`key`) LIKE LOWER(?)

SELECT c0_.`key` AS key_0, c0_.value AS value_1, c0_.`group` AS group_2, c0_.type AS type_3 FROM `configuration` c0_ WHERE LOWER(c0_.`key`) LIKE LOWER('bandeau');

#	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 35)
7	App\Domain\Configuration\Repository\ConfigurationRepository->findConfig (line 25)
8	App\Service\ConfigService->getConfigValue (line 32)
9	App\Service\ConfigService->getPathImg (line 128)
10	App\Domain\User\Controller\RegistrationController->register (line 183)
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)

0.81 ms

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.path AS path_2, m0_.slug AS slug_3, m0_.label AS label_4, m0_.position AS position_5, m0_.role AS role_6, m1_.id AS id_7, m1_.name AS name_8, m1_.path AS path_9, m1_.slug AS slug_10, m1_.label AS label_11, m1_.position AS position_12, m1_.role AS role_13, m0_.parent_id AS parent_id_14, m1_.parent_id AS parent_id_15 FROM menu m0_ LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id WHERE m0_.role IS NULL OR m0_.role IN (NULL) ORDER BY m0_.parent_id ASC, m0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.path AS path_2,
  m0_.slug AS slug_3,
  m0_.label AS label_4,
  m0_.position AS position_5,
  m0_.role AS role_6,
  m1_.id AS id_7,
  m1_.name AS name_8,
  m1_.path AS path_9,
  m1_.slug AS slug_10,
  m1_.label AS label_11,
  m1_.position AS position_12,
  m1_.role AS role_13,
  m0_.parent_id AS parent_id_14,
  m1_.parent_id AS parent_id_15
FROM
  menu m0_
  LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id
WHERE
  m0_.role IS NULL
  OR m0_.role IN (NULL)
ORDER BY
  m0_.parent_id ASC,
  m0_.id ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.path AS path_2, m0_.slug AS slug_3, m0_.label AS label_4, m0_.position AS position_5, m0_.role AS role_6, m1_.id AS id_7, m1_.name AS name_8, m1_.path AS path_9, m1_.slug AS slug_10, m1_.label AS label_11, m1_.position AS position_12, m1_.role AS role_13, m0_.parent_id AS parent_id_14, m1_.parent_id AS parent_id_15 FROM menu m0_ LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id WHERE m0_.role IS NULL OR m0_.role IN (NULL) ORDER BY m0_.parent_id ASC, m0_.id 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 47)
7	App\Domain\Menu\Repository\MenuRepository->FindMenusByRoles (line 78)
8	App\Service\MenuService->fetchMenusFromDatabase (line 69)
9	App\Service\MenuService->{closure:App\Service\MenuService::getMenusForRoles():63} (line 47)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():44} (line 111)
11	Symfony\Component\Cache\LockRegistry::compute (line 102)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 52)
16	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 63)
17	App\Service\MenuService->getMenusForRoles (line 35)
18	App\Twig\MenuExtension->getMenus (line 61)
19	__TwigTemplate_aa92235c23d8eb0acb8b5d9639590fb1->doDisplay (line 402)
20	Twig\Template->yield (line 129)
21	__TwigTemplate_18fdfe86d8dbecc5810141c55c2aeeb1->doDisplay (line 402)
22	Twig\Template->yield (line 57)
23	__TwigTemplate_0a1481de5da054d73a5afb6b2edbcb01->doDisplay (line 402)
24	Twig\Template->yield (line 358)
25	Twig\Template->display (line 373)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 333)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 124)
32	App\Domain\User\Controller\RegistrationController->register (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

0.35 ms

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.path AS path_2, m0_.slug AS slug_3, m0_.label AS label_4, m0_.position AS position_5, m0_.role AS role_6, m0_.parent_id AS parent_id_7 FROM menu m0_ WHERE m0_.slug = ?

Parameters:

[
  "register"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.path AS path_2,
  m0_.slug AS slug_3,
  m0_.label AS label_4,
  m0_.position AS position_5,
  m0_.role AS role_6,
  m0_.parent_id AS parent_id_7
FROM
  menu m0_
WHERE
  m0_.slug = ?

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.path AS path_2, m0_.slug AS slug_3, m0_.label AS label_4, m0_.position AS position_5, m0_.role AS role_6, m0_.parent_id AS parent_id_7 FROM menu m0_ WHERE m0_.slug = 'register';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 56)
7	App\Domain\Menu\Repository\MenuRepository->findLabelMenu (line 44)
8	App\Service\BreadcrumbService->addAllBreadcrumb (line 64)
9	App\Service\BreadcrumbService->getBreadcrumb (line 35)
10	App\Twig\breadcrumbExtension->getBreadcrumb (line 54)
11	__TwigTemplate_63ca6514078d6689d2fa7c826d61210d->doDisplay (line 402)
12	Twig\Template->yield (line 144)
13	__TwigTemplate_18fdfe86d8dbecc5810141c55c2aeeb1->doDisplay (line 402)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_0a1481de5da054d73a5afb6b2edbcb01->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 124)
24	App\Domain\User\Controller\RegistrationController->register (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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

Entities Mapping

Class	Mapping errors
App\Domain\Configuration\Entity\Configuration	No errors.
App\Domain\Menu\Entity\Menu	No errors.

Symfony Profiler

GET https://api.jmwebconcept.fr/register

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping