Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.31 ms Query time

0 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.64 ms

SELECT u0_.id AS id_0, u0_.title AS title_1, u0_.salutation AS salutation_2, u0_.firstname AS firstname_3, u0_.lastname AS lastname_4, u0_.username AS username_5, u0_.email AS email_6, u0_.roles AS roles_7, u0_.password AS password_8, u0_.enabled AS enabled_9, u0_.auth_failure_attempts AS auth_failure_attempts_10, u0_.auth_suspended_until AS auth_suspended_until_11, u0_.last_login_at AS last_login_at_12, u0_.created_at AS created_at_13, u0_.deleted_at AS deleted_at_14, u0_.reset_password_token AS reset_password_token_15, u0_.reset_password_token_valid_until AS reset_password_token_valid_until_16, u0_.permissions AS permissions_17 FROM user u0_ WHERE u0_.deleted_at IS NULL AND u0_.id = ? AND u0_.enabled = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.title AS title_1,
  u0_.salutation AS salutation_2,
  u0_.firstname AS firstname_3,
  u0_.lastname AS lastname_4,
  u0_.username AS username_5,
  u0_.email AS email_6,
  u0_.roles AS roles_7,
  u0_.password AS password_8,
  u0_.enabled AS enabled_9,
  u0_.auth_failure_attempts AS auth_failure_attempts_10,
  u0_.auth_suspended_until AS auth_suspended_until_11,
  u0_.last_login_at AS last_login_at_12,
  u0_.created_at AS created_at_13,
  u0_.deleted_at AS deleted_at_14,
  u0_.reset_password_token AS reset_password_token_15,
  u0_.reset_password_token_valid_until AS reset_password_token_valid_until_16,
  u0_.permissions AS permissions_17
FROM
  user u0_
WHERE
  u0_.deleted_at IS NULL
  AND u0_.id = ?
  AND u0_.enabled = ?

SELECT u0_.id AS id_0, u0_.title AS title_1, u0_.salutation AS salutation_2, u0_.firstname AS firstname_3, u0_.lastname AS lastname_4, u0_.username AS username_5, u0_.email AS email_6, u0_.roles AS roles_7, u0_.password AS password_8, u0_.enabled AS enabled_9, u0_.auth_failure_attempts AS auth_failure_attempts_10, u0_.auth_suspended_until AS auth_suspended_until_11, u0_.last_login_at AS last_login_at_12, u0_.created_at AS created_at_13, u0_.deleted_at AS deleted_at_14, u0_.reset_password_token AS reset_password_token_15, u0_.reset_password_token_valid_until AS reset_password_token_valid_until_16, u0_.permissions AS permissions_17 FROM user u0_ WHERE u0_.deleted_at IS NULL AND u0_.id = 2 AND u0_.enabled = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	App\Admin\Repository\UserRepository->getOneBy (line 34)
7	App\Admin\Security\UserProvider->refreshUser (line 46)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
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->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.52 ms

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.identifier AS identifier_2, t0_.roles AS roles_3, t0_.enabled AS enabled_4, t0_.description AS description_5, t0_.location_memo AS location_memo_6, t0_.last_heartbeat AS last_heartbeat_7, t0_.updated_at AS updated_at_8, t0_.deleted_at AS deleted_at_9, t0_.location_id AS location_id_10, t0_.use_case_id AS use_case_id_11 FROM terminal t0_ WHERE t0_.deleted_at IS NULL AND t0_.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.identifier AS identifier_2,
  t0_.roles AS roles_3,
  t0_.enabled AS enabled_4,
  t0_.description AS description_5,
  t0_.location_memo AS location_memo_6,
  t0_.last_heartbeat AS last_heartbeat_7,
  t0_.updated_at AS updated_at_8,
  t0_.deleted_at AS deleted_at_9,
  t0_.location_id AS location_id_10,
  t0_.use_case_id AS use_case_id_11
FROM
  terminal t0_
WHERE
  t0_.deleted_at IS NULL
  AND t0_.id = ?

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.identifier AS identifier_2, t0_.roles AS roles_3, t0_.enabled AS enabled_4, t0_.description AS description_5, t0_.location_memo AS location_memo_6, t0_.last_heartbeat AS last_heartbeat_7, t0_.updated_at AS updated_at_8, t0_.deleted_at AS deleted_at_9, t0_.location_id AS location_id_10, t0_.use_case_id AS use_case_id_11 FROM terminal t0_ WHERE t0_.deleted_at IS NULL AND t0_.id = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	App\Admin\Repository\Terminal\TerminalRepository->getOneBy (line 32)
7	App\Admin\Controller\Terminal\Management\TerminalEditController->__invoke (line 31)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.82 ms

SELECT l0_.id AS id_0, l0_.type AS type_1, l0_.name AS name_2, l0_.description AS description_3, l0_.floors AS floors_4, l0_.address AS address_5, l0_.accessible AS accessible_6, l0_.created_at AS created_at_7, l0_.lft AS lft_8, l0_.lvl AS lvl_9, l0_.rgt AS rgt_10 FROM location l0_ ORDER BY l0_.tree_root ASC, l0_.lft ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.type AS type_1,
  l0_.name AS name_2,
  l0_.description AS description_3,
  l0_.floors AS floors_4,
  l0_.address AS address_5,
  l0_.accessible AS accessible_6,
  l0_.created_at AS created_at_7,
  l0_.lft AS lft_8,
  l0_.lvl AS lvl_9,
  l0_.rgt AS rgt_10
FROM
  location l0_
ORDER BY
  l0_.tree_root ASC,
  l0_.lft ASC

SELECT l0_.id AS id_0, l0_.type AS type_1, l0_.name AS name_2, l0_.description AS description_3, l0_.floors AS floors_4, l0_.address AS address_5, l0_.accessible AS accessible_6, l0_.created_at AS created_at_7, l0_.lft AS lft_8, l0_.lvl AS lvl_9, l0_.rgt AS rgt_10 FROM location l0_ ORDER BY l0_.tree_root ASC, l0_.lft ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	Gedmo\Tree\Entity\Repository\NestedTreeRepository->getNodesHierarchy (line 1085)
7	App\Admin\Form\Type\LocationTreeType->buildForm (line 36)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 96)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
11	Symfony\Component\Form\FormBuilder->create (line 80)
12	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
13	Symfony\Component\Form\FormBuilder->getForm (line 160)
14	Symfony\Component\Form\FormFactory->create (line 26)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 355)
16	App\Admin\Controller\Terminal\Management\TerminalEditController->__invoke (line 36)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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 29)
22	require_once (line 5)

0.32 ms

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.description AS description_2, u0_.category AS category_3, u0_.enabled AS enabled_4, u0_.updated_at AS updated_at_5 FROM use_case u0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.description AS description_2,
  u0_.category AS category_3,
  u0_.enabled AS enabled_4,
  u0_.updated_at AS updated_at_5
FROM
  use_case u0_

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.description AS description_2, u0_.category AS category_3, u0_.enabled AS enabled_4, u0_.updated_at AS updated_at_5 FROM use_case u0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 455)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Admin\Controller\Terminal\Management\TerminalEditController->__invoke (line 50)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	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
App\Admin\Entity\Terminal\UseCase	4
App\Admin\Entity\User	1
App\Admin\Entity\Terminal\Terminal	1

Entities Mapping

Class	Mapping errors
App\Admin\Entity\User	No errors.
App\Admin\Entity\UserAuthLog	No errors.
App\Admin\Entity\UserGroup	No errors.
App\Admin\Entity\Terminal\Terminal	No errors.
App\Admin\Entity\Location	No errors.
App\Admin\Entity\Terminal\UseCase	No errors.
App\Admin\Entity\Terminal\UseCaseStep	No errors.

Symfony Profiler

GET https://dev1.ata.polavis.de/admin/terminal/devices/1/edit

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping