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', 'the-350f.mysapogo.com', '{\"id\":1776700038,\"tenant_id\":737184,\"location_id\":711291,\"code\":\"SON687333\",\"created_on\":\"2025-12-06T07:31:44Z\",\"modified_on\":\"2025-12-06T10:29:03Z\",\"issued_on\":\"2025-12-06T07:31:44Z\",\"ship_on\":null,\"ship_on_min\":\"2025-12-06T12:00:00Z\",\"ship_on_max\":\"2025-12-06T13:00:00Z\",\"account_id\":1049376,\"assignee_id\":1049376,\"customer_id\":319715894,\"customer_data\":{\"id\":319715894,\"tenant_id\":737184,\"default_location_id\":null,\"created_on\":\"2023-09-29T07:03:47Z\",\"modified_on\":\"2023-09-29T07:03:47Z\",\"code\":\"CO00149151\",\"name\":\"zalo Dương Huỳnh 0902437452\",\"dob\":null,\"sex\":\"other\",\"description\":\"\",\"email\":\"\",\"fax\":\"\",\"phone_number\":\"0902437452\",\"tax_number\":\"\",\"website\":\"\",\"customer_group_id\":2854104,\"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\":286997955,\"created_on\":\"2023-09-29T07:03:47Z\",\"modified_on\":\"2023-12-04T13:24:47Z\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 11\",\"address1\":\"102/23A Hồ Biểu Chánh\",\"address2\":null,\"zip_code\":\"\",\"email\":null,\"first_name\":null,\"last_name\":null,\"full_name\":\"web Huỳnh Thị Thùy Dương\",\"label\":\"chung cư Petroland số 2 đường 62, P. Bình Trưng Đông, Quận 2\",\"phone_number\":\"0902437452\",\"status\":\"active\"},{\"id\":805024256,\"created_on\":\"2025-12-06T07:28:38Z\",\"modified_on\":\"2025-12-06T07:28:38Z\",\"country\":\"Việt Nam\",\"city\":\"Hồ Chí Minh\",\"district\":\"Phường Phú Nhuận\",\"ward\":\"Phường Phú Nhuận\",\"address1\":\"102/23a Đường Hồ Biểu Chánh\",\"address2\":null,\"zip_code\":\"\",\"email\":\"\",\"first_name\":null,\"last_name\":null,\"full_name\":\"0902437452\",\"label\":null,\"phone_number\":\"0902437452\",\"status\":\"active\"}],\"contacts\":[],\"notes\":[{\"id\":1429637,\"tenant_id\":0,\"created_on\":\"2023-09-29T07:03:47Z\",\"modified_on\":\"2023-09-29T07:03:47Z\",\"account_id\":0,\"content\":\"902437452\",\"status\":\"active\"}],\"customer_group\":{\"id\":2854104,\"tenant_id\":737184,\"created_on\":\"2023-09-28T04:31:23Z\",\"modified_on\":\"2023-09-28T04:31:23Z\",\"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\":-540000.0000,\"apply_incentives\":\"group\",\"total_expense\":2508000.0000,\"loyalty_customer\":null,\"sale_order\":{\"total_sales\":3534000.00,\"order_purchases\":2.00,\"returned_item_quantity\":0.00,\"net_quantity\":13.00,\"last_order_on\":\"2024-12-06T10:38:31Z\"},\"social_customers\":[]},\"contact_id\":null,\"billing_address\":{\"id\":274494210,\"label\":\"chung cư Petroland số 2 đường 62, P. Bình Trưng Đông, Quận 2\",\"first_name\":\"\",\"full_name\":\"web Huỳnh Thị Thùy Dương\",\"last_name\":\"\",\"address1\":\"102/23A Hồ Biểu Chánh\",\"address2\":\"102/23A Hồ Biểu Chánh\",\"email\":\"\",\"phone_number\":\"0902437452\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 11\",\"zip_code\":null},\"shipping_address\":{\"id\":274494211,\"label\":null,\"first_name\":null,\"full_name\":\"0902437452\",\"last_name\":null,\"address1\":\"102/23a Đường Hồ Biểu Chánh\",\"address2\":null,\"email\":\"\",\"phone_number\":\"0902437452\",\"country\":\"Việt Nam\",\"city\":\"Hồ Chí Minh\",\"district\":\"Phường Phú Nhuận\",\"ward\":\"Phường Phú Nhuận\",\"zip_code\":\"\"},\"email\":\"\",\"phone_number\":\"0902437452\",\"reference_number\":\"\",\"currency_id\":0,\"price_list_id\":2150068,\"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\":7942636,\"tax_label\":null,\"total\":540000,\"order_discount_rate\":0.00,\"order_discount_value\":0.0000,\"discount_reason\":null,\"total_discount\":0,\"total_tax\":40000,\"note\":\"[P20]\\n\\nđã ck oa\\n\\ntag: Happy Birthday Mon 06-12\",\"tags\":[],\"delivery_fee\":null,\"order_discount_amount\":0,\"discount_items\":[],\"order_line_items\":[{\"id\":422488232,\"created_on\":\"2025-12-06T07:31:44Z\",\"modified_on\":\"2025-12-06T07:38:40Z\",\"variant_id\":393671085,\"product_id\":151794696,\"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\":422488233,\"created_on\":\"2025-12-06T07:31:44Z\",\"modified_on\":\"2025-12-06T07:38:40Z\",\"variant_id\":244426070,\"product_id\":151799164,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"Hộp Tròn Mini - Dâu\",\"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\":\"SP523\",\"barcode\":\"SP523\",\"unit\":null,\"variant_options\":\"Dâu\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":422488234,\"created_on\":\"2025-12-06T07:31:44Z\",\"modified_on\":\"2025-12-06T07:38:40Z\",\"variant_id\":244426072,\"product_id\":151799164,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"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\":null,\"variant_options\":\"Tiramisu\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":422488235,\"created_on\":\"2025-12-06T07:31:44Z\",\"modified_on\":\"2025-12-06T07:38:40Z\",\"variant_id\":244426075,\"product_id\":151799164,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"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\":null,\"variant_options\":\"Nhãn\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]},{\"id\":422488236,\"created_on\":\"2025-12-06T07:31:44Z\",\"modified_on\":\"2025-12-06T07:38:40Z\",\"variant_id\":244426074,\"product_id\":151799164,\"product_name\":\"Hộp Tròn Mini\",\"variant_name\":\"Hộp Tròn Mini - Việt Quất\",\"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\":\"SP530\",\"barcode\":\"SP530\",\"unit\":null,\"variant_options\":\"Việt Quất\",\"serials\":null,\"product_type\":\"normal\",\"lots_dates\":[]}],\"fulfillments\":[{\"id\":-2053897405,\"tenant_id\":737184,\"stock_location_id\":711291,\"code\":\"FUN924652\",\"order_id\":1776700038,\"account_id\":1049402,\"assignee_id\":1049402,\"partner_id\":319715894,\"billing_address\":{\"id\":274692387,\"label\":\"chung cư Petroland số 2 đường 62, P. Bình Trưng Đông, Quận 2\",\"first_name\":\"\",\"full_name\":\"web Huỳnh Thị Thùy Dương\",\"last_name\":\"\",\"address1\":\"102/23A Hồ Biểu Chánh\",\"address2\":\"102/23A Hồ Biểu Chánh\",\"email\":\"\",\"phone_number\":\"0902437452\",\"country\":\"Việt Nam\",\"city\":\"TP Hồ Chí Minh\",\"district\":\"Quận Phú Nhuận\",\"ward\":\"Phường 11\",\"zip_code\":null},\"delivery_type\":\"courier\",\"tax_treatment\":\"inclusive\",\"discount_rate\":0.000,\"discount_value\":0.0000,\"discount_amount\":0.0000,\"total\":540000.0000,\"total_tax\":40000.0000,\"total_discount\":0.0000,\"notes\":\"[P20]\\n\\nđã ck oa\\n\\ntag: Happy Birthday Mon 06-12\",\"packed_on\":\"2025-12-06T10:28:40Z\",\"received_on\":null,\"shipped_on\":null,\"cancel_date\":null,\"cancel_account_id\":null,\"created_on\":\"2025-12-06T10:28:40Z\",\"modified_on\":\"2025-12-06T10:28:40Z\",\"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\":-1618959485,\"created_on\":\"2025-12-06T10:28:40Z\",\"modified_on\":\"2025-12-06T10:28:40Z\",\"order_line_item_id\":422488232,\"product_id\":151794696,\"product_name\":\"Gift Set\",\"variant_id\":393671085,\"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\":-1618959484,\"created_on\":\"2025-12-06T10:28:40Z\",\"modified_on\":\"2025-12-06T10:28:40Z\",\"order_line_item_id\":422488233,\"product_id\":151799164,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":244426070,\"variant_name\":\"Hộp Tròn Mini - Dâu\",\"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\":\"SP523\",\"barcode\":\"SP523\",\"unit\":null,\"variant_options\":\"Dâu\",\"serials\":null},{\"id\":-1618959483,\"created_on\":\"2025-12-06T10:28:40Z\",\"modified_on\":\"2025-12-06T10:28:40Z\",\"order_line_item_id\":422488234,\"product_id\":151799164,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":244426072,\"variant_name\":\"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\":null,\"variant_options\":\"Tiramisu\",\"serials\":null},{\"id\":-1618959482,\"created_on\":\"2025-12-06T10:28:40Z\",\"modified_on\":\"2025-12-06T10:28:40Z\",\"order_line_item_id\":422488235,\"product_id\":151799164,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":244426075,\"variant_name\":\"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\":null,\"variant_options\":\"Nhãn\",\"serials\":null},{\"id\":-1618959481,\"created_on\":\"2025-12-06T10:28:40Z\",\"modified_on\":\"2025-12-06T10:28:40Z\",\"order_line_item_id\":422488236,\"product_id\":151799164,\"product_name\":\"Hộp Tròn Mini\",\"variant_id\":244426074,\"variant_name\":\"Hộp Tròn Mini - Việt Quất\",\"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\":\"SP530\",\"barcode\":\"SP530\",\"unit\":null,\"variant_options\":\"Việt Quất\",\"serials\":null}],\"shipment\":{\"id\":1369217811,\"delivery_service_provider_id\":400066,\"service_name\":null,\"cod_amount\":0.0000,\"freight_amount\":0.0000,\"freight_amount_detail\":null,\"delivery_fee\":0.0000,\"tracking_code\":\"FUN924652\",\"tracking_url\":null,\"created_on\":\"2025-12-06T10:28:40Z\",\"modified_on\":\"2025-12-06T10:28:40Z\",\"sender_address\":null,\"shipping_address\":{\"id\":274692388,\"label\":null,\"first_name\":\"0902437452\",\"full_name\":\"0902437452\",\"last_name\":null,\"address1\":\"102/23a Đường Hồ Biểu Chánh\",\"address2\":null,\"email\":null,\"phone_number\":\"0902437452\",\"country\":\"Việt Nam\",\"city\":\"Hồ Chí Minh\",\"district\":\"Phường Phú Nhuận\",\"ward\":\"Phường Phú Nhuận\",\"zip_code\":null},\"shipper_deposits\":[],\"detail\":\"{\\\"delivery_service_provider_id\\\":400066,\\\"receiver_name\\\":\\\"0902437452\\\",\\\"receiver_phone\\\":\\\"0902437452\\\",\\\"cod_amount\\\":0,\\\"destination_address\\\":\\\"102/23a Đường Hồ Biểu Chánh\\\",\\\"destination_province_id\\\":0,\\\"destination_district_id\\\":0,\\\"delivery_fee\\\":0,\\\"destination_country_id\\\":201,\\\"source_location_id\\\":711291,\\\"note\\\":\\\"Cho xem hàng, không cho thử |[P20]\\\\n\\\\nđã ck oa\\\\n\\\\ntag: Happy Birthday Mon 06-12\\\",\\\"destination_country\\\":\\\"Việt Nam\\\",\\\"destination_district\\\":\\\"Phường Phú Nhuận\\\",\\\"destination_province\\\":\\\"Hồ Chí Minh\\\",\\\"weight\\\":100,\\\"destination_ward\\\":\\\"Phường Phú Nhuận\\\"}\",\"note\":\"Cho xem hàng, không cho thử |[P20]\\n\\nđã ck oa\\n\\ntag: Happy Birthday Mon 06-12\",\"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\":7.000,\"reason_cancel_id\":null}],\"payments\":null,\"prepayments\":[{\"id\":1650642613,\"payment_method_id\":3283672,\"paid_on\":\"2025-12-06T07:38:38Z\",\"amount\":540000.0000,\"account_id\":1205891,\"note\":null,\"created_on\":\"2025-12-06T07:38:43Z\",\"modified_on\":\"2025-12-06T07:38:43Z\",\"reference\":null,\"source\":\"customer_prepaid\",\"source_id\":null,\"paid_amount\":540000.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\":16243,\"process_status\":null,\"reason_cancel_id\":null,\"finalized_on\":\"2025-12-06T07:31:46Z\",\"finished_on\":null,\"completed_on\":null,\"channel\":null,\"cancelled_on\":null,\"promotion_redemptions\":[],\"from_order_return_id\":null}', '{\"connection\":[\"Keep-Alive\"],\"host\":[\"test.noibo.the350f.com\"],\"content-length\":[\"14443\"],\"accept-encoding\":[\"gzip;q=1.0,deflate;q=0.6,identity;q=0.3\"],\"x-sapo-hmac-sha256\":[\"purMvv9NOEgCkS6LMxiWIg6rewaIgx3\\/haK82Ey6pZA=\"],\"x-sapo-test\":[\"false\"],\"user-agent\":[\"JVM\"],\"x-sapo-webhook-address\":[\"https:\\/\\/test.noibo.the350f.com\\/api\\/sapo-webhook\\/receive\"],\"x-sapo-tenant-domain\":[\"the-350f.mysapogo.com\"],\"content-type\":[\"application\\/json; charset=utf-8\"],\"x-sapo-order-id\":[\"1776700038\"],\"x-sapo-object-id\":[\"1776700038\"],\"x-sapo-topic\":[\"orders\\/update\"],\"x-event-version\":[\"5629589527\"],\"accept\":[\"*\\/*\"],\"x-php-ob-level\":[\"1\"]}', 'purMvv9NOEgCkS6LMxiWIg6rewaIgx3/haK82Ey6pZA=', '2025-12-06 10:29:08', 'pending', 0, NULL, NULL);

"COMMIT"

"COMMIT";