82.34 ms
(69.82%)
|
1 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id WHERE o0_.status <> ? AND o0_.hotel_id = ? GROUP BY o0_.id
Parameters: [
"template"
22
]
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id WHERE o0_.status <> 'template' AND o0_.hotel_id = 22 GROUP BY o0_.id;
|
8.87 ms
(7.52%)
|
50 |
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = 14271;
|
8.19 ms
(6.95%)
|
50 |
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 = ?
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 = 14271;
|
5.26 ms
(4.46%)
|
35 |
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 = ?
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 = 2;
|
3.91 ms
(3.31%)
|
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.is_confirmed AS is_confirmed_2, o0_.status AS status_3, o0_.order_number AS order_number_4, o0_.is_template AS is_template_5, o0_.template_name AS template_name_6, o0_.basket_number AS basket_number_7, o0_.is_only_template AS is_only_template_8, o0_.extra_data AS extra_data_9, o0_.updated_at AS updated_at_10, o0_.delivery_code AS delivery_code_11, o0_.hotel_id AS hotel_id_12, o0_.user_id AS user_id_13, o0_.accepted_by_id AS accepted_by_id_14 FROM `order` o0_ LEFT JOIN delivery d1_ ON o0_.id = d1_.hotel_order_id WHERE (d1_.date_confirmed IS NOT NULL AND d1_.invoice_no IS NULL AND d1_.file IS NULL) AND d1_.date_confirmed < ? AND o0_.hotel_id = ?
Parameters: [
"2026-05-15 19:06:46"
22
]
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.is_confirmed AS is_confirmed_2, o0_.status AS status_3, o0_.order_number AS order_number_4, o0_.is_template AS is_template_5, o0_.template_name AS template_name_6, o0_.basket_number AS basket_number_7, o0_.is_only_template AS is_only_template_8, o0_.extra_data AS extra_data_9, o0_.updated_at AS updated_at_10, o0_.delivery_code AS delivery_code_11, o0_.hotel_id AS hotel_id_12, o0_.user_id AS user_id_13, o0_.accepted_by_id AS accepted_by_id_14 FROM `order` o0_ LEFT JOIN delivery d1_ ON o0_.id = d1_.hotel_order_id WHERE (d1_.date_confirmed IS NOT NULL AND d1_.invoice_no IS NULL AND d1_.file IS NULL) AND d1_.date_confirmed < '2026-05-15 19:06:46' AND o0_.hotel_id = 22;
|
1.99 ms
(1.69%)
|
1 |
SELECT DISTINCT o0_.id AS id_0, o0_.id AS id_1 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id WHERE o0_.status <> ? AND o0_.hotel_id = ? GROUP BY o0_.id ORDER BY o0_.id DESC LIMIT 50
Parameters: [
"template"
22
]
SELECT DISTINCT o0_.id AS id_0, o0_.id AS id_1 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id WHERE o0_.status <> 'template' AND o0_.hotel_id = 22 GROUP BY o0_.id ORDER BY o0_.id DESC LIMIT 50;
|
1.78 ms
(1.51%)
|
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.is_confirmed AS is_confirmed_2, o0_.status AS status_3, o0_.order_number AS order_number_4, o0_.is_template AS is_template_5, o0_.template_name AS template_name_6, o0_.basket_number AS basket_number_7, o0_.is_only_template AS is_only_template_8, o0_.extra_data AS extra_data_9, o0_.updated_at AS updated_at_10, o0_.delivery_code AS delivery_code_11, o0_.hotel_id AS hotel_id_12, o0_.user_id AS user_id_13, o0_.accepted_by_id AS accepted_by_id_14 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id WHERE o0_.status <> ? AND o0_.hotel_id = ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY o0_.id ORDER BY o0_.id DESC
Parameters: [
"template"
22
14271
14268
14259
14240
14235
14234
14233
14229
14226
14182
14156
14155
14145
14144
14143
14142
14094
14093
14089
14076
14075
14073
14072
14036
14024
14017
14006
13978
13974
13959
13956
13907
13906
13885
13877
13836
13822
13818
13814
13788
13776
13764
13763
13724
13714
13694
13657
13629
13626
13612
]
SELECT
o0_.id AS id_0,
o0_.created_at AS created_at_1,
o0_.is_confirmed AS is_confirmed_2,
o0_.status AS status_3,
o0_.order_number AS order_number_4,
o0_.is_template AS is_template_5,
o0_.template_name AS template_name_6,
o0_.basket_number AS basket_number_7,
o0_.is_only_template AS is_only_template_8,
o0_.extra_data AS extra_data_9,
o0_.updated_at AS updated_at_10,
o0_.delivery_code AS delivery_code_11,
o0_.hotel_id AS hotel_id_12,
o0_.user_id AS user_id_13,
o0_.accepted_by_id AS accepted_by_id_14
FROM
`order` o0_
LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id
LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id
LEFT JOIN product p3_ ON o1_.product_id = p3_.id
LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id
WHERE
o0_.status <> ?
AND o0_.hotel_id = ?
AND o0_.id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?
)
GROUP BY
o0_.id
ORDER BY
o0_.id DESC
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.is_confirmed AS is_confirmed_2, o0_.status AS status_3, o0_.order_number AS order_number_4, o0_.is_template AS is_template_5, o0_.template_name AS template_name_6, o0_.basket_number AS basket_number_7, o0_.is_only_template AS is_only_template_8, o0_.extra_data AS extra_data_9, o0_.updated_at AS updated_at_10, o0_.delivery_code AS delivery_code_11, o0_.hotel_id AS hotel_id_12, o0_.user_id AS user_id_13, o0_.accepted_by_id AS accepted_by_id_14 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id WHERE o0_.status <> 'template' AND o0_.hotel_id = 22 AND o0_.id IN (14271, 14268, 14259, 14240, 14235, 14234, 14233, 14229, 14226, 14182, 14156, 14155, 14145, 14144, 14143, 14142, 14094, 14093, 14089, 14076, 14075, 14073, 14072, 14036, 14024, 14017, 14006, 13978, 13974, 13959, 13956, 13907, 13906, 13885, 13877, 13836, 13822, 13818, 13814, 13788, 13776, 13764, 13763, 13724, 13714, 13694, 13657, 13629, 13626, 13612) GROUP BY o0_.id ORDER BY o0_.id DESC;
|
1.49 ms
(1.27%)
|
1 |
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.user_id = ?
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.user_id = 21;
|
1.47 ms
(1.24%)
|
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.is_confirmed AS is_confirmed_2, o0_.status AS status_3, o0_.order_number AS order_number_4, o0_.is_template AS is_template_5, o0_.template_name AS template_name_6, o0_.basket_number AS basket_number_7, o0_.is_only_template AS is_only_template_8, o0_.extra_data AS extra_data_9, o0_.updated_at AS updated_at_10, o0_.delivery_code AS delivery_code_11, o0_.hotel_id AS hotel_id_12, o0_.user_id AS user_id_13, o0_.accepted_by_id AS accepted_by_id_14 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN product p2_ ON o1_.product_id = p2_.id LEFT JOIN supplier_has_product s3_ ON p2_.id = s3_.product_id WHERE o0_.status = ? AND o0_.hotel_id = ?
Parameters: [
"to_accept"
22
]
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.is_confirmed AS is_confirmed_2, o0_.status AS status_3, o0_.order_number AS order_number_4, o0_.is_template AS is_template_5, o0_.template_name AS template_name_6, o0_.basket_number AS basket_number_7, o0_.is_only_template AS is_only_template_8, o0_.extra_data AS extra_data_9, o0_.updated_at AS updated_at_10, o0_.delivery_code AS delivery_code_11, o0_.hotel_id AS hotel_id_12, o0_.user_id AS user_id_13, o0_.accepted_by_id AS accepted_by_id_14 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN product p2_ ON o1_.product_id = p2_.id LEFT JOIN supplier_has_product s3_ ON p2_.id = s3_.product_id WHERE o0_.status = 'to_accept' AND o0_.hotel_id = 22;
|
0.75 ms
(0.64%)
|
1 |
SELECT t0.id AS id_1, t0.hotel_id AS hotel_id_2, t0.supplier_id AS supplier_id_3 FROM hotel_has_supplier t0 WHERE t0.hotel_id = ?
SELECT t0.id AS id_1, t0.hotel_id AS hotel_id_2, t0.supplier_id AS supplier_id_3 FROM hotel_has_supplier t0 WHERE t0.hotel_id = 22;
|
0.40 ms
(0.34%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.city AS city_4, t0.address AS address_5, t0.month_limit AS month_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.postcode AS postcode_9, t0.email AS email_10, t0.shortcut AS shortcut_11, t0.logo AS logo_12, t0.www AS www_13, t0.nip AS nip_14 FROM hotel t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.city AS city_4, t0.address AS address_5, t0.month_limit AS month_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.postcode AS postcode_9, t0.email AS email_10, t0.shortcut AS shortcut_11, t0.logo AS logo_12, t0.www AS www_13, t0.nip AS nip_14 FROM hotel t0 WHERE t0.id = 22;
|
0.33 ms
(0.28%)
|
1 |
SELECT t0.id AS id_1, t0.hotel_department_id AS hotel_department_id_2, t0.product_category_id AS product_category_id_3 FROM hotel_department_has_exclude_category t0 WHERE t0.hotel_department_id = ?
SELECT t0.id AS id_1, t0.hotel_department_id AS hotel_department_id_2, t0.product_category_id AS product_category_id_3 FROM hotel_department_has_exclude_category t0 WHERE t0.hotel_department_id = 84;
|
0.29 ms
(0.25%)
|
1 |
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 = ?
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 = 21;
|
0.28 ms
(0.24%)
|
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.first_name AS first_name_5, u0_.last_name AS last_name_6, u0_.created_at AS created_at_7, u0_.is_active AS is_active_8, u0_.sell_limit AS sell_limit_9, u0_.position AS position_10, u0_.logo AS logo_11, u0_.phone AS phone_12, u0_.is_price_changed AS is_price_changed_13, u0_.last_price_read_at AS last_price_read_at_14, u0_.hotel_id AS hotel_id_15, u0_.hotel_department_id AS hotel_department_id_16 FROM `user` u0_ WHERE u0_.hotel_id = ? ORDER BY u0_.first_name ASC
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.first_name AS first_name_5, u0_.last_name AS last_name_6, u0_.created_at AS created_at_7, u0_.is_active AS is_active_8, u0_.sell_limit AS sell_limit_9, u0_.position AS position_10, u0_.logo AS logo_11, u0_.phone AS phone_12, u0_.is_price_changed AS is_price_changed_13, u0_.last_price_read_at AS last_price_read_at_14, u0_.hotel_id AS hotel_id_15, u0_.hotel_department_id AS hotel_department_id_16 FROM `user` u0_ WHERE u0_.hotel_id = 22 ORDER BY u0_.first_name ASC;
|
0.28 ms
(0.24%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sell_limit AS sell_limit_3, t0.hotel_id AS hotel_id_4 FROM hotel_department t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.sell_limit AS sell_limit_3, t0.hotel_id AS hotel_id_4 FROM hotel_department t0 WHERE t0.id = 84;
|
0.18 ms
(0.15%)
|
1 |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.phone AS phone_2, h0_.city AS city_3, h0_.address AS address_4, h0_.month_limit AS month_limit_5, h0_.is_active AS is_active_6, h0_.created_at AS created_at_7, h0_.postcode AS postcode_8, h0_.email AS email_9, h0_.shortcut AS shortcut_10, h0_.logo AS logo_11, h0_.www AS www_12, h0_.nip AS nip_13 FROM hotel h0_ WHERE h0_.id = ? ORDER BY h0_.name ASC
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.phone AS phone_2, h0_.city AS city_3, h0_.address AS address_4, h0_.month_limit AS month_limit_5, h0_.is_active AS is_active_6, h0_.created_at AS created_at_7, h0_.postcode AS postcode_8, h0_.email AS email_9, h0_.shortcut AS shortcut_10, h0_.logo AS logo_11, h0_.www AS www_12, h0_.nip AS nip_13 FROM hotel h0_ WHERE h0_.id = 22 ORDER BY h0_.name ASC;
|
0.11 ms
(0.09%)
|
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM product_category p0_ ORDER BY p0_.name ASC
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM product_category p0_ ORDER BY p0_.name ASC;
|