避免循环操作数据库

for (Long id : ids) {
            //查询
            TbGoods tbGoods = goodsMapper.selectByPrimaryKey(id);
            tbGoods.setIsDelete("1"); //逻辑删除
    		//修改
            goodsMapper.updateByPrimaryKey(tbGoods);
        }

<!-- 根据主键查询数据 -->
    <select id="selectByPrimaryKeys" resultMap="BaseResultMap" parameterType="list">
        SELECT
        <include refid="Base_Column_List"/>		//查询结果
        FROM tb_goods
    	WHERE id
    	IN
        <foreach collection="list" index="index" item="id" open="(" separator="," close=")">
            #{id}
        </foreach>
    </select>