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\":207633330,\"tenant_id\":816347,\"location_id\":776355,\"code\":\"SON491154\",\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:24Z\",\"issued_on\":\"2026-07-05T13:39:18Z\",\"ship_on\":null,\"ship_on_min\":null,\"ship_on_max\":null,\"account_id\":1260498,\"assignee_id\":1260498,\"customer_id\":871550019,\"customer_data\":{\"id\":871550019,\"tenant_id\":816347,\"default_location_id\":null,\"created_on\":\"2025-12-21T09:48:25Z\",\"modified_on\":\"2026-02-28T04:07:38Z\",\"code\":\"CUZN248574\",\"name\":\"Thao\",\"dob\":null,\"sex\":\"other\",\"description\":null,\"email\":null,\"fax\":null,\"phone_number\":\"0903732287\",\"tax_number\":null,\"website\":null,\"customer_group_id\":3122518,\"group_name\":\"Bán lẻ\",\"assignee_id\":1269024,\"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\":817939731,\"created_on\":\"2025-12-21T09:48:25Z\",\"modified_on\":\"2026-02-28T04:07:38Z\",\"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\":\"0903732287\",\"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\":-891000.0000,\"apply_incentives\":\"group\",\"total_expense\":null,\"loyalty_customer\":null,\"sale_order\":{\"total_sales\":5719940.28,\"order_purchases\":7.00,\"returned_item_quantity\":0.00,\"net_quantity\":38.00,\"last_order_on\":\"2026-05-10T14:39:57Z\"},\"social_customers\":[]},\"contact_id\":null,\"billing_address\":{\"id\":409758790,\"label\":\"07-09 Hoa Phượng\",\"first_name\":\"\",\"full_name\":\"\",\"last_name\":\"\",\"address1\":\"07-09 Hoa Phượng\",\"address2\":\"07-09 Hoa Phượng\",\"email\":\"\",\"phone_number\":\"0908171555\",\"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\":409758791,\"label\":null,\"first_name\":null,\"full_name\":\"Thao\",\"last_name\":null,\"address1\":\"5\",\"address2\":null,\"email\":null,\"phone_number\":\"0903732287\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"zip_code\":null},\"email\":null,\"phone_number\":\"0903732287\",\"reference_number\":null,\"currency_id\":0,\"price_list_id\":2349366,\"tax_treatment\":\"inclusive\",\"status\":\"finalized\",\"fulfillment_status\":\"unshipped\",\"packed_status\":\"packed\",\"payment_status\":\"paid\",\"return_status\":\"unreturned\",\"received_status\":\"unreceived\",\"source_url\":null,\"source_id\":8724174,\"tax_label\":null,\"total\":891000,\"order_discount_rate\":0.00,\"order_discount_value\":0.0000,\"discount_reason\":null,\"total_discount\":0,\"total_tax\":66000,\"note\":\"SP-6163\",\"tags\":[],\"delivery_fee\":null,\"order_discount_amount\":0,\"discount_items\":[],\"order_line_items\":[{\"id\":454831556,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"variant_id\":333744077,\"product_id\":204359797,\"product_name\":\"Bánh Chocolate Dream Cake Hộp Thiếc\",\"variant_name\":\"Bánh Chocolate Dream Cake Hộp Thiếc\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":22444.4800000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":280556,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":303000.4800000000,\"discount_items\":[],\"sku\":\"SP268\",\"barcode\":\"SP268\",\"unit\":\"cái\",\"variant_options\":\"Mặc định\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":454831557,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"variant_id\":333744074,\"product_id\":204359794,\"product_name\":\"Bánh Pistachio Chocolate Hộp Thiếc (Dubai)\",\"variant_name\":\"Bánh Pistachio Chocolate Hộp Thiếc (Dubai)\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":27407.4400000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":342593,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":370000.4400000000,\"discount_items\":[],\"sku\":\"SP271\",\"barcode\":\"SP271\",\"unit\":\"cái\",\"variant_options\":\"Mặc định\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":454831558,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"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\":16148.0800000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":201851,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":217999.0800000000,\"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\":454831559,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"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\":454831560,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"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\":[]}],\"fulfillments\":[{\"id\":190675704,\"tenant_id\":816347,\"stock_location_id\":776355,\"code\":\"FUN574563\",\"order_id\":207633330,\"account_id\":1260498,\"assignee_id\":1260498,\"partner_id\":871550019,\"billing_address\":{\"id\":409758792,\"label\":\"07-09 Hoa Phượng\",\"first_name\":\"\",\"full_name\":\"\",\"last_name\":\"\",\"address1\":\"07-09 Hoa Phượng\",\"address2\":\"07-09 Hoa Phượng\",\"email\":\"\",\"phone_number\":\"0908171555\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"zip_code\":null},\"delivery_type\":\"courier\",\"tax_treatment\":\"inclusive\",\"discount_rate\":0.000,\"discount_value\":0.0000,\"discount_amount\":0.0000,\"total\":891000.0000,\"total_tax\":66000.0000,\"total_discount\":0.0000,\"notes\":\"SP-6163\",\"packed_on\":\"2026-07-05T13:39:18Z\",\"received_on\":null,\"shipped_on\":null,\"cancel_date\":null,\"cancel_account_id\":null,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"status\":\"packed\",\"composite_fulfillment_status\":\"packed\",\"payment_status\":\"unpaid\",\"stock_out_account_id\":null,\"receive_account_id\":null,\"receive_cancellation_account_id\":null,\"receive_cancellation_on\":null,\"fulfillment_line_items\":[{\"id\":425274145,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"order_line_item_id\":454831556,\"product_id\":204359797,\"product_name\":\"Bánh Chocolate Dream Cake Hộp Thiếc\",\"variant_id\":333744077,\"variant_name\":\"Bánh Chocolate Dream Cake Hộp Thiếc\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":280556.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":303000.4800,\"line_tax_amount\":22444.4800,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP268\",\"barcode\":\"SP268\",\"unit\":\"cái\",\"variant_options\":\"Mặc định\",\"serials\":null},{\"id\":425274146,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"order_line_item_id\":454831557,\"product_id\":204359794,\"product_name\":\"Bánh Pistachio Chocolate Hộp Thiếc (Dubai)\",\"variant_id\":333744074,\"variant_name\":\"Bánh Pistachio Chocolate Hộp Thiếc (Dubai)\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":342593.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":370000.4400,\"line_tax_amount\":27407.4400,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP271\",\"barcode\":\"SP271\",\"unit\":\"cái\",\"variant_options\":\"Mặc định\",\"serials\":null},{\"id\":425274147,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"order_line_item_id\":454831558,\"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\":201851.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":217999.0800,\"line_tax_amount\":16148.0800,\"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\":425274148,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"order_line_item_id\":454831559,\"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\":425274149,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"order_line_item_id\":454831560,\"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}],\"shipment\":{\"id\":85241407,\"delivery_service_provider_id\":512596,\"service_name\":null,\"cod_amount\":0.0000,\"freight_amount\":0.0000,\"freight_amount_detail\":null,\"delivery_fee\":0.0000,\"tracking_code\":\"FUN574563\",\"tracking_url\":null,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"sender_address\":null,\"shipping_address\":{\"id\":409758793,\"label\":null,\"first_name\":\"Thao\",\"full_name\":\"Thao\",\"last_name\":null,\"address1\":\"5\",\"address2\":null,\"email\":null,\"phone_number\":\"0903732287\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 2\",\"zip_code\":null},\"shipper_deposits\":[],\"detail\":\"{\\\"receiver_name\\\":\\\"Thao\\\",\\\"receiver_phone\\\":\\\"0903732287\\\",\\\"cod_amount\\\":0,\\\"destination_address\\\":\\\"5\\\",\\\"delivery_fee\\\":0,\\\"delivery_service_provider_id\\\":512596,\\\"destination_province_id\\\":2,\\\"destination_district_id\\\":46,\\\"note\\\":\\\"Cho xem hàng, không cho thử |SP-6163\\\",\\\"source_location_id\\\":776355,\\\"destination_country\\\":\\\"Việt Nam\\\",\\\"destination_district\\\":\\\"Quận Phú Nhuận\\\",\\\"destination_province\\\":\\\"TP Hồ Chí Minh\\\",\\\"destination_ward\\\":\\\"Phường 2\\\",\\\"weight\\\":100,\\\"destination_country_id\\\":201}\",\"note\":\"Cho xem hàng, không cho thử |SP-6163\",\"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\":5.000,\"reason_cancel_id\":null}],\"payments\":null,\"prepayments\":[{\"id\":174531370,\"payment_method_id\":3621317,\"paid_on\":\"2026-07-05T13:39:18Z\",\"amount\":891000.0000,\"account_id\":1260498,\"note\":null,\"created_on\":\"2026-07-05T13:39:18Z\",\"modified_on\":\"2026-07-05T13:39:18Z\",\"reference\":null,\"source\":\"customer_prepaid\",\"source_id\":null,\"paid_amount\":891000.000,\"returned_amount\":0.000,\"status\":\"active\",\"integrated\":false,\"status_before_cancelled\":null}],\"order_returns\":[],\"expected_payment_method_id\":null,\"expected_delivery_type\":\"courier\",\"expected_delivery_provider_id\":512596,\"process_status_id\":null,\"process_status\":null,\"reason_cancel_id\":null,\"finalized_on\":\"2026-07-05T13:39:18Z\",\"finished_on\":null,\"completed_on\":null,\"channel\":\"POS\",\"cancelled_on\":null,\"promotion_redemptions\":[],\"from_order_return_id\":null}', '{\"connection\":[\"Keep-Alive\"],\"host\":[\"test.noibo.the350f.com\"],\"content-length\":[\"13586\"],\"x-event-version\":[\"1972351954\"],\"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\"],\"content-type\":[\"application\\/json; charset=utf-8\"],\"x-sapo-order-id\":[\"207633330\"],\"x-sapo-object-id\":[\"207633330\"],\"x-sapo-tenant-domain\":[\"the350f-ch.mysapogo.com\"],\"x-sapo-hmac-sha256\":[\"b7P\\/99P2VLs7Sg+JbiC0Fj9hCYV1N2pBkedLgUra2N0=\"],\"x-sapo-topic\":[\"orders\\/update\"],\"accept\":[\"*\\/*\"],\"x-php-ob-level\":[\"1\"]}', 'b7P/99P2VLs7Sg+JbiC0Fj9hCYV1N2pBkedLgUra2N0=', '2026-07-05 13:53:42', 'pending', 0, NULL, NULL);

"START TRANSACTION"

"START TRANSACTION";