Query Metrics
55
Database Queries
3
Different statements
41.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
34.00 ms (81.22%) |
53 |
SELECT o0_.id AS id_0, o0_.company_id AS company_id_1, o0_.platform_id AS platform_id_2, o0_.order_id AS order_id_3, o0_.product_id AS product_id_4, o0_.product_price_id AS product_price_id_5, o0_.product_recipe_id AS product_recipe_id_6, o0_.quantity AS quantity_7, o0_.unit_final_price AS unit_final_price_8, o0_.is_active AS is_active_9, p1_.product_id AS product_id_10, p1_.vat_id AS vat_id_11, p1_.currency_id AS currency_id_12, p2_.category_id AS category_id_13, p2_.name AS name_14, p2_.weight AS weight_15, p2_.weight_unit_id AS weight_unit_id_16, p2_.product_unit_id AS product_unit_id_17, p2_.shuttle AS shuttle_18, p3_.name AS name_19, u4_.label AS label_20, u5_.label AS label_21, p6_.label AS label_22 FROM order_product o0_ LEFT JOIN product_price p1_ ON (o0_.product_price_id = p1_.id) LEFT JOIN product p2_ ON (o0_.product_id = p2_.id) LEFT JOIN product_category p3_ ON (p2_.category_id = p3_.id) LEFT JOIN unit u4_ ON (p2_.weight_unit_id = u4_.id) LEFT JOIN unit u5_ ON (p2_.product_unit_id = u5_.id) LEFT JOIN product_recipe p6_ ON (o0_.product_recipe_id = p6_.id) WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ?
Parameters:
[ 13174 1 1 ]
|
||||||||||||||||||||||||||||||
|
7.14 ms (17.05%) |
1 |
SELECT o0_.id AS id_0, o0_.production_day_id AS production_day_id_1 FROM `order` o0_ WHERE o0_.company_id = ? AND o0_.is_active = ? AND o0_.production_day_id = ? AND o0_.status_id >= ? ORDER BY o0_.id DESC
Parameters:
[ 1 1 0 3 ]
|
||||||||||||||||||||||||||||||
|
0.73 ms (1.74%) |
1 |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1 FROM production_day p0_ WHERE p0_.company_id = ? AND p0_.date = ? AND p0_.is_active = ? LIMIT 1
Parameters:
[ 1 "2026-03-12 00:00:00" 1 ]
|
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\ProductionDay | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\OrderProduct | No errors. |
| App\Entity\ProductPrice | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductCategory | No errors. |
| App\Entity\Unit | No errors. |
| App\Entity\ProductRecipe | No errors. |