POST https://zamowienia.dhapps.co.pl/order/14279/edit

Query Metrics

45 Database Queries
15 Different statements
27.56 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.16 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  135
]
2 0.52 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_confirmed AS is_confirmed_3, t0.status AS status_4, t0.order_number AS order_number_5, t0.is_template AS is_template_6, t0.template_name AS template_name_7, t0.basket_number AS basket_number_8, t0.is_only_template AS is_only_template_9, t0.extra_data AS extra_data_10, t0.updated_at AS updated_at_11, t0.delivery_code AS delivery_code_12, t0.hotel_id AS hotel_id_13, t0.user_id AS user_id_14, t0.accepted_by_id AS accepted_by_id_15 FROM `order` t0 WHERE t0.id = ?
Parameters:
[
  "14279"
]
3 0.11 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.hotel_id AS hotel_id_4 FROM hotel_department_code t0 INNER JOIN user_hotel_department_code ON t0.id = user_hotel_department_code.hotel_department_code_id WHERE user_hotel_department_code.user_id = ?
Parameters:
[
  135
]
4 0.69 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  14279
]
5 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  74
]
6 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  4
]
7 0.15 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.hotel_order_id AS hotel_order_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_notice t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  14279
]
8 0.16 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
9 0.14 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
10 0.13 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
11 0.13 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
12 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
13 0.17 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
14 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
15 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
16 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
17 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
18 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
19 0.11 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
20 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
21 0.13 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
22 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
23 0.11 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
24 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
25 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
26 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
27 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
28 0.11 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
29 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
30 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
31 0.15 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "74"
]
32 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
33 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.id = ?
Parameters:
[
  20289.0
]
34 0.13 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city AS city_2, s0_.address AS address_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.is_active AS is_active_6, s0_.crated_at AS crated_at_7, s0_.postcode AS postcode_8, s0_.email_txt AS email_txt_9, s0_.order_confirm_type AS order_confirm_type_10, s0_.col_name AS col_name_11, s0_.col_number AS col_number_12, s0_.col_price AS col_price_13, s0_.min_price AS min_price_14, s0_.col_ean AS col_ean_15, s0_.col_image AS col_image_16, s0_.col_pieces AS col_pieces_17, s0_.col_weight AS col_weight_18, s0_.nip AS nip_19, s0_.contact_name AS contact_name_20, s0_.contact_surname AS contact_surname_21, s0_.shortcut AS shortcut_22, s0_.payment_term AS payment_term_23, s0_.col_manufacture AS col_manufacture_24, s0_.email_type AS email_type_25 FROM supplier s0_ WHERE s0_.id IN (?)
Parameters:
[
  "4"
]
35 0.11 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  14279
]
36 0.10 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.hotel_order_id AS hotel_order_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_notice t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  14279
]
37 0.16 ms
"START TRANSACTION"
Parameters:
[]
38 1.12 ms
INSERT INTO order_has_product (price, quantity, hotel_order_id, product_id, supplier_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "3.71"
  30
  14279
  20289
  4
]
39 0.21 ms
UPDATE `order` SET updated_at = ? WHERE id = ?
Parameters:
[
  "2026-05-15 18:15:42"
  14279
]
40 0.15 ms
UPDATE order_has_product SET price = ? WHERE id = ?
Parameters:
[
  "4.3"
  353310
]
41 1.44 ms
"COMMIT"
Parameters:
[]
42 14.37 ms
SELECT d0_.id AS id_0, d0_.invoice_no AS invoice_no_1, d0_.price AS price_2, d0_.creation_date AS creation_date_3, d0_.receipt_date AS receipt_date_4, d0_.file AS file_5, d0_.created_at AS created_at_6, d0_.number AS number_7, d0_.date_confirmed AS date_confirmed_8, d0_.hash AS hash_9, d0_.is_api AS is_api_10, d0_.supplier_comment AS supplier_comment_11, d0_.supplier_number AS supplier_number_12, d0_.comment AS comment_13, d0_.extra_data AS extra_data_14, d0_.api_status AS api_status_15, d0_.api_status_description AS api_status_description_16, d0_.is_accepted AS is_accepted_17, d0_.accepted_at AS accepted_at_18, d0_.hotel_order_id AS hotel_order_id_19, d0_.supplier_id AS supplier_id_20, d0_.accepted_by_id AS accepted_by_id_21 FROM delivery d0_ LEFT JOIN `order` o1_ ON d0_.hotel_order_id = o1_.id WHERE d0_.created_at LIKE ? AND o1_.hotel_id = ?
Parameters:
[
  "2026-05-15 %"
  16
]
43 2.23 ms
SELECT d0_.id AS id_0, d0_.invoice_no AS invoice_no_1, d0_.price AS price_2, d0_.creation_date AS creation_date_3, d0_.receipt_date AS receipt_date_4, d0_.file AS file_5, d0_.created_at AS created_at_6, d0_.number AS number_7, d0_.date_confirmed AS date_confirmed_8, d0_.hash AS hash_9, d0_.is_api AS is_api_10, d0_.supplier_comment AS supplier_comment_11, d0_.supplier_number AS supplier_number_12, d0_.comment AS comment_13, d0_.extra_data AS extra_data_14, d0_.api_status AS api_status_15, d0_.api_status_description AS api_status_description_16, d0_.is_accepted AS is_accepted_17, d0_.accepted_at AS accepted_at_18, d0_.hotel_order_id AS hotel_order_id_19, d0_.supplier_id AS supplier_id_20, d0_.accepted_by_id AS accepted_by_id_21 FROM delivery d0_ LEFT JOIN `order` o1_ ON d0_.hotel_order_id = o1_.id WHERE d0_.supplier_id = ? AND d0_.created_at < ? AND o1_.user_id = ? AND d0_.file IS NULL AND d0_.invoice_no IS NULL AND (d0_.api_status IS NULL OR d0_.api_status <> 2) LIMIT 1
Parameters:
[
  74
  "2026-05-01 00:00:00 %"
  135
]
44 0.16 ms
SELECT d0_.id AS id_0, d0_.invoice_no AS invoice_no_1, d0_.price AS price_2, d0_.creation_date AS creation_date_3, d0_.receipt_date AS receipt_date_4, d0_.file AS file_5, d0_.created_at AS created_at_6, d0_.number AS number_7, d0_.date_confirmed AS date_confirmed_8, d0_.hash AS hash_9, d0_.is_api AS is_api_10, d0_.supplier_comment AS supplier_comment_11, d0_.supplier_number AS supplier_number_12, d0_.comment AS comment_13, d0_.extra_data AS extra_data_14, d0_.api_status AS api_status_15, d0_.api_status_description AS api_status_description_16, d0_.is_accepted AS is_accepted_17, d0_.accepted_at AS accepted_at_18, d0_.hotel_order_id AS hotel_order_id_19, d0_.supplier_id AS supplier_id_20, d0_.accepted_by_id AS accepted_by_id_21 FROM delivery d0_ LEFT JOIN `order` o1_ ON d0_.hotel_order_id = o1_.id WHERE d0_.created_at LIKE ? AND o1_.hotel_id = ?
Parameters:
[
  "2026-05-15 %"
  16
]
45 2.08 ms
SELECT d0_.id AS id_0, d0_.invoice_no AS invoice_no_1, d0_.price AS price_2, d0_.creation_date AS creation_date_3, d0_.receipt_date AS receipt_date_4, d0_.file AS file_5, d0_.created_at AS created_at_6, d0_.number AS number_7, d0_.date_confirmed AS date_confirmed_8, d0_.hash AS hash_9, d0_.is_api AS is_api_10, d0_.supplier_comment AS supplier_comment_11, d0_.supplier_number AS supplier_number_12, d0_.comment AS comment_13, d0_.extra_data AS extra_data_14, d0_.api_status AS api_status_15, d0_.api_status_description AS api_status_description_16, d0_.is_accepted AS is_accepted_17, d0_.accepted_at AS accepted_at_18, d0_.hotel_order_id AS hotel_order_id_19, d0_.supplier_id AS supplier_id_20, d0_.accepted_by_id AS accepted_by_id_21 FROM delivery d0_ LEFT JOIN `order` o1_ ON d0_.hotel_order_id = o1_.id WHERE d0_.supplier_id = ? AND d0_.created_at < ? AND o1_.user_id = ? AND d0_.file IS NULL AND d0_.invoice_no IS NULL AND (d0_.api_status IS NULL OR d0_.api_status <> 2) LIMIT 1
Parameters:
[
  4
  "2026-05-01 00:00:00 %"
  135
]

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.