Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.11 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.70 ms
(33.24%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.id = ?

Parameters:

[
  "218"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.tracking_number AS tracking_number_3,
  t0.data AS data_4,
  t0.api_status AS api_status_5,
  t0.status AS status_6,
  t0.previous_status AS previous_status_7,
  t0.weight AS weight_8,
  t0.previous_weight AS previous_weight_9,
  t0.size AS size_10,
  t0.previous_size AS previous_size_11,
  t0.tracking_barcode AS tracking_barcode_12,
  t0.manifest_id AS manifest_id_13
FROM
  `order` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.id = '218';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 150)
6	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 115)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 241)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 61)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 78)
11	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.41 ms
(19.37%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.reference AS reference_3, t0.data AS data_4, t0.file AS file_5, t0.direction_type AS direction_type_6, t0.status_import AS status_import_7 FROM manifest t0 WHERE t0.id = ?

Parameters:

[
  213
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.reference AS reference_3,
  t0.data AS data_4,
  t0.file AS file_5,
  t0.direction_type AS direction_type_6,
  t0.status_import AS status_import_7
FROM
  manifest t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.reference AS reference_3, t0.data AS data_4, t0.file AS file_5, t0.direction_type AS direction_type_6, t0.status_import AS status_import_7 FROM manifest t0 WHERE t0.id = 213;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 111)
7	Proxies\__CG__\App\Entity\Manifest->__load (line 120)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 76)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->createForEntityInstance (line 186)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToOneAssociation (line 131)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 108)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 44)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 216)
14	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->edit (line 166)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.38 ms
(18.23%)

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.reference AS reference_2, m0_.data AS data_3, m0_.file AS file_4, m0_.direction_type AS direction_type_5, m0_.status_import AS status_import_6 FROM manifest m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.created_at AS created_at_1,
  m0_.reference AS reference_2,
  m0_.data AS data_3,
  m0_.file AS file_4,
  m0_.direction_type AS direction_type_5,
  m0_.status_import AS status_import_6
FROM
  manifest m0_

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.reference AS reference_2, m0_.data AS data_3, m0_.file AS file_4, m0_.direction_type AS direction_type_5, m0_.status_import AS status_import_6 FROM manifest m0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 179)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 204)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 468)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 47)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.36 ms
(17.10%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.item_description AS item_description_13, t0.parent_order_id AS parent_order_id_14 FROM order_item t0 WHERE t0.parent_order_id = ?

Parameters:

[
  218
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.tracking_number AS tracking_number_3,
  t0.data AS data_4,
  t0.api_status AS api_status_5,
  t0.status AS status_6,
  t0.previous_status AS previous_status_7,
  t0.weight AS weight_8,
  t0.previous_weight AS previous_weight_9,
  t0.size AS size_10,
  t0.previous_size AS previous_size_11,
  t0.tracking_barcode AS tracking_barcode_12,
  t0.item_description AS item_description_13,
  t0.parent_order_id AS parent_order_id_14
FROM
  order_item t0
WHERE
  t0.parent_order_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.item_description AS item_description_13, t0.parent_order_id AS parent_order_id_14 FROM order_item t0 WHERE t0.parent_order_id = 218;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3131)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 251)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 207)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 135)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 108)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 44)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 216)
14	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->edit (line 166)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.25 ms
(12.06%)

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.tracking_number AS tracking_number_2, o0_.data AS data_3, o0_.api_status AS api_status_4, o0_.status AS status_5, o0_.previous_status AS previous_status_6, o0_.weight AS weight_7, o0_.previous_weight AS previous_weight_8, o0_.size AS size_9, o0_.previous_size AS previous_size_10, o0_.tracking_barcode AS tracking_barcode_11, o0_.item_description AS item_description_12, o0_.parent_order_id AS parent_order_id_13 FROM order_item o0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.tracking_number AS tracking_number_2,
  o0_.data AS data_3,
  o0_.api_status AS api_status_4,
  o0_.status AS status_5,
  o0_.previous_status AS previous_status_6,
  o0_.weight AS weight_7,
  o0_.previous_weight AS previous_weight_8,
  o0_.size AS size_9,
  o0_.previous_size AS previous_size_10,
  o0_.tracking_barcode AS tracking_barcode_11,
  o0_.item_description AS item_description_12,
  o0_.parent_order_id AS parent_order_id_13
FROM
  order_item o0_

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.tracking_number AS tracking_number_2, o0_.data AS data_3, o0_.api_status AS api_status_4, o0_.status AS status_5, o0_.previous_status AS previous_status_6, o0_.weight AS weight_7, o0_.previous_weight AS previous_weight_8, o0_.size AS size_9, o0_.previous_size AS previous_size_10, o0_.tracking_barcode AS tracking_barcode_11, o0_.item_description AS item_description_12, o0_.parent_order_id AS parent_order_id_13 FROM order_item o0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 179)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 204)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 468)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 47)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\Order	No errors.
App\Entity\Manifest	No errors.
App\Entity\OrderItem	No errors.

Symfony Profiler

GET https://www.naqeledi.gebanalysis.cloud/?crudAction=edit&crudControllerFqcn=App%5CController%5CAdmin%5COrderCrudController&entityId=218

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping