a.id AS "id", a.show_type AS "showType", a.breed_name AS "breedName", a.breed_group AS "breedGroup", a.show_levels AS "showLevels", a.popular_flag AS "popularFlag", a.sort AS "sort", a.remarks AS "remarks", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.del_flag AS "delFlag" SELECT FROM groomer_show_breeds a WHERE a.id = #{id} SELECT FROM groomer_show_breeds a a.del_flag = #{DEL_FLAG_NORMAL} AND FIND_IN_SET(#{showLevels},a.show_levels) AND a.show_type = #{showType} AND a.popular_flag = #{popularFlag} ORDER BY ${page.orderBy} ORDER BY a.sort asc,a.update_date DESC SELECT FROM groomer_show_breeds a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO groomer_show_breeds( id, show_type, breed_name, breed_group, show_levels, popular_flag, sort, remarks, create_by, create_date, update_by, update_date, del_flag ) VALUES ( #{id}, #{showType}, #{breedName}, #{breedGroup}, #{showLevels}, #{popularFlag}, #{sort}, #{remarks}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{delFlag} ) UPDATE groomer_show_breeds SET show_type = #{showType}, breed_name = #{breedName}, breed_group = #{breedGroup}, show_levels = #{showLevels}, popular_flag = #{popularFlag}, sort = #{sort}, remarks = #{remarks}, update_by = #{updateBy.id}, update_date = #{updateDate} WHERE id = #{id} UPDATE groomer_show_breeds SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}