POST https://tata-bebe.primo.business-erp.ro/production/order-list

Query Metrics

14 Database Queries
4 Different statements
7.78 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.86 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
  "2025-12-06 00:00:00"
  1
]
2 1.94 ms
SELECT o0_.id AS id_0, o0_.platform_id AS platform_id_1, o0_.source_id AS source_id_2, o0_.type_id AS type_id_3, o0_.client_id AS client_id_4, o0_.client_work_point_id AS client_work_point_id_5, o0_.car_id AS car_id_6, o0_.driver_id AS driver_id_7, o0_.delivery_date AS delivery_date_8, o0_.production_day_id AS production_day_id_9, o0_.status_id AS status_id_10, o0_.payment_method_id AS payment_method_id_11, o0_.has_invoice AS has_invoice_12, o0_.invoice_series AS invoice_series_13, o0_.invoice_number AS invoice_number_14, o0_.has_storno_invoice AS has_storno_invoice_15, o0_.storno_invoice_number AS storno_invoice_number_16, o0_.storno_invoice_series AS storno_invoice_series_17, o0_.has_cargo_notice AS has_cargo_notice_18, o0_.cargo_notice_file AS cargo_notice_file_19, o0_.user_created AS user_created_20, o0_.date_created AS date_created_21, o0_.is_active AS is_active_22, c1_.name AS name_23, c1_.alias AS alias_24, c2_.name AS name_25, d3_.firstname AS firstname_26, d3_.lastname AS lastname_27, c4_.name AS name_28, c4_.color AS color_29, c5_.label AS label_30, c5_.collected AS collected_31, c5_.collected_not_vat AS collected_not_vat_32, p6_.date AS date_33 FROM `order` o0_ LEFT JOIN client c1_ ON (o0_.client_id = c1_.id) LEFT JOIN client_work_point c2_ ON (o0_.client_work_point_id = c2_.id) LEFT JOIN driver d3_ ON (o0_.driver_id = d3_.id) LEFT JOIN config_payment_method c5_ ON (o0_.payment_method_id = c5_.id) LEFT JOIN config_order_status c4_ ON (o0_.status_id = c4_.id) LEFT JOIN production_day p6_ ON (o0_.production_day_id = p6_.id) WHERE o0_.company_id = ? AND o0_.is_active = ? AND p6_.date = ? AND o0_.production_day_id = ? AND o0_.driver_id = ? ORDER BY o0_.id DESC
Parameters:
[
  1
  1
  "2025-12-06 00:00:00"
  210
  7
]
3 0.47 ms
SELECT c0_.id AS id_0, c0_.platform_id AS platform_id_1, c0_.name AS name_2, c0_.color AS color_3, c0_.selectable AS selectable_4, c0_.is_active AS is_active_5 FROM config_order_status c0_ WHERE c0_.platform_id = ? AND c0_.is_active = ?
Parameters:
[
  1
  1
]
4 0.60 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9570
  1
  1
]
5 0.39 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9569
  1
  1
]
6 0.42 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9568
  1
  1
]
7 0.37 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9566
  1
  1
]
8 0.41 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9559
  1
  1
]
9 0.39 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9552
  1
  1
]
10 0.40 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9551
  1
  1
]
11 0.38 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9550
  1
  1
]
12 0.37 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9548
  1
  1
]
13 0.37 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9546
  1
  1
]
14 0.41 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ? LIMIT 1
Parameters:
[
  9545
  1
  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