insert into user_purse_transactions (reference_type,reference_number,note,points,user_purse_id,created_time) (#{item.referenceType,typeHandler=org.apache.ibatis.type.EnumOrdinalTypeHandler}, #{item.referenceNumber}, #{item.note},#{item.points}, #{item.userPurseId}, #{item.createdTime} ) ON DUPLICATE KEY UPDATE points=#{item.points} insert into user_purses(id,points,created_time) select user_purse_id,points,CURRENT_TIMESTAMP from ( select user_purse_id,sum(points) as points,CURRENT_TIMESTAMP from user_purse_transactions where user_purse_id=#{userPurseId} group by user_purse_id ) as t ON DUPLICATE KEY UPDATE points=t.points