Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.94 ms Query time

0 Invalid entities

15 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.04 ms

SELECT t0.id AS id_1, t0.salutation AS salutation_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.password AS password_6, t0.roles AS roles_7, t0.valid_from AS valid_from_8, t0.valid_until AS valid_until_9, t0.is_approved AS is_approved_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.last_login_at AS last_login_at_13, t0.tutorial_completed AS tutorial_completed_14 FROM app_user t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.salutation AS salutation_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.roles AS roles_7,
  t0.valid_from AS valid_from_8,
  t0.valid_until AS valid_until_9,
  t0.is_approved AS is_approved_10,
  t0.is_active AS is_active_11,
  t0.created_at AS created_at_12,
  t0.last_login_at AS last_login_at_13,
  t0.tutorial_completed AS tutorial_completed_14
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.salutation AS salutation_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.password AS password_6, t0.roles AS roles_7, t0.valid_from AS valid_from_8, t0.valid_until AS valid_until_9, t0.is_approved AS is_approved_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.last_login_at AS last_login_at_13, t0.tutorial_completed AS tutorial_completed_14 FROM app_user t0 WHERE t0.id = 11;

#	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 5)

0.90 ms

SELECT a0_.id AS id_0, a0_.salutation AS salutation_1, a0_.first_name AS first_name_2, a0_.last_name AS last_name_3, a0_.email AS email_4, a0_.password AS password_5, a0_.roles AS roles_6, a0_.valid_from AS valid_from_7, a0_.valid_until AS valid_until_8, a0_.is_approved AS is_approved_9, a0_.is_active AS is_active_10, a0_.created_at AS created_at_11, a0_.last_login_at AS last_login_at_12, a0_.tutorial_completed AS tutorial_completed_13 FROM app_user a0_ WHERE a0_.is_active = 1 ORDER BY a0_.last_name ASC, a0_.first_name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.salutation AS salutation_1,
  a0_.first_name AS first_name_2,
  a0_.last_name AS last_name_3,
  a0_.email AS email_4,
  a0_.password AS password_5,
  a0_.roles AS roles_6,
  a0_.valid_from AS valid_from_7,
  a0_.valid_until AS valid_until_8,
  a0_.is_approved AS is_approved_9,
  a0_.is_active AS is_active_10,
  a0_.created_at AS created_at_11,
  a0_.last_login_at AS last_login_at_12,
  a0_.tutorial_completed AS tutorial_completed_13
FROM
  app_user a0_
WHERE
  a0_.is_active = 1
ORDER BY
  a0_.last_name ASC,
  a0_.first_name ASC

SELECT a0_.id AS id_0, a0_.salutation AS salutation_1, a0_.first_name AS first_name_2, a0_.last_name AS last_name_3, a0_.email AS email_4, a0_.password AS password_5, a0_.roles AS roles_6, a0_.valid_from AS valid_from_7, a0_.valid_until AS valid_until_8, a0_.is_approved AS is_approved_9, a0_.is_active AS is_active_10, a0_.created_at AS created_at_11, a0_.last_login_at AS last_login_at_12, a0_.tutorial_completed AS tutorial_completed_13 FROM app_user a0_ WHERE a0_.is_active = 1 ORDER BY a0_.last_name ASC, a0_.first_name 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	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 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\Admin\DeputyController->new (line 59)
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 32)
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\Entity\User	15

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\CommitteeMembership	No errors.
App\Entity\DeputyAssignment	No errors.
App\Entity\AssistantAssignment	No errors.
App\Entity\SessionInvitation	No errors.

Symfony Profiler

GET https://intern.ffa.de/admin/deputies/new

Configuration Settings

Theme

Page Width