Performance Profiling

Total processing time: 39 ms; Peak memory: 5.123 MB. Show Profiling Timeline

总计13条数据

Time	Duration	Category	Info

18:31:55.456	5.3 ms	yii\db\Command::query	INSERT 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":"4505","products":[{"name":"\u6d6a\u6f6eCS5468H3\u670d\u52a1\u5668","number":"1","amount":"332000","total_amount":"332000","description":"\u914d\u7f6e\u8be6\u60c5\u89c1\u539f\u6587\uff0c\u9700\u65b9\u81ea\u63d0\u6216\u4e59\u65b9\u9001\u8d27","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""},{"name":"\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6","number":"10","amount":"9247.79","total_amount":"104500","description":"\u542b\u7a0e\u5355\u4ef710,450.00\uff0c\u7a0e\u738713%","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":"13792.04","total_amount":"155850","description":"\u542b\u7a0e\u5355\u4ef715,585.00\uff0c\u7a0e\u738713%","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":"2654.87","total_amount":"30000","description":"\u542b\u7a0e\u5355\u4ef73,000.00\uff0c\u7a0e\u738713%","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":"13274.34","total_amount":"15000","description":"\u542b\u7a0e\u5355\u4ef715,000.00\uff0c\u7a0e\u738713%","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":"83962.26","total_amount":"89000","description":"\u542b\u7a0e\u5355\u4ef789,000.00\uff0c\u7a0e\u73876%","supplier_id":"","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""}],"web_access_token":"8xqSDHkpxFShwMjatgql1iJNjJHyfMBa"}', '{"code":2000,"result":{"list":[{"index":0,"name":"\u6d6a\u6f6eCS5468H3\u670d\u52a1\u5668","recognized_name":"\u6d6a\u6f6eCS5468H3\u670d\u52a1\u5668","number":"1","amount":"332000","total_amount":"332000","description":"\u914d\u7f6e\u8be6\u60c5\u89c1\u539f\u6587\uff0c\u9700\u65b9\u81ea\u63d0\u6216\u4e59\u65b9\u9001\u8d27","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\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":"9247.79","total_amount":"104500","description":"\u542b\u7a0e\u5355\u4ef710,450.00\uff0c\u7a0e\u738713%","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":2,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5b58\u50a8\u8f6f\u4ef6","recognized_name":"\u6df1\u4fe1\u670d\u865a\u62df\u5b58\u50a8\u8f6f\u4ef6","number":"10","amount":"13792.04","total_amount":"155850","description":"\u542b\u7a0e\u5355\u4ef715,585.00\uff0c\u7a0e\u738713%","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":3,"name":"\u6df1\u4fe1\u670d\u667a\u80fd\u7ba1\u5bb6","recognized_name":"\u6df1\u4fe1\u670d\u667a\u80fd\u7ba1\u5bb6","number":"10","amount":"2654.87","total_amount":"30000","description":"\u542b\u7a0e\u5355\u4ef73,000.00\uff0c\u7a0e\u738713%","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\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":"13274.34","total_amount":"15000","description":"\u542b\u7a0e\u5355\u4ef715,000.00\uff0c\u7a0e\u738713%","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":5,"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":"83962.26","total_amount":"89000","description":"\u542b\u7a0e\u5355\u4ef789,000.00\uff0c\u7a0e\u73876%","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":6,"matched":1,"pending":5}},"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; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-16 18:31:55', 27453952) RETURNING "id"
18:31:55.446	3.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "name" IN ('浪潮CS5468H3服务器', '深信服计算服务器虚拟化软件', '深信服虚拟存储软件', '深信服智能管家', '深信服企业级数据备份与恢复系统软件', '深信服超融合&备份实施服务')
18:31:55.440	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505
18:31:55.432	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1013
18:31:55.445	0.8 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183)
18:31:55.431	0.7 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
18:31:55.434	0.6 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:31:55.451	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7
18:31:55.436	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
18:31:55.452	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=139
18:31:55.453	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1283
18:31:55.453	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=12
18:31:55.454	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2