2021-03-08.log 48 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147
  1. 2021-03-08 09:58:22.164 [DEBU] [148 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
  2. 2021-03-08 09:58:22.187 [DEBU] [ 21 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
  3. 2021-03-08 09:58:22.192 [DEBU] [ 4 ms] [default] INSERT INTO `sys_job`(`concurrent`,`status`,`update_time`,`job_params`,`invoke_target`,`job_group`,`create_by`,`job_id`,`job_name`,`cron_expression`,`update_by`,`remark`,`misfire_policy`,`create_time`) VALUES(0,0,1596768044,'','checkUserOnline','DEFAULT',2,8,'在线用户定时更新','5 */10 * * * *',2,'',1,1596763977) ON DUPLICATE KEY UPDATE `update_time`=VALUES(`update_time`),`job_params`=VALUES(`job_params`),`invoke_target`=VALUES(`invoke_target`),`concurrent`=VALUES(`concurrent`),`status`=VALUES(`status`),`job_id`=VALUES(`job_id`),`job_name`=VALUES(`job_name`),`job_group`=VALUES(`job_group`),`create_by`=VALUES(`create_by`),`cron_expression`=VALUES(`cron_expression`),`update_by`=VALUES(`update_by`),`misfire_policy`=VALUES(`misfire_policy`),`create_time`=VALUES(`create_time`),`remark`=VALUES(`remark`)
  4. 2021-03-08 10:00:05.975 [DEBU] [ 46 ms] [default] SHOW FULL COLUMNS FROM `user_online`
  5. 2021-03-08 10:00:05.991 [DEBU] [ 12 ms] [default] SELECT COUNT(1) FROM `user_online`
  6. 2021-03-08 10:00:06.004 [DEBU] [ 13 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
  7. 2021-03-08 10:00:06.021 [DEBU] [ 13 ms] [default] DELETE FROM `user_online` WHERE `id`=16378
  8. 2021-03-08 10:10:05.032 [DEBU] [ 3 ms] [default] SELECT COUNT(1) FROM `user_online`
  9. 2021-03-08 10:10:05.034 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
  10. 2021-03-08 10:10:05.990 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `user_online`
  11. 2021-03-08 10:10:05.990 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
  12. 2021-03-08 10:10:15.429 [DEBU] [ 60 ms] [default] SHOW FULL COLUMNS FROM `user`
  13. 2021-03-08 10:10:15.431 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA==' LIMIT 1
  14. 2021-03-08 10:10:15.496 [DEBU] [ 64 ms] [default] INSERT INTO `user`(`user_nickname`,`create_time`,`user_status`,`last_login_time`,`is_admin`,`mobile`,`user_password`,`sex`,`remark`,`id`,`user_name`,`birthday`,`last_login_ip`,`dept_id`,`user_email`,`avatar`) VALUES('测试账号',1581314770,1,1615169415,1,'18699888856','9OFlt5qzzvCiZWhe7ilcLA==',2,'',31,'demo',0,'[::1]',109,'223@qq.com','pub_upload/2020-09-03/c5disauti1wogasemy.jpeg') ON DUPLICATE KEY UPDATE `mobile`=VALUES(`mobile`),`user_password`=VALUES(`user_password`),`sex`=VALUES(`sex`),`remark`=VALUES(`remark`),`id`=VALUES(`id`),`user_name`=VALUES(`user_name`),`birthday`=VALUES(`birthday`),`last_login_ip`=VALUES(`last_login_ip`),`dept_id`=VALUES(`dept_id`),`user_email`=VALUES(`user_email`),`avatar`=VALUES(`avatar`),`user_nickname`=VALUES(`user_nickname`),`create_time`=VALUES(`create_time`),`user_status`=VALUES(`user_status`),`last_login_time`=VALUES(`last_login_time`),`is_admin`=VALUES(`is_admin`)
  15. 2021-03-08 10:10:15.515 [DEBU] [ 16 ms] [default] INSERT INTO `user_online`(`explorer`,`os`,`id`,`uuid`,`token`,`create_time`,`user_name`,`ip`) VALUES('Chrome','Windows 10',0,'dcc9a38662237c5756ad5902a25f02cc','fCLUxFpxP3QqVAezWSiqJ34BRz5YTp2qDGmH5L5jiv7IuTjnVwU1hMxIMAIJawrfywN5deRVVCCE4bc2EcGgSrWy9Iawm/xzFBHyu2EoVSVfbJf5usf/XTDfj/tHXZdD',1615169415,'demo','[::1]') ON DUPLICATE KEY UPDATE `explorer`=VALUES(`explorer`),`os`=VALUES(`os`),`id`=VALUES(`id`),`uuid`=VALUES(`uuid`),`token`=VALUES(`token`),`create_time`=VALUES(`create_time`),`user_name`=VALUES(`user_name`),`ip`=VALUES(`ip`)
  16. 2021-03-08 10:10:15.529 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=31 LIMIT 1
  17. 2021-03-08 10:10:15.558 [DEBU] [ 61 ms] [default] SHOW FULL COLUMNS FROM `sys_login_log`
  18. 2021-03-08 10:10:15.566 [DEBU] [ 37 ms] [default] SHOW FULL COLUMNS FROM `role`
  19. 2021-03-08 10:10:15.568 [DEBU] [ 1 ms] [default] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
  20. 2021-03-08 10:10:15.569 [DEBU] [ 11 ms] [default] INSERT INTO `sys_login_log`(`status`,`msg`,`login_time`,`info_id`,`ipaddr`,`login_location`,`browser`,`os`,`module`,`login_name`) VALUES(1,'登录成功',1615169415,0,'[::1]','内网IP','Chrome','Windows 10','系统后台','demo') ON DUPLICATE KEY UPDATE `os`=VALUES(`os`),`status`=VALUES(`status`),`msg`=VALUES(`msg`),`login_time`=VALUES(`login_time`),`info_id`=VALUES(`info_id`),`ipaddr`=VALUES(`ipaddr`),`login_location`=VALUES(`login_location`),`browser`=VALUES(`browser`),`module`=VALUES(`module`),`login_name`=VALUES(`login_name`)
  21. 2021-03-08 10:10:15.603 [DEBU] [ 34 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule`
  22. 2021-03-08 10:10:15.614 [DEBU] [ 11 ms] [default] SELECT * FROM `casbin_rule`
  23. 2021-03-08 10:10:16.320 [DEBU] [376 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
  24. 2021-03-08 10:10:16.334 [DEBU] [ 13 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
  25. 2021-03-08 10:10:16.461 [DEBU] [110 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
  26. 2021-03-08 10:10:16.461 [DEBU] [ 99 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
  27. 2021-03-08 10:10:16.480 [DEBU] [ 19 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`method`,`operator_type`,`oper_url`,`oper_id`,`oper_name`,`oper_ip`,`oper_param`,`error_msg`,`request_method`,`dept_name`,`status`,`title`,`oper_location`,`json_result`,`oper_time`) VALUES(0,'/system/index/getInfo',1,'/system/index/getInfo',0,'demo','[::1]','{}','','GET','',1,'','内网IP','{"code":0,"msg":"ok"}',1615169416) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`oper_location`=VALUES(`oper_location`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`)
  28. 2021-03-08 10:10:16.481 [DEBU] [ 18 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_name`,`oper_id`,`business_type`,`oper_location`,`oper_param`,`json_result`,`error_msg`,`request_method`,`oper_ip`,`dept_name`,`oper_url`,`oper_time`,`title`,`operator_type`,`status`) VALUES('/system/index/getRouters','demo',0,0,'内网IP','{}','{"code":0,"msg":"ok"}','','GET','[::1]','','/system/index/getRouters',1615169416,'',1,1) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`)
  29. 2021-03-08 10:10:22.899 [DEBU] [ 66 ms] [default] SHOW FULL COLUMNS FROM `gen_table`
  30. 2021-03-08 10:10:22.900 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `gen_table`
  31. 2021-03-08 10:10:22.901 [DEBU] [ 1 ms] [default] SELECT * FROM `gen_table` ORDER BY `table_id` asc LIMIT 0,10
  32. 2021-03-08 10:10:22.904 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`json_result`,`status`,`oper_time`,`request_method`,`dept_name`,`oper_url`,`error_msg`,`oper_id`,`business_type`,`method`,`operator_type`,`oper_name`,`oper_ip`,`oper_location`,`oper_param`) VALUES('','{"code":0,"msg":"ok"}',1,1615169422,'GET','','/system/tools/gen/tableList?pageNum=1&pageSize=10&beginTime=&endTime=','',0,0,'/system/tools/gen/tableList',1,'demo','[::1]','内网IP','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`)
  33. 2021-03-08 10:10:24.485 [DEBU] [ 0 ms] [default] SELECT * FROM `gen_table` WHERE `table_id`=40 LIMIT 1
  34. 2021-03-08 10:10:24.494 [DEBU] [ 8 ms] [default] SHOW FULL COLUMNS FROM `gen_table_column`
  35. 2021-03-08 10:10:24.495 [DEBU] [ 1 ms] [default] SELECT * FROM `gen_table_column` WHERE `table_id`=40 ORDER BY `sort` asc,`column_id` asc
  36. 2021-03-08 10:10:24.686 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`business_type`,`method`,`request_method`,`oper_param`,`error_msg`,`json_result`,`oper_id`,`operator_type`,`dept_name`,`oper_url`,`oper_ip`,`title`,`oper_name`,`oper_location`,`status`) VALUES(1615169424,0,'/system/tools/gen/preview','GET','{"tableId":"40"}','','{"code":0,"msg":"ok"}',0,1,'','/system/tools/gen/preview?tableId=40','[::1]','','demo','内网IP',1) ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`)
  37. 2021-03-08 10:13:53.584 [DEBU] [ 50 ms] [default] SHOW FULL COLUMNS FROM `cms_category`
  38. 2021-03-08 10:13:53.586 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category` ORDER BY `list_order` ASC,`id` ASC
  39. 2021-03-08 10:13:53.616 [DEBU] [ 26 ms] [default] SHOW FULL COLUMNS FROM `cms_news`
  40. 2021-03-08 10:13:53.632 [DEBU] [ 14 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id)
  41. 2021-03-08 10:13:53.633 [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
  42. 2021-03-08 10:13:53.660 [DEBU] [ 24 ms] [default] SHOW FULL COLUMNS FROM `cms_category_news`
  43. 2021-03-08 10:13:53.662 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
  44. 2021-03-08 10:13:53.664 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
  45. 2021-03-08 10:13:53.665 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=128
  46. 2021-03-08 10:13:53.666 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
  47. 2021-03-08 10:13:53.666 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
  48. 2021-03-08 10:13:53.667 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
  49. 2021-03-08 10:13:53.668 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
  50. 2021-03-08 10:13:53.669 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=123
  51. 2021-03-08 10:13:53.670 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=122
  52. 2021-03-08 10:13:53.670 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=121
  53. 2021-03-08 10:13:53.713 [DEBU] [ 43 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
  54. 2021-03-08 10:13:53.721 [DEBU] [ 6 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_pub_type' AND `status`=1 LIMIT 1
  55. 2021-03-08 10:13:53.749 [DEBU] [ 28 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
  56. 2021-03-08 10:13:53.750 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_pub_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
  57. 2021-03-08 10:13:53.752 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_attr' AND `status`=1 LIMIT 1
  58. 2021-03-08 10:13:53.752 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_attr' ORDER BY `dict_sort` ASC,`dict_code` ASC
  59. 2021-03-08 10:13:53.754 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_type' AND `status`=1 LIMIT 1
  60. 2021-03-08 10:13:53.755 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
  61. 2021-03-08 10:13:53.759 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_ip`,`status`,`oper_time`,`oper_id`,`business_type`,`request_method`,`oper_name`,`dept_name`,`oper_location`,`json_result`,`title`,`method`,`operator_type`,`oper_param`,`error_msg`) VALUES('/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','[::1]',1,1615169633,0,0,'GET','demo','','内网IP','{"code":0,"msg":"信息列表"}','文章管理','/system/cms/news/list',1,'{"keyWords":"","pageNum":"1","pageSize":"10"}','') ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`)
  62. 2021-03-08 10:14:12.318 [DEBU] [ 2 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
  63. 2021-03-08 10:14:12.321 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
  64. 2021-03-08 10:14:12.324 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_ip`,`oper_param`,`oper_id`,`method`,`oper_name`,`oper_time`,`title`,`business_type`,`json_result`,`error_msg`,`request_method`,`oper_location`,`status`,`operator_type`,`oper_url`) VALUES('','[::1]','{"dictType":"sys_normal_disable"}',0,'/system/config/dict/getDicts','demo',1615169652,'',0,'{"code":0,"msg":"ok"}','','GET','内网IP',1,1,'/system/config/dict/getDicts?dictType=sys_normal_disable') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`)
  65. 2021-03-08 10:14:12.363 [DEBU] [ 47 ms] [default] SHOW FULL COLUMNS FROM `model_category`
  66. 2021-03-08 10:14:12.365 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `model_category`
  67. 2021-03-08 10:14:12.365 [DEBU] [ 0 ms] [default] SELECT * FROM `model_category` ORDER BY `c_sort` asc,`c_id` asc LIMIT 0,10
  68. 2021-03-08 10:14:12.368 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`title`,`method`,`oper_ip`,`oper_location`,`oper_param`,`oper_id`,`oper_name`,`dept_name`,`oper_time`,`request_method`,`json_result`,`status`,`error_msg`,`operator_type`,`oper_url`,`business_type`) VALUES('模型分类','/system/model/category/list','[::1]','内网IP','{"pageNum":"1","pageSize":"10"}',0,'demo','',1615169652,'GET','{"code":0,"msg":"信息列表"}',1,'',1,'/system/model/category/list?pageNum=1&pageSize=10',0) ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`business_type`=VALUES(`business_type`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`)
  69. 2021-03-08 10:14:13.405 [DEBU] [ 2 ms] [default] SELECT * FROM `model_category` WHERE `c_status`=1 ORDER BY `c_sort` ASC,`c_id` ASC
  70. 2021-03-08 10:14:13.408 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`oper_time`,`business_type`,`method`,`oper_location`,`oper_ip`,`error_msg`,`oper_id`,`title`,`oper_url`,`operator_type`,`json_result`,`status`,`request_method`,`oper_name`,`dept_name`) VALUES('{}',1615169653,0,'/system/model/category/all','内网IP','[::1]','',0,'','/system/model/category/all',1,'{"code":0,"msg":"ok"}',1,'GET','demo','') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`operator_type`=VALUES(`operator_type`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`)
  71. 2021-03-08 10:14:13.412 [DEBU] [ 5 ms] [default] INSERT INTO `sys_oper_log`(`status`,`oper_time`,`method`,`dept_name`,`oper_ip`,`json_result`,`error_msg`,`operator_type`,`oper_name`,`oper_location`,`oper_param`,`oper_id`,`title`,`business_type`,`oper_url`,`request_method`) VALUES(1,1615169653,'/system/config/dict/getDicts','','[::1]','{"code":0,"msg":"ok"}','',1,'demo','内网IP','{"dictType":"sys_normal_disable"}',0,'',0,'/system/config/dict/getDicts?dictType=sys_normal_disable','GET') ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`request_method`=VALUES(`request_method`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`)
  72. 2021-03-08 10:14:13.428 [DEBU] [ 26 ms] [default] SHOW FULL COLUMNS FROM `model_info`
  73. 2021-03-08 10:14:13.430 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `model_info` info LEFT JOIN `model_category` cate ON (cate.c_id=info.model_category_id)
  74. 2021-03-08 10:14:13.445 [DEBU] [ 15 ms] [default] SELECT info.*,cate.c_name FROM `model_info` info LEFT JOIN `model_category` cate ON (cate.c_id=info.model_category_id) ORDER BY `info`.`model_id` asc LIMIT 0,10
  75. 2021-03-08 10:14:13.452 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`oper_ip`,`error_msg`,`operator_type`,`oper_name`,`oper_url`,`status`,`oper_time`,`method`,`request_method`,`dept_name`,`oper_param`,`json_result`,`oper_id`,`business_type`,`oper_location`) VALUES('模型列表','[::1]','',1,'demo','/system/model/info/list?pageNum=1&pageSize=10',1,1615169653,'/system/model/info/list','GET','','{"pageNum":"1","pageSize":"10"}','{"code":0,"msg":"获取列表数据成功"}',0,0,'内网IP') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`operator_type`=VALUES(`operator_type`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`business_type`=VALUES(`business_type`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`)
  76. 2021-03-08 10:14:21.356 [DEBU] [ 50 ms] [default] SHOW FULL COLUMNS FROM `model_fields`
  77. 2021-03-08 10:14:21.357 [DEBU] [ 1 ms] [default] SELECT * FROM `model_fields` WHERE `model_id`=9 ORDER BY `field_sort` asc,`field_id` asc
  78. 2021-03-08 10:14:21.359 [DEBU] [ 0 ms] [default] SELECT * FROM `model_info` WHERE `model_id`=9 LIMIT 1
  79. 2021-03-08 10:14:21.364 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`operator_type`,`oper_ip`,`status`,`title`,`method`,`dept_name`,`oper_location`,`oper_param`,`error_msg`,`oper_id`,`oper_url`,`business_type`,`oper_name`,`json_result`,`oper_time`) VALUES('GET',1,'[::1]',1,'','/system/model/fields/list','','内网IP','{"modelId":"9"}','',0,'/system/model/fields/list?modelId=9',0,'demo','{"code":0,"msg":"获取列表数据成功"}',1615169661) ON DUPLICATE KEY UPDATE `oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_id`=VALUES(`oper_id`),`oper_url`=VALUES(`oper_url`)
  80. 2021-03-08 10:15:03.263 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id)
  81. 2021-03-08 10:15:03.264 [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
  82. 2021-03-08 10:15:03.268 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
  83. 2021-03-08 10:15:03.269 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
  84. 2021-03-08 10:15:03.270 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=128
  85. 2021-03-08 10:15:03.271 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
  86. 2021-03-08 10:15:03.272 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
  87. 2021-03-08 10:15:03.272 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
  88. 2021-03-08 10:15:03.273 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
  89. 2021-03-08 10:15:03.274 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=123
  90. 2021-03-08 10:15:03.274 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=122
  91. 2021-03-08 10:15:03.275 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=121
  92. 2021-03-08 10:15:03.280 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`title`,`business_type`,`method`,`operator_type`,`dept_name`,`oper_ip`,`oper_time`,`request_method`,`json_result`,`status`,`error_msg`,`oper_name`,`oper_url`,`oper_location`,`oper_param`) VALUES(0,'文章管理',0,'/system/cms/news/list',1,'','[::1]',1615169703,'GET','{"code":0,"msg":"信息列表"}',1,'','demo','/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','内网IP','{"keyWords":"","pageNum":"1","pageSize":"10"}') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`)
  93. 2021-03-08 10:15:04.732 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_news` WHERE `id`=130 LIMIT 1
  94. 2021-03-08 10:15:04.732 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
  95. 2021-03-08 10:15:04.735 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`status`,`business_type`,`oper_name`,`oper_param`,`title`,`request_method`,`operator_type`,`oper_location`,`oper_time`,`oper_id`,`method`,`dept_name`,`oper_url`,`oper_ip`,`error_msg`) VALUES('{"code":0,"msg":"添加信息"}',1,0,'demo','{"id":"130"}','修改文章','GET',1,'内网IP',1615169704,0,'/system/cms/news/edit','','/system/cms/news/edit?id=130','[::1]','') ON DUPLICATE KEY UPDATE `oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`)
  96. 2021-03-08 10:15:04.806 [DEBU] [ 0 ms] [default] SELECT * FROM `model_info` WHERE `model_id`=9 LIMIT 1
  97. 2021-03-08 10:15:04.808 [DEBU] [ 1 ms] [default] SELECT * FROM `model_fields` WHERE `model_id`=9 ORDER BY `field_sort` asc,`field_id` asc
  98. 2021-03-08 10:15:04.849 [DEBU] [ 40 ms] [default] SHOW FULL COLUMNS FROM `cms_news_attr`
  99. 2021-03-08 10:15:04.851 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_news_attr` WHERE `art_id`=130 LIMIT 1
  100. 2021-03-08 10:15:04.856 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_name`,`dept_name`,`oper_param`,`oper_time`,`oper_id`,`method`,`request_method`,`oper_url`,`business_type`,`oper_location`,`error_msg`,`oper_ip`,`json_result`,`status`,`title`) VALUES(1,'demo','','{"cateIds":["28"],"newsId":"130"}',1615169704,0,'/system/cms/news/getModelFields','GET','/system/cms/news/getModelFields?cateIds[]=28&newsId=130',0,'内网IP','','[::1]','{"code":0,"msg":"ok"}',1,'') ON DUPLICATE KEY UPDATE `oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`)
  101. 2021-03-08 10:16:50.612 [DEBU] [ 3 ms] [default] SELECT * FROM `cms_news` WHERE `id`=130 LIMIT 1
  102. 2021-03-08 10:16:50.614 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
  103. 2021-03-08 10:16:50.616 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`method`,`json_result`,`error_msg`,`oper_id`,`operator_type`,`dept_name`,`status`,`oper_time`,`title`,`business_type`,`request_method`,`oper_url`,`oper_name`,`oper_ip`,`oper_location`,`oper_param`) VALUES('/system/cms/news/edit','{"code":0,"msg":"添加信息"}','',0,1,'',1,1615169810,'修改文章',0,'GET','/system/cms/news/edit?id=130','demo','[::1]','内网IP','{"id":"130"}') ON DUPLICATE KEY UPDATE `oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`title`=VALUES(`title`)
  104. 2021-03-08 10:16:50.682 [DEBU] [ 1 ms] [default] SELECT * FROM `model_info` WHERE `model_id`=9 LIMIT 1
  105. 2021-03-08 10:16:50.683 [DEBU] [ 0 ms] [default] SELECT * FROM `model_fields` WHERE `model_id`=9 ORDER BY `field_sort` asc,`field_id` asc
  106. 2021-03-08 10:16:50.686 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_news_attr` WHERE `art_id`=130 LIMIT 1
  107. 2021-03-08 10:16:50.691 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`method`,`error_msg`,`oper_id`,`operator_type`,`json_result`,`status`,`title`,`request_method`,`oper_url`,`oper_param`,`oper_name`,`dept_name`,`oper_ip`,`oper_location`,`oper_time`) VALUES(0,'/system/cms/news/getModelFields','',0,1,'{"code":0,"msg":"ok"}',1,'','GET','/system/cms/news/getModelFields?cateIds[]=28&newsId=130','{"cateIds":["28"],"newsId":"130"}','demo','','[::1]','内网IP',1615169810) ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`oper_name`=VALUES(`oper_name`)
  108. 2021-03-08 10:17:39.517 [DEBU] [ 4 ms] [default] SELECT COUNT(1) FROM `model_category`
  109. 2021-03-08 10:17:39.519 [DEBU] [ 0 ms] [default] SELECT * FROM `model_category` ORDER BY `c_sort` asc,`c_id` asc LIMIT 0,10
  110. 2021-03-08 10:17:39.520 [DEBU] [ 3 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_time`,`operator_type`,`json_result`,`business_type`,`method`,`oper_name`,`oper_url`,`oper_ip`,`error_msg`,`title`,`request_method`,`oper_param`,`status`,`oper_id`,`oper_location`) VALUES('',1615169859,1,'{"code":0,"msg":"ok"}',0,'/system/config/dict/getDicts','demo','/system/config/dict/getDicts?dictType=sys_normal_disable','[::1]','','','GET','{"dictType":"sys_normal_disable"}',1,0,'内网IP') ON DUPLICATE KEY UPDATE `dept_name`=VALUES(`dept_name`),`oper_time`=VALUES(`oper_time`),`json_result`=VALUES(`json_result`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`)
  111. 2021-03-08 10:17:39.523 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`status`,`error_msg`,`title`,`business_type`,`json_result`,`oper_id`,`dept_name`,`oper_url`,`oper_param`,`method`,`request_method`,`operator_type`,`oper_time`,`oper_name`,`oper_ip`,`oper_location`) VALUES(1,'','模型分类',0,'{"code":0,"msg":"信息列表"}',0,'','/system/model/category/list?pageNum=1&pageSize=10','{"pageNum":"1","pageSize":"10"}','/system/model/category/list','GET',1,1615169859,'demo','[::1]','内网IP') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`oper_param`=VALUES(`oper_param`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`)
  112. 2021-03-08 10:17:40.103 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `model_info` info LEFT JOIN `model_category` cate ON (cate.c_id=info.model_category_id)
  113. 2021-03-08 10:17:40.106 [DEBU] [ 1 ms] [default] SELECT info.*,cate.c_name FROM `model_info` info LEFT JOIN `model_category` cate ON (cate.c_id=info.model_category_id) ORDER BY `info`.`model_id` asc LIMIT 0,10
  114. 2021-03-08 10:17:40.107 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`method`,`request_method`,`dept_name`,`oper_ip`,`oper_location`,`status`,`error_msg`,`oper_time`,`operator_type`,`oper_param`,`title`,`business_type`,`oper_name`,`oper_id`,`oper_url`,`json_result`) VALUES('/system/model/category/all','GET','','[::1]','内网IP',1,'',1615169860,1,'{}','',0,'demo',0,'/system/model/category/all','{"code":0,"msg":"ok"}') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`)
  115. 2021-03-08 10:17:40.108 [DEBU] [ 3 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`title`,`oper_url`,`status`,`oper_time`,`oper_id`,`business_type`,`oper_ip`,`oper_param`,`json_result`,`error_msg`,`method`,`request_method`,`operator_type`,`oper_name`,`dept_name`) VALUES('内网IP','','/system/config/dict/getDicts?dictType=sys_normal_disable',1,1615169860,0,0,'[::1]','{"dictType":"sys_normal_disable"}','{"code":0,"msg":"ok"}','','/system/config/dict/getDicts','GET',1,'demo','') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`)
  116. 2021-03-08 10:17:40.111 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`json_result`,`request_method`,`oper_name`,`oper_ip`,`oper_param`,`status`,`error_msg`,`oper_id`,`business_type`,`dept_name`,`oper_url`,`title`,`method`,`operator_type`,`oper_time`) VALUES('内网IP','{"code":0,"msg":"获取列表数据成功"}','GET','demo','[::1]','{"pageNum":"1","pageSize":"10"}',1,'',0,0,'','/system/model/info/list?pageNum=1&pageSize=10','模型列表','/system/model/info/list',1,1615169860) ON DUPLICATE KEY UPDATE `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`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`)
  117. 2021-03-08 10:17:49.457 [DEBU] [ 1 ms] [default] SELECT * FROM `model_fields` WHERE `model_id`=9 ORDER BY `field_sort` asc,`field_id` asc
  118. 2021-03-08 10:17:49.461 [DEBU] [ 0 ms] [default] SELECT * FROM `model_info` WHERE `model_id`=9 LIMIT 1
  119. 2021-03-08 10:17:49.465 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`business_type`,`request_method`,`oper_name`,`oper_url`,`oper_ip`,`title`,`dept_name`,`oper_location`,`oper_param`,`status`,`method`,`json_result`,`error_msg`,`oper_time`,`operator_type`) VALUES(0,0,'GET','demo','/system/model/fields/list?modelId=9','[::1]','','','内网IP','{"modelId":"9"}',1,'/system/model/fields/list','{"code":0,"msg":"获取列表数据成功"}','',1615169869,1) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`operator_type`=VALUES(`operator_type`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`)
  120. 2021-03-08 10:18:06.185 [DEBU] [ 0 ms] [default] SELECT * FROM `model_fields` WHERE `field_id`=18 LIMIT 1
  121. 2021-03-08 10:18:06.189 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`request_method`,`dept_name`,`oper_param`,`oper_id`,`oper_time`,`oper_url`,`operator_type`,`oper_name`,`oper_ip`,`status`,`title`,`oper_location`,`json_result`,`error_msg`,`method`) VALUES(0,'GET','','{"id":"18"}',0,1615169886,'/system/model/fields/edit?id=18',1,'demo','[::1]',1,'','内网IP','{"code":0,"msg":"ok"}','','/system/model/fields/edit') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`method`=VALUES(`method`),`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`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`)
  122. 2021-03-08 10:20:05.033 [DEBU] [ 4 ms] [default] SELECT COUNT(1) FROM `user_online`
  123. 2021-03-08 10:20:05.035 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
  124. 2021-03-08 10:20:05.991 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `user_online`
  125. 2021-03-08 10:20:05.991 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
  126. 2021-03-08 10:20:41.462 [DEBU] [ 3 ms] [default] SELECT COUNT(1) FROM `model_info` info LEFT JOIN `model_category` cate ON (cate.c_id=info.model_category_id)
  127. 2021-03-08 10:20:41.463 [DEBU] [ 1 ms] [default] SELECT info.*,cate.c_name FROM `model_info` info LEFT JOIN `model_category` cate ON (cate.c_id=info.model_category_id) ORDER BY `info`.`model_id` asc LIMIT 0,10
  128. 2021-03-08 10:20:41.465 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`oper_param`,`json_result`,`oper_time`,`title`,`method`,`oper_url`,`oper_ip`,`oper_location`,`error_msg`,`oper_id`,`business_type`,`request_method`,`dept_name`,`status`,`operator_type`) VALUES('demo','{}','{"code":0,"msg":"ok"}',1615170041,'','/system/model/category/all','/system/model/category/all','[::1]','内网IP','',0,0,'GET','',1,1) ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`)
  129. 2021-03-08 10:20:41.466 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_param`,`status`,`business_type`,`operator_type`,`oper_location`,`method`,`request_method`,`oper_name`,`oper_ip`,`error_msg`,`oper_time`,`oper_id`,`dept_name`,`json_result`,`title`) VALUES('/system/config/dict/getDicts?dictType=sys_normal_disable','{"dictType":"sys_normal_disable"}',1,0,1,'内网IP','/system/config/dict/getDicts','GET','demo','[::1]','',1615170041,0,'','{"code":0,"msg":"ok"}','') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`)
  130. 2021-03-08 10:20:41.468 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`business_type`,`oper_time`,`request_method`,`oper_param`,`status`,`error_msg`,`title`,`method`,`operator_type`,`oper_ip`,`json_result`,`oper_name`,`dept_name`,`oper_url`,`oper_location`) VALUES(0,0,1615170041,'GET','{"pageNum":"1","pageSize":"10"}',1,'','模型列表','/system/model/info/list',1,'[::1]','{"code":0,"msg":"获取列表数据成功"}','demo','','/system/model/info/list?pageNum=1&pageSize=10','内网IP') ON DUPLICATE KEY UPDATE `json_result`=VALUES(`json_result`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`)
  131. 2021-03-08 10:20:43.220 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `model_category`
  132. 2021-03-08 10:20:43.221 [DEBU] [ 0 ms] [default] SELECT * FROM `model_category` ORDER BY `c_sort` asc,`c_id` asc LIMIT 0,10
  133. 2021-03-08 10:20:43.226 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`title`,`method`,`request_method`,`oper_url`,`oper_param`,`error_msg`,`business_type`,`dept_name`,`oper_ip`,`operator_type`,`oper_time`,`oper_name`,`oper_location`,`json_result`,`status`) VALUES(0,'模型分类','/system/model/category/list','GET','/system/model/category/list?pageNum=1&pageSize=10','{"pageNum":"1","pageSize":"10"}','',0,'','[::1]',1,1615170043,'demo','内网IP','{"code":0,"msg":"信息列表"}',1) ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`operator_type`=VALUES(`operator_type`),`oper_time`=VALUES(`oper_time`)
  134. 2021-03-08 10:20:43.227 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`error_msg`,`oper_id`,`operator_type`,`oper_location`,`status`,`request_method`,`oper_ip`,`business_type`,`dept_name`,`oper_url`,`json_result`,`oper_time`,`title`,`method`,`oper_name`,`oper_param`) VALUES('',0,1,'内网IP',1,'GET','[::1]',0,'','/system/config/dict/getDicts?dictType=sys_normal_disable','{"code":0,"msg":"ok"}',1615170043,'','/system/config/dict/getDicts','demo','{"dictType":"sys_normal_disable"}') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`)
  135. 2021-03-08 10:22:30.819 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `model_info` info LEFT JOIN `model_category` cate ON (cate.c_id=info.model_category_id)
  136. 2021-03-08 10:22:30.820 [DEBU] [ 5 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`oper_name`,`oper_ip`,`oper_param`,`json_result`,`error_msg`,`method`,`request_method`,`operator_type`,`business_type`,`oper_url`,`status`,`oper_location`,`oper_id`,`title`,`dept_name`) VALUES(1615170150,'demo','[::1]','{}','{"code":0,"msg":"ok"}','','/system/model/category/all','GET',1,0,'/system/model/category/all',1,'内网IP',0,'','') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`)
  137. 2021-03-08 10:22:30.821 [DEBU] [ 4 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_name`,`oper_param`,`error_msg`,`business_type`,`oper_url`,`oper_ip`,`json_result`,`oper_id`,`dept_name`,`request_method`,`operator_type`,`oper_location`,`status`,`oper_time`,`title`) VALUES('/system/config/dict/getDicts','demo','{"dictType":"sys_normal_disable"}','',0,'/system/config/dict/getDicts?dictType=sys_normal_disable','[::1]','{"code":0,"msg":"ok"}',0,'','GET',1,'内网IP',1,1615170150,'') ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`dept_name`=VALUES(`dept_name`)
  138. 2021-03-08 10:22:30.822 [DEBU] [ 1 ms] [default] SELECT info.*,cate.c_name FROM `model_info` info LEFT JOIN `model_category` cate ON (cate.c_id=info.model_category_id) ORDER BY `info`.`model_id` asc LIMIT 0,10
  139. 2021-03-08 10:22:30.828 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`oper_param`,`oper_id`,`request_method`,`oper_url`,`status`,`error_msg`,`method`,`json_result`,`title`,`business_type`,`operator_type`,`oper_name`,`dept_name`,`oper_ip`,`oper_time`) VALUES('内网IP','{"pageNum":"1","pageSize":"10"}',0,'GET','/system/model/info/list?pageNum=1&pageSize=10',1,'','/system/model/info/list','{"code":0,"msg":"获取列表数据成功"}','模型列表',0,1,'demo','','[::1]',1615170150) ON DUPLICATE KEY UPDATE `json_result`=VALUES(`json_result`),`method`=VALUES(`method`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`oper_param`=VALUES(`oper_param`),`oper_location`=VALUES(`oper_location`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`)
  140. 2021-03-08 10:22:38.434 [DEBU] [ 1 ms] [default] SELECT * FROM `gen_table` WHERE `table_id`=40 LIMIT 1
  141. 2021-03-08 10:22:38.435 [DEBU] [ 1 ms] [default] SELECT * FROM `gen_table_column` WHERE `table_id`=40 ORDER BY `sort` asc,`column_id` asc
  142. 2021-03-08 10:22:38.584 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`title`,`oper_ip`,`error_msg`,`business_type`,`request_method`,`dept_name`,`oper_param`,`oper_time`,`method`,`oper_name`,`oper_url`,`json_result`,`status`,`operator_type`,`oper_location`) VALUES(0,'','[::1]','',0,'GET','','{"tableId":"40"}',1615170158,'/system/tools/gen/preview','demo','/system/tools/gen/preview?tableId=40','{"code":0,"msg":"ok"}',1,1,'内网IP') ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`)
  143. 2021-03-08 10:23:02.082 [DEBU] [ 1 ms] [default] SELECT * FROM `gen_table` WHERE `table_id`=40 LIMIT 1
  144. 2021-03-08 10:23:02.083 [DEBU] [ 0 ms] [default] SELECT * FROM `gen_table_column` WHERE `table_id`=40 ORDER BY `sort` asc,`column_id` asc
  145. 2021-03-08 10:23:02.231 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`error_msg`,`oper_time`,`operator_type`,`oper_name`,`oper_url`,`json_result`,`business_type`,`dept_name`,`oper_location`,`oper_id`,`title`,`oper_param`,`status`,`method`,`request_method`,`oper_ip`) VALUES('',1615170182,1,'demo','/system/tools/gen/preview?tableId=40','{"code":0,"msg":"ok"}',0,'','内网IP',0,'','{"tableId":"40"}',1,'/system/tools/gen/preview','GET','[::1]') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`)
  146. 2021-03-08 10:30:05.091 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
  147. 2021-03-08 10:30:05.092 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50