15:25:00.298 [http-nio-8899-exec-28] DEBUG c.b.s.m.S.selectUserByLoginName - [debug,159] - ==> Preparing: select u.user_id, u.dept_id, u.campus, u.campus_loc, u2.user_id as superior_id, u2.user_name as superior_name, u.login_name, u.user_name, u.user_type, u.email, u.avatar, u.phonenumber, u.sex, u.password, u.salt, u.status, u.del_flag, u.login_ip, u.login_date, u.create_time, u.remark, d.dept_id, d.parent_id, d.dept_name, d.order_num, d.leader, d.status as dept_status, r.role_id, r.role_name, r.role_key, r.role_sort, r.data_scope, r.status as role_status from sys_user u left join sys_user u2 on (u.superior_id = u2.user_id and u2.del_flag != 2) left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id where u.login_name = ?
15:25:00.300 [http-nio-8899-exec-28] DEBUG c.b.s.m.S.selectUserByLoginName - [debug,159] - ==> Parameters: admin(String)
15:25:00.366 [http-nio-8899-exec-28] DEBUG c.b.s.m.S.selectUserByLoginName - [debug,159] - <== Total: 1
15:25:00.379 [http-nio-8899-exec-28] DEBUG c.b.s.m.S.updateUser - [debug,159] - ==> Preparing: update sys_user SET dept_id = ?, campus = ?, campus_loc = ?, superior_id = ?, login_name = ?, user_name = ?, user_type = ?, email = ?, phonenumber = ?, sex = ?, avatar = ?, password = ?, salt = ?, status = ?, login_ip = ?, login_date = ?, remark = ?, update_time = sysdate() where user_id = ?
15:25:00.381 [http-nio-8899-exec-28] DEBUG c.b.s.m.S.updateUser - [debug,159] - ==> Parameters: 100(Long), 1(String), 1(String), 207(Long), admin(String), 管理员(String), 00(String), admin@163.com(String), 15888888888(String), 0(String), 96f039de-278a-4565-b8bf-03c3250dab0f9749.549872809997.png(String), 29c67a30398638269fe600f73a054934(String), 111111(String), 0(String), 113.72.8.122(String), 2020-08-26 15:25:00.374(Timestamp), 管理员(String), 1(Long)
15:25:00.384 [schedule-pool-2] INFO sys-user - [run,109] - [113.72.8.122]XX XX[admin][Success][登录成功]
15:25:00.384 [schedule-pool-2] DEBUG c.b.s.m.S.insertLogininfor - [debug,159] - ==> Preparing: insert into sys_logininfor (login_name, status, ipaddr, login_location, browser, os, msg, login_time) values (?, ?, ?, ?, ?, ?, ?, sysdate())
15:25:00.385 [schedule-pool-2] DEBUG c.b.s.m.S.insertLogininfor - [debug,159] - ==> Parameters: admin(String), 0(String), 113.72.8.122(String), XX XX(String), Chrome 8(String), Windows 10(String), 登录成功(String)
15:25:00.481 [http-nio-8899-exec-28] DEBUG c.b.s.m.S.updateUser - [debug,159] - <== Updates: 1
15:25:00.492 [schedule-pool-2] DEBUG c.b.s.m.S.insertLogininfor - [debug,159] - <== Updates: 1
客户端:ping,已收到
15:25:48.773 [schedule-pool-5] DEBUG c.b.s.m.S.saveOnline - [debug,159] - ==> Preparing: replace into sys_user_online(sessionId, login_name, dept_name, ipaddr, login_location, browser, os, status, start_timestamp, last_access_time, expire_time) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
15:25:48.774 [schedule-pool-5] DEBUG c.b.s.m.S.saveOnline - [debug,159] - ==> Parameters: 783041a3-0c7a-4630-a152-33d8306e6575(String), admin(String), 集团(String), 113.72.8.122(String), XX XX(String), Chrome 8(String), Windows 10(String), on_line(String), 2020-08-26 15:24:55.795(Timestamp), 2020-08-26 15:25:48.771(Timestamp), 600000(Long)
15:25:48.873 [schedule-pool-5] DEBUG c.b.s.m.S.saveOnline - [debug,159] - <== Updates: 1
15:26:03.379 [http-nio-8899-exec-21] DEBUG c.b.s.m.S.selectMenuNormalAll - [debug,159] - ==> Preparing: select distinct m.menu_id, m.parent_id, m.menu_name, m.url, m.visible, ifnull(m.perms,'') as perms, m.target, m.menu_type, m.icon, m.order_num, m.create_time from sys_menu m where m.menu_type in ('M', 'C') and m.visible = 0 order by m.parent_id, m.order_num
15:26:03.380 [http-nio-8899-exec-21] DEBUG c.b.s.m.S.selectMenuNormalAll - [debug,159] - ==> Parameters:
15:26:03.448 [http-nio-8899-exec-21] DEBUG c.b.s.m.S.selectMenuNormalAll - [debug,159] - <== Total: 38
15:26:03.450 [http-nio-8899-exec-21] DEBUG c.b.s.m.S.selectNewsCountByUserId - [debug,159] - ==> Preparing: select count(1) from sys_news where send_to = ? and read_flag = '0'
15:26:03.457 [http-nio-8899-exec-21] DEBUG c.b.s.m.S.selectNewsCountByUserId - [debug,159] - ==> Parameters: 1(Long)
15:26:03.507 [http-nio-8899-exec-21] DEBUG c.b.s.m.S.selectNewsCountByUserId - [debug,159] - <== Total: 1
15:26:03.508 [http-nio-8899-exec-21] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-config]
15:26:03.508 [http-nio-8899-exec-21] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-config]
15:26:03.513 [http-nio-8899-exec-21] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-config]
15:26:03.555 [http-nio-8899-exec-21] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-config]
15:26:03.671 [http-nio-8899-exec-26] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-dict]
15:26:03.673 [http-nio-8899-exec-26] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-dict]
如上所示,
15:25:00.492 [schedule-pool-2] DEBUG c.b.s.m.S.insertLogininfor - [debug,159] - <== Updates: 1
客户端:ping,已收到
15:25:48.773 [schedule-pool-5] DEBUG c.b.s.m.S.saveOnline - [debug,159] - ==> Preparing: replace into sys_user_online(sessionId, login_name, dept_name, ipaddr, login_location, browser, os, status, start_timestamp, last_access_time, expire_time) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
15:25:48.774 [schedule-pool-5] DEBUG c.b.s.m.S.saveOnline - [debug,159] - ==> Parameters: 783041a3-0c7a-4630-a152-33d8306e6575(String), admin(String), 集团(String), 113.72.8.122(String), XX XX(String), Chrome 8(String), Windows 10(String), on_line(String), 2020-08-26 15:24:55.795(Timestamp), 2020-08-26 15:25:48.771(Timestamp), 600000(Long)
15:25:48.873 [schedule-pool-5] DEBUG c.b.s.m.S.saveOnline - [debug,159] - <== Updates: 1
15:26:03.379 [http-nio-8899-exec-21] DEBUG c.b.s.m.S.selectMenuNormalAll - [debug,159] - ==> Preparing: select distinct m.menu_id, m.parent_id, m.menu_name, m.url, m.visible, ifnull(m.perms,'') as perms, m.target, m.menu_type, m.icon, m.order_num, m.create_time from sys_menu m where m.menu_type in ('M', 'C') and m.visible = 0 order by m.parent_id, m.order_num
这里卡了差不多一分钟,麻烦看一下问题所在,非常感谢