Symfony Profiler

"COMMIT"

"COMMIT";

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_
WHERE
  o0_.created_at LIKE ?
ORDER BY
  o0_.order_number DESC
LIMIT
  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_ WHERE o0_.created_at LIKE '2026-09-%' ORDER BY o0_.order_number DESC LIMIT 1;

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
  o1_.hotel_id = ?
  AND d0_.supplier_id = ?
  AND (
    d0_.api_status IS NULL
    OR d0_.api_status <> 2
  )
  AND (
    d0_.created_at >= ?
    AND d0_.created_at < ?
  )

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 o1_.hotel_id = 28 AND d0_.supplier_id = 44 AND (d0_.api_status IS NULL OR d0_.api_status <> 2) AND (d0_.created_at >= '2026-09-12 00:00:00' AND d0_.created_at < '2026-09-13 00:00:00');

INSERT INTO system_log (
  title, is_done, created_at, supplier_id,
  delivery_id, hotel_order_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO system_log (title, is_done, created_at, supplier_id, delivery_id, hotel_order_id) VALUES ('Zamówienie 648/09/26/HEK dla Zabłocki zostało wysłane (ID:20625). Kod: 12-09-2026/6aa547209895c', 1, '2026-09-12 14:35:45', 44, 20625, 21494);

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

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.supplier_code AS supplier_code_3,
  t0.image AS image_4,
  t0.last_price AS last_price_5,
  t0.price_changed_at AS price_changed_at_6,
  t0.price_last_at AS price_last_at_7,
  t0.is_active AS is_active_8,
  t0.extra_data AS extra_data_9,
  t0.last_is_active AS last_is_active_10,
  t0.supplier_id AS supplier_id_11,
  t0.product_id AS product_id_12
FROM
  supplier_has_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.supplier_code AS supplier_code_3, t0.image AS image_4, t0.last_price AS last_price_5, t0.price_changed_at AS price_changed_at_6, t0.price_last_at AS price_last_at_7, t0.is_active AS is_active_8, t0.extra_data AS extra_data_9, t0.last_is_active AS last_is_active_10, t0.supplier_id AS supplier_id_11, t0.product_id AS product_id_12 FROM supplier_has_product t0 WHERE t0.product_id = 33837;

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

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;

INSERT INTO delivery (
  invoice_no, price, creation_date,
  receipt_date, FILE, created_at, number,
  date_confirmed, hash, is_api, supplier_comment,
  supplier_number, COMMENT, extra_data,
  api_status, api_status_description,
  is_accepted, accepted_at, hotel_order_id,
  supplier_id, accepted_by_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

INSERT INTO delivery (invoice_no, price, creation_date, receipt_date, FILE, created_at, number, date_confirmed, hash, is_api, supplier_comment, supplier_number, COMMENT, extra_data, api_status, api_status_description, is_accepted, accepted_at, hotel_order_id, supplier_id, accepted_by_id) VALUES (NULL, NULL, NULL, NULL, NULL, '2026-09-12 14:35:44', 1, NULL, '83592a3c896c7ac53ae1b5282c5be8e6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 21494, 44, NULL);

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

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

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

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

UPDATE
  `order`
SET
  STATUS = ?,
  updated_at = ?,
  order_number = ?,
  accepted_by_id = ?
WHERE
  id = ?

UPDATE `order` SET STATUS = 'accepted', updated_at = '2026-09-12 14:35:44', order_number = 648, accepted_by_id = 145 WHERE id = 21494;

UPDATE
  order_has_product
SET
  price = ?
WHERE
  id = ?

UPDATE order_has_product SET price = '29.3' WHERE id = 573124;

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 = '21494';

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_
WHERE
  d0_.hotel_order_id = ?
ORDER BY
  d0_.number DESC
LIMIT
  1

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_ WHERE d0_.hotel_order_id = 21494 ORDER BY d0_.number DESC LIMIT 1;

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,
  s0_.hour_limit AS hour_limit_26
FROM
  supplier s0_
WHERE
  s0_.id IN (?)

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, s0_.hour_limit AS hour_limit_26 FROM supplier s0_ WHERE s0_.id IN ('44');

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

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

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

UPDATE
  delivery
SET
  is_api = ?
WHERE
  id = ?

UPDATE delivery SET is_api = 1 WHERE id = 20625;