Performance Profiling

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

总计15条数据

Time	Duration	Category	Info

17:44:15.552	1.6 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "o6a13e2c574d5a"."tbl_users" WHERE "user_status" IN ('1', '2') ORDER BY "updated_at" DESC) "c"
17:44:15.559	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', 5493, 5, 'vue/account/list', '{"page":"1","web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":{"list":[{"id":5493,"email":"97289742@126.com","name":"97289742","user_status":"1","pinyin_shortcut":"97289742","sex":"M","birth_date":"2026-05-01","entry_date":"2026-05-01","department_id":1,"department_position_id":1,"mobile":"18897289742","telephone":"","created_at":"2026-05-25 13:48:53","updated_at":"2026-05-27 17:22:58","id_number":"","native_place":"","graduate_school":"","specialty":"","education":"","telephone_area_code":"","telephone_extension_number":"","leave_date":"","pinyin1":"","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"9","namecut2":"7","namecut3":"2","namecut4":"8","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":{},"department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"},"departmentPosition":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"},"userRoles":[{"id":2,"key":2,"name":"Admin","display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458"},{"id":3,"key":3,"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":5495,"email":"","name":"\u903b\u8f91\u6d4b\u8bd5","user_status":"1","pinyin_shortcut":"ljcs","sex":"F","birth_date":"2026-05-25","entry_date":"2026-05-25","department_id":4,"department_position_id":9,"mobile":"17600801168","telephone":"","created_at":"2026-05-25 13:53:25","updated_at":"2026-05-25 13:53:25","id_number":"","native_place":"","graduate_school":"","specialty":"","education":"","telephone_area_code":"","telephone_extension_number":"","leave_date":"","pinyin1":"luo","pinyin2":"ji","pinyin3":"ce","pinyin4":"shi","namecut1":"\u903b","namecut2":"\u8f91","namecut3":"\u6d4b","namecut4":"\u8bd5","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":true,"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":{},"department":{"id":4,"key":4,"name":"\u5546\u52a1\u90e8"},"departmentPosition":{"id":9,"key":9,"name":"\u5546\u52a1\u7ecf\u7406"},"userRoles":[{"id":5,"key":5,"name":"CommercialAttache","display_name":"\u5546\u52a1\u4e13\u5458"}],"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"}],"create_notice":false,"can_create":true,"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"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-05-29 17:44:15', 25423104) RETURNING "id"
17:44:15.547	0.6 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5493
17:44:15.554	0.4 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "user_status" IN ('1', '2') ORDER BY "updated_at" DESC LIMIT 20
17:44:15.554	0.4 ms	yii\db\Command::query	SELECT "user_id", "meta_value" AS "avatar" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5493, 5495))
17:44:15.555	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id" IN (1, 4)
17:44:15.558	0.4 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_enterprises" WHERE "id"=312
17:44:15.549	0.4 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
17:44:15.555	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_department_positions" WHERE "id" IN (1, 9)
17:44:15.557	0.2 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_logins" WHERE "id"=5493
17:44:15.547	0.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:44:15.556	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "display_name" FROM "o6a13e2c574d5a"."tbl_auth_items" WHERE "name" IN ('Admin', 'CommercialAttache', 'AccountManager')
17:44:15.557	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "display_name" FROM "o6a13e2c574d5a"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('Admin', 'CommercialAttache', 'AccountManager'))
17:44:15.556	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "item_name" AS "name", "item_name", "user_id" FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE "user_id" IN (5493, 5495)
17:44:15.556	0.2 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE "user_id" IN (5493, 5495)