Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.41 ms Query time

0 Invalid entities

97 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.77 ms

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.full_name AS full_name_4, u0_.email AS email_5, u0_.phone AS phone_6, u0_.is_template AS is_template_7, u0_.status_id AS status_id_8, u0_.fonction_id AS fonction_id_9, u0_.service_id AS service_id_10 FROM [user] u0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.full_name AS full_name_4,
  u0_.email AS email_5,
  u0_.phone AS phone_6,
  u0_.is_template AS is_template_7,
  u0_.status_id AS status_id_8,
  u0_.fonction_id AS fonction_id_9,
  u0_.service_id AS service_id_10
FROM
  [user] u0_

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.full_name AS full_name_4, u0_.email AS email_5, u0_.phone AS phone_6, u0_.is_template AS is_template_7, u0_.status_id AS status_id_8, u0_.fonction_id AS fonction_id_9, u0_.service_id AS service_id_10 FROM [user] 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 208)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 467)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 238)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 116)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 114)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
18	Symfony\Component\Form\Form->createView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 186)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 197)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

2.94 ms

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.type AS type_3 FROM list_bundle_grades l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.description AS description_2,
  l0_.type AS type_3
FROM
  list_bundle_grades l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.type AS type_3 FROM list_bundle_grades l0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 208)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 467)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 238)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 116)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 114)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
18	Symfony\Component\Form\Form->createView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 186)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 197)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.37 ms

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.value AS value_2, l0_.description AS description_3 FROM list_status l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.value AS value_2,
  l0_.description AS description_3
FROM
  list_status l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.value AS value_2, l0_.description AS description_3 FROM list_status l0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 208)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 467)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 238)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 116)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 114)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
18	Symfony\Component\Form\Form->createView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 186)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 197)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.32 ms

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.short_name AS short_name_3, l0_.ew_id AS ew_id_4 FROM list_unit l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.code AS code_2,
  l0_.short_name AS short_name_3,
  l0_.ew_id AS ew_id_4
FROM
  list_unit l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.short_name AS short_name_3, l0_.ew_id AS ew_id_4 FROM list_unit l0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 208)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 467)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 238)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 116)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 114)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
18	Symfony\Component\Form\Form->createView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 186)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 197)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	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	63
App\Entity\ListBundleGrades	20
App\Entity\ListStatus	6
App\Entity\ListUnit	5
App\Entity\ListEw	3

Entities Mapping

Class	Mapping errors
App\Entity\CopperBundles	No errors.
App\Entity\User	No errors.
App\Entity\ListBundleGrades	No errors.
App\Entity\ListStatus	No errors.
App\Entity\ListUnit	No errors.
App\Entity\ListFunction	No errors.
App\Entity\ListService	No errors.
App\Entity\ListEw	No errors.
App\Entity\CopperBundleChangeRequest	No errors.
App\Entity\ConfigUserAccessRole	No errors.

Symfony Profiler

GET https://boyekoli.com/admin/copper-bundles/new?sort%5BgrossWeight%5D=DESC

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping