ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a58940e7cd8d: POST https://beta.jinchangxiao.com/vue/sales-contract/match-products at 2026-07-16 04:19:26 pm by 114.244.130.25

Database Queries

总计12条数据
TimeDurationTypeQuery
  
16:19:26.5151.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5461

[+] Explain
16:19:26.5170.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:19:26.5190.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:19:26.5220.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486

[+] Explain
16:19:26.5260.7 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174)

[+] Explain
16:19:26.5271.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "name" IN ('深信服计算服务器虚拟化软件', '深信服虚拟存储软件', '深信服智能管家', '深信服企业级数据备份与恢复系统软件', '深信服超融合&备份实施服务')

[+] Explain
16:19:26.5290.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7

[+] Explain
16:19:26.5290.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=139

[+] Explain
16:19:26.5300.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=12

[+] Explain
16:19:26.5300.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1283

[+] Explain
16:19:26.5310.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2

[+] Explain
16:19:26.5322.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-contract/match-products', '{"id":"4486","products":[{"name":"\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6","number":"10","amount":"10450","total_amount":"104500","description":"V6.0Base\u7248","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""},{"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5b58\u50a8\u8f6f\u4ef6","number":"10","amount":"15585","total_amount":"155850","description":"V3.0Base\u7248\u672c","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""},{"name":"\u6df1\u4fe1\u670d\u667a\u80fd\u7ba1\u5bb6","number":"10","amount":"3000","total_amount":"30000","description":"V1.0\uff081\u5e74\uff09","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""},{"name":"\u6df1\u4fe1\u670d\u4f01\u4e1a\u7ea7\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6","number":"1","amount":"15000","total_amount":"15000","description":"V3.0\u6807\u51c6\u7248","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""},{"name":"\u6df1\u4fe1\u670d\u8d85\u878d\u5408&\u5907\u4efd\u5b9e\u65bd\u670d\u52a1","number":"1","amount":"89000","total_amount":"89000","description":"\u5b9e\u65bd\u670d\u52a1","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""}],"web_access_token":"--xxX6Gmp9PXF1XHWWwlXiYIP9-yVx7F"}', '{"code":2000,"result":{"list":[{"index":0,"name":"\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6","recognized_name":"\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6","number":"10","amount":"10450","total_amount":"104500","description":"V6.0Base\u7248","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":"","matched":false,"match_status":"pending","match_status_display":"\u5f85\u786e\u8ba4","match_reason":"\u4ea7\u54c1\u540d\u79f0\u672a\u7cbe\u786e\u5339\u914d","product_id":"","product":""},{"index":1,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5b58\u50a8\u8f6f\u4ef6","recognized_name":"\u6df1\u4fe1\u670d\u865a\u62df\u5b58\u50a8\u8f6f\u4ef6","number":"10","amount":"15585","total_amount":"155850","description":"V3.0Base\u7248\u672c","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":"","matched":true,"match_status":"matched","match_status_display":"\u5df2\u5339\u914d","match_reason":"","product_id":1022,"product":{"id":1022,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5b58\u50a8\u8f6f\u4ef6","product_type":7,"product_component":139,"product_brand":12,"product_serie":1283,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-05 10:12:51","updated_at":"2024-03-11 14:34:44","pinyin_shortcut":"sxfxnccrj","product_unit":2,"is_renew":false,"in_out_at":"","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":139,"key":139,"name":"\u8d85\u878d\u5408\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1283,"key":1283,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5b58\u50a8\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"index":2,"name":"\u6df1\u4fe1\u670d\u667a\u80fd\u7ba1\u5bb6","recognized_name":"\u6df1\u4fe1\u670d\u667a\u80fd\u7ba1\u5bb6","number":"10","amount":"3000","total_amount":"30000","description":"V1.0\uff081\u5e74\uff09","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":"","matched":false,"match_status":"pending","match_status_display":"\u5f85\u786e\u8ba4","match_reason":"\u4ea7\u54c1\u540d\u79f0\u672a\u7cbe\u786e\u5339\u914d","product_id":"","product":""},{"index":3,"name":"\u6df1\u4fe1\u670d\u4f01\u4e1a\u7ea7\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6","recognized_name":"\u6df1\u4fe1\u670d\u4f01\u4e1a\u7ea7\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6","number":"1","amount":"15000","total_amount":"15000","description":"V3.0\u6807\u51c6\u7248","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":"","matched":false,"match_status":"pending","match_status_display":"\u5f85\u786e\u8ba4","match_reason":"\u4ea7\u54c1\u540d\u79f0\u672a\u7cbe\u786e\u5339\u914d","product_id":"","product":""},{"index":4,"name":"\u6df1\u4fe1\u670d\u8d85\u878d\u5408&\u5907\u4efd\u5b9e\u65bd\u670d\u52a1","recognized_name":"\u6df1\u4fe1\u670d\u8d85\u878d\u5408&\u5907\u4efd\u5b9e\u65bd\u670d\u52a1","number":"1","amount":"89000","total_amount":"89000","description":"\u5b9e\u65bd\u670d\u52a1","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":"","matched":false,"match_status":"pending","match_status_display":"\u5f85\u786e\u8ba4","match_reason":"\u4ea7\u54c1\u540d\u79f0\u672a\u7cbe\u786e\u5339\u914d","product_id":"","product":""}],"count":{"total":5,"matched":1,"pending":4}},"status":1,"msg":[{"name":"success","success":"\u4ea7\u54c1\u5339\u914d\u5b8c\u6210","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/150.0.0.0 Safari\/537.36"}', FALSE, '2026-07-16 16:19:26', 20139776) RETURNING "id"

[+] Explain