Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.submitted_at AS submitted_at_2,
  i0_.finished_at AS finished_at_3,
  i0_.external_crm_user_id AS external_crm_user_id_4,
  i0_.source_order_id AS source_order_id_5,
  i0_.custom_number AS custom_number_6,
  i0_.ship_to AS ship_to_7,
  i0_.requested_location AS requested_location_8,
  i0_.status AS status_9,
  i0_.requested_lines_count AS requested_lines_count_10,
  i0_.submitted_lines_count AS submitted_lines_count_11,
  i0_.rejected_lines_count AS rejected_lines_count_12,
  i0_.requested_items_qty AS requested_items_qty_13,
  i0_.submitted_items_qty AS submitted_items_qty_14,
  i0_.rejected_items_qty AS rejected_items_qty_15,
  i0_.deferred_payment AS deferred_payment_16,
  i0_.comments AS comments_17,
  i0_.ic_id AS ic_id_18,
  i0_.ic_requisition_id AS ic_requisition_id_19,
  i0_.ic_status_code AS ic_status_code_20,
  i0_.ic_phase_code AS ic_phase_code_21,
  i0_.ic_ship_from AS ic_ship_from_22,
  i0_.error_code AS error_code_23,
  i0_.error_message AS error_message_24,
  i0_.request_payload AS request_payload_25,
  i0_.response_payload AS response_payload_26,
  i0_.crm_user_id AS crm_user_id_27
FROM
  inter_cars_order_requests i0_
WHERE
  i0_.status IN (?, ?)
  AND i0_.custom_number = ?
ORDER BY
  i0_.id DESC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.submitted_at AS submitted_at_2, i0_.finished_at AS finished_at_3, i0_.external_crm_user_id AS external_crm_user_id_4, i0_.source_order_id AS source_order_id_5, i0_.custom_number AS custom_number_6, i0_.ship_to AS ship_to_7, i0_.requested_location AS requested_location_8, i0_.status AS status_9, i0_.requested_lines_count AS requested_lines_count_10, i0_.submitted_lines_count AS submitted_lines_count_11, i0_.rejected_lines_count AS rejected_lines_count_12, i0_.requested_items_qty AS requested_items_qty_13, i0_.submitted_items_qty AS submitted_items_qty_14, i0_.rejected_items_qty AS rejected_items_qty_15, i0_.deferred_payment AS deferred_payment_16, i0_.comments AS comments_17, i0_.ic_id AS ic_id_18, i0_.ic_requisition_id AS ic_requisition_id_19, i0_.ic_status_code AS ic_status_code_20, i0_.ic_phase_code AS ic_phase_code_21, i0_.ic_ship_from AS ic_ship_from_22, i0_.error_code AS error_code_23, i0_.error_message AS error_message_24, i0_.request_payload AS request_payload_25, i0_.response_payload AS response_payload_26, i0_.crm_user_id AS crm_user_id_27 FROM inter_cars_order_requests i0_ WHERE i0_.status IN ('submitted', 'partial') AND i0_.custom_number = '61224-380914' ORDER BY i0_.id DESC LIMIT 1;

