Query Metrics
8
Database Queries
8
Different statements
5.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.21 ms (56.93%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
|
0.96 ms (17.07%) |
1 |
UPDATE delivery SET date_confirmed = ?, supplier_comment = ?, supplier_number = ? WHERE id = ?
Parameters:
[ "2026-02-10" "" "" 9032 ]
|
||||||||||||||||||||||||||||||||||
|
0.60 ms (10.65%) |
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 = ? LIMIT 1
Parameters:
[
"aa05f78d67c3085b81d3d9ebb836beca"
]
|
||||||||||||||||||||||||||||||||||
|
0.32 ms (5.60%) |
1 |
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:
[
125
]
|
||||||||||||||||||||||||||||||||||
|
0.15 ms (2.66%) |
1 |
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
]
|
||||||||||||||||||||||||||||||||||
|
0.14 ms (2.53%) |
1 |
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 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
30
]
|
||||||||||||||||||||||||||||||||||
|
0.14 ms (2.48%) |
1 |
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
]
|
||||||||||||||||||||||||||||||||||
|
0.12 ms (2.07%) |
1 |
"START TRANSACTION"
Parameters:
[]
|
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\SupplierHasProduct | No errors. |
| App\Entity\HotelHasSupplier | No errors. |
| App\Entity\HotelDepartmentsExcludeSupplier | No errors. |
| App\Entity\OrderHasProduct | No errors. |
| App\Entity\OrderHasNotice | No errors. |
| App\Entity\Hotel | No errors. |
| App\Entity\HotelDepartment | No errors. |
| App\Entity\HotelHasProductLimit | No errors. |
| App\Entity\HotelExcludeProduct | No errors. |
| App\Entity\Product | No errors. |