<foreach collection="list" item="item" index="index" open="" close="" separator=";">
update total_score set score=#{item.score}
where user_id =(select id from sys_admin where uk_account=#{item.username})
and time=#{item.time}
</foreach>
像这样执行要40多秒,怎么能快一些呢?