Accueil Explorer Aide
Connexion
go_lizi
/
gfast
2
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki
Aborescence: 28c926d014
Branches Tags
gfast
/
data
/
log
/
sql
/
2021-03-24.log

2021-03-24.log 12 KB
Historique Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 
  1. 2021-03-24 09:10:36.220 [DEBU] [ 75 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
    2. 

  2. 2021-03-24 09:10:36.232 [DEBU] [  9 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
    3. 

  3. 2021-03-24 09:10:36.235 [DEBU] [  1 ms] [default] INSERT INTO `sys_job`(`job_params`,`cron_expression`,`create_by`,`remark`,`job_id`,`invoke_target`,`status`,`misfire_policy`,`concurrent`,`create_time`,`job_name`,`job_group`,`update_by`,`update_time`) VALUES('','5 */10 * * * *',2,'',8,'checkUserOnline',0,1,0,1596763977,'在线用户定时更新','DEFAULT',2,1596768044) ON DUPLICATE KEY UPDATE `misfire_policy`=VALUES(`misfire_policy`),`concurrent`=VALUES(`concurrent`),`create_time`=VALUES(`create_time`),`job_name`=VALUES(`job_name`),`job_group`=VALUES(`job_group`),`update_by`=VALUES(`update_by`),`update_time`=VALUES(`update_time`),`job_params`=VALUES(`job_params`),`cron_expression`=VALUES(`cron_expression`),`create_by`=VALUES(`create_by`),`remark`=VALUES(`remark`),`job_id`=VALUES(`job_id`),`invoke_target`=VALUES(`invoke_target`),`status`=VALUES(`status`)
    4. 

  4. 2021-03-24 09:10:52.799 [DEBU] [ 35 ms] [default] SHOW FULL COLUMNS FROM `role`
    5. 

  5. 2021-03-24 09:10:52.800 [DEBU] [  0 ms] [default] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
    6. 

  6. 2021-03-24 09:10:52.840 [DEBU] [ 39 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule`
    7. 

  7. 2021-03-24 09:10:52.852 [DEBU] [ 11 ms] [default] SELECT * FROM `casbin_rule`
    8. 

  8. 2021-03-24 09:10:52.896 [DEBU] [ 39 ms] [default] SHOW FULL COLUMNS FROM `cms_category`
    9. 

  9. 2021-03-24 09:10:52.898 [DEBU] [  0 ms] [default] SELECT * FROM `cms_category` ORDER BY `list_order` ASC,`id` ASC
    10. 

  10. 2021-03-24 09:10:52.928 [DEBU] [ 25 ms] [default] SHOW FULL COLUMNS FROM `cms_news`
    11. 

  11. 2021-03-24 09:10:52.973 [DEBU] [ 44 ms] [default] SHOW FULL COLUMNS FROM `user`
    12. 

  12. 2021-03-24 09:10:52.975 [DEBU] [  0 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE user.dept_id IN(101)
    13. 

  13. 2021-03-24 09:10:52.976 [DEBU] [  0 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE user.dept_id IN(101) ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,10
    14. 

  14. 2021-03-24 09:10:53.026 [DEBU] [ 49 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
    15. 

  15. 2021-03-24 09:10:53.029 [DEBU] [  2 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_pub_type' AND `status`=1 LIMIT 1
    16. 

  16. 2021-03-24 09:10:53.234 [DEBU] [203 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
    17. 

  17. 2021-03-24 09:10:53.236 [DEBU] [  1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_pub_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
    18. 

  18. 2021-03-24 09:10:53.238 [DEBU] [  0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_attr' AND `status`=1 LIMIT 1
    19. 

  19. 2021-03-24 09:10:53.240 [DEBU] [  1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_attr' ORDER BY `dict_sort` ASC,`dict_code` ASC
    20. 

  20. 2021-03-24 09:10:53.243 [DEBU] [  2 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_type' AND `status`=1 LIMIT 1
    21. 

  21. 2021-03-24 09:10:53.245 [DEBU] [  2 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
    22. 

  22. 2021-03-24 09:10:53.303 [DEBU] [ 53 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
    23. 

  23. 2021-03-24 09:10:53.324 [DEBU] [ 20 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
    24. 

  24. 2021-03-24 09:10:53.365 [DEBU] [ 26 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
    25. 

  25. 2021-03-24 09:10:53.386 [DEBU] [ 20 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`method`,`request_method`,`operator_type`,`oper_url`,`json_result`,`oper_name`,`dept_name`,`oper_ip`,`oper_param`,`oper_id`,`title`,`status`,`error_msg`,`oper_time`,`oper_location`) VALUES(0,'/system/cms/news/list','GET',1,'/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','{"code":0,"msg":"信息列表"}','admin','','127.0.0.1','{"keyWords":"","pageNum":"1","pageSize":"10"}',0,'文章管理',1,'',1616548253,'内网IP') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_location`=VALUES(`oper_location`)
    26. 

  26. 2021-03-24 09:11:15.375 [DEBU] [  2 ms] [default] SELECT * FROM `role` WHERE id=1 LIMIT 1
    27. 

  27. 2021-03-24 09:11:15.381 [DEBU] [  0 ms] [default] INSERT INTO `sys_oper_log`(`title`,`oper_name`,`oper_time`,`status`,`error_msg`,`oper_url`,`oper_ip`,`json_result`,`oper_param`,`oper_id`,`request_method`,`oper_location`,`dept_name`,`business_type`,`method`,`operator_type`) VALUES('修改角色','admin',1616548275,1,'','/system/auth/editRole?roleId=1','127.0.0.1','{"code":0,"msg":"成功"}','{"roleId":"1"}',0,'GET','内网IP','',0,'/system/auth/editRole',1) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`oper_time`=VALUES(`oper_time`)
    28. 

  28. 2021-03-24 09:11:15.418 [DEBU] [ 45 ms] [default] SHOW FULL COLUMNS FROM `sys_dept`
    29. 

  29. 2021-03-24 09:11:15.419 [DEBU] [  0 ms] [default] SELECT * FROM `sys_dept` WHERE `status`='1'
    30. 

  30. 2021-03-24 09:11:15.430 [DEBU] [  8 ms] [default] SHOW FULL COLUMNS FROM `role_dept`
    31. 

  31. 2021-03-24 09:11:15.433 [DEBU] [  2 ms] [default] SELECT * FROM `role_dept` WHERE `role_id`=1
    32. 

  32. 2021-03-24 09:11:15.436 [DEBU] [  1 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`oper_name`,`request_method`,`business_type`,`method`,`operator_type`,`oper_url`,`oper_ip`,`oper_location`,`status`,`error_msg`,`title`,`dept_name`,`json_result`,`oper_time`,`oper_id`) VALUES('{"roleId":"1"}','admin','GET',0,'/system/dept/roleDeptTreeSelect',1,'/system/dept/roleDeptTreeSelect?roleId=1','127.0.0.1','内网IP',1,'','','','{"code":0,"msg":"ok"}',1616548275,0) ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`)
    33. 

  33. 2021-03-24 09:11:18.613 [DEBU] [  1 ms] [default] UPDATE `role` SET `data_scope`=1 WHERE `id`=1
    34. 

  34. 2021-03-24 09:11:18.653 [DEBU] [  1 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
    35. 

  35. 2021-03-24 09:11:18.681 [DEBU] [ 15 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`error_msg`,`oper_url`,`business_type`,`method`,`request_method`,`dept_name`,`oper_location`,`json_result`,`oper_id`,`oper_name`,`status`,`oper_time`,`title`,`oper_ip`,`operator_type`) VALUES('{"dataScope":"1","deptIds":[],"menuIds":[1,5,19,20,21,22,23,24,25,6,2,8,16,17,18,26,27,29,30,31,28,33,40,3,34,36,37,38,39,4,32,35],"remark":"备注","roleId":1,"roleName":"超级管理员","roleSort":0,"status":"1"}','','/system/auth/roleDataScope',0,'/system/auth/roleDataScope','PUT','','内网IP','{"code":0,"msg":"数据权限设置成功"}',0,'admin',1,1616548278,'','127.0.0.1',1) ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`)
    36. 

  36. 2021-03-24 09:11:18.699 [DEBU] [ 15 ms] [default] SELECT COUNT(1) FROM `role`
    37. 

  37. 2021-03-24 09:11:18.701 [DEBU] [  1 ms] [default] SELECT * FROM `role` ORDER BY `id` asc LIMIT 0,10
    38. 

  38. 2021-03-24 09:11:18.702 [DEBU] [  1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
    39. 

  39. 2021-03-24 09:11:18.703 [DEBU] [  1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
    40. 

  40. 2021-03-24 09:11:18.706 [DEBU] [  1 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`oper_location`,`oper_ip`,`oper_param`,`business_type`,`title`,`method`,`oper_name`,`dept_name`,`oper_url`,`json_result`,`status`,`oper_id`,`operator_type`,`error_msg`,`request_method`) VALUES(1616548278,'内网IP','127.0.0.1','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}',0,'角色管理','/system/auth/roleList','admin','','/system/auth/roleList?pageNum=1&pageSize=10&beginTime=&endTime=','{"code":0,"msg":"成功"}',1,0,1,'','GET') ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`error_msg`=VALUES(`error_msg`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`)
    41. 

  41. 2021-03-24 09:11:24.307 [DEBU] [  1 ms] [default] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
    42. 

  42. 2021-03-24 09:11:24.308 [DEBU] [  0 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id)
    43. 

  43. 2021-03-24 09:11:24.309 [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
    44. 

  44. 2021-03-24 09:11:24.372 [DEBU] [ 60 ms] [default] SHOW FULL COLUMNS FROM `cms_category_news`
    45. 

  45. 2021-03-24 09:11:24.375 [DEBU] [  2 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
    46. 

  46. 2021-03-24 09:11:24.376 [DEBU] [  1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
    47. 

  47. 2021-03-24 09:11:24.376 [DEBU] [  0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=128
    48. 

  48. 2021-03-24 09:11:24.378 [DEBU] [  1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
    49. 

  49. 2021-03-24 09:11:24.380 [DEBU] [  1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
    50. 

  50. 2021-03-24 09:11:24.381 [DEBU] [  1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
    51. 

  51. 2021-03-24 09:11:24.381 [DEBU] [  0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
    52. 

  52. 2021-03-24 09:11:24.382 [DEBU] [  1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=123
    53. 

  53. 2021-03-24 09:11:24.383 [DEBU] [  1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=122
    54. 

  54. 2021-03-24 09:11:24.383 [DEBU] [  0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=121
    55. 

  55. 2021-03-24 09:11:24.387 [DEBU] [  1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`title`,`request_method`,`oper_url`,`oper_location`,`json_result`,`method`,`operator_type`,`dept_name`,`oper_ip`,`oper_name`,`status`,`error_msg`,`business_type`,`oper_param`,`oper_time`) VALUES(0,'文章管理','GET','/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','内网IP','{"code":0,"msg":"信息列表"}','/system/cms/news/list',1,'','127.0.0.1','admin',1,'',0,'{"keyWords":"","pageNum":"1","pageSize":"10"}',1616548284) ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`)
    56.