Symfony Profiler

Query Metrics

33 Database Queries

7 Different statements

10.13 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.38 ms
(33.36%)

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?

Parameters:

[
  11094
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.created_at AS created_at_3,
  t0.amount AS amount_4,
  t0.folio AS folio_5,
  t0.status AS status_6,
  t0.type AS type_7,
  t0.payment_id AS payment_id_8,
  t0.captured_by_id AS captured_by_id_9
FROM
  partial_payments t0
WHERE
  t0.payment_id = ?

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = 11094;

#	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 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1)
8	IteratorIterator->__construct (line 1687)
9	twig_array_filter (line 651)
10	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->block_body (line 171)
11	Twig\Template->displayBlock (line 761)
12	__TwigTemplate_795c1a5bcef5f85e9dcf3dfca49c64b8->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 228)
24	App\Controller\Admin\AdminOrdersController->view (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

3.27 ms
(32.27%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?

Parameters:

[
  11094
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.thumb_filename AS thumb_filename_3,
  t0.type AS type_4,
  t0.category AS category_5,
  t0.folder AS folder_6,
  t0.clients_id AS clients_id_7,
  t0.payments_id AS payments_id_8,
  t0.partial_payments_id AS partial_payments_id_9
FROM
  media t0
WHERE
  t0.payments_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = 11094;

#	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 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 587)
8	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->block_body (line 171)
9	Twig\Template->displayBlock (line 761)
10	__TwigTemplate_795c1a5bcef5f85e9dcf3dfca49c64b8->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 51)
13	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 228)
22	App\Controller\Admin\AdminOrdersController->view (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.37 ms
(13.49%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.partial_payments_id = ?

Parameters:

[
  4714
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.thumb_filename AS thumb_filename_3,
  t0.type AS type_4,
  t0.category AS category_5,
  t0.folder AS folder_6,
  t0.clients_id AS clients_id_7,
  t0.payments_id AS payments_id_8,
  t0.partial_payments_id AS partial_payments_id_9
FROM
  media t0
WHERE
  t0.partial_payments_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.partial_payments_id = 4714;

#	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 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 740)
8	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->block_body (line 171)
9	Twig\Template->displayBlock (line 761)
10	__TwigTemplate_795c1a5bcef5f85e9dcf3dfca49c64b8->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 51)
13	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 228)
22	App\Controller\Admin\AdminOrdersController->view (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.57 ms
(5.64%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.mobile AS mobile_7, t0.position AS position_8, t0.is_active AS is_active_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.photo AS photo_12, t0.address AS address_13 FROM users t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.mobile AS mobile_7,
  t0.position AS position_8,
  t0.is_active AS is_active_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.photo AS photo_12,
  t0.address AS address_13
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.mobile AS mobile_7, t0.position AS position_8, t0.is_active AS is_active_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.photo AS photo_12, t0.address AS address_13 FROM users t0 WHERE t0.id = 4;

#	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 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.57 ms
(5.60%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.amount AS amount_3, t0.payment_date AS payment_date_4, t0.expiration_date AS expiration_date_5, t0.is_active AS is_active_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.sort AS sort_10, t0.print AS print_11, t0.folio AS folio_12, t0.capture_date AS capture_date_13, t0.type AS type_14, t0.orders_id AS orders_id_15, t0.captured_by_id AS captured_by_id_16 FROM payments t0 WHERE t0.orders_id = ?

Parameters:

[
  870
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.amount AS amount_3,
  t0.payment_date AS payment_date_4,
  t0.expiration_date AS expiration_date_5,
  t0.is_active AS is_active_6,
  t0.updated_at AS updated_at_7,
  t0.created_at AS created_at_8,
  t0.status AS status_9,
  t0.sort AS sort_10,
  t0.print AS print_11,
  t0.folio AS folio_12,
  t0.capture_date AS capture_date_13,
  t0.type AS type_14,
  t0.orders_id AS orders_id_15,
  t0.captured_by_id AS captured_by_id_16
FROM
  payments t0
WHERE
  t0.orders_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.amount AS amount_3, t0.payment_date AS payment_date_4, t0.expiration_date AS expiration_date_5, t0.is_active AS is_active_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.sort AS sort_10, t0.print AS print_11, t0.folio AS folio_12, t0.capture_date AS capture_date_13, t0.type AS type_14, t0.orders_id AS orders_id_15, t0.captured_by_id AS captured_by_id_16 FROM payments t0 WHERE t0.orders_id = 870;

#	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 3289)
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 1127)
9	twig_length_filter (line 477)
10	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->block_body (line 171)
11	Twig\Template->displayBlock (line 761)
12	__TwigTemplate_795c1a5bcef5f85e9dcf3dfca49c64b8->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 228)
24	App\Controller\Admin\AdminOrdersController->view (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.51 ms
(5.08%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.motherslastname AS motherslastname_4, t0.is_active AS is_active_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.photo AS photo_8, t0.official_id AS official_id_9, t0.home_exterior_photo AS home_exterior_photo_10, t0.created_by_id AS created_by_id_11 FROM clients t0 WHERE t0.id = ?

Parameters:

[
  871
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.motherslastname AS motherslastname_4,
  t0.is_active AS is_active_5,
  t0.updated_at AS updated_at_6,
  t0.created_at AS created_at_7,
  t0.photo AS photo_8,
  t0.official_id AS official_id_9,
  t0.home_exterior_photo AS home_exterior_photo_10,
  t0.created_by_id AS created_by_id_11
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.motherslastname AS motherslastname_4, t0.is_active AS is_active_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.photo AS photo_8, t0.official_id AS official_id_9, t0.home_exterior_photo AS home_exterior_photo_10, t0.created_by_id AS created_by_id_11 FROM clients t0 WHERE t0.id = 871;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Clients::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\Clients->__get (line 120)
8	App\Entity\Clients->getFirstname (line 1635)
9	twig_get_attribute (line 452)
10	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->block_body (line 171)
11	Twig\Template->displayBlock (line 761)
12	__TwigTemplate_795c1a5bcef5f85e9dcf3dfca49c64b8->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_a931650e74bc54d42f5090713300b9ad->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 228)
24	App\Controller\Admin\AdminOrdersController->view (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.46 ms
(4.56%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.items AS items_3, t0.subtotal AS subtotal_4, t0.tax AS tax_5, t0.total AS total_6, t0.is_active AS is_active_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.initial_payment AS initial_payment_10, t0.payments_start_date AS payments_start_date_11, t0.contract_number AS contract_number_12, t0.delivery_date AS delivery_date_13, t0.payment_amount AS payment_amount_14, t0.status AS status_15, t0.print AS print_16, t0.source AS source_17, t0.discount AS discount_18, t0.discount_by_agreement AS discount_by_agreement_19, t0.payment_type AS payment_type_20, t0.client_id AS client_id_21, t0.vendor_id AS vendor_id_22, t0.sales_closer_id AS sales_closer_id_23, t0.speaker_id AS speaker_id_24, t0.coordinator_id AS coordinator_id_25, t0.leader_id AS leader_id_26, t0.route_id AS route_id_27, t0.debt_collector_id AS debt_collector_id_28, t0.warehouse_id AS warehouse_id_29, t0.created_by_id AS created_by_id_30, t0.voucher_id AS voucher_id_31 FROM orders t0 WHERE t0.id = ?

Parameters:

[
  870
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.items AS items_3,
  t0.subtotal AS subtotal_4,
  t0.tax AS tax_5,
  t0.total AS total_6,
  t0.is_active AS is_active_7,
  t0.updated_at AS updated_at_8,
  t0.created_at AS created_at_9,
  t0.initial_payment AS initial_payment_10,
  t0.payments_start_date AS payments_start_date_11,
  t0.contract_number AS contract_number_12,
  t0.delivery_date AS delivery_date_13,
  t0.payment_amount AS payment_amount_14,
  t0.status AS status_15,
  t0.print AS print_16,
  t0.source AS source_17,
  t0.discount AS discount_18,
  t0.discount_by_agreement AS discount_by_agreement_19,
  t0.payment_type AS payment_type_20,
  t0.client_id AS client_id_21,
  t0.vendor_id AS vendor_id_22,
  t0.sales_closer_id AS sales_closer_id_23,
  t0.speaker_id AS speaker_id_24,
  t0.coordinator_id AS coordinator_id_25,
  t0.leader_id AS leader_id_26,
  t0.route_id AS route_id_27,
  t0.debt_collector_id AS debt_collector_id_28,
  t0.warehouse_id AS warehouse_id_29,
  t0.created_by_id AS created_by_id_30,
  t0.voucher_id AS voucher_id_31
FROM
  orders t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.items AS items_3, t0.subtotal AS subtotal_4, t0.tax AS tax_5, t0.total AS total_6, t0.is_active AS is_active_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.initial_payment AS initial_payment_10, t0.payments_start_date AS payments_start_date_11, t0.contract_number AS contract_number_12, t0.delivery_date AS delivery_date_13, t0.payment_amount AS payment_amount_14, t0.status AS status_15, t0.print AS print_16, t0.source AS source_17, t0.discount AS discount_18, t0.discount_by_agreement AS discount_by_agreement_19, t0.payment_type AS payment_type_20, t0.client_id AS client_id_21, t0.vendor_id AS vendor_id_22, t0.sales_closer_id AS sales_closer_id_23, t0.speaker_id AS speaker_id_24, t0.coordinator_id AS coordinator_id_25, t0.leader_id AS leader_id_26, t0.route_id AS route_id_27, t0.debt_collector_id AS debt_collector_id_28, t0.warehouse_id AS warehouse_id_29, t0.created_by_id AS created_by_id_30, t0.voucher_id AS voucher_id_31 FROM orders t0 WHERE t0.id = 870;

#	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 220)
6	App\Controller\Admin\AdminOrdersController->view (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\Users	The field App\Entity\Users#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Orders#createdBy does not contain the required 'inversedBy="orders"' attribute. The field App\Entity\Users#vouchersCreated is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Vouchers#createdBy does not contain the required 'inversedBy="vouchersCreated"' attribute. The field App\Entity\Users#partialPayments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PartialPayments#capturedBy does not contain the required 'inversedBy="partialPayments"' attribute. The field App\Entity\Users#clients is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Clients#createdBy does not contain the required 'inversedBy="clients"' attribute.
App\Entity\Warehouses	No errors.
App\Entity\Vouchers	No errors.
App\Entity\Orders	The mappings App\Entity\Orders#salesCloser and App\Entity\Users#orders are inconsistent with each other. The mappings App\Entity\Orders#speaker and App\Entity\Users#orders are inconsistent with each other. The mappings App\Entity\Orders#coordinator and App\Entity\Users#orders are inconsistent with each other. The mappings App\Entity\Orders#leader and App\Entity\Users#orders are inconsistent with each other.
App\Entity\Payments	No errors.
App\Entity\PartialPayments	No errors.
App\Entity\Clients	No errors.
App\Entity\Vendor	No errors.
App\Entity\Routes	No errors.
App\Entity\DebtCollectors	No errors.
App\Entity\OrderItems	No errors.
App\Entity\ClientAddresses	No errors.
App\Entity\ClientPhoneNumbers	No errors.
App\Entity\Media	No errors.

Symfony Profiler

GET https://www.servicioseducativosnaku.com.mx/admin/orders/view/870

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping