Performance Profiling

Total processing time: 29 ms; Peak memory: 3.474 MB. Show Profiling Timeline

总计9条数据

Time	Duration	Category	Info

11:42:06.748	1.0 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, 'o6a13e2c574d5a', 5495, 5, 'vue/project/get-filter-of-client', '{"web_access_token":"7CCP7jMsjjSDfF61luGGB1mxLPdASSzl"}', '{"code":2000,"result":[{"key":"ProjectSearch[projectProductTypes]","name":"\u5546\u673a\u7c7b\u578b","value":[{"key":1,"name":"\u9632\u706b\u5899"}],"default":"","type":"SelectMultiple"},{"key":"ProjectSearch[project_progress]","name":"\u9500\u552e\u9636\u6bb5","value":[{"key":1,"name":"\u786e\u8ba4\u95ee\u9898"},{"key":2,"name":"\u65b9\u6848\u8bbe\u8ba1"},{"key":3,"name":"\u786e\u8ba4\u65b9\u6848"},{"key":4,"name":"\u5546\u52a1\u62a5\u4ef7"},{"key":5,"name":"\u63a8\u52a8\u6210\u4ea4"},{"key":6,"name":"\u7b7e\u8ba2\u5408\u540c"},{"key":7,"name":"\u4ea4\u8d27\u4e2d"},{"key":8,"name":"\u6536\u6b3e\u4e2d"}]},{"key":"ProjectSearch[project_status]","name":"\u5546\u673a\u72b6\u6001","value":[{"key":1,"name":"\u9690\u6027\u9700\u6c42"},{"key":2,"name":"\u660e\u786e\u9700\u6c42"},{"key":3,"name":"\u5546\u673a\u6210\u4ea4"},{"key":4,"name":"\u5546\u673a\u5931\u8d25"},{"key":5,"name":"\u5546\u673a\u6401\u7f6e"},{"key":"-1","name":"\u6536\u6b3e\u5b8c\u6210"}],"default":""},{"key":"ProjectSearch[engineer_id]","name":"\u552e\u524d\u652f\u6301","value":[{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5"},{"key":0,"name":"(\u672a\u8bbe\u7f6e)"}],"default":5495},{"key":"ProjectSearch[salesForecast]","name":"\u9500\u552e\u9884\u6d4b","value":[{"key":93,"name":"\u786e\u4fdd"},{"key":94,"name":"\u4e89\u53d6"},{"key":95,"name":"\u673a\u4f1a"}],"default":""},{"key":"ProjectSearch[invoice_status]","name":"\u5f00\u7968\u72b6\u6001","value":[{"key":"0","name":"\u672a\u5f00\u53d1\u7968"},{"key":"1","name":"\u5df2\u5f00\u53d1\u7968"}],"default":""}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 11:42:06', 24993024) RETURNING "id"
11:42:06.746	0.8 ms	yii\db\Command::query	SELECT "user_id" FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" "urcl" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-06-01 11:42:06, 2026-06-01 11:42:06]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
11:42:06.737	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5495
11:42:06.743	0.6 ms	yii\db\Command::query	SELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
11:42:06.747	0.5 ms	yii\db\Command::query	SELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("is_delete"=FALSE) ORDER BY "sort", "id"
11:42:06.744	0.5 ms	yii\db\Command::query	SELECT "id" AS "key", "project_progress" AS "name" FROM "o6a13e2c574d5a"."tbl_project_progresses" WHERE "is_delete"=FALSE ORDER BY "order"
11:42:06.739	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
11:42:06.745	0.4 ms	yii\db\Command::query	SELECT "id" AS "key", "project_status" AS "name" FROM "o6a13e2c574d5a"."tbl_project_statuses" ORDER BY "order"
11:42:06.737	0.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta