Symfony Profiler

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 = ?

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 = 21223;

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  delivery d0_
  LEFT JOIN `order` o1_ ON d0_.hotel_order_id = o1_.id
  LEFT JOIN `user` u2_ ON o1_.user_id = u2_.id
  LEFT JOIN hotel h3_ ON o1_.hotel_id = h3_.id
  LEFT JOIN order_has_product o4_ ON o1_.id = o4_.hotel_order_id
  LEFT JOIN supplier s5_ ON d0_.supplier_id = s5_.id
  LEFT JOIN product p6_ ON o4_.product_id = p6_.id
  LEFT JOIN product_category p7_ ON p6_.category_id = p7_.id
  LEFT JOIN supplier_has_product s8_ ON p6_.id = s8_.product_id
WHERE
  o1_.hotel_id = ?
  AND d0_.created_at >= ?
GROUP BY
  d0_.id

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM delivery d0_ LEFT JOIN `order` o1_ ON d0_.hotel_order_id = o1_.id LEFT JOIN `user` u2_ ON o1_.user_id = u2_.id LEFT JOIN hotel h3_ ON o1_.hotel_id = h3_.id LEFT JOIN order_has_product o4_ ON o1_.id = o4_.hotel_order_id LEFT JOIN supplier s5_ ON d0_.supplier_id = s5_.id LEFT JOIN product p6_ ON o4_.product_id = p6_.id LEFT JOIN product_category p7_ ON p6_.category_id = p7_.id LEFT JOIN supplier_has_product s8_ ON p6_.id = s8_.product_id WHERE o1_.hotel_id = 28 AND d0_.created_at >= '2026-06-09 00:00:00' GROUP BY d0_.id;

SELECT
  DISTINCT d0_.id AS id_0,
  o1_.id AS id_1
FROM
  delivery d0_
  LEFT JOIN `order` o1_ ON d0_.hotel_order_id = o1_.id
  LEFT JOIN `user` u2_ ON o1_.user_id = u2_.id
  LEFT JOIN hotel h3_ ON o1_.hotel_id = h3_.id
  LEFT JOIN order_has_product o4_ ON o1_.id = o4_.hotel_order_id
  LEFT JOIN supplier s5_ ON d0_.supplier_id = s5_.id
  LEFT JOIN product p6_ ON o4_.product_id = p6_.id
  LEFT JOIN product_category p7_ ON p6_.category_id = p7_.id
  LEFT JOIN supplier_has_product s8_ ON p6_.id = s8_.product_id
WHERE
  o1_.hotel_id = ?
  AND d0_.created_at >= ?
GROUP BY
  d0_.id
ORDER BY
  o1_.id DESC
LIMIT
  200

SELECT DISTINCT d0_.id AS id_0, o1_.id AS id_1 FROM delivery d0_ LEFT JOIN `order` o1_ ON d0_.hotel_order_id = o1_.id LEFT JOIN `user` u2_ ON o1_.user_id = u2_.id LEFT JOIN hotel h3_ ON o1_.hotel_id = h3_.id LEFT JOIN order_has_product o4_ ON o1_.id = o4_.hotel_order_id LEFT JOIN supplier s5_ ON d0_.supplier_id = s5_.id LEFT JOIN product p6_ ON o4_.product_id = p6_.id LEFT JOIN product_category p7_ ON p6_.category_id = p7_.id LEFT JOIN supplier_has_product s8_ ON p6_.id = s8_.product_id WHERE o1_.hotel_id = 28 AND d0_.created_at >= '2026-06-09 00:00:00' GROUP BY d0_.id ORDER BY o1_.id DESC LIMIT 200;

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 = 21232;

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
  LEFT JOIN `user` u2_ ON o1_.user_id = u2_.id
  LEFT JOIN hotel h3_ ON o1_.hotel_id = h3_.id
  LEFT JOIN order_has_product o4_ ON o1_.id = o4_.hotel_order_id
  LEFT JOIN supplier s5_ ON d0_.supplier_id = s5_.id
  LEFT JOIN product p6_ ON o4_.product_id = p6_.id
  LEFT JOIN product_category p7_ ON p6_.category_id = p7_.id
  LEFT JOIN supplier_has_product s8_ ON p6_.id = s8_.product_id
WHERE
  o1_.hotel_id = ?
  AND d0_.created_at >= ?
  AND d0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
GROUP BY
  d0_.id
ORDER BY
  o1_.id DESC

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 LEFT JOIN `user` u2_ ON o1_.user_id = u2_.id LEFT JOIN hotel h3_ ON o1_.hotel_id = h3_.id LEFT JOIN order_has_product o4_ ON o1_.id = o4_.hotel_order_id LEFT JOIN supplier s5_ ON d0_.supplier_id = s5_.id LEFT JOIN product p6_ ON o4_.product_id = p6_.id LEFT JOIN product_category p7_ ON p6_.category_id = p7_.id LEFT JOIN supplier_has_product s8_ ON p6_.id = s8_.product_id WHERE o1_.hotel_id = 28 AND d0_.created_at >= '2026-06-09 00:00:00' AND d0_.id IN (20367, 20366, 20365, 20424, 20425, 20343, 20262, 20225, 20222, 20221, 20187, 20183, 20184, 20185, 20174, 20155, 20154, 20102, 20101, 20140, 20029, 20028, 19932, 19925, 19926, 19757, 19713, 19714, 19715, 19716, 19672, 19606, 19591, 19497, 19485, 19484, 19481, 19466, 19467, 19385, 19371, 19270, 19269, 19266, 19255, 19256, 19257, 19128, 19129, 19127, 19126, 19122, 19045, 19046, 18983, 18920, 18919, 18918, 18909, 18901, 18790, 18791, 18792, 18727, 18651, 18652, 18609, 18610, 18611, 18586, 18505, 18501, 18446, 18364, 18351, 18352, 18279, 18203, 18200, 18199, 18154, 18229, 18153, 18142, 18128, 18127, 18125, 18091, 18092, 18006, 18007, 17822, 18124, 17702, 17699, 17698, 17682, 17683, 17681, 17617, 17618, 17558, 17557, 17500, 17489, 17490, 17432, 17433, 17436, 17450, 17353, 17354, 17313, 17190, 17136, 17097, 17096, 17003, 17002, 16969, 17001, 16900, 16901, 16909, 16862, 16856, 16829, 16757, 16758, 16759, 16630, 16621, 16622, 16623, 16594, 16592, 16589, 16584, 16568, 16582, 16412, 16413, 16414, 16415, 16345, 16346, 16316, 16271, 16206, 16111, 16112, 16052, 16161, 16044, 16043, 16035, 15912, 15913, 15867, 15868, 15871, 15805, 15804, 15728, 15729, 15710, 16162, 15585, 15586, 15512, 15451, 15452, 15353, 15354, 15355, 15380, 15252, 15253, 15251, 15277, 15199, 15139, 15036, 15035, 15012, 14902) GROUP BY d0_.id ORDER BY o1_.id DESC;

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,
  t0.hour_limit AS hour_limit_27
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, t0.hour_limit AS hour_limit_27 FROM supplier t0 WHERE t0.id = 4;

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 = 145;

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 = 145;

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 = 28;

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 = 28;

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 = 28 ORDER BY h0_.name ASC;

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 = 136;

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 = 136;

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;