Symfony Profiler

Query Metrics

259 Database Queries

4 Different statements

760.69 ms Query time

0 Invalid entities

853 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

742.83 ms
(97.65%)

253

SELECT t0.id AS id_1, t0.role AS role_2, t0.label AS label_3, t0.type AS type_4, t0.section AS section_5, t0.visible AS visible_6, t0.status_list AS status_list_7, t0.created_at AS created_at_8 FROM lle_credential_credential t0 WHERE t0.id = ?

Parameters:

[
  53717
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.section AS section_5,
  t0.visible AS visible_6,
  t0.status_list AS status_list_7,
  t0.created_at AS created_at_8
FROM
  lle_credential_credential t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.label AS label_3, t0.type AS type_4, t0.section AS section_5, t0.visible AS visible_6, t0.status_list AS status_list_7, t0.created_at AS created_at_8 FROM lle_credential_credential t0 WHERE t0.id = 53717;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\Lle\CredentialBundle\Entity\Credential::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Lle\CredentialBundle\Entity\Credential->__get (line 153)
7	Lle\CredentialBundle\Entity\Credential->getRole (line 60)
8	Lle\CredentialBundle\Security\CredentialVoter->__construct (line 32)
9	Container5CrjO0A\getCredentialVoterService->do (line 38)
10	Container5CrjO0A\App_KernelDevDebugContainer::load (line 773)
11	Container5CrjO0A\App_KernelDevDebugContainer->{closure:Container5CrjO0A\App_KernelDevDebugContainer::getDebug_Security_Access_DecisionManagerService():2046} (line 2051)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager::getVoters (line 115)
13	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 87)
14	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
15	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
16	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
17	Symfony\Component\Security\Http\Firewall\AccessListener->authenticate (line 78)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
30	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
34	Symfony\Component\HttpKernel\Kernel->handle (line 179)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

10.93 ms
(1.44%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_role AS is_role_3, t0.active AS active_4, t0.required_role AS required_role_5, t0.rank AS rank_6, t0.label AS label_7 FROM lle_credential_group t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_role AS is_role_3,
  t0.active AS active_4,
  t0.required_role AS required_role_5,
  t0.rank AS rank_6,
  t0.label AS label_7
FROM
  lle_credential_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_role AS is_role_3, t0.active AS active_4, t0.required_role AS required_role_5, t0.rank AS rank_6, t0.label AS label_7 FROM lle_credential_group t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\Lle\CredentialBundle\Entity\Group::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Lle\CredentialBundle\Entity\Group->__get (line 153)
7	Lle\CredentialBundle\Entity\Group->getName (line 93)
8	Lle\CredentialBundle\Security\CredentialVoter->__construct (line 31)
9	Container5CrjO0A\getCredentialVoterService->do (line 38)
10	Container5CrjO0A\App_KernelDevDebugContainer::load (line 773)
11	Container5CrjO0A\App_KernelDevDebugContainer->{closure:Container5CrjO0A\App_KernelDevDebugContainer::getDebug_Security_Access_DecisionManagerService():2046} (line 2051)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager::getVoters (line 115)
13	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 87)
14	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
15	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
16	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
17	Symfony\Component\Security\Http\Firewall\AccessListener->authenticate (line 78)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
30	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
34	Symfony\Component\HttpKernel\Kernel->handle (line 179)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

3.68 ms
(0.48%)

SELECT t0.id AS id_1, t0.allowed AS allowed_2, t0.status_allowed AS status_allowed_3, t0.credential_id AS credential_id_4, t0.groupe_id AS groupe_id_5 FROM lle_credential_group_credential t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.allowed AS allowed_2,
  t0.status_allowed AS status_allowed_3,
  t0.credential_id AS credential_id_4,
  t0.groupe_id AS groupe_id_5
FROM
  lle_credential_group_credential t0

SELECT t0.id AS id_1, t0.allowed AS allowed_2, t0.status_allowed AS status_allowed_3, t0.credential_id AS credential_id_4, t0.groupe_id AS groupe_id_5 FROM lle_credential_group_credential t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	Lle\CredentialBundle\Security\CredentialVoter->__construct (line 26)
5	Container5CrjO0A\getCredentialVoterService->do (line 38)
6	Container5CrjO0A\App_KernelDevDebugContainer::load (line 773)
7	Container5CrjO0A\App_KernelDevDebugContainer->{closure:Container5CrjO0A\App_KernelDevDebugContainer::getDebug_Security_Access_DecisionManagerService():2046} (line 2051)
8	Symfony\Component\Security\Core\Authorization\AccessDecisionManager::getVoters (line 115)
9	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 87)
10	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
11	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
12	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
13	Symfony\Component\Security\Http\Firewall\AccessListener->authenticate (line 78)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
26	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
30	Symfony\Component\HttpKernel\Kernel->handle (line 179)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

3.24 ms
(0.43%)

SELECT t0.id AS id_1, t0.role AS role_2, t0.label AS label_3, t0.type AS type_4, t0.section AS section_5, t0.visible AS visible_6, t0.status_list AS status_list_7, t0.created_at AS created_at_8 FROM lle_credential_credential t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.section AS section_5,
  t0.visible AS visible_6,
  t0.status_list AS status_list_7,
  t0.created_at AS created_at_8
FROM
  lle_credential_credential t0

SELECT t0.id AS id_1, t0.role AS role_2, t0.label AS label_3, t0.type AS type_4, t0.section AS section_5, t0.visible AS visible_6, t0.status_list AS status_list_7, t0.created_at AS created_at_8 FROM lle_credential_credential t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	Lle\CredentialBundle\Security\CredentialVoter->__construct (line 55)
5	Container5CrjO0A\getCredentialVoterService->do (line 38)
6	Container5CrjO0A\App_KernelDevDebugContainer::load (line 773)
7	Container5CrjO0A\App_KernelDevDebugContainer->{closure:Container5CrjO0A\App_KernelDevDebugContainer::getDebug_Security_Access_DecisionManagerService():2046} (line 2051)
8	Symfony\Component\Security\Core\Authorization\AccessDecisionManager::getVoters (line 115)
9	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 87)
10	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
11	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
12	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
13	Symfony\Component\Security\Http\Firewall\AccessListener->authenticate (line 78)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
26	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
30	Symfony\Component\HttpKernel\Kernel->handle (line 179)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
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
Lle\CredentialBundle\Entity\GroupCredential	476
Lle\CredentialBundle\Entity\Credential	373
Lle\CredentialBundle\Entity\Group	4

Entities Mapping

Class	Mapping errors
Lle\CredentialBundle\Entity\GroupCredential	No errors.
Lle\CredentialBundle\Entity\Credential	No errors.
Lle\CredentialBundle\Entity\Group	No errors.

Symfony Profiler

GET https://tmb.2le-test.me/admin/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping