2020-07-17.log 57 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. 2020-07-17 09:39:15.140 [DEBU] [ 37 ms] SHOW FULL COLUMNS FROM `sys_job`
  2. 2020-07-17 09:39:15.142 [DEBU] [ 0 ms] SELECT * FROM `sys_job` WHERE `status`=0
  3. 2020-07-17 09:40:10.391 [DEBU] [ 8 ms] SHOW FULL COLUMNS FROM `sys_job`
  4. 2020-07-17 09:40:10.397 [DEBU] [ 5 ms] SELECT * FROM `sys_job` WHERE `status`=0
  5. 2020-07-17 09:49:58.239 [DEBU] [ 9 ms] SHOW FULL COLUMNS FROM `sys_job`
  6. 2020-07-17 09:49:58.245 [DEBU] [ 5 ms] SELECT * FROM `sys_job` WHERE `status`=0
  7. 2020-07-17 10:14:42.418 [DEBU] [ 9 ms] SHOW FULL COLUMNS FROM `sys_job`
  8. 2020-07-17 10:14:42.431 [DEBU] [ 12 ms] SELECT * FROM `sys_job` WHERE `status`=0
  9. 2020-07-17 10:15:19.738 [DEBU] [ 88 ms] SHOW FULL COLUMNS FROM `user`
  10. 2020-07-17 10:15:19.740 [DEBU] [ 1 ms] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA=='
  11. 2020-07-17 10:15:19.799 [DEBU] [ 58 ms] UPDATE `user` SET `birthday`=0,`user_email`='223@qq.com',`remark`='',`last_login_ip`='[::1]',`dept_id`=109,`is_admin`=1,`user_nickname`='测试账号',`create_time`=1581314770,`last_login_time`=1594952119,`user_status`=1,`avatar`='pub_upload/2020-07-06/c3z4e80h9q9sdfspwe.jpeg',`user_name`='demo',`mobile`='18699888856',`user_password`='9OFlt5qzzvCiZWhe7ilcLA==',`id`=31,`sex`=2 WHERE `id` IN (31)
  12. 2020-07-17 10:15:19.844 [DEBU] [ 44 ms] SHOW FULL COLUMNS FROM `sys_login_log`
  13. 2020-07-17 10:15:19.847 [DEBU] [ 45 ms] SHOW FULL COLUMNS FROM `user_online`
  14. 2020-07-17 10:15:19.848 [DEBU] [ 1 ms] INSERT INTO `sys_login_log`(`info_id`,`login_name`,`ipaddr`,`login_location`,`status`,`login_time`,`browser`,`os`,`msg`) VALUES(0,'demo','[::1]','内网IP',1,1594952119,'Chrome','Windows 10','登录成功') ON DUPLICATE KEY UPDATE `browser`=VALUES(`browser`),`os`=VALUES(`os`),`msg`=VALUES(`msg`),`status`=VALUES(`status`),`login_time`=VALUES(`login_time`),`info_id`=VALUES(`info_id`),`login_name`=VALUES(`login_name`),`ipaddr`=VALUES(`ipaddr`),`login_location`=VALUES(`login_location`)
  15. 2020-07-17 10:15:19.850 [DEBU] [ 1 ms] INSERT INTO `user_online`(`explorer`,`os`,`id`,`uuid`,`token`,`create_time`,`user_name`,`ip`) VALUES('Chrome','Windows 10',0,'be93ef43f9eb2ce1660cf4c0ca5b5d3c','fCLUxFpxP3QqVAezWSiqJ34BRz5YTp2qDGmH5L5jiv7IuTjnVwU1hMxIMAIJawrfJZ7ZMxb3rYXC6r1/ACTQWikbCA1qf6TxcZV/60vvMLjxeQGGhlC0gGOyWMRpYO98',1594952119,'demo','[::1]') ON DUPLICATE KEY UPDATE `ip`=VALUES(`ip`),`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`)
  16. 2020-07-17 10:15:19.880 [DEBU] [ 0 ms] SELECT * FROM `user` WHERE `id`=31
  17. 2020-07-17 10:15:19.907 [DEBU] [ 26 ms] SHOW FULL COLUMNS FROM `role`
  18. 2020-07-17 10:15:19.908 [DEBU] [ 0 ms] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
  19. 2020-07-17 10:15:19.923 [DEBU] [ 14 ms] SHOW FULL COLUMNS FROM `casbin_rule`
  20. 2020-07-17 10:15:19.925 [DEBU] [ 1 ms] SELECT * FROM `casbin_rule`
  21. 2020-07-17 10:15:19.948 [DEBU] [ 20 ms] SHOW FULL COLUMNS FROM `auth_rule`
  22. 2020-07-17 10:15:19.949 [DEBU] [ 1 ms] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
  23. 2020-07-17 10:15:19.973 [DEBU] [ 20 ms] SHOW FULL COLUMNS FROM `sys_oper_log`
  24. 2020-07-17 10:15:19.973 [DEBU] [ 11 ms] SHOW FULL COLUMNS FROM `sys_oper_log`
  25. 2020-07-17 10:15:19.977 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`request_method`,`oper_name`,`dept_name`,`oper_param`,`method`,`operator_type`,`oper_url`,`oper_ip`,`error_msg`,`business_type`,`oper_location`,`json_result`,`status`,`oper_time`,`oper_id`,`title`) VALUES('GET','demo','','{}','/system/index/getRouters',1,'/system/index/getRouters','[::1]','',0,'内网IP','{"code":0,"msg":"ok"}',1,1594952119,0,'') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`)
  26. 2020-07-17 10:15:19.977 [DEBU] [ 2 ms] INSERT INTO `sys_oper_log`(`title`,`dept_name`,`oper_param`,`status`,`oper_time`,`oper_id`,`method`,`operator_type`,`error_msg`,`business_type`,`oper_location`,`json_result`,`request_method`,`oper_name`,`oper_url`,`oper_ip`) VALUES('','','{}',1,1594952119,0,'/system/index/getInfo',1,'',0,'内网IP','{"code":0,"msg":"ok"}','GET','demo','/system/index/getInfo','[::1]') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`)
  27. 2020-07-17 10:15:29 [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}]
  28. 2020-07-17 10:15:29.881 [DEBU] [ 52 ms] SHOW FULL COLUMNS FROM `sys_dict_type`
  29. 2020-07-17 10:15:29.910 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_show_hide' AND `status`=1
  30. 2020-07-17 10:15:29.935 [DEBU] [ 25 ms] SHOW FULL COLUMNS FROM `sys_dict_data`
  31. 2020-07-17 10:15:29.936 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_show_hide' ORDER BY `dict_sort` ASC,`dict_code` ASC
  32. 2020-07-17 10:15:29.937 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1
  33. 2020-07-17 10:15:29.938 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
  34. 2020-07-17 10:15:29.941 [DEBU] [ 0 ms] INSERT INTO `sys_oper_log`(`business_type`,`request_method`,`operator_type`,`dept_name`,`oper_url`,`oper_time`,`oper_id`,`oper_name`,`oper_location`,`oper_param`,`title`,`method`,`oper_ip`,`error_msg`,`json_result`,`status`) VALUES(0,'GET',1,'','/system/auth/menuList',1594952129,0,'demo','内网IP','{}','菜单管理','/system/auth/menuList','[::1]','','{"code":0,"msg":"成功"}',1) ON DUPLICATE KEY UPDATE `oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`)
  35. 2020-07-17 10:15:37.679 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`method`,`dept_name`,`oper_url`,`title`,`oper_location`,`oper_param`,`request_method`,`operator_type`,`status`,`business_type`,`oper_name`,`oper_ip`,`json_result`,`error_msg`,`oper_time`,`oper_id`) VALUES('/system/auth/addMenu','','/system/auth/addMenu','添加菜单','内网IP','{}','GET',1,1,0,'demo','[::1]','{"code":0,"msg":"成功"}','',1594952137,0) ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`)
  36. 2020-07-17 10:16:41.581 [DEBU] [ 2 ms] INSERT INTO `sys_oper_log`(`operator_type`,`oper_ip`,`status`,`error_msg`,`oper_id`,`method`,`dept_name`,`oper_url`,`oper_location`,`oper_param`,`oper_time`,`title`,`business_type`,`json_result`,`request_method`,`oper_name`) VALUES(1,'[::1]',0,'',0,'/system/auth/addMenu','','/system/auth/addMenu','内网IP','{"component":"system/tools/api","icon":"guide","isFrame":"0","menuName":"系统接口","menuType":"1","orderNum":0,"parentId":75,"path":"api","status":"1","visible":"1"}',1594952201,'添加菜单',0,'{"code":-1,"msg":"演示系统禁止操作"}','POST','demo') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`)
  37. 2020-07-17 10:17:12.783 [DEBU] [ 9 ms] SHOW FULL COLUMNS FROM `sys_job`
  38. 2020-07-17 10:17:12.792 [DEBU] [ 6 ms] SELECT * FROM `sys_job` WHERE `status`=0
  39. 2020-07-17 10:17:16.624 [DEBU] [ 6 ms] SHOW FULL COLUMNS FROM `auth_rule`
  40. 2020-07-17 10:17:16.625 [DEBU] [ 1 ms] SELECT COUNT(1) FROM `auth_rule` WHERE name='system/tools/api'
  41. 2020-07-17 10:17:16.626 [DEBU] [ 1 ms] SELECT COUNT(1) FROM `auth_rule` WHERE (path='api') AND (menu_type<>2)
  42. 2020-07-17 10:17:16.627 [DEBU] [ 1 ms] INSERT INTO `auth_rule`(`title`,`always_show`,`createtime`,`weigh`,`condition`,`remark`,`menu_type`,`path`,`is_frame`,`id`,`icon`,`updatetime`,`status`,`pid`,`name`) VALUES('系统接口',1,1594952236,0,'','',1,'api',0,0,'guide',1594952236,1,75,'system/tools/api')
  43. 2020-07-17 10:17:16.628 [DEBU] [ 0 ms] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
  44. 2020-07-17 10:17:16.638 [DEBU] [ 5 ms] SHOW FULL COLUMNS FROM `sys_oper_log`
  45. 2020-07-17 10:17:16.640 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`oper_param`,`oper_time`,`error_msg`,`oper_id`,`business_type`,`oper_name`,`oper_ip`,`json_result`,`title`,`request_method`,`dept_name`,`method`,`operator_type`,`oper_url`,`oper_location`,`status`) VALUES('{"component":"system/tools/api","icon":"guide","isFrame":"0","menuName":"系统接口","menuType":"1","orderNum":0,"parentId":75,"path":"api","status":"1","visible":"1"}',1594952236,'',0,0,'demo','[::1]','{"code":0,"msg":"添加菜单成功"}','添加菜单','POST','','/system/auth/addMenu',1,'/system/auth/addMenu','内网IP',1) ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`)
  46. 2020-07-17 10:17:16 [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}]
  47. 2020-07-17 10:17:16.671 [DEBU] [ 5 ms] SHOW FULL COLUMNS FROM `sys_dict_type`
  48. 2020-07-17 10:17:16.672 [DEBU] [ 0 ms] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_show_hide' AND `status`=1
  49. 2020-07-17 10:17:16.677 [DEBU] [ 5 ms] SHOW FULL COLUMNS FROM `sys_dict_data`
  50. 2020-07-17 10:17:16.678 [DEBU] [ 1 ms] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_show_hide' ORDER BY `dict_sort` ASC,`dict_code` ASC
  51. 2020-07-17 10:17:16.679 [DEBU] [ 0 ms] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1
  52. 2020-07-17 10:17:16.680 [DEBU] [ 0 ms] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
  53. 2020-07-17 10:17:16.684 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`title`,`method`,`oper_time`,`business_type`,`oper_url`,`status`,`request_method`,`oper_name`,`oper_ip`,`json_result`,`oper_id`,`operator_type`,`dept_name`,`oper_location`,`oper_param`,`error_msg`) VALUES('菜单管理','/system/auth/menuList',1594952236,0,'/system/auth/menuList',1,'GET','demo','[::1]','{"code":0,"msg":"成功"}',0,1,'','内网IP','{}','') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`)
  54. 2020-07-17 10:17:19.899 [DEBU] [ 5 ms] SHOW FULL COLUMNS FROM `user`
  55. 2020-07-17 10:17:19.900 [DEBU] [ 1 ms] SELECT * FROM `user` WHERE `id`=31
  56. 2020-07-17 10:17:19.905 [DEBU] [ 5 ms] SHOW FULL COLUMNS FROM `role`
  57. 2020-07-17 10:17:19.906 [DEBU] [ 1 ms] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
  58. 2020-07-17 10:17:19.911 [DEBU] [ 5 ms] SHOW FULL COLUMNS FROM `casbin_rule`
  59. 2020-07-17 10:17:19.911 [DEBU] [ 0 ms] SELECT * FROM `casbin_rule`
  60. 2020-07-17 10:17:19.915 [DEBU] [ 0 ms] INSERT INTO `sys_oper_log`(`operator_type`,`oper_name`,`dept_name`,`oper_time`,`request_method`,`business_type`,`json_result`,`status`,`title`,`oper_url`,`oper_location`,`error_msg`,`method`,`oper_ip`,`oper_param`,`oper_id`) VALUES(1,'demo','',1594952239,'GET',0,'{"code":0,"msg":"ok"}',1,'','/system/index/getInfo','内网IP','','/system/index/getInfo','[::1]','{}',0) ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_time`=VALUES(`oper_time`)
  61. 2020-07-17 10:17:19.948 [DEBU] [ 11 ms] INSERT INTO `sys_oper_log`(`title`,`request_method`,`operator_type`,`dept_name`,`status`,`error_msg`,`oper_time`,`business_type`,`method`,`oper_ip`,`oper_param`,`json_result`,`oper_id`,`oper_name`,`oper_url`,`oper_location`) VALUES('','GET',1,'',1,'',1594952239,0,'/system/index/getRouters','[::1]','{}','{"code":0,"msg":"ok"}',0,'demo','/system/index/getRouters','内网IP') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`)
  62. 2020-07-17 10:17:20 [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}]
  63. 2020-07-17 10:17:20.286 [DEBU] [ 0 ms] INSERT INTO `sys_oper_log`(`json_result`,`business_type`,`dept_name`,`oper_param`,`oper_time`,`request_method`,`oper_location`,`status`,`oper_url`,`oper_id`,`method`,`oper_name`,`error_msg`,`title`,`operator_type`,`oper_ip`) VALUES('{"code":0,"msg":"成功"}',0,'','{}',1594952240,'GET','内网IP',1,'/system/auth/menuList',0,'/system/auth/menuList','demo','','菜单管理',1,'[::1]') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`)
  64. 2020-07-17 10:19:45.585 [DEBU] [ 2 ms] SELECT * FROM `user` WHERE `id`=31
  65. 2020-07-17 10:19:45.593 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`oper_time`,`oper_name`,`dept_name`,`oper_url`,`oper_ip`,`oper_location`,`oper_param`,`title`,`method`,`request_method`,`oper_id`,`operator_type`,`error_msg`,`business_type`,`json_result`,`status`) VALUES(1594952385,'demo','','/system/index/getInfo','[::1]','内网IP','{}','','/system/index/getInfo','GET',0,1,'',0,'{"code":0,"msg":"ok"}',1) ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`business_type`=VALUES(`business_type`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`)
  66. 2020-07-17 10:19:45.615 [DEBU] [ 1 ms] INSERT INTO `sys_oper_log`(`method`,`operator_type`,`oper_url`,`oper_param`,`error_msg`,`oper_id`,`title`,`business_type`,`oper_name`,`oper_ip`,`status`,`request_method`,`dept_name`,`oper_location`,`json_result`,`oper_time`) VALUES('/system/index/getRouters',1,'/system/index/getRouters','{}','',0,'',0,'demo','[::1]',1,'GET','','内网IP','{"code":0,"msg":"ok"}',1594952385) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`)
  67. 2020-07-17 10:20:27.731 [DEBU] [ 9 ms] SHOW FULL COLUMNS FROM `sys_job`
  68. 2020-07-17 10:20:27.738 [DEBU] [ 6 ms] SELECT * FROM `sys_job` WHERE `status`=0