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\":151776188,\"tenant_id\":816347,\"location_id\":776510,\"code\":\"SON362006\",\"created_on\":\"2026-01-21T00:07:15Z\",\"modified_on\":\"2026-01-21T12:13:03Z\",\"issued_on\":\"2026-01-21T00:07:15Z\",\"ship_on\":null,\"ship_on_min\":\"2026-01-21T04:45:00Z\",\"ship_on_max\":\"2026-01-21T05:45:00Z\",\"account_id\":1277050,\"assignee_id\":1277050,\"customer_id\":897686822,\"customer_data\":{\"id\":897686822,\"tenant_id\":816347,\"default_location_id\":null,\"created_on\":\"2026-01-21T00:06:04Z\",\"modified_on\":\"2026-01-21T00:06:04Z\",\"code\":\"CUZN268266\",\"name\":\"TRƯƠNG NỮ TRẦN CHUNG\",\"dob\":null,\"sex\":\"other\",\"description\":null,\"email\":null,\"fax\":null,\"phone_number\":\"0905008885\",\"tax_number\":null,\"website\":null,\"customer_group_id\":3122518,\"group_name\":\"Bán lẻ\",\"assignee_id\":1277050,\"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\":843099888,\"created_on\":\"2026-01-21T00:06:24Z\",\"modified_on\":\"2026-01-21T00:06:24Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 2\",\"ward\":\"Phường An Khánh\",\"address1\":\"MB Đông Hồ Chí Minh - 173 Trần Não\",\"address2\":null,\"zip_code\":\"\",\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":\"Chị Ngọc\",\"label\":null,\"phone_number\":\"0961010568\",\"status\":\"active\"},{\"id\":843291428,\"created_on\":\"2026-01-21T04:06:15Z\",\"modified_on\":\"2026-01-21T04:06:15Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường An Phú\",\"address1\":\"đường 31e\",\"address2\":null,\"zip_code\":\"\",\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":\"Chị Ngọc\",\"label\":null,\"phone_number\":\"0961010568\",\"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\":null,\"loyalty_customer\":null,\"sale_order\":{\"total_sales\":561600.00,\"order_purchases\":1.00,\"returned_item_quantity\":0.00,\"net_quantity\":1.00,\"last_order_on\":\"2026-01-21T06:08:07Z\"},\"social_customers\":[]},\"contact_id\":null,\"billing_address\":null,\"shipping_address\":{\"id\":304259758,\"label\":null,\"first_name\":null,\"full_name\":\"Chị Ngọc\",\"last_name\":null,\"address1\":\"đường 31e\",\"address2\":null,\"email\":\"\",\"phone_number\":\"0961010568\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường An Phú\",\"zip_code\":\"\"},\"email\":null,\"phone_number\":\"0905008885\",\"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\":8722570,\"tax_label\":null,\"total\":561600,\"order_discount_rate\":0.00,\"order_discount_value\":0.0000,\"discount_reason\":null,\"total_discount\":0,\"total_tax\":41600,\"note\":\"[P30] đã ck zl xanh - bánh tặng \\n\\ntag:\\nChúc mừng sinh nhật bác Ngọc!\\n21-01\\n\\nchụp hình bánh gửi khách \\n\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tới\",\"tags\":[],\"delivery_fee\":null,\"order_discount_amount\":0,\"discount_items\":[],\"order_line_items\":[{\"id\":331360816,\"created_on\":\"2026-01-21T00:07:15Z\",\"modified_on\":\"2026-01-21T04:09:41Z\",\"variant_id\":333744278,\"product_id\":204359844,\"product_name\":\"Bánh Blueberry Mousse\",\"variant_name\":\"Bánh Blueberry Mousse - Size 16cm\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":41600.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":520000,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":561600.0000000000,\"discount_items\":[],\"sku\":\"SP0317\",\"barcode\":\"SP0317\",\"unit\":\"cái\",\"variant_options\":\"Size 16cm\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]}],\"fulfillments\":[{\"id\":138441849,\"tenant_id\":816347,\"stock_location_id\":776510,\"code\":\"FUN434812\",\"order_id\":151776188,\"account_id\":1277097,\"assignee_id\":1277097,\"partner_id\":897686822,\"billing_address\":null,\"delivery_type\":\"courier\",\"tax_treatment\":\"inclusive\",\"discount_rate\":0.000,\"discount_value\":0.0000,\"discount_amount\":0.0000,\"total\":561600.0000,\"total_tax\":41600.0000,\"total_discount\":0.0000,\"notes\":null,\"packed_on\":\"2026-01-21T04:06:05Z\",\"received_on\":null,\"shipped_on\":null,\"cancel_date\":\"2026-01-21T04:06:23Z\",\"cancel_account_id\":1277082,\"created_on\":\"2026-01-21T04:06:05Z\",\"modified_on\":\"2026-01-21T04:06:23Z\",\"status\":\"cancelled\",\"composite_fulfillment_status\":\"packed_cancelled\",\"payment_status\":\"unpaid\",\"stock_out_account_id\":null,\"receive_account_id\":null,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":\"2026-01-21T04:06:23Z\",\"fulfillment_line_items\":[{\"id\":308713679,\"created_on\":\"2026-01-21T04:06:05Z\",\"modified_on\":\"2026-01-21T04:06:05Z\",\"order_line_item_id\":331360816,\"product_id\":204359844,\"product_name\":\"Bánh Blueberry Mousse\",\"variant_id\":333744278,\"variant_name\":\"Bánh Blueberry Mousse - Size 16cm\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":520000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":561600.0000,\"line_tax_amount\":41600.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP0317\",\"barcode\":\"SP0317\",\"unit\":\"cái\",\"variant_options\":\"Size 16cm\",\"serials\":null}],\"shipment\":{\"id\":62984115,\"delivery_service_provider_id\":513214,\"service_name\":null,\"cod_amount\":0.0000,\"freight_amount\":0.0000,\"freight_amount_detail\":null,\"delivery_fee\":0.0000,\"tracking_code\":\"FUN434812\",\"tracking_url\":null,\"created_on\":\"2026-01-21T04:06:05Z\",\"modified_on\":\"2026-01-21T04:06:05Z\",\"sender_address\":null,\"shipping_address\":{\"id\":304527233,\"label\":null,\"first_name\":\"Chị Ngọc\",\"full_name\":\"Chị Ngọc\",\"last_name\":null,\"address1\":\"MB Đông Hồ Chí Minh - 173 Trần Não\",\"address2\":null,\"email\":null,\"phone_number\":\"0961010568\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận 2\",\"ward\":\"Phường An Khánh\",\"zip_code\":null},\"shipper_deposits\":[],\"detail\":\"{\\\"delivery_service_provider_id\\\":513214,\\\"receiver_name\\\":\\\"Chị Ngọc\\\",\\\"receiver_phone\\\":\\\"0961010568\\\",\\\"cod_amount\\\":0,\\\"destination_address\\\":\\\"MB Đông Hồ Chí Minh - 173 Trần Não\\\",\\\"destination_province_id\\\":2,\\\"destination_district_id\\\":31,\\\"delivery_fee\\\":0,\\\"destination_country_id\\\":201,\\\"source_location_id\\\":776510,\\\"note\\\":\\\"Cho xem hàng, không cho thử |[P30] check ck zl xanh - bánh tặng \\\\n\\\\ntag:\\\\nChúc mừng sinh nhật bác Ngọc!\\\\n21-01\\\\n\\\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tới\\\",\\\"destination_country\\\":\\\"Việt Nam\\\",\\\"destination_district\\\":\\\"Quận 2\\\",\\\"destination_province\\\":\\\"TP Hồ Chí Minh\\\",\\\"weight\\\":100,\\\"destination_ward\\\":\\\"Phường An Khánh\\\"}\",\"note\":\"Cho xem hàng, không cho thử |[P30] check ck zl xanh - bánh tặng \\n\\ntag:\\nChúc mừng sinh nhật bác Ngọc!\\n21-01\\n\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tớ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\":1.000,\"reason_cancel_id\":null},{\"id\":138442080,\"tenant_id\":816347,\"stock_location_id\":776510,\"code\":\"FUN434813\",\"order_id\":151776188,\"account_id\":1277097,\"assignee_id\":1277097,\"partner_id\":897686822,\"billing_address\":null,\"delivery_type\":\"courier\",\"tax_treatment\":\"inclusive\",\"discount_rate\":0.000,\"discount_value\":0.0000,\"discount_amount\":0.0000,\"total\":561600.0000,\"total_tax\":41600.0000,\"total_discount\":0.0000,\"notes\":null,\"packed_on\":\"2026-01-21T04:06:48Z\",\"received_on\":null,\"shipped_on\":null,\"cancel_date\":\"2026-01-21T04:09:26Z\",\"cancel_account_id\":1277082,\"created_on\":\"2026-01-21T04:06:48Z\",\"modified_on\":\"2026-01-21T04:09:26Z\",\"status\":\"cancelled\",\"composite_fulfillment_status\":\"packed_cancelled\",\"payment_status\":\"unpaid\",\"stock_out_account_id\":null,\"receive_account_id\":null,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":\"2026-01-21T04:09:26Z\",\"fulfillment_line_items\":[{\"id\":308714291,\"created_on\":\"2026-01-21T04:06:48Z\",\"modified_on\":\"2026-01-21T04:06:48Z\",\"order_line_item_id\":331360816,\"product_id\":204359844,\"product_name\":\"Bánh Blueberry Mousse\",\"variant_id\":333744278,\"variant_name\":\"Bánh Blueberry Mousse - Size 16cm\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":520000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":561600.0000,\"line_tax_amount\":41600.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP0317\",\"barcode\":\"SP0317\",\"unit\":\"cái\",\"variant_options\":\"Size 16cm\",\"serials\":null}],\"shipment\":{\"id\":62984223,\"delivery_service_provider_id\":513214,\"service_name\":null,\"cod_amount\":0.0000,\"freight_amount\":0.0000,\"freight_amount_detail\":null,\"delivery_fee\":0.0000,\"tracking_code\":\"FUN434813\",\"tracking_url\":null,\"created_on\":\"2026-01-21T04:06:48Z\",\"modified_on\":\"2026-01-21T04:06:48Z\",\"sender_address\":null,\"shipping_address\":{\"id\":304527801,\"label\":null,\"first_name\":\"Chị Ngọc\",\"full_name\":\"Chị Ngọc\",\"last_name\":null,\"address1\":\"đường 31e\",\"address2\":null,\"email\":null,\"phone_number\":\"0961010568\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường An Phú\",\"zip_code\":null},\"shipper_deposits\":[],\"detail\":\"{\\\"delivery_service_provider_id\\\":513214,\\\"receiver_name\\\":\\\"Chị Ngọc\\\",\\\"receiver_phone\\\":\\\"0961010568\\\",\\\"cod_amount\\\":0,\\\"destination_address\\\":\\\"đường 31e\\\",\\\"destination_province_id\\\":2,\\\"destination_district_id\\\":10924,\\\"delivery_fee\\\":0,\\\"destination_country_id\\\":201,\\\"source_location_id\\\":776510,\\\"note\\\":\\\"Cho xem hàng, không cho thử |[P30] check ck zl xanh - bánh tặng \\\\n\\\\ntag:\\\\nChúc mừng sinh nhật bác Ngọc!\\\\n21-01\\\\n\\\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tới\\\",\\\"destination_country\\\":\\\"Việt Nam\\\",\\\"destination_district\\\":\\\"Thành phố Thủ Đức\\\",\\\"destination_province\\\":\\\"TP Hồ Chí Minh\\\",\\\"weight\\\":100,\\\"destination_ward\\\":\\\"Phường An Phú\\\"}\",\"note\":\"Cho xem hàng, không cho thử |[P30] check ck zl xanh - bánh tặng \\n\\ntag:\\nChúc mừng sinh nhật bác Ngọc!\\n21-01\\n\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tớ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\":1.000,\"reason_cancel_id\":null},{\"id\":138443081,\"tenant_id\":816347,\"stock_location_id\":776510,\"code\":\"FUN434816\",\"order_id\":151776188,\"account_id\":1277097,\"assignee_id\":1277097,\"partner_id\":897686822,\"billing_address\":null,\"delivery_type\":\"courier\",\"tax_treatment\":\"inclusive\",\"discount_rate\":0.000,\"discount_value\":0.0000,\"discount_amount\":0.0000,\"total\":561600.0000,\"total_tax\":41600.0000,\"total_discount\":0.0000,\"notes\":\"[P30] check ck zl xanh - bánh tặng \\n\\ntag:\\nChúc mừng sinh nhật bác Ngọc!\\n21-01\\n\\nchụp hình bánh gửi khách \\n\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tới\",\"packed_on\":\"2026-01-21T04:09:51Z\",\"received_on\":null,\"shipped_on\":null,\"cancel_date\":\"2026-01-21T04:10:36Z\",\"cancel_account_id\":1277092,\"created_on\":\"2026-01-21T04:09:51Z\",\"modified_on\":\"2026-01-21T04:10:36Z\",\"status\":\"cancelled\",\"composite_fulfillment_status\":\"packed_cancelled\",\"payment_status\":\"unpaid\",\"stock_out_account_id\":null,\"receive_account_id\":null,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":\"2026-01-21T04:10:36Z\",\"fulfillment_line_items\":[{\"id\":308716723,\"created_on\":\"2026-01-21T04:09:51Z\",\"modified_on\":\"2026-01-21T04:09:51Z\",\"order_line_item_id\":331360816,\"product_id\":204359844,\"product_name\":\"Bánh Blueberry Mousse\",\"variant_id\":333744278,\"variant_name\":\"Bánh Blueberry Mousse - Size 16cm\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":520000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":561600.0000,\"line_tax_amount\":41600.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP0317\",\"barcode\":\"SP0317\",\"unit\":\"cái\",\"variant_options\":\"Size 16cm\",\"serials\":null}],\"shipment\":{\"id\":62984692,\"delivery_service_provider_id\":512914,\"service_name\":null,\"cod_amount\":0.0000,\"freight_amount\":0.0000,\"freight_amount_detail\":null,\"delivery_fee\":0.0000,\"tracking_code\":\"FUN434816\",\"tracking_url\":null,\"created_on\":\"2026-01-21T04:09:51Z\",\"modified_on\":\"2026-01-21T04:09:51Z\",\"sender_address\":null,\"shipping_address\":{\"id\":304530148,\"label\":null,\"first_name\":\"Chị Ngọc\",\"full_name\":\"Chị Ngọc\",\"last_name\":null,\"address1\":\"đường 31e\",\"address2\":null,\"email\":null,\"phone_number\":\"0961010568\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường An Phú\",\"zip_code\":null},\"shipper_deposits\":[],\"detail\":\"{\\\"delivery_service_provider_id\\\":512914,\\\"receiver_name\\\":\\\"Chị Ngọc\\\",\\\"receiver_phone\\\":\\\"0961010568\\\",\\\"cod_amount\\\":0,\\\"destination_address\\\":\\\"đường 31e\\\",\\\"destination_province_id\\\":2,\\\"destination_district_id\\\":10924,\\\"delivery_fee\\\":0,\\\"destination_country_id\\\":201,\\\"source_location_id\\\":776510,\\\"note\\\":\\\"Cho xem hàng, không cho thử |[P30] check ck zl xanh - bánh tặng \\\\n\\\\ntag:\\\\nChúc mừng sinh nhật bác Ngọc!\\\\n21-01\\\\n\\\\nchụp hình bánh gửi khách \\\\n\\\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tới\\\",\\\"destination_country\\\":\\\"Việt Nam\\\",\\\"destination_district\\\":\\\"Thành phố Thủ Đức\\\",\\\"destination_province\\\":\\\"TP Hồ Chí Minh\\\",\\\"weight\\\":100,\\\"destination_ward\\\":\\\"Phường An Phú\\\"}\",\"note\":\"Cho xem hàng, không cho thử |[P30] check ck zl xanh - bánh tặng \\n\\ntag:\\nChúc mừng sinh nhật bác Ngọc!\\n21-01\\n\\nchụp hình bánh gửi khách \\n\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tớ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\":1.000,\"reason_cancel_id\":null},{\"id\":138443271,\"tenant_id\":816347,\"stock_location_id\":776510,\"code\":\"FUN434817\",\"order_id\":151776188,\"account_id\":1277092,\"assignee_id\":1277092,\"partner_id\":897686822,\"billing_address\":null,\"delivery_type\":\"courier\",\"tax_treatment\":\"inclusive\",\"discount_rate\":0.000,\"discount_value\":0.0000,\"discount_amount\":0.0000,\"total\":561600.0000,\"total_tax\":41600.0000,\"total_discount\":0.0000,\"notes\":\"[P30] check ck zl xanh - bánh tặng \\n\\ntag:\\nChúc mừng sinh nhật bác Ngọc!\\n21-01\\n\\nchụp hình bánh gửi khách \\n\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tới\",\"packed_on\":\"2026-01-21T04:10:41Z\",\"received_on\":\"2026-01-21T06:08:07Z\",\"shipped_on\":\"2026-01-21T06:08:05Z\",\"cancel_date\":null,\"cancel_account_id\":null,\"created_on\":\"2026-01-21T04:10:41Z\",\"modified_on\":\"2026-01-21T12:12:57Z\",\"status\":\"received\",\"composite_fulfillment_status\":\"received\",\"payment_status\":\"paid\",\"stock_out_account_id\":1277101,\"receive_account_id\":1277101,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":null,\"fulfillment_line_items\":[{\"id\":308717195,\"created_on\":\"2026-01-21T04:10:41Z\",\"modified_on\":\"2026-01-21T04:10:41Z\",\"order_line_item_id\":331360816,\"product_id\":204359844,\"product_name\":\"Bánh Blueberry Mousse\",\"variant_id\":333744278,\"variant_name\":\"Bánh Blueberry Mousse - Size 16cm\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":520000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":561600.0000,\"line_tax_amount\":41600.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP0317\",\"barcode\":\"SP0317\",\"unit\":\"cái\",\"variant_options\":\"Size 16cm\",\"serials\":null}],\"shipment\":{\"id\":62984731,\"delivery_service_provider_id\":513214,\"service_name\":null,\"cod_amount\":0.0000,\"freight_amount\":0.0000,\"freight_amount_detail\":null,\"delivery_fee\":0.0000,\"tracking_code\":\"FUN434817\",\"tracking_url\":null,\"created_on\":\"2026-01-21T04:10:41Z\",\"modified_on\":\"2026-01-21T04:10:41Z\",\"sender_address\":null,\"shipping_address\":{\"id\":304530604,\"label\":null,\"first_name\":\"Chị Ngọc\",\"full_name\":\"Chị Ngọc\",\"last_name\":null,\"address1\":\"đường 31e\",\"address2\":null,\"email\":null,\"phone_number\":\"0961010568\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Thành phố Thủ Đức\",\"ward\":\"Phường An Phú\",\"zip_code\":null},\"shipper_deposits\":[],\"detail\":\"{\\\"delivery_service_provider_id\\\":513214,\\\"receiver_name\\\":\\\"Chị Ngọc\\\",\\\"receiver_phone\\\":\\\"0961010568\\\",\\\"cod_amount\\\":0,\\\"destination_address\\\":\\\"đường 31e\\\",\\\"destination_province_id\\\":2,\\\"destination_district_id\\\":10924,\\\"delivery_fee\\\":0,\\\"destination_country_id\\\":201,\\\"source_location_id\\\":776510,\\\"note\\\":\\\"Cho xem hàng, không cho thử |[P30] check ck zl xanh - bánh tặng \\\\n\\\\ntag:\\\\nChúc mừng sinh nhật bác Ngọc!\\\\n21-01\\\\n\\\\nchụp hình bánh gửi khách \\\\n\\\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tới\\\",\\\"destination_country\\\":\\\"Việt Nam\\\",\\\"destination_district\\\":\\\"Thành phố Thủ Đức\\\",\\\"destination_province\\\":\\\"TP Hồ Chí Minh\\\",\\\"weight\\\":100,\\\"destination_ward\\\":\\\"Phường An Phú\\\"}\",\"note\":\"Cho xem hàng, không cho thử |[P30] check ck zl xanh - bánh tặng \\n\\ntag:\\nChúc mừng sinh nhật bác Ngọc!\\n21-01\\n\\nchụp hình bánh gửi khách \\n\\nshipper giao càng sớm càng tốt, giao gần tới gọi cho khách để khách hướng dẫn chỉ đường tớ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\":[{\"id\":176014753,\"tenant_id\":0,\"location_id\":0,\"account_id\":1277043,\"created_on\":\"2026-01-21T12:12:57Z\",\"modified_on\":\"2026-01-21T12:12:57Z\",\"order_id\":151776188,\"payment_method_id\":3621317,\"amount\":561600,\"reference\":null,\"paid_on\":\"2026-01-21T12:12:57Z\",\"status\":\"active\",\"currency_id\":0,\"exchange_rate\":null,\"paid_amount\":0,\"returned_amount\":0}],\"total_quantity\":1.000,\"reason_cancel_id\":null}],\"payments\":null,\"prepayments\":[{\"id\":126848235,\"payment_method_id\":3621317,\"paid_on\":\"2026-01-21T12:12:54Z\",\"amount\":561600.0000,\"account_id\":1277043,\"note\":null,\"created_on\":\"2026-01-21T12:12:57Z\",\"modified_on\":\"2026-01-21T12:12:57Z\",\"reference\":null,\"source\":\"customer_prepaid\",\"source_id\":null,\"paid_amount\":561600.000,\"returned_amount\":0.000,\"status\":\"active\",\"integrated\":false,\"status_before_cancelled\":null}],\"order_returns\":[],\"expected_payment_method_id\":0,\"expected_delivery_type\":null,\"expected_delivery_provider_id\":null,\"process_status_id\":18525,\"process_status\":null,\"reason_cancel_id\":null,\"finalized_on\":\"2026-01-21T00:07:18Z\",\"finished_on\":null,\"completed_on\":\"2026-01-21T12:12:57Z\",\"channel\":null,\"cancelled_on\":null,\"promotion_redemptions\":[],\"from_order_return_id\":null}', '{\"connection\":[\"Keep-Alive\"],\"host\":[\"test.noibo.the350f.com\"],\"content-length\":[\"20431\"],\"x-sapo-hmac-sha256\":[\"x0gyjTVB71\\/Gc+J9Whz4ctJRgYGNnw4+S2HxSrckH8I=\"],\"accept-encoding\":[\"gzip;q=1.0,deflate;q=0.6,identity;q=0.3\"],\"x-sapo-order-id\":[\"151776188\"],\"x-sapo-object-id\":[\"151776188\"],\"x-sapo-test\":[\"false\"],\"user-agent\":[\"JVM\"],\"x-sapo-webhook-address\":[\"https:\\/\\/test.noibo.the350f.com\\/api\\/sapo-webhook\\/receive\"],\"x-event-version\":[\"1377019425\"],\"content-type\":[\"application\\/json; charset=utf-8\"],\"x-sapo-tenant-domain\":[\"the350f-ch.mysapogo.com\"],\"x-sapo-topic\":[\"orders\\/update\"],\"accept\":[\"*\\/*\"],\"x-php-ob-level\":[\"1\"]}', 'x0gyjTVB71/Gc+J9Whz4ctJRgYGNnw4+S2HxSrckH8I=', '2026-01-21 12:13:05', 'pending', 0, NULL, NULL);

"COMMIT"

"COMMIT";