Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

3.58 ms Query time

0 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.78 ms
(49.65%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.description AS description_4 FROM roles t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.description AS description_4
FROM
  roles t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.description AS description_4 FROM roles 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\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Role::getRoleSymfony (line 130)
5	App\Manager\ArgosManager->{closure:App\Manager\ArgosManager::regles():150} (line 156)
6	App\Manager\MemoryManager->{closure:App\Manager\MemoryManager::lire():150} (line 159)
7	Symfony\Component\Cache\LockRegistry->compute (line 116)
8	Symfony\Component\Cache\Adapter\TagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
9	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 67)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 85)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 30)
12	App\Cache\LongTier->get (line 99)
13	App\Manager\MemoryManager->lire (line 150)
14	App\Manager\ArgosManager->regles (line 150)
15	App\Security\RuleVoter->supports (line 46)
16	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 34)
17	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
18	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
19	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
20	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
21	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
22	Symfony\Component\Security\Http\Firewall\AccessListener->authenticate (line 78)
23	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
24	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
25	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
26	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
33	Symfony\Component\HttpKernel\Kernel->handle (line 143)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
35	require_once (line 32)
36	require_once (line 12)

1.04 ms
(29.16%)

SELECT t0.id AS id_1, t0.var AS var_2, t0.label AS label_3, t0.val AS val_4, t0.type AS type_5, t0.hint AS hint_6 FROM configuration t0 WHERE t0.var = ? LIMIT 1

Parameters:

[
  "cache.actif"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.var AS var_2,
  t0.label AS label_3,
  t0.val AS val_4,
  t0.type AS type_5,
  t0.hint AS hint_6
FROM
  configuration t0
WHERE
  t0.var = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.var AS var_2, t0.label AS label_3, t0.val AS val_4, t0.type AS type_5, t0.hint AS hint_6 FROM configuration t0 WHERE t0.var = 'cache.actif' 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Manager\MemoryManager->actif (line 185)
5	App\Manager\MemoryManager->lire (line 146)
6	App\Manager\ArgosManager->regles (line 150)
7	App\Security\RuleVoter->supports (line 46)
8	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 34)
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\Http\Firewall\AccessListener->authenticate (line 78)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
25	Symfony\Component\HttpKernel\Kernel->handle (line 143)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 12)

0.76 ms
(21.19%)

SELECT t0.id AS id_1, t0.prop AS prop_2, t0.cond AS cond_3, t0.val AS val_4, t0.role_id AS role_id_5 FROM regles t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prop AS prop_2,
  t0.cond AS cond_3,
  t0.val AS val_4,
  t0.role_id AS role_id_5
FROM
  regles t0

SELECT t0.id AS id_1, t0.prop AS prop_2, t0.cond AS cond_3, t0.val AS val_4, t0.role_id AS role_id_5 FROM regles t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Manager\ArgosManager->{closure:App\Manager\ArgosManager::regles():150} (line 152)
6	App\Manager\MemoryManager->{closure:App\Manager\MemoryManager::lire():150} (line 159)
7	Symfony\Component\Cache\LockRegistry->compute (line 116)
8	Symfony\Component\Cache\Adapter\TagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
9	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 67)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 85)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 30)
12	App\Cache\LongTier->get (line 99)
13	App\Manager\MemoryManager->lire (line 150)
14	App\Manager\ArgosManager->regles (line 150)
15	App\Security\RuleVoter->supports (line 46)
16	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 34)
17	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
18	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
19	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
20	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
21	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
22	Symfony\Component\Security\Http\Firewall\AccessListener->authenticate (line 78)
23	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
24	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
25	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
26	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
33	Symfony\Component\HttpKernel\Kernel->handle (line 143)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
35	require_once (line 32)
36	require_once (line 12)

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\Rule	13
App\Entity\Role	3
App\Entity\Setting	1

Entities Mapping

Class	Mapping errors
App\Entity\Setting	No errors.
App\Entity\Rule	No errors.
App\Entity\Role	No errors.

GET https://argos-dev.kaziza.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping