Inicio Explorar Axuda
Iniciar sesión
go_lizi
/
gfast
2
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Rama: pgsql
Ramas Etiquetas
gfast
/
library
/
data
/
log
/
gf-app
/
sql
/
2021-09-14.log

2021-09-14.log 25 KB
Permalink Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130 
  1. 2021-09-14 00:00:05.943 [DEBU] [  8 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    2. 

  2. 2021-09-14 00:00:05.947 [DEBU] [  3 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    3. 

  3. 2021-09-14 00:10:05.696 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    4. 

  4. 2021-09-14 00:10:05.698 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    5. 

  5. 2021-09-14 00:20:05.773 [DEBU] [ 26 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    6. 

  6. 2021-09-14 00:20:05.781 [DEBU] [  7 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    7. 

  7. 2021-09-14 00:30:05.926 [DEBU] [ 10 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    8. 

  8. 2021-09-14 00:30:05.928 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    9. 

  9. 2021-09-14 14:50:05.053 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    10. 

  10. 2021-09-14 14:50:05.059 [DEBU] [  4 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    11. 

  11. 2021-09-14 15:00:05.154 [DEBU] [ 10 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    12. 

  12. 2021-09-14 15:00:05.156 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    13. 

  13. 2021-09-14 15:10:05.442 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    14. 

  14. 2021-09-14 15:10:05.444 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    15. 

  15. 2021-09-14 15:20:05.227 [DEBU] [ 26 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    16. 

  16. 2021-09-14 15:20:05.236 [DEBU] [  8 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    17. 

  17. 2021-09-14 15:30:05.208 [DEBU] [ 32 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    18. 

  18. 2021-09-14 15:30:05.216 [DEBU] [  7 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    19. 

  19. 2021-09-14 15:40:05.415 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    20. 

  20. 2021-09-14 15:40:05.418 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    21. 

  21. 2021-09-14 20:50:05.705 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    22. 

  22. 2021-09-14 20:50:05.707 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    23. 

  23. 2021-09-14 20:56:17.664 [DEBU] [ 11 ms] [default] SELECT `id`,`user_name`,`user_nickname`,`user_password`,`user_salt`,`user_status`,`is_admin`,`avatar`,`dept_id` FROM `sys_user` WHERE (`user_name`='demo') AND `deleted_at` IS NULL LIMIT 1 
    24. 

  24. 2021-09-14 20:56:17.675 [DEBU] [ 10 ms] [default] UPDATE `sys_user` SET `last_login_ip`='[::1]',`last_login_time`='2021-09-14 20:56:17' WHERE `id`=31 
    25. 

  25. 2021-09-14 20:56:17.709 [DEBU] [ 33 ms] [default] INSERT INTO `sys_login_log`(`ipaddr`,`login_location`,`os`,`status`,`module`,`login_name`,`browser`,`msg`,`login_time`,`info_id`) VALUES('[::1]','内网IP','Intel Mac OS X 11_2_3',1,'系统后台','demo','Chrome','登录成功','2021-09-14 20:56:17',0)  
    26. 

  26. 2021-09-14 20:56:17.712 [DEBU] [ 22 ms] [default] SELECT `id` FROM `sys_user_online` WHERE `token`='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv/MCADIoz6rqTwJ2m/XrgByLQqdLxv7yYXVNhUt2UmP/9rMktoxvEKWIe29tg8W74A==' LIMIT 1 
    27. 

  27. 2021-09-14 20:56:17.736 [DEBU] [ 23 ms] [default] INSERT INTO `sys_user_online`(`explorer`,`os`,`uuid`,`token`,`create_time`,`user_name`,`ip`) VALUES('Chrome','Intel Mac OS X 11_2_3','d7dedbe7f22e1ca8bc29fa18da932525','oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv/MCADIoz6rqTwJ2m/XrgByLQqdLxv7yYXVNhUt2UmP/9rMktoxvEKWIe29tg8W74A==','2021-09-14 20:56:17','demo','[::1]')  
    28. 

  28. 2021-09-14 20:56:17.752 [DEBU] [  6 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    29. 

  29. 2021-09-14 20:56:17.768 [DEBU] [ 14 ms] [default] INSERT INTO `sys_oper_log`(`title`,`method`,`oper_time`,`oper_url`,`operator_type`,`oper_name`,`json_result`,`oper_param`,`oper_location`,`status`,`request_method`,`oper_ip`,`dept_name`) VALUES('','/system/user/getInfo','2021-09-14 20:56:17','/system/user/getInfo',1,'demo','{"code":0,"msg":"success"}','{}','内网IP',1,'GET','[::1]','财务部门')  
    30. 

  30. 2021-09-14 20:56:17.806 [DEBU] [  7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    31. 

  31. 2021-09-14 20:56:17.825 [DEBU] [ 18 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_location`,`status`,`oper_param`,`request_method`,`title`,`method`,`dept_name`,`oper_name`,`json_result`,`oper_time`,`oper_url`,`operator_type`) VALUES('[::1]','内网IP',1,'{}','GET','','/system/user/getRouters','财务部门','demo','{"code":0,"msg":"success"}','2021-09-14 20:56:17','/system/user/getRouters',1)  
    32. 

  32. 2021-09-14 20:56:35.859 [DEBU] [  4 ms] [default] SELECT `dept_id`,`parent_id`,`ancestors`,`dept_name`,`order_num`,`leader`,`phone`,`email`,`status`,`created_by`,`updated_by`,`created_at`,`updated_at`,`deleted_at` FROM `sys_dept` WHERE `deleted_at` IS NULL 
    33. 

  33. 2021-09-14 20:56:35.879 [DEBU] [  6 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    34. 

  34. 2021-09-14 20:56:35.880 [DEBU] [  7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    35. 

  35. 2021-09-14 20:56:35.889 [DEBU] [ 10 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`operator_type`,`oper_location`,`json_result`,`oper_name`,`oper_ip`,`oper_time`,`dept_name`,`oper_url`,`status`,`title`,`method`,`request_method`) VALUES('{}',1,'内网IP','{"code":0,"msg":"success"}','demo','[::1]','2021-09-14 20:56:35','财务部门','/system/auth/deptList',1,'部门管理','/system/auth/deptList','GET')  
    36. 

  36. 2021-09-14 20:56:35.894 [DEBU] [ 13 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`status`,`method`,`request_method`,`json_result`,`oper_param`,`operator_type`,`oper_name`,`oper_url`,`oper_ip`,`oper_time`,`title`,`dept_name`) VALUES('内网IP',1,'/system/config/dict/data/GetDictData','GET','{"code":0,"msg":"success"}','{"defaultValue":"","dictType":"sys_normal_disable"}',1,'demo','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','[::1]','2021-09-14 20:56:35','','财务部门')  
    37. 

  37. 2021-09-14 20:56:41.147 [DEBU] [  4 ms] [default] SELECT `dept_id`,`parent_id`,`ancestors`,`dept_name`,`order_num`,`leader`,`phone`,`email`,`status`,`created_by`,`updated_by`,`created_at`,`updated_at`,`deleted_at` FROM `sys_dept` WHERE `deleted_at` IS NULL 
    38. 

  38. 2021-09-14 20:56:41.153 [DEBU] [  9 ms] [default] SELECT `dept_id`,`parent_id`,`ancestors`,`dept_name`,`order_num`,`leader`,`phone`,`email`,`status`,`created_by`,`updated_by`,`created_at`,`updated_at`,`deleted_at` FROM `sys_dept` WHERE (`dept_id`=108) AND `deleted_at` IS NULL LIMIT 1 
    39. 

  39. 2021-09-14 20:56:41.171 [DEBU] [  7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    40. 

  40. 2021-09-14 20:56:41.172 [DEBU] [  7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    41. 

  41. 2021-09-14 20:56:41.187 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`oper_param`,`operator_type`,`oper_ip`,`oper_time`,`status`,`title`,`request_method`,`dept_name`,`oper_url`,`json_result`,`method`,`oper_location`) VALUES('demo','{"excludeId":"108"}',1,'[::1]','2021-09-14 20:56:41',1,'部门管理','GET','财务部门','/system/auth/deptList?excludeId=108','{"code":0,"msg":"success"}','/system/auth/deptList','内网IP')  
    42. 

  42. 2021-09-14 20:56:41.194 [DEBU] [ 21 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`dept_name`,`request_method`,`oper_ip`,`json_result`,`method`,`operator_type`,`oper_name`,`oper_location`,`oper_time`,`title`,`status`,`oper_param`) VALUES('/system/auth/deptGet?id=108','财务部门','GET','[::1]','{"code":0,"msg":"success"}','/system/auth/deptGet',1,'demo','内网IP','2021-09-14 20:56:41','',1,'{"id":"108"}')  
    43. 

  43. 2021-09-14 20:56:50.506 [DEBU] [ 16 ms] [default] SELECT COUNT(1) FROM `sys_role` 
    44. 

  44. 2021-09-14 20:56:50.510 [DEBU] [  3 ms] [default] SELECT `id`,`status`,`list_order`,`name`,`remark`,`data_scope` FROM `sys_role` ORDER BY `id` asc LIMIT 0,10 
    45. 

  45. 2021-09-14 20:56:50.526 [DEBU] [ 24 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    46. 

  46. 2021-09-14 20:56:50.540 [DEBU] [ 12 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    47. 

  47. 2021-09-14 20:56:50.555 [DEBU] [ 28 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`request_method`,`oper_location`,`oper_time`,`method`,`operator_type`,`dept_name`,`status`,`oper_ip`,`oper_url`,`title`,`oper_name`,`json_result`) VALUES('{"defaultValue":"","dictType":"sys_normal_disable"}','GET','内网IP','2021-09-14 20:56:50','/system/config/dict/data/GetDictData',1,'财务部门',1,'[::1]','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','','demo','{"code":0,"msg":"success"}')  
    48. 

  48. 2021-09-14 20:56:50.565 [DEBU] [ 23 ms] [default] INSERT INTO `sys_oper_log`(`method`,`request_method`,`operator_type`,`oper_name`,`dept_name`,`oper_ip`,`oper_location`,`title`,`oper_time`,`oper_url`,`json_result`,`status`,`oper_param`) VALUES('/system/auth/roleList','GET',1,'demo','财务部门','[::1]','内网IP','角色管理','2021-09-14 20:56:50','/system/auth/roleList?pageNum=1&pageSize=10&beginTime=&endTime=','{"code":0,"msg":"success"}',1,'{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}')  
    49. 

  49. 2021-09-14 20:56:53.728 [DEBU] [  4 ms] [default] SELECT * FROM `sys_role` WHERE id = 2 LIMIT 1 
    50. 

  50. 2021-09-14 20:56:53.753 [DEBU] [  8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    51. 

  51. 2021-09-14 20:56:53.767 [DEBU] [ 14 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_time`,`oper_param`,`oper_ip`,`oper_location`,`request_method`,`operator_type`,`dept_name`,`title`,`oper_url`,`oper_name`,`status`,`json_result`) VALUES('/system/auth/editRole','2021-09-14 20:56:53','{"roleId":"2"}','[::1]','内网IP','GET',1,'财务部门','修改角色','/system/auth/editRole?roleId=2','demo',1,'{"code":0,"msg":"success"}')  
    52. 

  52. 2021-09-14 20:57:10.818 [DEBU] [  7 ms] [default] SELECT * FROM `sys_role` WHERE id = 2 LIMIT 1 
    53. 

  53. 2021-09-14 20:57:10.822 [DEBU] [  6 ms] [default] SELECT `dept_id`,`parent_id`,`ancestors`,`dept_name`,`order_num`,`leader`,`phone`,`email`,`status`,`created_by`,`updated_by`,`created_at`,`updated_at`,`deleted_at` FROM `sys_dept` WHERE (`status`='1') AND `deleted_at` IS NULL 
    54. 

  54. 2021-09-14 20:57:10.828 [DEBU] [  4 ms] [default] SHOW FULL COLUMNS FROM `sys_role_dept` 
    55. 

  55. 2021-09-14 20:57:10.836 [DEBU] [  8 ms] [default] SELECT `role_id`,`dept_id` FROM `sys_role_dept` WHERE `role_id`=2 
    56. 

  56. 2021-09-14 20:57:10.845 [DEBU] [  9 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    57. 

  57. 2021-09-14 20:57:10.854 [DEBU] [  8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    58. 

  58. 2021-09-14 20:57:10.861 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`oper_url`,`oper_name`,`dept_name`,`oper_location`,`method`,`json_result`,`oper_ip`,`title`,`request_method`,`operator_type`,`status`,`oper_param`) VALUES('2021-09-14 20:57:10','/system/auth/editRole?roleId=2','demo','财务部门','内网IP','/system/auth/editRole','{"code":0,"msg":"success"}','[::1]','修改角色','GET',1,1,'{"roleId":"2"}')  
    59. 

  59. 2021-09-14 20:57:10.871 [DEBU] [ 16 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_ip`,`operator_type`,`dept_name`,`oper_url`,`status`,`json_result`,`oper_param`,`oper_time`,`request_method`,`title`,`oper_name`,`oper_location`) VALUES('/system/auth/roleDeptTreeSelect','[::1]',1,'财务部门','/system/auth/roleDeptTreeSelect?roleId=2',1,'{"code":0,"msg":"success"}','{"roleId":"2"}','2021-09-14 20:57:10','GET','','demo','内网IP')  
    60. 

  60. 2021-09-14 20:57:46.913 [DEBU] [ 10 ms] [default] [1] BEGIN 
    61. 

  61. 2021-09-14 20:57:46.918 [DEBU] [  5 ms] [default] [1] UPDATE `sys_role` SET `data_scope`=2 WHERE `id`=2 
    62. 

  62. 2021-09-14 20:57:46.924 [DEBU] [  6 ms] [default] [1] DELETE FROM `sys_role_dept` WHERE `role_id`=2 
    63. 

  63. 2021-09-14 20:57:46.929 [DEBU] [  4 ms] [default] [1] INSERT INTO `sys_role_dept`(`dept_id`,`role_id`) VALUES(106,2)  
    64. 

  64. 2021-09-14 20:57:46.939 [DEBU] [  9 ms] [default] [1] COMMIT 
    65. 

  65. 2021-09-14 20:57:46.980 [DEBU] [  7 ms] [default] SHOW FULL COLUMNS FROM `sys_auth_rule` 
    66. 

  66. 2021-09-14 20:57:46.990 [DEBU] [  9 ms] [default] SELECT `id`,`pid`,`name`,`title`,`icon`,`condition`,`remark`,`menu_type`,`weigh`,`status`,`always_show`,`path`,`jump_path`,`component`,`is_frame`,`module_type`,`model_id` FROM `sys_auth_rule` WHERE `deleted_at` IS NULL ORDER BY `weigh` desc,`id` asc 
    67. 

  67. 2021-09-14 20:57:47.019 [DEBU] [  5 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    68. 

  68. 2021-09-14 20:57:47.033 [DEBU] [ 13 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_time`,`oper_param`,`oper_location`,`status`,`operator_type`,`oper_name`,`oper_ip`,`title`,`method`,`request_method`,`json_result`,`oper_url`) VALUES('财务部门','2021-09-14 20:57:47','{"dataScope":"2","deptCheckStrictly":false,"deptIds":[106],"menuCheckStrictly":false,"menuIds":[1,5,19,20,21,22,23,24,25,6,41,42,43,2,8,16,17,18,26,27,29,30,31,28,33,40,50,52,53,3,34,36,37,38,39,4,32,35,96,97,98,124,126],"remark":"备注","roleId":2,"roleName":"普通管理员","roleSort":0,"status":"1"}','内网IP',1,1,'demo','[::1]','','/system/auth/roleDataScope','PUT','{"code":0,"msg":"success"}','/system/auth/roleDataScope')  
    69. 

  69. 2021-09-14 20:57:47.061 [DEBU] [  4 ms] [default] SELECT COUNT(1) FROM `sys_role` 
    70. 

  70. 2021-09-14 20:57:47.065 [DEBU] [  3 ms] [default] SELECT `id`,`status`,`list_order`,`name`,`remark`,`data_scope` FROM `sys_role` ORDER BY `id` asc LIMIT 0,10 
    71. 

  71. 2021-09-14 20:57:47.086 [DEBU] [  8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    72. 

  72. 2021-09-14 20:57:47.102 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_param`,`title`,`status`,`oper_ip`,`oper_location`,`request_method`,`oper_name`,`oper_time`,`oper_url`,`method`,`dept_name`,`json_result`) VALUES(1,'{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','角色管理',1,'[::1]','内网IP','GET','demo','2021-09-14 20:57:47','/system/auth/roleList?pageNum=1&pageSize=10&beginTime=&endTime=','/system/auth/roleList','财务部门','{"code":0,"msg":"success"}')  
    73. 

  73. 2021-09-14 21:00:05.674 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    74. 

  74. 2021-09-14 21:00:05.679 [DEBU] [  5 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    75. 

  75. 2021-09-14 21:10:05.656 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    76. 

  76. 2021-09-14 21:10:05.660 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    77. 

  77. 2021-09-14 21:20:05.623 [DEBU] [ 10 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    78. 

  78. 2021-09-14 21:20:05.626 [DEBU] [  3 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    79. 

  79. 2021-09-14 21:30:05.493 [DEBU] [  8 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    80. 

  80. 2021-09-14 21:30:05.495 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    81. 

  81. 2021-09-14 21:40:05.590 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    82. 

  82. 2021-09-14 21:40:05.593 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    83. 

  83. 2021-09-14 21:50:05.567 [DEBU] [ 10 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    84. 

  84. 2021-09-14 21:50:05.569 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    85. 

  85. 2021-09-14 22:00:05.545 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    86. 

  86. 2021-09-14 22:00:05.551 [DEBU] [  5 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    87. 

  87. 2021-09-14 22:10:05.504 [DEBU] [  8 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    88. 

  88. 2021-09-14 22:10:05.507 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    89. 

  89. 2021-09-14 22:18:26.498 [DEBU] [ 12 ms] [default] SELECT * FROM `sys_role` WHERE id = 2 LIMIT 1 
    90. 

  90. 2021-09-14 22:18:26.502 [DEBU] [ 12 ms] [default] SELECT `dept_id`,`parent_id`,`ancestors`,`dept_name`,`order_num`,`leader`,`phone`,`email`,`status`,`created_by`,`updated_by`,`created_at`,`updated_at`,`deleted_at` FROM `sys_dept` WHERE (`status`='1') AND `deleted_at` IS NULL 
    91. 

  91. 2021-09-14 22:18:26.509 [DEBU] [  6 ms] [default] SELECT `role_id`,`dept_id` FROM `sys_role_dept` WHERE `role_id`=2 
    92. 

  92. 2021-09-14 22:18:26.524 [DEBU] [  7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    93. 

  93. 2021-09-14 22:18:26.529 [DEBU] [  8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    94. 

  94. 2021-09-14 22:18:26.543 [DEBU] [ 18 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`operator_type`,`oper_name`,`dept_name`,`status`,`json_result`,`oper_param`,`title`,`oper_location`,`oper_ip`,`oper_url`,`method`,`oper_time`) VALUES('GET',1,'demo','财务部门',1,'{"code":0,"msg":"success"}','{"roleId":"2"}','修改角色','内网IP','[::1]','/system/auth/editRole?roleId=2','/system/auth/editRole','2021-09-14 22:18:26')  
    95. 

  95. 2021-09-14 22:18:26.548 [DEBU] [ 18 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_location`,`oper_time`,`oper_url`,`json_result`,`method`,`request_method`,`operator_type`,`oper_name`,`status`,`title`,`dept_name`,`oper_param`) VALUES('[::1]','内网IP','2021-09-14 22:18:26','/system/auth/roleDeptTreeSelect?roleId=2','{"code":0,"msg":"success"}','/system/auth/roleDeptTreeSelect','GET',1,'demo',1,'','财务部门','{"roleId":"2"}')  
    96. 

  96. 2021-09-14 22:19:05.101 [DEBU] [  8 ms] [default] [2] BEGIN 
    97. 

  97. 2021-09-14 22:19:05.105 [DEBU] [  4 ms] [default] [2] UPDATE `sys_role` SET `data_scope`=2 WHERE `id`=2 
    98. 

  98. 2021-09-14 22:19:05.110 [DEBU] [  4 ms] [default] [2] DELETE FROM `sys_role_dept` WHERE `role_id`=2 
    99. 

  99. 2021-09-14 22:19:05.116 [DEBU] [  5 ms] [default] [2] INSERT INTO `sys_role_dept`(`role_id`,`dept_id`) VALUES(2,104),(2,106)  
    100. 

  100. 2021-09-14 22:19:05.123 [DEBU] [  7 ms] [default] [2] COMMIT 
    101. 

  101. 2021-09-14 22:19:05.162 [DEBU] [  8 ms] [default] SELECT `id`,`pid`,`name`,`title`,`icon`,`condition`,`remark`,`menu_type`,`weigh`,`status`,`always_show`,`path`,`jump_path`,`component`,`is_frame`,`module_type`,`model_id` FROM `sys_auth_rule` WHERE `deleted_at` IS NULL ORDER BY `weigh` desc,`id` asc 
    102. 

  102. 2021-09-14 22:19:05.193 [DEBU] [  6 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    103. 

  103. 2021-09-14 22:19:05.204 [DEBU] [ 11 ms] [default] INSERT INTO `sys_oper_log`(`title`,`request_method`,`oper_name`,`oper_url`,`json_result`,`dept_name`,`oper_location`,`status`,`oper_param`,`oper_time`,`method`,`operator_type`,`oper_ip`) VALUES('','PUT','demo','/system/auth/roleDataScope','{"code":0,"msg":"success"}','财务部门','内网IP',1,'{"dataScope":"2","deptCheckStrictly":false,"deptIds":[104,106],"menuCheckStrictly":false,"menuIds":[1,5,19,20,21,22,23,24,25,6,41,42,43,2,8,16,17,18,26,27,29,30,31,28,33,40,50,52,53,3,34,36,37,38,39,4,32,35,96,97,98,124,126],"remark":"备注","roleId":2,"roleName":"普通管理员","roleSort":0,"status":"1"}','2021-09-14 22:19:05','/system/auth/roleDataScope',1,'[::1]')  
    104. 

  104. 2021-09-14 22:19:05.234 [DEBU] [  5 ms] [default] SELECT COUNT(1) FROM `sys_role` 
    105. 

  105. 2021-09-14 22:19:05.239 [DEBU] [  5 ms] [default] SELECT `id`,`status`,`list_order`,`name`,`remark`,`data_scope` FROM `sys_role` ORDER BY `id` asc LIMIT 0,10 
    106. 

  106. 2021-09-14 22:19:05.266 [DEBU] [ 13 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    107. 

  107. 2021-09-14 22:19:05.284 [DEBU] [ 17 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_time`,`oper_url`,`json_result`,`request_method`,`oper_location`,`method`,`operator_type`,`oper_param`,`oper_name`,`status`,`title`,`dept_name`) VALUES('[::1]','2021-09-14 22:19:05','/system/auth/roleList?pageNum=1&pageSize=10&beginTime=&endTime=','{"code":0,"msg":"success"}','GET','内网IP','/system/auth/roleList',1,'{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','demo',1,'角色管理','财务部门')  
    108. 

  108. 2021-09-14 22:20:05.504 [DEBU] [ 11 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    109. 

  109. 2021-09-14 22:20:05.507 [DEBU] [  3 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    110. 

  110. 2021-09-14 22:25:07.589 [DEBU] [ 16 ms] [default] SHOW FULL COLUMNS FROM `sys_post` 
    111. 

  111. 2021-09-14 22:25:07.607 [DEBU] [ 17 ms] [default] SELECT COUNT(1) FROM `sys_post` WHERE `deleted_at` IS NULL 
    112. 

  112. 2021-09-14 22:25:07.610 [DEBU] [  2 ms] [default] SELECT `post_id`,`post_code`,`post_name`,`post_sort`,`status`,`remark`,`created_by`,`updated_by`,`created_at`,`updated_at`,`deleted_at` FROM `sys_post` WHERE `deleted_at` IS NULL ORDER BY `post_sort` asc,`post_id` asc LIMIT 0,10 
    113. 

  113. 2021-09-14 22:25:07.611 [DEBU] [ 21 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    114. 

  114. 2021-09-14 22:25:07.627 [DEBU] [ 16 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`json_result`,`oper_param`,`oper_time`,`status`,`oper_location`,`title`,`method`,`dept_name`,`operator_type`,`oper_name`,`oper_url`,`oper_ip`) VALUES('GET','{"code":0,"msg":"success"}','{"defaultValue":"","dictType":"sys_normal_disable"}','2021-09-14 22:25:07',1,'内网IP','','/system/config/dict/data/GetDictData','财务部门',1,'demo','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','[::1]')  
    115. 

  115. 2021-09-14 22:25:07.633 [DEBU] [ 10 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 
    116. 

  116. 2021-09-14 22:25:07.650 [DEBU] [ 17 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`dept_name`,`oper_location`,`status`,`method`,`oper_name`,`oper_time`,`json_result`,`oper_ip`,`request_method`,`title`,`oper_url`,`oper_param`) VALUES(1,'财务部门','内网IP',1,'/system/auth/postList','demo','2021-09-14 22:25:07','{"code":0,"msg":"success"}','[::1]','GET','岗位管理','/system/auth/postList?pageNum=1&pageSize=10','{"pageNum":"1","pageSize":"10"}')  
    117. 

  117. 2021-09-14 22:30:05.470 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    118. 

  118. 2021-09-14 22:30:05.472 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    119. 

  119. 2021-09-14 22:40:05.445 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    120. 

  120. 2021-09-14 22:40:05.448 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    121. 

  121. 2021-09-14 22:50:05.425 [DEBU] [ 11 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    122. 

  122. 2021-09-14 22:50:05.428 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    123. 

  123. 2021-09-14 23:20:05.916 [DEBU] [ 10 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    124. 

  124. 2021-09-14 23:20:05.922 [DEBU] [  6 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    125. 

  125. 2021-09-14 23:30:05.895 [DEBU] [  8 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    126. 

  126. 2021-09-14 23:30:05.899 [DEBU] [  3 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    127. 

  127. 2021-09-14 23:40:05.875 [DEBU] [  9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    128. 

  128. 2021-09-14 23:40:05.877 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    129. 

  129. 2021-09-14 23:50:05.857 [DEBU] [ 11 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 
    130. 

  130. 2021-09-14 23:50:05.859 [DEBU] [  2 ms] [default] SELECT `id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os` FROM `sys_user_online` ORDER BY `create_time` DESC LIMIT 0,50 
    131.