POST https://tata-bebe.primo.business-erp.ro/production/get-product-necessary-report

Query Metrics

55 Database Queries
3 Different statements
41.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.