ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a2f62136b760: POST https://beta.jinchangxiao.com/vue/address-book/list at 2026-06-15 10:23:15 am by 124.127.56.185

Performance Profiling

Total processing time: 23 ms; Peak memory: 2.293 MB. Show Profiling Timeline

总计12条数据
TimeDurationCategoryInfo
  
10:23:15.4572.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/address-book/list', '{"page":"2","web_access_token":"JU9Qn0Er55lxUI9CLMF3SA6k67eZ2hvL"}', '{"code":2000,"result":{"list":[{"id":5016,"email":"gaojunyang@toast.com.cn","name":"\u9ad8\u90e1\u9633","user_status":"1","pinyin_shortcut":"gjy","sex":"M","birth_date":"1990-02-09","entry_date":"2017-06-12","department_id":10,"department_position_id":21,"mobile":"18202460558","telephone":"88864628","created_at":"2017-07-03 15:10:57","updated_at":"2026-03-30 18:07:41","id_number":"220211199002094218","native_place":"\u5409\u6797","graduate_school":"\u5409\u6797\u7535\u5b50\u4fe1\u606f\u804c\u4e1a\u6280\u672f\u5b66\u9662","specialty":"\u7f51\u7edc\u7cfb\u7edf\u7ba1\u7406","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"888","leave_date":"2026-03-30","pinyin1":"gao","pinyin2":"jun","pinyin3":"yang","pinyin4":null,"namecut1":"\u9ad8","namecut2":"\u90e1","namecut3":"\u9633","namecut4":null,"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":false,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"departmentPosition":{"id":21,"key":21,"name":"\u5f00\u53d1\u5de5\u7a0b\u5e08"},"avatar":{"user_id":5016,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"authAssignments":[{"id":135,"key":135,"name":"\u8f6f\u4ef6\u5f00\u53d1","item_name":"\u8f6f\u4ef6\u5f00\u53d1","user_id":5016,"item":{"id":101,"key":101,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},{"id":495,"key":495,"name":"Admin","item_name":"Admin","user_id":5016,"item":{"id":77,"key":77,"name":"Admin"}}],"telephone_display":"010-88864628-888","bgcolor":"#89c541"},{"id":1000,"email":"caoyongsheng@toast.com.cn","name":"\u66f9\u6c38\u751f","user_status":"1","pinyin_shortcut":"cys","sex":"M","birth_date":"1986-01-01","entry_date":"2016-07-04","department_id":10,"department_position_id":22,"mobile":"13810260729","telephone":"88864628","created_at":"2017-02-06 12:39:24","updated_at":"2026-04-30 15:41:28","id_number":"372328197810220612","native_place":"\u535a\u5174","graduate_school":"\u6ee8\u5dde\u5e08\u8303\u4e13\u79d1\u5b66\u6821","specialty":"\u6570\u5b66\u6559\u80b2(\u8ba1\u7b97\u673a)","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"813","leave_date":null,"pinyin1":"cao","pinyin2":"yong","pinyin3":"sheng","pinyin4":null,"namecut1":"\u66f9","namecut2":"\u6c38","namecut3":"\u751f","namecut4":null,"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":null,"work_on_remind":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"departmentPosition":{"id":22,"key":22,"name":"\u5f00\u53d1\u603b\u76d1"},"avatar":{"user_id":1000,"avatar":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"authAssignments":[{"id":208,"key":208,"name":"\u8f6f\u4ef6\u5f00\u53d1","item_name":"\u8f6f\u4ef6\u5f00\u53d1","user_id":1000,"item":{"id":101,"key":101,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},{"id":494,"key":494,"name":"Admin","item_name":"Admin","user_id":1000,"item":{"id":77,"key":77,"name":"Admin"}}],"telephone_display":"010-88864628-813","bgcolor":"#89c541"},{"id":5064,"email":"yaoxuechun@jinchangxiao.com","name":"\u59da\u96ea\u7eaf","user_status":"1","pinyin_shortcut":"yxc","sex":"F","birth_date":"1992-08-02","entry_date":"2018-03-06","department_id":10,"department_position_id":25,"mobile":"17610273960","telephone":"88864628","created_at":"2018-03-06 16:55:56","updated_at":"2026-04-23 17:24:00","id_number":"","native_place":"\u4fdd\u5b9a","graduate_school":"","specialty":"","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"845","leave_date":null,"pinyin1":"yao","pinyin2":"xue","pinyin3":"chun","pinyin4":null,"namecut1":"\u59da","namecut2":"\u96ea","namecut3":"\u7eaf","namecut4":null,"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":null,"work_on_remind":true,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"departmentPosition":{"id":25,"key":25,"name":"\u4ea7\u54c1\u7ecf\u7406"},"avatar":{"user_id":5064,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"authAssignments":[{"id":431,"key":431,"name":"\u8f6f\u4ef6\u5f00\u53d1","item_name":"\u8f6f\u4ef6\u5f00\u53d1","user_id":5064,"item":{"id":101,"key":101,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},{"id":498,"key":498,"name":"Engineer","item_name":"Engineer","user_id":5064,"item":{"id":79,"key":79,"name":"Engineer"}},{"id":499,"key":499,"name":"Admin","item_name":"Admin","user_id":5064,"item":{"id":77,"key":77,"name":"Admin"}}],"telephone_display":"010-88864628-845","bgcolor":"#89c541"},{"id":5461,"email":"xiaoshuai@toast.com.cn","name":"\u8096\u5e05","user_status":"1","pinyin_shortcut":"xs","sex":"M","birth_date":"2001-08-20","entry_date":"2025-11-26","department_id":10,"department_position_id":62,"mobile":"13716912663","telephone":"88864628","created_at":"2025-11-26 13:33:48","updated_at":"2025-11-26 14:29:18","id_number":"110111200108203819","native_place":"\u5317\u4eac\u5e02","graduate_school":"\u5317\u6d77\u827a\u672f\u8bbe\u8ba1\u5b66\u9662","specialty":"\u6570\u5b57\u5a92\u4f53\u827a\u672f","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"xiao","pinyin2":"shuai","pinyin3":null,"pinyin4":null,"namecut1":"\u8096","namecut2":"\u5e05","namecut3":null,"namecut4":null,"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":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"departmentPosition":{"id":62,"key":62,"name":"\u54c1\u724c\u8fd0\u8425\u63a8\u5e7f\u4e13\u5458"},"avatar":{"user_id":5461,"avatar":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"},"authAssignments":[{"id":490,"key":490,"name":"Operator","item_name":"Operator","user_id":5461,"item":{"id":175,"key":175,"name":"Operator"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"}],"pagenation":{"totalcount":24,"thispage":2,"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 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36 Edg\/149.0.0.0"}', FALSE, '2026-06-15 10:23:15', 15382784) RETURNING "id"
10:23:15.4511.5 msyii\db\Command::querySELECT "u".* FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_departments" "d" ON d.id = u.department_id LEFT JOIN "a57be577deb434"."tbl_department_positions" "dp" ON dp.id = u.department_position_id LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON aa.user_id = u.id LEFT JOIN "a57be577deb434"."tbl_auth_items" "ai" ON ai.name = aa.item_name WHERE "u"."user_status" IN ('1', '2') GROUP BY "u"."id", "d"."order", "dp"."created_at" ORDER BY d.order, dp.created_at, u.pinyin1 nulls first, namecut1 nulls first, u.pinyin2 nulls first, namecut2 nulls first, u.pinyin3 nulls first, namecut3 nulls first, u.pinyin4 nulls first, namecut4 nulls first LIMIT 20 OFFSET 20
10:23:15.4491.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "u".* FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_departments" "d" ON d.id = u.department_id LEFT JOIN "a57be577deb434"."tbl_department_positions" "dp" ON dp.id = u.department_position_id LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON aa.user_id = u.id LEFT JOIN "a57be577deb434"."tbl_auth_items" "ai" ON ai.name = aa.item_name WHERE "u"."user_status" IN ('1', '2') GROUP BY "u"."id", "d"."order", "dp"."created_at" ORDER BY d.order, dp.created_at, u.pinyin1 nulls first, namecut1 nulls first, u.pinyin2 nulls first, namecut2 nulls first, u.pinyin3 nulls first, namecut3 nulls first, u.pinyin4 nulls first, namecut4 nulls first ) "c"
10:23:15.4440.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:23:15.4460.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:23:15.4480.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:23:15.4550.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name" IN ('软件开发', 'Operator', 'Admin', 'Engineer')
10:23:15.4440.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:23:15.4540.3 msyii\db\Command::querySELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5016, 1000, 5064, 5461))
10:23:15.4530.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
10:23:15.4540.3 msyii\db\Command::querySELECT "id", "id" AS "key", "item_name" AS "name", "item_name", "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id" IN (5016, 1000, 5064, 5461)
10:23:15.4530.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (21, 22, 25, 62)