Performance Profiling

Total processing time: 53 ms; Peak memory: 5.264 MB. Show Profiling Timeline

总计15条数据

Time	Duration	Category	Info

16:37:50.437	2.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, 'a57be577deb434', 1001, 5, 'vue/account/list', '{"AccountSearch":{"department_id":"","department_position_id":"","keyword":"l"},"page":"1"}', '{"code":2000,"result":{"list":[{"id":1001,"email":"lrc@toast.com.cn","name":"\u5218\u4eba\u8bda","user_status":"1","pinyin_shortcut":"lrc","sex":"M","birth_date":"1977-04-06","entry_date":"2005-06-06","department_id":4,"department_position_id":7,"mobile":"13501128560","telephone":"88864628","created_at":"2017-02-06 13:05:08","updated_at":"2026-06-29 20:16:20","id_number":"220523197704064411","native_place":"\u5409\u6797","graduate_school":"\u5409\u6797\u5de5\u4e1a\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u5e94\u7528","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"821","leave_date":"","pinyin1":"liu","pinyin2":"ren","pinyin3":"cheng","pinyin4":"","namecut1":"\u5218","namecut2":"\u4eba","namecut3":"\u8bda","namecut4":"","budget_count":"2000425.78","profit_count":"88226.214434000000000000","bargain_count":"5","opportunity_budget_count":"697106.06","opportunity_count":"4","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"user_id":1001,"avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"departmentPosition":{"id":7,"key":7,"name":"\u603b\u7ecf\u7406"},"userRoles":[{"id":77,"key":77,"name":"Admin","display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458"},{"id":283,"key":283,"name":"Treasurer","display_name":"\u8d22\u52a1\u4e13\u5458"},{"id":81,"key":81,"name":"AccountManager","display_name":"\u5ba2\u6237\u7ecf\u7406"}],"is_sales":true,"is_admin":true,"can_update_visit_auth":true,"can_update":true,"can_change_password":true,"can_delete":false,"can_destroy":false,"can_resend":false,"can_reactivate":false,"sex_display":"\u7537","bgcolor":"#89c541"},{"id":5446,"email":"liujuan@toast.com.cn","name":"\u5218\u5a1f","user_status":"1","pinyin_shortcut":"lj","sex":"F","birth_date":"1987-10-04","entry_date":"2025-03-03","department_id":8,"department_position_id":61,"mobile":"15699735973","telephone":"88864628","created_at":"2025-03-03 10:55:13","updated_at":"2025-03-03 10:55:13","id_number":"413026198710047225","native_place":"\u7518\u8083\u7701\u5609\u5cea\u5173\u5e02","graduate_school":"\u5317\u4eac\u4e1c\u65b9\u5927\u5b66","specialty":"\u5de5\u5546\u4f01\u4e1a\u7ba1\u7406","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"liu","pinyin2":"juan","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u5a1f","namecut3":"","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"user_id":5446,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"},"department":{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90"},"departmentPosition":{"id":61,"key":61,"name":"\u62db\u8058\u4e13\u5458"},"userRoles":[{"id":110,"key":110,"name":"\u4eba\u529b\u8d44\u6e90","display_name":"\u4eba\u529b\u8d44\u6e90"}],"is_sales":false,"is_admin":false,"can_update_visit_auth":true,"can_update":true,"can_change_password":true,"can_delete":true,"can_destroy":false,"can_resend":false,"can_reactivate":false,"sex_display":"\u5973","bgcolor":"#89c541"},{"id":5087,"email":"liuwei@toast.com.cn","name":"\u5218\u5fae","user_status":"1","pinyin_shortcut":"lw","sex":"F","birth_date":"1977-07-07","entry_date":"2005-05-01","department_id":1,"department_position_id":2,"mobile":"13910698067","telephone":"","created_at":"2019-01-16 14:27:07","updated_at":"2021-12-13 11:21:52","id_number":"","native_place":"\u5409\u6797","graduate_school":"\u5317\u4eac\u5efa\u8bbe\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u5e94\u7528","education":"\u672c\u79d1","telephone_area_code":"","telephone_extension_number":"","leave_date":"2020-06-12","pinyin1":"liu","pinyin2":"wei","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u5fae","namecut3":"","namecut4":"","budget_count":"420440","profit_count":"176762.528000000000000000","bargain_count":"4","opportunity_budget_count":"20149680","opportunity_count":"12","work_log_score":"5","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"user_id":5087,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":2,"key":2,"name":"\u5ba2\u6237\u7ecf\u7406"},"userRoles":[{"id":81,"key":81,"name":"AccountManager","display_name":"\u5ba2\u6237\u7ecf\u7406"}],"is_sales":true,"is_admin":false,"can_update_visit_auth":true,"can_update":true,"can_change_password":true,"can_delete":true,"can_destroy":false,"can_resend":false,"can_reactivate":false,"sex_display":"\u5973","bgcolor":"#89c541"},{"id":5248,"email":"wenjialong@toast.com.cn","name":"\u6587\u4f73\u9f99","user_status":"1","pinyin_shortcut":"wjl","sex":"M","birth_date":"1996-03-11","entry_date":"2020-11-16","department_id":2,"department_position_id":3,"mobile":"15511215410","telephone":"88864628","created_at":"2020-11-16 09:35:44","updated_at":"2020-11-16 10:18:56","id_number":"142622199603117510","native_place":"\u5c71\u897f\u7701\u7ffc\u57ce\u53bf","graduate_school":"\u6cb3\u5317\u79d1\u6280\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u79d1\u5b66\u4e0e\u6280\u672f","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"wen","pinyin2":"jia","pinyin3":"long","pinyin4":"","namecut1":"\u6587","namecut2":"\u4f73","namecut3":"\u9f99","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"23","e_budget_count":"0","e_profit_count":"0","e_client_count":"14","e_project_count":"14","e_point_count":"828","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"user_id":5248,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"departmentPosition":{"id":3,"key":3,"name":"\u6280\u672f\u5de5\u7a0b\u5e08"},"userRoles":[{"id":79,"key":79,"name":"Engineer","display_name":"\u5de5\u7a0b\u5e08"}],"is_sales":false,"is_admin":false,"can_update_visit_auth":true,"can_update":true,"can_change_password":true,"can_delete":true,"can_destroy":false,"can_resend":false,"can_reactivate":false,"sex_display":"\u7537","bgcolor":"#89c541"}],"create_notice":false,"can_create":true,"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-30 16:37:50', 26053120) RETURNING "id"
16:37:50.415	1.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:37:50.423	1.5 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND (("name" ILIKE '%l%') OR ("email" ILIKE '%l%') OR ("pinyin_shortcut" ILIKE '%l%')) ORDER BY "updated_at" DESC) "c"
16:37:50.425	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND (("name" ILIKE '%l%') OR ("email" ILIKE '%l%') OR ("pinyin_shortcut" ILIKE '%l%')) ORDER BY "updated_at" DESC LIMIT 20
16:37:50.414	0.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:37:50.419	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:37:50.427	0.4 ms	yii\db\Command::query	SELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5446, 5087, 5248))
16:37:50.432	0.4 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2
16:37:50.429	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name" IN ('AccountManager', 'Admin', 'Engineer', '人力资源', 'Treasurer')
16:37:50.430	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('AccountManager', 'Admin', 'Engineer', '人力资源', 'Treasurer'))
16:37:50.431	0.3 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_logins" WHERE "id"=1001
16:37:50.427	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 8, 1, 2)
16:37:50.428	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "item_name" AS "name", "item_name", "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id" IN (1001, 5446, 5087, 5248)
16:37:50.428	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (7, 61, 2, 3)
16:37:50.429	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id" IN (1001, 5446, 5087, 5248)