a.id AS "id", a.sku_id AS "skuId", a.charging_item_id AS "chargingItemId" SELECT FROM sku_item_rel a WHERE a.id = #{id} SELECT FROM sku_item_rel a AND a.sku_id = #{skuId} AND a.charging_item_id = #{chargingItemId} ORDER BY ${page.orderBy} SELECT FROM sku_item_rel a ORDER BY ${page.orderBy} INSERT INTO sku_item_rel( id, sku_id, charging_item_id ) VALUES ( #{id}, #{skuId}, #{chargingItemId} ) UPDATE sku_item_rel SET sku_id = #{skuId}, charging_item_id = #{chargingItemId} WHERE id = #{id} DELETE FROM sku_item_rel WHERE id = #{id}