Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

5.38 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.85 ms
(34.51%)

SELECT t0.id AS id_1, t0.invoice_number AS invoice_number_2, t0.date AS date_3, t0.total_amount AS total_amount_4, t0.vat_amount AS vat_amount_5, t0.status AS status_6, t0.due_date AS due_date_7, t0.notes AS notes_8, t0.currency AS currency_9, t0.label AS label_10, t0.paid_at AS paid_at_11, t0.type AS type_12, t0.valid_until AS valid_until_13, t0.converted_to_invoice_at AS converted_to_invoice_at_14, t0.vat AS vat_15, t0.acquitted AS acquitted_16, t0.deposit_percent AS deposit_percent_17, t0.billing_stage AS billing_stage_18, t0.late_payment_penalties AS late_payment_penalties_19, t0.sender_email AS sender_email_20, t0.client_id AS client_id_21, t0.original_invoice_id AS original_invoice_id_22 FROM invoice t0 WHERE t0.id = ?

Parameters:

[
  "138"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.invoice_number AS invoice_number_2,
  t0.date AS date_3,
  t0.total_amount AS total_amount_4,
  t0.vat_amount AS vat_amount_5,
  t0.status AS status_6,
  t0.due_date AS due_date_7,
  t0.notes AS notes_8,
  t0.currency AS currency_9,
  t0.label AS label_10,
  t0.paid_at AS paid_at_11,
  t0.type AS type_12,
  t0.valid_until AS valid_until_13,
  t0.converted_to_invoice_at AS converted_to_invoice_at_14,
  t0.vat AS vat_15,
  t0.acquitted AS acquitted_16,
  t0.deposit_percent AS deposit_percent_17,
  t0.billing_stage AS billing_stage_18,
  t0.late_payment_penalties AS late_payment_penalties_19,
  t0.sender_email AS sender_email_20,
  t0.client_id AS client_id_21,
  t0.original_invoice_id AS original_invoice_id_22
FROM
  invoice t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.invoice_number AS invoice_number_2, t0.date AS date_3, t0.total_amount AS total_amount_4, t0.vat_amount AS vat_amount_5, t0.status AS status_6, t0.due_date AS due_date_7, t0.notes AS notes_8, t0.currency AS currency_9, t0.label AS label_10, t0.paid_at AS paid_at_11, t0.type AS type_12, t0.valid_until AS valid_until_13, t0.converted_to_invoice_at AS converted_to_invoice_at_14, t0.vat AS vat_15, t0.acquitted AS acquitted_16, t0.deposit_percent AS deposit_percent_17, t0.billing_stage AS billing_stage_18, t0.late_payment_penalties AS late_payment_penalties_19, t0.sender_email AS sender_email_20, t0.client_id AS client_id_21, t0.original_invoice_id AS original_invoice_id_22 FROM invoice t0 WHERE t0.id = '138';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 146)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 243)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 62)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 78)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.51 ms
(28.04%)

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

Parameters:

[
  1
]

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
FROM
  users 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 FROM users t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.20 ms
(22.38%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.category AS category_3, t0.reference AS reference_4, t0.line_type AS line_type_5, t0.unit_price AS unit_price_6, t0.quantity AS quantity_7, t0.total_price AS total_price_8, t0.invoice_id AS invoice_id_9, t0.linked_invoice_id AS linked_invoice_id_10 FROM invoice_item t0 WHERE t0.invoice_id = ? ORDER BY t0.id ASC

Parameters:

[
  138
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.category AS category_3,
  t0.reference AS reference_4,
  t0.line_type AS line_type_5,
  t0.unit_price AS unit_price_6,
  t0.quantity AS quantity_7,
  t0.total_price AS total_price_8,
  t0.invoice_id AS invoice_id_9,
  t0.linked_invoice_id AS linked_invoice_id_10
FROM
  invoice_item t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.description AS description_2, t0.category AS category_3, t0.reference AS reference_4, t0.line_type AS line_type_5, t0.unit_price AS unit_price_6, t0.quantity AS quantity_7, t0.total_price AS total_price_8, t0.invoice_id AS invoice_id_9, t0.linked_invoice_id AS linked_invoice_id_10 FROM invoice_item t0 WHERE t0.invoice_id = 138 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1828)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1773)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 412)
8	App\Entity\Invoice->hasCategories (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 310)
10	__TwigTemplate_28aefb300d1396445917db80fc7a6874->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 311)
19	App\Controller\Admin\InvoiceCrudController->printDocument (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.81 ms
(15.07%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.company_name AS company_name_4, t0.siret AS siret_5, t0.client_number AS client_number_6, t0.email AS email_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.vat_number AS vat_number_13 FROM client t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.company_name AS company_name_4,
  t0.siret AS siret_5,
  t0.client_number AS client_number_6,
  t0.email AS email_7,
  t0.phone_number AS phone_number_8,
  t0.address AS address_9,
  t0.postal_code AS postal_code_10,
  t0.city AS city_11,
  t0.country AS country_12,
  t0.vat_number AS vat_number_13
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.company_name AS company_name_4, t0.siret AS siret_5, t0.client_number AS client_number_6, t0.email AS email_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.vat_number AS vat_number_13 FROM client t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Client::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Client->__get (line 117)
8	App\Entity\Client->getClientNumber (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 251)
10	__TwigTemplate_28aefb300d1396445917db80fc7a6874->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 311)
19	App\Controller\Admin\InvoiceCrudController->printDocument (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\User	No errors.
App\Entity\Invoice	No errors.
App\Entity\Client	No errors.
App\Entity\InvoiceItem	No errors.

Symfony Profiler

GET https://factures.boubou.ovh/admin?crudAction=printDocument&crudControllerFqcn=App%5CController%5CAdmin%5CInvoiceCrudController&entityId=138

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping