Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.04 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.54 ms
(75.57%)

SELECT t0.id AS id_1, t0.module_id AS module_id_2, t0.release_date AS release_date_3, t0.status AS status_4, t0.version AS version_5 FROM published_release t0 WHERE t0.status = ? ORDER BY t0.release_date DESC LIMIT 1

Parameters:

[
  100
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.module_id AS module_id_2,
  t0.release_date AS release_date_3,
  t0.status AS status_4,
  t0.version AS version_5
FROM
  published_release t0
WHERE
  t0.status = ?
ORDER BY
  t0.release_date DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.module_id AS module_id_2, t0.release_date AS release_date_3, t0.status AS status_4, t0.version AS version_5 FROM published_release t0 WHERE t0.status = 100 ORDER BY t0.release_date DESC 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\EventSubscriber\TwigEventSubscriber->onControllerEvent (line 66)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.50 ms
(24.43%)

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.module_id AS module_id_3, t0.is_demo AS is_demo_4, t0.module_expiration_date AS module_expiration_date_5, t0.start_date AS start_date_6, t0.is_active AS is_active_7, t0.ordered AS ordered_8 FROM account_module t0 WHERE t0.account_id IS NULL AND t0.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.account_id AS account_id_2,
  t0.module_id AS module_id_3,
  t0.is_demo AS is_demo_4,
  t0.module_expiration_date AS module_expiration_date_5,
  t0.start_date AS start_date_6,
  t0.is_active AS is_active_7,
  t0.ordered AS ordered_8
FROM
  account_module t0
WHERE
  t0.account_id IS NULL
  AND t0.is_active = ?

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.module_id AS module_id_3, t0.is_demo AS is_demo_4, t0.module_expiration_date AS module_expiration_date_5, t0.start_date AS start_date_6, t0.is_active AS is_active_7, t0.ordered AS ordered_8 FROM account_module t0 WHERE t0.account_id IS NULL AND t0.is_active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\Main\AccountRepository->getAvailableModules (line 103)
5	App\Service\Generic\Menu->getTranslatedMenuStructure (line 251)
6	App\EventSubscriber\TwigEventSubscriber->onControllerEvent (line 61)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
legacy	doctrine.dbal.legacy_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
legacy	doctrine.orm.legacy_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Main\PublishedRelease	1

legacy entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Main\AbstractBaseEntity	No errors.
App\Entity\Main\SecurityToken	No errors.
App\Entity\Main\User	No errors.
App\Entity\Main\Permission	No errors.
App\Entity\Main\AccountUser	No errors.
App\Entity\Main\Citations	No errors.
App\Entity\Main\File	No errors.
App\Entity\Main\AbstractVersionControlledEntity	No errors.
App\Entity\Main\Documents	No errors.
App\Entity\Main\Account	No errors.
App\Entity\Main\PublishedRelease	No errors.
App\Entity\Main\AccountModule	No errors.

legacy entity manager

No loaded entities.

Symfony Profiler

GET https://quin.riskplaza.nl/api/auditplus/planning/audits/store_status/11

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

legacy entity manager

Entities Mapping

default entity manager

legacy entity manager