SELECT a.*, u.id AS "createBy.id", u.name AS "createBy.name", c.name AS "createBy.company.name", o.name AS "createBy.office.name" FROM jeesite_sys_log a JOIN jeesite_sys_user u ON u.id = a.create_by JOIN jeesite_sys_office c ON c.id = u.company_id JOIN jeesite_sys_office o ON o.id = u.office_id WHERE a.create_date BETWEEN #{beginDate} AND #{endDate} AND a.title LIKE '%'||#{title}||'%' '%'+#{title}+'%' CONCAT('%', #{title}, '%') AND a.create_by = #{createBy.id} AND a.request_uri LIKE CONCAT(#{requestUri}, '%') AND a.type = #{TYPE_EXCEPTION} AND a.params LIKE CONCAT('%', #{params}, '%') ORDER BY a.create_date DESC INSERT INTO jeesite_sys_log( id, type, title, create_by, create_date, remote_addr, user_agent, request_uri, method, params, exception ) VALUES ( #{id}, #{type}, #{title}, #{createBy.id}, #{createDate}, #{remoteAddr}, #{userAgent}, #{requestUri}, #{method}, #{params}, #{exception} )