a.id AS "id", a.task_id AS "taskId", a.job_info AS "jobInfo", a.job_name AS "jobName", a.job_group AS "jobGroup", a.execute_type AS "executeType", a.execute_time AS "executeTime", a.success_count AS "successCount", a.success_state AS "successState", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag" SELECT FROM task_log a WHERE a.id = #{id} SELECT FROM task_log a a.del_flag = #{DEL_FLAG_NORMAL} AND a.job_name = #{jobName} AND a.job_group = #{jobGroup} AND a.execute_type = #{executeType} AND a.execute_time = #{executeTime} AND a.success_state = #{successState} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM task_log a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO task_log( id, task_id, job_info, job_name, job_group, execute_type, execute_time, success_count, success_state, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{taskId}, #{jobInfo}, #{jobName}, #{jobGroup}, #{executeType}, #{executeTime}, #{successCount}, #{successState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE task_log SET task_id = #{taskId}, job_info = #{jobInfo}, job_name = #{jobName}, job_group = #{jobGroup}, execute_type = #{executeType}, execute_time = #{executeTime}, success_count = #{successCount}, success_state = #{successState}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE task_log SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select * from task_log where job_name = #{jobName} and execute_type = '0' and del_flag = '0' order by execute_time desc limit 1 SELECT FROM task_log a a.del_flag = '0' and TO_DAYS(execute_time) = TO_DAYS(date_sub(NOW(),interval 1 day)) ORDER BY create_date desc ORDER BY create_date desc