Symfony Profiler

Query Metrics

12 Database Queries

3 Different statements

3.36 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.60 ms
(47.51%)

SELECT t0.order_number AS order_number_1, t0.grand_total AS grand_total_2, t0.invoice_number AS invoice_number_3, t0.invoice_grand_total AS invoice_grand_total_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.payment_advice_credit_id AS payment_advice_credit_id_8 FROM payment_advice_credit_position t0 WHERE t0.payment_advice_credit_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.order_number AS order_number_1,
  t0.grand_total AS grand_total_2,
  t0.invoice_number AS invoice_number_3,
  t0.invoice_grand_total AS invoice_grand_total_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.payment_advice_credit_id AS payment_advice_credit_id_8
FROM
  payment_advice_credit_position t0
WHERE
  t0.payment_advice_credit_id = ?

SELECT t0.order_number AS order_number_1, t0.grand_total AS grand_total_2, t0.invoice_number AS invoice_number_3, t0.invoice_grand_total AS invoice_grand_total_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.payment_advice_credit_id AS payment_advice_credit_id_8 FROM payment_advice_credit_position t0 WHERE t0.payment_advice_credit_id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 82)
8	PcFibo\Form\Type\PaymentAdviceAvis\CreditNotesTableType->buildView (line 116)
9	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
11	Symfony\Component\Form\Form->createView (line 903)
12	Symfony\Component\Form\Form->createView (line 47)
13	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 34)
17	Ciosix\Core\Flows\Decorator\EventDispatcherDecorator->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.26 ms
(37.59%)

SELECT t0.number AS number_1, t0.date AS date_2, t0.grand_total AS grand_total_3, t0.status AS status_4, t0.pdf AS pdf_5, t0.pdf_name AS pdf_name_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM payment_advice_credit t0 WHERE t0.number IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "5100652525"
  "5100653727"
  "5100657267"
  "5100660713"
  "5100664761"
  "5100665848"
  "5100665851"
  "5100669206"
  "5100673445"
  "5100674674"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.number AS number_1,
  t0.date AS date_2,
  t0.grand_total AS grand_total_3,
  t0.status AS status_4,
  t0.pdf AS pdf_5,
  t0.pdf_name AS pdf_name_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  payment_advice_credit t0
WHERE
  t0.number IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.number AS number_1, t0.date AS date_2, t0.grand_total AS grand_total_3, t0.status AS status_4, t0.pdf AS pdf_5, t0.pdf_name AS pdf_name_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM payment_advice_credit t0 WHERE t0.number IN ('5100652525', '5100653727', '5100657267', '5100660713', '5100664761', '5100665848', '5100665851', '5100669206', '5100673445', '5100674674');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 53)
4	PcFibo\Form\Type\PaymentAdviceAvis\CreditNotesTableType->buildView (line 116)
5	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
6	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
7	Symfony\Component\Form\Form->createView (line 903)
8	Symfony\Component\Form\Form->createView (line 47)
9	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 34)
13	Ciosix\Core\Flows\Decorator\EventDispatcherDecorator->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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.50 ms
(14.90%)

SELECT t0.status AS status_1, t0.pdf AS pdf_2, t0.pdf_name AS pdf_name_3, t0.credit_note_numbers AS credit_note_numbers_4, t0.avis_number AS avis_number_5, t0.avis_date AS avis_date_6, t0.avis_total AS avis_total_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM payment_advice_avis t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.status AS status_1,
  t0.pdf AS pdf_2,
  t0.pdf_name AS pdf_name_3,
  t0.credit_note_numbers AS credit_note_numbers_4,
  t0.avis_number AS avis_number_5,
  t0.avis_date AS avis_date_6,
  t0.avis_total AS avis_total_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  payment_advice_avis t0
WHERE
  t0.id = ?

SELECT t0.status AS status_1, t0.pdf AS pdf_2, t0.pdf_name AS pdf_name_3, t0.credit_note_numbers AS credit_note_numbers_4, t0.avis_number AS avis_number_5, t0.avis_date AS avis_date_6, t0.avis_total AS avis_total_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM payment_advice_avis t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 146)
6	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 243)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 62)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 57)
11	Ciosix\Core\EventSubscriber\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 34)
15	Ciosix\Core\Flows\Decorator\EventDispatcherDecorator->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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
PcFibo\Entity\PaymentAdviceAvis	No errors.
PcFibo\Entity\PaymentAdviceCredit	No errors.
Ciosix\Core\Notes\Entity\Note	No errors.
PcFibo\Entity\PaymentAdviceCredit\Position	No errors.

Symfony Profiler

GET https://ciosix-pc-fibo-stage.workspace.connect-io.de/?crudAction=edit&crudControllerFqcn=PcFibo%5CController%5CPaymentAdviceAvisController&entityId=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping