Symfony Profiler

Query Metrics

13 Database Queries

5 Different statements

1.70 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.61 ms
(35.65%)

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:

[
  21250
]

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 = 21250;

#	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 40)
9	App\Service\ExcelService->createOrderFile (line 274)
10	App\Controller\DeliveryController->excelAction (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.53 ms
(31.26%)

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:

[
  21250
]

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 = 21250;

#	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 31)
9	PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder->bindValue (line 236)
10	PhpOffice\PhpSpreadsheet\Cell\Cell->setValue (line 1117)
11	PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->setCellValue (line 38)
12	App\Service\ExcelService->createOrderFile (line 274)
13	App\Controller\DeliveryController->excelAction (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.20 ms
(11.99%)

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.hash = ? LIMIT 1

Parameters:

[
  "aa05f78d67c3085b81d3d9ebb836beca"
]

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.hash = ?
LIMIT
  1

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.hash = 'aa05f78d67c3085b81d3d9ebb836beca' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 270)
5	App\Controller\DeliveryController->excelAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.20 ms
(11.76%)

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.hotel_id AS hotel_id_12, t0.user_id AS user_id_13, t0.accepted_by_id AS accepted_by_id_14 FROM `order` t0 WHERE t0.id = ?

Parameters:

[
  9173
]

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.hotel_id AS hotel_id_12,
  t0.user_id AS user_id_13,
  t0.accepted_by_id AS accepted_by_id_14
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.hotel_id AS hotel_id_12, t0.user_id AS user_id_13, t0.accepted_by_id AS accepted_by_id_14 FROM `order` t0 WHERE t0.id = 9173;

#	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\Order::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Order->__get (line 195)
8	App\Entity\Order->getOrderHasProducts (line 34)
9	App\Service\ExcelService->createOrderFile (line 274)
10	App\Controller\DeliveryController->excelAction (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.16 ms
(9.35%)

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:

[
  9173
]

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 = 9173;

#	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 34)
8	App\Service\ExcelService->createOrderFile (line 274)
9	App\Controller\DeliveryController->excelAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\Delivery	No errors.
App\Entity\Order	No errors.
App\Entity\Supplier	No errors.
App\Entity\User	No errors.
App\Entity\DeliveryHasNotice	No errors.
App\Entity\SystemLog	No errors.
App\Entity\Hotel	No errors.
App\Entity\OrderHasProduct	No errors.
App\Entity\OrderHasNotice	No errors.
App\Entity\Product	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\SupplierHasProduct	No errors.
App\Entity\HotelHasProductLimit	No errors.
App\Entity\HotelExcludeProduct	No errors.
App\Entity\OrderProduct	No errors.

Symfony Profiler

GET https://zamowienia.dhapps.co.pl/delivery/aa05f78d67c3085b81d3d9ebb836beca/excel/download

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping