Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

1 Different statements

20.30 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

15.18 ms

SELECT a0_.id AS id_0, a0_.libelle AS libelle_1, a0_.lft AS lft_2, a0_.rgt AS rgt_3, a0_.root AS root_4, a0_.lvl AS lvl_5, a0_.icon AS icon_6, a0_.route AS route_7, a0_.role AS role_8, a0_.parent_id AS parent_id_9 FROM app_menu a0_ WHERE a0_.route = ? AND a0_.lft + 1 = a0_.rgt LIMIT 1

Parameters:

[
  "app_reset_password_request"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.libelle AS libelle_1,
  a0_.lft AS lft_2,
  a0_.rgt AS rgt_3,
  a0_.root AS root_4,
  a0_.lvl AS lvl_5,
  a0_.icon AS icon_6,
  a0_.route AS route_7,
  a0_.role AS role_8,
  a0_.parent_id AS parent_id_9
FROM
  app_menu a0_
WHERE
  a0_.route = ?
  AND a0_.lft + 1 = a0_.rgt
LIMIT
  1

SELECT a0_.id AS id_0, a0_.libelle AS libelle_1, a0_.lft AS lft_2, a0_.rgt AS rgt_3, a0_.root AS root_4, a0_.lvl AS lvl_5, a0_.icon AS icon_6, a0_.route AS route_7, a0_.role AS role_8, a0_.parent_id AS parent_id_9 FROM app_menu a0_ WHERE a0_.route = 'app_reset_password_request' AND a0_.lft + 1 = a0_.rgt LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 31)
7	App\Repository\MenuTreeRepository->findOneLeafByRoute (line 190)
8	App\Component\TwigExtension\MenuBuilder->App\Component\TwigExtension\{closure} (line 113)
9	Symfony\Component\Cache\LockRegistry::compute (line 98)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 72)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 81)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 35)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 182)
14	App\Component\TwigExtension\MenuBuilder->getCachedBreadcrumb (line 114)
15	App\Component\TwigExtension\MenuBuilder->createMenu (line 55)
16	__TwigTemplate_f091905c369d948b82cc0134497ae637->doDisplay (line 393)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_b7b6b325595ef736611cf5a003304d00->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 258)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
26	App\Controller\ResetPasswordController->request (line 163)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
29	Symfony\Component\HttpKernel\Kernel->handle (line 20)

1.71 ms

SELECT a0_.id AS id_0, a0_.libelle AS libelle_1, a0_.lft AS lft_2, a0_.rgt AS rgt_3, a0_.root AS root_4, a0_.lvl AS lvl_5, a0_.icon AS icon_6, a0_.route AS route_7, a0_.role AS role_8, a0_.parent_id AS parent_id_9 FROM app_menu a0_ WHERE a0_.route = ? AND a0_.lft + 1 = a0_.rgt LIMIT 1

Parameters:

[
  "app_reset_password_index"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.libelle AS libelle_1,
  a0_.lft AS lft_2,
  a0_.rgt AS rgt_3,
  a0_.root AS root_4,
  a0_.lvl AS lvl_5,
  a0_.icon AS icon_6,
  a0_.route AS route_7,
  a0_.role AS role_8,
  a0_.parent_id AS parent_id_9
FROM
  app_menu a0_
WHERE
  a0_.route = ?
  AND a0_.lft + 1 = a0_.rgt
LIMIT
  1

SELECT a0_.id AS id_0, a0_.libelle AS libelle_1, a0_.lft AS lft_2, a0_.rgt AS rgt_3, a0_.root AS root_4, a0_.lvl AS lvl_5, a0_.icon AS icon_6, a0_.route AS route_7, a0_.role AS role_8, a0_.parent_id AS parent_id_9 FROM app_menu a0_ WHERE a0_.route = 'app_reset_password_index' AND a0_.lft + 1 = a0_.rgt LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 31)
7	App\Repository\MenuTreeRepository->findOneLeafByRoute (line 193)
8	App\Component\TwigExtension\MenuBuilder->App\Component\TwigExtension\{closure} (line 113)
9	Symfony\Component\Cache\LockRegistry::compute (line 98)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 72)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 81)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 35)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 182)
14	App\Component\TwigExtension\MenuBuilder->getCachedBreadcrumb (line 114)
15	App\Component\TwigExtension\MenuBuilder->createMenu (line 55)
16	__TwigTemplate_f091905c369d948b82cc0134497ae637->doDisplay (line 393)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_b7b6b325595ef736611cf5a003304d00->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 258)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
26	App\Controller\ResetPasswordController->request (line 163)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
29	Symfony\Component\HttpKernel\Kernel->handle (line 20)

1.69 ms

SELECT a0_.id AS id_0, a0_.libelle AS libelle_1, a0_.lft AS lft_2, a0_.rgt AS rgt_3, a0_.root AS root_4, a0_.lvl AS lvl_5, a0_.icon AS icon_6, a0_.route AS route_7, a0_.role AS role_8, a0_.parent_id AS parent_id_9 FROM app_menu a0_ WHERE a0_.route = ? AND a0_.lft + 1 = a0_.rgt LIMIT 1

Parameters:

[
  "app_reset_password_request"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.libelle AS libelle_1,
  a0_.lft AS lft_2,
  a0_.rgt AS rgt_3,
  a0_.root AS root_4,
  a0_.lvl AS lvl_5,
  a0_.icon AS icon_6,
  a0_.route AS route_7,
  a0_.role AS role_8,
  a0_.parent_id AS parent_id_9
FROM
  app_menu a0_
WHERE
  a0_.route = ?
  AND a0_.lft + 1 = a0_.rgt
LIMIT
  1

SELECT a0_.id AS id_0, a0_.libelle AS libelle_1, a0_.lft AS lft_2, a0_.rgt AS rgt_3, a0_.root AS root_4, a0_.lvl AS lvl_5, a0_.icon AS icon_6, a0_.route AS route_7, a0_.role AS role_8, a0_.parent_id AS parent_id_9 FROM app_menu a0_ WHERE a0_.route = 'app_reset_password_request' AND a0_.lft + 1 = a0_.rgt LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 31)
7	App\Repository\MenuTreeRepository->findOneLeafByRoute (line 247)
8	App\Component\TwigExtension\MenuBuilder->App\Component\TwigExtension\{closure} (line 113)
9	Symfony\Component\Cache\LockRegistry::compute (line 98)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 72)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 81)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 35)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 242)
14	App\Component\TwigExtension\MenuBuilder->getCachedButtons (line 117)
15	App\Component\TwigExtension\MenuBuilder->createMenu (line 326)
16	__TwigTemplate_f091905c369d948b82cc0134497ae637->block_buttons (line 437)
17	Twig\Template->yieldBlock (line 142)
18	__TwigTemplate_f091905c369d948b82cc0134497ae637->doDisplay (line 393)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_b7b6b325595ef736611cf5a003304d00->doDisplay (line 393)
21	Twig\Template->yield (line 349)
22	Twig\Template->display (line 364)
23	Twig\Template->render (line 35)
24	Twig\TemplateWrapper->render (line 306)
25	Twig\Environment->render (line 258)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
28	App\Controller\ResetPasswordController->request (line 163)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
31	Symfony\Component\HttpKernel\Kernel->handle (line 20)

1.72 ms

SELECT a0_.id AS id_0, a0_.libelle AS libelle_1, a0_.lft AS lft_2, a0_.rgt AS rgt_3, a0_.root AS root_4, a0_.lvl AS lvl_5, a0_.icon AS icon_6, a0_.route AS route_7, a0_.role AS role_8, a0_.parent_id AS parent_id_9 FROM app_menu a0_ WHERE a0_.route = ? AND a0_.lft + 1 = a0_.rgt LIMIT 1

Parameters:

[
  "app_reset_password_index"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.libelle AS libelle_1,
  a0_.lft AS lft_2,
  a0_.rgt AS rgt_3,
  a0_.root AS root_4,
  a0_.lvl AS lvl_5,
  a0_.icon AS icon_6,
  a0_.route AS route_7,
  a0_.role AS role_8,
  a0_.parent_id AS parent_id_9
FROM
  app_menu a0_
WHERE
  a0_.route = ?
  AND a0_.lft + 1 = a0_.rgt
LIMIT
  1

SELECT a0_.id AS id_0, a0_.libelle AS libelle_1, a0_.lft AS lft_2, a0_.rgt AS rgt_3, a0_.root AS root_4, a0_.lvl AS lvl_5, a0_.icon AS icon_6, a0_.route AS route_7, a0_.role AS role_8, a0_.parent_id AS parent_id_9 FROM app_menu a0_ WHERE a0_.route = 'app_reset_password_index' AND a0_.lft + 1 = a0_.rgt LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 31)
7	App\Repository\MenuTreeRepository->findOneLeafByRoute (line 252)
8	App\Component\TwigExtension\MenuBuilder->App\Component\TwigExtension\{closure} (line 113)
9	Symfony\Component\Cache\LockRegistry::compute (line 98)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 72)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 81)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 35)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 242)
14	App\Component\TwigExtension\MenuBuilder->getCachedButtons (line 117)
15	App\Component\TwigExtension\MenuBuilder->createMenu (line 326)
16	__TwigTemplate_f091905c369d948b82cc0134497ae637->block_buttons (line 437)
17	Twig\Template->yieldBlock (line 142)
18	__TwigTemplate_f091905c369d948b82cc0134497ae637->doDisplay (line 393)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_b7b6b325595ef736611cf5a003304d00->doDisplay (line 393)
21	Twig\Template->yield (line 349)
22	Twig\Template->display (line 364)
23	Twig\Template->render (line 35)
24	Twig\TemplateWrapper->render (line 306)
25	Twig\Environment->render (line 258)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
28	App\Controller\ResetPasswordController->request (line 163)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
31	Symfony\Component\HttpKernel\Kernel->handle (line 20)

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.

Entities Mapping

Class	Mapping errors
App\Entity\MenuTree	No errors.

Symfony Profiler

http://proxidriver-back.dev.noprod.gcp.proximy.fr/reset-password

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping