Symfony Profiler

Query Metrics

12 Database Queries

7 Different statements

6.20 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.49 ms
(40.07%)

WITH RECURSIVE ancestors AS (
                SELECT id, parent_id, name, path, slug, label, position, target,
                    lockable, roles_acl, roles_menu, displayable, positionabsolute, actif
                FROM menu
                WHERE id = ?

                UNION ALL
                SELECT m.id, m.parent_id, m.name, m.path, m.slug, m.label, m.position, m.target,
                    m.lockable, m.roles_acl, m.roles_menu, m.displayable, m.positionabsolute, m.actif
                FROM menu m
                INNER JOIN ancestors a ON a.parent_id = m.id
            )
            SELECT *
            FROM ancestors
            ORDER BY parent_id IS NOT NULL ASC
            LIMIT 1;

Parameters:

[
  161
]

View formatted query View runnable query Explain query View query backtrace

WITH
  RECURSIVE ancestors AS (
    SELECT
      id,
      parent_id,
      name,
      path,
      slug,
      label,
      position,
      target,
      lockable,
      roles_acl,
      roles_menu,
      displayable,
      positionabsolute,
      actif
    FROM
      menu
    WHERE
      id = ?
    UNION ALL
    SELECT
      m.id,
      m.parent_id,
      m.name,
      m.path,
      m.slug,
      m.label,
      m.position,
      m.target,
      m.lockable,
      m.roles_acl,
      m.roles_menu,
      m.displayable,
      m.positionabsolute,
      m.actif
    FROM
      menu m
      INNER JOIN ancestors a ON a.parent_id = m.id
  )
SELECT
  *
FROM
  ancestors
ORDER BY
  parent_id IS NOT NULL ASC
LIMIT
  1;

WITH RECURSIVE ancestors AS (
                SELECT id, parent_id, name, path, slug, label, position, target,
                    lockable, roles_acl, roles_menu, displayable, positionabsolute, actif
                FROM menu
                WHERE id = 161

                UNION ALL
                SELECT m.id, m.parent_id, m.name, m.path, m.slug, m.label, m.position, m.target,
                    m.lockable, m.roles_acl, m.roles_menu, m.displayable, m.positionabsolute, m.actif
                FROM menu m
                INNER JOIN ancestors a ON a.parent_id = m.id
            )
            SELECT *
            FROM ancestors
            ORDER BY parent_id IS NOT NULL ASC
            LIMIT 1;
        ;

#	File/Call
1	App\Domain\Menu\Repository\MenuRepository->findRootAncestor (line 388)
2	App\Domain\Menu\Controller\MenuController->menu (line 56)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 4)

1.24 ms
(19.99%)

WITH RECURSIVE hierarchy AS (
                SELECT 
                    id, parent_id, name, path, slug, label, position, target,
                    lockable, roles_acl, roles_menu, displayable, positionabsolute, actif
                FROM menu
                WHERE id = ?

                UNION ALL

                SELECT 
                    m.id, m.parent_id, m.name, m.path, m.slug, m.label, m.position, m.target,
                    m.lockable, m.roles_acl, m.roles_menu, m.displayable, m.positionabsolute, m.actif
                FROM menu m
                INNER JOIN hierarchy h ON m.parent_id = h.id
            )
            SELECT *
            FROM hierarchy
            WHERE displayable = 1
            ORDER BY position ASC;

Parameters:

[
  150
]

View formatted query View runnable query Explain query View query backtrace

WITH
  RECURSIVE hierarchy AS (
    SELECT
      id,
      parent_id,
      name,
      path,
      slug,
      label,
      position,
      target,
      lockable,
      roles_acl,
      roles_menu,
      displayable,
      positionabsolute,
      actif
    FROM
      menu
    WHERE
      id = ?
    UNION ALL
    SELECT
      m.id,
      m.parent_id,
      m.name,
      m.path,
      m.slug,
      m.label,
      m.position,
      m.target,
      m.lockable,
      m.roles_acl,
      m.roles_menu,
      m.displayable,
      m.positionabsolute,
      m.actif
    FROM
      menu m
      INNER JOIN hierarchy h ON m.parent_id = h.id
  )
SELECT
  *
FROM
  hierarchy
WHERE
  displayable = 1
ORDER BY
  position ASC;

WITH RECURSIVE hierarchy AS (
                SELECT 
                    id, parent_id, name, path, slug, label, position, target,
                    lockable, roles_acl, roles_menu, displayable, positionabsolute, actif
                FROM menu
                WHERE id = 150

                UNION ALL

                SELECT 
                    m.id, m.parent_id, m.name, m.path, m.slug, m.label, m.position, m.target,
                    m.lockable, m.roles_acl, m.roles_menu, m.displayable, m.positionabsolute, m.actif
                FROM menu m
                INNER JOIN hierarchy h ON m.parent_id = h.id
            )
            SELECT *
            FROM hierarchy
            WHERE displayable = 1
            ORDER BY position ASC;
        ;

#	File/Call
1	App\Domain\Menu\Repository\MenuRepository->findRecursiveMenus (line 278)
2	App\Service\MenuService->getSubMenuById (line 205)
3	App\Domain\Menu\Controller\MenuController->menu (line 57)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 4)

1.10 ms
(17.68%)

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = ? LIMIT 1

Parameters:

[
  "isAclDisplaySynced"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2,
  t0.`group` AS group_3,
  t0.type AS type_4,
  t0.comment AS comment_5
FROM
  `configuration` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = 'isAclDisplaySynced' 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\ConfigurationService->getValueByType (line 33)
5	App\Service\MenuService->getEffectiveRoles (line 38)
6	App\Domain\Menu\Security\ActionPermissionChecker->canAccess (line 47)
7	App\Domain\User\Security\Voter\ACLRouteVoter->voteOnAttribute (line 29)
8	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
9	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
10	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
11	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
13	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
14	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
15	Symfony\Bundle\SecurityBundle\Security->isGranted (line 65)
16	App\EventSubscriber\AccessSubscriber->onController (line 75)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 4)

0.44 ms
(7.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.slug AS slug_4, t0.label AS label_5, t0.position AS position_6, t0.target AS target_7, t0.lockable AS lockable_8, t0.menu_item AS menu_item_9, t0.roles_acl AS roles_acl_10, t0.roles_menu AS roles_menu_11, t0.displayable AS displayable_12, t0.positionabsolute AS positionabsolute_13, t0.actif AS actif_14, t0.allow_writing AS allow_writing_15, t0.allow_deleting AS allow_deleting_16, t0.allow_validating AS allow_validating_17, t0.parent_id AS parent_id_18 FROM menu t0 WHERE t0.path = ? AND t0.actif = ? LIMIT 1

Parameters:

[
  "api_menu"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.slug AS slug_4,
  t0.label AS label_5,
  t0.position AS position_6,
  t0.target AS target_7,
  t0.lockable AS lockable_8,
  t0.menu_item AS menu_item_9,
  t0.roles_acl AS roles_acl_10,
  t0.roles_menu AS roles_menu_11,
  t0.displayable AS displayable_12,
  t0.positionabsolute AS positionabsolute_13,
  t0.actif AS actif_14,
  t0.allow_writing AS allow_writing_15,
  t0.allow_deleting AS allow_deleting_16,
  t0.allow_validating AS allow_validating_17,
  t0.parent_id AS parent_id_18
FROM
  menu t0
WHERE
  t0.path = ?
  AND t0.actif = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.slug AS slug_4, t0.label AS label_5, t0.position AS position_6, t0.target AS target_7, t0.lockable AS lockable_8, t0.menu_item AS menu_item_9, t0.roles_acl AS roles_acl_10, t0.roles_menu AS roles_menu_11, t0.displayable AS displayable_12, t0.positionabsolute AS positionabsolute_13, t0.actif AS actif_14, t0.allow_writing AS allow_writing_15, t0.allow_deleting AS allow_deleting_16, t0.allow_validating AS allow_validating_17, t0.parent_id AS parent_id_18 FROM menu t0 WHERE t0.path = 'api_menu' AND t0.actif = 1 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Domain\Menu\Security\ActionPermissionChecker->canAccess (line 41)
5	App\Domain\User\Security\Voter\ACLRouteVoter->voteOnAttribute (line 29)
6	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
7	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
8	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
9	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
10	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
11	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
12	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
13	Symfony\Bundle\SecurityBundle\Security->isGranted (line 65)
14	App\EventSubscriber\AccessSubscriber->onController (line 75)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 4)

0.38 ms
(6.14%)

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.mail AS mail_7, t0.is_verified AS is_verified_8, t0.failed_login_count AS failed_login_count_9, t0.last_failed_login_at AS last_failed_login_at_10, t0.last_login_at AS last_login_at_11, t0.is_validated AS is_validated_12, t0.token AS token_13 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.mail AS mail_7,
  t0.is_verified AS is_verified_8,
  t0.failed_login_count AS failed_login_count_9,
  t0.last_failed_login_at AS last_failed_login_at_10,
  t0.last_login_at AS last_login_at_11,
  t0.is_validated AS is_validated_12,
  t0.token AS token_13
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.mail AS mail_7, t0.is_verified AS is_verified_8, t0.failed_login_count AS failed_login_count_9, t0.last_failed_login_at AS last_failed_login_at_10, t0.last_login_at AS last_login_at_11, t0.is_validated AS is_validated_12, t0.token AS token_13 FROM `user` t0 WHERE t0.id = 3;

#	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\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 4)

0.28 ms
(4.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.slug AS slug_4, t0.label AS label_5, t0.position AS position_6, t0.target AS target_7, t0.lockable AS lockable_8, t0.menu_item AS menu_item_9, t0.roles_acl AS roles_acl_10, t0.roles_menu AS roles_menu_11, t0.displayable AS displayable_12, t0.positionabsolute AS positionabsolute_13, t0.actif AS actif_14, t0.allow_writing AS allow_writing_15, t0.allow_deleting AS allow_deleting_16, t0.allow_validating AS allow_validating_17, t0.parent_id AS parent_id_18 FROM menu t0 WHERE t0.id = ?

Parameters:

[
  "161"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.slug AS slug_4,
  t0.label AS label_5,
  t0.position AS position_6,
  t0.target AS target_7,
  t0.lockable AS lockable_8,
  t0.menu_item AS menu_item_9,
  t0.roles_acl AS roles_acl_10,
  t0.roles_menu AS roles_menu_11,
  t0.displayable AS displayable_12,
  t0.positionabsolute AS positionabsolute_13,
  t0.actif AS actif_14,
  t0.allow_writing AS allow_writing_15,
  t0.allow_deleting AS allow_deleting_16,
  t0.allow_validating AS allow_validating_17,
  t0.parent_id AS parent_id_18
FROM
  menu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.slug AS slug_4, t0.label AS label_5, t0.position AS position_6, t0.target AS target_7, t0.lockable AS lockable_8, t0.menu_item AS menu_item_9, t0.roles_acl AS roles_acl_10, t0.roles_menu AS roles_menu_11, t0.displayable AS displayable_12, t0.positionabsolute AS positionabsolute_13, t0.actif AS actif_14, t0.allow_writing AS allow_writing_15, t0.allow_deleting AS allow_deleting_16, t0.allow_validating AS allow_validating_17, t0.parent_id AS parent_id_18 FROM menu t0 WHERE t0.id = '161';

#	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 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 4)

0.28 ms
(4.48%)

SELECT t0.id AS id_1, t0.year AS year_2, t0.datestart AS datestart_3, t0.dateend AS dateend_4, t0.comment AS comment_5, t0.statut_close AS statut_close_6, t0.statut_lock AS statut_lock_7, t0.locked_at AS locked_at_8, t0.closed_at AS closed_at_9 FROM accounting_year t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.datestart AS datestart_3,
  t0.dateend AS dateend_4,
  t0.comment AS comment_5,
  t0.statut_close AS statut_close_6,
  t0.statut_lock AS statut_lock_7,
  t0.locked_at AS locked_at_8,
  t0.closed_at AS closed_at_9
FROM
  accounting_year t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.year AS year_2, t0.datestart AS datestart_3, t0.dateend AS dateend_4, t0.comment AS comment_5, t0.statut_close AS statut_close_6, t0.statut_lock AS statut_lock_7, t0.locked_at AS locked_at_8, t0.closed_at AS closed_at_9 FROM accounting_year t0 WHERE t0.id = 3;

#	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	App\Service\CurrentAccountingYear->get (line 17)
7	App\EventSubscriber\CurrentYearGuardSubscriber->onKernelRequest (line 18)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 4)

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\Domain\Menu\Entity\Menu	3
App\Domain\User\Entity\User	1
App\Domain\AccountingYear\Entity\AccountingYear	1
App\Domain\SiteConfiguration\Entity\SiteConfiguration	1

Entities Mapping

Class	Mapping errors
App\Domain\User\Entity\User	No errors.
App\Domain\User\Entity\LoginLog	No errors.
App\Domain\JournalEntry\Entity\JournalEntry	No errors.
App\Domain\JournalEntryLine\Entity\JournalEntryLine	No errors.
App\Domain\AccountingYear\Entity\AccountingYear	No errors.
App\Domain\RepartitionKey\Entity\RepartitionKey	No errors.
App\Domain\Menu\Entity\Menu	No errors.
App\Domain\SiteConfiguration\Entity\SiteConfiguration	No errors.

Symfony Profiler

GET https://compta.eschenlauer.fr/api/menu/161

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping