Performance Profiling

Total processing time: 33 ms; Peak memory: 5.249 MB. Show Profiling Timeline

总计16条数据

Time	Duration	Category	Info

15:03:39.647	2.2 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":"3","department_position_id":""},"page":"1","web_access_token":"Ch010kzLIo0K3JLdI5ASnPkRyaIiGsY7"}', '{"code":2000,"result":{"list":[{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":"","pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":"","namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","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":1011,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"},"departmentPosition":{"id":18,"key":18,"name":"\u5546\u52a1\u7ecf\u7406"},"userRoles":[{"id":85,"key":85,"name":"CommercialAttache","display_name":"\u5546\u52a1\u4e13\u5458"},{"id":161,"key":161,"name":"Dispatcher","display_name":"\u6d3e\u5355\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"},{"id":5360,"email":"zhanghongfang@toast.com.cn","name":"\u5f20\u7ea2\u82b3","user_status":"1","pinyin_shortcut":"zhf","sex":"F","birth_date":"1997-04-07","entry_date":"2023-04-24","department_id":3,"department_position_id":60,"mobile":"18660100116","telephone":"88864628","created_at":"2023-04-24 09:37:05","updated_at":"2023-04-25 06:04:57","id_number":"371421199704072969","native_place":"\u5c71\u4e1c\u7701\u9675\u53bf","graduate_school":"\u5c71\u4e1c\u5e08\u8303\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u7f51\u8def\u6280\u672f","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"819","leave_date":"","pinyin1":"zhang","pinyin2":"hong","pinyin3":"fang","pinyin4":"","namecut1":"\u5f20","namecut2":"\u7ea2","namecut3":"\u82b3","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":5360,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"},"departmentPosition":{"id":60,"key":60,"name":"\u5546\u52a1\u4e13\u5458"},"userRoles":[{"id":85,"key":85,"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":"124.127.56.185","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/26.2 Safari\/605.1.15"}', FALSE, '2026-07-01 15:03:39', 24343040) RETURNING "id"
15:03:39.626	1.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:03:39.629	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:03:39.635	0.8 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND ("department_id"='3') ORDER BY "updated_at" DESC) "c"
15:03:39.636	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND ("department_id"='3') ORDER BY "updated_at" DESC LIMIT 20
15:03:39.631	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:03:39.626	0.5 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:03:39.638	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 (1011, 5360))
15:03:39.643	0.4 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2
15:03:39.642	0.4 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_logins" WHERE "id"=1001
15:03:39.640	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name" IN ('Dispatcher', 'CommercialAttache')
15:03:39.641	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 ('Dispatcher', 'CommercialAttache'))
15:03:39.639	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (18, 60)
15:03:39.639	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 (1011, 5360)
15:03:39.640	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id" IN (1011, 5360)
15:03:39.638	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3