Symfony Profiler

Query Metrics

16 Database Queries

13 Different statements

1.72 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.38 ms
(22.31%)

SELECT t0.id AS id_1, t0.price AS price_2, t0.supplier_code AS supplier_code_3, t0.image AS image_4, t0.last_price AS last_price_5, t0.price_changed_at AS price_changed_at_6, t0.price_last_at AS price_last_at_7, t0.is_active AS is_active_8, t0.extra_data AS extra_data_9, t0.last_is_active AS last_is_active_10, t0.supplier_id AS supplier_id_11, t0.product_id AS product_id_12 FROM supplier_has_product t0 WHERE t0.product_id = ?

Parameters:

[
  182889
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.supplier_code AS supplier_code_3,
  t0.image AS image_4,
  t0.last_price AS last_price_5,
  t0.price_changed_at AS price_changed_at_6,
  t0.price_last_at AS price_last_at_7,
  t0.is_active AS is_active_8,
  t0.extra_data AS extra_data_9,
  t0.last_is_active AS last_is_active_10,
  t0.supplier_id AS supplier_id_11,
  t0.product_id AS product_id_12
FROM
  supplier_has_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.supplier_code AS supplier_code_3, t0.image AS image_4, t0.last_price AS last_price_5, t0.price_changed_at AS price_changed_at_6, t0.price_last_at AS price_last_at_7, t0.is_active AS is_active_8, t0.extra_data AS extra_data_9, t0.last_is_active AS last_is_active_10, t0.supplier_id AS supplier_id_11, t0.product_id AS product_id_12 FROM supplier_has_product t0 WHERE t0.product_id = 182889;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
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 365)
8	App\Entity\Product->getSupplierCode (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 580)
10	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->{closure} (line 1775)
11	Twig\Extension\CoreExtension::captureOutput (line 626)
12	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->macro_item_row (line 1228)
13	Twig\Extension\CoreExtension::callMacro (line 277)
14	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 1332)
18	Twig\Extension\CoreExtension::include (line 91)
19	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->block_body (line 430)
20	Twig\Template->yieldBlock (line 191)
21	__TwigTemplate_8ea01d219fd81d3c4ebf21fd9bcaf9b9->doDisplay (line 360)
22	Twig\Template->yield (line 50)
23	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->doDisplay (line 360)
24	Twig\Template->yield (line 335)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 307)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 217)
31	App\Controller\OrderController->show (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.17 ms
(9.92%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.id = ?

Parameters:

[
  182889
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.is_active AS is_active_4,
  t0.max_limit AS max_limit_5,
  t0.unit AS unit_6,
  t0.ean AS ean_7,
  t0.pieces AS pieces_8,
  t0.dimension AS dimension_9,
  t0.manufacturer AS manufacturer_10,
  t0.category_id AS category_id_11
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.id = 182889;

#	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\Product::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Product->__get (line 175)
8	App\Entity\Product->__toString (line 1)
9	mb_strtoupper (line 1160)
10	Twig\Extension\CoreExtension::upper (line 569)
11	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->{closure} (line 1775)
12	Twig\Extension\CoreExtension::captureOutput (line 626)
13	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->macro_item_row (line 1228)
14	Twig\Extension\CoreExtension::callMacro (line 277)
15	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 1332)
19	Twig\Extension\CoreExtension::include (line 91)
20	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->block_body (line 430)
21	Twig\Template->yieldBlock (line 191)
22	__TwigTemplate_8ea01d219fd81d3c4ebf21fd9bcaf9b9->doDisplay (line 360)
23	Twig\Template->yield (line 50)
24	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->doDisplay (line 360)
25	Twig\Template->yield (line 335)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 307)
28	Twig\Environment->render (line 448)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 217)
32	App\Controller\OrderController->show (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

0.16 ms
(9.18%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.hotel_order_id AS hotel_order_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_notice t0 WHERE t0.hotel_order_id = ?

Parameters:

[
  20904
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.user_id AS user_id_4,
  t0.hotel_order_id AS hotel_order_id_5,
  t0.supplier_id AS supplier_id_6
FROM
  order_has_notice t0
WHERE
  t0.hotel_order_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.hotel_order_id AS hotel_order_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_notice t0 WHERE t0.hotel_order_id = 20904;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
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 545)
7	Doctrine\ORM\PersistentCollection->__clone (line 276)
8	Symfony\Component\Form\Form->setData (line 50)
9	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
10	Symfony\Component\Form\Form->setData (line 412)
11	Symfony\Component\Form\Form->initialize (line 176)
12	Symfony\Component\Form\FormBuilder->getForm (line 28)
13	Symfony\Component\Form\FormFactory->create (line 340)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 211)
15	App\Controller\OrderController->show (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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.14 ms
(8.13%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_confirmed AS is_confirmed_3, t0.status AS status_4, t0.order_number AS order_number_5, t0.is_template AS is_template_6, t0.template_name AS template_name_7, t0.basket_number AS basket_number_8, t0.is_only_template AS is_only_template_9, t0.extra_data AS extra_data_10, t0.updated_at AS updated_at_11, t0.delivery_code AS delivery_code_12, t0.hotel_id AS hotel_id_13, t0.user_id AS user_id_14, t0.accepted_by_id AS accepted_by_id_15 FROM `order` t0 WHERE t0.user_id = ?

Parameters:

[
  126
]

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.is_confirmed AS is_confirmed_3,
  t0.status AS status_4,
  t0.order_number AS order_number_5,
  t0.is_template AS is_template_6,
  t0.template_name AS template_name_7,
  t0.basket_number AS basket_number_8,
  t0.is_only_template AS is_only_template_9,
  t0.extra_data AS extra_data_10,
  t0.updated_at AS updated_at_11,
  t0.delivery_code AS delivery_code_12,
  t0.hotel_id AS hotel_id_13,
  t0.user_id AS user_id_14,
  t0.accepted_by_id AS accepted_by_id_15
FROM
  `order` t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_confirmed AS is_confirmed_3, t0.status AS status_4, t0.order_number AS order_number_5, t0.is_template AS is_template_6, t0.template_name AS template_name_7, t0.basket_number AS basket_number_8, t0.is_only_template AS is_only_template_9, t0.extra_data AS extra_data_10, t0.updated_at AS updated_at_11, t0.delivery_code AS delivery_code_12, t0.hotel_id AS hotel_id_13, t0.user_id AS user_id_14, t0.accepted_by_id AS accepted_by_id_15 FROM `order` t0 WHERE t0.user_id = 126;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
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 375)
8	App\Entity\User->countBasketOrders (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 179)
10	__TwigTemplate_8ea01d219fd81d3c4ebf21fd9bcaf9b9->doDisplay (line 360)
11	Twig\Template->yield (line 50)
12	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 307)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 217)
20	App\Controller\OrderController->show (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.13 ms
(7.84%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25, s0_.hour_limit AS hour_limit_26 FROM supplier s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.city AS city_2,
  s0_.address AS address_3,
  s0_.phone AS phone_4,
  s0_.email AS email_5,
  s0_.is_active AS is_active_6,
  s0_.crated_at AS crated_at_7,
  s0_.postcode AS postcode_8,
  s0_.email_txt AS email_txt_9,
  s0_.order_confirm_type AS order_confirm_type_10,
  s0_.col_name AS col_name_11,
  s0_.col_number AS col_number_12,
  s0_.col_price AS col_price_13,
  s0_.min_price AS min_price_14,
  s0_.col_ean AS col_ean_15,
  s0_.col_image AS col_image_16,
  s0_.col_pieces AS col_pieces_17,
  s0_.col_weight AS col_weight_18,
  s0_.nip AS nip_19,
  s0_.contact_name AS contact_name_20,
  s0_.contact_surname AS contact_surname_21,
  s0_.shortcut AS shortcut_22,
  s0_.payment_term AS payment_term_23,
  s0_.col_manufacture AS col_manufacture_24,
  s0_.email_type AS email_type_25,
  s0_.hour_limit AS hour_limit_26
FROM
  supplier s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25, s0_.hour_limit AS hour_limit_26 FROM supplier s0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 183)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 194)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 473)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
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 69)
21	Symfony\Component\Form\Extension\Core\Type\CollectionType->buildView (line 116)
22	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
23	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
24	Symfony\Component\Form\Form->createView (line 903)
25	Symfony\Component\Form\Form->createView (line 440)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 217)
29	App\Controller\OrderController->show (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.11 ms
(6.44%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  126
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.created_at AS created_at_8,
  t0.is_active AS is_active_9,
  t0.sell_limit AS sell_limit_10,
  t0.position AS position_11,
  t0.logo AS logo_12,
  t0.phone AS phone_13,
  t0.is_price_changed AS is_price_changed_14,
  t0.last_price_read_at AS last_price_read_at_15,
  t0.hotel_id AS hotel_id_16,
  t0.hotel_department_id AS hotel_department_id_17
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 WHERE t0.id = 126;

#	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 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (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 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.10 ms
(5.87%)

SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?

Parameters:

[
  20904
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.invoice_no AS invoice_no_2,
  t0.price AS price_3,
  t0.creation_date AS creation_date_4,
  t0.receipt_date AS receipt_date_5,
  t0.file AS file_6,
  t0.created_at AS created_at_7,
  t0.number AS number_8,
  t0.date_confirmed AS date_confirmed_9,
  t0.hash AS hash_10,
  t0.is_api AS is_api_11,
  t0.supplier_comment AS supplier_comment_12,
  t0.supplier_number AS supplier_number_13,
  t0.comment AS comment_14,
  t0.extra_data AS extra_data_15,
  t0.api_status AS api_status_16,
  t0.api_status_description AS api_status_description_17,
  t0.is_accepted AS is_accepted_18,
  t0.accepted_at AS accepted_at_19,
  t0.hotel_order_id AS hotel_order_id_20,
  t0.supplier_id AS supplier_id_21,
  t0.accepted_by_id AS accepted_by_id_22
FROM
  delivery t0
WHERE
  t0.hotel_order_id = ?

SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = 20904;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
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 178)
8	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->doDisplay (line 360)
9	Twig\Template->yield (line 335)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 1332)
12	Twig\Extension\CoreExtension::include (line 91)
13	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->block_body (line 430)
14	Twig\Template->yieldBlock (line 191)
15	__TwigTemplate_8ea01d219fd81d3c4ebf21fd9bcaf9b9->doDisplay (line 360)
16	Twig\Template->yield (line 50)
17	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->doDisplay (line 360)
18	Twig\Template->yield (line 335)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 307)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 217)
25	App\Controller\OrderController->show (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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.09 ms
(5.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26, t0.hour_limit AS hour_limit_27 FROM supplier t0 WHERE t0.id = ?

Parameters:

[
  18
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.is_active AS is_active_7,
  t0.crated_at AS crated_at_8,
  t0.postcode AS postcode_9,
  t0.email_txt AS email_txt_10,
  t0.order_confirm_type AS order_confirm_type_11,
  t0.col_name AS col_name_12,
  t0.col_number AS col_number_13,
  t0.col_price AS col_price_14,
  t0.min_price AS min_price_15,
  t0.col_ean AS col_ean_16,
  t0.col_image AS col_image_17,
  t0.col_pieces AS col_pieces_18,
  t0.col_weight AS col_weight_19,
  t0.nip AS nip_20,
  t0.contact_name AS contact_name_21,
  t0.contact_surname AS contact_surname_22,
  t0.shortcut AS shortcut_23,
  t0.payment_term AS payment_term_24,
  t0.col_manufacture AS col_manufacture_25,
  t0.email_type AS email_type_26,
  t0.hour_limit AS hour_limit_27
FROM
  supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26, t0.hour_limit AS hour_limit_27 FROM supplier t0 WHERE t0.id = 18;

#	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\Supplier::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 104)
7	Proxies\__CG__\App\Entity\Supplier->initializeLazyObject (line 20)
8	Proxies\__CG__\App\Entity\Supplier->__load (line 3029)
9	Doctrine\ORM\UnitOfWork->initializeObject (line 557)
10	Doctrine\ORM\EntityManager->initializeObject (line 89)
11	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
12	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
13	array_map (line 49)
14	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
15	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 34)
16	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 992)
17	Symfony\Component\Form\Form->normToView (line 301)
18	Symfony\Component\Form\Form->setData (line 50)
19	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
20	Symfony\Component\Form\Form->setData (line 50)
21	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
22	Symfony\Component\Form\Form->setData (line 50)
23	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
24	Symfony\Component\Form\Form->setData (line 412)
25	Symfony\Component\Form\Form->initialize (line 176)
26	Symfony\Component\Form\FormBuilder->getForm (line 28)
27	Symfony\Component\Form\FormFactory->create (line 340)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 211)
29	App\Controller\OrderController->show (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.09 ms
(5.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.city AS city_4, t0.address AS address_5, t0.month_limit AS month_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.postcode AS postcode_9, t0.email AS email_10, t0.shortcut AS shortcut_11, t0.logo AS logo_12, t0.www AS www_13, t0.nip AS nip_14 FROM hotel t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.city AS city_4,
  t0.address AS address_5,
  t0.month_limit AS month_limit_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.postcode AS postcode_9,
  t0.email AS email_10,
  t0.shortcut AS shortcut_11,
  t0.logo AS logo_12,
  t0.www AS www_13,
  t0.nip AS nip_14
FROM
  hotel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.city AS city_4, t0.address AS address_5, t0.month_limit AS month_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.postcode AS postcode_9, t0.email AS email_10, t0.shortcut AS shortcut_11, t0.logo AS logo_12, t0.www AS www_13, t0.nip AS nip_14 FROM hotel t0 WHERE t0.id = 2;

#	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\Hotel::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Hotel->__get (line 603)
8	App\Entity\Hotel->getShortcut (line 484)
9	App\Entity\Order->getFullNumber (line 578)
10	App\Entity\Order->__toString (line 114)
11	Twig\Runtime\EscaperRuntime->escape (line 67)
12	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 1332)
16	Twig\Extension\CoreExtension::include (line 91)
17	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->block_body (line 430)
18	Twig\Template->yieldBlock (line 191)
19	__TwigTemplate_8ea01d219fd81d3c4ebf21fd9bcaf9b9->doDisplay (line 360)
20	Twig\Template->yield (line 50)
21	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->doDisplay (line 360)
22	Twig\Template->yield (line 335)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 307)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 217)
29	App\Controller\OrderController->show (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.09 ms
(5.22%)

SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?

Parameters:

[
  20904
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.quantity AS quantity_3,
  t0.hotel_order_id AS hotel_order_id_4,
  t0.product_id AS product_id_5,
  t0.supplier_id AS supplier_id_6
FROM
  order_has_product t0
WHERE
  t0.hotel_order_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = 20904;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
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 545)
7	Doctrine\ORM\PersistentCollection->__clone (line 276)
8	Symfony\Component\Form\Form->setData (line 50)
9	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
10	Symfony\Component\Form\Form->setData (line 412)
11	Symfony\Component\Form\Form->initialize (line 176)
12	Symfony\Component\Form\FormBuilder->getForm (line 28)
13	Symfony\Component\Form\FormFactory->create (line 340)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 211)
15	App\Controller\OrderController->show (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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.09 ms
(5.05%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_confirmed AS is_confirmed_3, t0.status AS status_4, t0.order_number AS order_number_5, t0.is_template AS is_template_6, t0.template_name AS template_name_7, t0.basket_number AS basket_number_8, t0.is_only_template AS is_only_template_9, t0.extra_data AS extra_data_10, t0.updated_at AS updated_at_11, t0.delivery_code AS delivery_code_12, t0.hotel_id AS hotel_id_13, t0.user_id AS user_id_14, t0.accepted_by_id AS accepted_by_id_15 FROM `order` t0 WHERE t0.id = ?

Parameters:

[
  "20904"
]

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.is_confirmed AS is_confirmed_3,
  t0.status AS status_4,
  t0.order_number AS order_number_5,
  t0.is_template AS is_template_6,
  t0.template_name AS template_name_7,
  t0.basket_number AS basket_number_8,
  t0.is_only_template AS is_only_template_9,
  t0.extra_data AS extra_data_10,
  t0.updated_at AS updated_at_11,
  t0.delivery_code AS delivery_code_12,
  t0.hotel_id AS hotel_id_13,
  t0.user_id AS user_id_14,
  t0.accepted_by_id AS accepted_by_id_15
FROM
  `order` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_confirmed AS is_confirmed_3, t0.status AS status_4, t0.order_number AS order_number_5, t0.is_template AS is_template_6, t0.template_name AS template_name_7, t0.basket_number AS basket_number_8, t0.is_only_template AS is_only_template_9, t0.extra_data AS extra_data_10, t0.updated_at AS updated_at_11, t0.delivery_code AS delivery_code_12, t0.hotel_id AS hotel_id_13, t0.user_id AS user_id_14, t0.accepted_by_id AS accepted_by_id_15 FROM `order` t0 WHERE t0.id = '20904';

#	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 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.08 ms
(4.76%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.hotel_id AS hotel_id_4 FROM hotel_department_code t0 INNER JOIN user_hotel_department_code ON t0.id = user_hotel_department_code.hotel_department_code_id WHERE user_hotel_department_code.user_id = ?

Parameters:

[
  126
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.hotel_id AS hotel_id_4
FROM
  hotel_department_code t0
  INNER JOIN user_hotel_department_code ON t0.id = user_hotel_department_code.hotel_department_code_id
WHERE
  user_hotel_department_code.user_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.hotel_id AS hotel_id_4 FROM hotel_department_code t0 INNER JOIN user_hotel_department_code ON t0.id = user_hotel_department_code.hotel_department_code_id WHERE user_hotel_department_code.user_id = 126;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
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 22)
8	App\Form\OrderType->buildForm (line 102)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 340)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 211)
15	App\Controller\OrderController->show (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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.08 ms
(4.58%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM product_category t0 WHERE t0.id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM product_category t0 WHERE t0.id = 22;

#	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\ProductCategory::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\ProductCategory->__get (line 88)
8	App\Entity\ProductCategory->__toString (line 114)
9	Twig\Runtime\EscaperRuntime->escape (line 588)
10	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->{closure} (line 1775)
11	Twig\Extension\CoreExtension::captureOutput (line 626)
12	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->macro_item_row (line 1228)
13	Twig\Extension\CoreExtension::callMacro (line 277)
14	__TwigTemplate_3ebf2fcf7e33dbf1047935e3042a33e2->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 1332)
18	Twig\Extension\CoreExtension::include (line 91)
19	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->block_body (line 430)
20	Twig\Template->yieldBlock (line 191)
21	__TwigTemplate_8ea01d219fd81d3c4ebf21fd9bcaf9b9->doDisplay (line 360)
22	Twig\Template->yield (line 50)
23	__TwigTemplate_c138e07a509d6037c7968198ea5b2d53->doDisplay (line 360)
24	Twig\Template->yield (line 335)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 307)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 217)
31	App\Controller\OrderController->show (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	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\Hotel	No errors.
App\Entity\HotelDepartment	No errors.
App\Entity\Order	No errors.
App\Entity\Product	No errors.
App\Entity\Delivery	No errors.
App\Entity\HotelDepartmentCode	No errors.
App\Entity\OrderHasProduct	No errors.
App\Entity\OrderHasNotice	No errors.
App\Entity\SystemLog	No errors.
App\Entity\Supplier	No errors.
App\Entity\SupplierHasProduct	No errors.
App\Entity\HotelHasSupplier	No errors.
App\Entity\HotelDepartmentsExcludeSupplier	No errors.
App\Entity\HotelHasProductLimit	No errors.
App\Entity\HotelExcludeProduct	No errors.
App\Entity\DeliveryHasNotice	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\OrderProduct	No errors.
App\Entity\HotelDepartmentHasExcludeCategory	No errors.

Symfony Profiler

GET https://zamowienia.dhapps.co.pl/order/20904

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping