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\":232029713,\"tenant_id\":816347,\"location_id\":776356,\"code\":\"SON530814\",\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-12T01:09:30Z\",\"issued_on\":\"2026-09-11T15:33:44Z\",\"ship_on\":null,\"ship_on_min\":null,\"ship_on_max\":null,\"account_id\":1260493,\"assignee_id\":1260493,\"customer_id\":670585003,\"customer_data\":{\"id\":670585003,\"tenant_id\":816347,\"default_location_id\":null,\"created_on\":\"2025-03-31T08:29:18Z\",\"modified_on\":\"2026-05-30T15:27:33Z\",\"code\":\"KH127654\",\"name\":\"C NHƯ\",\"dob\":null,\"sex\":\"other\",\"description\":\"\",\"email\":\"\",\"fax\":\"\",\"phone_number\":\"0902468349\",\"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\":928687479,\"created_on\":\"2026-05-30T15:27:33Z\",\"modified_on\":\"2026-05-30T15:27:33Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"address1\":\"5\",\"address2\":null,\"zip_code\":null,\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":null,\"phone_number\":\"0902468349\",\"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\":680000.0000,\"loyalty_customer\":null,\"sale_order\":{\"total_sales\":2901452.00,\"order_purchases\":6.00,\"returned_item_quantity\":0.00,\"net_quantity\":23.00,\"last_order_on\":\"2026-09-11T15:33:44Z\"},\"social_customers\":[]},\"contact_id\":null,\"billing_address\":{\"id\":454192066,\"label\":null,\"first_name\":null,\"full_name\":null,\"last_name\":null,\"address1\":\"5\",\"address2\":null,\"email\":null,\"phone_number\":\"0902468349\",\"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\":454192067,\"label\":null,\"first_name\":null,\"full_name\":null,\"last_name\":null,\"address1\":\"5\",\"address2\":null,\"email\":null,\"phone_number\":\"0902468349\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"zip_code\":null},\"email\":\"\",\"phone_number\":\"0902468349\",\"reference_number\":null,\"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\":8722575,\"tax_label\":null,\"total\":877716,\"order_discount_rate\":10.00,\"order_discount_value\":0.0000,\"discount_reason\":null,\"total_discount\":90300,\"total_tax\":65016,\"note\":\"mv\",\"tags\":[],\"delivery_fee\":null,\"order_discount_amount\":90300.0000,\"discount_items\":[{\"position\":0,\"source\":\"manual\",\"rate\":10.000,\"value\":0.0000,\"amount\":90300.0000,\"reason\":null,\"promotion_redemption_id\":null,\"promotion_condition_item_id\":null}],\"order_line_items\":[{\"id\":509627623,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"variant_id\":333744225,\"product_id\":204359834,\"product_name\":\"Combo Bánh Mini Tròn\",\"variant_name\":\"Combo Bánh Mini Tròn - Combo 2\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":14256.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":198000,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":212256.0000000000,\"discount_items\":[],\"sku\":\"SP487\",\"barcode\":\"SP487\",\"unit\":\"Combo\",\"variant_options\":\"Combo 2 Hộp Tròn Mini\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":509627624,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"variant_id\":445175982,\"product_id\":246629724,\"product_name\":\"Bánh Mini Hộp Thiếc\",\"variant_name\":\"Bánh Mini Hộp Thiếc - 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\":\"SP355 -Ti\",\"barcode\":\"SP355 -Ti\",\"unit\":\"cái\",\"variant_options\":\"Tiramisu\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":509627625,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"variant_id\":445175988,\"product_id\":246629724,\"product_name\":\"Bánh Mini Hộp Thiếc\",\"variant_name\":\"Bánh Mini Hộp Thiếc - Bơ\",\"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\":\"SP355 -Bo\",\"barcode\":\"SP355 -Bo\",\"unit\":\"cái\",\"variant_options\":\"Bơ\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":509627626,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"variant_id\":386962205,\"product_id\":220259467,\"product_name\":\"BÁNH TIRAMISU HỘP THIẾC TRÒN CLASSIC\",\"variant_name\":\"BÁNH TIRAMISU HỘP THIẾC TRÒN CLASSIC\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":16200.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":225000,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":241200.0000000000,\"discount_items\":[],\"sku\":\"SP335\",\"barcode\":\"SP335\",\"unit\":\"Cái\",\"variant_options\":\"Mặc định\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":509627627,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"variant_id\":452162078,\"product_id\":251127310,\"product_name\":\"2026 Bánh Trung Thu Lava 50gr\",\"variant_name\":\"2026 Bánh Trung Thu Lava 50gr - Trứng Muối\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":17280.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":120000,\"quantity\":2.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":257280.0000000000,\"discount_items\":[],\"sku\":\"SP363-T\",\"barcode\":\"SP363-T\",\"unit\":\"Cái\",\"variant_options\":\"Trứng Muối\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":509627628,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"variant_id\":452162082,\"product_id\":251127310,\"product_name\":\"2026 Bánh Trung Thu Lava 50gr\",\"variant_name\":\"2026 Bánh Trung Thu Lava 50gr - Mochi Custard\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":17280.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":120000,\"quantity\":2.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":257280.0000000000,\"discount_items\":[],\"sku\":\"SP363-Mo\",\"barcode\":\"SP363-Mo\",\"unit\":\"Cái\",\"variant_options\":\"Mochi Custard\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":509627629,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"variant_id\":450463127,\"product_id\":250039807,\"product_name\":\"Hộp Trung Thu 2026\",\"variant_name\":\"Hộp Trung Thu 2026 - Hộp 4 Bánh\",\"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\":\"SP360-4\",\"barcode\":\"SP360-4\",\"unit\":\"Hộp\",\"variant_options\":\"Hộp 4 Bánh\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]}],\"fulfillments\":[{\"id\":213243843,\"tenant_id\":816347,\"stock_location_id\":776356,\"code\":\"FUN614308\",\"order_id\":232029713,\"account_id\":1260493,\"assignee_id\":1260493,\"partner_id\":670585003,\"billing_address\":{\"id\":454192068,\"label\":null,\"first_name\":null,\"full_name\":null,\"last_name\":null,\"address1\":\"5\",\"address2\":null,\"email\":null,\"phone_number\":\"0902468349\",\"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\":10.000,\"discount_value\":0.0000,\"discount_amount\":90300.0000,\"total\":877716.0000,\"total_tax\":65016.0000,\"total_discount\":90300.0000,\"notes\":null,\"packed_on\":\"2026-09-11T15:33:44Z\",\"received_on\":\"2026-09-11T15:33:44Z\",\"shipped_on\":\"2026-09-11T15:33:44Z\",\"cancel_date\":null,\"cancel_account_id\":null,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"status\":\"received\",\"composite_fulfillment_status\":\"received\",\"payment_status\":\"paid\",\"stock_out_account_id\":1260493,\"receive_account_id\":1260493,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":null,\"fulfillment_line_items\":[{\"id\":476815093,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"order_line_item_id\":509627623,\"product_id\":204359834,\"product_name\":\"Combo Bánh Mini Tròn\",\"variant_id\":333744225,\"variant_name\":\"Combo Bánh Mini Tròn - Combo 2\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":198000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":212256.0000,\"line_tax_amount\":14256.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP487\",\"barcode\":\"SP487\",\"unit\":\"Combo\",\"variant_options\":\"Combo 2 Hộp Tròn Mini\",\"serials\":null},{\"id\":476815094,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"order_line_item_id\":509627624,\"product_id\":246629724,\"product_name\":\"Bánh Mini Hộp Thiếc\",\"variant_id\":445175982,\"variant_name\":\"Bánh Mini Hộp Thiếc - 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\":\"SP355 -Ti\",\"barcode\":\"SP355 -Ti\",\"unit\":\"cái\",\"variant_options\":\"Tiramisu\",\"serials\":null},{\"id\":476815095,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"order_line_item_id\":509627625,\"product_id\":246629724,\"product_name\":\"Bánh Mini Hộp Thiếc\",\"variant_id\":445175988,\"variant_name\":\"Bánh Mini Hộp Thiếc - Bơ\",\"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\":\"SP355 -Bo\",\"barcode\":\"SP355 -Bo\",\"unit\":\"cái\",\"variant_options\":\"Bơ\",\"serials\":null},{\"id\":476815096,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"order_line_item_id\":509627626,\"product_id\":220259467,\"product_name\":\"BÁNH TIRAMISU HỘP THIẾC TRÒN CLASSIC\",\"variant_id\":386962205,\"variant_name\":\"BÁNH TIRAMISU HỘP THIẾC TRÒN CLASSIC\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":225000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":241200.0000,\"line_tax_amount\":16200.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP335\",\"barcode\":\"SP335\",\"unit\":\"Cái\",\"variant_options\":\"Mặc định\",\"serials\":null},{\"id\":476815097,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"order_line_item_id\":509627627,\"product_id\":251127310,\"product_name\":\"2026 Bánh Trung Thu Lava 50gr\",\"variant_id\":452162078,\"variant_name\":\"2026 Bánh Trung Thu Lava 50gr - Trứng Muối\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":120000.0000,\"quantity\":2.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":257280.0000,\"line_tax_amount\":17280.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP363-T\",\"barcode\":\"SP363-T\",\"unit\":\"Cái\",\"variant_options\":\"Trứng Muối\",\"serials\":null},{\"id\":476815098,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"order_line_item_id\":509627628,\"product_id\":251127310,\"product_name\":\"2026 Bánh Trung Thu Lava 50gr\",\"variant_id\":452162082,\"variant_name\":\"2026 Bánh Trung Thu Lava 50gr - Mochi Custard\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":120000.0000,\"quantity\":2.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":257280.0000,\"line_tax_amount\":17280.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP363-Mo\",\"barcode\":\"SP363-Mo\",\"unit\":\"Cái\",\"variant_options\":\"Mochi Custard\",\"serials\":null},{\"id\":476815099,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"order_line_item_id\":509627629,\"product_id\":250039807,\"product_name\":\"Hộp Trung Thu 2026\",\"variant_id\":450463127,\"variant_name\":\"Hộp Trung Thu 2026 - Hộp 4 Bánh\",\"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\":\"SP360-4\",\"barcode\":\"SP360-4\",\"unit\":\"Hộp\",\"variant_options\":\"Hộp 4 Bánh\",\"serials\":null}],\"shipment\":null,\"payments\":[{\"id\":268969478,\"tenant_id\":0,\"location_id\":0,\"account_id\":0,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"order_id\":232029713,\"payment_method_id\":3621316,\"amount\":877716,\"reference\":null,\"paid_on\":\"2026-09-11T15:33:44Z\",\"status\":\"active\",\"currency_id\":0,\"exchange_rate\":null,\"paid_amount\":0,\"returned_amount\":0}],\"total_quantity\":9.000,\"reason_cancel_id\":null}],\"payments\":null,\"prepayments\":[{\"id\":195220745,\"payment_method_id\":3621316,\"paid_on\":\"2026-09-11T15:33:44Z\",\"amount\":877716.0000,\"account_id\":1260493,\"note\":null,\"created_on\":\"2026-09-11T15:33:44Z\",\"modified_on\":\"2026-09-11T15:33:44Z\",\"reference\":null,\"source\":\"customer_paid\",\"source_id\":null,\"paid_amount\":877716.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-09-11T15:33:44Z\",\"finished_on\":null,\"completed_on\":\"2026-09-11T15:33:44Z\",\"channel\":\"POS\",\"cancelled_on\":null,\"promotion_redemptions\":[],\"from_order_return_id\":null}', '{\"connection\":[\"Keep-Alive\"],\"host\":[\"test.noibo.the350f.com\"],\"content-length\":[\"15345\"],\"x-sapo-order-id\":[\"232029713\"],\"x-sapo-object-id\":[\"232029713\"],\"x-sapo-hmac-sha256\":[\"usBQdoWmF4aJLa6GExbb5ylDOnVjSJwF3NxuR117uVc=\"],\"accept-encoding\":[\"gzip;q=1.0,deflate;q=0.6,identity;q=0.3\"],\"x-event-version\":[\"2251116018\"],\"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-topic\":[\"orders\\/update\"],\"accept\":[\"*\\/*\"],\"x-php-ob-level\":[\"1\"]}', 'usBQdoWmF4aJLa6GExbb5ylDOnVjSJwF3NxuR117uVc=', '2026-09-12 01:09:52', 'pending', 0, NULL, NULL);

"COMMIT"

"COMMIT";