| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195 |
- 2021-01-11 10:35:44.734 [DEBU] [ 86 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
- 2021-01-11 10:35:44.746 [DEBU] [ 11 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
- 2021-01-11 10:35:44.747 [DEBU] [ 1 ms] [default] INSERT INTO `sys_job`(`job_params`,`invoke_target`,`create_by`,`update_by`,`update_time`,`misfire_policy`,`concurrent`,`status`,`create_time`,`job_id`,`job_name`,`job_group`,`cron_expression`,`remark`) VALUES('','checkUserOnline',2,2,1596768044,1,0,0,1596763977,8,'在线用户定时更新','DEFAULT','5 */10 * * * *','') ON DUPLICATE KEY UPDATE `remark`=VALUES(`remark`),`job_id`=VALUES(`job_id`),`job_name`=VALUES(`job_name`),`job_group`=VALUES(`job_group`),`cron_expression`=VALUES(`cron_expression`),`job_params`=VALUES(`job_params`),`invoke_target`=VALUES(`invoke_target`),`create_by`=VALUES(`create_by`),`update_by`=VALUES(`update_by`),`update_time`=VALUES(`update_time`),`misfire_policy`=VALUES(`misfire_policy`),`concurrent`=VALUES(`concurrent`),`status`=VALUES(`status`),`create_time`=VALUES(`create_time`)
- 2021-01-11 10:38:58.281 [DEBU] [ 77 ms] [default] SHOW FULL COLUMNS FROM `user`
- 2021-01-11 10:38:58.285 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA==' LIMIT 1
- 2021-01-11 10:38:58.329 [DEBU] [ 44 ms] [default] INSERT INTO `user`(`user_nickname`,`user_password`,`avatar`,`dept_id`,`user_status`,`sex`,`is_admin`,`id`,`mobile`,`birthday`,`last_login_ip`,`user_name`,`create_time`,`user_email`,`last_login_time`,`remark`) VALUES('测试账号','9OFlt5qzzvCiZWhe7ilcLA==','pub_upload/2020-09-03/c5disauti1wogasemy.jpeg',109,1,2,1,31,'18699888856',0,'[::1]','demo',1581314770,'223@qq.com',1610332738,'') ON DUPLICATE KEY UPDATE `user_status`=VALUES(`user_status`),`sex`=VALUES(`sex`),`is_admin`=VALUES(`is_admin`),`last_login_ip`=VALUES(`last_login_ip`),`id`=VALUES(`id`),`mobile`=VALUES(`mobile`),`birthday`=VALUES(`birthday`),`last_login_time`=VALUES(`last_login_time`),`remark`=VALUES(`remark`),`user_name`=VALUES(`user_name`),`create_time`=VALUES(`create_time`),`user_email`=VALUES(`user_email`),`dept_id`=VALUES(`dept_id`),`user_nickname`=VALUES(`user_nickname`),`user_password`=VALUES(`user_password`),`avatar`=VALUES(`avatar`)
- 2021-01-11 10:38:58.499 [DEBU] [169 ms] [default] SHOW FULL COLUMNS FROM `sys_login_log`
- 2021-01-11 10:38:58.526 [DEBU] [ 25 ms] [default] INSERT INTO `sys_login_log`(`login_time`,`module`,`login_name`,`ipaddr`,`browser`,`msg`,`info_id`,`login_location`,`os`,`status`) VALUES(1610332738,'系统后台','demo','[::1]','Chrome','登录成功',0,'内网IP','Windows 10',1) ON DUPLICATE KEY UPDATE `login_location`=VALUES(`login_location`),`os`=VALUES(`os`),`status`=VALUES(`status`),`info_id`=VALUES(`info_id`),`ipaddr`=VALUES(`ipaddr`),`browser`=VALUES(`browser`),`msg`=VALUES(`msg`),`login_time`=VALUES(`login_time`),`module`=VALUES(`module`),`login_name`=VALUES(`login_name`)
- 2021-01-11 10:39:34.354 [DEBU] [ 5 ms] [default] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA==' LIMIT 1
- 2021-01-11 10:39:34.391 [DEBU] [ 36 ms] [default] INSERT INTO `user`(`last_login_time`,`dept_id`,`id`,`user_password`,`is_admin`,`user_nickname`,`avatar`,`user_status`,`user_email`,`remark`,`mobile`,`create_time`,`sex`,`last_login_ip`,`user_name`,`birthday`) VALUES(1610332774,109,31,'9OFlt5qzzvCiZWhe7ilcLA==',1,'测试账号','pub_upload/2020-09-03/c5disauti1wogasemy.jpeg',1,'223@qq.com','','18699888856',1581314770,2,'[::1]','demo',0) ON DUPLICATE KEY UPDATE `create_time`=VALUES(`create_time`),`user_status`=VALUES(`user_status`),`user_email`=VALUES(`user_email`),`remark`=VALUES(`remark`),`mobile`=VALUES(`mobile`),`birthday`=VALUES(`birthday`),`sex`=VALUES(`sex`),`last_login_ip`=VALUES(`last_login_ip`),`user_name`=VALUES(`user_name`),`user_password`=VALUES(`user_password`),`last_login_time`=VALUES(`last_login_time`),`dept_id`=VALUES(`dept_id`),`id`=VALUES(`id`),`avatar`=VALUES(`avatar`),`is_admin`=VALUES(`is_admin`),`user_nickname`=VALUES(`user_nickname`)
- 2021-01-11 10:39:34.393 [DEBU] [ 1 ms] [default] INSERT INTO `sys_login_log`(`ipaddr`,`login_location`,`os`,`login_time`,`info_id`,`login_name`,`browser`,`status`,`msg`,`module`) VALUES('[::1]','内网IP','Windows 10',1610332774,0,'demo','Chrome',1,'登录成功','系统后台') ON DUPLICATE KEY UPDATE `login_time`=VALUES(`login_time`),`ipaddr`=VALUES(`ipaddr`),`login_location`=VALUES(`login_location`),`os`=VALUES(`os`),`status`=VALUES(`status`),`msg`=VALUES(`msg`),`module`=VALUES(`module`),`info_id`=VALUES(`info_id`),`login_name`=VALUES(`login_name`),`browser`=VALUES(`browser`)
- 2021-01-11 10:39:34.424 [DEBU] [ 29 ms] [default] SHOW FULL COLUMNS FROM `user_online`
- 2021-01-11 10:39:34.427 [DEBU] [ 2 ms] [default] INSERT INTO `user_online`(`token`,`create_time`,`user_name`,`ip`,`explorer`,`os`,`id`,`uuid`) VALUES('fCLUxFpxP3QqVAezWSiqJ34BRz5YTp2qDGmH5L5jiv7IuTjnVwU1hMxIMAIJawrfnKlUrJ0bp3JqJDqtqHcthGGOo2EwRaH+tD6bwoXXb91HDHdRAqdM67x7SGt/upe8',1610332774,'demo','[::1]','Chrome','Windows 10',0,'a45da7f7aa26a14906532e30245694df') 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`)
- 2021-01-11 10:39:34.453 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=31 LIMIT 1
- 2021-01-11 10:39:34.504 [DEBU] [ 50 ms] [default] SHOW FULL COLUMNS FROM `role`
- 2021-01-11 10:39:34.505 [DEBU] [ 1 ms] [default] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
- 2021-01-11 10:39:34.549 [DEBU] [ 41 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule`
- 2021-01-11 10:39:34.560 [DEBU] [ 10 ms] [default] SELECT * FROM `casbin_rule`
- 2021-01-11 10:39:34.601 [DEBU] [ 35 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2021-01-11 10:39:34.622 [DEBU] [ 20 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2021-01-11 10:39:34.662 [DEBU] [ 33 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2021-01-11 10:39:34.664 [DEBU] [ 21 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2021-01-11 10:39:34.686 [DEBU] [ 23 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_name`,`oper_location`,`title`,`business_type`,`oper_ip`,`oper_param`,`error_msg`,`oper_time`,`request_method`,`dept_name`,`oper_url`,`json_result`,`status`,`oper_id`,`operator_type`) VALUES('/system/index/getInfo','demo','内网IP','',0,'[::1]','{}','',1610332774,'GET','','/system/index/getInfo','{"code":0,"msg":"ok"}',1,0,1) ON DUPLICATE KEY UPDATE `oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`)
- 2021-01-11 10:39:34.686 [DEBU] [ 22 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`oper_param`,`status`,`oper_time`,`oper_id`,`business_type`,`error_msg`,`title`,`operator_type`,`dept_name`,`oper_url`,`oper_location`,`json_result`,`method`,`oper_name`,`oper_ip`) VALUES('GET','{}',1,1610332774,0,0,'','',1,'','/system/index/getRouters','内网IP','{"code":0,"msg":"ok"}','/system/index/getRouters','demo','[::1]') ON DUPLICATE KEY UPDATE `oper_ip`=VALUES(`oper_ip`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`)
- 2021-01-11 10:39:39.096 [DEBU] [ 45 ms] [default] SHOW FULL COLUMNS FROM `cms_category`
- 2021-01-11 10:39:39.096 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category` ORDER BY `list_order` ASC,`id` ASC
- 2021-01-11 10:39:39.128 [DEBU] [ 30 ms] [default] SHOW FULL COLUMNS FROM `cms_news`
- 2021-01-11 10:39:39.129 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id)
- 2021-01-11 10:39:39.130 [DEBU] [ 1 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,10
- 2021-01-11 10:39:39.144 [DEBU] [ 13 ms] [default] SHOW FULL COLUMNS FROM `cms_category_news`
- 2021-01-11 10:39:39.146 [DEBU] [ 2 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
- 2021-01-11 10:39:39.146 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
- 2021-01-11 10:39:39.147 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=128
- 2021-01-11 10:39:39.147 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
- 2021-01-11 10:39:39.148 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
- 2021-01-11 10:39:39.149 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
- 2021-01-11 10:39:39.149 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
- 2021-01-11 10:39:39.150 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=123
- 2021-01-11 10:39:39.150 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=122
- 2021-01-11 10:39:39.151 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=121
- 2021-01-11 10:39:39.198 [DEBU] [ 47 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2021-01-11 10:39:39.206 [DEBU] [ 7 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_pub_type' AND `status`=1 LIMIT 1
- 2021-01-11 10:39:39.226 [DEBU] [ 20 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2021-01-11 10:39:39.226 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_pub_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-11 10:39:39.227 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `status`=1 AND `dict_type`='cms_news_attr' LIMIT 1
- 2021-01-11 10:39:39.228 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_attr' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-11 10:39:39.229 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_type' AND `status`=1 LIMIT 1
- 2021-01-11 10:39:39.230 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-11 10:39:39.232 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`business_type`,`method`,`request_method`,`operator_type`,`oper_param`,`oper_time`,`oper_location`,`oper_id`,`oper_name`,`dept_name`,`json_result`,`status`,`error_msg`,`oper_url`,`oper_ip`) VALUES('文章管理',0,'/system/cms/news/list','GET',1,'{"keyWords":"","pageNum":"1","pageSize":"10"}',1610332779,'内网IP',0,'demo','','{"code":0,"msg":"信息列表"}',1,'','/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','[::1]') ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`)
- 2021-01-11 10:39:41.132 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE (`news`.`is_slide`=1) AND (`news`.`news_status`=1)
- 2021-01-11 10:39:41.133 [DEBU] [ 1 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE (`news`.`is_slide`=1) AND (`news`.`news_status`=1) ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,5
- 2021-01-11 10:39:41.134 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
- 2021-01-11 10:39:41.135 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
- 2021-01-11 10:39:41.135 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
- 2021-01-11 10:39:41.136 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=120
- 2021-01-11 10:39:41.136 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=118
- 2021-01-11 10:39:41.137 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE `news`.`news_status`=1
- 2021-01-11 10:39:41.139 [DEBU] [ 1 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE `news`.`news_status`=1 ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,7
- 2021-01-11 10:39:41.141 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
- 2021-01-11 10:39:41.142 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
- 2021-01-11 10:39:41.143 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=128
- 2021-01-11 10:39:41.143 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
- 2021-01-11 10:39:41.144 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
- 2021-01-11 10:39:41.145 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
- 2021-01-11 10:39:41.145 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
- 2021-01-11 10:39:41.147 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE (`news`.`recommended`=1) AND (`news`.`news_status`=1)
- 2021-01-11 10:39:41.148 [DEBU] [ 1 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE (`news`.`recommended`=1) AND (`news`.`news_status`=1) ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,4
- 2021-01-11 10:39:41.149 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
- 2021-01-11 10:39:41.149 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
- 2021-01-11 10:39:41.150 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
- 2021-01-11 10:39:41.150 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
- 2021-01-11 10:39:41.151 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE `news`.`news_status`=1
- 2021-01-11 10:39:41.152 [DEBU] [ 0 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE `news`.`news_status`=1 ORDER BY `news`.`news_hits` desc LIMIT 0,4
- 2021-01-11 10:39:41.153 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=111
- 2021-01-11 10:39:41.154 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=115
- 2021-01-11 10:39:41.155 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
- 2021-01-11 10:39:41.156 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=113
- 2021-01-11 10:39:45.273 [DEBU] [115 ms] [default] SHOW FULL COLUMNS FROM `model_info`
- 2021-01-11 10:39:45.274 [DEBU] [ 0 ms] [default] SELECT * FROM `model_info` WHERE `model_id`=9 LIMIT 1
- 2021-01-11 10:39:45.461 [DEBU] [186 ms] [default] SHOW FULL COLUMNS FROM `model_fields`
- 2021-01-11 10:39:45.463 [DEBU] [ 1 ms] [default] SELECT * FROM `model_fields` WHERE `model_id`=9 ORDER BY `field_sort` asc,`field_id` asc
- 2021-01-11 10:39:45.740 [DEBU] [276 ms] [default] SHOW FULL COLUMNS FROM `cms_news_attr`
- 2021-01-11 10:39:45.743 [DEBU] [ 2 ms] [default] SELECT * FROM `cms_news_attr` WHERE `art_id`=125 LIMIT 1
- 2021-01-11 10:39:45.744 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_news` WHERE `id`=125 LIMIT 1
- 2021-01-11 10:39:45.787 [DEBU] [ 41 ms] [default] INSERT INTO `cms_news`(`news_title`,`news_source`,`is_jump`,`delete_time`,`recommended`,`is_slide`,`news_like`,`news_keywords`,`is_top`,`news_hits`,`create_time`,`update_time`,`published_time`,`id`,`news_status`,`news_excerpt`,`thumbnail`,`jump_url`,`user_id`) VALUES('百城住宅库存连跌35个月 三四线库存创10年新低','',0,0,1,0,0,'',0,3,1604028929,1604029262,1604028885,125,1,'随着三、四线城市楼市交易量的提升,全国百城住宅库存再次降低。截至6月底,全国百城住宅库存已经连续35个月减少。','pub_upload/2020-10-30/c6pwsqcu6mi85nxf0g.png','',2) ON DUPLICATE KEY UPDATE `is_top`=VALUES(`is_top`),`recommended`=VALUES(`recommended`),`is_slide`=VALUES(`is_slide`),`news_like`=VALUES(`news_like`),`news_keywords`=VALUES(`news_keywords`),`id`=VALUES(`id`),`news_hits`=VALUES(`news_hits`),`create_time`=VALUES(`create_time`),`update_time`=VALUES(`update_time`),`published_time`=VALUES(`published_time`),`user_id`=VALUES(`user_id`),`news_status`=VALUES(`news_status`),`news_excerpt`=VALUES(`news_excerpt`),`thumbnail`=VALUES(`thumbnail`),`jump_url`=VALUES(`jump_url`),`delete_time`=VALUES(`delete_time`),`news_title`=VALUES(`news_title`),`news_source`=VALUES(`news_source`),`is_jump`=VALUES(`is_jump`)
- 2021-01-11 10:39:45.814 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE (`news`.`recommended`=1) AND (`news`.`news_status`=1)
- 2021-01-11 10:39:45.816 [DEBU] [ 1 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE (`news`.`recommended`=1) AND (`news`.`news_status`=1) ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,4
- 2021-01-11 10:39:45.818 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
- 2021-01-11 10:39:45.819 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
- 2021-01-11 10:39:45.820 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
- 2021-01-11 10:39:45.821 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
- 2021-01-11 10:39:45.824 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE `news`.`news_status`=1
- 2021-01-11 10:39:45.825 [DEBU] [ 1 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) WHERE `news`.`news_status`=1 ORDER BY `news`.`news_hits` desc LIMIT 0,4
- 2021-01-11 10:39:45.830 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=111
- 2021-01-11 10:39:45.832 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=115
- 2021-01-11 10:39:45.833 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
- 2021-01-11 10:39:45.834 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=113
- 2021-01-11 10:39:53.486 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_type' AND `status`=1 LIMIT 1
- 2021-01-11 10:39:53.488 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-11 10:39:53.488 [DEBU] [ 2 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
- 2021-01-11 10:39:53.490 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-11 10:39:53.491 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`business_type`,`oper_location`,`oper_url`,`oper_time`,`request_method`,`oper_name`,`dept_name`,`operator_type`,`oper_param`,`json_result`,`status`,`error_msg`,`oper_id`,`method`,`oper_ip`) VALUES('',0,'内网IP','/system/config/dict/getDicts?dictType=flow_type',1610332793,'GET','demo','',1,'{"dictType":"flow_type"}','{"code":0,"msg":"ok"}',1,'',0,'/system/config/dict/getDicts','[::1]') ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`oper_location`=VALUES(`oper_location`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`)
- 2021-01-11 10:39:53.493 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`dept_name`,`json_result`,`oper_time`,`method`,`operator_type`,`oper_url`,`oper_ip`,`oper_param`,`business_type`,`error_msg`,`oper_id`,`title`,`request_method`,`oper_location`,`status`) VALUES('demo','','{"code":0,"msg":"ok"}',1610332793,'/system/config/dict/getDicts',1,'/system/config/dict/getDicts?dictType=sys_normal_disable','[::1]','{"dictType":"sys_normal_disable"}',0,'',0,'','GET','内网IP',1) ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`oper_name`=VALUES(`oper_name`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`method`=VALUES(`method`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`)
- 2021-01-11 10:39:53.550 [DEBU] [ 65 ms] [default] SHOW FULL COLUMNS FROM `wf_flow`
- 2021-01-11 10:39:53.551 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `wf_flow` WHERE `is_del`=0
- 2021-01-11 10:39:53.552 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `is_del`=0 ORDER BY `sort_order` asc,`id` asc LIMIT 0,10
- 2021-01-11 10:39:53.589 [DEBU] [ 37 ms] [default] SHOW FULL COLUMNS FROM `wf_run`
- 2021-01-11 10:39:53.591 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE flow_id in(1,2,3,5,8) and status = 0 ORDER BY `id` asc
- 2021-01-11 10:39:53.593 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`request_method`,`oper_name`,`oper_url`,`oper_location`,`oper_param`,`json_result`,`oper_id`,`oper_time`,`error_msg`,`status`,`operator_type`,`dept_name`,`business_type`,`oper_ip`,`method`) VALUES('工作流列表','GET','demo','/system/wf/flow/list?pageNum=1&pageSize=10','内网IP','{"pageNum":"1","pageSize":"10"}','{"code":0,"msg":"获取列表数据成功"}',0,1610332793,'',1,1,'',0,'[::1]','/system/wf/flow/list') ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`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`),`oper_time`=VALUES(`oper_time`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`dept_name`=VALUES(`dept_name`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`)
- 2021-01-11 10:39:55.585 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2021-01-11 10:39:55.614 [DEBU] [ 28 ms] [default] SHOW FULL COLUMNS FROM `wf_flow_process`
- 2021-01-11 10:39:55.615 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE (`flow_id`=3) AND (`is_del`=0) ORDER BY `id` asc
- 2021-01-11 10:39:55.630 [DEBU] [ 15 ms] [default] SELECT COLUMN_NAME as field_name,column_comment as field_text FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'wf_news' AND table_schema = 'gfast_open'
- 2021-01-11 10:39:55.632 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`error_msg`,`oper_time`,`method`,`request_method`,`operator_type`,`dept_name`,`business_type`,`oper_param`,`json_result`,`status`,`oper_name`,`oper_ip`,`oper_id`,`title`,`oper_location`) VALUES('/system/wf/flow/designFlow?id=3','',1610332795,'/system/wf/flow/designFlow','GET',1,'',0,'{"id":"3"}','{"code":0,"msg":"ok"}',1,'demo','[::1]',0,'','内网IP') ON DUPLICATE KEY UPDATE `oper_ip`=VALUES(`oper_ip`),`oper_name`=VALUES(`oper_name`),`title`=VALUES(`title`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`)
- 2021-01-11 10:40:05.910 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2021-01-11 10:40:05.910 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2021-01-11 10:40:05.912 [DEBU] [ 0 ms] [default] DELETE FROM `user_online` WHERE `id`=16377
- 2021-01-11 10:40:09.382 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`status`,`oper_param`,`oper_time`,`oper_id`,`oper_name`,`request_method`,`operator_type`,`dept_name`,`oper_ip`,`error_msg`,`business_type`,`method`,`oper_location`,`json_result`,`title`,`oper_url`) VALUES(0,'{"auto_person":"4","auto_role_ids":"","auto_role_text":"","auto_sponsor_ids":"","auto_sponsor_text":"","flow_id":3,"is_back":"1","is_sing":"1","process_condition":"65,66","process_id":64,"process_in_set":[{"condition":null,"id":65,"prev_id":64,"process_name":"[直线]步骤","process_type":"is_step"},{"condition":null,"id":66,"prev_id":64,"process_name":"[直线]步骤","process_type":"is_step"}],"process_name":"步骤","process_type":"is_one","range_user_ids":"","range_user_text":"","style_height":"auto","style_width":"120","wf_action":"view","wf_mode":"1","work_ids":"","work_msg":"","work_sql":"","work_text":""}',1610332809,0,'demo','POST',1,'','[::1]','',0,'/system/wf/flow/saveAttr','内网IP','{"code":-1,"msg":"该功能仅对捐赠用户开放,捐赠299即可获得完整工作流功能及配套视频。"}','','/system/wf/flow/saveAttr') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`)
- 2021-01-11 10:42:13.639 [DEBU] [ 4 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`json_result`,`business_type`,`method`,`operator_type`,`dept_name`,`oper_location`,`error_msg`,`oper_id`,`oper_ip`,`oper_param`,`title`,`request_method`,`oper_name`,`status`,`oper_time`) VALUES('/system/wf/flow/saveAttr','{"code":-1,"msg":"该功能仅对捐赠用户开放,捐赠299即可获得完整工作流功能及配套视频。"}',0,'/system/wf/flow/saveAttr',1,'','内网IP','',0,'[::1]','{"auto_person":"4","auto_role_ids":"","auto_role_text":"","auto_sponsor_ids":"","auto_sponsor_text":"","flow_id":3,"is_back":"1","is_sing":"1","process_condition":"65,66","process_id":64,"process_in_set":[{"condition":null,"id":65,"prev_id":64,"process_name":"[直线]步骤","process_type":"is_step"},{"condition":null,"id":66,"prev_id":64,"process_name":"[直线]步骤","process_type":"is_step"}],"process_name":"步骤","process_type":"is_one","range_user_ids":"","range_user_text":"","style_height":"auto","style_width":"120","wf_action":"view","wf_mode":"1","work_ids":"","work_msg":"","work_sql":"","work_text":""}','','POST','demo',0,1610332933) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`status`=VALUES(`status`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`)
- 2021-01-11 10:42:15.766 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_status' AND `status`=1 LIMIT 1
- 2021-01-11 10:42:15.768 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_status' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-11 10:42:15.773 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_location`,`request_method`,`oper_name`,`dept_name`,`oper_time`,`oper_ip`,`json_result`,`status`,`oper_id`,`method`,`oper_param`,`error_msg`,`title`,`business_type`,`operator_type`) VALUES('/system/config/dict/getDicts?dictType=flow_status','内网IP','GET','demo','',1610332935,'[::1]','{"code":0,"msg":"ok"}',1,0,'/system/config/dict/getDicts','{"dictType":"flow_status"}','','',0,1) ON DUPLICATE KEY UPDATE `oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`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`)
- 2021-01-11 10:42:15.774 [DEBU] [ 7 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_level' AND `status`=1 LIMIT 1
- 2021-01-11 10:42:15.775 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_level' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2021-01-11 10:42:15.779 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`oper_location`,`error_msg`,`oper_ip`,`operator_type`,`dept_name`,`oper_url`,`status`,`oper_id`,`title`,`json_result`,`oper_param`,`oper_time`,`business_type`,`method`,`request_method`) VALUES('demo','内网IP','','[::1]',1,'','/system/config/dict/getDicts?dictType=flow_level',1,0,'','{"code":0,"msg":"ok"}','{"dictType":"flow_level"}',1610332935,0,'/system/config/dict/getDicts','GET') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`)
- 2021-01-11 10:42:15.810 [DEBU] [ 44 ms] [default] SHOW FULL COLUMNS FROM `wf_news`
- 2021-01-11 10:42:15.810 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2021-01-11 10:42:15.811 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2021-01-11 10:42:15.819 [DEBU] [ 8 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-11 10:42:15.833 [DEBU] [ 14 ms] [default] SHOW FULL COLUMNS FROM `wf_run_process`
- 2021-01-11 10:42:15.844 [DEBU] [ 11 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-11 10:42:15.845 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:15.846 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2021-01-11 10:42:15.847 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2021-01-11 10:42:15.848 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2021-01-11 10:42:15.848 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2021-01-11 10:42:15.849 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2021-01-11 10:42:15.850 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2021-01-11 10:42:15.851 [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-11 10:42:15.851 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2021-01-11 10:42:15.852 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2021-01-11 10:42:15.853 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2021-01-11 10:42:15.880 [DEBU] [ 27 ms] [default] SHOW FULL COLUMNS FROM `wf_run_sign`
- 2021-01-11 10:42:15.881 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2021-01-11 10:42:15.882 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:15.882 [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-11 10:42:15.883 [DEBU] [ 0 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-11 10:42:15.884 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2021-01-11 10:42:15.885 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:15.885 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:15.886 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2021-01-11 10:42:15.887 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2021-01-11 10:42:15.889 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2021-01-11 10:42:15.890 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2021-01-11 10:42:15.891 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2021-01-11 10:42:15.892 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE `from_id`=4 AND `from_table`='wf_news' AND `is_del`=0 AND `status`=0 ORDER BY `id` desc LIMIT 1
- 2021-01-11 10:42:15.893 [DEBU] [ 1 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-11 10:42:15.893 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2021-01-11 10:42:15.894 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2021-01-11 10:42:15.895 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2021-01-11 10:42:15.896 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:15.897 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=368 LIMIT 1
- 2021-01-11 10:42:15.897 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 368) AND (`run_flow`=1) AND (`run_id`=88)
- 2021-01-11 10:42:15.899 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`operator_type`,`dept_name`,`oper_param`,`status`,`error_msg`,`title`,`method`,`oper_ip`,`oper_id`,`request_method`,`oper_name`,`oper_url`,`oper_location`,`json_result`,`oper_time`) VALUES(0,1,'','{"pageNum":"1","pageSize":"10"}',1,'','','/system/wf/news/list','[::1]',0,'GET','demo','/system/wf/news/list?pageNum=1&pageSize=10','内网IP','{"code":0,"msg":"获取列表数据成功"}',1610332935) ON DUPLICATE KEY UPDATE `oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`)
- 2021-01-11 10:42:23.403 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE (`type`='wf_news') AND (`status`=1) AND (`is_del`=0)
- 2021-01-11 10:42:23.405 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`json_result`,`oper_time`,`title`,`oper_url`,`oper_ip`,`oper_location`,`status`,`error_msg`,`business_type`,`method`,`operator_type`,`dept_name`,`oper_id`,`request_method`,`oper_name`) VALUES('{"wf_fid":"5","wf_status_field":"status","wf_title":"title","wf_type":"wf_news"}','{"code":0,"msg":"ok"}',1610332943,'','/system/wf/flow/wfStart?wf_type=wf_news&wf_title=title&wf_status_field=status&wf_fid=5','[::1]','内网IP',1,'',0,'/system/wf/flow/wfStart',1,'',0,'GET','demo') ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_id`=VALUES(`oper_id`)
- 2021-01-11 10:42:35.562 [DEBU] [ 20 ms] [default] SHOW FULL COLUMNS FROM `wf_run_log`
- 2021-01-11 10:42:35.563 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_log` WHERE `from_id`=1 AND `from_table`='wf_news'
- 2021-01-11 10:42:35.564 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=1 LIMIT 1
- 2021-01-11 10:42:35.565 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:35.566 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:35.566 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:35.567 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:35.568 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:35.568 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:35.570 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_param`,`oper_id`,`oper_location`,`json_result`,`oper_time`,`oper_name`,`request_method`,`operator_type`,`error_msg`,`business_type`,`method`,`oper_url`,`oper_ip`,`status`,`title`) VALUES('','{"id":"1","wf_type":"wf_news"}',0,'内网IP','{"code":0,"msg":"ok"}',1610332955,'demo','GET',1,'',0,'/system/wf/news/checkLog','/system/wf/news/checkLog?id=1&wf_type=wf_news','[::1]',1,'') ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`oper_name`=VALUES(`oper_name`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`)
- 2021-01-11 10:42:41.009 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_flow` WHERE `is_del`=0
- 2021-01-11 10:42:41.012 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_flow` WHERE `is_del`=0 ORDER BY `sort_order` asc,`id` asc LIMIT 0,10
- 2021-01-11 10:42:41.015 [DEBU] [ 3 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`oper_name`,`oper_url`,`business_type`,`oper_ip`,`error_msg`,`oper_id`,`title`,`method`,`operator_type`,`oper_param`,`dept_name`,`oper_location`,`json_result`,`status`,`oper_time`) VALUES('GET','demo','/system/config/dict/getDicts?dictType=flow_type',0,'[::1]','',0,'','/system/config/dict/getDicts',1,'{"dictType":"flow_type"}','','内网IP','{"code":0,"msg":"ok"}',1,1610332961) ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`dept_name`=VALUES(`dept_name`)
- 2021-01-11 10:42:41.015 [DEBU] [ 4 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`dept_name`,`oper_ip`,`oper_time`,`method`,`oper_location`,`status`,`title`,`request_method`,`oper_url`,`oper_param`,`error_msg`,`oper_id`,`operator_type`,`oper_name`,`json_result`) VALUES(0,'','[::1]',1610332961,'/system/config/dict/getDicts','内网IP',1,'','GET','/system/config/dict/getDicts?dictType=sys_normal_disable','{"dictType":"sys_normal_disable"}','',0,1,'demo','{"code":0,"msg":"ok"}') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`),`method`=VALUES(`method`),`oper_location`=VALUES(`oper_location`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`)
- 2021-01-11 10:42:41.016 [DEBU] [ 4 ms] [default] SELECT * FROM `wf_run` WHERE flow_id in(1,2,3,5,8) and status = 0 ORDER BY `id` asc
- 2021-01-11 10:42:41.018 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`error_msg`,`method`,`request_method`,`operator_type`,`oper_url`,`oper_time`,`business_type`,`dept_name`,`oper_param`,`json_result`,`status`,`oper_name`,`title`,`oper_ip`,`oper_location`,`oper_id`) VALUES('','/system/wf/flow/list','GET',1,'/system/wf/flow/list?pageNum=1&pageSize=10',1610332961,0,'','{"pageNum":"1","pageSize":"10"}','{"code":0,"msg":"获取列表数据成功"}',1,'demo','工作流列表','[::1]','内网IP',0) ON DUPLICATE KEY UPDATE `error_msg`=VALUES(`error_msg`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_ip`=VALUES(`oper_ip`)
- 2021-01-11 10:42:44.039 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2021-01-11 10:42:44.040 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE (`flow_id`=3) AND (`is_del`=0) ORDER BY `id` asc
- 2021-01-11 10:42:44.052 [DEBU] [ 11 ms] [default] SELECT COLUMN_NAME as field_name,column_comment as field_text FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'wf_news' AND table_schema = 'gfast_open'
- 2021-01-11 10:42:44.055 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`status`,`error_msg`,`business_type`,`request_method`,`operator_type`,`oper_name`,`oper_ip`,`dept_name`,`oper_location`,`oper_param`,`json_result`,`oper_id`,`oper_time`,`title`,`method`,`oper_url`) VALUES(1,'',0,'GET',1,'demo','[::1]','','内网IP','{"id":"3"}','{"code":0,"msg":"ok"}',0,1610332964,'','/system/wf/flow/designFlow','/system/wf/flow/designFlow?id=3') ON DUPLICATE KEY UPDATE `oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`oper_time`=VALUES(`oper_time`),`oper_url`=VALUES(`oper_url`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`)
- 2021-01-11 10:42:46.736 [DEBU] [ 3 ms] [default] SELECT * FROM `wf_run` WHERE `status` IN (0) ORDER BY `id` asc
- 2021-01-11 10:42:46.736 [DEBU] [ 4 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`oper_time`,`title`,`method`,`oper_name`,`json_result`,`status`,`operator_type`,`oper_url`,`oper_param`,`business_type`,`request_method`,`error_msg`,`oper_id`,`dept_name`,`oper_ip`) VALUES('内网IP',1610332966,'','/system/config/dict/getDicts','demo','{"code":0,"msg":"ok"}',1,1,'/system/config/dict/getDicts?dictType=flow_level','{"dictType":"flow_level"}',0,'GET','',0,'','[::1]') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`)
- 2021-01-11 10:42:46.738 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2021-01-11 10:42:46.739 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `run_id`=85 AND `run_flow_process`='52'
- 2021-01-11 10:42:46.741 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2021-01-11 10:42:46.742 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `run_flow_process`='2' AND `run_id`=87
- 2021-01-11 10:42:46.744 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2021-01-11 10:42:46.746 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `run_flow_process`='1' AND `run_id`=88
- 2021-01-11 10:42:46.748 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`business_type`,`request_method`,`operator_type`,`oper_name`,`dept_name`,`oper_id`,`oper_location`,`oper_param`,`status`,`title`,`oper_url`,`oper_ip`,`json_result`,`error_msg`,`method`) VALUES(1610332966,0,'GET',1,'demo','',0,'内网IP','{}',1,'流程监控','/system/wf/flow/monitoring','[::1]','{"code":0,"msg":"ok"}','','/system/wf/flow/monitoring') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`title`=VALUES(`title`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`oper_time`=VALUES(`oper_time`)
|