Performance Profiling

Total processing time: 25 ms; Peak memory: 2.998 MB. Show Profiling Timeline

总计11条数据

Time	Duration	Category	Info

14:38:09.000	3.1 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', 5493, 5, 'vue/project/get-filter-all-status', '{"web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":[{"key":"ProjectSearch[created_by]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5493,"name":"97289742"}],"default":""},{"key":"ProjectSearch[creator]","name":"\u521b\u5efa\u4eba","value":[{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5"}],"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":""},{"custom":"1","key":"ProjectSearch[period]","name":"\u6210\u4ea4\u65e5\u671f","value":[{"key":"thisweek","name":"\u672c\u5468"},{"key":"lastweek","name":"\u4e0a\u5468"},{"key":"thismonth","name":"\u672c\u6708"},{"key":"lastmonth","name":"\u4e0a\u6708"},{"key":"nextmonth","name":"\u4e0b\u6708"},{"key":"custom","name":"\u81ea\u5b9a\u4e49"}],"default":""},{"key":"ProjectSearch[budget]","name":"\u5546\u673a\u91d1\u989d","value":[{"key":"1","name":"10\u4e07\u4ee5\u4e0b"},{"key":"2","name":"10\u4e07\u81f320\u4e07"},{"key":"3","name":"20\u4e07\u81f350\u4e07"},{"key":"4","name":"50\u4e07\u81f3100\u4e07"},{"key":"5","name":"100\u4e07\u4ee5\u4e0a"}],"default":""},{"key":"ProjectSearch[profit_pct]","name":"\u5229\u6da6\u7387","value":[{"key":"1","name":"10%\u4ee5\u4e0b"},{"key":"2","name":"10%\u81f320%"},{"key":"3","name":"20%\u4ee5\u4e0a"}],"default":""},{"key":"ProjectSearch[invoice_status]","name":"\u5f00\u7968\u72b6\u6001","value":[{"key":"0","name":"\u672a\u5f00\u7968\u5b8c\u6210"},{"key":"1","name":"\u5df2\u5f00\u53d1\u7968"}],"default":""},{"key":"ProjectSearch[payment_status]","name":"\u6536\u6b3e\u72b6\u6001","value":[{"key":"0","name":"\u672a\u6536\u6b3e\u5b8c\u6210"},{"key":"1","name":"\u6536\u6b3e\u5b8c\u6210"}],"default":""},{"key":"ProjectSearch[project_progress]","name":"\u9500\u552e\u9636\u6bb5","value":[{"key":1,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n\u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},{"key":2,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002\n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},{"key":3,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002\n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},{"key":4,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e\n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},{"key":5,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002\n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},{"key":6,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002\n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u7248\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},{"key":7,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355\n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},{"key":8,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"}],"default":""},{"key":"ProjectSearch[salesForecast]","name":"\u9500\u552e\u9884\u6d4b","value":[{"key":93,"name":"\u786e\u4fdd","description":"100%\u786e\u8ba4\u5728\u6210\u4ea4\u65e5\u671f\u5185\u7b7e\u8ba2\u5408\u540c\u3002"},{"key":94,"name":"\u4e89\u53d6","description":"100%\u786e\u5b9a\u7b7e\u5408\u540c\uff0c\u4f46\u6210\u4ea4\u65e5\u671f\u4e0d\u786e\u5b9a\u3002"},{"key":95,"name":"\u673a\u4f1a","description":"\u53c2\u4e0e\uff0c\u6ca1\u6709\u628a\u63e1\u7b7e\u8ba2\u5408\u540c\u3002"}],"default":""},{"key":"ProjectSearch[projectProductTypes]","name":"\u5546\u673a\u7c7b\u578b","value":[{"key":1,"name":"\u9632\u706b\u5899"}],"default":"","type":"SelectMultiple"},{"key":"ProjectSearch[contract_type]","name":"\u5408\u540c\u7c7b\u578b","value":[{"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},{"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"}],"default":""},{"key":"Filter[name]","name":"\u65f6\u95f4\u6392\u5e8f","value":[{"key":"bargain_date","name":"\u6210\u4ea4\u65e5\u671f"},{"key":"updated_at","name":"\u66f4\u65b0\u65f6\u95f4"},{"key":"created_at","name":"\u521b\u5efa\u65f6\u95f4"}],"default":"updated_at"},{"key":"Filter[sort]","name":"\u6392\u5e8f\u65b9\u5f0f","value":[{"key":"ASC","name":"\u6b63\u5e8f"},{"key":"DESC","name":"\u5012\u5e8f"}],"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 14:38:09', 18080000) RETURNING "id"
14:38:08.997	1.8 ms	yii\db\Command::query	SELECT "id" AS "key", "type" AS "name" FROM "o6a13e2c574d5a"."tbl_contract_types" WHERE "is_delete"=FALSE ORDER BY "sort"
14:38:08.990	1.3 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id" IN (SELECT "creator" FROM "o6a13e2c574d5a"."tbl_projects" GROUP BY "creator") 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
14:38:08.995	1.0 ms	yii\db\Command::query	SELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
14:38:08.984	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5493
14:38:08.992	0.7 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 14:38:08, 2026-06-01 14:38:08]'::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
14:38:08.986	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
14:38:08.989	0.4 ms	yii\db\Command::query	SELECT "id" FROM "o6a13e2c574d5a"."tbl_users" WHERE ("id"=5493) AND ("user_status"='1') 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
14:38:08.983	0.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:38:08.994	0.3 ms	yii\db\Command::query	SELECT "id" AS "key", "name", "description" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("is_delete"=FALSE) ORDER BY "sort", "id"
14:38:08.994	0.3 ms	yii\db\Command::query	SELECT "id" AS "key", "project_progress" AS "name", "description" FROM "o6a13e2c574d5a"."tbl_project_progresses" WHERE "is_delete"=FALSE ORDER BY "order"