Query Metrics
8
Database Queries
3
Different statements
2.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.39 ms |
SELECT o0_.id AS id_0, o0_.supply_date AS supply_date_1 FROM `order` o0_ WHERE o0_.supply_date = ?
Parameters:
[
"2025-02-25 00:00:00"
]
|
| 2 | 0.29 ms |
SELECT t0.id AS id_1, t0.requested_qty AS requested_qty_2, t0.xorder_id AS xorder_id_3, t0.product_type_id AS product_type_id_4 FROM order_line t0 WHERE t0.xorder_id = ?
Parameters:
[
17
]
|
| 3 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.expiry_days AS expiry_days_5, t0.husky_code AS husky_code_6, t0.tspoon_code AS tspoon_code_7, t0.production_type AS production_type_8, t0.production_day AS production_day_9, t0.withdrawal_day AS withdrawal_day_10, t0.category_id AS category_id_11 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 4 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.expiry_days AS expiry_days_5, t0.husky_code AS husky_code_6, t0.tspoon_code AS tspoon_code_7, t0.production_type AS production_type_8, t0.production_day AS production_day_9, t0.withdrawal_day AS withdrawal_day_10, t0.category_id AS category_id_11 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
59
]
|
| 5 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.expiry_days AS expiry_days_5, t0.husky_code AS husky_code_6, t0.tspoon_code AS tspoon_code_7, t0.production_type AS production_type_8, t0.production_day AS production_day_9, t0.withdrawal_day AS withdrawal_day_10, t0.category_id AS category_id_11 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
64
]
|
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.expiry_days AS expiry_days_5, t0.husky_code AS husky_code_6, t0.tspoon_code AS tspoon_code_7, t0.production_type AS production_type_8, t0.production_day AS production_day_9, t0.withdrawal_day AS withdrawal_day_10, t0.category_id AS category_id_11 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
74
]
|
| 7 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.expiry_days AS expiry_days_5, t0.husky_code AS husky_code_6, t0.tspoon_code AS tspoon_code_7, t0.production_type AS production_type_8, t0.production_day AS production_day_9, t0.withdrawal_day AS withdrawal_day_10, t0.category_id AS category_id_11 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
155
]
|
| 8 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.expiry_days AS expiry_days_5, t0.husky_code AS husky_code_6, t0.tspoon_code AS tspoon_code_7, t0.production_type AS production_type_8, t0.production_day AS production_day_9, t0.withdrawal_day AS withdrawal_day_10, t0.category_id AS category_id_11 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
237
]
|
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\Order | No errors. |
| App\Entity\OrderLine | No errors. |
| App\Entity\ProductType | No errors. |
| App\Entity\PickListLine | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\StockLevel | No errors. |