INSERT INTO inter_cars_order_requests (
  created_at, submitted_at, finished_at,
  external_crm_user_id, source_order_id,
  custom_number, ship_to, requested_location,
  status, requested_lines_count, submitted_lines_count,
  rejected_lines_count, requested_items_qty,
  submitted_items_qty, rejected_items_qty,
  deferred_payment, comments, ic_id,
  ic_requisition_id, ic_status_code,
  ic_phase_code, ic_ship_from, error_code,
  error_message, request_payload,
  response_payload, crm_user_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO inter_cars_order_requests (created_at, submitted_at, finished_at, external_crm_user_id, source_order_id, custom_number, ship_to, requested_location, status, requested_lines_count, submitted_lines_count, rejected_lines_count, requested_items_qty, submitted_items_qty, rejected_items_qty, deferred_payment, comments, ic_id, ic_requisition_id, ic_status_code, ic_phase_code, ic_ship_from, error_code, error_message, request_payload, response_payload, crm_user_id) VALUES ('2026-04-27 12:20:43', NULL, NULL, NULL, '61224', '61224-380914', NULL, NULL, 'received', 1, 0, 0, 1, 0, 0, NULL, 'zamowienie z karty zlecenia, czesc ID 380914', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '{\"sourceOrderId\":\"61224\",\"customNumber\":\"61224-380914\",\"comments\":\"zamowienie z karty zlecenia, czesc ID 380914\",\"lines\":[{\"sku\":\"BFED9C\",\"quantity\":1,\"custom\":\"380914\"}]}', NULL, NULL);

UPDATE
  inter_cars_order_request_lines
SET
  quoted_total_stock = ?,
  unit_price_net = ?,
  unit_price_gross = ?,
  status = ?,
  accepted_quantity = ?,
  missing_quantity = ?,
  quote_payload = ?,
  response_payload = ?
WHERE
  id = ?

UPDATE inter_cars_order_request_lines SET quoted_total_stock = 24, unit_price_net = '12.20', unit_price_gross = '15.01', status = 'submitted', accepted_quantity = 1, missing_quantity = 0, quote_payload = '{\"net_price\":24.12,\"gross_price\":29.67,\"customerPriceNet\":12.2,\"customerPriceGross\":15.01,\"total_stock\":24,\"by_location\":{\"KTW\":4,\"HSN\":10,\"HZA\":10},\"index\":\"FE32211\",\"sku\":\"BFED9C\"}', response_payload = '{\"name\":\"Filtr powietrza\",\"sku\":\"BFED9C\",\"index\":\"FE32211\",\"description\":\"Filtr powietrza (Wk\\u0142ad filtra) pasuje do: ALFA ROMEO MITO, FIAT 500L, BRAVO II, DOBLO, DOBLO CARGO, GRANDE PUNTO, IDEA, LINEA, PUNTO, PUNTO EVO, STILO, TIPO, LANCIA MUSA, YPSILON 1.2-2.0D 11.01-\",\"eans\":[\"4027816322115\"],\"requiredQuantity\":1,\"missingQuantity\":0,\"acceptedQuantity\":1,\"collectedQuantity\":0,\"packagedQuantity\":0,\"unitPriceNet\":12.2,\"unitPriceGross\":15.01,\"totalNet\":12.2,\"totalGross\":15.01,\"deliveryId\":[null]}' WHERE id = 279;

UPDATE
  inter_cars_order_requests
SET
  submitted_at = ?,
  finished_at = ?,
  status = ?,
  submitted_lines_count = ?,
  submitted_items_qty = ?,
  ic_id = ?,
  ic_requisition_id = ?,
  ic_status_code = ?,
  ic_phase_code = ?,
  ic_ship_from = ?,
  response_payload = ?
WHERE
  id = ?

UPDATE inter_cars_order_requests SET submitted_at = '2026-04-27 12:20:45', finished_at = '2026-04-27 12:20:45', status = 'submitted', submitted_lines_count = 1, submitted_items_qty = 1, ic_id = '113387/KTW/2026', ic_requisition_id = 'IC2228285940', ic_status_code = 'D', ic_phase_code = 'CONFIRMED', ic_ship_from = 'KTW', response_payload = '[{\"id\":\"113387\\/KTW\\/2026\",\"requisitionId\":\"IC2228285940\",\"customNumber\":\"61224-380914\",\"currencyCode\":\"PLN\",\"billTo\":\"99TZTH\",\"shipTo\":\"99TZTH\",\"shipFrom\":\"KTW\",\"deliveryMethod\":\"I\",\"paymentMethod\":\"02\",\"creationDate\":\"2026-04-27T12:20:44+02:00\",\"acceptedDate\":\"2026-04-27T12:20:44+02:00\",\"statusCode\":\"D\",\"phaseCode\":\"CONFIRMED\",\"deferredPayment\":true,\"totalNet\":12.2,\"totalGross\":15.01,\"comments\":\"zamowienie z karty zlecenia, czesc ID 380914\",\"lines\":[{\"name\":\"Filtr powietrza\",\"sku\":\"BFED9C\",\"index\":\"FE32211\",\"description\":\"Filtr powietrza (Wk\\u0142ad filtra) pasuje do: ALFA ROMEO MITO, FIAT 500L, BRAVO II, DOBLO, DOBLO CARGO, GRANDE PUNTO, IDEA, LINEA, PUNTO, PUNTO EVO, STILO, TIPO, LANCIA MUSA, YPSILON 1.2-2.0D 11.01-\",\"eans\":[\"4027816322115\"],\"requiredQuantity\":1,\"missingQuantity\":0,\"acceptedQuantity\":1,\"collectedQuantity\":0,\"packagedQuantity\":0,\"unitPriceNet\":12.2,\"unitPriceGross\":15.01,\"totalNet\":12.2,\"totalGross\":15.01,\"deliveryId\":[null]}]}]' WHERE id = 279;

INSERT INTO inter_cars_order_request_lines (
  line_no, sku, line_custom, requested_quantity,
  quoted_total_stock, quoted_location_stock,
  unit_price_net, unit_price_gross,
  status, reject_reason, reject_details,
  accepted_quantity, missing_quantity,
  ic_line_order_id, quote_payload,
  response_payload, request_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO inter_cars_order_request_lines (line_no, sku, line_custom, requested_quantity, quoted_total_stock, quoted_location_stock, unit_price_net, unit_price_gross, status, reject_reason, reject_details, accepted_quantity, missing_quantity, ic_line_order_id, quote_payload, response_payload, request_id) VALUES (1, 'BFED9C', '380914', 1, NULL, NULL, NULL, NULL, 'requested', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 279);

"START TRANSACTION"

"START TRANSACTION";