| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114 |
- 2021-01-22 17:08:33.811 [DEBU] [211 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
- 2021-01-22 17:08:33.815 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
- 2021-01-22 17:08:33.819 [DEBU] [ 1 ms] [default] INSERT INTO `sys_job`(`misfire_policy`,`concurrent`,`status`,`invoke_target`,`cron_expression`,`remark`,`job_group`,`create_time`,`job_name`,`job_params`,`update_by`,`update_time`,`job_id`,`create_by`) VALUES(1,0,0,'checkUserOnline','5 */10 * * * *','','DEFAULT',1596763977,'在线用户定时更新','',2,1596768044,8,2) ON DUPLICATE KEY UPDATE `job_id`=VALUES(`job_id`),`create_by`=VALUES(`create_by`),`update_by`=VALUES(`update_by`),`update_time`=VALUES(`update_time`),`invoke_target`=VALUES(`invoke_target`),`cron_expression`=VALUES(`cron_expression`),`misfire_policy`=VALUES(`misfire_policy`),`concurrent`=VALUES(`concurrent`),`status`=VALUES(`status`),`remark`=VALUES(`remark`),`job_name`=VALUES(`job_name`),`job_params`=VALUES(`job_params`),`job_group`=VALUES(`job_group`),`create_time`=VALUES(`create_time`)
- 2021-01-22 17:08:46.921 [DEBU] [247 ms] [default] SHOW FULL COLUMNS FROM `user`
- 2021-01-22 17:08:46.923 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=31 LIMIT 1
- 2021-01-22 17:08:46.961 [DEBU] [ 37 ms] [default] SHOW FULL COLUMNS FROM `role`
- 2021-01-22 17:08:46.962 [DEBU] [ 0 ms] [default] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
- 2021-01-22 17:08:47.003 [DEBU] [ 39 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule`
- 2021-01-22 17:08:47.022 [DEBU] [ 18 ms] [default] SELECT * FROM `casbin_rule`
- 2021-01-22 17:08:47.098 [DEBU] [ 71 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2021-01-22 17:08:47.118 [DEBU] [ 20 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2021-01-22 17:08:47.172 [DEBU] [ 18 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2021-01-22 17:08:47.172 [DEBU] [ 41 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2021-01-22 17:08:47.213 [DEBU] [ 39 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`status`,`oper_name`,`dept_name`,`oper_ip`,`oper_time`,`title`,`request_method`,`operator_type`,`error_msg`,`oper_id`,`business_type`,`oper_location`,`oper_param`,`method`,`oper_url`) VALUES('{"code":0,"msg":"ok"}',1,'demo','','[::1]',1611306527,'','GET',1,'',0,0,'内网IP','{}','/system/index/getInfo','/system/index/getInfo') ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`error_msg`=VALUES(`error_msg`)
- 2021-01-22 17:08:47.213 [DEBU] [ 41 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`request_method`,`oper_param`,`title`,`method`,`oper_ip`,`status`,`json_result`,`error_msg`,`oper_id`,`dept_name`,`oper_url`,`oper_location`,`operator_type`,`oper_name`,`oper_time`) VALUES(0,'GET','{}','','/system/index/getRouters','[::1]',1,'{"code":0,"msg":"ok"}','',0,'','/system/index/getRouters','内网IP',1,'demo',1611306527) ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`)
- 2021-01-22 17:08:56.907 [DEBU] [138 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2021-01-22 17:08:56.907 [DEBU] [139 ms] [default] SHOW FULL COLUMNS FROM `blog_comment`
- 2021-01-22 17:08:56.909 [DEBU] [ 2 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
- 2021-01-22 17:08:56.954 [DEBU] [ 44 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2021-01-22 17:08:56.954 [DEBU] [ 46 ms] [default] SHOW FULL COLUMNS FROM `blog_log`
- 2021-01-22 17:08:56.955 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-22 17:08:56.955 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `blog_comment` comment LEFT JOIN `blog_log` log ON (log.log_id=comment.comment_log_id) LEFT JOIN `user` u ON (u.id=comment.comment_user_id)
- 2021-01-22 17:08:56.956 [DEBU] [ 0 ms] [default] SELECT comment.*,log.log_title,u.user_name FROM `blog_comment` comment LEFT JOIN `blog_log` log ON (log.log_id=comment.comment_log_id) LEFT JOIN `user` u ON (u.id=comment.comment_user_id) ORDER BY `comment`.`create_time` desc,`comment`.`comment_id` asc LIMIT 0,10
- 2021-01-22 17:08:56.957 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`request_method`,`oper_url`,`oper_ip`,`oper_location`,`json_result`,`error_msg`,`title`,`method`,`operator_type`,`dept_name`,`business_type`,`oper_name`,`oper_param`,`status`,`oper_time`) VALUES(0,'GET','/system/config/dict/getDicts?dictType=sys_normal_disable','[::1]','内网IP','{"code":0,"msg":"ok"}','','','/system/config/dict/getDicts',1,'',0,'demo','{"dictType":"sys_normal_disable"}',1,1611306536) ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`)
- 2021-01-22 17:08:56.959 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`method`,`operator_type`,`oper_name`,`oper_ip`,`oper_location`,`oper_id`,`business_type`,`title`,`request_method`,`status`,`dept_name`,`json_result`,`error_msg`,`oper_time`,`oper_url`,`oper_param`) VALUES('/system/plugin/blog/comment/list',1,'demo','[::1]','内网IP',0,0,'评论管理','GET',1,'','{"code":0,"msg":"评论列表"}','',1611306536,'/system/plugin/blog/comment/list?pageNum=1&pageSize=10','{"pageNum":"1","pageSize":"10"}') ON DUPLICATE KEY UPDATE `dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`)
- 2021-01-22 17:08:59.725 [DEBU] [ 4 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_log_sign' AND `status`=1 LIMIT 1
- 2021-01-22 17:08:59.774 [DEBU] [ 56 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_url`,`oper_ip`,`request_method`,`title`,`method`,`oper_name`,`oper_location`,`error_msg`,`oper_time`,`oper_id`,`status`,`business_type`,`oper_param`,`json_result`,`operator_type`) VALUES('','/system/config/dict/getDicts?dictType=sys_normal_disable','[::1]','GET','','/system/config/dict/getDicts','demo','内网IP','',1611306539,0,1,0,'{"dictType":"sys_normal_disable"}','{"code":0,"msg":"ok"}',1) ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`)
- 2021-01-22 17:08:59.774 [DEBU] [ 48 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`oper_ip`,`json_result`,`error_msg`,`oper_param`,`oper_time`,`request_method`,`oper_name`,`dept_name`,`oper_url`,`operator_type`,`status`,`oper_id`,`title`,`business_type`,`method`) VALUES('内网IP','[::1]','{"code":0,"msg":"ok"}','','{"dictType":"sys_log_sign"}',1611306539,'GET','demo','','/system/config/dict/getDicts?dictType=sys_log_sign',1,1,0,'',0,'/system/config/dict/getDicts') ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`)
- 2021-01-22 17:08:59.841 [DEBU] [121 ms] [default] SHOW FULL COLUMNS FROM `blog_classification`
- 2021-01-22 17:08:59.841 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `blog_log` log LEFT JOIN `blog_classification` cf ON (cf.classification_id=log.log_type)
- 2021-01-22 17:08:59.842 [DEBU] [ 1 ms] [default] SELECT log.*,cf.classification_name FROM `blog_log` log LEFT JOIN `blog_classification` cf ON (cf.classification_id=log.log_type) ORDER BY `log`.`log_sort` asc,`log`.`log_id` desc LIMIT 0,10
- 2021-01-22 17:08:59.855 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`status`,`business_type`,`oper_ip`,`oper_location`,`oper_param`,`method`,`request_method`,`oper_name`,`error_msg`,`oper_id`,`dept_name`,`oper_url`,`title`,`operator_type`,`oper_time`) VALUES('{"code":0,"msg":"日志列表"}',1,0,'[::1]','内网IP','{"pageNum":"1","pageSize":"10"}','/system/plugin/blog/log/list','GET','demo','',0,'','/system/plugin/blog/log/list?pageNum=1&pageSize=10','日志管理',1,1611306539) ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`error_msg`=VALUES(`error_msg`)
- 2021-01-22 17:09:02.303 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `blog_log` log LEFT JOIN `blog_classification` cf ON (cf.classification_id=log.log_type) WHERE log.log_status = 1
- 2021-01-22 17:09:02.304 [DEBU] [ 1 ms] [default] SELECT log.*,cf.classification_name FROM `blog_log` log LEFT JOIN `blog_classification` cf ON (cf.classification_id=log.log_type) WHERE log.log_status = 1 ORDER BY `log`.`log_sort` asc,`log`.`log_id` desc LIMIT 0,8
- 2021-01-22 17:09:02.306 [DEBU] [ 1 ms] [default] SELECT log.*,cf.classification_name FROM `blog_log` log LEFT JOIN `blog_classification` cf ON (cf.classification_id=log.log_type) WHERE (log.log_status = 1) AND (log.log_sign = 1) ORDER BY `log`.`log_sort` asc,`log`.`creat_time` desc LIMIT 3
- 2021-01-22 17:09:02.307 [DEBU] [ 1 ms] [default] SELECT log.*,cf.classification_name FROM `blog_log` log LEFT JOIN `blog_classification` cf ON (cf.classification_id=log.log_type) WHERE (log.log_status = 1) AND (log.log_sign = 2) ORDER BY `log`.`log_sort` asc,`log`.`creat_time` desc LIMIT 3
- 2021-01-22 17:09:02.308 [DEBU] [ 1 ms] [default] SELECT * FROM `blog_log` ORDER BY `log_hits` desc
- 2021-01-22 17:09:02.338 [DEBU] [ 30 ms] [default] SHOW FULL COLUMNS FROM `plug_link`
- 2021-01-22 17:09:02.343 [DEBU] [ 4 ms] [default] SELECT `link_name`,`link_url`,`link_target` FROM `plug_link` WHERE (link_typeid = 13) AND (link_open = 1) ORDER BY `link_order` asc,`link_addtime` desc LIMIT 6
- 2021-01-22 17:09:02.608 [DEBU] [264 ms] [default] SHOW FULL COLUMNS FROM `plug_ad`
- 2021-01-22 17:09:02.609 [DEBU] [ 1 ms] [default] SELECT * FROM `plug_ad` WHERE (ad_open = 1) AND (ad_adtypeid = 21) ORDER BY `ad_sort` asc,`ad_addtime` desc LIMIT 2
- 2021-01-22 17:09:02.610 [DEBU] [ 1 ms] [default] SELECT log.*,cf.classification_name FROM `blog_log` log LEFT JOIN `blog_classification` cf ON (cf.classification_id=log.log_type) WHERE (log.log_status = 1) AND (log.log_sign = 3) ORDER BY `log`.`log_sort` asc,`log`.`creat_time` desc LIMIT 4
- 2021-01-22 17:09:02.611 [DEBU] [ 1 ms] [default] SELECT log.*,cf.classification_name FROM `blog_log` log LEFT JOIN `blog_classification` cf ON (cf.classification_id=log.log_type) WHERE (log.log_status = 1) AND (log.log_sign = 0) ORDER BY `log`.`log_sort` asc,`log`.`creat_time` desc LIMIT 4
- 2021-01-22 17:09:02.612 [DEBU] [ 1 ms] [default] SELECT * FROM `blog_classification` WHERE classification_status = 1 ORDER BY `classification_sort` asc,`classification_id` asc
- 2021-01-22 17:10:05.583 [DEBU] [ 65 ms] [default] SHOW FULL COLUMNS FROM `user_online`
- 2021-01-22 17:10:05.585 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-01-22 17:10:05.586 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-01-22 17:20:05.523 [DEBU] [ 7 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-01-22 17:20:05.526 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-01-22 17:30:05.617 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-01-22 17:30:05.618 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-01-22 17:31:33.392 [DEBU] [ 9 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
- 2021-01-22 17:31:33.404 [DEBU] [ 11 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
- 2021-01-22 17:31:33.405 [DEBU] [ 1 ms] [default] INSERT INTO `sys_job`(`job_name`,`job_params`,`job_id`,`cron_expression`,`concurrent`,`update_by`,`remark`,`invoke_target`,`create_by`,`job_group`,`misfire_policy`,`status`,`create_time`,`update_time`) VALUES('在线用户定时更新','',8,'5 */10 * * * *',0,2,'','checkUserOnline',2,'DEFAULT',1,0,1596763977,1596768044) ON DUPLICATE KEY UPDATE `remark`=VALUES(`remark`),`job_id`=VALUES(`job_id`),`cron_expression`=VALUES(`cron_expression`),`concurrent`=VALUES(`concurrent`),`update_by`=VALUES(`update_by`),`invoke_target`=VALUES(`invoke_target`),`create_by`=VALUES(`create_by`),`update_time`=VALUES(`update_time`),`job_group`=VALUES(`job_group`),`misfire_policy`=VALUES(`misfire_policy`),`status`=VALUES(`status`),`create_time`=VALUES(`create_time`),`job_name`=VALUES(`job_name`),`job_params`=VALUES(`job_params`)
- 2021-01-22 17:31:41.849 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2021-01-22 17:31:41.850 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_level' AND `status`=1 LIMIT 1
- 2021-01-22 17:31:41.853 [DEBU] [ 10 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2021-01-22 17:31:41.854 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_status' AND `status`=1 LIMIT 1
- 2021-01-22 17:31:41.857 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2021-01-22 17:31:41.896 [DEBU] [ 39 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_level' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-22 17:31:41.899 [DEBU] [ 45 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2021-01-22 17:31:41.900 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_status' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-22 17:31:41.903 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2021-01-22 17:31:41.905 [DEBU] [ 1 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2021-01-22 17:31:41.913 [DEBU] [ 11 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2021-01-22 17:31:41.914 [DEBU] [ 1 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2021-01-22 17:31:41.919 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2021-01-22 17:31:41.913 [DEBU] [ 68 ms] [default] SHOW FULL COLUMNS FROM `wf_news`
- 2021-01-22 17:31:41.920 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2021-01-22 17:31:41.920 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`dept_name`,`oper_ip`,`status`,`business_type`,`error_msg`,`json_result`,`oper_time`,`oper_id`,`title`,`oper_url`,`oper_param`,`method`,`operator_type`,`oper_name`,`oper_location`) VALUES('GET','','[::1]',1,0,'','{"code":0,"msg":"ok"}',1611307901,0,'','/system/config/dict/getDicts?dictType=flow_level','{"dictType":"flow_level"}','/system/config/dict/getDicts',1,'demo','内网IP') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`error_msg`=VALUES(`error_msg`)
- 2021-01-22 17:31:41.920 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2021-01-22 17:31:41.925 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`request_method`,`oper_location`,`error_msg`,`oper_ip`,`business_type`,`method`,`operator_type`,`dept_name`,`oper_url`,`status`,`oper_id`,`oper_param`,`json_result`,`oper_time`,`title`) VALUES('demo','GET','内网IP','','[::1]',0,'/system/config/dict/getDicts',1,'','/system/config/dict/getDicts?dictType=flow_status',1,0,'{"dictType":"flow_status"}','{"code":0,"msg":"ok"}',1611307901,'') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`title`=VALUES(`title`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`)
- 2021-01-22 17:31:41.978 [DEBU] [ 57 ms] [default] SHOW FULL COLUMNS FROM `wf_run`
- 2021-01-22 17:31:41.981 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_run` WHERE `from_id`=1 AND `from_table`='wf_news' AND `is_del`=0 AND `status`=0 ORDER BY `id` desc LIMIT 1
- 2021-01-22 17:31:41.991 [DEBU] [ 10 ms] [default] SHOW FULL COLUMNS FROM `wf_run_process`
- 2021-01-22 17:31:41.992 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (`run_id`=85) AND (run_flow_process in ('52') OR FIND_IN_SET(run_flow_process,'52')) AND (`run_flow`=2) AND (`status`=0)
- 2021-01-22 17:31:42.035 [DEBU] [ 42 ms] [default] SHOW FULL COLUMNS FROM `wf_flow`
- 2021-01-22 17:31:42.035 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2021-01-22 17:31:42.056 [DEBU] [ 20 ms] [default] SHOW FULL COLUMNS FROM `wf_flow_process`
- 2021-01-22 17:31:42.057 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2021-01-22 17:31:42.058 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2021-01-22 17:31:42.059 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2021-01-22 17:31:42.062 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2021-01-22 17:31:42.063 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2021-01-22 17:31:42.064 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2021-01-22 17:31:42.066 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (`run_id`=85) AND (run_flow_process in ('52') OR FIND_IN_SET(run_flow_process,'52')) AND (`run_flow`=2) AND (`status`=0) LIMIT 1
- 2021-01-22 17:31:42.067 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2021-01-22 17:31:42.068 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2021-01-22 17:31:42.069 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2021-01-22 17:31:42.113 [DEBU] [ 43 ms] [default] SHOW FULL COLUMNS FROM `wf_run_sign`
- 2021-01-22 17:31:42.114 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2021-01-22 17:31:42.119 [DEBU] [ 4 ms] [default] SHOW FULL COLUMNS FROM `user`
- 2021-01-22 17:31:42.120 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2021-01-22 17:31:42.121 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run` WHERE `from_id`=3 AND `from_table`='wf_news' AND `is_del`=0 AND `status`=0 ORDER BY `id` desc LIMIT 1
- 2021-01-22 17:31:42.123 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_run_process` WHERE (`run_id`=87) AND (run_flow_process in ('2') OR FIND_IN_SET(run_flow_process,'2')) AND (`run_flow`=1) AND (`status`=0)
- 2021-01-22 17:31:42.123 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2021-01-22 17:31:42.124 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2021-01-22 17:31:42.125 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2021-01-22 17:31:42.149 [DEBU] [ 22 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2021-01-22 17:31:42.150 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2021-01-22 17:31:42.151 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2021-01-22 17:31:42.152 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2021-01-22 17:31:42.153 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2021-01-22 17:31:42.153 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run` WHERE `from_table`='wf_news' AND `is_del`=0 AND `status`=0 AND `from_id`=4 ORDER BY `id` desc LIMIT 1
- 2021-01-22 17:31:42.154 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (`run_id`=88) AND (run_flow_process in ('1') OR FIND_IN_SET(run_flow_process,'1')) AND (`run_flow`=1) AND (`status`=0)
- 2021-01-22 17:31:42.155 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2021-01-22 17:31:42.156 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2021-01-22 17:31:42.157 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2021-01-22 17:31:42.159 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2021-01-22 17:31:42.160 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=368 LIMIT 1
- 2021-01-22 17:31:42.162 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 368) AND (`run_flow`=1) AND (`run_id`=88)
- 2021-01-22 17:31:42.165 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`operator_type`,`oper_name`,`oper_url`,`status`,`oper_time`,`oper_id`,`method`,`oper_param`,`business_type`,`request_method`,`dept_name`,`oper_ip`,`oper_location`,`json_result`,`error_msg`) VALUES('',1,'demo','/system/wf/news/list?pageNum=1&pageSize=10',1,1611307902,0,'/system/wf/news/list','{"pageNum":"1","pageSize":"10"}',0,'GET','','[::1]','内网IP','{"code":0,"msg":"获取列表数据成功"}','') ON DUPLICATE KEY UPDATE `oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`)
- 2021-01-22 17:31:47.901 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE (`type`='wf_news') AND (`status`=1) AND (`is_del`=0)
- 2021-01-22 17:31:47.903 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_url`,`oper_location`,`oper_param`,`oper_id`,`title`,`operator_type`,`status`,`error_msg`,`request_method`,`oper_name`,`oper_time`,`business_type`,`dept_name`,`oper_ip`,`json_result`) VALUES('/system/wf/flow/wfStart','/system/wf/flow/wfStart?wf_type=wf_news&wf_title=title&wf_status_field=status&wf_fid=7','内网IP','{"wf_fid":"7","wf_status_field":"status","wf_title":"title","wf_type":"wf_news"}',0,'',1,1,'','GET','demo',1611307907,0,'','[::1]','{"code":0,"msg":"ok"}') ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`method`=VALUES(`method`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`business_type`=VALUES(`business_type`)
|