| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625 |
- 2020-12-07 09:44:36.160 [DEBU] [ 46 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
- 2020-12-07 09:44:36.174 [DEBU] [ 11 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
- 2020-12-07 09:44:36.175 [DEBU] [ 0 ms] [default] INSERT INTO `sys_job`(`invoke_target`,`misfire_policy`,`create_time`,`job_id`,`job_params`,`job_group`,`concurrent`,`update_by`,`job_name`,`status`,`remark`,`cron_expression`,`create_by`,`update_time`) VALUES('checkUserOnline',1,1596763977,8,'','DEFAULT',0,2,'在线用户定时更新',0,'','5 */10 * * * *',2,1596768044) ON DUPLICATE KEY UPDATE `job_name`=VALUES(`job_name`),`status`=VALUES(`status`),`cron_expression`=VALUES(`cron_expression`),`create_by`=VALUES(`create_by`),`update_time`=VALUES(`update_time`),`remark`=VALUES(`remark`),`job_id`=VALUES(`job_id`),`job_params`=VALUES(`job_params`),`job_group`=VALUES(`job_group`),`invoke_target`=VALUES(`invoke_target`),`misfire_policy`=VALUES(`misfire_policy`),`create_time`=VALUES(`create_time`),`concurrent`=VALUES(`concurrent`),`update_by`=VALUES(`update_by`)
- 2020-12-07 09:45:49.550 [DEBU] [ 47 ms] [default] SHOW FULL COLUMNS FROM `user`
- 2020-12-07 09:45:49.552 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA==' LIMIT 1
- 2020-12-07 09:45:49.611 [DEBU] [ 56 ms] [default] INSERT INTO `user`(`mobile`,`create_time`,`avatar`,`remark`,`id`,`user_status`,`user_email`,`sex`,`dept_id`,`birthday`,`user_password`,`last_login_time`,`last_login_ip`,`user_name`,`user_nickname`,`is_admin`) VALUES('18699888856',1581314770,'pub_upload/2020-09-03/c5disauti1wogasemy.jpeg','',31,1,'223@qq.com',2,109,0,'9OFlt5qzzvCiZWhe7ilcLA==',1607305549,'192.168.0.212','demo','测试账号',1) ON DUPLICATE KEY UPDATE `last_login_ip`=VALUES(`last_login_ip`),`birthday`=VALUES(`birthday`),`user_password`=VALUES(`user_password`),`last_login_time`=VALUES(`last_login_time`),`user_name`=VALUES(`user_name`),`user_nickname`=VALUES(`user_nickname`),`is_admin`=VALUES(`is_admin`),`mobile`=VALUES(`mobile`),`create_time`=VALUES(`create_time`),`avatar`=VALUES(`avatar`),`sex`=VALUES(`sex`),`dept_id`=VALUES(`dept_id`),`remark`=VALUES(`remark`),`id`=VALUES(`id`),`user_status`=VALUES(`user_status`),`user_email`=VALUES(`user_email`)
- 2020-12-07 09:45:49.753 [DEBU] [138 ms] [default] SHOW FULL COLUMNS FROM `user_online`
- 2020-12-07 09:45:49.755 [DEBU] [ 1 ms] [default] INSERT INTO `user_online`(`user_name`,`ip`,`explorer`,`os`,`id`,`uuid`,`token`,`create_time`) VALUES('demo','192.168.0.212','Chrome','Windows 10',0,'eeaf0b8a58270d48100ec1b01876115c','fCLUxFpxP3QqVAezWSiqJ7D3QYZ7jkylPshqw8BVzfJJfAHAbwsSFhjrTyqHZEnzZwFT0YRIfumQTxnJAjCUHKpnrXWMqRHjXbV4yPu0tn7dHESK+gRr5ODilRyUkc5h',1607305549) ON DUPLICATE KEY UPDATE `token`=VALUES(`token`),`create_time`=VALUES(`create_time`),`user_name`=VALUES(`user_name`),`ip`=VALUES(`ip`),`explorer`=VALUES(`explorer`),`os`=VALUES(`os`),`id`=VALUES(`id`),`uuid`=VALUES(`uuid`)
- 2020-12-07 09:45:49.808 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=31 LIMIT 1
- 2020-12-07 09:45:50.065 [DEBU] [217 ms] [default] SHOW FULL COLUMNS FROM `sys_login_log`
- 2020-12-07 09:45:50.066 [DEBU] [257 ms] [default] SHOW FULL COLUMNS FROM `role`
- 2020-12-07 09:45:50.067 [DEBU] [ 0 ms] [default] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
- 2020-12-07 09:45:50.115 [DEBU] [ 49 ms] [default] INSERT INTO `sys_login_log`(`login_location`,`browser`,`msg`,`login_time`,`module`,`info_id`,`login_name`,`ipaddr`,`os`,`status`) VALUES('','Chrome','登录成功',1607305549,'系统后台',0,'demo','192.168.0.212','Windows 10',1) ON DUPLICATE KEY UPDATE `login_location`=VALUES(`login_location`),`browser`=VALUES(`browser`),`msg`=VALUES(`msg`),`login_time`=VALUES(`login_time`),`module`=VALUES(`module`),`info_id`=VALUES(`info_id`),`login_name`=VALUES(`login_name`),`ipaddr`=VALUES(`ipaddr`),`os`=VALUES(`os`),`status`=VALUES(`status`)
- 2020-12-07 09:45:50.177 [DEBU] [108 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule`
- 2020-12-07 09:45:50.178 [DEBU] [ 1 ms] [default] SELECT * FROM `casbin_rule`
- 2020-12-07 09:45:50.233 [DEBU] [ 50 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2020-12-07 09:45:50.240 [DEBU] [ 6 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2020-12-07 09:45:50.431 [DEBU] [ 33 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2020-12-07 09:45:50.459 [DEBU] [ 27 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`oper_name`,`oper_time`,`title`,`method`,`oper_ip`,`oper_param`,`oper_id`,`oper_location`,`error_msg`,`json_result`,`status`,`business_type`,`operator_type`,`dept_name`,`oper_url`) VALUES('GET','demo',1607305550,'','/system/index/getInfo','192.168.0.212','{}',0,'','','{"code":0,"msg":"ok"}',1,0,1,'','/system/index/getInfo') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`)
- 2020-12-07 09:45:50.463 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`method`,`operator_type`,`oper_name`,`dept_name`,`oper_time`,`title`,`oper_url`,`oper_param`,`json_result`,`status`,`error_msg`,`oper_id`,`oper_location`,`business_type`,`request_method`,`oper_ip`) VALUES('/system/index/getRouters',1,'demo','',1607305550,'','/system/index/getRouters','{}','{"code":0,"msg":"ok"}',1,'',0,'',0,'GET','192.168.0.212') ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`oper_location`=VALUES(`oper_location`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`)
- 2020-12-07 09:46:04.739 [DEBU] [ 55 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2020-12-07 09:46:04.742 [DEBU] [ 53 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2020-12-07 09:46:04.745 [DEBU] [ 3 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_level' AND `status`=1 LIMIT 1
- 2020-12-07 09:46:04.745 [DEBU] [ 5 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_status' AND `status`=1 LIMIT 1
- 2020-12-07 09:46:04.748 [DEBU] [ 59 ms] [default] SHOW FULL COLUMNS FROM `wf_news`
- 2020-12-07 09:46:04.749 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2020-12-07 09:46:04.750 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2020-12-07 09:46:04.772 [DEBU] [ 27 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2020-12-07 09:46:04.774 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_level' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 09:46:04.775 [DEBU] [ 29 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2020-12-07 09:46:04.776 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_status' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 09:46:04.785 [DEBU] [ 35 ms] [default] SHOW FULL COLUMNS FROM `wf_run`
- 2020-12-07 09:46:04.788 [DEBU] [ 1 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
- 2020-12-07 09:46:04.860 [DEBU] [ 71 ms] [default] SHOW FULL COLUMNS FROM `wf_run_process`
- 2020-12-07 09:46:04.862 [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)
- 2020-12-07 09:46:04.902 [DEBU] [ 38 ms] [default] SHOW FULL COLUMNS FROM `wf_flow`
- 2020-12-07 09:46:04.903 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:46:04.910 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`error_msg`,`oper_time`,`request_method`,`oper_name`,`oper_url`,`oper_location`,`oper_id`,`method`,`operator_type`,`oper_ip`,`status`,`title`,`business_type`,`dept_name`,`oper_param`) VALUES('{"code":0,"msg":"ok"}','',1607305564,'GET','demo','/system/config/dict/getDicts?dictType=flow_status','',0,'/system/config/dict/getDicts',1,'192.168.0.212',1,'',0,'','{"dictType":"flow_status"}') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`)
- 2020-12-07 09:46:04.922 [DEBU] [ 17 ms] [default] SHOW FULL COLUMNS FROM `wf_flow_process`
- 2020-12-07 09:46:04.924 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:46:04.926 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:46:04.927 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:46:04.929 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 09:46:04.930 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 09:46:04.932 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 09:46:04.933 [DEBU] [ 0 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
- 2020-12-07 09:46:04.935 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:46:04.939 [DEBU] [ 3 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:46:04.941 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:46:04.979 [DEBU] [ 35 ms] [default] SHOW FULL COLUMNS FROM `wf_run_sign`
- 2020-12-07 09:46:04.979 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 09:46:04.980 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:46:04.981 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run` WHERE `is_del`=0 AND `status`=0 AND `from_id`=3 AND `from_table`='wf_news' ORDER BY `id` desc LIMIT 1
- 2020-12-07 09:46:04.982 [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)
- 2020-12-07 09:46:04.983 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:46:04.985 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:46:04.987 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:46:04.989 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 09:46:04.990 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:04.991 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 09:46:04.992 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 09:46:04.993 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:46:04.996 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_url`,`oper_id`,`business_type`,`oper_name`,`json_result`,`oper_time`,`request_method`,`operator_type`,`oper_param`,`status`,`title`,`oper_ip`,`oper_location`,`error_msg`,`method`,`dept_name`) VALUES('/system/config/dict/getDicts?dictType=flow_level',0,0,'demo','{"code":0,"msg":"ok"}',1607305564,'GET',1,'{"dictType":"flow_level"}',1,'','192.168.0.212','','','/system/config/dict/getDicts','') ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 09:46:05.055 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`status`,`title`,`oper_name`,`json_result`,`request_method`,`oper_url`,`oper_ip`,`oper_location`,`error_msg`,`oper_time`,`oper_id`,`business_type`,`method`,`operator_type`,`oper_param`) VALUES('',1,'','demo','{"code":0,"msg":"获取列表数据成功"}','GET','/system/wf/news/list?pageNum=1&pageSize=10','192.168.0.212','','',1607305565,0,0,'/system/wf/news/list',1,'{"pageNum":"1","pageSize":"10"}') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`)
- 2020-12-07 09:46:23.620 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_flow` WHERE `type`='wf_news'
- 2020-12-07 09:46:23.732 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`method`,`oper_param`,`json_result`,`operator_type`,`oper_ip`,`oper_location`,`oper_url`,`request_method`,`oper_name`,`dept_name`,`status`,`error_msg`,`oper_time`,`oper_id`,`title`,`business_type`) VALUES('/system/wf/flow/wfStart','{"wf_fid":"4","wf_status_field":"status","wf_title":"2","wf_type":"wf_news"}','{"code":0,"msg":"ok"}',1,'192.168.0.212','','/system/wf/flow/wfStart?wf_type=wf_news&wf_title=2&wf_status_field=status&wf_fid=4','GET','demo','',1,'',1607305583,0,'',0) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`)
- 2020-12-07 09:46:26.742 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='sys_normal_disable' AND `status`=1 LIMIT 1
- 2020-12-07 09:46:26.742 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `wf_flow` WHERE `is_del`=0
- 2020-12-07 09:46:26.743 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `is_del`=0 ORDER BY `sort_order` asc,`id` asc LIMIT 0,10
- 2020-12-07 09:46:26.743 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='sys_normal_disable' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 09:46:26.745 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE flow_id in(1,2,3,5,8) and status = 0 ORDER BY `id` asc
- 2020-12-07 09:46:26.745 [DEBU] [ 3 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_type' AND `status`=1 LIMIT 1
- 2020-12-07 09:46:26.747 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 09:46:26.804 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`dept_name`,`oper_ip`,`oper_location`,`json_result`,`status`,`oper_time`,`oper_id`,`title`,`oper_name`,`oper_url`,`oper_param`,`error_msg`,`method`,`request_method`,`operator_type`) VALUES(0,'','192.168.0.212','','{"code":0,"msg":"ok"}',1,1607305586,0,'','demo','/system/config/dict/getDicts?dictType=flow_type','{"dictType":"flow_type"}','','/system/config/dict/getDicts','GET',1) ON DUPLICATE KEY UPDATE `oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`)
- 2020-12-07 09:46:26.831 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`title`,`request_method`,`error_msg`,`oper_id`,`business_type`,`oper_ip`,`oper_location`,`operator_type`,`json_result`,`status`,`oper_time`,`method`,`oper_name`,`dept_name`,`oper_url`,`oper_param`) VALUES('','GET','',0,0,'192.168.0.212','',1,'{"code":0,"msg":"ok"}',1,1607305586,'/system/config/dict/getDicts','demo','','/system/config/dict/getDicts?dictType=sys_normal_disable','{"dictType":"sys_normal_disable"}') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`method`=VALUES(`method`)
- 2020-12-07 09:46:26.834 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`oper_name`,`oper_url`,`oper_time`,`title`,`status`,`method`,`request_method`,`operator_type`,`oper_location`,`oper_param`,`error_msg`,`business_type`,`dept_name`,`oper_ip`,`json_result`) VALUES(0,'demo','/system/wf/flow/list?pageNum=1&pageSize=10',1607305586,'工作流列表',1,'/system/wf/flow/list','GET',1,'','{"pageNum":"1","pageSize":"10"}','',0,'','192.168.0.212','{"code":0,"msg":"获取列表数据成功"}') ON DUPLICATE KEY UPDATE `json_result`=VALUES(`json_result`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`title`=VALUES(`title`),`status`=VALUES(`status`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`)
- 2020-12-07 09:46:28.596 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:28.598 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE (`flow_id`=3) AND (`is_del`=0) ORDER BY `id` asc
- 2020-12-07 09:46:28.608 [DEBU] [ 9 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'
- 2020-12-07 09:46:28.671 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`oper_ip`,`error_msg`,`oper_time`,`operator_type`,`oper_name`,`dept_name`,`oper_url`,`oper_location`,`json_result`,`business_type`,`oper_id`,`method`,`request_method`,`oper_param`,`status`) VALUES('','192.168.0.212','',1607305588,1,'demo','','/system/wf/flow/designFlow?id=3','','{"code":0,"msg":"ok"}',0,0,'/system/wf/flow/designFlow','GET','{"id":"3"}',1) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`title`=VALUES(`title`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`)
- 2020-12-07 09:46:30.866 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:30.867 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `flow_id`=3 ORDER BY `id` desc
- 2020-12-07 09:46:30.898 [DEBU] [ 30 ms] [default] INSERT INTO `wf_flow_process`(`id`,`auto_sponsor_text`,`is_sing`,`updatetime`,`process_name`,`work_ids`,`is_back`,`wf_mode`,`auto_person`,`wf_action`,`work_text`,`auto_role_text`,`is_del`,`work_msg`,`process_type`,`range_user_text`,`flow_id`,`process_to`,`auto_sponsor_ids`,`settop`,`range_user_ids`,`out_condition`,`dateline`,`auto_role_ids`,`setleft`,`style`,`work_sql`) VALUES(0,'',1,0,'步骤','',1,0,4,'view','','',0,'','is_step','',3,'','',130,'','',0,'',130,'{"color":"#0e76a8","height":"auto","width":"120"}','') ON DUPLICATE KEY UPDATE `process_name`=VALUES(`process_name`),`work_ids`=VALUES(`work_ids`),`is_back`=VALUES(`is_back`),`wf_mode`=VALUES(`wf_mode`),`auto_person`=VALUES(`auto_person`),`wf_action`=VALUES(`wf_action`),`work_text`=VALUES(`work_text`),`auto_role_text`=VALUES(`auto_role_text`),`is_del`=VALUES(`is_del`),`work_msg`=VALUES(`work_msg`),`process_type`=VALUES(`process_type`),`range_user_text`=VALUES(`range_user_text`),`flow_id`=VALUES(`flow_id`),`process_to`=VALUES(`process_to`),`auto_sponsor_ids`=VALUES(`auto_sponsor_ids`),`settop`=VALUES(`settop`),`range_user_ids`=VALUES(`range_user_ids`),`out_condition`=VALUES(`out_condition`),`dateline`=VALUES(`dateline`),`auto_role_ids`=VALUES(`auto_role_ids`),`setleft`=VALUES(`setleft`),`style`=VALUES(`style`),`work_sql`=VALUES(`work_sql`),`updatetime`=VALUES(`updatetime`),`id`=VALUES(`id`),`auto_sponsor_text`=VALUES(`auto_sponsor_text`),`is_sing`=VALUES(`is_sing`)
- 2020-12-07 09:46:30.917 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:30.918 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE (`flow_id`=3) AND (`is_del`=0) ORDER BY `id` asc
- 2020-12-07 09:46:30.930 [DEBU] [ 10 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'
- 2020-12-07 09:46:30.956 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`dept_name`,`error_msg`,`oper_time`,`method`,`oper_url`,`request_method`,`oper_ip`,`json_result`,`status`,`business_type`,`title`,`operator_type`,`oper_location`,`oper_param`,`oper_id`) VALUES('demo','','',1607305590,'/system/wf/flow/addProcess','/system/wf/flow/addProcess','POST','192.168.0.212','{"code":0,"msg":"添加成功"}',1,0,'',1,'','{"id":3}',0) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`)
- 2020-12-07 09:46:30.978 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`method`,`oper_name`,`error_msg`,`business_type`,`oper_url`,`oper_location`,`title`,`request_method`,`oper_param`,`oper_time`,`operator_type`,`dept_name`,`oper_ip`,`json_result`,`status`) VALUES(0,'/system/wf/flow/designFlow','demo','',0,'/system/wf/flow/designFlow?id=3','','','GET','{"id":"3"}',1607305590,1,'','192.168.0.212','{"code":0,"msg":"ok"}',1) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 09:46:33.008 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:33.009 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `flow_id`=3 ORDER BY `id` desc
- 2020-12-07 09:46:33.048 [DEBU] [ 35 ms] [default] INSERT INTO `wf_flow_process`(`process_name`,`settop`,`auto_sponsor_text`,`style`,`updatetime`,`wf_mode`,`process_to`,`auto_person`,`work_text`,`out_condition`,`flow_id`,`auto_sponsor_ids`,`auto_role_ids`,`range_user_text`,`is_del`,`work_msg`,`process_type`,`work_ids`,`auto_role_text`,`is_sing`,`is_back`,`dateline`,`work_sql`,`id`,`range_user_ids`,`setleft`,`wf_action`) VALUES('步骤',160,'','{"color":"#0e76a8","height":"auto","width":"120"}',0,0,'',4,'','',3,'','','',0,'','is_step','','',1,1,0,'',0,'',160,'view') ON DUPLICATE KEY UPDATE `process_type`=VALUES(`process_type`),`work_ids`=VALUES(`work_ids`),`auto_role_text`=VALUES(`auto_role_text`),`is_sing`=VALUES(`is_sing`),`is_back`=VALUES(`is_back`),`dateline`=VALUES(`dateline`),`work_sql`=VALUES(`work_sql`),`id`=VALUES(`id`),`range_user_ids`=VALUES(`range_user_ids`),`setleft`=VALUES(`setleft`),`wf_action`=VALUES(`wf_action`),`process_name`=VALUES(`process_name`),`settop`=VALUES(`settop`),`auto_sponsor_text`=VALUES(`auto_sponsor_text`),`style`=VALUES(`style`),`updatetime`=VALUES(`updatetime`),`wf_mode`=VALUES(`wf_mode`),`process_to`=VALUES(`process_to`),`auto_person`=VALUES(`auto_person`),`work_text`=VALUES(`work_text`),`out_condition`=VALUES(`out_condition`),`flow_id`=VALUES(`flow_id`),`auto_sponsor_ids`=VALUES(`auto_sponsor_ids`),`auto_role_ids`=VALUES(`auto_role_ids`),`range_user_text`=VALUES(`range_user_text`),`is_del`=VALUES(`is_del`),`work_msg`=VALUES(`work_msg`)
- 2020-12-07 09:46:33.069 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:33.070 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE (`flow_id`=3) AND (`is_del`=0) ORDER BY `id` asc
- 2020-12-07 09:46:33.082 [DEBU] [ 9 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'
- 2020-12-07 09:46:33.114 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`title`,`operator_type`,`oper_param`,`business_type`,`oper_location`,`json_result`,`oper_id`,`request_method`,`oper_name`,`dept_name`,`oper_ip`,`status`,`method`,`oper_url`,`error_msg`,`oper_time`) VALUES('',1,'{"id":3}',0,'','{"code":0,"msg":"添加成功"}',0,'POST','demo','','192.168.0.212',1,'/system/wf/flow/addProcess','/system/wf/flow/addProcess','',1607305593) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 09:46:33.139 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`operator_type`,`oper_location`,`oper_param`,`json_result`,`status`,`title`,`oper_ip`,`error_msg`,`oper_time`,`business_type`,`oper_name`,`oper_url`,`method`,`request_method`,`dept_name`) VALUES(0,1,'','{"id":"3"}','{"code":0,"msg":"ok"}',1,'','192.168.0.212','',1607305593,0,'demo','/system/wf/flow/designFlow?id=3','/system/wf/flow/designFlow','GET','') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`title`=VALUES(`title`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 09:46:38.779 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=64 LIMIT 1
- 2020-12-07 09:46:38.780 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=65 LIMIT 1
- 2020-12-07 09:46:38.781 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=66 LIMIT 1
- 2020-12-07 09:46:38.786 [DEBU] [ 1 ms] [default] INSERT INTO `wf_flow_process`(`auto_role_text`,`is_del`,`process_name`,`process_type`,`is_back`,`setleft`,`auto_sponsor_text`,`range_user_text`,`is_sing`,`auto_person`,`wf_mode`,`wf_action`,`updatetime`,`dateline`,`work_text`,`range_user_ids`,`style`,`auto_role_ids`,`work_sql`,`flow_id`,`process_to`,`work_ids`,`out_condition`,`settop`,`id`,`auto_sponsor_ids`,`work_msg`) VALUES('',0,'步骤','is_one',1,100,'','',1,4,0,'view',0,0,'','','{"color":"#0e76a8","height":"auto","width":"120"}','','',3,'65,66','','',100,64,'',''),('',0,'步骤','is_step',1,270,'','',1,4,0,'view',0,0,'','','{"color":"#0e76a8","height":"auto","width":"120"}','','',3,'','','',349,65,'',''),('',0,'步骤','is_step',1,540,'','',1,4,0,'view',0,0,'','','{"color":"#0e76a8","height":"auto","width":"120"}','','',3,'','','',219,66,'','') ON DUPLICATE KEY UPDATE `auto_role_text`=VALUES(`auto_role_text`),`is_del`=VALUES(`is_del`),`process_name`=VALUES(`process_name`),`process_type`=VALUES(`process_type`),`is_back`=VALUES(`is_back`),`setleft`=VALUES(`setleft`),`auto_sponsor_text`=VALUES(`auto_sponsor_text`),`range_user_text`=VALUES(`range_user_text`),`is_sing`=VALUES(`is_sing`),`auto_person`=VALUES(`auto_person`),`wf_mode`=VALUES(`wf_mode`),`wf_action`=VALUES(`wf_action`),`updatetime`=VALUES(`updatetime`),`dateline`=VALUES(`dateline`),`work_text`=VALUES(`work_text`),`range_user_ids`=VALUES(`range_user_ids`),`style`=VALUES(`style`),`auto_role_ids`=VALUES(`auto_role_ids`),`work_sql`=VALUES(`work_sql`),`flow_id`=VALUES(`flow_id`),`process_to`=VALUES(`process_to`),`work_ids`=VALUES(`work_ids`),`out_condition`=VALUES(`out_condition`),`settop`=VALUES(`settop`),`id`=VALUES(`id`),`auto_sponsor_ids`=VALUES(`auto_sponsor_ids`),`work_msg`=VALUES(`work_msg`)
- 2020-12-07 09:46:38.886 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:38.888 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE (`flow_id`=3) AND (`is_del`=0) ORDER BY `id` asc
- 2020-12-07 09:46:38.933 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_location`,`oper_name`,`oper_url`,`json_result`,`oper_id`,`business_type`,`oper_time`,`title`,`method`,`dept_name`,`oper_param`,`status`,`error_msg`,`request_method`,`operator_type`) VALUES('192.168.0.212','','demo','/system/wf/flow/saveProcess','{"code":0,"msg":"保存成功"}',0,0,1607305598,'','/system/wf/flow/saveProcess','','{"data":[{"id":64,"left":"100","process_to":"65,66","top":"100"},{"id":65,"left":"270","process_to":"","top":"349"},{"id":66,"left":"540","process_to":"","top":"219"}]}',1,'','POST',1) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_time`=VALUES(`oper_time`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`)
- 2020-12-07 09:46:38.951 [DEBU] [ 62 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'
- 2020-12-07 09:46:39.000 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`dept_name`,`status`,`error_msg`,`business_type`,`request_method`,`operator_type`,`json_result`,`oper_time`,`oper_ip`,`oper_param`,`title`,`method`,`oper_name`,`oper_url`,`oper_location`) VALUES(0,'',1,'',0,'GET',1,'{"code":0,"msg":"ok"}',1607305598,'192.168.0.212','{"id":"3"}','','/system/wf/flow/designFlow','demo','/system/wf/flow/designFlow?id=3','') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`oper_ip`=VALUES(`oper_ip`)
- 2020-12-07 09:46:44.980 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`title`,`request_method`,`operator_type`,`oper_name`,`dept_name`,`oper_url`,`oper_location`,`status`,`oper_id`,`business_type`,`oper_ip`,`oper_param`,`json_result`,`error_msg`,`oper_time`,`method`) VALUES('','POST',1,'demo','','/system/wf/flow/saveAttr','',0,0,0,'192.168.0.212','{"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":""}','{"code":-1,"msg":"该功能仅对捐赠用户开放,捐赠299即可获得完整工作流功能及配套视频。"}','',1607305604,'/system/wf/flow/saveAttr') ON DUPLICATE KEY UPDATE `oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_ip`=VALUES(`oper_ip`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`)
- 2020-12-07 09:46:55.650 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `wf_flow` WHERE `is_del`=0
- 2020-12-07 09:46:55.651 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `is_del`=0 ORDER BY `sort_order` asc,`id` asc LIMIT 0,10
- 2020-12-07 09:46:55.654 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE flow_id in(1,2,3,5,8) and status = 0 ORDER BY `id` asc
- 2020-12-07 09:46:55.698 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`method`,`request_method`,`operator_type`,`oper_url`,`json_result`,`business_type`,`oper_ip`,`status`,`error_msg`,`oper_time`,`oper_id`,`title`,`oper_name`,`dept_name`,`oper_location`,`oper_param`) VALUES('/system/config/dict/getDicts','GET',1,'/system/config/dict/getDicts?dictType=sys_normal_disable','{"code":0,"msg":"ok"}',0,'192.168.0.212',1,'',1607305615,0,'','demo','','','{"dictType":"sys_normal_disable"}') ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`oper_ip`=VALUES(`oper_ip`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_param`=VALUES(`oper_param`)
- 2020-12-07 09:46:55.704 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`oper_url`,`json_result`,`oper_ip`,`oper_location`,`status`,`oper_time`,`dept_name`,`oper_param`,`error_msg`,`title`,`business_type`,`method`,`request_method`,`operator_type`,`oper_name`) VALUES(0,'/system/config/dict/getDicts?dictType=flow_type','{"code":0,"msg":"ok"}','192.168.0.212','',1,1607305615,'','{"dictType":"flow_type"}','','',0,'/system/config/dict/getDicts','GET',1,'demo') ON DUPLICATE KEY UPDATE `json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`)
- 2020-12-07 09:46:55.708 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`error_msg`,`method`,`oper_name`,`oper_location`,`request_method`,`oper_url`,`operator_type`,`dept_name`,`oper_ip`,`oper_param`,`status`,`oper_time`,`title`,`business_type`,`oper_id`) VALUES('{"code":0,"msg":"获取列表数据成功"}','','/system/wf/flow/list','demo','','GET','/system/wf/flow/list?pageNum=1&pageSize=10',1,'','192.168.0.212','{"pageNum":"1","pageSize":"10"}',1,1607305615,'工作流列表',0,0) ON DUPLICATE KEY UPDATE `error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 09:46:57.553 [DEBU] [ 4 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:57.557 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_flow_process` WHERE (`flow_id`=3) AND (`is_del`=0) ORDER BY `id` asc
- 2020-12-07 09:46:57.577 [DEBU] [ 17 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'
- 2020-12-07 09:46:57.684 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`business_type`,`operator_type`,`oper_ip`,`oper_param`,`oper_time`,`method`,`oper_name`,`oper_url`,`oper_id`,`request_method`,`json_result`,`error_msg`,`dept_name`,`oper_location`,`status`) VALUES('',0,1,'192.168.0.212','{"id":"3"}',1607305617,'/system/wf/flow/designFlow','demo','/system/wf/flow/designFlow?id=3',0,'GET','{"code":0,"msg":"ok"}','','','',1) ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`dept_name`=VALUES(`dept_name`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`method`=VALUES(`method`)
- 2020-12-07 09:46:58.932 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2020-12-07 09:46:58.933 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2020-12-07 09:46:58.935 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE `is_del`=0 AND `status`=0 AND `from_id`=1 AND `from_table`='wf_news' ORDER BY `id` desc LIMIT 1
- 2020-12-07 09:46:58.937 [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)
- 2020-12-07 09:46:58.938 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:46:58.939 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:46:58.941 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:46:58.947 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:46:58.949 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 09:46:58.951 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 09:46:58.954 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 09:46:58.956 [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
- 2020-12-07 09:46:58.957 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:46:58.959 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:46:58.960 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:46:58.963 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 09:46:58.964 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:46:58.966 [DEBU] [ 1 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
- 2020-12-07 09:46:58.967 [DEBU] [ 1 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)
- 2020-12-07 09:46:58.968 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:46:58.971 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:46:58.972 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:46:58.973 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 09:46:58.974 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:46:58.976 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 09:46:58.977 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 09:46:58.979 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:46:58.999 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`dept_name`,`oper_url`,`oper_ip`,`error_msg`,`method`,`json_result`,`oper_location`,`oper_time`,`title`,`business_type`,`request_method`,`operator_type`,`oper_name`,`oper_param`,`status`) VALUES(0,'','/system/config/dict/getDicts?dictType=flow_level','192.168.0.212','','/system/config/dict/getDicts','{"code":0,"msg":"ok"}','',1607305618,'',0,'GET',1,'demo','{"dictType":"flow_level"}',1) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`json_result`=VALUES(`json_result`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`)
- 2020-12-07 09:46:59.004 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`oper_id`,`business_type`,`oper_url`,`error_msg`,`oper_time`,`operator_type`,`oper_name`,`oper_param`,`status`,`title`,`request_method`,`oper_location`,`method`,`dept_name`,`oper_ip`) VALUES('{"code":0,"msg":"ok"}',0,0,'/system/config/dict/getDicts?dictType=flow_status','',1607305619,1,'demo','{"dictType":"flow_status"}',1,'','GET','','/system/config/dict/getDicts','','192.168.0.212') ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`)
- 2020-12-07 09:46:59.040 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`dept_name`,`oper_url`,`oper_ip`,`oper_location`,`error_msg`,`request_method`,`oper_name`,`status`,`oper_time`,`oper_id`,`title`,`business_type`,`method`,`oper_param`,`json_result`) VALUES(1,'','/system/wf/news/list?pageNum=1&pageSize=10','192.168.0.212','','','GET','demo',1,1607305619,0,'',0,'/system/wf/news/list','{"pageNum":"1","pageSize":"10"}','{"code":0,"msg":"获取列表数据成功"}') ON DUPLICATE KEY UPDATE `dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`)
- 2020-12-07 09:47:04.231 [DEBU] [ 1 ms] [default] DELETE FROM `user_online` WHERE `token`='fCLUxFpxP3QqVAezWSiqJ7D3QYZ7jkylPshqw8BVzfJJfAHAbwsSFhjrTyqHZEnzZwFT0YRIfumQTxnJAjCUHKpnrXWMqRHjXbV4yPu0tn7dHESK+gRr5ODilRyUkc5h'
- 2020-12-07 09:47:10.905 [DEBU] [ 3 ms] [default] SELECT * FROM `user` WHERE user_name='yixiaohu' and user_password='9OFlt5qzzvCiZWhe7ilcLA==' LIMIT 1
- 2020-12-07 09:47:10.944 [DEBU] [ 37 ms] [default] INSERT INTO `user`(`user_name`,`user_nickname`,`user_password`,`user_email`,`dept_id`,`is_admin`,`id`,`birthday`,`create_time`,`sex`,`avatar`,`remark`,`mobile`,`user_status`,`last_login_time`,`last_login_ip`) VALUES('yixiaohu','奈斯','9OFlt5qzzvCiZWhe7ilcLA==','yxh@qq.com',102,1,2,0,0,1,'','备注','13699885599',1,1607305630,'192.168.0.212') ON DUPLICATE KEY UPDATE `user_name`=VALUES(`user_name`),`user_nickname`=VALUES(`user_nickname`),`user_password`=VALUES(`user_password`),`user_email`=VALUES(`user_email`),`dept_id`=VALUES(`dept_id`),`is_admin`=VALUES(`is_admin`),`id`=VALUES(`id`),`birthday`=VALUES(`birthday`),`create_time`=VALUES(`create_time`),`sex`=VALUES(`sex`),`avatar`=VALUES(`avatar`),`remark`=VALUES(`remark`),`mobile`=VALUES(`mobile`),`user_status`=VALUES(`user_status`),`last_login_time`=VALUES(`last_login_time`),`last_login_ip`=VALUES(`last_login_ip`)
- 2020-12-07 09:47:10.947 [DEBU] [ 1 ms] [default] INSERT INTO `user_online`(`token`,`create_time`,`user_name`,`ip`,`explorer`,`os`,`id`,`uuid`) VALUES('4AhyM5BOoJoI7BYH7RGFACpligxkD4xPNypAoXU+QRTR3qKGhlTBUmi93rci7oyksR6guzYa+mvzsz39ycJUNULtPwBXaso2bAXAU9yyUAor5vlG6LJ2Z4iKeM4agXZUhSyhCcbwACUzCc/WWQDaQw==',1607305630,'yixiaohu','192.168.0.212','Chrome','Windows 10',0,'12af7ee6b9c1067f139ae59d8ef55741') ON DUPLICATE KEY UPDATE `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`),`ip`=VALUES(`ip`)
- 2020-12-07 09:47:10.962 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:11.010 [DEBU] [ 1 ms] [default] INSERT INTO `sys_login_log`(`login_name`,`ipaddr`,`os`,`status`,`msg`,`info_id`,`browser`,`login_time`,`module`,`login_location`) VALUES('yixiaohu','192.168.0.212','Windows 10',1,'登录成功',0,'Chrome',1607305631,'系统后台','') ON DUPLICATE KEY UPDATE `os`=VALUES(`os`),`status`=VALUES(`status`),`msg`=VALUES(`msg`),`info_id`=VALUES(`info_id`),`login_name`=VALUES(`login_name`),`ipaddr`=VALUES(`ipaddr`),`module`=VALUES(`module`),`login_location`=VALUES(`login_location`),`browser`=VALUES(`browser`),`login_time`=VALUES(`login_time`)
- 2020-12-07 09:47:11.032 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`oper_ip`,`oper_location`,`json_result`,`error_msg`,`method`,`operator_type`,`oper_id`,`request_method`,`oper_url`,`oper_param`,`status`,`oper_time`,`title`,`dept_name`,`business_type`) VALUES('yixiaohu','192.168.0.212','','{"code":0,"msg":"ok"}','','/system/index/getInfo',1,0,'GET','/system/index/getInfo','{}',1,1607305631,'','',0) ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`)
- 2020-12-07 09:47:11.039 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`oper_url`,`oper_location`,`oper_param`,`status`,`oper_time`,`title`,`oper_name`,`oper_ip`,`json_result`,`business_type`,`method`,`request_method`,`operator_type`,`dept_name`,`error_msg`) VALUES(0,'/system/index/getRouters','','{}',1,1607305631,'','yixiaohu','192.168.0.212','{"code":0,"msg":"ok"}',0,'/system/index/getRouters','GET',1,'','') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 09:47:11.374 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2020-12-07 09:47:11.375 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2020-12-07 09:47:11.379 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE `from_table`='wf_news' AND `is_del`=0 AND `status`=0 AND `from_id`=1 ORDER BY `id` desc LIMIT 1
- 2020-12-07 09:47:11.381 [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)
- 2020-12-07 09:47:11.387 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:11.389 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:11.390 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:11.391 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:47:11.393 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 09:47:11.394 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 09:47:11.396 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 09:47:11.398 [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
- 2020-12-07 09:47:11.399 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:11.401 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:11.402 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:47:11.405 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 09:47:11.406 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:11.407 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE `from_table`='wf_news' AND `is_del`=0 AND `status`=0 AND `from_id`=3 ORDER BY `id` desc LIMIT 1
- 2020-12-07 09:47:11.408 [DEBU] [ 1 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)
- 2020-12-07 09:47:11.409 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:47:11.410 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:11.410 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:11.411 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 09:47:11.412 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:47:11.413 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 09:47:11.414 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 09:47:11.416 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:47:11.441 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`title`,`request_method`,`status`,`oper_id`,`oper_name`,`oper_url`,`oper_ip`,`oper_param`,`error_msg`,`oper_time`,`business_type`,`operator_type`,`dept_name`,`method`,`json_result`,`oper_location`) VALUES('','GET',1,0,'yixiaohu','/system/config/dict/getDicts?dictType=flow_status','192.168.0.212','{"dictType":"flow_status"}','',1607305631,0,1,'','/system/config/dict/getDicts','{"code":0,"msg":"ok"}','') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`status`=VALUES(`status`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`)
- 2020-12-07 09:47:11.443 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`status`,`title`,`operator_type`,`oper_location`,`business_type`,`method`,`oper_param`,`oper_ip`,`error_msg`,`oper_time`,`oper_id`,`request_method`,`oper_url`,`oper_name`,`dept_name`) VALUES('{"code":0,"msg":"ok"}',1,'',1,'',0,'/system/config/dict/getDicts','{"dictType":"flow_level"}','192.168.0.212','',1607305631,0,'GET','/system/config/dict/getDicts?dictType=flow_level','yixiaohu','') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`)
- 2020-12-07 09:47:11.473 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_url`,`oper_ip`,`oper_location`,`oper_param`,`oper_id`,`status`,`oper_time`,`title`,`business_type`,`method`,`request_method`,`oper_name`,`dept_name`,`json_result`,`error_msg`) VALUES(1,'/system/wf/news/list?pageNum=1&pageSize=10','192.168.0.212','','{"pageNum":"1","pageSize":"10"}',0,1,1607305631,'',0,'/system/wf/news/list','GET','yixiaohu','','{"code":0,"msg":"获取列表数据成功"}','') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`operator_type`=VALUES(`operator_type`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 09:47:13.461 [DEBU] [ 1 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
- 2020-12-07 09:47:13.462 [DEBU] [ 0 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)
- 2020-12-07 09:47:13.463 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:13.464 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:13.465 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:13.466 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:47:13.468 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 09:47:13.469 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 09:47:13.470 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 09:47:13.471 [DEBU] [ 0 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
- 2020-12-07 09:47:13.472 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:13.473 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:13.475 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:47:13.477 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 09:47:13.509 [DEBU] [ 31 ms] [default] SHOW FULL COLUMNS FROM `wf_run_log`
- 2020-12-07 09:47:13.510 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_log` WHERE `from_id`=1 AND `from_table`='wf_news'
- 2020-12-07 09:47:13.512 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:47:13.512 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:13.513 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:13.514 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:13.515 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:13.516 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:13.517 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:13.518 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:47:13.575 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`error_msg`,`oper_time`,`oper_id`,`method`,`oper_location`,`oper_param`,`status`,`dept_name`,`oper_ip`,`oper_name`,`oper_url`,`json_result`,`title`,`request_method`,`business_type`,`operator_type`) VALUES('',1607305633,0,'/system/wf/flow/wfCheck','','{"wf_fid":"1","wf_status_field":"status","wf_title":"2","wf_type":"wf_news"}',1,'','192.168.0.212','yixiaohu','/system/wf/flow/wfCheck?wf_type=wf_news&wf_title=2&wf_status_field=status&wf_fid=1','{"code":0,"msg":"ok"}','','GET',0,1) ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`error_msg`=VALUES(`error_msg`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`)
- 2020-12-07 09:47:18.176 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (`run_id`=85) AND (run_flow_process in ('7') OR FIND_IN_SET(run_flow_process,'7')) LIMIT 1
- 2020-12-07 09:47:18.234 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`oper_param`,`oper_time`,`business_type`,`method`,`dept_name`,`oper_url`,`oper_ip`,`status`,`error_msg`,`title`,`oper_location`,`json_result`,`oper_id`,`request_method`,`operator_type`) VALUES('yixiaohu','{"backId":"7","runId":"85"}',1607305638,0,'/system/wf/flow/getBackTodo','','/system/wf/flow/getBackTodo?backId=7&runId=85','192.168.0.212',1,'','','','{"code":0,"msg":"ok"}',0,'GET',1) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`title`=VALUES(`title`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`)
- 2020-12-07 09:47:19.616 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`json_result`,`title`,`method`,`request_method`,`oper_name`,`dept_name`,`error_msg`,`business_type`,`operator_type`,`oper_url`,`oper_ip`,`oper_location`,`oper_time`,`oper_param`,`status`) VALUES(0,'{"code":-1,"msg":"该功能仅对捐赠用户开放,捐赠299即可获得完整工作流功能及配套视频。"}','','/system/wf/flow/checkSave','POST','yixiaohu','','',0,1,'/system/wf/flow/checkSave','192.168.0.212','',1607305639,'{"bTodo":"","btodo":"","flowId":2,"flowProcess":52,"npid":"9,8","runId":85,"runProcess":359,"singSt":1,"submitToSave":"sback","sup":"0","todo":"","wfBackFlow":"7","wfFid":1,"wfMode":0,"wfStatusField":"status","wfTitle":"2","wfType":"wf_news"}',0) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`)
- 2020-12-07 09:47:25.083 [DEBU] [ 1 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
- 2020-12-07 09:47:25.084 [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)
- 2020-12-07 09:47:25.085 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:25.086 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:25.087 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:25.088 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:47:25.090 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 09:47:25.091 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 09:47:25.092 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 09:47:25.093 [DEBU] [ 0 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
- 2020-12-07 09:47:25.094 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:25.095 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:47:25.097 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:47:25.098 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 09:47:25.099 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_log` WHERE `from_id`=1 AND `from_table`='wf_news'
- 2020-12-07 09:47:25.100 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:47:25.101 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:25.102 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:25.103 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:25.104 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:25.105 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:25.105 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:47:25.106 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:47:25.161 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`business_type`,`oper_location`,`oper_param`,`operator_type`,`dept_name`,`oper_url`,`error_msg`,`oper_time`,`title`,`request_method`,`oper_name`,`oper_ip`,`method`,`json_result`,`status`) VALUES(0,0,'','{"wf_fid":"1","wf_status_field":"status","wf_title":"2","wf_type":"wf_news"}',1,'','/system/wf/flow/wfCheck?wf_type=wf_news&wf_title=2&wf_status_field=status&wf_fid=1','',1607305645,'','GET','yixiaohu','192.168.0.212','/system/wf/flow/wfCheck','{"code":0,"msg":"ok"}',1) ON DUPLICATE KEY UPDATE `oper_ip`=VALUES(`oper_ip`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`method`=VALUES(`method`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`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`)
- 2020-12-07 09:47:31.615 [DEBU] [ 3 ms] [default] SELECT COUNT(1) FROM `user` WHERE user_name like '%张%' or user_nickname like '%张%'
- 2020-12-07 09:47:31.616 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE user_name like '%张%' or user_nickname like '%张%' ORDER BY `id` asc LIMIT 0,50
- 2020-12-07 09:47:31.725 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`operator_type`,`oper_ip`,`title`,`request_method`,`json_result`,`status`,`oper_time`,`method`,`oper_name`,`oper_location`,`oper_param`,`error_msg`,`oper_id`,`dept_name`,`oper_url`) VALUES(0,1,'192.168.0.212','','POST','{"code":0,"msg":"ok"}',1,1607305651,'/system/wf/flow/getManager','yixiaohu','','{"key":"张","type":"getUser"}','',0,'','/system/wf/flow/getManager') ON DUPLICATE KEY UPDATE `json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`)
- 2020-12-07 09:47:33.894 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`oper_name`,`oper_param`,`error_msg`,`oper_location`,`json_result`,`status`,`oper_time`,`oper_id`,`business_type`,`request_method`,`oper_url`,`method`,`operator_type`,`dept_name`,`oper_ip`) VALUES('','yixiaohu','{"btodo":"","flowId":2,"flowProcess":52,"npid":"9,8","runId":85,"runProcess":359,"singSt":1,"submitToSave":"ssing","sup":"0","todo":"","wfFid":1,"wfMode":0,"wfSingFlow":3,"wfStatusField":"status","wfTitle":"2","wfType":"wf_news"}','','','{"code":-1,"msg":"该功能仅对捐赠用户开放,捐赠299即可获得完整工作流功能及配套视频。"}',0,1607305653,0,0,'POST','/system/wf/flow/checkSave','/system/wf/flow/checkSave',1,'','192.168.0.212') ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`)
- 2020-12-07 09:47:43.983 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_flow` WHERE `is_del`=0
- 2020-12-07 09:47:43.984 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `is_del`=0 ORDER BY `sort_order` asc,`id` asc LIMIT 0,10
- 2020-12-07 09:47:43.991 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE flow_id in(1,2,3,5,8) and status = 0 ORDER BY `id` asc
- 2020-12-07 09:47:44.040 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`json_result`,`status`,`oper_time`,`title`,`method`,`dept_name`,`oper_param`,`oper_id`,`oper_name`,`operator_type`,`oper_location`,`oper_ip`,`error_msg`,`business_type`,`oper_url`) VALUES('GET','{"code":0,"msg":"ok"}',1,1607305664,'','/system/config/dict/getDicts','','{"dictType":"sys_normal_disable"}',0,'yixiaohu',1,'','192.168.0.212','',0,'/system/config/dict/getDicts?dictType=sys_normal_disable') ON DUPLICATE KEY UPDATE `dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`oper_name`=VALUES(`oper_name`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`title`=VALUES(`title`),`method`=VALUES(`method`)
- 2020-12-07 09:47:44.041 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`title`,`dept_name`,`oper_ip`,`status`,`oper_id`,`business_type`,`operator_type`,`error_msg`,`method`,`oper_url`,`oper_time`,`request_method`,`oper_name`,`oper_location`,`oper_param`,`json_result`) VALUES('','','192.168.0.212',1,0,0,1,'','/system/config/dict/getDicts','/system/config/dict/getDicts?dictType=flow_type',1607305664,'GET','yixiaohu','','{"dictType":"flow_type"}','{"code":0,"msg":"ok"}') ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`error_msg`=VALUES(`error_msg`)
- 2020-12-07 09:47:44.056 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`business_type`,`method`,`oper_location`,`oper_url`,`json_result`,`status`,`title`,`operator_type`,`oper_name`,`oper_ip`,`error_msg`,`request_method`,`dept_name`,`oper_param`,`oper_time`) VALUES(0,0,'/system/wf/flow/list','','/system/wf/flow/list?pageNum=1&pageSize=10','{"code":0,"msg":"获取列表数据成功"}',1,'工作流列表',1,'yixiaohu','192.168.0.212','','GET','','{"pageNum":"1","pageSize":"10"}',1607305664) ON DUPLICATE KEY UPDATE `json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_url`=VALUES(`oper_url`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 09:47:45.954 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:47:45.957 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE (`flow_id`=3) AND (`is_del`=0) ORDER BY `id` asc
- 2020-12-07 09:47:45.975 [DEBU] [ 14 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'
- 2020-12-07 09:47:46.031 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`oper_url`,`status`,`business_type`,`dept_name`,`oper_ip`,`oper_location`,`oper_param`,`json_result`,`oper_id`,`title`,`error_msg`,`operator_type`,`oper_time`,`method`,`request_method`) VALUES('yixiaohu','/system/wf/flow/designFlow?id=3',1,0,'','192.168.0.212','','{"id":"3"}','{"code":0,"msg":"ok"}',0,'','',1,1607305666,'/system/wf/flow/designFlow','GET') ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`error_msg`=VALUES(`error_msg`),`operator_type`=VALUES(`operator_type`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`)
- 2020-12-07 09:48:32.358 [DEBU] [ 4 ms] [default] SELECT COUNT(1) FROM `wf_flow` WHERE `is_del`=0
- 2020-12-07 09:48:32.359 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `is_del`=0 ORDER BY `sort_order` asc,`id` asc LIMIT 0,10
- 2020-12-07 09:48:32.361 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE flow_id in(1,2,3,5,8) and status = 0 ORDER BY `id` asc
- 2020-12-07 09:48:32.563 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_id`,`title`,`operator_type`,`oper_url`,`json_result`,`error_msg`,`business_type`,`oper_location`,`oper_param`,`oper_time`,`method`,`request_method`,`oper_name`,`oper_ip`,`status`) VALUES('',0,'',1,'/system/config/dict/getDicts?dictType=sys_normal_disable','{"code":0,"msg":"ok"}','',0,'','{"dictType":"sys_normal_disable"}',1607305712,'/system/config/dict/getDicts','GET','yixiaohu','192.168.0.212',1) ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`dept_name`=VALUES(`dept_name`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`)
- 2020-12-07 09:48:32.624 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`error_msg`,`oper_time`,`operator_type`,`title`,`business_type`,`method`,`request_method`,`oper_url`,`oper_ip`,`oper_location`,`oper_id`,`json_result`,`oper_param`,`status`,`dept_name`) VALUES('yixiaohu','',1607305712,1,'工作流列表',0,'/system/wf/flow/list','GET','/system/wf/flow/list?pageNum=1&pageSize=10','192.168.0.212','',0,'{"code":0,"msg":"获取列表数据成功"}','{"pageNum":"1","pageSize":"10"}',1,'') ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`dept_name`=VALUES(`dept_name`),`status`=VALUES(`status`),`oper_name`=VALUES(`oper_name`)
- 2020-12-07 09:48:32.696 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`method`,`request_method`,`operator_type`,`oper_name`,`oper_id`,`error_msg`,`oper_time`,`business_type`,`oper_url`,`oper_location`,`json_result`,`dept_name`,`oper_ip`,`oper_param`,`status`,`title`) VALUES('/system/config/dict/getDicts','GET',1,'yixiaohu',0,'',1607305712,0,'/system/config/dict/getDicts?dictType=flow_type','','{"code":0,"msg":"ok"}','','192.168.0.212','{"dictType":"flow_type"}',1,'') ON DUPLICATE KEY UPDATE `business_type`=VALUES(`business_type`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`json_result`=VALUES(`json_result`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`title`=VALUES(`title`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`)
- 2020-12-07 09:48:36.253 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2020-12-07 09:48:36.253 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2020-12-07 09:48:36.259 [DEBU] [ 5 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
- 2020-12-07 09:48:36.261 [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)
- 2020-12-07 09:48:36.264 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:48:36.265 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:48:36.267 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:48:36.271 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:48:36.273 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 09:48:36.274 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 09:48:36.277 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 09:48:36.282 [DEBU] [ 4 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
- 2020-12-07 09:48:36.283 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:48:36.285 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 09:48:36.286 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 09:48:36.288 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 09:48:36.290 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:48:36.291 [DEBU] [ 1 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
- 2020-12-07 09:48:36.293 [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)
- 2020-12-07 09:48:36.294 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:48:36.295 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:48:36.296 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:48:36.297 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 09:48:36.298 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:48:36.300 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 09:48:36.301 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 09:48:36.302 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:48:36.413 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`title`,`oper_url`,`status`,`error_msg`,`dept_name`,`oper_ip`,`oper_location`,`json_result`,`business_type`,`method`,`oper_param`,`request_method`,`operator_type`,`oper_name`,`oper_time`) VALUES(0,'','/system/config/dict/getDicts?dictType=flow_status',1,'','','192.168.0.212','','{"code":0,"msg":"ok"}',0,'/system/config/dict/getDicts','{"dictType":"flow_status"}','GET',1,'yixiaohu',1607305716) ON DUPLICATE KEY UPDATE `dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`)
- 2020-12-07 09:48:36.482 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`oper_location`,`oper_time`,`dept_name`,`json_result`,`oper_id`,`title`,`business_type`,`method`,`oper_ip`,`status`,`operator_type`,`oper_name`,`oper_url`,`oper_param`,`error_msg`) VALUES('GET','',1607305716,'','{"code":0,"msg":"ok"}',0,'',0,'/system/config/dict/getDicts','192.168.0.212',1,1,'yixiaohu','/system/config/dict/getDicts?dictType=flow_level','{"dictType":"flow_level"}','') ON DUPLICATE KEY UPDATE `dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`request_method`=VALUES(`request_method`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 09:48:36.540 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`request_method`,`operator_type`,`oper_ip`,`oper_location`,`oper_time`,`method`,`dept_name`,`oper_url`,`json_result`,`status`,`title`,`business_type`,`oper_name`,`error_msg`,`oper_param`) VALUES(0,'GET',1,'192.168.0.212','',1607305716,'/system/wf/news/list','','/system/wf/news/list?pageNum=1&pageSize=10','{"code":0,"msg":"获取列表数据成功"}',1,'',0,'yixiaohu','','{"pageNum":"1","pageSize":"10"}') ON DUPLICATE KEY UPDATE `oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`error_msg`=VALUES(`error_msg`),`oper_param`=VALUES(`oper_param`)
- 2020-12-07 09:48:44.833 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run` WHERE `status`=0 AND `from_id`=3 AND `from_table`='wf_news' AND `is_del`=0 ORDER BY `id` desc LIMIT 1
- 2020-12-07 09:48:44.834 [DEBU] [ 1 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)
- 2020-12-07 09:48:44.835 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:48:44.836 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:48:44.837 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:48:44.838 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 09:48:44.839 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:48:44.840 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 09:48:44.841 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 09:48:44.843 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 09:48:44.844 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_log` WHERE `from_id`=3 AND `from_table`='wf_news'
- 2020-12-07 09:48:44.844 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:48:44.845 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 09:48:44.846 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE `id`=3 LIMIT 1
- 2020-12-07 09:48:44.923 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`title`,`method`,`operator_type`,`oper_name`,`status`,`oper_id`,`request_method`,`oper_param`,`json_result`,`error_msg`,`oper_time`,`business_type`,`dept_name`,`oper_url`,`oper_ip`,`oper_location`) VALUES('','/system/wf/flow/wfCheck',1,'yixiaohu',1,0,'GET','{"wf_fid":"3","wf_status_field":"status","wf_title":"2","wf_type":"wf_news"}','{"code":0,"msg":"ok"}','',1607305724,0,'','/system/wf/flow/wfCheck?wf_type=wf_news&wf_title=2&wf_status_field=status&wf_fid=3','192.168.0.212','') ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`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`),`oper_name`=VALUES(`oper_name`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 09:49:11.016 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_run_process` WHERE (`run_id`=87) AND (run_flow_process in ('1') OR FIND_IN_SET(run_flow_process,'1')) LIMIT 1
- 2020-12-07 09:49:11.095 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`method`,`oper_param`,`dept_name`,`error_msg`,`oper_time`,`request_method`,`operator_type`,`oper_url`,`oper_ip`,`status`,`oper_id`,`title`,`oper_name`,`oper_location`,`json_result`) VALUES(0,'/system/wf/flow/getBackTodo','{"backId":"1","runId":"87"}','','',1607305751,'GET',1,'/system/wf/flow/getBackTodo?backId=1&runId=87','192.168.0.212',1,0,'','yixiaohu','','{"code":0,"msg":"ok"}') ON DUPLICATE KEY UPDATE `oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_param`=VALUES(`oper_param`),`dept_name`=VALUES(`dept_name`)
- 2020-12-07 09:49:12.265 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 09:49:12.345 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`dept_name`,`oper_id`,`business_type`,`request_method`,`oper_location`,`status`,`oper_time`,`method`,`oper_ip`,`oper_param`,`json_result`,`error_msg`,`title`,`oper_name`,`oper_url`) VALUES(1,'',0,0,'POST','',0,1607305752,'/system/wf/flow/checkSave','192.168.0.212','{"bTodo":"","btodo":"","flowId":1,"flowProcess":2,"npid":3,"runId":87,"runProcess":367,"singSt":0,"submitToSave":"back","sup":"0","todo":"","wfBackFlow":"1","wfFid":3,"wfMode":0,"wfStatusField":"status","wfTitle":"2","wfType":"wf_news"}','{"code":-1,"msg":"该功能仅对捐赠用户开放,捐赠299即可获得完整工作流功能及配套视频。"}','','','yixiaohu','/system/wf/flow/checkSave') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`method`=VALUES(`method`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 09:50:05.959 [DEBU] [ 3 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 09:50:05.961 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 10:00:05.060 [DEBU] [ 3 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 10:00:05.062 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 10:10:05.259 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 10:10:05.260 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 10:20:05.362 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 10:20:05.365 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 10:30:05.362 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 10:30:05.366 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 10:40:05.362 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 10:40:05.365 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 10:50:05.363 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 10:50:05.366 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 11:00:05.409 [DEBU] [ 3 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 11:00:05.411 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 11:10:05.411 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 11:10:05.414 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 11:20:05.562 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 11:20:05.565 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 11:22:07.583 [DEBU] [ 6 ms] [default] SELECT * FROM `user` WHERE user_name='demo' and user_password='9OFlt5qzzvCiZWhe7ilcLA==' LIMIT 1
- 2020-12-07 11:22:07.621 [DEBU] [ 33 ms] [default] INSERT INTO `user`(`birthday`,`sex`,`avatar`,`last_login_ip`,`is_admin`,`mobile`,`last_login_time`,`remark`,`user_name`,`create_time`,`user_password`,`user_status`,`user_nickname`,`user_email`,`dept_id`,`id`) VALUES(0,2,'pub_upload/2020-09-03/c5disauti1wogasemy.jpeg','192.168.0.198',1,'18699888856',1607311327,'','demo',1581314770,'9OFlt5qzzvCiZWhe7ilcLA==',1,'测试账号','223@qq.com',109,31) ON DUPLICATE KEY UPDATE `user_email`=VALUES(`user_email`),`dept_id`=VALUES(`dept_id`),`id`=VALUES(`id`),`birthday`=VALUES(`birthday`),`sex`=VALUES(`sex`),`avatar`=VALUES(`avatar`),`last_login_ip`=VALUES(`last_login_ip`),`is_admin`=VALUES(`is_admin`),`mobile`=VALUES(`mobile`),`last_login_time`=VALUES(`last_login_time`),`remark`=VALUES(`remark`),`user_name`=VALUES(`user_name`),`create_time`=VALUES(`create_time`),`user_password`=VALUES(`user_password`),`user_status`=VALUES(`user_status`),`user_nickname`=VALUES(`user_nickname`)
- 2020-12-07 11:22:07.628 [DEBU] [ 2 ms] [default] INSERT INTO `user_online`(`user_name`,`ip`,`explorer`,`os`,`id`,`uuid`,`token`,`create_time`) VALUES('demo','192.168.0.198','Chrome','Windows 10',0,'d9f1df662f078e3c11b64f0a4720928f','fCLUxFpxP3QqVAezWSiqJ6pyweOfKoQtw7i7NY1c/Q0tWMjmfwGTqj2wSH5J/1BrKn5mRA7BRYzLAmj1Pz38Xw6XGQLcabGkhioNPh09R1cJPb0U9NO6V8Dgm1V5X+LU',1607311327) ON DUPLICATE KEY UPDATE `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`),`ip`=VALUES(`ip`)
- 2020-12-07 11:22:07.647 [DEBU] [ 2 ms] [default] SELECT * FROM `user` WHERE `id`=31 LIMIT 1
- 2020-12-07 11:22:07.975 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`business_type`,`error_msg`,`oper_time`,`title`,`oper_url`,`oper_location`,`status`,`request_method`,`operator_type`,`oper_ip`,`oper_param`,`method`,`oper_name`,`dept_name`,`json_result`) VALUES(0,0,'',1607311327,'','/system/index/getInfo','',1,'GET',1,'192.168.0.198','{}','/system/index/getInfo','demo','','{"code":0,"msg":"ok"}') ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`method`=VALUES(`method`),`business_type`=VALUES(`business_type`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`)
- 2020-12-07 11:22:08.061 [DEBU] [ 1 ms] [default] INSERT INTO `sys_login_log`(`info_id`,`login_name`,`ipaddr`,`browser`,`os`,`status`,`login_time`,`module`,`login_location`,`msg`) VALUES(0,'demo','192.168.0.198','Chrome','Windows 10',1,1607311328,'系统后台','','登录成功') ON DUPLICATE KEY UPDATE `login_location`=VALUES(`login_location`),`msg`=VALUES(`msg`),`module`=VALUES(`module`),`info_id`=VALUES(`info_id`),`login_name`=VALUES(`login_name`),`ipaddr`=VALUES(`ipaddr`),`browser`=VALUES(`browser`),`os`=VALUES(`os`),`status`=VALUES(`status`),`login_time`=VALUES(`login_time`)
- 2020-12-07 11:22:08.141 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`operator_type`,`oper_name`,`oper_ip`,`oper_param`,`json_result`,`oper_location`,`error_msg`,`oper_time`,`oper_id`,`title`,`business_type`,`method`,`dept_name`,`oper_url`,`status`) VALUES('GET',1,'demo','192.168.0.198','{}','{"code":0,"msg":"ok"}','','',1607311328,0,'',0,'/system/index/getRouters','','/system/index/getRouters',1) ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 11:25:34.327 [DEBU] [ 68 ms] [default] SHOW FULL COLUMNS FROM `cms_category`
- 2020-12-07 11:25:34.332 [DEBU] [ 2 ms] [default] SELECT * FROM `cms_category` ORDER BY `list_order` ASC,`id` ASC
- 2020-12-07 11:25:34.397 [DEBU] [ 48 ms] [default] SHOW FULL COLUMNS FROM `cms_news`
- 2020-12-07 11:25:34.399 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id)
- 2020-12-07 11:25:34.400 [DEBU] [ 0 ms] [default] SELECT news.*,user.user_nickname FROM `cms_news` news LEFT JOIN `user` user ON (news.user_id=user.id) ORDER BY `published_time` desc,`news`.`id` desc LIMIT 0,10
- 2020-12-07 11:25:34.430 [DEBU] [ 22 ms] [default] SHOW FULL COLUMNS FROM `cms_category_news`
- 2020-12-07 11:25:34.433 [DEBU] [ 2 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=130
- 2020-12-07 11:25:34.434 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=129
- 2020-12-07 11:25:34.436 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=128
- 2020-12-07 11:25:34.437 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=127
- 2020-12-07 11:25:34.439 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=126
- 2020-12-07 11:25:34.440 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=125
- 2020-12-07 11:25:34.441 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=124
- 2020-12-07 11:25:34.443 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=123
- 2020-12-07 11:25:34.444 [DEBU] [ 0 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=122
- 2020-12-07 11:25:34.446 [DEBU] [ 1 ms] [default] SELECT * FROM `cms_category_news` WHERE `news_id`=121
- 2020-12-07 11:25:34.448 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_type` WHERE `status`=1 AND `dict_type`='cms_news_pub_type' LIMIT 1
- 2020-12-07 11:25:34.449 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_pub_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 11:25:34.452 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_attr' AND `status`=1 LIMIT 1
- 2020-12-07 11:25:34.454 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_attr' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 11:25:34.456 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='cms_news_type' AND `status`=1 LIMIT 1
- 2020-12-07 11:25:34.459 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='cms_news_type' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 11:25:34.540 [DEBU] [ 2 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`status`,`oper_id`,`method`,`request_method`,`title`,`oper_param`,`oper_name`,`oper_ip`,`oper_url`,`oper_location`,`error_msg`,`oper_time`,`business_type`,`operator_type`,`dept_name`) VALUES('{"code":0,"msg":"信息列表"}',1,0,'/system/cms/news/list','GET','文章管理','{"keyWords":"","pageNum":"1","pageSize":"10"}','demo','192.168.0.198','/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','','',1607311534,0,1,'') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`status`=VALUES(`status`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`oper_param`=VALUES(`oper_param`)
- 2020-12-07 11:25:52.235 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `sys_login_log`
- 2020-12-07 11:25:52.236 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_login_log` ORDER BY `info_id` DESC LIMIT 0,10
- 2020-12-07 11:25:52.238 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='admin_login_status' AND `status`=1 LIMIT 1
- 2020-12-07 11:25:52.239 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='admin_login_status' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 11:25:52.327 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`method`,`oper_location`,`oper_name`,`json_result`,`error_msg`,`oper_time`,`oper_id`,`operator_type`,`dept_name`,`oper_param`,`status`,`business_type`,`request_method`,`oper_url`,`oper_ip`) VALUES('','/system/monitor/loginlog/list','','yixiaohu','{"code":0,"msg":"登录日志列表"}','',1607311552,0,1,'','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}',1,0,'GET','/system/monitor/loginlog/list?pageNum=1&pageSize=10&beginTime=&endTime=','192.168.0.212') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_location`=VALUES(`oper_location`)
- 2020-12-07 11:30:05.007 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 11:30:05.008 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 11:40:05.010 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 11:40:05.011 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 11:50:05.210 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 11:50:05.211 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 11:50:05.213 [DEBU] [ 1 ms] [default] DELETE FROM `user_online` WHERE `id`=16374
- 2020-12-07 12:00:05.658 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 12:00:05.659 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 12:10:05.312 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 12:10:05.315 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 12:20:05.411 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 12:20:05.415 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 12:30:05.413 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 12:30:05.416 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 12:40:05.413 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 12:40:05.416 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 12:50:05.412 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 12:50:05.416 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 13:00:05.412 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 13:00:05.415 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 13:10:05.412 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 13:10:05.415 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 13:20:05.413 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 13:20:05.416 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 13:30:05.411 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 13:30:05.414 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 13:40:05.412 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 13:40:05.415 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 13:50:05.412 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 13:50:05.415 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 14:00:05.412 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 14:00:05.415 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 14:10:05.413 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 14:10:05.416 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 14:20:05.464 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 14:20:05.467 [DEBU] [ 2 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 14:30:05.513 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 14:30:05.516 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 14:40:05.514 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 14:40:05.517 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 14:50:05.007 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 14:50:05.008 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 15:00:05.258 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 15:00:05.259 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 15:10:05.708 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 15:10:05.710 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 15:16:52.101 [DEBU] [ 8 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
- 2020-12-07 15:16:52.124 [DEBU] [ 21 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
- 2020-12-07 15:16:52.126 [DEBU] [ 0 ms] [default] INSERT INTO `sys_job`(`job_name`,`job_params`,`job_group`,`cron_expression`,`concurrent`,`status`,`update_by`,`remark`,`invoke_target`,`create_by`,`create_time`,`job_id`,`misfire_policy`,`update_time`) VALUES('在线用户定时更新','','DEFAULT','5 */10 * * * *',0,0,2,'','checkUserOnline',2,1596763977,8,1,1596768044) ON DUPLICATE KEY UPDATE `job_id`=VALUES(`job_id`),`misfire_policy`=VALUES(`misfire_policy`),`update_time`=VALUES(`update_time`),`job_name`=VALUES(`job_name`),`job_params`=VALUES(`job_params`),`job_group`=VALUES(`job_group`),`cron_expression`=VALUES(`cron_expression`),`concurrent`=VALUES(`concurrent`),`status`=VALUES(`status`),`update_by`=VALUES(`update_by`),`remark`=VALUES(`remark`),`invoke_target`=VALUES(`invoke_target`),`create_by`=VALUES(`create_by`),`create_time`=VALUES(`create_time`)
- 2020-12-07 15:17:03.202 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2020-12-07 15:17:03.203 [DEBU] [ 1 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_status' AND `status`=1 LIMIT 1
- 2020-12-07 15:17:03.204 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `wf_news`
- 2020-12-07 15:17:03.204 [DEBU] [ 8 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_type`
- 2020-12-07 15:17:03.205 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2020-12-07 15:17:03.206 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2020-12-07 15:17:03.209 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `sys_dict_data`
- 2020-12-07 15:17:03.210 [DEBU] [ 5 ms] [default] SELECT * FROM `sys_dict_type` WHERE `dict_type`='flow_level' AND `status`=1 LIMIT 1
- 2020-12-07 15:17:03.211 [DEBU] [ 0 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_level' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 15:17:03.213 [DEBU] [ 2 ms] [default] SELECT * FROM `sys_dict_data` WHERE `dict_type`='flow_status' ORDER BY `dict_sort` ASC,`dict_code` ASC
- 2020-12-07 15:17:03.215 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `wf_run`
- 2020-12-07 15:17:03.217 [DEBU] [ 1 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
- 2020-12-07 15:17:03.223 [DEBU] [ 8 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2020-12-07 15:17:03.224 [DEBU] [ 8 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
- 2020-12-07 15:17:03.225 [DEBU] [ 1 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2020-12-07 15:17:03.235 [DEBU] [ 10 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
- 2020-12-07 15:17:03.235 [DEBU] [ 17 ms] [default] SHOW FULL COLUMNS FROM `wf_run_process`
- 2020-12-07 15:17:03.236 [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)
- 2020-12-07 15:17:03.245 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `wf_flow`
- 2020-12-07 15:17:03.246 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:17:03.253 [DEBU] [ 6 ms] [default] SHOW FULL COLUMNS FROM `wf_flow_process`
- 2020-12-07 15:17:03.256 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:17:03.257 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:17:03.259 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 15:17:03.260 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 15:17:03.262 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 15:17:03.263 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 15:17:03.264 [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
- 2020-12-07 15:17:03.265 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:17:03.266 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:17:03.267 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 15:17:03.273 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `wf_run_sign`
- 2020-12-07 15:17:03.274 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 15:17:03.280 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `user`
- 2020-12-07 15:17:03.281 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:17:03.282 [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
- 2020-12-07 15:17:03.283 [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)
- 2020-12-07 15:17:03.284 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:17:03.285 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:17:03.286 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:17:03.287 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 15:17:03.288 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 15:17:03.290 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 15:17:03.291 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 15:17:03.292 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:17:03.725 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
- 2020-12-07 15:17:03.727 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_name`,`dept_name`,`oper_location`,`oper_param`,`oper_id`,`title`,`business_type`,`method`,`status`,`operator_type`,`oper_url`,`request_method`,`oper_ip`,`json_result`,`error_msg`,`oper_time`) VALUES('yixiaohu','','','{"dictType":"flow_level"}',0,'',0,'/system/config/dict/getDicts',1,1,'/system/config/dict/getDicts?dictType=flow_level','GET','192.168.0.212','{"code":0,"msg":"ok"}','',1607325423) ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`)
- 2020-12-07 15:17:03.795 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`status`,`oper_param`,`oper_ip`,`request_method`,`dept_name`,`oper_location`,`json_result`,`oper_time`,`business_type`,`title`,`method`,`operator_type`,`oper_name`,`oper_url`,`error_msg`,`oper_id`) VALUES(1,'{"pageNum":"1","pageSize":"10"}','192.168.0.212','GET','','','{"code":0,"msg":"获取列表数据成功"}',1607325423,0,'','/system/wf/news/list',1,'yixiaohu','/system/wf/news/list?pageNum=1&pageSize=10','',0) ON DUPLICATE KEY UPDATE `oper_ip`=VALUES(`oper_ip`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`error_msg`=VALUES(`error_msg`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`)
- 2020-12-07 15:17:03.896 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`status`,`business_type`,`operator_type`,`oper_location`,`oper_param`,`oper_name`,`oper_ip`,`oper_time`,`method`,`json_result`,`request_method`,`dept_name`,`oper_url`,`error_msg`,`oper_id`,`title`) VALUES(1,0,1,'','{"dictType":"flow_status"}','yixiaohu','192.168.0.212',1607325423,'/system/config/dict/getDicts','{"code":0,"msg":"ok"}','GET','','/system/config/dict/getDicts?dictType=flow_status','',0,'') ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`status`=VALUES(`status`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`)
- 2020-12-07 15:17:04.566 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE (`type`='wf_news') AND (`status`=1) AND (`is_del`=0)
- 2020-12-07 15:17:04.679 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_ip`,`oper_location`,`status`,`business_type`,`request_method`,`json_result`,`oper_id`,`title`,`method`,`operator_type`,`oper_name`,`oper_url`,`oper_param`,`error_msg`,`oper_time`) VALUES('','192.168.0.212','',1,0,'GET','{"code":0,"msg":"ok"}',0,'','/system/wf/flow/wfStart',1,'yixiaohu','/system/wf/flow/wfStart?wf_type=wf_news&wf_title=title&wf_status_field=status&wf_fid=4','{"wf_fid":"4","wf_status_field":"status","wf_title":"title","wf_type":"wf_news"}','',1607325424) ON DUPLICATE KEY UPDATE `dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 15:17:10.199 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`status`,`error_msg`,`oper_name`,`oper_url`,`oper_param`,`oper_time`,`business_type`,`title`,`operator_type`,`oper_ip`,`json_result`,`oper_id`,`request_method`,`dept_name`,`oper_location`,`method`) VALUES(0,'','yixiaohu','/system/wf/flow/saveStartWf?wfType=wf_news&wfStatusField=status&wfFid=4&wfId=1&newType=0&checkCon=6666','{"checkCon":"6666","newType":"0","wfFid":"4","wfId":"1","wfStatusField":"status","wfType":"wf_news"}',1607325430,0,'',1,'192.168.0.212','{"code":-1,"msg":"标题字段名称不能为空"}',0,'POST','','','/system/wf/flow/saveStartWf') ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`oper_location`=VALUES(`oper_location`),`oper_name`=VALUES(`oper_name`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 15:18:45.339 [DEBU] [ 4 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_param`,`oper_id`,`title`,`oper_ip`,`oper_location`,`oper_time`,`business_type`,`request_method`,`oper_name`,`dept_name`,`oper_url`,`error_msg`,`method`,`json_result`,`status`) VALUES(1,'{"dictType":"flow_level"}',0,'','192.168.0.212','',1607325525,0,'GET','yixiaohu','','/system/config/dict/getDicts?dictType=flow_level','','/system/config/dict/getDicts','{"code":0,"msg":"ok"}',1) ON DUPLICATE KEY UPDATE `error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`method`=VALUES(`method`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 15:18:51.852 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:51.860 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `role`
- 2020-12-07 15:18:51.862 [DEBU] [ 2 ms] [default] SELECT * FROM `role` ORDER BY `list_order` asc,`id` asc
- 2020-12-07 15:18:51.872 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `casbin_rule`
- 2020-12-07 15:18:51.873 [DEBU] [ 0 ms] [default] SELECT * FROM `casbin_rule`
- 2020-12-07 15:18:51.939 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`dept_name`,`oper_param`,`status`,`method`,`error_msg`,`oper_ip`,`business_type`,`operator_type`,`oper_url`,`oper_time`,`title`,`request_method`,`oper_name`,`oper_location`,`json_result`,`oper_id`) VALUES('','{}',1,'/system/index/getInfo','','192.168.0.212',0,1,'/system/index/getInfo',1607325531,'','GET','yixiaohu','','{"code":0,"msg":"ok"}',0) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_ip`=VALUES(`oper_ip`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 15:18:51.947 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`operator_type`,`oper_location`,`json_result`,`status`,`oper_url`,`oper_ip`,`error_msg`,`business_type`,`method`,`oper_name`,`oper_param`,`oper_time`,`oper_id`,`title`,`request_method`,`dept_name`) VALUES(1,'','{"code":0,"msg":"ok"}',1,'/system/index/getRouters','192.168.0.212','',0,'/system/index/getRouters','yixiaohu','{}',1607325531,0,'','GET','') ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`status`=VALUES(`status`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`)
- 2020-12-07 15:18:52.510 [DEBU] [ 0 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2020-12-07 15:18:52.511 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2020-12-07 15:18:52.514 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE `from_table`='wf_news' AND `is_del`=0 AND `status`=0 AND `from_id`=1 ORDER BY `id` desc LIMIT 1
- 2020-12-07 15:18:52.516 [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)
- 2020-12-07 15:18:52.519 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:52.520 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:18:52.522 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:18:52.524 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 15:18:52.526 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 15:18:52.528 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 15:18:52.530 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 15:18:52.533 [DEBU] [ 0 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
- 2020-12-07 15:18:52.535 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:18:52.536 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:18:52.538 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 15:18:52.539 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 15:18:52.540 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:52.541 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run` WHERE `from_table`='wf_news' AND `is_del`=0 AND `status`=0 AND `from_id`=3 ORDER BY `id` desc LIMIT 1
- 2020-12-07 15:18:52.542 [DEBU] [ 1 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)
- 2020-12-07 15:18:52.543 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:18:52.544 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:52.546 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:52.547 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE (uid= '1') AND (`id`=3) LIMIT 1
- 2020-12-07 15:18:52.549 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 15:18:52.551 [DEBU] [ 2 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 15:18:52.552 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 15:18:52.555 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 15:18:52.556 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:18:52.571 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`request_method`,`oper_name`,`oper_url`,`json_result`,`title`,`method`,`status`,`business_type`,`operator_type`,`dept_name`,`oper_ip`,`oper_location`,`oper_param`,`error_msg`,`oper_time`,`oper_id`) VALUES('GET','yixiaohu','/system/config/dict/getDicts?dictType=flow_level','{"code":0,"msg":"ok"}','','/system/config/dict/getDicts',1,0,1,'','192.168.0.212','','{"dictType":"flow_level"}','',1607325532,0) ON DUPLICATE KEY UPDATE `error_msg`=VALUES(`error_msg`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`status`=VALUES(`status`)
- 2020-12-07 15:18:52.572 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_param`,`status`,`oper_time`,`oper_id`,`title`,`business_type`,`dept_name`,`oper_name`,`oper_url`,`json_result`,`method`,`operator_type`,`oper_location`,`error_msg`,`request_method`) VALUES('192.168.0.212','{"dictType":"flow_status"}',1,1607325532,0,'',0,'','yixiaohu','/system/config/dict/getDicts?dictType=flow_status','{"code":0,"msg":"ok"}','/system/config/dict/getDicts',1,'','','GET') ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`request_method`=VALUES(`request_method`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`)
- 2020-12-07 15:18:52.609 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`json_result`,`method`,`oper_ip`,`oper_location`,`oper_param`,`status`,`oper_time`,`operator_type`,`business_type`,`oper_name`,`oper_url`,`error_msg`,`oper_id`,`request_method`,`dept_name`,`title`) VALUES('{"code":0,"msg":"获取列表数据成功"}','/system/wf/news/list','192.168.0.212','','{"pageNum":"1","pageSize":"10"}',1,1607325532,1,0,'yixiaohu','/system/wf/news/list?pageNum=1&pageSize=10','',0,'GET','','') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`dept_name`=VALUES(`dept_name`),`method`=VALUES(`method`),`json_result`=VALUES(`json_result`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`error_msg`=VALUES(`error_msg`)
- 2020-12-07 15:18:54.084 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE (`type`='wf_news') AND (`status`=1) AND (`is_del`=0)
- 2020-12-07 15:18:54.140 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`status`,`oper_time`,`business_type`,`method`,`oper_name`,`oper_url`,`oper_ip`,`oper_location`,`error_msg`,`title`,`dept_name`,`json_result`,`oper_id`,`request_method`,`operator_type`) VALUES('{"wf_fid":"4","wf_status_field":"status","wf_title":"title","wf_type":"wf_news"}',1,1607325534,0,'/system/wf/flow/wfStart','yixiaohu','/system/wf/flow/wfStart?wf_type=wf_news&wf_title=title&wf_status_field=status&wf_fid=4','192.168.0.212','','','','','{"code":0,"msg":"ok"}',0,'GET',1) ON DUPLICATE KEY UPDATE `oper_url`=VALUES(`oper_url`),`oper_ip`=VALUES(`oper_ip`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`dept_name`=VALUES(`dept_name`),`json_result`=VALUES(`json_result`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`)
- 2020-12-07 15:18:59.487 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:18:59.488 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE `id`=4 LIMIT 1
- 2020-12-07 15:18:59.489 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `flow_id`=1
- 2020-12-07 15:18:59.492 [DEBU] [ 1 ms] [default] DELETE FROM `wf_run` WHERE `from_table`='wf_news' AND `from_id`=4
- 2020-12-07 15:18:59.493 [DEBU] [ 1 ms] [default] INSERT INTO `wf_run`(`dateline`,`pid`,`from_table`,`run_name`,`from_status`,`from_id`,`run_flow_id`,`run_flow_process`,`uid`,`flow_id`,`from_title`) VALUES(1607325539,0,'wf_news','4','status',4,1,'1',2,1,'title') ON DUPLICATE KEY UPDATE `pid`=VALUES(`pid`),`from_table`=VALUES(`from_table`),`run_name`=VALUES(`run_name`),`dateline`=VALUES(`dateline`),`run_flow_id`=VALUES(`run_flow_id`),`run_flow_process`=VALUES(`run_flow_process`),`uid`=VALUES(`uid`),`flow_id`=VALUES(`flow_id`),`from_title`=VALUES(`from_title`),`from_status`=VALUES(`from_status`),`from_id`=VALUES(`from_id`)
- 2020-12-07 15:18:59.494 [DEBU] [ 1 ms] [default] UPDATE `wf_run_process` SET `status`=2 WHERE `run_id`=88 AND `run_flow`=1 AND `run_flow_process`=1
- 2020-12-07 15:18:59.507 [DEBU] [ 13 ms] [default] INSERT INTO `wf_run_process`(`wf_action`,`parent_flow`,`parent_flow_process`,`auto_person`,`is_sponsor`,`uid`,`run_id`,`remark`,`sponsor_text`,`js_time`,`run_flow`,`run_flow_process`,`status`,`wf_mode`,`run_child`,`sponsor_ids`,`dateline`) VALUES('view',0,0,4,0,2,88,'','奈斯',1607325539,1,1,0,0,0,'2',1607325539) ON DUPLICATE KEY UPDATE `run_flow_process`=VALUES(`run_flow_process`),`status`=VALUES(`status`),`sponsor_text`=VALUES(`sponsor_text`),`js_time`=VALUES(`js_time`),`run_flow`=VALUES(`run_flow`),`sponsor_ids`=VALUES(`sponsor_ids`),`dateline`=VALUES(`dateline`),`wf_mode`=VALUES(`wf_mode`),`run_child`=VALUES(`run_child`),`parent_flow_process`=VALUES(`parent_flow_process`),`auto_person`=VALUES(`auto_person`),`wf_action`=VALUES(`wf_action`),`parent_flow`=VALUES(`parent_flow`),`run_id`=VALUES(`run_id`),`remark`=VALUES(`remark`),`is_sponsor`=VALUES(`is_sponsor`),`uid`=VALUES(`uid`)
- 2020-12-07 15:18:59.548 [DEBU] [ 41 ms] [default] SHOW FULL COLUMNS FROM `wf_business_checker`
- 2020-12-07 15:18:59.549 [DEBU] [ 1 ms] [default] INSERT INTO `wf_business_checker`(`user_id`,`department_id`,`from_table`,`from_id`) VALUES('2','','wf_news',4) ON DUPLICATE KEY UPDATE `from_table`=VALUES(`from_table`),`from_id`=VALUES(`from_id`),`user_id`=VALUES(`user_id`),`department_id`=VALUES(`department_id`)
- 2020-12-07 15:18:59.575 [DEBU] [ 25 ms] [default] SHOW FULL COLUMNS FROM `wf_run_cache`
- 2020-12-07 15:18:59.577 [DEBU] [ 1 ms] [default] INSERT INTO `wf_run_cache`(`flow_id`,`run_form`,`run_flow`,`run_flow_process`,`dateline`,`run_id`,`form_id`) VALUES(1,'','{"id":1,"type":"wf_news","flow_name":"请假","flow_desc":"请假任务","sort_order":0,"status":1,"is_del":0,"uid":7,"add_time":1597213002}','{"id":1,"flow_id":1,"process_name":"核查","process_type":"is_one","process_to":"2","auto_person":4,"auto_sponsor_ids":"2","auto_sponsor_text":"奈斯","work_ids":"1","work_text":"","auto_role_ids":"","auto_role_text":"","range_user_ids":"","range_user_text":"","is_sing":1,"is_back":2,"out_condition":"{}","setleft":158,"settop":34,"style":"{\"color\":\"#0e76a8\",\"height\":\"auto\",\"width\":\"120\"}","is_del":0,"updatetime":1597213640,"dateline":0,"wf_mode":0,"wf_action":"view","work_sql":"","work_msg":""}',1607325539,88,4) ON DUPLICATE KEY UPDATE `run_id`=VALUES(`run_id`),`form_id`=VALUES(`form_id`),`flow_id`=VALUES(`flow_id`),`run_form`=VALUES(`run_form`),`run_flow`=VALUES(`run_flow`),`run_flow_process`=VALUES(`run_flow_process`),`dateline`=VALUES(`dateline`)
- 2020-12-07 15:18:59.577 [DEBU] [ 0 ms] [default] UPDATE `wf_news` SET `status`=1 WHERE `id`=4
- 2020-12-07 15:18:59.582 [DEBU] [ 5 ms] [default] SHOW FULL COLUMNS FROM `wf_run_log`
- 2020-12-07 15:18:59.584 [DEBU] [ 2 ms] [default] INSERT INTO `wf_run_log`(`work_info`,`uid`,`from_id`,`from_table`,`run_flow`,`dateline`,`btn`,`art`,`run_id`,`content`) VALUES('',2,4,'wf_news',0,1607325539,'Send','',88,'6666') ON DUPLICATE KEY UPDATE `content`=VALUES(`content`),`run_id`=VALUES(`run_id`),`from_id`=VALUES(`from_id`),`from_table`=VALUES(`from_table`),`run_flow`=VALUES(`run_flow`),`dateline`=VALUES(`dateline`),`btn`=VALUES(`btn`),`art`=VALUES(`art`),`work_info`=VALUES(`work_info`),`uid`=VALUES(`uid`)
- 2020-12-07 15:18:59.725 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `wf_news`
- 2020-12-07 15:18:59.726 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` ORDER BY `id` asc LIMIT 0,10
- 2020-12-07 15:18:59.727 [DEBU] [ 0 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
- 2020-12-07 15:18:59.730 [DEBU] [ 0 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)
- 2020-12-07 15:18:59.730 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_id`,`oper_param`,`status`,`error_msg`,`method`,`oper_location`,`oper_name`,`oper_ip`,`json_result`,`request_method`,`operator_type`,`dept_name`,`oper_url`,`oper_time`,`title`,`business_type`) VALUES(0,'{"checkCon":"6666","newType":"0","wfFid":"4","wfId":"1","wfStatusField":"status","wfTitle":"title","wfType":"wf_news"}',1,'','/system/wf/flow/saveStartWf','','yixiaohu','192.168.0.212','{"code":0,"msg":"发起成功"}','POST',1,'','/system/wf/flow/saveStartWf?wfType=wf_news&wfTitle=title&wfStatusField=status&wfFid=4&wfId=1&newType=0&checkCon=6666',1607325539,'',0) ON DUPLICATE KEY UPDATE `request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`oper_param`=VALUES(`oper_param`),`method`=VALUES(`method`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`)
- 2020-12-07 15:18:59.731 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:59.732 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:18:59.734 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:18:59.735 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 15:18:59.738 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 15:18:59.739 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 15:18:59.741 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 15:18:59.743 [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
- 2020-12-07 15:18:59.744 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:18:59.746 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:18:59.747 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 15:18:59.748 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 15:18:59.749 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:59.750 [DEBU] [ 1 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
- 2020-12-07 15:18:59.751 [DEBU] [ 1 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)
- 2020-12-07 15:18:59.752 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:18:59.753 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:59.756 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:59.758 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 15:18:59.759 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 15:18:59.760 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 15:18:59.761 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 15:18:59.762 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:18:59.764 [DEBU] [ 0 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
- 2020-12-07 15:18:59.765 [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)
- 2020-12-07 15:18:59.766 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:18:59.766 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:18:59.768 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:18:59.769 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:18:59.772 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=368 LIMIT 1
- 2020-12-07 15:18:59.773 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 368) AND (`run_flow`=1) AND (`run_id`=88)
- 2020-12-07 15:18:59.828 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_time`,`oper_id`,`operator_type`,`oper_url`,`oper_location`,`status`,`business_type`,`oper_param`,`json_result`,`error_msg`,`request_method`,`oper_ip`,`title`,`method`,`oper_name`,`dept_name`) VALUES(1607325539,0,1,'/system/wf/news/list?pageNum=1&pageSize=10','',1,0,'{"pageNum":"1","pageSize":"10"}','{"code":0,"msg":"获取列表数据成功"}','','GET','192.168.0.212','','/system/wf/news/list','yixiaohu','') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`title`=VALUES(`title`),`method`=VALUES(`method`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`operator_type`=VALUES(`operator_type`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`business_type`=VALUES(`business_type`),`oper_param`=VALUES(`oper_param`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`)
- 2020-12-07 15:20:05.403 [DEBU] [ 7 ms] [default] SHOW FULL COLUMNS FROM `user_online`
- 2020-12-07 15:20:05.404 [DEBU] [ 1 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 15:20:05.404 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 15:20:06.948 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run` WHERE `status` IN (0) ORDER BY `id` asc
- 2020-12-07 15:20:06.950 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:06.952 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `run_id`=85 AND `run_flow_process`='52'
- 2020-12-07 15:20:06.955 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:06.957 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `run_id`=87 AND `run_flow_process`='2'
- 2020-12-07 15:20:06.958 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:06.960 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `run_id`=88 AND `run_flow_process`='1'
- 2020-12-07 15:20:07.493 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`oper_param`,`oper_time`,`business_type`,`method`,`operator_type`,`dept_name`,`oper_location`,`error_msg`,`oper_id`,`request_method`,`oper_name`,`oper_url`,`title`,`oper_ip`,`json_result`,`status`) VALUES('{}',1607325607,0,'/system/wf/flow/monitoring',1,'','','',0,'GET','yixiaohu','/system/wf/flow/monitoring','流程监控','192.168.0.212','{"code":0,"msg":"ok"}',1) ON DUPLICATE KEY UPDATE `error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`title`=VALUES(`title`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`oper_param`=VALUES(`oper_param`),`oper_time`=VALUES(`oper_time`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`)
- 2020-12-07 15:20:07.568 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`title`,`business_type`,`operator_type`,`oper_ip`,`oper_location`,`oper_id`,`dept_name`,`oper_param`,`error_msg`,`oper_url`,`json_result`,`status`,`method`,`request_method`,`oper_name`,`oper_time`) VALUES('',0,1,'192.168.0.212','',0,'','{"dictType":"flow_level"}','','/system/config/dict/getDicts?dictType=flow_level','{"code":0,"msg":"ok"}',1,'/system/config/dict/getDicts','GET','yixiaohu',1607325607) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),`oper_url`=VALUES(`oper_url`),`json_result`=VALUES(`json_result`),`oper_name`=VALUES(`oper_name`),`oper_time`=VALUES(`oper_time`),`method`=VALUES(`method`),`request_method`=VALUES(`request_method`),`operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`oper_location`=VALUES(`oper_location`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`oper_param`=VALUES(`oper_param`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`dept_name`=VALUES(`dept_name`)
- 2020-12-07 15:20:09.366 [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
- 2020-12-07 15:20:09.367 [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)
- 2020-12-07 15:20:09.368 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:09.369 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:09.371 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:09.372 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:09.373 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=368 LIMIT 1
- 2020-12-07 15:20:09.374 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 368) AND (`run_flow`=1) AND (`run_id`=88)
- 2020-12-07 15:20:09.375 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_log` WHERE `from_id`=4 AND `from_table`='wf_news'
- 2020-12-07 15:20:09.376 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:09.377 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE `id`=4 LIMIT 1
- 2020-12-07 15:20:09.538 [DEBU] [ 0 ms] [default] INSERT INTO `sys_oper_log`(`status`,`oper_time`,`oper_name`,`dept_name`,`oper_url`,`oper_param`,`oper_id`,`business_type`,`request_method`,`oper_ip`,`json_result`,`error_msg`,`title`,`method`,`operator_type`,`oper_location`) VALUES(1,1607325609,'yixiaohu','','/system/wf/flow/wfCheck?wf_type=wf_news&wf_title=title&wf_status_field=status&wf_fid=4','{"wf_fid":"4","wf_status_field":"status","wf_title":"title","wf_type":"wf_news"}',0,0,'GET','192.168.0.212','{"code":0,"msg":"ok"}','','','/system/wf/flow/wfCheck',1,'') ON DUPLICATE KEY UPDATE `oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_param`=VALUES(`oper_param`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 15:20:12.627 [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
- 2020-12-07 15:20:12.629 [DEBU] [ 1 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)
- 2020-12-07 15:20:12.630 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:12.631 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:12.632 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:12.633 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE (title REGEXP '审批' AND uid= '2') AND (`id`=3) LIMIT 1
- 2020-12-07 15:20:12.633 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=3 LIMIT 1
- 2020-12-07 15:20:12.635 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=367 LIMIT 1
- 2020-12-07 15:20:12.636 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 367) AND (`run_flow`=1) AND (`run_id`=87)
- 2020-12-07 15:20:12.637 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:12.638 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_log` WHERE `from_id`=3 AND `from_table`='wf_news'
- 2020-12-07 15:20:12.639 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:12.640 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:12.640 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_news` WHERE `id`=3 LIMIT 1
- 2020-12-07 15:20:12.800 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`status`,`oper_time`,`operator_type`,`business_type`,`method`,`json_result`,`error_msg`,`oper_id`,`request_method`,`oper_name`,`dept_name`,`oper_url`,`oper_location`,`oper_param`,`title`) VALUES('192.168.0.212',1,1607325612,1,0,'/system/wf/flow/wfCheck','{"code":0,"msg":"ok"}','',0,'GET','yixiaohu','','/system/wf/flow/wfCheck?wf_type=wf_news&wf_title=&wf_status_field=status&wf_fid=3','','{"wf_fid":"3","wf_status_field":"status","wf_title":"","wf_type":"wf_news"}','') ON DUPLICATE KEY UPDATE `operator_type`=VALUES(`operator_type`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`business_type`=VALUES(`business_type`),`method`=VALUES(`method`),`json_result`=VALUES(`json_result`),`error_msg`=VALUES(`error_msg`),`oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`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`)
- 2020-12-07 15:20:14.724 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run` WHERE `from_table`='wf_news' AND `is_del`=0 AND `status`=0 AND `from_id`=1 ORDER BY `id` desc LIMIT 1
- 2020-12-07 15:20:14.726 [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)
- 2020-12-07 15:20:14.727 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:14.727 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:20:14.729 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:20:14.730 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 15:20:14.731 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_process` WHERE `id`=359 LIMIT 1
- 2020-12-07 15:20:14.732 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_run_process` WHERE (id < 359) AND (`run_flow`=2) AND (`run_id`=85)
- 2020-12-07 15:20:14.733 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=7 LIMIT 1
- 2020-12-07 15:20:14.735 [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
- 2020-12-07 15:20:14.736 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:20:14.737 [DEBU] [ 0 ms] [default] SELECT * FROM `wf_flow_process` WHERE `id`=52 LIMIT 1
- 2020-12-07 15:20:14.739 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_flow_process` WHERE id in (9,8)
- 2020-12-07 15:20:14.740 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_sign` WHERE `id`=42 LIMIT 1
- 2020-12-07 15:20:14.741 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_run_log` WHERE `from_id`=1 AND `from_table`='wf_news'
- 2020-12-07 15:20:14.742 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:14.743 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:14.744 [DEBU] [ 1 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:14.744 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:14.745 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:14.746 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:14.747 [DEBU] [ 0 ms] [default] SELECT * FROM `user` WHERE `id`=2 LIMIT 1
- 2020-12-07 15:20:14.748 [DEBU] [ 1 ms] [default] SELECT * FROM `wf_news` WHERE `id`=1 LIMIT 1
- 2020-12-07 15:20:14.832 [DEBU] [ 1 ms] [default] INSERT INTO `sys_oper_log`(`oper_location`,`oper_id`,`method`,`dept_name`,`oper_url`,`oper_param`,`json_result`,`error_msg`,`title`,`business_type`,`operator_type`,`oper_name`,`request_method`,`oper_ip`,`status`,`oper_time`) VALUES('',0,'/system/wf/flow/wfCheck','','/system/wf/flow/wfCheck?wf_type=wf_news&wf_title=&wf_status_field=status&wf_fid=1','{"wf_fid":"1","wf_status_field":"status","wf_title":"","wf_type":"wf_news"}','{"code":0,"msg":"ok"}','','',0,1,'yixiaohu','GET','192.168.0.212',1,1607325614) ON DUPLICATE KEY UPDATE `oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`oper_location`=VALUES(`oper_location`),`error_msg`=VALUES(`error_msg`),`title`=VALUES(`title`),`business_type`=VALUES(`business_type`),`operator_type`=VALUES(`operator_type`),`oper_name`=VALUES(`oper_name`),`oper_param`=VALUES(`oper_param`),`json_result`=VALUES(`json_result`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`),`status`=VALUES(`status`),`oper_time`=VALUES(`oper_time`)
- 2020-12-07 15:30:05.900 [DEBU] [ 5 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 15:30:05.903 [DEBU] [ 0 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 15:40:05.047 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 15:40:05.049 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 15:50:05.098 [DEBU] [ 2 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 15:50:05.100 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
- 2020-12-07 16:00:05.099 [DEBU] [ 4 ms] [default] SELECT COUNT(1) FROM `user_online`
- 2020-12-07 16:00:05.101 [DEBU] [ 1 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
|