2021-09-12 16:56:14.200 [DEBU] [ 14 ms] [default] SHOW FULL COLUMNS FROM `sys_job` 2021-09-12 16:56:14.214 [DEBU] [ 13 ms] [default] SELECT `job_id`,`job_name`,`job_params`,`job_group`,`invoke_target`,`cron_expression`,`misfire_policy`,`concurrent`,`status`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_job` WHERE (`status`=0) AND `deleted_at` IS NULL 2021-09-12 16:56:14.220 [DEBU] [ 5 ms] [default] UPDATE `sys_job` SET `status`=0 WHERE `job_id`=8 2021-09-12 16:59:39.709 [DEBU] [ 20 ms] [default] SHOW FULL COLUMNS FROM `sys_user` 2021-09-12 16:59:39.717 [DEBU] [ 8 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 2021-09-12 16:59:39.727 [DEBU] [ 9 ms] [default] UPDATE `sys_user` SET `last_login_ip`='[::1]',`last_login_time`='2021-09-12 16:59:39' WHERE `id`=31 2021-09-12 16:59:39.739 [DEBU] [ 11 ms] [default] SHOW FULL COLUMNS FROM `sys_login_log` 2021-09-12 16:59:39.755 [DEBU] [ 15 ms] [default] SHOW FULL COLUMNS FROM `sys_user_online` 2021-09-12 16:59:39.756 [DEBU] [ 16 ms] [default] INSERT INTO `sys_login_log`(`info_id`,`login_location`,`msg`,`module`,`login_name`,`ipaddr`,`browser`,`os`,`status`,`login_time`) VALUES(0,'内网IP','登录成功','系统后台','demo','[::1]','Chrome','Intel Mac OS X 11_2_3',1,'2021-09-12 16:59:39') 2021-09-12 16:59:39.759 [DEBU] [ 4 ms] [default] SHOW FULL COLUMNS FROM `sys_role` 2021-09-12 16:59:39.764 [DEBU] [ 5 ms] [default] SELECT * FROM `sys_role` ORDER BY `list_order` asc,`id` asc 2021-09-12 16:59:39.769 [DEBU] [ 9 ms] [default] SELECT `id` FROM `sys_user_online` WHERE `token`='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv6ebYBJG/d6XljHiHXijdUDenBu+qc8gkG5PEDUf5luJJAlkCi1Yq+iIfQQeZY0U1g==' LIMIT 1 2021-09-12 16:59:39.774 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule` 2021-09-12 16:59:39.780 [DEBU] [ 6 ms] [default] SELECT `ptype`,`v0`,`v1`,`v2`,`v3`,`v4`,`v5` FROM `casbin_rule` 2021-09-12 16:59:39.793 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `sys_auth_rule` 2021-09-12 16:59:39.797 [DEBU] [ 22 ms] [default] INSERT INTO `sys_user_online`(`ip`,`explorer`,`os`,`uuid`,`token`,`create_time`,`user_name`) VALUES('[::1]','Chrome','Intel Mac OS X 11_2_3','415dc797ef74df332b86575c27cd7efa','oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv6ebYBJG/d6XljHiHXijdUDenBu+qc8gkG5PEDUf5luJJAlkCi1Yq+iIfQQeZY0U1g==','2021-09-12 16:59:39','demo') 2021-09-12 16:59:39.800 [DEBU] [ 6 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 2021-09-12 16:59:39.810 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `sys_dept` 2021-09-12 16:59:39.817 [DEBU] [ 3 ms] [default] SELECT * FROM `sys_role` ORDER BY `list_order` asc,`id` asc 2021-09-12 16:59:39.819 [DEBU] [ 8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:39.824 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log` 2021-09-12 16:59:39.828 [DEBU] [ 4 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 2021-09-12 16:59:39.834 [DEBU] [ 10 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_ip`,`oper_time`,`json_result`,`title`,`request_method`,`oper_name`,`oper_param`,`oper_url`,`dept_name`,`oper_location`,`status`,`operator_type`) VALUES('/system/user/getInfo','[::1]','2021-09-12 16:59:39','{"code":0,"msg":"success"}','','GET','demo','{}','/system/user/getInfo','财务部门','内网IP',1,1) 2021-09-12 16:59:39.841 [DEBU] [ 3 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 2021-09-12 16:59:39.853 [DEBU] [ 5 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:39.865 [DEBU] [ 12 ms] [default] INSERT INTO `sys_oper_log`(`title`,`operator_type`,`oper_ip`,`oper_url`,`json_result`,`status`,`oper_param`,`dept_name`,`method`,`request_method`,`oper_name`,`oper_location`,`oper_time`) VALUES('',1,'[::1]','/system/user/getRouters','{"code":0,"msg":"success"}',1,'{}','财务部门','/system/user/getRouters','GET','demo','内网IP','2021-09-12 16:59:39') 2021-09-12 16:59:47.282 [DEBU] [ 11 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type` 2021-09-12 16:59:47.286 [DEBU] [ 4 ms] [default] SELECT COUNT(1) FROM `sys_dict_type` WHERE `deleted_at` IS NULL 2021-09-12 16:59:47.290 [DEBU] [ 3 ms] [default] SELECT `dict_id`,`dict_name`,`dict_type`,`status`,`remark`,`created_at` FROM `sys_dict_type` WHERE `deleted_at` IS NULL ORDER BY `dict_id` asc LIMIT 0,10 2021-09-12 16:59:47.290 [DEBU] [ 8 ms] [default] SELECT `dict_name`,`remark` FROM `sys_dict_type` WHERE ((`dict_type`='sys_normal_disable') AND (`status`=1)) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:47.305 [DEBU] [ 14 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data` 2021-09-12 16:59:47.310 [DEBU] [ 4 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 2021-09-12 16:59:47.313 [DEBU] [ 7 ms] [default] SELECT `dict_value`,`dict_label`,`is_default`,`remark` FROM `sys_dict_data` WHERE (`dict_type`='sys_normal_disable') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc 2021-09-12 16:59:47.325 [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 2021-09-12 16:59:47.345 [DEBU] [ 21 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:47.351 [DEBU] [ 11 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:47.363 [DEBU] [ 17 ms] [default] INSERT INTO `sys_oper_log`(`title`,`oper_location`,`method`,`operator_type`,`oper_ip`,`oper_name`,`dept_name`,`status`,`json_result`,`oper_param`,`request_method`,`oper_time`,`oper_url`) VALUES('字典管理','内网IP','/system/config/dict/type/list',1,'[::1]','demo','财务部门',1,'{"code":0,"msg":"success"}','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','GET','2021-09-12 16:59:47','/system/config/dict/type/list?pageNum=1&pageSize=10&beginTime=&endTime=') 2021-09-12 16:59:47.376 [DEBU] [ 24 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_param`,`method`,`request_method`,`oper_location`,`oper_time`,`oper_url`,`status`,`title`,`operator_type`,`dept_name`,`oper_name`,`json_result`) VALUES('[::1]','{"defaultValue":"","dictType":"sys_normal_disable"}','/system/config/dict/data/GetDictData','GET','内网IP','2021-09-12 16:59:47','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=',1,'',1,'财务部门','demo','{"code":0,"msg":"success"}') 2021-09-12 16:59:49.265 [DEBU] [ 9 ms] [default] SHOW FULL COLUMNS FROM `sys_config` 2021-09-12 16:59:49.276 [DEBU] [ 10 ms] [default] SELECT `dict_name`,`remark` FROM `sys_dict_type` WHERE ((`dict_type`='sys_yes_no') AND (`status`=1)) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:49.277 [DEBU] [ 12 ms] [default] SELECT COUNT(1) FROM `sys_config` WHERE `deleted_at` IS NULL 2021-09-12 16:59:49.284 [DEBU] [ 7 ms] [default] SELECT `config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_config` WHERE `deleted_at` IS NULL ORDER BY `config_id` asc LIMIT 0,10 2021-09-12 16:59:49.289 [DEBU] [ 13 ms] [default] SELECT `dict_value`,`dict_label`,`is_default`,`remark` FROM `sys_dict_data` WHERE (`dict_type`='sys_yes_no') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc 2021-09-12 16:59:49.291 [DEBU] [ 5 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 2021-09-12 16:59:49.296 [DEBU] [ 5 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 2021-09-12 16:59:49.314 [DEBU] [ 13 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:49.320 [DEBU] [ 12 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:49.333 [DEBU] [ 19 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`status`,`oper_url`,`json_result`,`method`,`operator_type`,`dept_name`,`oper_ip`,`oper_param`,`title`,`oper_location`,`oper_time`,`request_method`) VALUES('demo',1,'/system/config/sysConfig/list?pageNum=1&pageSize=10&beginTime=&endTime=','{"code":0,"msg":"success"}','/system/config/sysConfig/list',1,'财务部门','[::1]','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','参数管理','内网IP','2021-09-12 16:59:49','GET') 2021-09-12 16:59:49.342 [DEBU] [ 22 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_time`,`oper_ip`,`oper_url`,`title`,`method`,`operator_type`,`status`,`oper_param`,`request_method`,`oper_name`,`oper_location`,`json_result`) VALUES('财务部门','2021-09-12 16:59:49','[::1]','/system/config/dict/data/GetDictData?dictType=sys_yes_no&defaultValue=','','/system/config/dict/data/GetDictData',1,1,'{"defaultValue":"","dictType":"sys_yes_no"}','GET','demo','内网IP','{"code":0,"msg":"success"}') 2021-09-12 16:59:51.571 [DEBU] [ 9 ms] [default] SHOW FULL COLUMNS FROM `sys_web_set` 2021-09-12 16:59:51.574 [DEBU] [ 3 ms] [default] SELECT `web_id`,`web_content` FROM `sys_web_set` LIMIT 0,1 2021-09-12 16:59:51.579 [DEBU] [ 4 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 2021-09-12 16:59:51.595 [DEBU] [ 5 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 16:59:51.609 [DEBU] [ 14 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`json_result`,`request_method`,`oper_ip`,`oper_location`,`status`,`title`,`oper_name`,`oper_param`,`method`,`dept_name`,`oper_url`,`operator_type`) VALUES('2021-09-12 16:59:51','{"code":0,"msg":"success"}','GET','[::1]','内网IP',1,'站点设置','demo','{}','/system/config/sysWebSet','财务部门','/system/config/sysWebSet',1) 2021-09-12 17:00:05.200 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 17:00:05.207 [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 2021-09-12 17:00:09.967 [DEBU] [ 27 ms] [default] SELECT `config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_config` WHERE (`config_key`='sys.uploadFile.imageType') AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:00:09.977 [DEBU] [ 6 ms] [default] SELECT `config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_config` WHERE (`config_key`='sys.uploadFile.imageSize') AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:00:09.991 [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 2021-09-12 17:00:10.010 [DEBU] [ 11 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:00:10.025 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_location`,`oper_time`,`json_result`,`operator_type`,`oper_name`,`oper_param`,`request_method`,`status`,`title`,`method`,`dept_name`,`oper_url`) VALUES('[::1]','内网IP','2021-09-12 17:00:10','{"code":0,"msg":"success"}',1,'demo','{"token":"oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv6ebYBJG/d6XljHiHXijdUDenBu+qc8gkG5PEDUf5luJJAlkCi1Yq+iIfQQeZY0U1g=="}','POST',1,'','/system/upload/upImg','财务部门','/system/upload/upImg') 2021-09-12 17:00:13.527 [DEBU] [ 10 ms] [default] UPDATE `sys_web_set` SET `web_content`='{"CopyrightInfo":"11122","recordInfo":"111222","statisticsCode":"11122","webId":1,"webLogo":"pub_upload/2021-09-12/ce7s83oqb2xc9zgtz6.jpeg","webName":"gfast","webSite":"http://localhost/index#/webSet"}' WHERE `web_id`=1 2021-09-12 17:00:13.535 [DEBU] [ 6 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 2021-09-12 17:00:13.550 [DEBU] [ 6 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:00:13.562 [DEBU] [ 11 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_time`,`oper_url`,`json_result`,`method`,`dept_name`,`oper_location`,`oper_param`,`oper_ip`,`status`,`title`,`request_method`,`oper_name`) VALUES(1,'2021-09-12 17:00:13','/system/config/sysWebSet/update','{"code":0,"msg":"success"}','/system/config/sysWebSet/update','财务部门','内网IP','{"webContent":{"CopyrightInfo":"11122","recordInfo":"111222","statisticsCode":"11122","webId":1,"webLogo":"pub_upload/2021-09-12/ce7s83oqb2xc9zgtz6.jpeg","webName":"gfast","webSite":"http://localhost/index#/webSet"},"webId":1}','[::1]',1,'站点配置更新','POST','demo') 2021-09-12 17:00:18.601 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `sys_config` WHERE `deleted_at` IS NULL 2021-09-12 17:00:18.605 [DEBU] [ 3 ms] [default] SELECT `config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_config` WHERE `deleted_at` IS NULL ORDER BY `config_id` asc LIMIT 0,10 2021-09-12 17:00:18.611 [DEBU] [ 4 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 2021-09-12 17:00:18.614 [DEBU] [ 18 ms] [default] SELECT `dict_name`,`remark` FROM `sys_dict_type` WHERE ((`dict_type`='sys_yes_no') AND (`status`=1)) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:00:18.622 [DEBU] [ 7 ms] [default] SELECT `dict_value`,`dict_label`,`is_default`,`remark` FROM `sys_dict_data` WHERE (`dict_type`='sys_yes_no') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc 2021-09-12 17:00:18.626 [DEBU] [ 8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:00:18.628 [DEBU] [ 4 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 2021-09-12 17:00:18.645 [DEBU] [ 19 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_param`,`oper_name`,`oper_ip`,`title`,`oper_url`,`json_result`,`operator_type`,`oper_location`,`status`,`method`,`request_method`,`oper_time`) VALUES('财务部门','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','demo','[::1]','参数管理','/system/config/sysConfig/list?pageNum=1&pageSize=10&beginTime=&endTime=','{"code":0,"msg":"success"}',1,'内网IP',1,'/system/config/sysConfig/list','GET','2021-09-12 17:00:18') 2021-09-12 17:00:18.646 [DEBU] [ 8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:00:18.661 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`operator_type`,`oper_location`,`status`,`json_result`,`oper_name`,`dept_name`,`oper_param`,`request_method`,`method`,`title`,`oper_time`,`oper_url`) VALUES('[::1]',1,'内网IP',1,'{"code":0,"msg":"success"}','demo','财务部门','{"defaultValue":"","dictType":"sys_yes_no"}','GET','/system/config/dict/data/GetDictData','','2021-09-12 17:00:18','/system/config/dict/data/GetDictData?dictType=sys_yes_no&defaultValue=') 2021-09-12 17:00:21.498 [DEBU] [ 4 ms] [default] SELECT `web_id`,`web_content` FROM `sys_web_set` LIMIT 0,1 2021-09-12 17:00:21.505 [DEBU] [ 4 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 2021-09-12 17:00:21.517 [DEBU] [ 5 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:00:21.532 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`oper_time`,`oper_location`,`oper_url`,`dept_name`,`json_result`,`operator_type`,`status`,`title`,`method`,`oper_name`,`oper_ip`,`oper_param`) VALUES('GET','2021-09-12 17:00:21','内网IP','/system/config/sysWebSet','财务部门','{"code":0,"msg":"success"}',1,1,'站点设置','/system/config/sysWebSet','demo','[::1]','{}') 2021-09-12 17:10:05.187 [DEBU] [ 10 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 17:10:05.190 [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 2021-09-12 17:16:52.698 [DEBU] [ 15 ms] [default] SELECT `dict_name`,`remark` FROM `sys_dict_type` WHERE ((`dict_type`='sys_normal_disable') AND (`status`=1)) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:16:52.699 [DEBU] [ 14 ms] [default] SELECT COUNT(1) FROM `sys_dict_data` WHERE (dict_type = 'sys_user_sex') AND `deleted_at` IS NULL 2021-09-12 17:16:52.708 [DEBU] [ 8 ms] [default] SELECT * FROM `sys_dict_data` WHERE (dict_type = 'sys_user_sex') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc LIMIT 0,10 2021-09-12 17:16:52.708 [DEBU] [ 9 ms] [default] SELECT `dict_value`,`dict_label`,`is_default`,`remark` FROM `sys_dict_data` WHERE (`dict_type`='sys_normal_disable') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc 2021-09-12 17:16:52.713 [DEBU] [ 4 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 2021-09-12 17:16:52.714 [DEBU] [ 3 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 2021-09-12 17:16:52.728 [DEBU] [ 7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:16:52.729 [DEBU] [ 9 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 17:16:52.743 [DEBU] [ 14 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`status`,`oper_location`,`oper_param`,`method`,`operator_type`,`json_result`,`title`,`request_method`,`oper_time`,`oper_url`,`oper_name`,`dept_name`) VALUES('[::1]',1,'内网IP','{"defaultValue":"","dictType":"sys_normal_disable"}','/system/config/dict/data/GetDictData',1,'{"code":0,"msg":"success"}','','GET','2021-09-12 17:16:52','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','demo','财务部门') 2021-09-12 17:16:52.749 [DEBU] [ 20 ms] [default] INSERT INTO `sys_oper_log`(`method`,`dept_name`,`status`,`title`,`request_method`,`oper_name`,`oper_ip`,`oper_param`,`operator_type`,`oper_time`,`oper_location`,`oper_url`,`json_result`) VALUES('/system/config/dict/data/list','财务部门',1,'字典数据管理','GET','demo','[::1]','{"dictType":"sys_user_sex","pageNum":"1","pageSize":"10"}',1,'2021-09-12 17:16:52','内网IP','/system/config/dict/data/list?pageNum=1&pageSize=10&dictType=sys_user_sex','{"code":0,"msg":"success"}') 2021-09-12 17:20:05.172 [DEBU] [ 15 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 17:20:05.174 [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 2021-09-12 17:30:05.118 [ERRO] [ 1 ms] [default] SELECT COUNT(1) FROM `sys_user_online` Error: dial tcp [::1]:3306: connect: connection refused Stack: 1. gfast/app/system/service.(*online).GetOnlineListPage /Users/apple/work/code/go/gfastv2/gfast/app/system/service/sys_user_online.go:59 2. gfast/app/system/api.(*auth).CheckUserOnline /Users/apple/work/code/go/gfastv2/gfast/app/system/api/auth.go:165 2021-09-12 17:40:05.090 [ERRO] [ 1 ms] [default] SELECT COUNT(1) FROM `sys_user_online` Error: dial tcp [::1]:3306: connect: connection refused Stack: 1. gfast/app/system/service.(*online).GetOnlineListPage /Users/apple/work/code/go/gfastv2/gfast/app/system/service/sys_user_online.go:59 2. gfast/app/system/api.(*auth).CheckUserOnline /Users/apple/work/code/go/gfastv2/gfast/app/system/api/auth.go:165 2021-09-12 18:40:05.770 [ERRO] [ 1 ms] [default] SELECT COUNT(1) FROM `sys_user_online` Error: dial tcp [::1]:3306: connect: connection refused Stack: 1. gfast/app/system/service.(*online).GetOnlineListPage /Users/apple/work/code/go/gfastv2/gfast/app/system/service/sys_user_online.go:59 2. gfast/app/system/api.(*auth).CheckUserOnline /Users/apple/work/code/go/gfastv2/gfast/app/system/api/auth.go:165 2021-09-12 18:50:06.809 [DEBU] [1065 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 18:50:06.814 [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 2021-09-12 18:53:44.229 [DEBU] [ 20 ms] [default] SELECT * FROM `sys_role` ORDER BY `list_order` asc,`id` asc 2021-09-12 18:53:44.275 [DEBU] [ 12 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 2021-09-12 18:53:44.313 [DEBU] [ 11 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:53:44.342 [DEBU] [ 29 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`method`,`request_method`,`oper_url`,`oper_name`,`dept_name`,`oper_ip`,`status`,`title`,`oper_location`,`oper_time`,`operator_type`,`oper_param`) VALUES('{"code":0,"msg":"success"}','/system/user/getInfo','GET','/system/user/getInfo','demo','财务部门','[::1]',1,'','内网IP','2021-09-12 18:53:44',1,'{}') 2021-09-12 18:53:44.413 [DEBU] [ 18 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:53:44.443 [DEBU] [ 29 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`status`,`title`,`method`,`dept_name`,`oper_param`,`oper_ip`,`oper_location`,`json_result`,`operator_type`,`oper_time`,`oper_url`,`oper_name`) VALUES('GET',1,'','/system/user/getRouters','财务部门','{}','[::1]','内网IP','{"code":0,"msg":"success"}',1,'2021-09-12 18:53:44','/system/user/getRouters','demo') 2021-09-12 18:53:44.668 [DEBU] [ 17 ms] [default] SELECT COUNT(1) FROM `sys_dict_data` WHERE (dict_type = 'sys_user_sex') AND `deleted_at` IS NULL 2021-09-12 18:53:44.675 [DEBU] [ 7 ms] [default] SELECT * FROM `sys_dict_data` WHERE (dict_type = 'sys_user_sex') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc LIMIT 0,10 2021-09-12 18:53:44.701 [DEBU] [ 43 ms] [default] SELECT `dict_name`,`remark` FROM `sys_dict_type` WHERE ((`dict_type`='sys_normal_disable') AND (`status`=1)) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:53:44.702 [DEBU] [ 15 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:53:44.721 [DEBU] [ 19 ms] [default] SELECT `dict_value`,`dict_label`,`is_default`,`remark` FROM `sys_dict_data` WHERE (`dict_type`='sys_normal_disable') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc 2021-09-12 18:53:44.742 [DEBU] [ 40 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`oper_ip`,`json_result`,`method`,`dept_name`,`oper_name`,`title`,`status`,`oper_location`,`oper_url`,`request_method`,`operator_type`,`oper_param`) VALUES('2021-09-12 18:53:44','[::1]','{"code":0,"msg":"success"}','/system/config/dict/data/list','财务部门','demo','字典数据管理',1,'内网IP','/system/config/dict/data/list?pageNum=1&pageSize=10&dictType=sys_user_sex','GET',1,'{"dictType":"sys_user_sex","pageNum":"1","pageSize":"10"}') 2021-09-12 18:53:44.779 [DEBU] [ 10 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:53:44.793 [DEBU] [ 14 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_time`,`oper_url`,`dept_name`,`oper_ip`,`oper_location`,`status`,`request_method`,`oper_param`,`method`,`oper_name`,`json_result`,`title`) VALUES(1,'2021-09-12 18:53:44','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','财务部门','[::1]','内网IP',1,'GET','{"defaultValue":"","dictType":"sys_normal_disable"}','/system/config/dict/data/GetDictData','demo','{"code":0,"msg":"success"}','') 2021-09-12 18:54:39.015 [DEBU] [ 24 ms] [default] SHOW FULL COLUMNS FROM `sys_job` 2021-09-12 18:54:39.028 [DEBU] [ 12 ms] [default] SELECT `job_id`,`job_name`,`job_params`,`job_group`,`invoke_target`,`cron_expression`,`misfire_policy`,`concurrent`,`status`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_job` WHERE (`status`=0) AND `deleted_at` IS NULL 2021-09-12 18:54:39.041 [DEBU] [ 12 ms] [default] UPDATE `sys_job` SET `status`=0 WHERE `job_id`=8 2021-09-12 18:54:51.238 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `sys_user` 2021-09-12 18:54:51.252 [DEBU] [ 12 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 2021-09-12 18:54:51.260 [DEBU] [ 8 ms] [default] UPDATE `sys_user` SET `last_login_ip`='[::1]',`last_login_time`='2021-09-12 18:54:51' WHERE `id`=31 2021-09-12 18:54:51.271 [DEBU] [ 10 ms] [default] SHOW FULL COLUMNS FROM `sys_user_online` 2021-09-12 18:54:51.282 [DEBU] [ 11 ms] [default] SHOW FULL COLUMNS FROM `sys_login_log` 2021-09-12 18:54:51.305 [DEBU] [ 22 ms] [default] SELECT `id` FROM `sys_user_online` WHERE `token`='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv6+9opbt/3w/ovrTEhqelCbO7OvH4bZ6FaByJ4KPJFlXJe4TmaeNhOkoZeZU2krPPA==' LIMIT 1 2021-09-12 18:54:51.310 [DEBU] [ 24 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule` 2021-09-12 18:54:51.315 [DEBU] [ 32 ms] [default] INSERT INTO `sys_login_log`(`info_id`,`browser`,`os`,`msg`,`login_time`,`module`,`login_name`,`ipaddr`,`login_location`,`status`) VALUES(0,'Chrome','Intel Mac OS X 11_2_3','登录成功','2021-09-12 18:54:51','系统后台','demo','[::1]','内网IP',1) 2021-09-12 18:54:51.322 [DEBU] [ 11 ms] [default] SELECT `ptype`,`v0`,`v1`,`v2`,`v3`,`v4`,`v5` FROM `casbin_rule` 2021-09-12 18:54:51.336 [DEBU] [ 25 ms] [default] INSERT INTO `sys_user_online`(`create_time`,`user_name`,`ip`,`explorer`,`os`,`uuid`,`token`) VALUES('2021-09-12 18:54:51','demo','[::1]','Chrome','Intel Mac OS X 11_2_3','4a29eb789dea5951fec1cef144a0ab98','oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv6+9opbt/3w/ovrTEhqelCbO7OvH4bZ6FaByJ4KPJFlXJe4TmaeNhOkoZeZU2krPPA==') 2021-09-12 18:54:51.349 [DEBU] [ 9 ms] [default] SHOW FULL COLUMNS FROM `sys_dept` 2021-09-12 18:54:51.356 [DEBU] [ 7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:54:51.369 [DEBU] [ 13 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log` 2021-09-12 18:54:51.393 [DEBU] [ 23 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`dept_name`,`request_method`,`oper_name`,`title`,`method`,`operator_type`,`oper_ip`,`json_result`,`oper_param`,`oper_time`,`oper_url`,`status`) VALUES('内网IP','财务部门','GET','demo','','/system/user/getInfo',1,'[::1]','{"code":0,"msg":"success"}','{}','2021-09-12 18:54:51','/system/user/getInfo',1) 2021-09-12 18:54:51.400 [DEBU] [ 10 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:54:51.424 [DEBU] [ 23 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`oper_name`,`status`,`title`,`method`,`oper_location`,`request_method`,`dept_name`,`operator_type`,`oper_ip`,`oper_url`,`oper_param`,`json_result`) VALUES('2021-09-12 18:54:51','demo',1,'','/system/user/getRouters','内网IP','GET','财务部门',1,'[::1]','/system/user/getRouters','{}','{"code":0,"msg":"success"}') 2021-09-12 18:55:16.913 [DEBU] [ 9 ms] [default] SHOW FULL COLUMNS FROM `sys_config` 2021-09-12 18:55:16.923 [DEBU] [ 9 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type` 2021-09-12 18:55:16.931 [DEBU] [ 17 ms] [default] SELECT COUNT(1) FROM `sys_config` WHERE `deleted_at` IS NULL 2021-09-12 18:55:16.931 [DEBU] [ 7 ms] [default] SELECT `dict_name`,`remark` FROM `sys_dict_type` WHERE ((`dict_type`='sys_yes_no') AND (`status`=1)) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:16.935 [DEBU] [ 4 ms] [default] SELECT `config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_config` WHERE `deleted_at` IS NULL ORDER BY `config_id` asc LIMIT 0,10 2021-09-12 18:55:16.942 [DEBU] [ 10 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data` 2021-09-12 18:55:16.956 [DEBU] [ 13 ms] [default] SELECT `dict_value`,`dict_label`,`is_default`,`remark` FROM `sys_dict_data` WHERE (`dict_type`='sys_yes_no') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc 2021-09-12 18:55:16.972 [DEBU] [ 19 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:17.012 [DEBU] [ 39 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_name`,`method`,`request_method`,`status`,`json_result`,`title`,`dept_name`,`oper_location`,`oper_time`,`oper_param`,`oper_ip`,`oper_url`) VALUES(1,'demo','/system/config/sysConfig/list','GET',1,'{"code":0,"msg":"success"}','参数管理','财务部门','内网IP','2021-09-12 18:55:16','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','[::1]','/system/config/sysConfig/list?pageNum=1&pageSize=10&beginTime=&endTime=') 2021-09-12 18:55:17.024 [DEBU] [ 7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:17.037 [DEBU] [ 13 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`oper_url`,`operator_type`,`oper_name`,`dept_name`,`oper_location`,`request_method`,`oper_ip`,`json_result`,`oper_param`,`title`,`method`,`status`) VALUES('2021-09-12 18:55:17','/system/config/dict/data/GetDictData?dictType=sys_yes_no&defaultValue=',1,'demo','财务部门','内网IP','GET','[::1]','{"code":0,"msg":"success"}','{"defaultValue":"","dictType":"sys_yes_no"}','','/system/config/dict/data/GetDictData',1) 2021-09-12 18:55:24.218 [DEBU] [ 24 ms] [default] SHOW FULL COLUMNS FROM `sys_role` 2021-09-12 18:55:24.227 [DEBU] [ 8 ms] [default] SELECT COUNT(1) FROM `sys_role` 2021-09-12 18:55:24.235 [DEBU] [ 8 ms] [default] SELECT `id`,`status`,`list_order`,`name`,`remark`,`data_scope` FROM `sys_role` ORDER BY `id` asc LIMIT 0,10 2021-09-12 18:55:24.256 [DEBU] [ 37 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:24.274 [DEBU] [ 16 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:24.282 [DEBU] [ 25 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`oper_url`,`method`,`operator_type`,`oper_ip`,`oper_param`,`oper_location`,`oper_time`,`status`,`request_method`,`oper_name`,`dept_name`,`title`) VALUES('{"code":0,"msg":"success"}','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','/system/config/dict/data/GetDictData',1,'[::1]','{"defaultValue":"","dictType":"sys_normal_disable"}','内网IP','2021-09-12 18:55:24',1,'GET','demo','财务部门','') 2021-09-12 18:55:24.290 [DEBU] [ 16 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`request_method`,`dept_name`,`method`,`oper_name`,`oper_location`,`status`,`json_result`,`oper_param`,`title`,`operator_type`,`oper_url`,`oper_ip`) VALUES('2021-09-12 18:55:24','GET','财务部门','/system/auth/roleList','demo','内网IP',1,'{"code":0,"msg":"success"}','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','角色管理',1,'/system/auth/roleList?pageNum=1&pageSize=10&beginTime=&endTime=','[::1]') 2021-09-12 18:55:40.833 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `sys_dict_type` WHERE `deleted_at` IS NULL 2021-09-12 18:55:40.838 [DEBU] [ 5 ms] [default] SELECT `dict_id`,`dict_name`,`dict_type`,`status`,`remark`,`created_at` FROM `sys_dict_type` WHERE `deleted_at` IS NULL ORDER BY `dict_id` asc LIMIT 0,10 2021-09-12 18:55:40.869 [DEBU] [ 14 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:40.873 [DEBU] [ 12 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:40.892 [DEBU] [ 23 ms] [default] INSERT INTO `sys_oper_log`(`method`,`operator_type`,`oper_ip`,`oper_param`,`oper_name`,`status`,`oper_time`,`json_result`,`request_method`,`oper_location`,`oper_url`,`title`,`dept_name`) VALUES('/system/config/dict/data/GetDictData',1,'[::1]','{"defaultValue":"","dictType":"sys_normal_disable"}','demo',1,'2021-09-12 18:55:40','{"code":0,"msg":"success"}','GET','内网IP','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','','财务部门') 2021-09-12 18:55:40.904 [DEBU] [ 30 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`dept_name`,`operator_type`,`status`,`oper_url`,`title`,`method`,`oper_location`,`oper_time`,`oper_name`,`oper_ip`,`json_result`,`oper_param`) VALUES('GET','财务部门',1,1,'/system/config/dict/type/list?pageNum=1&pageSize=10&beginTime=&endTime=','字典管理','/system/config/dict/type/list','内网IP','2021-09-12 18:55:40','demo','[::1]','{"code":0,"msg":"success"}','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}') 2021-09-12 18:55:42.780 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `sys_dict_data` WHERE (dict_type = 'sys_user_sex') AND `deleted_at` IS NULL 2021-09-12 18:55:42.792 [DEBU] [ 11 ms] [default] SELECT * FROM `sys_dict_data` WHERE (dict_type = 'sys_user_sex') AND `deleted_at` IS NULL ORDER BY `dict_sort` asc,`dict_code` asc LIMIT 0,10 2021-09-12 18:55:42.806 [DEBU] [ 12 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:42.818 [DEBU] [ 11 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:55:42.827 [DEBU] [ 21 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_time`,`json_result`,`title`,`oper_url`,`method`,`oper_name`,`request_method`,`oper_param`,`operator_type`,`dept_name`,`oper_location`,`status`) VALUES('[::1]','2021-09-12 18:55:42','{"code":0,"msg":"success"}','','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','/system/config/dict/data/GetDictData','demo','GET','{"defaultValue":"","dictType":"sys_normal_disable"}',1,'财务部门','内网IP',1) 2021-09-12 18:55:42.842 [DEBU] [ 23 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_url`,`title`,`request_method`,`oper_name`,`json_result`,`oper_ip`,`oper_time`,`status`,`method`,`operator_type`,`oper_location`,`oper_param`) VALUES('财务部门','/system/config/dict/data/list?pageNum=1&pageSize=10&dictType=sys_user_sex','字典数据管理','GET','demo','{"code":0,"msg":"success"}','[::1]','2021-09-12 18:55:42',1,'/system/config/dict/data/list',1,'内网IP','{"dictType":"sys_user_sex","pageNum":"1","pageSize":"10"}') 2021-09-12 18:56:03.955 [DEBU] [ 17 ms] [default] SELECT COUNT(1) FROM `sys_config` WHERE `deleted_at` IS NULL 2021-09-12 18:56:03.959 [DEBU] [ 4 ms] [default] SELECT `config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_config` WHERE `deleted_at` IS NULL ORDER BY `config_id` asc LIMIT 0,10 2021-09-12 18:56:03.976 [DEBU] [ 19 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:56:03.982 [DEBU] [ 9 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:56:04.004 [DEBU] [ 27 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`status`,`operator_type`,`oper_ip`,`oper_name`,`dept_name`,`method`,`oper_param`,`title`,`oper_location`,`oper_time`,`json_result`,`request_method`) VALUES('/system/config/dict/data/GetDictData?dictType=sys_yes_no&defaultValue=',1,1,'[::1]','demo','财务部门','/system/config/dict/data/GetDictData','{"defaultValue":"","dictType":"sys_yes_no"}','','内网IP','2021-09-12 18:56:03','{"code":0,"msg":"success"}','GET') 2021-09-12 18:56:04.015 [DEBU] [ 32 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_param`,`operator_type`,`oper_name`,`oper_ip`,`oper_time`,`json_result`,`method`,`oper_location`,`status`,`dept_name`,`title`,`request_method`) VALUES('/system/config/sysConfig/list?pageNum=1&pageSize=10&beginTime=&endTime=','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}',1,'demo','[::1]','2021-09-12 18:56:03','{"code":0,"msg":"success"}','/system/config/sysConfig/list','内网IP',1,'财务部门','参数管理','GET') 2021-09-12 18:56:08.712 [DEBU] [ 7 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 2021-09-12 18:56:08.732 [DEBU] [ 9 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:56:08.738 [DEBU] [ 11 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:56:08.748 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`title`,`operator_type`,`oper_param`,`request_method`,`oper_url`,`oper_ip`,`oper_time`,`json_result`,`method`,`oper_name`,`oper_location`,`status`) VALUES('财务部门','',1,'{"defaultValue":"","dictType":"sys_normal_disable"}','GET','/system/config/dict/data/GetDictData?dictType=sys_normal_disable&defaultValue=','[::1]','2021-09-12 18:56:08','{"code":0,"msg":"success"}','/system/config/dict/data/GetDictData','demo','内网IP',1) 2021-09-12 18:56:08.753 [DEBU] [ 14 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`operator_type`,`oper_name`,`dept_name`,`oper_url`,`title`,`request_method`,`oper_ip`,`method`,`oper_time`,`oper_param`,`oper_location`,`status`) VALUES('{"code":0,"msg":"success"}',1,'demo','财务部门','/system/auth/deptList','部门管理','GET','[::1]','/system/auth/deptList','2021-09-12 18:56:08','{}','内网IP',1) 2021-09-12 18:56:14.027 [DEBU] [ 7 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 2021-09-12 18:56:14.028 [DEBU] [ 8 ms] [default] SELECT * FROM `sys_role` WHERE id = 1 LIMIT 1 2021-09-12 18:56:14.039 [DEBU] [ 9 ms] [default] SHOW FULL COLUMNS FROM `sys_role_dept` 2021-09-12 18:56:14.055 [DEBU] [ 14 ms] [default] SELECT `role_id`,`dept_id` FROM `sys_role_dept` WHERE `role_id`=1 2021-09-12 18:56:14.064 [DEBU] [ 13 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:56:14.085 [DEBU] [ 20 ms] [default] INSERT INTO `sys_oper_log`(`status`,`json_result`,`method`,`operator_type`,`dept_name`,`request_method`,`oper_ip`,`oper_time`,`oper_param`,`oper_name`,`oper_location`,`oper_url`,`title`) VALUES(1,'{"code":0,"msg":"success"}','/system/auth/editRole',1,'财务部门','GET','[::1]','2021-09-12 18:56:14','{"roleId":"1"}','demo','内网IP','/system/auth/editRole?roleId=1','修改角色') 2021-09-12 18:56:14.087 [DEBU] [ 16 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:56:14.100 [DEBU] [ 13 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_time`,`dept_name`,`oper_url`,`json_result`,`method`,`oper_name`,`oper_location`,`title`,`operator_type`,`status`,`oper_param`,`request_method`) VALUES('[::1]','2021-09-12 18:56:14','财务部门','/system/auth/roleDeptTreeSelect?roleId=1','{"code":0,"msg":"success"}','/system/auth/roleDeptTreeSelect','demo','内网IP','',1,1,'{"roleId":"1"}','GET') 2021-09-12 18:56:23.270 [DEBU] [ 3 ms] [default] [1] BEGIN 2021-09-12 18:56:23.276 [DEBU] [ 6 ms] [default] [1] UPDATE `sys_role` SET `data_scope`=2 WHERE `id`=1 2021-09-12 18:56:23.280 [DEBU] [ 4 ms] [default] [1] DELETE FROM `sys_role_dept` WHERE `role_id`=1 2021-09-12 18:56:23.289 [DEBU] [ 9 ms] [default] [1] INSERT INTO `sys_role_dept`(`dept_id`,`role_id`) VALUES(101,1),(103,1),(104,1) 2021-09-12 18:56:23.300 [DEBU] [ 10 ms] [default] [1] COMMIT 2021-09-12 18:56:23.343 [DEBU] [ 8 ms] [default] SHOW FULL COLUMNS FROM `sys_auth_rule` 2021-09-12 18:56:23.352 [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 2021-09-12 18:56:23.385 [DEBU] [ 5 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:56:23.396 [DEBU] [ 11 ms] [default] INSERT INTO `sys_oper_log`(`status`,`oper_name`,`oper_location`,`json_result`,`request_method`,`operator_type`,`oper_ip`,`oper_url`,`title`,`method`,`dept_name`,`oper_param`,`oper_time`) VALUES(1,'demo','内网IP','{"code":0,"msg":"success"}','PUT',1,'[::1]','/system/auth/roleDataScope','','/system/auth/roleDataScope','财务部门','{"dataScope":"2","deptCheckStrictly":false,"deptIds":[101,103,104],"menuCheckStrictly":false,"menuIds":[1,5,19,20,21,22,23,24,25,6,41,42,43,86,2,8,16,17,18,26,27,29,30,31,28,44,45,46,33,47,48,49,40,50,51,52,53,54,3,34,55,36,56,57,58,59,60,37,38,61,62,39,63,64,4,32,65,66,67,68,35,69,70,71,89,103,119,104,106,90,112,115,116,117,93,113,118,114,107,108,109,110,111],"remark":"备注","roleId":1,"roleName":"超级管理员","roleSort":0,"status":"1"}','2021-09-12 18:56:23') 2021-09-12 18:56:23.405 [DEBU] [ 4 ms] [default] SELECT COUNT(1) FROM `sys_role` 2021-09-12 18:56:23.408 [DEBU] [ 3 ms] [default] SELECT `id`,`status`,`list_order`,`name`,`remark`,`data_scope` FROM `sys_role` ORDER BY `id` asc LIMIT 0,10 2021-09-12 18:56:23.421 [DEBU] [ 5 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 18:56:23.441 [DEBU] [ 18 ms] [default] INSERT INTO `sys_oper_log`(`method`,`request_method`,`oper_url`,`oper_name`,`dept_name`,`oper_location`,`json_result`,`title`,`oper_ip`,`oper_time`,`operator_type`,`status`,`oper_param`) VALUES('/system/auth/roleList','GET','/system/auth/roleList?pageNum=1&pageSize=10&beginTime=&endTime=','demo','财务部门','内网IP','{"code":0,"msg":"success"}','角色管理','[::1]','2021-09-12 18:56:23',1,1,'{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}') 2021-09-12 19:00:06.006 [DEBU] [ 13 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 19:00:06.012 [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 2021-09-12 19:10:08.274 [DEBU] [ 25 ms] [default] SHOW FULL COLUMNS FROM `sys_job` 2021-09-12 19:10:08.286 [DEBU] [ 11 ms] [default] SELECT `job_id`,`job_name`,`job_params`,`job_group`,`invoke_target`,`cron_expression`,`misfire_policy`,`concurrent`,`status`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_job` WHERE (`status`=0) AND `deleted_at` IS NULL 2021-09-12 19:10:08.301 [DEBU] [ 14 ms] [default] UPDATE `sys_job` SET `status`=0 WHERE `job_id`=8 2021-09-12 19:10:45.482 [DEBU] [ 14 ms] [default] SHOW FULL COLUMNS FROM `sys_job` 2021-09-12 19:10:45.496 [DEBU] [ 13 ms] [default] SELECT `job_id`,`job_name`,`job_params`,`job_group`,`invoke_target`,`cron_expression`,`misfire_policy`,`concurrent`,`status`,`create_by`,`update_by`,`remark`,`created_at`,`updated_at`,`deleted_at` FROM `sys_job` WHERE (`status`=0) AND `deleted_at` IS NULL 2021-09-12 19:10:45.502 [DEBU] [ 5 ms] [default] UPDATE `sys_job` SET `status`=0 WHERE `job_id`=8 2021-09-12 19:11:00.205 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `sys_user` 2021-09-12 19:11:00.211 [DEBU] [ 6 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 2021-09-12 19:11:00.221 [DEBU] [ 9 ms] [default] UPDATE `sys_user` SET `last_login_ip`='[::1]',`last_login_time`='2021-09-12 19:11:00' WHERE `id`=31 2021-09-12 19:11:00.233 [DEBU] [ 11 ms] [default] SHOW FULL COLUMNS FROM `sys_login_log` 2021-09-12 19:11:00.251 [DEBU] [ 16 ms] [default] SHOW FULL COLUMNS FROM `sys_user_online` 2021-09-12 19:11:00.257 [DEBU] [ 24 ms] [default] INSERT INTO `sys_login_log`(`login_name`,`ipaddr`,`login_location`,`os`,`msg`,`info_id`,`browser`,`status`,`login_time`,`module`) VALUES('demo','[::1]','内网IP','Intel Mac OS X 11_2_3','登录成功',0,'Chrome',1,'2021-09-12 19:11:00','系统后台') 2021-09-12 19:11:00.264 [DEBU] [ 12 ms] [default] SELECT `id` FROM `sys_user_online` WHERE `token`='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv765LmHbV6bNSHN8YBr1X/l8UJmdvM+TsbvBNzUHnGHcYj4ZY7tJdKXIzCNpmGlL2Q==' LIMIT 1 2021-09-12 19:11:00.273 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `sys_role` 2021-09-12 19:11:00.277 [DEBU] [ 3 ms] [default] SELECT * FROM `sys_role` ORDER BY `list_order` asc,`id` asc 2021-09-12 19:11:00.278 [DEBU] [ 14 ms] [default] INSERT INTO `sys_user_online`(`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os`) VALUES('d150bf474a26c08ecd51cf7ad424b4e0','oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv765LmHbV6bNSHN8YBr1X/l8UJmdvM+TsbvBNzUHnGHcYj4ZY7tJdKXIzCNpmGlL2Q==','2021-09-12 19:11:00','demo','[::1]','Chrome','Intel Mac OS X 11_2_3') 2021-09-12 19:11:00.301 [DEBU] [ 3 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule` 2021-09-12 19:11:00.303 [DEBU] [ 2 ms] [default] SELECT `ptype`,`v0`,`v1`,`v2`,`v3`,`v4`,`v5` FROM `casbin_rule` 2021-09-12 19:11:00.319 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `sys_dept` 2021-09-12 19:11:00.327 [DEBU] [ 8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 19:11:00.333 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log` 2021-09-12 19:11:00.353 [DEBU] [ 19 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`operator_type`,`request_method`,`status`,`oper_param`,`method`,`dept_name`,`oper_ip`,`oper_location`,`title`,`oper_name`,`oper_url`,`oper_time`) VALUES('{"code":0,"msg":"success"}',1,'GET',1,'{}','/system/user/getInfo','财务部门','[::1]','内网IP','','demo','/system/user/getInfo','2021-09-12 19:11:00') 2021-09-12 19:11:00.360 [DEBU] [ 7 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 19:11:00.374 [DEBU] [ 13 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`operator_type`,`oper_url`,`status`,`json_result`,`method`,`oper_location`,`oper_time`,`title`,`dept_name`,`oper_ip`,`request_method`,`oper_name`) VALUES('{}',1,'/system/user/getRouters',1,'{"code":0,"msg":"success"}','/system/user/getRouters','内网IP','2021-09-12 19:11:00','','财务部门','[::1]','GET','demo') 2021-09-12 19:20:05.485 [DEBU] [ 14 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 19:20:05.491 [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 2021-09-12 19:20:05.516 [DEBU] [ 14 ms] [default] DELETE FROM `sys_user_online` WHERE `token`='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv6+9opbt/3w/ovrTEhqelCbO7OvH4bZ6FaByJ4KPJFlXJe4TmaeNhOkoZeZU2krPPA==' 2021-09-12 19:20:05.538 [DEBU] [ 17 ms] [default] DELETE FROM `sys_user_online` WHERE `token`='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv6ebYBJG/d6XljHiHXijdUDenBu+qc8gkG5PEDUf5luJJAlkCi1Yq+iIfQQeZY0U1g==' 2021-09-12 19:20:05.561 [DEBU] [ 16 ms] [default] DELETE FROM `sys_user_online` WHERE `token`='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv/yGio7yvc+QyTvz49y3+y8KKdRi8RcbrmB9mWv3FxHiZNNlGZJqcRXAgv4pFKCAAg==' 2021-09-12 20:10:05.931 [DEBU] [ 13 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 20:10:05.935 [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 2021-09-12 21:40:05.120 [DEBU] [ 9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 21:40:05.124 [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 2021-09-12 21:50:05.111 [DEBU] [ 11 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 21:50:05.115 [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 2021-09-12 21:50:29.782 [DEBU] [ 6 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 21:50:29.794 [DEBU] [ 11 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`status`,`title`,`dept_name`,`oper_location`,`oper_ip`,`method`,`request_method`,`oper_time`,`oper_param`,`operator_type`,`oper_name`,`json_result`) VALUES('/system/user/getInfo',1,'','财务部门','内网IP','[::1]','/system/user/getInfo','GET','2021-09-12 21:50:29','{}',1,'demo','{"code":0,"msg":"success"}') 2021-09-12 21:50:29.940 [DEBU] [ 8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 21:50:29.954 [DEBU] [ 13 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_url`,`title`,`request_method`,`oper_name`,`oper_param`,`oper_ip`,`oper_location`,`oper_time`,`operator_type`,`dept_name`,`status`,`json_result`) VALUES('/system/user/getRouters','/system/user/getRouters','','GET','demo','{}','[::1]','内网IP','2021-09-12 21:50:29',1,'财务部门',1,'{"code":0,"msg":"success"}') 2021-09-12 21:50:51.947 [DEBU] [ 11 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 21:50:51.965 [DEBU] [ 17 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`oper_url`,`title`,`method`,`dept_name`,`oper_param`,`request_method`,`oper_ip`,`oper_time`,`status`,`json_result`,`operator_type`,`oper_name`) VALUES('内网IP','/system/user/getInfo','','/system/user/getInfo','财务部门','{}','GET','[::1]','2021-09-12 21:50:51',1,'{"code":0,"msg":"success"}',1,'demo') 2021-09-12 21:50:52.046 [DEBU] [ 5 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 21:50:52.062 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`operator_type`,`oper_time`,`status`,`json_result`,`oper_ip`,`oper_location`,`title`,`request_method`,`dept_name`,`oper_url`,`method`,`oper_name`) VALUES('{}',1,'2021-09-12 21:50:52',1,'{"code":0,"msg":"success"}','[::1]','内网IP','','GET','财务部门','/system/user/getRouters','/system/user/getRouters','demo') 2021-09-12 21:52:31.826 [DEBU] [ 9 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 21:52:31.837 [DEBU] [ 10 ms] [default] INSERT INTO `sys_oper_log`(`status`,`json_result`,`operator_type`,`oper_name`,`oper_param`,`dept_name`,`oper_time`,`oper_url`,`method`,`oper_ip`,`oper_location`,`title`,`request_method`) VALUES(1,'{"code":0,"msg":"success"}',1,'demo','{}','财务部门','2021-09-12 21:52:31','/system/user/getInfo','/system/user/getInfo','[::1]','内网IP','','GET') 2021-09-12 21:52:31.911 [DEBU] [ 5 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 21:52:31.923 [DEBU] [ 12 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_url`,`title`,`method`,`request_method`,`operator_type`,`oper_name`,`status`,`oper_location`,`oper_time`,`dept_name`,`json_result`,`oper_param`) VALUES('[::1]','/system/user/getRouters','','/system/user/getRouters','GET',1,'demo',1,'内网IP','2021-09-12 21:52:31','财务部门','{"code":0,"msg":"success"}','{}') 2021-09-12 21:54:04.787 [DEBU] [ 12 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 21:54:04.802 [DEBU] [ 13 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_location`,`method`,`request_method`,`operator_type`,`oper_url`,`status`,`oper_param`,`oper_time`,`title`,`json_result`,`oper_name`,`dept_name`) VALUES('[::1]','内网IP','/system/user/getInfo','GET',1,'/system/user/getInfo',1,'{}','2021-09-12 21:54:04','','{"code":0,"msg":"success"}','demo','财务部门') 2021-09-12 21:54:04.883 [DEBU] [ 8 ms] [default] SELECT `dept_id`,`dept_name` FROM `sys_dept` WHERE (`dept_id`=109) AND `deleted_at` IS NULL LIMIT 1 2021-09-12 21:54:04.897 [DEBU] [ 14 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`oper_time`,`title`,`dept_name`,`oper_ip`,`request_method`,`method`,`oper_url`,`status`,`json_result`,`operator_type`,`oper_name`,`oper_param`) VALUES('内网IP','2021-09-12 21:54:04','','财务部门','[::1]','GET','/system/user/getRouters','/system/user/getRouters',1,'{"code":0,"msg":"success"}',1,'demo','{}') 2021-09-12 22:00:05.021 [DEBU] [ 9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 22:00:05.024 [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 2021-09-12 22:40:05.313 [DEBU] [ 9 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 22:40:05.316 [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 2021-09-12 22:50:05.185 [DEBU] [ 14 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 22:50:05.188 [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 2021-09-12 23:00:05.147 [DEBU] [ 10 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 23:00:05.150 [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 2021-09-12 23:20:05.982 [DEBU] [ 12 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 23:20:05.984 [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 2021-09-12 23:30:05.390 [DEBU] [ 8 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 23:30:05.396 [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 2021-09-12 23:40:05.367 [DEBU] [ 8 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 23:40:05.369 [DEBU] [ 1 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 2021-09-12 23:41:46.669 [DEBU] [ 36 ms] [default] DELETE FROM `sys_user_online` WHERE `token`='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lv765LmHbV6bNSHN8YBr1X/l8UJmdvM+TsbvBNzUHnGHcYj4ZY7tJdKXIzCNpmGlL2Q==' 2021-09-12 23:50:05.343 [DEBU] [ 8 ms] [default] SELECT COUNT(1) FROM `sys_user_online` 2021-09-12 23:50:05.349 [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