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

Query Metrics

2 Database Queries
2 Different statements
44.67 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
26.97 ms
(60.37%)
1
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_.status_id AS status_id_6, o0_.payment_method_id AS payment_method_id_7, o0_.has_invoice AS has_invoice_8, o0_.invoice_series AS invoice_series_9, o0_.invoice_number AS invoice_number_10, o0_.paid AS paid_11, o0_.production_day_id AS production_day_id_12, o0_.user_created AS user_created_13, o0_.date_created AS date_created_14, o0_.is_active AS is_active_15, c1_.name AS name_16, c1_.alias AS alias_17, c2_.name AS name_18, u3_.firstname AS firstname_19, u3_.lastname AS lastname_20, c4_.name AS name_21, c4_.color AS color_22, c5_.name AS name_23, c5_.color AS color_24, c6_.label AS label_25, p7_.date AS date_26, p7_.is_active AS is_active_27 FROM `order` o0_ LEFT JOIN user u3_ ON (o0_.user_created = u3_.id) 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 config_order_source c4_ ON (o0_.source_id = c4_.id) LEFT JOIN config_order_status c5_ ON (o0_.status_id = c5_.id) LEFT JOIN config_payment_method c6_ ON (o0_.payment_method_id = c6_.id) LEFT JOIN production_day p7_ ON (o0_.production_day_id = p7_.id) WHERE o0_.company_id = ? AND o0_.is_deleted = ? AND (o0_.date_created BETWEEN ? AND ?) ORDER BY o0_.id DESC LIMIT 12 OFFSET 24
Parameters:
[
  1
  0
  "2025-12-01 00:00:00"
  "2025-12-31 23:59:59"
]
17.70 ms
(39.63%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.company_id = ? AND o0_.is_deleted = ? AND (o0_.date_created BETWEEN ? AND ?) LIMIT 1
Parameters:
[
  1
  0
  "2025-12-01 00:00:00"
  "2025-12-31 23:59:59"
]

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