ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a4378e413871: POST https://beta.jinchangxiao.com/vue/address-book/list at 2026-06-30 04:05:56 pm by 39.156.194.178

Performance Profiling

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

总计12条数据
TimeDurationCategoryInfo
  
16:05:56.1013.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":"eMTml_7SPa2soMn8MVK5OyrE5RurRc4u"}', '{"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":null,"pinyin1":"weng","pinyin2":"jia","pinyin3":"cheng","pinyin4":null,"namecut1":"\u7fc1","namecut2":"\u5bb6","namecut3":"\u6210","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":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"},"departmentPosition":{"id":17,"key":17,"name":"\u5e93\u7ba1\u5458"},"avatar":{"user_id":1013,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"authAssignments":[{"id":248,"key":248,"name":"TechDirector","item_name":"TechDirector","user_id":1013,"item":{"id":82,"key":82,"name":"TechDirector"}},{"id":249,"key":249,"name":"Dispatcher","item_name":"Dispatcher","user_id":1013,"item":{"id":161,"key":161,"name":"Dispatcher"}},{"id":75,"key":75,"name":"StoreKeeper","item_name":"StoreKeeper","user_id":1013,"item":{"id":86,"key":86,"name":"StoreKeeper"}},{"id":435,"key":435,"name":"CommercialAttache","item_name":"CommercialAttache","user_id":1013,"item":{"id":85,"key":85,"name":"CommercialAttache"}},{"id":456,"key":456,"name":"AccountManager","item_name":"AccountManager","user_id":1013,"item":{"id":81,"key":81,"name":"AccountManager"}},{"id":487,"key":487,"name":"Treasurer","item_name":"Treasurer","user_id":1013,"item":{"id":283,"key":283,"name":"Treasurer"}}],"telephone_display":"88864628-833","bgcolor":"#89c541"},{"id":5250,"email":"dongrong@jinchangxiao.com","name":"\u8463\u8363","user_status":"1","pinyin_shortcut":"dr","sex":"M","birth_date":"1992-10-05","entry_date":"2020-11-27","department_id":10,"department_position_id":21,"mobile":"18210054154","telephone":"88864628","created_at":"2020-11-27 09:49:55","updated_at":"2026-06-29 20:15:55","id_number":"220283199210052719","native_place":"\u5409\u6797\u7701\u8212\u5170\u5e02","graduate_school":"\u5317\u4eac\u822a\u7a7a\u822a\u5929\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u79d1\u5b66\u4e0e\u6280\u672f","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"dong","pinyin2":"rong","pinyin3":null,"pinyin4":null,"namecut1":"\u8463","namecut2":"\u8363","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":false,"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":5250,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"authAssignments":[{"id":345,"key":345,"name":"\u8f6f\u4ef6\u5f00\u53d1","item_name":"\u8f6f\u4ef6\u5f00\u53d1","user_id":5250,"item":{"id":101,"key":101,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},{"id":497,"key":497,"name":"Admin","item_name":"Admin","user_id":5250,"item":{"id":77,"key":77,"name":"Admin"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"},{"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":"13888888888","telephone":"99999999","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-99999999-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":26,"thispage":2,"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_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-30 16:05:56', 19479040) RETURNING "id"
16:05:56.0912.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"
16:05:56.0941.8 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
16:05:56.0841.0 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1000
16:05:56.0870.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:05:56.0890.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:05:56.0980.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name" IN ('TechDirector', 'Dispatcher', 'StoreKeeper', '软件开发', 'CommercialAttache', 'AccountManager', 'Treasurer', 'Operator', 'Admin', 'Engineer')
16:05:56.0980.4 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 (1013, 5250, 5016, 1000, 5064, 5461)
16:05:56.0840.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:05:56.0960.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (17, 21, 22, 25, 62)
16:05:56.0970.4 msyii\db\Command::querySELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1013, 5250, 5016, 1000, 5064, 5461))
16:05:56.0960.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (7, 10)