Performance Profiling

Total processing time: 24 ms; Peak memory: 5.203 MB. Show Profiling Timeline

总计15条数据

Time	Duration	Category	Info

17:40:06.023	3.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND (("name" ILIKE '%wjc%') OR ("email" ILIKE '%wjc%') OR ("pinyin_shortcut" ILIKE '%wjc%')) ORDER BY "updated_at" DESC) "c"
17:40:06.035	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, 'a57be577deb434', 1001, 5, 'vue/account/list', '{"AccountSearch":{"department_id":"","department_position_id":"","keyword":"wjc"},"page":"1","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":1013,"email":"wengjiacheng@toast.com.cn","name":"\u7fc1\u5bb6\u6210","user_status":"1","pinyin_shortcut":"wjc","sex":"M","birth_date":"1978-05-25","entry_date":"2002-05-23","department_id":7,"department_position_id":17,"mobile":"13701159744","telephone":"88864628","created_at":"2017-02-06 13:12:50","updated_at":"2025-08-01 23:27:04","id_number":"330903197805250012","native_place":"\u821f\u5c71","graduate_school":"-","specialty":"-","education":"-","telephone_area_code":"","telephone_extension_number":"833","leave_date":"","pinyin1":"weng","pinyin2":"jia","pinyin3":"cheng","pinyin4":"","namecut1":"\u7fc1","namecut2":"\u5bb6","namecut3":"\u6210","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":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":1013,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"},"departmentPosition":{"id":17,"key":17,"name":"\u5e93\u7ba1\u5458"},"userRoles":[{"id":82,"key":82,"name":"TechDirector","display_name":"\u6280\u672f\u603b\u76d1"},{"id":86,"key":86,"name":"StoreKeeper","display_name":"\u5e93\u7ba1\u4e13\u5458"},{"id":85,"key":85,"name":"CommercialAttache","display_name":"\u5546\u52a1\u4e13\u5458"},{"id":283,"key":283,"name":"Treasurer","display_name":"\u8d22\u52a1\u4e13\u5458"},{"id":161,"key":161,"name":"Dispatcher","display_name":"\u6d3e\u5355\u5458"},{"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":"\u7537","bgcolor":"#89c541"}],"create_notice":false,"can_create":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 17:40:06', 19414016) RETURNING "id"
17:40:06.026	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND (("name" ILIKE '%wjc%') OR ("email" ILIKE '%wjc%') OR ("pinyin_shortcut" ILIKE '%wjc%')) ORDER BY "updated_at" DESC LIMIT 20
17:40:06.017	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:40:06.020	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:06.032	0.3 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2
17:40:06.029	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name" IN ('TechDirector', 'Dispatcher', 'StoreKeeper', 'CommercialAttache', 'AccountManager', 'Treasurer')
17:40:06.028	0.3 ms	yii\db\Command::query	SELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)
17:40:06.030	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 ('TechDirector', 'Dispatcher', 'StoreKeeper', 'CommercialAttache', 'AccountManager', 'Treasurer'))
17:40:06.031	0.3 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_logins" WHERE "id"=1001
17:40:06.029	0.2 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"=1013
17:40:06.017	0.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:40:06.030	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=1013
17:40:06.028	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=7
17:40:06.029	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id"=17