a.id AS "id", a.today AS "today", a.ip AS "ip", a.count AS "count" SELECT FROM ip_address a WHERE a.id = #{id} SELECT FROM ip_address a a.ip not in (select ip from ip_black_list where status = '0') and ip = #{ip} ORDER BY ${page.orderBy} order by a.count desc SELECT FROM ip_address a ORDER BY ${page.orderBy} UPDATE ip_address SET today = #{today}, ip = #{ip}, count = #{count} WHERE id = #{id} DELETE FROM ip_address WHERE id = #{id} INSERT INTO ip_address (id,today,ip,count) VALUES ( #{id},#{today},#{ip},#{count} ) select id,today,ip,count from ip_address AND today = #{today} AND ip = #{ip} limit 1 update ip_address set count = count + 1 AND today = #{today} AND ip = #{ip} select id,ip from ip_black_list where ip = #{ip} and status = "0"