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\":195917965,\"tenant_id\":816347,\"location_id\":776355,\"code\":\"SON472288\",\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:49Z\",\"issued_on\":\"2026-06-01T04:56:48Z\",\"ship_on\":null,\"ship_on_min\":null,\"ship_on_max\":null,\"account_id\":1260498,\"assignee_id\":1260498,\"customer_id\":670607027,\"customer_data\":{\"id\":670607027,\"tenant_id\":816347,\"default_location_id\":null,\"created_on\":\"2025-03-31T08:45:39Z\",\"modified_on\":\"2025-03-31T08:45:39Z\",\"code\":\"KH114365\",\"name\":\"Web Nguyễn Kiều Anh Thy\",\"dob\":null,\"sex\":\"other\",\"description\":\"\",\"email\":\"\",\"fax\":\"\",\"phone_number\":\"0981314407\",\"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\":623352118,\"created_on\":\"2025-03-31T08:45:39Z\",\"modified_on\":\"2025-03-31T08:45:39Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Bình Thạnh\",\"ward\":\"Phường 22\",\"address1\":\"Landmark plus\",\"address2\":null,\"zip_code\":null,\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":null,\"label\":\"Landmark plus\",\"phone_number\":\"0981314407\",\"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\":580000.0000,\"loyalty_customer\":null,\"sale_order\":{\"total_sales\":580000.00,\"order_purchases\":0.00,\"returned_item_quantity\":0.00,\"net_quantity\":0.00,\"last_order_on\":null},\"social_customers\":[]},\"contact_id\":null,\"billing_address\":{\"id\":388858662,\"label\":\"Landmark plus\",\"first_name\":null,\"full_name\":null,\"last_name\":null,\"address1\":\"Landmark plus\",\"address2\":null,\"email\":\"\",\"phone_number\":\"0981314407\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Bình Thạnh\",\"ward\":\"Phường 22\",\"zip_code\":null},\"shipping_address\":{\"id\":388858663,\"label\":\"Landmark plus\",\"first_name\":null,\"full_name\":null,\"last_name\":null,\"address1\":\"Landmark plus\",\"address2\":null,\"email\":\"\",\"phone_number\":\"0981314407\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Bình Thạnh\",\"ward\":\"Phường 22\",\"zip_code\":null},\"email\":\"\",\"phone_number\":\"0981314407\",\"reference_number\":null,\"currency_id\":0,\"price_list_id\":2349366,\"tax_treatment\":\"inclusive\",\"status\":\"finalized\",\"fulfillment_status\":\"unshipped\",\"packed_status\":\"packed\",\"payment_status\":\"unpaid\",\"return_status\":\"unreturned\",\"received_status\":\"unreceived\",\"source_url\":null,\"source_id\":8722575,\"tax_label\":null,\"total\":604800,\"order_discount_rate\":0.00,\"order_discount_value\":0.0000,\"discount_reason\":null,\"total_discount\":0,\"total_tax\":44800,\"note\":\"43 hồng hà\",\"tags\":[],\"delivery_fee\":null,\"order_discount_amount\":0,\"discount_items\":[],\"order_line_items\":[{\"id\":428719698,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"variant_id\":393671274,\"product_id\":204359859,\"product_name\":\"Gift Set\",\"variant_name\":\"Gift Set 6 MIX VỊ\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":40000.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":500000,\"quantity\":1.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":540000.0000000000,\"discount_items\":[],\"sku\":\"SP549M\",\"barcode\":\"SP549M\",\"unit\":\"Hộp\",\"variant_options\":\"Gift Set 6 MIX VỊ\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":428719699,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"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\":428719700,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"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\":2.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\":428719701,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"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\":428719702,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"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\":428719703,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"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\":428719704,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"variant_id\":333744054,\"product_id\":204359785,\"product_name\":\"Phụ kiện giữ nhiệt\",\"variant_name\":\"Phụ kiện giữ nhiệt\",\"tax_type_id\":null,\"tax_included\":false,\"tax_rate_override\":8.000,\"tax_rate\":8.000,\"tax_amount\":4800.0000000000,\"discount_rate\":0.00,\"discount_value\":0.0000,\"discount_reason\":null,\"discount_amount\":0E-10,\"note\":\"\",\"price\":30000,\"quantity\":2.000,\"is_freeform\":false,\"is_composite\":false,\"line_amount\":64800.0000000000,\"discount_items\":[],\"sku\":\"SP293\",\"barcode\":\"SP293\",\"unit\":\"Bộ\",\"variant_options\":\"Mặc định\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]}],\"fulfillments\":[{\"id\":179562921,\"tenant_id\":816347,\"stock_location_id\":776355,\"code\":\"FUN555696\",\"order_id\":195917965,\"account_id\":1260498,\"assignee_id\":1260498,\"partner_id\":670607027,\"billing_address\":{\"id\":388858664,\"label\":\"Landmark plus\",\"first_name\":null,\"full_name\":null,\"last_name\":null,\"address1\":\"Landmark plus\",\"address2\":null,\"email\":\"\",\"phone_number\":\"0981314407\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Bình Thạnh\",\"ward\":\"Phường 22\",\"zip_code\":null},\"delivery_type\":\"pickup\",\"tax_treatment\":\"inclusive\",\"discount_rate\":0.000,\"discount_value\":0.0000,\"discount_amount\":0.0000,\"total\":604800.0000,\"total_tax\":44800.0000,\"total_discount\":0.0000,\"notes\":null,\"packed_on\":\"2026-06-01T04:56:48Z\",\"received_on\":null,\"shipped_on\":null,\"cancel_date\":null,\"cancel_account_id\":null,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"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\":400265160,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"order_line_item_id\":428719698,\"product_id\":204359859,\"product_name\":\"Gift Set\",\"variant_id\":393671274,\"variant_name\":\"Gift Set 6 MIX VỊ\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":500000.0000,\"quantity\":1.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":540000.0000,\"line_tax_amount\":40000.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP549M\",\"barcode\":\"SP549M\",\"unit\":\"Hộp\",\"variant_options\":\"Gift Set 6 MIX VỊ\",\"serials\":null},{\"id\":400265161,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"order_line_item_id\":428719699,\"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\":400265162,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"order_line_item_id\":428719700,\"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\":2.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\":400265163,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"order_line_item_id\":428719701,\"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\":400265164,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"order_line_item_id\":428719702,\"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\":400265165,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"order_line_item_id\":428719703,\"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\":400265166,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"order_line_item_id\":428719704,\"product_id\":204359785,\"product_name\":\"Phụ kiện giữ nhiệt\",\"variant_id\":333744054,\"variant_name\":\"Phụ kiện giữ nhiệt\",\"order_line_item_note\":\"\",\"is_freeform\":false,\"is_composite\":false,\"is_packsize\":false,\"base_price\":30000.0000,\"quantity\":2.000,\"tax_type_id\":null,\"tax_rate_override\":8,\"tax_rate\":8.00,\"line_amount\":64800.0000,\"line_tax_amount\":4800.0000,\"line_discount_amount\":0.0000,\"discount_value\":0.0000,\"discount_rate\":0.000,\"sku\":\"SP293\",\"barcode\":\"SP293\",\"unit\":\"Bộ\",\"variant_options\":\"Mặc định\",\"serials\":null}],\"shipment\":null,\"payments\":[],\"total_quantity\":9.000,\"reason_cancel_id\":null}],\"payments\":null,\"prepayments\":[{\"id\":164269201,\"payment_method_id\":3621885,\"paid_on\":\"2026-06-01T04:56:48Z\",\"amount\":604800.0000,\"account_id\":1260498,\"note\":null,\"created_on\":\"2026-06-01T04:56:48Z\",\"modified_on\":\"2026-06-01T04:56:48Z\",\"reference\":null,\"source\":\"customer_paid\",\"source_id\":null,\"paid_amount\":604800.000,\"returned_amount\":0.000,\"status\":\"waiting\",\"integrated\":true,\"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-06-01T04:56:48Z\",\"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\":[\"14573\"],\"accept-encoding\":[\"gzip;q=1.0,deflate;q=0.6,identity;q=0.3\"],\"x-sapo-order-id\":[\"195917965\"],\"x-sapo-object-id\":[\"195917965\"],\"x-sapo-test\":[\"false\"],\"user-agent\":[\"JVM\"],\"x-event-version\":[\"1832935197\"],\"x-sapo-webhook-address\":[\"https:\\/\\/test.noibo.the350f.com\\/api\\/sapo-webhook\\/receive\"],\"content-type\":[\"application\\/json; charset=utf-8\"],\"x-sapo-hmac-sha256\":[\"TfeI56+y0y3gcI6tjlrwD6vZKYqzebWTqN0t9\\/Vm1+8=\"],\"x-sapo-tenant-domain\":[\"the350f-ch.mysapogo.com\"],\"x-sapo-topic\":[\"orders\\/update\"],\"accept\":[\"*\\/*\"],\"x-php-ob-level\":[\"1\"]}', 'TfeI56+y0y3gcI6tjlrwD6vZKYqzebWTqN0t9/Vm1+8=', '2026-06-01 04:56:51', 'pending', 0, NULL, NULL);

"COMMIT"

"COMMIT";