Query Metrics
69
Database Queries
4
Different statements
51.36 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.71 ms |
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 ]
|
||||||||||||||||||||||||||||||
| 2 | 6.33 ms |
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 ]
|
||||||||||||||||||||||||||||||
| 3 | 1.02 ms |
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 ]
|
||||||||||||||||||||||||||||||
| 4 | 0.68 ms |
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:
[ 13173 1 1 ]
|
||||||||||||||||||||||||||||||
| 5 | 0.59 ms |
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:
[ 13172 1 1 ]
|
||||||||||||||||||||||||||||||
| 6 | 0.55 ms |
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:
[ 13171 1 1 ]
|
||||||||||||||||||||||||||||||
| 7 | 0.52 ms |
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:
[ 13170 1 1 ]
|
||||||||||||||||||||||||||||||
| 8 | 0.57 ms |
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:
[ 13169 1 1 ]
|
||||||||||||||||||||||||||||||
| 9 | 1.19 ms |
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:
[ 13168 1 1 ]
|
||||||||||||||||||||||||||||||
| 10 | 0.59 ms |
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:
[ 13167 1 1 ]
|
||||||||||||||||||||||||||||||
| 11 | 0.55 ms |
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:
[ 13166 1 1 ]
|
||||||||||||||||||||||||||||||
| 12 | 0.53 ms |
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:
[ 13165 1 1 ]
|
||||||||||||||||||||||||||||||
| 13 | 0.77 ms |
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:
[ 13164 1 1 ]
|
||||||||||||||||||||||||||||||
| 14 | 0.50 ms |
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:
[ 13163 1 1 ]
|
||||||||||||||||||||||||||||||
| 15 | 1.19 ms |
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:
[ 13162 1 1 ]
|
||||||||||||||||||||||||||||||
| 16 | 0.58 ms |
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:
[ 13161 1 1 ]
|
||||||||||||||||||||||||||||||
| 17 | 0.52 ms |
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:
[ 13160 1 1 ]
|
||||||||||||||||||||||||||||||
| 18 | 0.53 ms |
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:
[ 13159 1 1 ]
|
||||||||||||||||||||||||||||||
| 19 | 0.80 ms |
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:
[ 13158 1 1 ]
|
||||||||||||||||||||||||||||||
| 20 | 0.93 ms |
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:
[ 13157 1 1 ]
|
||||||||||||||||||||||||||||||
| 21 | 0.58 ms |
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:
[ 13156 1 1 ]
|
||||||||||||||||||||||||||||||
| 22 | 0.83 ms |
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:
[ 13155 1 1 ]
|
||||||||||||||||||||||||||||||
| 23 | 0.52 ms |
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:
[ 13154 1 1 ]
|
||||||||||||||||||||||||||||||
| 24 | 1.01 ms |
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:
[ 13153 1 1 ]
|
||||||||||||||||||||||||||||||
| 25 | 0.52 ms |
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:
[ 13152 1 1 ]
|
||||||||||||||||||||||||||||||
| 26 | 0.53 ms |
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:
[ 13151 1 1 ]
|
||||||||||||||||||||||||||||||
| 27 | 0.53 ms |
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:
[ 13150 1 1 ]
|
||||||||||||||||||||||||||||||
| 28 | 1.11 ms |
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:
[ 13149 1 1 ]
|
||||||||||||||||||||||||||||||
| 29 | 0.54 ms |
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:
[ 13148 1 1 ]
|
||||||||||||||||||||||||||||||
| 30 | 0.52 ms |
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:
[ 13147 1 1 ]
|
||||||||||||||||||||||||||||||
| 31 | 0.57 ms |
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:
[ 13146 1 1 ]
|
||||||||||||||||||||||||||||||
| 32 | 0.60 ms |
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:
[ 13145 1 1 ]
|
||||||||||||||||||||||||||||||
| 33 | 0.75 ms |
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:
[ 13144 1 1 ]
|
||||||||||||||||||||||||||||||
| 34 | 1.12 ms |
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:
[ 13143 1 1 ]
|
||||||||||||||||||||||||||||||
| 35 | 1.11 ms |
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:
[ 13142 1 1 ]
|
||||||||||||||||||||||||||||||
| 36 | 0.59 ms |
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:
[ 13141 1 1 ]
|
||||||||||||||||||||||||||||||
| 37 | 0.60 ms |
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:
[ 13140 1 1 ]
|
||||||||||||||||||||||||||||||
| 38 | 0.60 ms |
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:
[ 13139 1 1 ]
|
||||||||||||||||||||||||||||||
| 39 | 0.68 ms |
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:
[ 13138 1 1 ]
|
||||||||||||||||||||||||||||||
| 40 | 0.80 ms |
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:
[ 13137 1 1 ]
|
||||||||||||||||||||||||||||||
| 41 | 0.94 ms |
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:
[ 13136 1 1 ]
|
||||||||||||||||||||||||||||||
| 42 | 1.28 ms |
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:
[ 13135 1 1 ]
|
||||||||||||||||||||||||||||||
| 43 | 0.77 ms |
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:
[ 13134 1 1 ]
|
||||||||||||||||||||||||||||||
| 44 | 0.65 ms |
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:
[ 13133 1 1 ]
|
||||||||||||||||||||||||||||||
| 45 | 0.79 ms |
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:
[ 13132 1 1 ]
|
||||||||||||||||||||||||||||||
| 46 | 0.65 ms |
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:
[ 13131 1 1 ]
|
||||||||||||||||||||||||||||||
| 47 | 1.10 ms |
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:
[ 13130 1 1 ]
|
||||||||||||||||||||||||||||||
| 48 | 0.69 ms |
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:
[ 13129 1 1 ]
|
||||||||||||||||||||||||||||||
| 49 | 1.30 ms |
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:
[ 13128 1 1 ]
|
||||||||||||||||||||||||||||||
| 50 | 0.91 ms |
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:
[ 13127 1 1 ]
|
||||||||||||||||||||||||||||||
| 51 | 0.64 ms |
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:
[ 13126 1 1 ]
|
||||||||||||||||||||||||||||||
| 52 | 0.61 ms |
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:
[ 13125 1 1 ]
|
||||||||||||||||||||||||||||||
| 53 | 0.60 ms |
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:
[ 13124 1 1 ]
|
||||||||||||||||||||||||||||||
| 54 | 0.59 ms |
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:
[ 13123 1 1 ]
|
||||||||||||||||||||||||||||||
| 55 | 0.60 ms |
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:
[ 13122 1 1 ]
|
||||||||||||||||||||||||||||||
| 56 | 0.40 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 15 1 ]
|
||||||||||||||||||||||||||||||
| 57 | 0.39 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 2 1 ]
|
||||||||||||||||||||||||||||||
| 58 | 0.39 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 5 1 ]
|
||||||||||||||||||||||||||||||
| 59 | 0.38 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 23 1 ]
|
||||||||||||||||||||||||||||||
| 60 | 0.39 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||||||
| 61 | 0.34 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 11 1 ]
|
||||||||||||||||||||||||||||||
| 62 | 0.41 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 3 1 ]
|
||||||||||||||||||||||||||||||
| 63 | 0.35 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 9 1 ]
|
||||||||||||||||||||||||||||||
| 64 | 0.38 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 6 1 ]
|
||||||||||||||||||||||||||||||
| 65 | 0.57 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 21 1 ]
|
||||||||||||||||||||||||||||||
| 66 | 0.37 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 24 1 ]
|
||||||||||||||||||||||||||||||
| 67 | 0.37 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 17 1 ]
|
||||||||||||||||||||||||||||||
| 68 | 0.37 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 13 1 ]
|
||||||||||||||||||||||||||||||
| 69 | 0.41 ms |
SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1
Parameters:
[ 20 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. |
| App\Entity\ProductCurrentStock | No errors. |