| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879 |
- 2021-04-29 09:31:30.597 [DEBU] [116 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
- 2021-04-29 09:31:30.608 [DEBU] [ 10 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
- 2021-04-29 09:31:30.609 [DEBU] [ 1 ms] [default] INSERT INTO `sys_job`(`job_name`,`misfire_policy`,`concurrent`,`update_time`,`invoke_target`,`status`,`job_id`,`job_group`,`remark`,`job_params`,`cron_expression`,`create_by`,`create_time`,`update_by`) VALUES('在线用户定时更新',1,0,1596768044,'checkUserOnline',0,8,'DEFAULT','','','5 */10 * * * *',2,1596763977,2) ON DUPLICATE KEY UPDATE `invoke_target`=VALUES(`invoke_target`),`status`=VALUES(`status`),`remark`=VALUES(`remark`),`job_id`=VALUES(`job_id`),`job_group`=VALUES(`job_group`),`create_by`=VALUES(`create_by`),`create_time`=VALUES(`create_time`),`update_by`=VALUES(`update_by`),`job_params`=VALUES(`job_params`),`cron_expression`=VALUES(`cron_expression`),`concurrent`=VALUES(`concurrent`),`update_time`=VALUES(`update_time`),`job_name`=VALUES(`job_name`),`misfire_policy`=VALUES(`misfire_policy`)
- 2021-04-29 09:31:40.661 [DEBU] [ 56 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2021-04-29 09:31:40.662 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `sys_dict_data`
- 2021-04-29 09:31:40.663 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` ORDER BY `dict_sort` asc,`dict_code` asc LIMIT 0,10
- 2021-04-29 09:31:40.690 [DEBU] [ 26 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2021-04-29 09:31:40.697 [DEBU] [ 6 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
- 2021-04-29 09:31:40.699 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-04-29 09:31:40.727 [DEBU] [ 27 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2021-04-29 09:31:40.740 [DEBU] [ 12 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2021-04-29 09:31:40.781 [DEBU] [ 26 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2021-04-29 09:31:40.802 [DEBU] [ 20 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_param`,`method`,`oper_name`,`dept_name`,`oper_id`,`operator_type`,`status`,`oper_time`,`oper_location`,`json_result`,`error_msg`,`oper_ip`,`title`,`business_type`,`request_method`) VALUES('/system/config/dict/dataList?pageNum=1&pageSize=10&dictType=','{"dictType":"","pageNum":"1","pageSize":"10"}','/system/config/dict/dataList','demo','',0,1,1,1619659900,'内网IP','{"code":0,"msg":"ok"}','','[::1]','字典数据管理',0,'GET') ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`)
- 2021-04-29 09:31:43.480 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `sys_dict_type`
- 2021-04-29 09:31:43.481 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` ORDER BY `dict_id` asc LIMIT 0,10
- 2021-04-29 09:31:43.490 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`operator_type`,`oper_name`,`dept_name`,`oper_url`,`oper_location`,`oper_time`,`business_type`,`request_method`,`oper_param`,`json_result`,`title`,`method`,`oper_ip`,`status`,`error_msg`) VALUES(0,1,'demo','','/system/config/dict/list?pageNum=1&pageSize=10&beginTime=&endTime=','内网IP',1619659903,0,'GET','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','{"code":0,"msg":"字典列表"}','字典管理','/system/config/dict/list','[::1]',1,'') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`)
- 2021-04-29 09:31:44.780 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `sys_dict_type`
- 2021-04-29 09:31:44.781 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` ORDER BY `dict_id` asc LIMIT 0,10
- 2021-04-29 09:31:44.785 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_time`,`request_method`,`json_result`,`oper_name`,`dept_name`,`oper_location`,`error_msg`,`oper_id`,`method`,`operator_type`,`oper_ip`,`oper_param`,`status`,`title`,`business_type`) VALUES('/system/config/dict/list?pageNum=1&pageSize=10&beginTime=&endTime=',1619659904,'GET','{"code":0,"msg":"字典列表"}','demo','','内网IP','',0,'/system/config/dict/list',1,'[::1]','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}',1,'字典管理',0) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`)
- 2021-04-29 09:31:45.685 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `sys_dict_type`
- 2021-04-29 09:31:45.686 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` ORDER BY `dict_id` asc LIMIT 0,10
- 2021-04-29 09:31:45.689 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`status`,`oper_ip`,`business_type`,`method`,`request_method`,`oper_name`,`oper_url`,`error_msg`,`title`,`operator_type`,`dept_name`,`oper_param`,`json_result`,`oper_time`,`oper_id`,`oper_location`) VALUES(1,'[::1]',0,'/system/config/dict/list','GET','demo','/system/config/dict/list?pageNum=1&pageSize=10&beginTime=&endTime=','','字典管理',1,'','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','{"code":0,"msg":"字典列表"}',1619659905,0,'内网IP') ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`)
- 2021-04-29 09:31:46.757 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE dict_id=1 LIMIT 1
- 2021-04-29 09:31:46.760 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`status`,`business_type`,`method`,`oper_ip`,`oper_location`,`title`,`operator_type`,`dept_name`,`json_result`,`error_msg`,`oper_id`,`request_method`,`oper_name`,`oper_param`,`oper_time`) VALUES('/system/config/dict/edit?dictId=1',1,0,'/system/config/dict/edit','[::1]','内网IP','修改字典',1,'','{"code":0,"msg":"ok"}','',0,'GET','demo','{"dictId":"1"}',1619659906) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_location`=VALUES(`oper_location`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`)
- 2021-04-29 09:31:51.055 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE dict_type='sys_user_sex_2' and dict_id!=1 LIMIT 1
- 2021-04-29 09:31:51.059 [DEBU] [ 2 ms] [default] SELECT * FROM `sys_dict_type` WHERE dict_id=1 LIMIT 1
- 2021-04-29 09:31:51.063 [DEBU] [ 1 ms] [default] INSERT INTO `sys_dict_type`(`dict_id`,`dict_name`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`,`dict_type`,`status`) VALUES(1,'用户性别',31,1582789177,31,1619659911,'用于选择用户性别','sys_user_sex_2',1) ON DUPLICATE KEY UPDATE `update_time`=VALUES(`update_time`),`remark`=VALUES(`remark`),`dict_id`=VALUES(`dict_id`),`dict_name`=VALUES(`dict_name`),`create_by`=VALUES(`create_by`),`create_time`=VALUES(`create_time`),`update_by`=VALUES(`update_by`),`dict_type`=VALUES(`dict_type`),`status`=VALUES(`status`)
- 2021-04-29 09:31:51.065 [DEBU] [ 1 ms] [default] UPDATE `sys_dict_data` SET `dict_type`='sys_user_sex_2' WHERE `dict_type`='sys_user_sex'
- 2021-04-29 09:31:51.115 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`oper_url`,`oper_ip`,`oper_param`,`dept_name`,`status`,`oper_time`,`json_result`,`error_msg`,`oper_id`,`title`,`request_method`,`operator_type`,`business_type`,`method`,`oper_location`) VALUES('demo','/system/config/dict/edit','[::1]','{"dictId":1,"dictName":"用户性别","dictType":"sys_user_sex_2","remark":"用于选择用户性别","status":"1"}','',1,1619659911,'{"code":0,"msg":"修改成功"}','',0,'修改字典','POST',1,0,'/system/config/dict/edit','内网IP') ON DUPLICATE KEY UPDATE `dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`operator_type`=VALUES(`operator_type`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`)
- 2021-04-29 09:31:51.130 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `sys_dict_type`
- 2021-04-29 09:31:51.130 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` ORDER BY `dict_id` asc LIMIT 0,10
- 2021-04-29 09:31:51.134 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
- 2021-04-29 09:31:51.135 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-04-29 09:31:51.140 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`json_result`,`error_msg`,`oper_time`,`operator_type`,`oper_ip`,`method`,`request_method`,`dept_name`,`status`,`oper_id`,`business_type`,`oper_param`,`oper_name`,`oper_url`,`title`) VALUES('内网IP','{"code":0,"msg":"字典列表"}','',1619659911,1,'[::1]','/system/config/dict/list','GET','',1,0,0,'{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','demo','/system/config/dict/list?pageNum=1&pageSize=10&beginTime=&endTime=','字典管理') ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_param`=VALUES(`oper_param`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`title`=VALUES(`title`)
- 2021-04-29 09:31:53.383 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `sys_dict_data` WHERE dict_type = 'sys_user_sex_2'
- 2021-04-29 09:31:53.384 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE dict_type = 'sys_user_sex_2' ORDER BY `dict_sort` asc,`dict_code` asc LIMIT 0,10
- 2021-04-29 09:31:53.396 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`dept_name`,`json_result`,`status`,`oper_id`,`oper_name`,`oper_url`,`oper_ip`,`error_msg`,`business_type`,`operator_type`,`oper_location`,`oper_time`,`method`,`request_method`,`oper_param`) VALUES('字典数据管理','','{"code":0,"msg":"ok"}',1,0,'demo','/system/config/dict/dataList?pageNum=1&pageSize=10&dictType=sys_user_sex_2','[::1]','',0,1,'内网IP',1619659913,'/system/config/dict/dataList','GET','{"dictType":"sys_user_sex_2","pageNum":"1","pageSize":"10"}') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`)
- 2021-04-29 09:31:54.500 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_code`=1 LIMIT 1
- 2021-04-29 09:31:54.503 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`oper_param`,`status`,`oper_id`,`method`,`operator_type`,`oper_url`,`oper_location`,`error_msg`,`title`,`dept_name`,`json_result`,`oper_time`,`business_type`,`oper_ip`,`oper_name`) VALUES('GET','{"dictCode":"1"}',1,0,'/system/config/dict/dataEdit',1,'/system/config/dict/dataEdit?dictCode=1','内网IP','','修改字典数据','','{"code":0,"msg":"ok"}',1619659914,0,'[::1]','demo') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`)
- 2021-04-29 09:31:58.194 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `sys_dict_type`
- 2021-04-29 09:31:58.195 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` ORDER BY `dict_id` asc LIMIT 0,10
- 2021-04-29 09:31:58.202 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_location`,`json_result`,`error_msg`,`title`,`business_type`,`method`,`status`,`oper_id`,`oper_time`,`operator_type`,`oper_name`,`dept_name`,`oper_ip`,`oper_param`,`request_method`) VALUES('/system/config/dict/list?pageNum=1&pageSize=10&beginTime=&endTime=','内网IP','{"code":0,"msg":"字典列表"}','','字典管理',0,'/system/config/dict/list',1,0,1619659918,1,'demo','','[::1]','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','GET') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`oper_time`=VALUES(`oper_time`)
- 2021-04-29 09:31:59.252 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE dict_id=1 LIMIT 1
- 2021-04-29 09:31:59.254 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`title`,`operator_type`,`error_msg`,`oper_param`,`json_result`,`business_type`,`method`,`request_method`,`dept_name`,`oper_ip`,`oper_location`,`status`,`oper_name`,`oper_url`,`oper_time`) VALUES(0,'修改字典',1,'','{"dictId":"1"}','{"code":0,"msg":"ok"}',0,'/system/config/dict/edit','GET','','[::1]','内网IP',1,'demo','/system/config/dict/edit?dictId=1',1619659919) ON DUPLICATE KEY UPDATE `error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`status`=VALUES(`status`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`)
- 2021-04-29 09:32:01.623 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE dict_type='sys_user_sex' and dict_id!=1 LIMIT 1
- 2021-04-29 09:32:01.626 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE dict_id=1 LIMIT 1
- 2021-04-29 09:32:01.649 [DEBU] [ 22 ms] [default] INSERT INTO `sys_dict_type`(`dict_id`,`status`,`create_by`,`update_time`,`remark`,`dict_name`,`dict_type`,`create_time`,`update_by`) VALUES(1,1,31,1619659921,'用于选择用户性别','用户性别','sys_user_sex',1582789177,31) ON DUPLICATE KEY UPDATE `dict_name`=VALUES(`dict_name`),`dict_type`=VALUES(`dict_type`),`create_time`=VALUES(`create_time`),`update_by`=VALUES(`update_by`),`remark`=VALUES(`remark`),`dict_id`=VALUES(`dict_id`),`status`=VALUES(`status`),`create_by`=VALUES(`create_by`),`update_time`=VALUES(`update_time`)
- 2021-04-29 09:32:01.650 [DEBU] [ 0 ms] [default] UPDATE `sys_dict_data` SET `dict_type`='sys_user_sex' WHERE `dict_type`='sys_user_sex_2'
- 2021-04-29 09:32:01.814 [DEBU] [ 3 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`request_method`,`oper_name`,`dept_name`,`oper_url`,`oper_id`,`oper_ip`,`oper_param`,`json_result`,`status`,`error_msg`,`oper_time`,`oper_location`,`method`,`operator_type`,`title`) VALUES(0,'POST','demo','','/system/config/dict/edit',0,'[::1]','{"dictId":1,"dictName":"用户性别","dictType":"sys_user_sex","remark":"用于选择用户性别","status":"1"}','{"code":0,"msg":"修改成功"}',1,'',1619659921,'内网IP','/system/config/dict/edit',1,'修改字典') ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`)
- 2021-04-29 09:32:01.847 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `sys_dict_type`
- 2021-04-29 09:32:01.848 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` ORDER BY `dict_id` asc LIMIT 0,10
- 2021-04-29 09:32:01.852 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
- 2021-04-29 09:32:01.854 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-04-29 09:32:01.860 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_param`,`oper_url`,`oper_location`,`oper_id`,`oper_name`,`request_method`,`dept_name`,`json_result`,`error_msg`,`title`,`business_type`,`status`,`oper_time`,`method`,`oper_ip`) VALUES(1,'{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','/system/config/dict/list?pageNum=1&pageSize=10&beginTime=&endTime=','内网IP',0,'demo','GET','','{"code":0,"msg":"字典列表"}','','字典管理',0,1,1619659921,'/system/config/dict/list','[::1]') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`)
- 2021-04-29 09:32:03.143 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE dict_id=1 LIMIT 1
- 2021-04-29 09:32:03.146 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`method`,`oper_url`,`oper_location`,`oper_param`,`status`,`error_msg`,`oper_id`,`business_type`,`dept_name`,`oper_ip`,`oper_name`,`request_method`,`operator_type`,`json_result`,`oper_time`) VALUES('修改字典','/system/config/dict/edit','/system/config/dict/edit?dictId=1','内网IP','{"dictId":"1"}',1,'',0,0,'','[::1]','demo','GET',1,'{"code":0,"msg":"ok"}',1619659923) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_name`=VALUES(`oper_name`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`)
- 2021-04-29 09:32:08.052 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `sys_dict_data` WHERE dict_type = 'sys_user_sex'
- 2021-04-29 09:32:08.053 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE dict_type = 'sys_user_sex' ORDER BY `dict_sort` asc,`dict_code` asc LIMIT 0,10
- 2021-04-29 09:32:08.061 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_name`,`dept_name`,`request_method`,`operator_type`,`json_result`,`oper_time`,`oper_id`,`title`,`business_type`,`oper_ip`,`oper_location`,`error_msg`,`oper_url`,`oper_param`,`status`) VALUES('/system/config/dict/dataList','demo','','GET',1,'{"code":0,"msg":"ok"}',1619659928,0,'字典数据管理',0,'[::1]','内网IP','','/system/config/dict/dataList?pageNum=1&pageSize=10&dictType=sys_user_sex','{"dictType":"sys_user_sex","pageNum":"1","pageSize":"10"}',1) ON DUPLICATE KEY UPDATE `json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`business_type`=VALUES(`business_type`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`status`=VALUES(`status`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`dept_name`=VALUES(`dept_name`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`)
- 2021-04-29 09:32:09.141 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_code`=2 LIMIT 1
- 2021-04-29 09:32:09.146 [DEBU] [ 3 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`method`,`status`,`oper_time`,`error_msg`,`title`,`request_method`,`operator_type`,`dept_name`,`oper_url`,`oper_ip`,`oper_location`,`oper_name`,`oper_id`,`oper_param`,`json_result`) VALUES(0,'/system/config/dict/dataEdit',1,1619659929,'','修改字典数据','GET',1,'','/system/config/dict/dataEdit?dictCode=2','[::1]','内网IP','demo',0,'{"dictCode":"2"}','{"code":0,"msg":"ok"}') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_name`=VALUES(`oper_name`)
- 2021-04-29 09:32:11.846 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `sys_dict_type`
- 2021-04-29 09:32:11.847 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` ORDER BY `dict_id` asc LIMIT 0,10
- 2021-04-29 09:32:11.850 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`oper_ip`,`oper_param`,`request_method`,`dept_name`,`oper_url`,`oper_location`,`error_msg`,`oper_time`,`oper_name`,`json_result`,`status`,`oper_id`,`business_type`,`method`,`operator_type`) VALUES('字典管理','[::1]','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','GET','','/system/config/dict/list?pageNum=1&pageSize=10&beginTime=&endTime=','内网IP','',1619659931,'demo','{"code":0,"msg":"字典列表"}',1,0,0,'/system/config/dict/list',1) ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`title`=VALUES(`title`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`)
- 2021-04-29 09:40:05.306 [DEBU] [ 49 ms] [default] SHOW FULL COLUMNS FROM `user_online`
- 2021-04-29 09:40:05.309 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-04-29 09:40:05.311 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-04-29 09:50:05.499 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-04-29 09:50:05.500 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-04-29 10:00:05.499 [DEBU] [ 3 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-04-29 10:00:05.500 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-04-29 10:10:05.564 [DEBU] [ 7 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-04-29 10:10:05.566 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-04-29 10:20:05.562 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-04-29 10:20:05.565 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-04-29 10:30:05.562 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-04-29 10:30:05.565 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-04-29 10:40:05.622 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-04-29 10:40:05.626 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
|