Performance Profiling

Total processing time: 460 ms; Peak memory: 2.279 MB. Show Profiling Timeline

总计6条数据

Time	Duration	Category	Info

10:24:15.810	8.1 ms	yii\db\Command::query	SELECT "id" AS "key", "project_title" AS "name", "bargain_date", "pinyin_shortcut", "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='982') AND ("project_status"=3) ORDER BY "bargain_date" DESC
10:24:15.820	6.2 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/search/project-by-client-id-with-bargain-date', '{"client_id":"982","web_access_token":"wTKilqflq6B-eOSFd1z6EzcpqcAU3V6m"}', '{"code":2000,"result":[{"key":4167,"name":"\u65b0\u5efa\u9879\u76ee (2026-05-14)","bargain_date":"2026-05-14","pinyin_shortcut":"xjxm","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":4166,"name":"9999 (2026-05-12)","bargain_date":"2026-05-12","pinyin_shortcut":"9999","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":4161,"name":"3535 (2026-04-23)","bargain_date":"2026-04-23","pinyin_shortcut":"3535","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":4164,"name":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a\/\u7f16\u8f91\/\u751f\u6210\u5408\u540c (2026-04-08)","bargain_date":"2026-04-08","pinyin_shortcut":"csxjsjbjscht","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":4155,"name":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a (2026-03-31)","bargain_date":"2026-03-31","pinyin_shortcut":"csxjsj","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":1111,"name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf (2019-09-23)","bargain_date":"2019-09-23","pinyin_shortcut":"ylsphytytx","created_by":1003,"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1}}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-02 10:24:15', 439194880) RETURNING "id"
10:24:15.806	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:24:15.804	1.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:24:15.809	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:24:15.819	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1003)