Symfony Profiler

Query Metrics

47 Database Queries

3 Different statements

13.56 ms Query time

0 Invalid entities

108 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.03 ms
(81.36%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.tax_id AS tax_id_4, t0.archived_at AS archived_at_5 FROM customer t0 WHERE t0.id = ?

Parameters:

[
  "019ff1a5-3d5f-797a-969b-15fc6f8bc8c0"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.legal_name AS legal_name_3,
  t0.tax_id AS tax_id_4,
  t0.archived_at AS archived_at_5
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.tax_id AS tax_id_4, t0.archived_at AS archived_at_5 FROM customer t0 WHERE t0.id = '019ff1a5-3d5f-797a-969b-15fc6f8bc8c0';

#	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\Customer\Domain\Entity\Customer::getName (line 57)
5	App\Customer\Domain\Entity\CustomerUnit->__toString (line 113)
6	Symfony\Bridge\Doctrine\Form\Type\DoctrineType->createChoiceLabel (line 55)
7	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceView (line 161)
8	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 236)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::createView (line 123)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 481)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
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\Component\Form\Form->createView (line 895)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 193)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
28	Symfony\Component\HttpKernel\Kernel->handle (line 143)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

1.52 ms
(11.19%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM app_user t0 WHERE t0.id = ?

Parameters:

[
  "019fe74c-e07f-7b19-9238-0660fb6839f2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.display_name AS display_name_5
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM app_user t0 WHERE t0.id = '019fe74c-e07f-7b19-9238-0660fb6839f2';

#	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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
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 129)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
18	Symfony\Component\HttpKernel\Kernel->handle (line 143)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	require_once (line 5)

1.01 ms
(7.45%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.normalized_name AS normalized_name_2, c0_.address AS address_3, c0_.archived_at AS archived_at_4, c0_.customer_id AS customer_id_5 FROM customer_unit c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.normalized_name AS normalized_name_2,
  c0_.address AS address_3,
  c0_.archived_at AS archived_at_4,
  c0_.customer_id AS customer_id_5
FROM
  customer_unit c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.normalized_name AS normalized_name_2, c0_.address AS address_3, c0_.archived_at AS archived_at_4, c0_.customer_id AS customer_id_5 FROM customer_unit c0_;

#	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 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 481)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
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\Component\Form\Form->createView (line 895)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 193)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
28	Symfony\Component\HttpKernel\Kernel->handle (line 143)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	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\Customer\Domain\Entity\CustomerUnit	62
App\Customer\Domain\Entity\Customer	45
App\User\Domain\Entity\User	1

Entities Mapping

Class	Mapping errors
App\User\Domain\Entity\User	No errors.
App\Order\Domain\Entity\Order	No errors.
App\Customer\Domain\Entity\CustomerUnit	No errors.
App\Customer\Domain\Entity\Customer	No errors.

GET https:///admin/order/render-filters

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping