2020-07-24.log 29 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. 2020-07-24 11:50:40.881 [DEBU] [ 46 ms] SHOW FULL COLUMNS FROM `sys_job`
  2. 2020-07-24 11:50:40.891 [DEBU] [ 7 ms] SELECT * FROM `sys_job` WHERE `status`=0
  3. 2020-07-24 11:51:17.427 [DEBU] [ 55 ms] SHOW FULL COLUMNS FROM `user`
  4. 2020-07-24 11:51:17.430 [DEBU] [ 1 ms] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA=='
  5. 2020-07-24 11:51:17.493 [DEBU] [ 61 ms] UPDATE `user` SET `sex`=2,`mobile`='18699888856',`birthday`=0,`user_password`='9OFlt5qzzvCiZWhe7ilcLA==',`user_status`=1,`user_email`='223@qq.com',`dept_id`=109,`is_admin`=1,`id`=31,`create_time`=1581314770,`avatar`='pub_upload/2020-07-06/c3z4e80h9q9sdfspwe.jpeg',`user_nickname`='测试账号',`last_login_time`=1595562677,`last_login_ip`='[::1]',`remark`='',`user_name`='demo' WHERE `id` IN (31)
  6. 2020-07-24 11:51:17.549 [DEBU] [ 54 ms] SHOW FULL COLUMNS FROM `sys_login_log`
  7. 2020-07-24 11:51:17.552 [DEBU] [ 55 ms] SHOW FULL COLUMNS FROM `user_online`
  8. 2020-07-24 11:51:17.557 [DEBU] [ 7 ms] INSERT INTO `sys_login_log`(`info_id`,`status`,`login_time`,`browser`,`os`,`msg`,`login_name`,`ipaddr`,`login_location`) VALUES(0,1,1595562677,'Chrome','Windows 10','登录成功','demo','[::1]','内网IP') ON DUPLICATE KEY UPDATE `info_id`=VALUES(`info_id`),`status`=VALUES(`status`),`login_time`=VALUES(`login_time`),`login_name`=VALUES(`login_name`),`ipaddr`=VALUES(`ipaddr`),`login_location`=VALUES(`login_location`),`browser`=VALUES(`browser`),`os`=VALUES(`os`),`msg`=VALUES(`msg`)
  9. 2020-07-24 11:51:17.572 [DEBU] [ 18 ms] INSERT INTO `user_online`(`os`,`id`,`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`) VALUES('Windows 10',0,'be93ef43f9eb2ce1660cf4c0ca5b5d3c','fCLUxFpxP3QqVAezWSiqJ34BRz5YTp2qDGmH5L5jiv7IuTjnVwU1hMxIMAIJawrfJZ7ZMxb3rYXC6r1/ACTQWikbCA1qf6TxcZV/60vvMLjxeQGGhlC0gGOyWMRpYO98',1595562677,'demo','[::1]','Chrome') ON DUPLICATE KEY UPDATE `create_time`=VALUES(`create_time`),`user_name`=VALUES(`user_name`),`ip`=VALUES(`ip`),`explorer`=VALUES(`explorer`),`os`=VALUES(`os`),`id`=VALUES(`id`),`uuid`=VALUES(`uuid`),`token`=VALUES(`token`)
  10. 2020-07-24 11:51:17.588 [DEBU] [ 0 ms] SELECT * FROM `user` WHERE `id`=31
  11. 2020-07-24 11:51:17.621 [DEBU] [ 32 ms] SHOW FULL COLUMNS FROM `role`
  12. 2020-07-24 11:51:17.622 [DEBU] [ 1 ms] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
  13. 2020-07-24 11:51:17.647 [DEBU] [ 24 ms] SHOW FULL COLUMNS FROM `casbin_rule`
  14. 2020-07-24 11:51:17.650 [DEBU] [ 3 ms] SELECT * FROM `casbin_rule`
  15. 2020-07-24 11:51:17.670 [DEBU] [ 17 ms] SHOW FULL COLUMNS FROM `auth_rule`
  16. 2020-07-24 11:51:17.672 [DEBU] [ 1 ms] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
  17. 2020-07-24 11:51:17.684 [DEBU] [ 7 ms] SHOW FULL COLUMNS FROM `sys_oper_log`
  18. 2020-07-24 11:51:17.757 [DEBU] [ 71 ms] INSERT INTO `sys_oper_log`(`title`,`status`,`oper_param`,`oper_time`,`oper_id`,`business_type`,`oper_url`,`oper_location`,`request_method`,`oper_name`,`dept_name`,`error_msg`,`method`,`operator_type`,`oper_ip`,`json_result`) VALUES('',1,'{}',1595562677,0,0,'/system/index/getInfo','内网IP','GET','demo','','','/system/index/getInfo',1,'[::1]','{"code":0,"msg":"ok"}') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`)
  19. 2020-07-24 11:51:17.757 [DEBU] [ 68 ms] INSERT INTO `sys_oper_log`(`method`,`operator_type`,`dept_name`,`oper_ip`,`oper_time`,`title`,`oper_name`,`oper_url`,`oper_location`,`business_type`,`oper_param`,`error_msg`,`oper_id`,`request_method`,`json_result`,`status`) VALUES('/system/index/getRouters',1,'','[::1]',1595562677,'','demo','/system/index/getRouters','内网IP',0,'{}','',0,'GET','{"code":0,"msg":"ok"}',1) ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`business_type`=VALUES(`business_type`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_time`=VALUES(`oper_time`)
  20. 2020-07-24 14:25:08.316 [DEBU] [::1]
  21. 2020-07-24 14:25:25.689 [DEBU] [::1]
  22. 2020-07-24 14:29:22.075 [DEBU] [::1]
  23. 2020-07-24 14:29:22.076 [DEBU]
  24. 2020-07-24 14:41:51.346 [DEBU] [ 54 ms] SHOW FULL COLUMNS FROM `sys_job`
  25. 2020-07-24 14:41:51.349 [DEBU] [ 1 ms] SELECT * FROM `sys_job` WHERE `status`=0
  26. 2020-07-24 14:42:02.620 [DEBU] [ 9 ms] SHOW FULL COLUMNS FROM `user`
  27. 2020-07-24 14:42:02.622 [DEBU] [ 1 ms] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA=='
  28. 2020-07-24 14:42:02.689 [DEBU] [ 66 ms] UPDATE `user` SET `user_nickname`='测试账号',`user_email`='223@qq.com',`remark`='',`is_admin`=1,`user_name`='demo',`mobile`='18699888856',`user_password`='9OFlt5qzzvCiZWhe7ilcLA==',`avatar`='pub_upload/2020-07-06/c3z4e80h9q9sdfspwe.jpeg',`dept_id`=109,`birthday`=0,`user_status`=1,`sex`=2,`last_login_ip`='[::1]',`id`=31,`create_time`=1581314770,`last_login_time`=1595572922 WHERE `id` IN (31)
  29. 2020-07-24 14:42:02.699 [DEBU] [ 9 ms] SHOW FULL COLUMNS FROM `sys_login_log`
  30. 2020-07-24 14:42:02.701 [DEBU] [ 1 ms] INSERT INTO `sys_login_log`(`login_name`,`browser`,`os`,`login_time`,`info_id`,`ipaddr`,`login_location`,`status`,`msg`) VALUES('demo','Chrome','Windows 10',1595572922,0,'[::1]','内网IP',1,'登录成功') ON DUPLICATE KEY UPDATE `info_id`=VALUES(`info_id`),`ipaddr`=VALUES(`ipaddr`),`login_location`=VALUES(`login_location`),`status`=VALUES(`status`),`msg`=VALUES(`msg`),`login_name`=VALUES(`login_name`),`browser`=VALUES(`browser`),`os`=VALUES(`os`),`login_time`=VALUES(`login_time`)
  31. 2020-07-24 14:42:02.702 [DEBU] [ 10 ms] SHOW FULL COLUMNS FROM `user_online`
  32. 2020-07-24 14:42:02.703 [DEBU] [ 1 ms] INSERT INTO `user_online`(`uuid`,`token`,`create_time`,`user_name`,`ip`,`explorer`,`os`,`id`) VALUES('be93ef43f9eb2ce1660cf4c0ca5b5d3c','fCLUxFpxP3QqVAezWSiqJ34BRz5YTp2qDGmH5L5jiv7IuTjnVwU1hMxIMAIJawrfJZ7ZMxb3rYXC6r1/ACTQWikbCA1qf6TxcZV/60vvMLjxeQGGhlC0gGOyWMRpYO98',1595572922,'demo','[::1]','Chrome','Windows 10',0) ON DUPLICATE KEY UPDATE `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`),`explorer`=VALUES(`explorer`)
  33. 2020-07-24 14:42:02.725 [DEBU] [ 0 ms] SELECT * FROM `user` WHERE `id`=31
  34. 2020-07-24 14:42:02.732 [DEBU] [ 6 ms] SHOW FULL COLUMNS FROM `role`
  35. 2020-07-24 14:42:02.733 [DEBU] [ 1 ms] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
  36. 2020-07-24 14:42:02.739 [DEBU] [ 5 ms] SHOW FULL COLUMNS FROM `casbin_rule`
  37. 2020-07-24 14:42:02.740 [DEBU] [ 0 ms] SELECT * FROM `casbin_rule`
  38. 2020-07-24 14:42:02.749 [DEBU] [ 7 ms] SHOW FULL COLUMNS FROM `auth_rule`
  39. 2020-07-24 14:42:02.750 [DEBU] [ 0 ms] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
  40. 2020-07-24 14:42:02.763 [DEBU] [ 7 ms] SHOW FULL COLUMNS FROM `sys_oper_log`
  41. 2020-07-24 14:42:02.765 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`dept_name`,`oper_ip`,`oper_time`,`oper_id`,`method`,`oper_name`,`status`,`business_type`,`request_method`,`oper_url`,`json_result`,`error_msg`,`title`,`operator_type`,`oper_location`,`oper_param`) VALUES('','[::1]',1595572922,0,'/system/index/getInfo','demo',1,0,'GET','/system/index/getInfo','{"code":0,"msg":"ok"}','','',1,'内网IP','{}') ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_time`=VALUES(`oper_time`)
  42. 2020-07-24 14:42:02.767 [DEBU] [ 0 ms] INSERT INTO `sys_oper_log`(`error_msg`,`json_result`,`status`,`oper_location`,`oper_time`,`request_method`,`operator_type`,`business_type`,`method`,`oper_name`,`dept_name`,`oper_url`,`oper_ip`,`oper_id`,`title`,`oper_param`) VALUES('','{"code":0,"msg":"ok"}',1,'内网IP',1595572922,'GET',1,0,'/system/index/getRouters','demo','','/system/index/getRouters','[::1]',0,'','{}') ON DUPLICATE KEY UPDATE `oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`)
  43. 2020-07-24 14:42:13 [DEBU] D:/goProject/p2020/gfast_open/app/service/admin/auth_service/auth_rule.go:83: [{"id":1,"pid":0,"name":"system/config","title":"系统配置","icon":"system","condition":"","remark":"Admin tips","menu_type":0,"createtime":1497429920,"updatetime":1497430320,"weigh":0,"status":1,"alwaysShow":1,"path":"config","isFrame":0},{"id":2,"pid":0,"name":"system/auth","title":"权限管理","icon":"peoples","condition":"","remark":"","menu_type":0,"createtime":1497429920,"updatetime":1592380524,"weigh":0,"status":1,"alwaysShow":1,"path":"system/auth","isFrame":0},{"id":3,"pid":0,"name":"system/monitor","title":"系统监控","icon":"monitor","condition":"","remark":"","menu_type":0,"createtime":1497429920,"updatetime":1592380560,"weigh":0,"status":1,"alwaysShow":1,"path":"monitor","isFrame":0},{"id":5,"pid":1,"name":"system/config/dict/list","title":"字典管理","icon":"dict","condition":"","remark":"","menu_type":1,"createtime":1497429920,"updatetime":1592380469,"weigh":0,"status":1,"alwaysShow":1,"path":"dict/list","isFrame":0},{"id":6,"pid":1,"name":"system/config/params/list","title":"参数管理","icon":"date-range","condition":"","remark":"","menu_type":1,"createtime":1497429920,"updatetime":1592380510,"weigh":0,"status":1,"alwaysShow":1,"path":"params/list","isFrame":0},{"id":8,"pid":2,"name":"system/auth/menuList","title":"菜单管理","icon":"nested","condition":"","remark":"","menu_type":1,"createtime":1497429920,"updatetime":1592380548,"weigh":0,"status":1,"alwaysShow":1,"path":"menuList","isFrame":0},{"id":16,"pid":8,"name":"system/auth/addMenu","title":"添加菜单","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592357208,"updatetime":1592357280,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":17,"pid":8,"name":"system/auth/editMenu","title":"修改菜单","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592357231,"updatetime":1592357274,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":18,"pid":8,"name":"system/auth/deleteMenu","title":"删除菜单","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592357268,"updatetime":1592357268,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":19,"pid":5,"name":"system/config/dict/add","title":"添加字典","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592363585,"updatetime":1592363585,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":20,"pid":5,"name":"system/config/dict/edit","title":"修改字典","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592363604,"updatetime":1592363604,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":21,"pid":5,"name":"system/config/dict/delete","title":"删除字典","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592363629,"updatetime":1592363629,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":22,"pid":5,"name":"system/config/dict/dataList","title":"字典数据管理","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592363790,"updatetime":1592365455,"weigh":0,"status":1,"alwaysShow":1,"path":"dataList","isFrame":0},{"id":23,"pid":5,"name":"system/config/dict/dataAdd","title":"添加字典数据","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592380398,"updatetime":1593411393,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":24,"pid":5,"name":"system/config/dict/dataEdit","title":"修改字典数据","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592380417,"updatetime":1593411398,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":25,"pid":5,"name":"system/config/dict/dataDelete","title":"删除字典数据","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592380449,"updatetime":1593411403,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":26,"pid":2,"name":"system/auth/roleList","title":"角色管理","icon":"logininfor","condition":"","remark":"","menu_type":1,"createtime":1592385260,"updatetime":1592385291,"weigh":0,"status":1,"alwaysShow":1,"path":"role","isFrame":0},{"id":27,"pid":26,"name":"system/auth/addRole","title":"添加角色","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592389821,"updatetime":1592389821,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":28,"pid":2,"name":"system/auth/dept","title":"部门管理","icon":"peoples","condition":"","remark":"","menu_type":1,"createtime":1592449845,"updatetime":1592449845,"weigh":0,"status":1,"alwaysShow":1,"path":"dept","isFrame":0},{"id":29,"pid":26,"name":"system/auth/editRole","title":"修改角色","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592469153,"updatetime":1592469153,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":30,"pid":26,"name":"system/auth/statusSetRole","title":"设置角色状态","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592469201,"updatetime":1592469201,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":31,"pid":26,"name":"system/auth/deleteRole","title":"删除角色","icon":"","condition":"","remark":"","menu_type":2,"createtime":1592469234,"updatetime":1592469234,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":33,"pid":2,"name":"system/auth/post","title":"岗位管理","icon":"tab","condition":"","remark":"","menu_type":1,"createtime":1592558968,"updatetime":1592558968,"weigh":0,"status":1,"alwaysShow":1,"path":"post","isFrame":0},{"id":34,"pid":3,"name":"system/monitor/online/list","title":"在线用户","icon":"cascader","condition":"","remark":"","menu_type":1,"createtime":1593328511,"updatetime":1593328511,"weigh":0,"status":1,"alwaysShow":1,"path":"online","isFrame":0},{"id":36,"pid":3,"name":"system/monitor/job","title":"定时任务","icon":"clipboard","condition":"","remark":"","menu_type":1,"createtime":1593332305,"updatetime":1593332434,"weigh":0,"status":1,"alwaysShow":1,"path":"job","isFrame":0},{"id":37,"pid":3,"name":"system/monitor/server","title":"服务监控","icon":"dict","condition":"","remark":"","menu_type":1,"createtime":1593419394,"updatetime":1593419394,"weigh":0,"status":1,"alwaysShow":1,"path":"server","isFrame":0},{"id":38,"pid":3,"name":"system/monitor/logininfor","title":"登录日志","icon":"chart","condition":"","remark":"","menu_type":1,"createtime":1593423378,"updatetime":1593423505,"weigh":0,"status":1,"alwaysShow":1,"path":"logininfor","isFrame":0},{"id":39,"pid":3,"name":"system/monitor/operlog","title":"操作日志","icon":"dashboard","condition":"","remark":"","menu_type":1,"createtime":1593485097,"updatetime":1593485097,"weigh":0,"status":1,"alwaysShow":1,"path":"operlog","isFrame":0},{"id":40,"pid":2,"name":"system/auth/userList","title":"用户管理","icon":"user","condition":"","remark":"","menu_type":1,"createtime":1593572523,"updatetime":1593572523,"weigh":0,"status":1,"alwaysShow":1,"path":"user","isFrame":0},{"id":41,"pid":6,"name":"system/config/params/add","title":"添加参数","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593684331,"updatetime":1593684331,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":42,"pid":6,"name":"system/config/params/edit","title":"修改参数","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593684351,"updatetime":1593684351,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":43,"pid":6,"name":"system/config/params/delete","title":"删除参数","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593684470,"updatetime":1593684470,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":44,"pid":28,"name":"system/dept/addDept","title":"添加部门","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593738070,"updatetime":1593738070,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":45,"pid":28,"name":"system/dept/editDept","title":"修改部门","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593738097,"updatetime":1593738097,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":46,"pid":28,"name":"system/dept/delDept","title":"删除部门","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593738125,"updatetime":1593738125,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":47,"pid":33,"name":"system/post/add","title":"添加岗位","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593738444,"updatetime":1593738444,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":48,"pid":33,"name":"system/post/edit","title":"修改岗位","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593738567,"updatetime":1593738567,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":49,"pid":33,"name":"system/post/delete","title":"删除岗位","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593738590,"updatetime":1593738590,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":50,"pid":40,"name":"system/auth/addUser","title":"添加用户","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593738798,"updatetime":1593738798,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":51,"pid":40,"name":"system/auth/editUser","title":"修改用户","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593738950,"updatetime":1593738950,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":52,"pid":40,"name":"system/auth/resetUserPwd","title":"密码重置","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593739001,"updatetime":1593739001,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":53,"pid":40,"name":"system/auth/changeUserStatus","title":"状态设置","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593739079,"updatetime":1593739079,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":54,"pid":40,"name":"system/auth/deleteAdmin","title":"删除用户","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593739113,"updatetime":1593739113,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":55,"pid":34,"name":"system/monitor/online/forceLogout","title":"强制退出","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593739201,"updatetime":1593739201,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":56,"pid":36,"name":"system/monitor/job/add","title":"添加任务","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740041,"updatetime":1593740041,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":57,"pid":36,"name":"system/monitor/job/edit","title":"修改任务","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740062,"updatetime":1593740062,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":58,"pid":36,"name":"system/monitor/job/start","title":"开启任务","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740105,"updatetime":1593740105,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":59,"pid":36,"name":"system/monitor/job/stop","title":"停止任务","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740139,"updatetime":1593740139,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":60,"pid":36,"name":"system/monitor/job/delete","title":"删除任务","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740165,"updatetime":1593740165,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":61,"pid":38,"name":"system/monitor/loginlog/delete","title":"删除","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740342,"updatetime":1593740342,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":62,"pid":38,"name":"system/monitor/loginlog/clear","title":"清空","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740359,"updatetime":1593740359,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":63,"pid":39,"name":"system/monitor/operlog/delete","title":"删除","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740422,"updatetime":1593740422,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":64,"pid":39,"name":"system/monitor/operlog/clear","title":"清空","icon":"","condition":"","remark":"","menu_type":2,"createtime":1593740434,"updatetime":1593740434,"weigh":0,"status":1,"alwaysShow":1,"path":"","isFrame":0},{"id":75,"pid":0,"name":"system/tools","title":"系统工具","icon":"server","condition":"","remark":"","menu_type":0,"createtime":1594016328,"updatetime":1594016328,"weigh":0,"status":1,"alwaysShow":1,"path":"system/tools","isFrame":0},{"id":76,"pid":75,"name":"system/tools/build","title":"表单构建","icon":"build","condition":"","remark":"","menu_type":1,"createtime":1594016392,"updatetime":1594016808,"weigh":0,"status":1,"alwaysShow":1,"path":"build","isFrame":0},{"id":77,"pid":75,"name":"system/tools/gen","title":"代码生成","icon":"code","condition":"","remark":"","menu_type":1,"createtime":1594016637,"updatetime":1594016637,"weigh":0,"status":1,"alwaysShow":1,"path":"gen","isFrame":0},{"id":82,"pid":75,"name":"system/tools/api","title":"系统接口","icon":"guide","condition":"","remark":"","menu_type":1,"createtime":1594952236,"updatetime":1594952236,"weigh":0,"status":1,"alwaysShow":1,"path":"api","isFrame":0}]
  44. 2020-07-24 14:42:13.143 [DEBU] [ 27 ms] SHOW FULL COLUMNS FROM `sys_dict_type`
  45. 2020-07-24 14:42:13.144 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_show_hide' AND `status`=1
  46. 2020-07-24 14:42:13.159 [DEBU] [ 14 ms] SHOW FULL COLUMNS FROM `sys_dict_data`
  47. 2020-07-24 14:42:13.160 [DEBU] [ 0 ms] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_show_hide' ORDER BY `dict_sort` ASC,`dict_code` ASC
  48. 2020-07-24 14:42:13.162 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_type` WHERE `status`=1 AND `dict_type`='sys_normal_disable'
  49. 2020-07-24 14:42:13.163 [DEBU] [ 0 ms] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
  50. 2020-07-24 14:42:13.166 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_id`,`method`,`operator_type`,`json_result`,`error_msg`,`oper_time`,`business_type`,`oper_location`,`title`,`request_method`,`oper_name`,`dept_name`,`oper_url`,`oper_param`,`status`) VALUES('[::1]',0,'/system/auth/menuList',1,'{"code":0,"msg":"成功"}','',1595572933,0,'内网IP','菜单管理','GET','demo','','/system/auth/menuList','{}',1) ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`oper_location`=VALUES(`oper_location`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`)
  51. 2020-07-24 14:42:15.193 [DEBU] [ 16 ms] SELECT COUNT(1) FROM `role`
  52. 2020-07-24 14:42:15.193 [DEBU] [ 0 ms] SELECT * FROM `role` ORDER BY `id` asc LIMIT 0,10
  53. 2020-07-24 14:42:15.196 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`json_result`,`status`,`business_type`,`operator_type`,`oper_location`,`oper_ip`,`oper_param`,`request_method`,`oper_name`,`oper_url`,`method`,`error_msg`,`oper_time`,`oper_id`,`title`,`dept_name`) VALUES('{"code":0,"msg":"成功"}',1,0,1,'内网IP','[::1]','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','GET','demo','/system/auth/roleList?pageNum=1&pageSize=10&beginTime=&endTime=','/system/auth/roleList','',1595572935,0,'角色管理','') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`method`=VALUES(`method`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`)
  54. 2020-07-24 14:42:19.505 [DEBU] [ 0 ms] SELECT COUNT(1) FROM `sys_login_log`
  55. 2020-07-24 14:42:19.530 [DEBU] [ 25 ms] SELECT * FROM `sys_login_log` ORDER BY `login_time` DESC LIMIT 0,10
  56. 2020-07-24 14:42:19.532 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_type` WHERE `dict_type`='admin_login_status' AND `status`=1
  57. 2020-07-24 14:42:19.533 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_data` WHERE `dict_type`='admin_login_status' ORDER BY `dict_sort` ASC,`dict_code` ASC
  58. 2020-07-24 14:42:19.535 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`method`,`request_method`,`oper_url`,`oper_location`,`oper_param`,`json_result`,`error_msg`,`oper_id`,`title`,`business_type`,`oper_name`,`oper_ip`,`oper_time`,`status`,`operator_type`,`dept_name`) VALUES('/system/monitor/loginlog/list','GET','/system/monitor/loginlog/list?pageNum=1&pageSize=10&beginTime=&endTime=','内网IP','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','{"code":0,"msg":"登录日志列表"}','',0,'',0,'demo','[::1]',1595572939,1,1,'') ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_time`=VALUES(`oper_time`)
  59. 2020-07-24 14:42:22.161 [DEBU] [ 0 ms] SELECT COUNT(1) FROM `sys_oper_log`
  60. 2020-07-24 14:42:22.162 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_oper_log_status' AND `status`=1
  61. 2020-07-24 14:42:22.163 [DEBU] [ 0 ms] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_oper_log_status' ORDER BY `dict_sort` ASC,`dict_code` ASC
  62. 2020-07-24 14:42:22.183 [DEBU] [ 22 ms] SELECT * FROM `sys_oper_log` ORDER BY `oper_time` DESC LIMIT 0,10
  63. 2020-07-24 14:42:22.184 [DEBU] [ 19 ms] INSERT INTO `sys_oper_log`(`title`,`business_type`,`method`,`oper_ip`,`status`,`request_method`,`oper_name`,`dept_name`,`oper_url`,`oper_location`,`oper_param`,`json_result`,`operator_type`,`oper_id`,`error_msg`,`oper_time`) VALUES('',0,'/system/config/dict/sysCommonStatus','[::1]',1,'GET','demo','','/system/config/dict/sysCommonStatus','内网IP','{}','{"code":0,"msg":"ok"}',1,0,'',1595572942) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`operator_type`=VALUES(`operator_type`)
  64. 2020-07-24 14:42:22.187 [DEBU] [ 0 ms] INSERT INTO `sys_oper_log`(`business_type`,`json_result`,`status`,`request_method`,`dept_name`,`oper_url`,`oper_ip`,`oper_location`,`oper_id`,`title`,`operator_type`,`oper_name`,`error_msg`,`oper_time`,`method`,`oper_param`) VALUES(0,'{"code":0,"msg":"操作日志列表"}',1,'GET','','/system/monitor/operlog/list?pageNum=1&pageSize=10&beginTime=&endTime=','[::1]','内网IP',0,'',1,'demo','',1595572942,'/system/monitor/operlog/list','{"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`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`business_type`=VALUES(`business_type`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`)