Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

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:39', NULL, NULL, NULL, '61224', '61224-380913', NULL, NULL, 'received', 1, 0, 0, 1, 0, 0, NULL, 'zamowienie z karty zlecenia, czesc ID 380913', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '{\"sourceOrderId\":\"61224\",\"customNumber\":\"61224-380913\",\"comments\":\"zamowienie z karty zlecenia, czesc ID 380913\",\"lines\":[{\"sku\":\"G13TNO\",\"quantity\":1,\"custom\":\"380913\"}]}', NULL, NULL);

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, 'G13TNO', '380913', 1, NULL, NULL, NULL, NULL, 'requested', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 278);

"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-380913' ORDER BY i0_.id DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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:43', finished_at = '2026-04-27 12:20:43', status = 'submitted', submitted_lines_count = 1, submitted_items_qty = 1, ic_id = '113386/KTW/2026', ic_requisition_id = 'IC2228285939', ic_status_code = 'D', ic_phase_code = 'CONFIRMED', ic_ship_from = 'KTW', response_payload = '[{\"id\":\"113386\\/KTW\\/2026\",\"requisitionId\":\"IC2228285939\",\"customNumber\":\"61224-380913\",\"currencyCode\":\"PLN\",\"billTo\":\"99TZTH\",\"shipTo\":\"99TZTH\",\"shipFrom\":\"KTW\",\"deliveryMethod\":\"I\",\"paymentMethod\":\"02\",\"creationDate\":\"2026-04-27T12:20:40+02:00\",\"acceptedDate\":\"2026-04-27T12:20:43+02:00\",\"statusCode\":\"D\",\"phaseCode\":\"CONFIRMED\",\"deferredPayment\":true,\"totalNet\":14.39,\"totalGross\":17.7,\"comments\":\"zamowienie z karty zlecenia, czesc ID 380913\",\"lines\":[{\"name\":\"Filtr oleju\",\"sku\":\"G13TNO\",\"index\":\"F 026 407 347\",\"description\":\"Filtr oleju pasuje do: ALFA ROMEO MITO, BYD SEAL U, FIAT 500, 500 C, 500L, BRAVA, BRAVO I, BRAVO II, DOBLO, DOBLO CARGO, FIORINO, FULLBACK, GRANDE PUNTO, IDEA, LINEA, MAREA, PALIO 1.1-2.4D 04.96-\",\"eans\":[\"4047026597318\"],\"requiredQuantity\":1,\"missingQuantity\":0,\"acceptedQuantity\":1,\"collectedQuantity\":0,\"packagedQuantity\":0,\"unitPriceNet\":14.39,\"unitPriceGross\":17.7,\"totalNet\":14.39,\"totalGross\":17.7,\"deliveryId\":[null]}]}]' WHERE id = 278;

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 = 27, unit_price_net = '14.39', unit_price_gross = '17.70', status = 'submitted', accepted_quantity = 1, missing_quantity = 0, quote_payload = '{\"net_price\":25.51,\"gross_price\":31.38,\"customerPriceNet\":14.39,\"customerPriceGross\":17.7,\"total_stock\":27,\"by_location\":{\"KTW\":7,\"HSN\":10,\"HZA\":10},\"index\":\"F 026 407 347\",\"sku\":\"G13TNO\"}', response_payload = '{\"name\":\"Filtr oleju\",\"sku\":\"G13TNO\",\"index\":\"F 026 407 347\",\"description\":\"Filtr oleju pasuje do: ALFA ROMEO MITO, BYD SEAL U, FIAT 500, 500 C, 500L, BRAVA, BRAVO I, BRAVO II, DOBLO, DOBLO CARGO, FIORINO, FULLBACK, GRANDE PUNTO, IDEA, LINEA, MAREA, PALIO 1.1-2.4D 04.96-\",\"eans\":[\"4047026597318\"],\"requiredQuantity\":1,\"missingQuantity\":0,\"acceptedQuantity\":1,\"collectedQuantity\":0,\"packagedQuantity\":0,\"unitPriceNet\":14.39,\"unitPriceGross\":17.7,\"totalNet\":14.39,\"totalGross\":17.7,\"deliveryId\":[null]}' WHERE id = 278;

"COMMIT"

"COMMIT";