Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

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\":180946198,\"tenant_id\":816347,\"location_id\":776355,\"code\":\"SON440871\",\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:45:54Z\",\"issued_on\":\"2026-04-16T14:30:19Z\",\"ship_on\":null,\"ship_on_min\":\"2026-04-17T01:00:00Z\",\"ship_on_max\":\"2026-04-17T01:45:00Z\",\"account_id\":1260498,\"assignee_id\":1260498,\"customer_id\":670891617,\"customer_data\":{\"id\":670891617,\"tenant_id\":816347,\"default_location_id\":null,\"created_on\":\"2025-03-31T12:14:08Z\",\"modified_on\":\"2025-10-15T17:50:17Z\",\"code\":\"KH03387\",\"name\":\"Thùy Thùy\",\"dob\":null,\"sex\":\"other\",\"description\":\"\",\"email\":\"\",\"fax\":\"\",\"phone_number\":\"0914999241\",\"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\":623573248,\"created_on\":\"2025-03-31T12:14:08Z\",\"modified_on\":\"2025-03-31T12:14:08Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 10\",\"address1\":\"4A Đặng Văn Ngữ\",\"address2\":null,\"zip_code\":null,\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"4A Đặng Văn Ngữ\",\"phone_number\":\"0914999241\",\"status\":\"active\"},{\"id\":623573249,\"created_on\":\"2025-03-31T12:14:08Z\",\"modified_on\":\"2025-03-31T12:14:08Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Bình\",\"ward\":\"Phường 12\",\"address1\":\"196/17 Cộng Hòa\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"196/17 Cộng Hòa\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623573250,\"created_on\":\"2025-03-31T12:14:08Z\",\"modified_on\":\"2025-03-31T12:14:08Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Bình\",\"ward\":\"Phường 7\",\"address1\":\"1073/29 cách mạng Tháng 8\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"1073/29 cách mạng Tháng 8\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623573251,\"created_on\":\"2025-03-31T12:14:08Z\",\"modified_on\":\"2025-03-31T12:14:08Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Bình\",\"ward\":\"Phường 7\",\"address1\":\"1073/29 cách mạng T8\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"1073/29 cách mạng T8\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623573252,\"created_on\":\"2025-03-31T12:14:08Z\",\"modified_on\":\"2025-03-31T12:14:08Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Bình\",\"ward\":\"Phường 7\",\"address1\":\"1073/29 cách mạng tháng 8\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"1073/29 cách mạng tháng 8\",\"phone_number\":null,\"status\":\"active\"},{\"id\":623573253,\"created_on\":\"2025-03-31T12:14:08Z\",\"modified_on\":\"2025-03-31T12:14:08Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Bình\",\"ward\":\"Phường 7\",\"address1\":\"1073/29 cách mạng tháng 8\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"1073/29 cách mạng tháng 8\",\"phone_number\":null,\"status\":\"active\"},{\"id\":770314070,\"created_on\":\"2025-10-23T13:33:20Z\",\"modified_on\":\"2025-10-23T13:33:20Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Bình\",\"ward\":\"Phường 7\",\"address1\":\"1073/29 Cách mạng tháng 8, Phường 7, Quận Tân Bình, TP Hồ Chí Minh\",\"address2\":null,\"zip_code\":\"\",\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":\"\",\"label\":null,\"phone_number\":\"0914999241\",\"status\":\"active\"},{\"id\":776477732,\"created_on\":\"2025-10-31T12:34:05Z\",\"modified_on\":\"2025-10-31T12:34:05Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Phú\",\"ward\":\"Phường Sơn Kỳ\",\"address1\":\"Cổng 2, chung cư ruby celadon, 36 tân thắng\",\"address2\":null,\"zip_code\":\"\",\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":\"\",\"label\":null,\"phone_number\":\"0914999241\",\"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\":0.0000,\"apply_incentives\":\"group\",\"total_expense\":5047000.0000,\"loyalty_customer\":null,\"sale_order\":{\"total_sales\":7321480.00,\"order_purchases\":4.00,\"returned_item_quantity\":0.00,\"net_quantity\":29.00,\"last_order_on\":\"2026-04-17T01:28:26Z\"},\"social_customers\":[]},\"contact_id\":null,\"billing_address\":{\"id\":361850634,\"label\":null,\"first_name\":\"\",\"full_name\":\"\",\"last_name\":\"\",\"address1\":\"Cổng 2, chung cư ruby celadon, 36 tân thắng\",\"address2\":\"Cổng 2, chung cư ruby celadon, 36 tân thắng\",\"email\":\"\",\"phone_number\":\"0914999241\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Phú\",\"ward\":\"Phường Sơn Kỳ\",\"zip_code\":null},\"shipping_address\":{\"id\":361850635,\"label\":null,\"first_name\":null,\"full_name\":\"\",\"last_name\":null,\"address1\":\"Cổng 2, chung cư ruby celadon, 36 tân thắng\",\"address2\":null,\"email\":\"\",\"phone_number\":\"0914999241\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Phú\",\"ward\":\"Phường Sơn Kỳ\",\"zip_code\":\"\"},\"email\":\"\",\"phone_number\":\"0914999241\",\"reference_number\":\"\",\"currency_id\":0,\"price_list_id\":2349366,\"tax_treatment\":\"inclusive\",\"status\":\"completed\",\"fulfillment_status\":\"shipped\",\"packed_status\":\"packed\",\"payment_status\":\"paid\",\"return_status\":\"unreturned\",\"received_status\":\"received\",\"source_url\":null,\"source_id\":8724178,\"tax_label\":null,\"total\":612360,\"order_discount_rate\":10.00,\"order_discount_value\":0.0000,\"discount_reason\":null,\"total_discount\":63000,\"total_tax\":45360,\"note\":\"Thông tin xuất hóa đơn: \\nTên công ty: CÔNG TY TNHH NHỊP SỐNG MỚI\\nMã số thuế: 0303496605\\nĐịa chỉ: 4A Đặng Văn Ngữ, Phường Phú Nhuận, Thành Phố Hồ Chí Minh, Việt Nam\\nEmail nhận hóa đơn: sales01@modernlife.com.vn\",\"tags\":[\"Tag cắm mini: Happy Birthday BINA (icon trái tim)\"],\"delivery_fee\":null,\"order_discount_amount\":63000.0000,\"discount_items\":[{\"position\":0,\"source\":\"manual\",\"rate\":10.000,\"value\":0.0000,\"amount\":63000.0000,\"reason\":\"\",\"promotion_redemption_id\":null,\"promotion_condition_item_id\":null}],\"order_line_items\":[{\"id\":395283033,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744338,\"product_id\":204359859,\"product_name\":\"Gift Set\",\"variant_name\":\"Giftset 9 NGUYÊN SET\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":45360.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":630000,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":675360.0000000000,\"discount_items\":[],\"sku\":\"SP550\",\"barcode\":\"SP550\",\"unit\":\"Hộp\",\"variant_options\":\"Giftset 9 NGUYÊN SET\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":395283034,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744231,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh 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\":395283035,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744227,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh 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\":[]},{\"id\":395283036,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744226,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh 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\":395283037,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744243,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh Hộp Tròn Mini - 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\":395283038,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744228,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh 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\":395283039,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744241,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh Hộp Tròn Mini - CHOCOMINT\",\"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\":\"SP173\",\"barcode\":\"SP173\",\"unit\":\"cái\",\"variant_options\":\"CHOCOMINT\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":395283040,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744240,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh Hộp Tròn Mini - 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\":395283041,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744235,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh Hộp Tròn Mini - Bưởi Hồng\",\"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\":\"SP588\",\"barcode\":\"SP004\",\"unit\":\"cái\",\"variant_options\":\"Bưởi Hồng\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":395283042,\"created_on\":\"2026-04-16T14:30:19Z\",\"modified_on\":\"2026-04-17T01:27:51Z\",\"variant_id\":333744230,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_name\":\"Bánh Hộp Tròn Mini - Việt Quất\",\"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\":\"SP530\",\"barcode\":\"SP530\",\"unit\":\"cái\",\"variant_options\":\"Việt Quất\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]}],\"fulfillments\":[{\"id\":165823723,\"tenant_id\":816347,\"stock_location_id\":776355,\"code\":\"FUN524320\",\"order_id\":180946198,\"account_id\":1260498,\"assignee_id\":1260498,\"partner_id\":670891617,\"billing_address\":{\"id\":362006285,\"label\":null,\"first_name\":\"\",\"full_name\":\"\",\"last_name\":\"\",\"address1\":\"Cổng 2, chung cư ruby celadon, 36 tân thắng\",\"address2\":\"Cổng 2, chung cư ruby celadon, 36 tân thắng\",\"email\":\"\",\"phone_number\":\"0914999241\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Tân Phú\",\"ward\":\"Phường Sơn Kỳ\",\"zip_code\":null},\"delivery_type\":\"pickup\",\"tax_treatment\":\"inclusive\",\"discount_rate\":10.000,\"discount_value\":0.0000,\"discount_amount\":63000.0000,\"total\":612360.0000,\"total_tax\":45360.0000,\"total_discount\":63000.0000,\"notes\":null,\"packed_on\":\"2026-04-17T01:28:05Z\",\"received_on\":\"2026-04-17T01:28:26Z\",\"shipped_on\":\"2026-04-17T01:28:26Z\",\"cancel_date\":null,\"cancel_account_id\":null,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:26Z\",\"status\":\"received\",\"composite_fulfillment_status\":\"received\",\"payment_status\":\"paid\",\"stock_out_account_id\":1260498,\"receive_account_id\":null,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":null,\"fulfillment_line_items\":[{\"id\":369559014,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283033,\"product_id\":204359859,\"product_name\":\"Gift Set\",\"variant_id\":333744338,\"variant_name\":\"Giftset 9 NGUYÊN SET\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":630000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":675360.0000,\"line_tax_amount\":45360.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP550\",\"barcode\":\"SP550\",\"unit\":\"Hộp\",\"variant_options\":\"Giftset 9 NGUYÊN SET\",\"serials\":null},{\"id\":369559015,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283034,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744231,\"variant_name\":\"Bánh 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\":369559016,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283035,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744227,\"variant_name\":\"Bánh 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},{\"id\":369559017,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283036,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744226,\"variant_name\":\"Bánh 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\":369559018,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283037,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744243,\"variant_name\":\"Bánh Hộp Tròn Mini - 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\":369559019,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283038,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744228,\"variant_name\":\"Bánh 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\":369559020,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283039,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744241,\"variant_name\":\"Bánh Hộp Tròn Mini - CHOCOMINT\",\"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\":\"SP173\",\"barcode\":\"SP173\",\"unit\":\"cái\",\"variant_options\":\"CHOCOMINT\",\"serials\":null},{\"id\":369559021,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283040,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744240,\"variant_name\":\"Bánh Hộp Tròn Mini - 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\":369559022,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283041,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744235,\"variant_name\":\"Bánh Hộp Tròn Mini - Bưởi Hồng\",\"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\":\"SP588\",\"barcode\":\"SP004\",\"unit\":\"cái\",\"variant_options\":\"Bưởi Hồng\",\"serials\":null},{\"id\":369559023,\"created_on\":\"2026-04-17T01:28:05Z\",\"modified_on\":\"2026-04-17T01:28:05Z\",\"order_line_item_id\":395283042,\"product_id\":204359835,\"product_name\":\"Bánh Hộp Tròn Mini\",\"variant_id\":333744230,\"variant_name\":\"Bánh Hộp Tròn Mini - Việt Quất\",\"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\":\"SP530\",\"barcode\":\"SP530\",\"unit\":\"cái\",\"variant_options\":\"Việt Quất\",\"serials\":null}],\"shipment\":null,\"payments\":[{\"id\":210296652,\"tenant_id\":0,\"location_id\":0,\"account_id\":1260498,\"created_on\":\"2026-04-17T01:28:26Z\",\"modified_on\":\"2026-04-17T01:28:26Z\",\"order_id\":180946198,\"payment_method_id\":3621317,\"amount\":612360,\"reference\":null,\"paid_on\":\"2026-04-17T01:28:26Z\",\"status\":\"active\",\"currency_id\":0,\"exchange_rate\":null,\"paid_amount\":0,\"returned_amount\":0}],\"total_quantity\":10.000,\"reason_cancel_id\":null}],\"payments\":null,\"prepayments\":[{\"id\":151623127,\"payment_method_id\":3621317,\"paid_on\":\"2026-04-16T14:30:24Z\",\"amount\":612360.0000,\"account_id\":1260498,\"note\":null,\"created_on\":\"2026-04-16T14:30:30Z\",\"modified_on\":\"2026-04-16T14:30:30Z\",\"reference\":null,\"source\":\"customer_prepaid\",\"source_id\":null,\"paid_amount\":612360.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\":\"2026-04-16T14:30:30Z\",\"finished_on\":null,\"completed_on\":\"2026-04-17T01:28:26Z\",\"channel\":null,\"cancelled_on\":null,\"promotion_redemptions\":[],\"from_order_return_id\":null}', '{\"connection\":[\"Keep-Alive\"],\"host\":[\"test.noibo.the350f.com\"],\"content-length\":[\"22463\"],\"accept-encoding\":[\"gzip;q=1.0,deflate;q=0.6,identity;q=0.3\"],\"x-sapo-test\":[\"false\"],\"user-agent\":[\"JVM\"],\"x-sapo-webhook-address\":[\"https:\\/\\/test.noibo.the350f.com\\/api\\/sapo-webhook\\/receive\"],\"x-sapo-order-id\":[\"180946198\"],\"x-sapo-object-id\":[\"180946198\"],\"x-event-version\":[\"1668737203\"],\"content-type\":[\"application\\/json; charset=utf-8\"],\"x-sapo-tenant-domain\":[\"the350f-ch.mysapogo.com\"],\"x-sapo-hmac-sha256\":[\"D1ole340RGVE9n7nk43QDqQ3PvARM5seqodAtOA+IKE=\"],\"x-sapo-topic\":[\"orders\\/update\"],\"accept\":[\"*\\/*\"],\"x-php-ob-level\":[\"1\"]}', 'D1ole340RGVE9n7nk43QDqQ3PvARM5seqodAtOA+IKE=', '2026-04-17 01:45:54', 'pending', 0, NULL, NULL);

"COMMIT"

"COMMIT";