Symfony Profiler

"COMMIT"

"COMMIT";

INSERT INTO sapo_webhook (
  topic, tenant_domain, payload, headers,
  hmac, created_at, status, retry_count,
  processed_at, last_error
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO sapo_webhook (topic, tenant_domain, payload, headers, hmac, created_at, status, retry_count, processed_at, last_error) VALUES ('orders/update', 'the350f-ch.mysapogo.com', '{\"id\":135250368,\"tenant_id\":816347,\"location_id\":776510,\"code\":\"ONL685825\",\"created_on\":\"2025-12-05T12:01:48Z\",\"modified_on\":\"2025-12-06T12:07:50Z\",\"issued_on\":\"2025-12-05T12:01:48Z\",\"ship_on\":null,\"ship_on_min\":\"2025-12-05T09:00:00Z\",\"ship_on_max\":\"2025-12-05T10:00:00Z\",\"account_id\":1229924,\"assignee_id\":1229924,\"customer_id\":670954067,\"customer_data\":{\"id\":670954067,\"tenant_id\":816347,\"default_location_id\":null,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"code\":\"CO00135903\",\"name\":\"Nghĩa Mập 0976877469\",\"dob\":null,\"sex\":\"other\",\"description\":\"\",\"email\":\"\",\"fax\":\"\",\"phone_number\":\"0976877469\",\"tax_number\":\"\",\"website\":\"\",\"customer_group_id\":3122518,\"group_name\":\"Bán lẻ\",\"assignee_id\":null,\"default_payment_term_id\":null,\"default_payment_method_id\":null,\"default_tax_type_id\":null,\"default_discount_rate\":null,\"default_price_list_id\":null,\"tags\":[],\"addresses\":[{\"id\":623630680,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 1\",\"ward\":\"Phường Đa Kao\",\"address1\":\"138 Hai Bà Trưng\",\"address2\":null,\"zip_code\":null,\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"138 Hai Bà Trưng\",\"phone_number\":\"0976877469\",\"status\":\"active\"},{\"id\":623630681,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 1\",\"ward\":\"Phường Đa Kao\",\"address1\":\"138 Hai Bà Trưng\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"138 Hai Bà Trưng\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623630682,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 1\",\"ward\":\"Phường Đa Kao\",\"address1\":\"138 Hai Bà Trưng\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"138 Hai Bà Trưng\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623630683,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường Thủ Thiêm\",\"address1\":\"Toà nhà The Mett, 15 Trần Bạch Đằng\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"Toà nhà The Mett, 15 Trần Bạch Đằng\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623630684,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường Thủ Thiêm\",\"address1\":\"15 Trần Bạch Đằng (Shinhanbank)\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"15 Trần Bạch Đằng (Shinhanbank)\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623630685,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường Thủ Thiêm\",\"address1\":\"Tòa nhà The Mett, số 15 Trần Bạch Đằng\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"Tòa nhà The Mett, số 15 Trần Bạch Đằng\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623630686,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 2\",\"ward\":\"Phường Thủ Thiêm\",\"address1\":\"Toà nhà The Mett, 15 trần bạch đằng\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"Toà nhà The Mett, 15 trần bạch đằng\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623630687,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 7\",\"ward\":\"Phường Tân Phú\",\"address1\":\"77 Hoàng Văn Thái (tòa nhà Đại Minh)\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"77 Hoàng Văn Thái (tòa nhà Đại Minh)\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623630688,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 4\",\"ward\":\"Phường 4\",\"address1\":\"6 Tân Vĩnh\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"6 Tân Vĩnh\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623630689,\"created_on\":\"2025-03-31T12:58:56Z\",\"modified_on\":\"2025-03-31T12:58:56Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường Thủ Thiêm\",\"address1\":\"Tòa nhà The Mett - 15 Trần Bạch Đằng\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"Tòa nhà The Mett - 15 Trần Bạch Đằng\",\"phone_number\":null,\"status\":\"active\"},{\"id\":804437338,\"created_on\":\"2025-12-05T12:00:38Z\",\"modified_on\":\"2025-12-05T12:00:38Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 4\",\"ward\":\"Phường 9\",\"address1\":\"7 đường 10A\",\"address2\":null,\"zip_code\":\"\",\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":\"\",\"label\":null,\"phone_number\":\"0976877469\",\"status\":\"active\"}],\"contacts\":[],\"notes\":[],\"customer_group\":{\"id\":3122518,\"tenant_id\":816347,\"created_on\":\"2025-03-24T04:16:21Z\",\"modified_on\":\"2025-03-24T04:16:21Z\",\"name\":\"RETAIL\",\"name_translate\":\"Bán lẻ\",\"status\":\"active\",\"is_default\":true,\"default_payment_term_id\":null,\"default_payment_method_id\":null,\"default_tax_type_id\":null,\"default_discount_rate\":null,\"default_price_list_id\":null,\"note\":null,\"code\":\"BANLE\"},\"status\":\"active\",\"is_default\":false,\"debt\":-486000.0000,\"apply_incentives\":\"group\",\"total_expense\":13699000.0000,\"loyalty_customer\":null,\"sale_order\":{\"total_sales\":13699000.00,\"order_purchases\":0.00,\"returned_item_quantity\":0.00,\"net_quantity\":0.00,\"last_order_on\":null},\"social_customers\":[]},\"contact_id\":null,\"billing_address\":{\"id\":269914970,\"label\":\"Tòa nhà The Mett - 15 Trần Bạch Đằng\",\"first_name\":\"\",\"full_name\":\"\",\"last_name\":\"\",\"address1\":\"Tòa nhà The Mett - 15 Trần Bạch Đằng\",\"address2\":\"Tòa nhà The Mett - 15 Trần Bạch Đằng\",\"email\":\"\",\"phone_number\":null,\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường Thủ Thiêm\",\"zip_code\":null},\"shipping_address\":{\"id\":269914971,\"label\":null,\"first_name\":null,\"full_name\":\"\",\"last_name\":null,\"address1\":\"7 đường 10A\",\"address2\":null,\"email\":\"\",\"phone_number\":\"0976877469\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 4\",\"ward\":\"Phường 9\",\"zip_code\":\"\"},\"email\":\"\",\"phone_number\":\"0976877469\",\"reference_number\":\"\",\"currency_id\":0,\"price_list_id\":2349366,\"tax_treatment\":\"inclusive\",\"status\":\"finalized\",\"fulfillment_status\":\"shipped\",\"packed_status\":\"packed\",\"payment_status\":\"paid\",\"return_status\":\"unreturned\",\"received_status\":\"unreceived\",\"source_url\":null,\"source_id\":8724180,\"tax_label\":null,\"total\":486000,\"order_discount_rate\":0.00,\"order_discount_value\":0.0000,\"discount_reason\":null,\"total_discount\":50000,\"total_tax\":36000,\"note\":\"[P20] -đã ck - VAT\\n\\ntag gs thường: Chúc mừng sinh nhật anh Totoro!\\n\\nGS6 mix vị (matcha, nhãn, dâu, dưa lưới, tira, xoài)\",\"tags\":[],\"delivery_fee\":null,\"order_discount_amount\":0,\"discount_items\":[],\"order_line_items\":[{\"id\":296024763,\"created_on\":\"2025-12-05T12:01:48Z\",\"modified_on\":\"2025-12-05T12:01:53Z\",\"variant_id\":393671274,\"product_id\":204359859,\"product_name\":\"Gift Set\",\"variant_name\":\"Gift Set 6 MIX VỊ\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":36000.0000000000,\"discount_rate\":10.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":50000.0000000000,\"note\":\"\",\"price\":500000,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":486000.0000000000,\"discount_items\":[{\"position\":0,\"source\":\"manual\",\"rate\":10.000,\"value\":0.0000,\"amount\":50000,\"reason\":null,\"promotion_redemption_id\":null,\"promotion_condition_item_id\":null}],\"sku\":\"SP549M\",\"barcode\":\"SP549M\",\"unit\":\"Hộp\",\"variant_options\":\"Gift Set 6 MIX VỊ\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":296024764,\"created_on\":\"2025-12-05T12:01:48Z\",\"modified_on\":\"2025-12-05T12:01:53Z\",\"variant_id\":333744243,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"Matchamisu Mini\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":0E-10,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":0,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":0E-10,\"discount_items\":[],\"sku\":\"SP266\",\"barcode\":\"SP266\",\"unit\":\"cái\",\"variant_options\":\"Matchamisu Mini\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":296024765,\"created_on\":\"2025-12-05T12:01:48Z\",\"modified_on\":\"2025-12-05T12:01:53Z\",\"variant_id\":333744231,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"Hộp Tròn Mini - Nhãn\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":0E-10,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":0,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":0E-10,\"discount_items\":[],\"sku\":\"SP526\",\"barcode\":\"SP526\",\"unit\":\"cái\",\"variant_options\":\"Nhãn\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":296024766,\"created_on\":\"2025-12-05T12:01:48Z\",\"modified_on\":\"2025-12-05T12:01:53Z\",\"variant_id\":333744226,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"Hộp Tròn Mini - Dâu\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":0E-10,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":0,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":0E-10,\"discount_items\":[],\"sku\":\"SP523\",\"barcode\":\"SP523\",\"unit\":\"cái\",\"variant_options\":\"Dâu\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":296024767,\"created_on\":\"2025-12-05T12:01:48Z\",\"modified_on\":\"2025-12-05T12:01:53Z\",\"variant_id\":333744240,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"2024 Dưa Lưới Mini\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":0E-10,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":0,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":0E-10,\"discount_items\":[],\"sku\":\"SP172\",\"barcode\":\"SP172\",\"unit\":\"cái\",\"variant_options\":\"2024 Dưa Lưới Mini\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":296024768,\"created_on\":\"2025-12-05T12:01:48Z\",\"modified_on\":\"2025-12-05T12:01:53Z\",\"variant_id\":333744228,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"Hộp Tròn Mini - Tiramisu\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":0E-10,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":0,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":0E-10,\"discount_items\":[],\"sku\":\"SP524\",\"barcode\":\"SP524\",\"unit\":\"cái\",\"variant_options\":\"Tiramisu\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":296024769,\"created_on\":\"2025-12-05T12:01:48Z\",\"modified_on\":\"2025-12-05T12:01:53Z\",\"variant_id\":333744227,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"Hộp Tròn Mini - Xoài\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":0E-10,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":0,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":0E-10,\"discount_items\":[],\"sku\":\"SP525\",\"barcode\":\"SP525\",\"unit\":\"cái\",\"variant_options\":\"Xoài\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]}],\"fulfillments\":[{\"id\":123191179,\"tenant_id\":816347,\"stock_location_id\":776510,\"code\":\"FUN353161\",\"order_id\":135250368,\"account_id\":1230677,\"assignee_id\":1230677,\"partner_id\":670954067,\"billing_address\":{\"id\":270594786,\"label\":\"Tòa nhà The Mett - 15 Trần Bạch Đằng\",\"first_name\":\"\",\"full_name\":\"\",\"last_name\":\"\",\"address1\":\"Tòa nhà The Mett - 15 Trần Bạch Đằng\",\"address2\":\"Tòa nhà The Mett - 15 Trần Bạch Đằng\",\"email\":\"\",\"phone_number\":null,\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường Thủ Thiêm\",\"zip_code\":null},\"delivery_type\":\"courier\",\"tax_treatment\":\"inclusive\",\"discount_rate\":0.000,\"discount_value\":0.0000,\"discount_amount\":0.0000,\"total\":486000.0000,\"total_tax\":36000.0000,\"total_discount\":50000.0000,\"notes\":\"[P20] -đã ck - VAT\\n\\ntag gs thường: Chúc mừng sinh nhật anh Totoro!\\n\\nGS6 mix vị (matcha, nhãn, dâu, dưa lưới, tira, xoài)\",\"packed_on\":\"2025-12-06T12:07:18Z\",\"received_on\":null,\"shipped_on\":\"2025-12-06T12:07:50Z\",\"cancel_date\":null,\"cancel_account_id\":null,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:50Z\",\"status\":\"fulfilled\",\"composite_fulfillment_status\":\"fulfilled\",\"payment_status\":\"unpaid\",\"stock_out_account_id\":1230677,\"receive_account_id\":null,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":null,\"fulfillment_line_items\":[{\"id\":275723521,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:18Z\",\"order_line_item_id\":296024763,\"product_id\":204359859,\"product_name\":\"Gift Set\",\"variant_id\":393671274,\"variant_name\":\"Gift Set 6 MIX VỊ\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":500000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":486000.0000,\"line_tax_amount\":36000.0000,\"line_discount_amount\":50000.0000,\"discount_value\":0.0000,\"discount_rate\":10.000,\"sku\":\"SP549M\",\"barcode\":\"SP549M\",\"unit\":\"Hộp\",\"variant_options\":\"Gift Set 6 MIX VỊ\",\"serials\":null},{\"id\":275723522,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:18Z\",\"order_line_item_id\":296024764,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":333744243,\"variant_name\":\"Matchamisu Mini\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":0.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":0.0000,\"line_tax_amount\":0.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP266\",\"barcode\":\"SP266\",\"unit\":\"cái\",\"variant_options\":\"Matchamisu Mini\",\"serials\":null},{\"id\":275723523,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:18Z\",\"order_line_item_id\":296024765,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":333744231,\"variant_name\":\"Hộp Tròn Mini - Nhãn\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":0.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":0.0000,\"line_tax_amount\":0.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP526\",\"barcode\":\"SP526\",\"unit\":\"cái\",\"variant_options\":\"Nhãn\",\"serials\":null},{\"id\":275723524,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:18Z\",\"order_line_item_id\":296024766,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":333744226,\"variant_name\":\"Hộp Tròn Mini - Dâu\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":0.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":0.0000,\"line_tax_amount\":0.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP523\",\"barcode\":\"SP523\",\"unit\":\"cái\",\"variant_options\":\"Dâu\",\"serials\":null},{\"id\":275723525,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:18Z\",\"order_line_item_id\":296024767,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":333744240,\"variant_name\":\"2024 Dưa Lưới Mini\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":0.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":0.0000,\"line_tax_amount\":0.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP172\",\"barcode\":\"SP172\",\"unit\":\"cái\",\"variant_options\":\"2024 Dưa Lưới Mini\",\"serials\":null},{\"id\":275723526,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:18Z\",\"order_line_item_id\":296024768,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":333744228,\"variant_name\":\"Hộp Tròn Mini - Tiramisu\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":0.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":0.0000,\"line_tax_amount\":0.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP524\",\"barcode\":\"SP524\",\"unit\":\"cái\",\"variant_options\":\"Tiramisu\",\"serials\":null},{\"id\":275723527,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:18Z\",\"order_line_item_id\":296024769,\"product_id\":204359835,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":333744227,\"variant_name\":\"Hộp Tròn Mini - Xoài\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":0.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":0.0000,\"line_tax_amount\":0.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP525\",\"barcode\":\"SP525\",\"unit\":\"cái\",\"variant_options\":\"Xoài\",\"serials\":null}],\"shipment\":{\"id\":55583141,\"delivery_service_provider_id\":512894,\"service_name\":null,\"cod_amount\":0.0000,\"freight_amount\":0.0000,\"freight_amount_detail\":null,\"delivery_fee\":0.0000,\"tracking_code\":\"FUN353161\",\"tracking_url\":null,\"created_on\":\"2025-12-06T12:07:18Z\",\"modified_on\":\"2025-12-06T12:07:18Z\",\"sender_address\":null,\"shipping_address\":{\"id\":270594787,\"label\":null,\"first_name\":\"Nghĩa Mập 0976877469\",\"full_name\":\"Nghĩa Mập 0976877469\",\"last_name\":null,\"address1\":\"7 đường 10A\",\"address2\":null,\"email\":null,\"phone_number\":\"0976877469\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 4\",\"ward\":\"Phường 9\",\"zip_code\":null},\"shipper_deposits\":[],\"detail\":\"{\\\"delivery_service_provider_id\\\":512894,\\\"receiver_name\\\":\\\"Nghĩa Mập 0976877469\\\",\\\"receiver_phone\\\":\\\"0976877469\\\",\\\"cod_amount\\\":0,\\\"destination_address\\\":\\\"7 đường 10A\\\",\\\"destination_province_id\\\":2,\\\"destination_district_id\\\":33,\\\"delivery_fee\\\":0,\\\"destination_country_id\\\":201,\\\"source_location_id\\\":776510,\\\"note\\\":\\\"Cho xem hàng, không cho thử |[P20] -đã ck - VAT\\\\n\\\\ntag gs thường: Chúc mừng sinh nhật anh Totoro!\\\\n\\\\nGS6 mix vị (matcha, nhãn, dâu, dưa lưới, tira, xoài)\\\",\\\"destination_country\\\":\\\"Việt Nam\\\",\\\"destination_district\\\":\\\"Quận 4\\\",\\\"destination_province\\\":\\\"TP Hồ Chí Minh\\\",\\\"weight\\\":100,\\\"destination_ward\\\":\\\"Phường 9\\\"}\",\"note\":\"Cho xem hàng, không cho thử |[P20] -đã ck - VAT\\n\\ntag gs thường: Chúc mừng sinh nhật anh Totoro!\\n\\nGS6 mix vị (matcha, nhãn, dâu, dưa lưới, tira, xoài)\",\"pushing_status\":null,\"reference_status\":null,\"reference_status_explanation\":null,\"pushing_note\":null,\"collation_status\":\"unresolved\",\"delivery_service_provider\":null,\"weight\":100.000,\"length\":10.000,\"height\":10.000,\"width\":10.000},\"payments\":[],\"total_quantity\":7.000,\"reason_cancel_id\":null}],\"payments\":null,\"prepayments\":[{\"id\":112794054,\"payment_method_id\":3621317,\"paid_on\":\"2025-12-05T12:01:50Z\",\"amount\":486000.0000,\"account_id\":1229924,\"note\":null,\"created_on\":\"2025-12-05T12:01:52Z\",\"modified_on\":\"2025-12-05T12:01:52Z\",\"reference\":null,\"source\":\"customer_prepaid\",\"source_id\":null,\"paid_amount\":486000.000,\"returned_amount\":0.000,\"status\":\"active\",\"integrated\":false,\"status_before_cancelled\":null}],\"order_returns\":[],\"expected_payment_method_id\":null,\"expected_delivery_type\":null,\"expected_delivery_provider_id\":null,\"process_status_id\":null,\"process_status\":null,\"reason_cancel_id\":null,\"finalized_on\":\"2025-12-05T12:01:52Z\",\"finished_on\":null,\"completed_on\":null,\"channel\":null,\"cancelled_on\":null,\"promotion_redemptions\":[],\"from_order_return_id\":null}', '{\"connection\":[\"Keep-Alive\"],\"host\":[\"test.noibo.the350f.com\"],\"content-length\":[\"20979\"],\"accept-encoding\":[\"gzip;q=1.0,deflate;q=0.6,identity;q=0.3\"],\"x-event-version\":[\"1216271879\"],\"x-sapo-test\":[\"false\"],\"user-agent\":[\"JVM\"],\"x-sapo-webhook-address\":[\"https:\\/\\/test.noibo.the350f.com\\/api\\/sapo-webhook\\/receive\"],\"content-type\":[\"application\\/json; charset=utf-8\"],\"x-sapo-tenant-domain\":[\"the350f-ch.mysapogo.com\"],\"x-sapo-hmac-sha256\":[\"s9KPlxr3pC+fQKRHNvPRXDPKKESahcoYBGj+85Z2rWM=\"],\"x-sapo-order-id\":[\"135250368\"],\"x-sapo-object-id\":[\"135250368\"],\"x-sapo-topic\":[\"orders\\/update\"],\"accept\":[\"*\\/*\"],\"x-php-ob-level\":[\"1\"]}', 's9KPlxr3pC+fQKRHNvPRXDPKKESahcoYBGj+85Z2rWM=', '2025-12-06 12:07:52', 'pending', 0, NULL, NULL);

"START TRANSACTION"

"START TRANSACTION";