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\":223220978,\"tenant_id\":816347,\"location_id\":776355,\"code\":\"SON514884\",\"created_on\":\"2026-08-19T05:35:57Z\",\"modified_on\":\"2026-08-19T15:58:17Z\",\"issued_on\":\"2026-08-19T05:35:57Z\",\"ship_on\":null,\"ship_on_min\":\"2026-08-19T06:00:00Z\",\"ship_on_max\":\"2026-08-19T06:00:00Z\",\"account_id\":1260498,\"assignee_id\":1260498,\"customer_id\":707528206,\"customer_data\":{\"id\":707528206,\"tenant_id\":816347,\"default_location_id\":null,\"created_on\":\"2025-05-22T15:23:50Z\",\"modified_on\":\"2025-10-24T03:25:24Z\",\"code\":\"CUZN108177\",\"name\":\"C Quyên (CH05) 20%\",\"dob\":null,\"sex\":\"other\",\"description\":null,\"email\":null,\"fax\":null,\"phone_number\":\"0786861204\",\"tax_number\":null,\"website\":null,\"customer_group_id\":3122518,\"group_name\":\"Bán lẻ\",\"assignee_id\":1239325,\"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\":662901095,\"created_on\":\"2025-05-28T14:03:37Z\",\"modified_on\":\"2026-08-19T05:31:47Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"address1\":\"CH 7 Hoa Phượng\",\"address2\":null,\"zip_code\":\"\",\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":\"\",\"label\":null,\"phone_number\":\"0786861204\",\"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\":160697460.60,\"order_purchases\":190.00,\"returned_item_quantity\":0.00,\"net_quantity\":1059.00,\"last_order_on\":\"2026-08-19T05:49:49Z\"},\"social_customers\":[]},\"contact_id\":null,\"billing_address\":{\"id\":438072718,\"label\":null,\"first_name\":\"\",\"full_name\":\"\",\"last_name\":\"\",\"address1\":\"CH 5 Hoa Phượng\",\"address2\":\"CH 5 Hoa Phượng\",\"email\":\"\",\"phone_number\":\"0786861204\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"zip_code\":null},\"shipping_address\":{\"id\":438072719,\"label\":null,\"first_name\":null,\"full_name\":\"\",\"last_name\":null,\"address1\":\"CH 7 Hoa Phượng\",\"address2\":null,\"email\":null,\"phone_number\":\"0786861204\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"zip_code\":\"\"},\"email\":null,\"phone_number\":\"0786861204\",\"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\":8722572,\"tax_label\":null,\"total\":379296,\"order_discount_rate\":20.00,\"order_discount_value\":0.0000,\"discount_reason\":null,\"total_discount\":87800,\"total_tax\":28096,\"note\":\"đã ck \\n\\ntag cắm mini: Chúc mừng Sinh Nhật Mai Panda \\nMãi Xinh Đẹp và Vui Vẻ nhé ✨\",\"tags\":[],\"delivery_fee\":null,\"order_discount_amount\":87800.0000,\"discount_items\":[{\"position\":0,\"source\":\"manual\",\"rate\":20.000,\"value\":0.0000,\"amount\":87800.0000,\"reason\":\"\",\"promotion_redemption_id\":null,\"promotion_condition_item_id\":null}],\"order_line_items\":[{\"id\":490086290,\"created_on\":\"2026-08-19T05:35:57Z\",\"modified_on\":\"2026-08-19T05:41:37Z\",\"variant_id\":445175980,\"product_id\":246629724,\"product_name\":\"Bánh Mini Hộp Thiếc\",\"variant_name\":\"Bánh Mini Hộp Thiếc - Dâu\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":6336.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":99000,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":105336.0000000000,\"discount_items\":[],\"sku\":\"SP355 -D\",\"barcode\":\"SP355 -D\",\"unit\":\"cái\",\"variant_options\":\"Dâu\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":490086291,\"created_on\":\"2026-08-19T05:35:57Z\",\"modified_on\":\"2026-08-19T05:41:37Z\",\"variant_id\":333744045,\"product_id\":204359780,\"product_name\":\"BÁNH MERRY BERRY HỘP THIẾC\",\"variant_name\":\"BÁNH MERRY BERRY HỘP THIẾC\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":21760.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":340000,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":361760.0000000000,\"discount_items\":[],\"sku\":\"SP303\",\"barcode\":\"SP303\",\"unit\":\"cái\",\"variant_options\":\"Mặc định\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]}],\"fulfillments\":[{\"id\":205368991,\"tenant_id\":816347,\"stock_location_id\":776355,\"code\":\"FUN598348\",\"order_id\":223220978,\"account_id\":1302516,\"assignee_id\":1302516,\"partner_id\":707528206,\"billing_address\":{\"id\":438079174,\"label\":null,\"first_name\":\"\",\"full_name\":\"\",\"last_name\":\"\",\"address1\":\"CH 5 Hoa Phượng\",\"address2\":\"CH 5 Hoa Phượng\",\"email\":\"\",\"phone_number\":\"0786861204\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"zip_code\":null},\"delivery_type\":\"pickup\",\"tax_treatment\":\"inclusive\",\"discount_rate\":20.000,\"discount_value\":0.0000,\"discount_amount\":87800.0000,\"total\":379296.0000,\"total_tax\":28096.0000,\"total_discount\":87800.0000,\"notes\":null,\"packed_on\":\"2026-08-19T05:49:46Z\",\"received_on\":\"2026-08-19T05:49:49Z\",\"shipped_on\":\"2026-08-19T05:49:49Z\",\"cancel_date\":null,\"cancel_account_id\":null,\"created_on\":\"2026-08-19T05:49:46Z\",\"modified_on\":\"2026-08-19T05:49:49Z\",\"status\":\"received\",\"composite_fulfillment_status\":\"received\",\"payment_status\":\"paid\",\"stock_out_account_id\":1302516,\"receive_account_id\":null,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":null,\"fulfillment_line_items\":[{\"id\":458757114,\"created_on\":\"2026-08-19T05:49:46Z\",\"modified_on\":\"2026-08-19T05:49:46Z\",\"order_line_item_id\":490086290,\"product_id\":246629724,\"product_name\":\"Bánh Mini Hộp Thiếc\",\"variant_id\":445175980,\"variant_name\":\"Bánh Mini Hộp Thiếc - Dâu\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":99000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":105336.0000,\"line_tax_amount\":6336.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP355 -D\",\"barcode\":\"SP355 -D\",\"unit\":\"cái\",\"variant_options\":\"Dâu\",\"serials\":null},{\"id\":458757115,\"created_on\":\"2026-08-19T05:49:46Z\",\"modified_on\":\"2026-08-19T05:49:46Z\",\"order_line_item_id\":490086291,\"product_id\":204359780,\"product_name\":\"BÁNH MERRY BERRY HỘP THIẾC\",\"variant_id\":333744045,\"variant_name\":\"BÁNH MERRY BERRY HỘP THIẾC\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":340000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":361760.0000,\"line_tax_amount\":21760.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP303\",\"barcode\":\"SP303\",\"unit\":\"cái\",\"variant_options\":\"Mặc định\",\"serials\":null}],\"shipment\":null,\"payments\":[{\"id\":259290107,\"tenant_id\":0,\"location_id\":0,\"account_id\":1302516,\"created_on\":\"2026-08-19T05:49:49Z\",\"modified_on\":\"2026-08-19T05:49:49Z\",\"order_id\":223220978,\"payment_method_id\":3621885,\"amount\":379296,\"reference\":null,\"paid_on\":\"2026-08-19T05:49:49Z\",\"status\":\"active\",\"currency_id\":0,\"exchange_rate\":null,\"paid_amount\":0,\"returned_amount\":0}],\"total_quantity\":2.000,\"reason_cancel_id\":null}],\"payments\":null,\"prepayments\":[{\"id\":188015384,\"payment_method_id\":3621885,\"paid_on\":\"2026-08-19T05:40:35Z\",\"amount\":379296.0000,\"account_id\":1260498,\"note\":\"MS07T11743220498601\",\"created_on\":\"2026-08-19T05:40:41Z\",\"modified_on\":\"2026-08-19T05:41:10Z\",\"reference\":\"FT26231008376265 - MD071787118042307IU\",\"source\":\"customer_prepaid\",\"source_id\":null,\"paid_amount\":379296.000,\"returned_amount\":0.000,\"status\":\"active\",\"integrated\":true,\"status_before_cancelled\":null}],\"order_returns\":[],\"expected_payment_method_id\":0,\"expected_delivery_type\":null,\"expected_delivery_provider_id\":null,\"process_status_id\":null,\"process_status\":null,\"reason_cancel_id\":null,\"finalized_on\":\"2026-08-19T05:40:41Z\",\"finished_on\":null,\"completed_on\":\"2026-08-19T05:49:49Z\",\"channel\":null,\"cancelled_on\":null,\"promotion_redemptions\":[],\"from_order_return_id\":null}', '{\"connection\":[\"Keep-Alive\"],\"host\":[\"test.noibo.the350f.com\"],\"content-length\":[\"8701\"],\"accept-encoding\":[\"gzip;q=1.0,deflate;q=0.6,identity;q=0.3\"],\"x-sapo-order-id\":[\"223220978\"],\"x-sapo-object-id\":[\"223220978\"],\"x-sapo-test\":[\"false\"],\"user-agent\":[\"JVM\"],\"x-sapo-hmac-sha256\":[\"D\\/4obOiKwaIbj30dZ4uFTpsfS7PUOLFOsTmWk\\/VfL0U=\"],\"x-event-version\":[\"2155103569\"],\"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-topic\":[\"orders\\/update\"],\"accept\":[\"*\\/*\"],\"x-php-ob-level\":[\"1\"]}', 'D/4obOiKwaIbj30dZ4uFTpsfS7PUOLFOsTmWk/VfL0U=', '2026-08-19 15:58:17', 'pending', 0, NULL, NULL);

"START TRANSACTION"

"START TRANSACTION";