gfast/data/log/sql/2021-04-02.log

2021-04-02 10:08:15.164 [DEBU] [ 67 ms] [default] SHOW FULL COLUMNS FROM `sys_job`
2021-04-02 10:08:15.167 [DEBU] [  0 ms] [default] SELECT * FROM `sys_job` WHERE `status`=0
2021-04-02 10:08:15.169 [DEBU] [  0 ms] [default] INSERT INTO `sys_job`(`update_by`,`update_time`,`remark`,`cron_expression`,`misfire_policy`,`status`,`create_time`,`job_id`,`job_name`,`invoke_target`,`job_group`,`concurrent`,`job_params`,`create_by`) VALUES(2,1596768044,'','5 */10 * * * *',1,0,1596763977,8,'在线用户定时更新','checkUserOnline','DEFAULT',0,'',2) ON DUPLICATE KEY UPDATE `job_params`=VALUES(`job_params`),`create_by`=VALUES(`create_by`),`update_time`=VALUES(`update_time`),`remark`=VALUES(`remark`),`cron_expression`=VALUES(`cron_expression`),`misfire_policy`=VALUES(`misfire_policy`),`status`=VALUES(`status`),`update_by`=VALUES(`update_by`),`job_id`=VALUES(`job_id`),`job_name`=VALUES(`job_name`),`invoke_target`=VALUES(`invoke_target`),`create_time`=VALUES(`create_time`),`job_group`=VALUES(`job_group`),`concurrent`=VALUES(`concurrent`)
2021-04-02 10:08:27.719 [DEBU] [ 57 ms] [default] SHOW FULL COLUMNS FROM `gen_table`
2021-04-02 10:08:27.720 [DEBU] [  1 ms] [default] SELECT COUNT(1) FROM `gen_table`
2021-04-02 10:08:27.720 [DEBU] [  0 ms] [default] SELECT * FROM `gen_table` ORDER BY `table_id` asc LIMIT 0,10
2021-04-02 10:08:27.752 [DEBU] [ 29 ms] [default] SHOW FULL COLUMNS FROM `auth_rule`
2021-04-02 10:08:27.767 [DEBU] [ 14 ms] [default] SELECT * FROM `auth_rule` ORDER BY `weigh` desc,`id` asc
2021-04-02 10:08:27.817 [DEBU] [ 36 ms] [default] SHOW FULL COLUMNS FROM `sys_oper_log`
2021-04-02 10:08:27.837 [DEBU] [ 19 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`dept_name`,`oper_time`,`oper_ip`,`json_result`,`status`,`oper_location`,`error_msg`,`oper_id`,`method`,`operator_type`,`oper_url`,`oper_param`,`title`,`request_method`,`oper_name`) VALUES(0,'',1617329307,'127.0.0.1','{"code":0,"msg":"ok"}',1,'内网IP','',0,'/system/tools/gen/tableList',1,'/system/tools/gen/tableList?pageNum=1&pageSize=10&beginTime=&endTime=','{"beginTime":"","endTime":"","pageNum":"1","pageSize":"10"}','','GET','demo') ON DUPLICATE KEY UPDATE `oper_param`=VALUES(`oper_param`),`title`=VALUES(`title`),`request_method`=VALUES(`request_method`),`oper_name`=VALUES(`oper_name`),`oper_url`=VALUES(`oper_url`),`business_type`=VALUES(`business_type`),`dept_name`=VALUES(`dept_name`),`oper_time`=VALUES(`oper_time`),`oper_ip`=VALUES(`oper_ip`),`json_result`=VALUES(`json_result`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`),`method`=VALUES(`method`),`operator_type`=VALUES(`operator_type`),`oper_location`=VALUES(`oper_location`)
2021-04-02 10:08:29.606 [DEBU] [  0 ms] [default] SELECT * FROM `gen_table` WHERE `table_id`=40 LIMIT 1
2021-04-02 10:08:29.617 [DEBU] [ 10 ms] [default] SHOW FULL COLUMNS FROM `gen_table_column`
2021-04-02 10:08:29.619 [DEBU] [  0 ms] [default] SELECT * FROM `gen_table_column` WHERE `table_id`=40 ORDER BY `sort` asc,`column_id` asc
2021-04-02 10:08:29.799 [DEBU] [  1 ms] [default] INSERT INTO `sys_oper_log`(`business_type`,`oper_param`,`status`,`error_msg`,`method`,`oper_name`,`oper_location`,`json_result`,`oper_time`,`oper_id`,`request_method`,`oper_ip`,`title`,`operator_type`,`dept_name`,`oper_url`) VALUES(0,'{"tableId":"40"}',1,'','/system/tools/gen/preview','demo','内网IP','{"code":0,"msg":"ok"}',1617329309,0,'GET','127.0.0.1','',1,'','/system/tools/gen/preview?tableId=40') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`operator_type`=VALUES(`operator_type`),`dept_name`=VALUES(`dept_name`),`oper_url`=VALUES(`oper_url`),`business_type`=VALUES(`business_type`),`oper_param`=VALUES(`oper_param`),`status`=VALUES(`status`),`error_msg`=VALUES(`error_msg`),`method`=VALUES(`method`),`oper_name`=VALUES(`oper_name`),`oper_location`=VALUES(`oper_location`),`json_result`=VALUES(`json_result`),`oper_time`=VALUES(`oper_time`),`oper_id`=VALUES(`oper_id`),`request_method`=VALUES(`request_method`),`oper_ip`=VALUES(`oper_ip`)
2021-04-02 10:09:15.076 [DEBU] [  2 ms] [default] SELECT * FROM `gen_table` WHERE `table_id`=40 LIMIT 1
2021-04-02 10:09:15.079 [DEBU] [  1 ms] [default] SELECT * FROM `gen_table_column` WHERE `table_id`=40 ORDER BY `sort` asc,`column_id` asc
2021-04-02 10:09:15.282 [DEBU] [  2 ms] [default] INSERT INTO `sys_oper_log`(`oper_ip`,`oper_param`,`oper_name`,`dept_name`,`error_msg`,`oper_id`,`title`,`request_method`,`operator_type`,`oper_url`,`oper_location`,`json_result`,`status`,`business_type`,`method`,`oper_time`) VALUES('127.0.0.1','{"tables":"40"}','demo','','',0,'','GET',1,'/system/tools/gen/batchGenCode?tables=40','内网IP','',0,0,'/system/tools/gen/batchGenCode',1617329355) ON DUPLICATE KEY UPDATE `method`=VALUES(`method`),`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`),`status`=VALUES(`status`),`business_type`=VALUES(`business_type`),`oper_time`=VALUES(`oper_time`),`oper_param`=VALUES(`oper_param`),`oper_ip`=VALUES(`oper_ip`),`title`=VALUES(`title`),`oper_name`=VALUES(`oper_name`),`dept_name`=VALUES(`dept_name`),`error_msg`=VALUES(`error_msg`),`oper_id`=VALUES(`oper_id`)
2021-04-02 10:10:05.639 [DEBU] [ 56 ms] [default] SHOW FULL COLUMNS FROM `user_online`
2021-04-02 10:10:05.642 [DEBU] [  1 ms] [default] SELECT COUNT(1) FROM `user_online`
2021-04-02 10:10:05.644 [DEBU] [  2 ms] [default] SELECT * FROM `user_online` ORDER BY `create_time` DESC LIMIT 0,50
2021-04-02 10:10:05.652 [DEBU] [  3 ms] [default] DELETE FROM `user_online` WHERE `id`=16380