| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 |
- 2021-03-10 11:04:48.784 [DEBU] [ 33 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
- 2021-03-10 11:04:48.797 [DEBU] [ 11 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
- 2021-03-10 11:04:48.799 [DEBU] [ 0 ms] [default] INSERT INTO `sys_job`(`misfire_policy`,`concurrent`,`status`,`create_time`,`update_by`,`job_group`,`invoke_target`,`update_time`,`job_id`,`job_name`,`job_params`,`cron_expression`,`create_by`,`remark`) VALUES(1,0,0,1596763977,2,'DEFAULT','checkUserOnline',1596768044,8,'在线用户定时更新','','5 */10 * * * *',2,'') ON DUPLICATE KEY UPDATE `job_group`=VALUES(`job_group`),`invoke_target`=VALUES(`invoke_target`),`update_time`=VALUES(`update_time`),`remark`=VALUES(`remark`),`job_id`=VALUES(`job_id`),`job_name`=VALUES(`job_name`),`job_params`=VALUES(`job_params`),`cron_expression`=VALUES(`cron_expression`),`create_by`=VALUES(`create_by`),`misfire_policy`=VALUES(`misfire_policy`),`concurrent`=VALUES(`concurrent`),`status`=VALUES(`status`),`create_time`=VALUES(`create_time`),`update_by`=VALUES(`update_by`)
- 2021-03-10 11:05:05.888 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `user`
- 2021-03-10 11:05:05.890 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA==' LIMIT 1
- 2021-03-10 11:05:06.077 [DEBU] [185 ms] [default] INSERT INTO `user`(`create_time`,`user_status`,`dept_id`,`id`,`user_nickname`,`last_login_ip`,`remark`,`is_admin`,`mobile`,`user_email`,`last_login_time`,`user_password`,`sex`,`avatar`,`user_name`,`birthday`) VALUES(1581314770,1,109,31,'测试账号','[::1]','',1,'18699888856','223@qq.com',1615345505,'9OFlt5qzzvCiZWhe7ilcLA==',2,'pub_upload/2020-09-03/c5disauti1wogasemy.jpeg','demo',0) ON DUPLICATE KEY UPDATE `sex`=VALUES(`sex`),`avatar`=VALUES(`avatar`),`user_name`=VALUES(`user_name`),`birthday`=VALUES(`birthday`),`user_password`=VALUES(`user_password`),`user_status`=VALUES(`user_status`),`dept_id`=VALUES(`dept_id`),`id`=VALUES(`id`),`user_nickname`=VALUES(`user_nickname`),`create_time`=VALUES(`create_time`),`remark`=VALUES(`remark`),`is_admin`=VALUES(`is_admin`),`mobile`=VALUES(`mobile`),`user_email`=VALUES(`user_email`),`last_login_ip`=VALUES(`last_login_ip`),`last_login_time`=VALUES(`last_login_time`)
- 2021-03-10 11:05:06.083 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `sys_login_log`
- 2021-03-10 11:05:06.086 [DEBU] [ 8 ms] [default] SHOW FULL COLUMNS FROM `user_online`
- 2021-03-10 11:05:06.088 [DEBU] [ 0 ms] [default] INSERT INTO `user_online`(`id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os`) VALUES(0,'dcc9a38662237c5756ad5902a25f02cc','fCLUxFpxP3QqVAezWSiqJ34BRz5YTp2qDGmH5L5jiv7IuTjnVwU1hMxIMAIJawrfywN5deRVVCCE4bc2EcGgSrWy9Iawm/xzFBHyu2EoVSVfbJf5usf/XTDfj/tHXZdD',1615345506,'demo','[::1]','Chrome','Windows 10') ON DUPLICATE KEY UPDATE `id`=VALUES(`id`),`uuid`=VALUES(`uuid`),`token`=VALUES(`token`),`create_time`=VALUES(`create_time`),`user_name`=VALUES(`user_name`),`ip`=VALUES(`ip`),`explorer`=VALUES(`explorer`),`os`=VALUES(`os`)
- 2021-03-10 11:05:06.098 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=31 LIMIT 1
- 2021-03-10 11:05:06.106 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `role`
- 2021-03-10 11:05:06.106 [DEBU] [ 22 ms] [default] INSERT INTO `sys_login_log`(`status`,`msg`,`ipaddr`,`login_location`,`browser`,`os`,`login_time`,`module`,`info_id`,`login_name`) VALUES(1,'登录成功','[::1]','内网IP','Chrome','Windows 10',1615345506,'系统后台',0,'demo') ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),`msg`=VALUES(`msg`),`os`=VALUES(`os`),`login_time`=VALUES(`login_time`),`module`=VALUES(`module`),`info_id`=VALUES(`info_id`),`login_name`=VALUES(`login_name`),`ipaddr`=VALUES(`ipaddr`),`login_location`=VALUES(`login_location`),`browser`=VALUES(`browser`)
- 2021-03-10 11:05:06.118 [DEBU] [ 12 ms] [default] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
- 2021-03-10 11:05:06.125 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule`
- 2021-03-10 11:05:06.126 [DEBU] [ 0 ms] [default] SELECT * FROM `casbin_rule`
- 2021-03-10 11:05:06.207 [DEBU] [ 76 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2021-03-10 11:05:06.209 [DEBU] [ 2 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2021-03-10 11:05:06.229 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2021-03-10 11:05:06.587 [DEBU] [358 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_ip`,`json_result`,`business_type`,`method`,`operator_type`,`dept_name`,`oper_location`,`status`,`title`,`oper_name`,`oper_param`,`oper_id`,`error_msg`,`oper_time`,`request_method`) VALUES('/system/index/getInfo','[::1]','{"code":0,"msg":"ok"}',0,'/system/index/getInfo',1,'','内网IP',1,'','demo','{}',0,'',1615345506,'GET') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`)
- 2021-03-10 11:05:06.629 [DEBU] [395 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_name`,`oper_url`,`oper_param`,`oper_time`,`dept_name`,`title`,`business_type`,`request_method`,`oper_location`,`status`,`oper_id`,`method`,`oper_ip`,`json_result`,`error_msg`) VALUES(1,'demo','/system/index/getRouters','{}',1615345506,'','',0,'GET','内网IP',1,0,'/system/index/getRouters','[::1]','{"code":0,"msg":"ok"}','') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`)
- 2021-03-10 11:05:26.272 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `cms_category`
- 2021-03-10 11:05:26.299 [DEBU] [ 25 ms] [default] SELECT * FROM `cms_category` ORDER BY `list_order` ASC,`id` ASC
- 2021-03-10 11:05:26.308 [DEBU] [ 4 ms] [default] SHOW FULL COLUMNS FROM `cms_news`
- 2021-03-10 11:05:26.309 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id)
- 2021-03-10 11:05:26.310 [DEBU] [ 0 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,10
- 2021-03-10 11:05:26.317 [DEBU] [ 4 ms] [default] SHOW FULL COLUMNS FROM `cms_category_news`
- 2021-03-10 11:05:26.319 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
- 2021-03-10 11:05:26.320 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
- 2021-03-10 11:05:26.320 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=128
- 2021-03-10 11:05:26.321 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
- 2021-03-10 11:05:26.321 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
- 2021-03-10 11:05:26.322 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
- 2021-03-10 11:05:26.322 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
- 2021-03-10 11:05:26.323 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=123
- 2021-03-10 11:05:26.323 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=122
- 2021-03-10 11:05:26.324 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=121
- 2021-03-10 11:05:26.328 [DEBU] [ 4 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2021-03-10 11:05:26.329 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_pub_type' AND `status`=1 LIMIT 1
- 2021-03-10 11:05:26.334 [DEBU] [ 4 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2021-03-10 11:05:26.336 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_pub_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-03-10 11:05:26.337 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_attr' AND `status`=1 LIMIT 1
- 2021-03-10 11:05:26.338 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_attr' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-03-10 11:05:26.339 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_type' AND `status`=1 LIMIT 1
- 2021-03-10 11:05:26.340 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-03-10 11:05:26.342 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`operator_type`,`oper_url`,`oper_id`,`method`,`oper_param`,`request_method`,`oper_name`,`oper_ip`,`oper_location`,`json_result`,`status`,`title`,`dept_name`,`error_msg`,`oper_time`) VALUES(0,1,'/system/cms/news/list?pageNum=1&pageSize=10&keyWords=',0,'/system/cms/news/list','{"keyWords":"","pageNum":"1","pageSize":"10"}','GET','demo','[::1]','内网IP','{"code":0,"msg":"信息列表"}',1,'文章管理','','',1615345526) ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`)
- 2021-03-10 11:05:29.756 [DEBU] [ 30 ms] [default] SHOW FULL COLUMNS FROM `sys_config`
- 2021-03-10 11:05:29.758 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `sys_config`
- 2021-03-10 11:05:29.759 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_config` ORDER BY `config_id` asc LIMIT 0,10
- 2021-03-10 11:05:29.760 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_yes_no' AND `status`=1 LIMIT 1
- 2021-03-10 11:05:29.761 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_yes_no' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-03-10 11:05:29.772 [DEBU] [ 9 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`status`,`oper_time`,`error_msg`,`method`,`request_method`,`oper_name`,`oper_ip`,`title`,`oper_location`,`oper_param`,`json_result`,`oper_id`,`business_type`,`operator_type`,`dept_name`) VALUES('/system/config/params/list?pageNum=1&pageSize=10&beginTime=&endTime=',1,1615345529,'','/system/config/params/list','GET','demo','[::1]','参数管理','内网IP','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','{"code":0,"msg":"字典列表"}',0,0,1,'') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`oper_location`=VALUES(`oper_location`)
- 2021-03-10 11:05:30.963 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `sys_dict_type`
- 2021-03-10 11:05:30.967 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` ORDER BY `dict_id` asc LIMIT 0,10
- 2021-03-10 11:05:30.971 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
- 2021-03-10 11:05:30.972 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-03-10 11:05:30.976 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`status`,`oper_url`,`operator_type`,`oper_time`,`request_method`,`oper_name`,`oper_ip`,`oper_location`,`error_msg`,`title`,`business_type`,`method`,`dept_name`,`oper_param`,`json_result`,`oper_id`) VALUES(1,'/system/config/dict/list?pageNum=1&pageSize=10&beginTime=&endTime=',1,1615345530,'GET','demo','[::1]','内网IP','','字典管理',0,'/system/config/dict/list','','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','{"code":0,"msg":"字典列表"}',0) ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_time`=VALUES(`oper_time`)
- 2021-03-10 11:05:36.964 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `sys_config`
- 2021-03-10 11:05:36.966 [DEBU] [ 2 ms] [default] SELECT * FROM `sys_config` ORDER BY `config_id` asc LIMIT 0,10
- 2021-03-10 11:05:36.972 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`method`,`request_method`,`oper_id`,`oper_ip`,`error_msg`,`oper_time`,`title`,`dept_name`,`oper_url`,`oper_param`,`json_result`,`status`,`operator_type`,`oper_name`,`oper_location`) VALUES(0,'/system/config/params/list','GET',0,'[::1]','',1615345536,'参数管理','','/system/config/params/list?pageNum=1&pageSize=10&beginTime=&endTime=','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','{"code":0,"msg":"字典列表"}',1,1,'demo','内网IP') ON DUPLICATE KEY UPDATE `error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_id`=VALUES(`oper_id`),`oper_ip`=VALUES(`oper_ip`)
- 2021-03-10 11:05:48.935 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id)
- 2021-03-10 11:05:48.936 [DEBU] [ 0 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,10
- 2021-03-10 11:05:48.941 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
- 2021-03-10 11:05:48.943 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
- 2021-03-10 11:05:48.943 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=128
- 2021-03-10 11:05:48.944 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
- 2021-03-10 11:05:48.945 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
- 2021-03-10 11:05:48.946 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
- 2021-03-10 11:05:48.946 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
- 2021-03-10 11:05:48.946 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=123
- 2021-03-10 11:05:48.947 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=122
- 2021-03-10 11:05:48.948 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=121
- 2021-03-10 11:05:48.952 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`title`,`request_method`,`oper_ip`,`oper_url`,`oper_param`,`json_result`,`oper_id`,`operator_type`,`oper_name`,`business_type`,`error_msg`,`oper_time`,`status`,`method`,`dept_name`,`oper_location`) VALUES('文章管理','GET','[::1]','/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','{"keyWords":"","pageNum":"1","pageSize":"10"}','{"code":0,"msg":"信息列表"}',0,1,'demo',0,'',1615345548,1,'/system/cms/news/list','','内网IP') ON DUPLICATE KEY UPDATE `oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`error_msg`=VALUES(`error_msg`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`)
|