POST https://core.relaxmoma.cz/statictics/orders

Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 0.30 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.locale AS locale_7, t0.avatar AS avatar_8, t0.is_verified AS is_verified_9, t0.createts AS createts_10, t0.editts AS editts_11, t0.create_user_id AS create_user_id_12, t0.edit_user_id AS edit_user_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 404.38 ms
SELECT o0_.id AS id_0, o0_.order_id AS order_id_1, o0_.external_order_id AS external_order_id_2, o0_.source AS source_3, o0_.status_id_bl AS status_id_bl_4, o0_.core_status AS core_status_5, o0_.is_confirmed AS is_confirmed_6, o0_.createts AS createts_7, o0_.must_be_send AS must_be_send_8, o0_.currency AS currency_9, o0_.payment AS payment_10, o0_.phone AS phone_11, o0_.email AS email_12, o0_.delivery AS delivery_13, o0_.delivery_price AS delivery_price_14, o0_.profit_percent AS profit_percent_15, o0_.profit AS profit_16, o0_.order_page AS order_page_17, o0_.amount_paid AS amount_paid_18, o0_.user_comment AS user_comment_19, o0_.admin_comment AS admin_comment_20, o0_.data AS data_21, o1_.id AS id_22, o1_.code AS code_23, o1_.ean AS ean_24, o1_.price AS price_25, o1_.vat AS vat_26, o1_.quantity AS quantity_27, o1_.name AS name_28, o0_.status_id AS status_id_29, o1_.order_id AS order_id_30, o1_.stock_id AS stock_id_31, o1_.variant_id AS variant_id_32, o1_.supplier_id AS supplier_id_33 FROM `order` o0_ LEFT JOIN order_item o1_ ON o0_.id = o1_.order_id WHERE (o0_.createts BETWEEN ? AND ?) AND o0_.status_id NOT IN (?, ?, ?)
Parameters:
[
  "2025-04-01 00:00:00"
  "2025-04-30 23:59:59"
  4
  10
  16
]

Database Connections

Name Service
default doctrine.dbal.default_connection
ms5 doctrine.dbal.ms5_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\User No errors.
App\Entity\Order No errors.
App\Entity\OrderItem No errors.
App\Entity\OrderStatus No errors.
App\Entity\Stock No errors.
App\Entity\Variant No errors.
App\Entity\Supplier No errors.
App\Entity\OrderAddress No errors.