springboot接口提高查询速度方法

接口想要提高查询速度，需要减少查询数据库的次数，需要把循环里面的查询提出来一次性查询完毕，然后通过java代码来获取响应的值。如下所示：

List<OrderInfoHtVO> orderInfoList = orderInfoService.getOrderInfoHtlist(query);

if(CollectionUtils.isNotEmpty(orderInfoList)){

List<Integer> orderIdList = orderInfoList.stream().map(OrderInfoHtVO::getOrderId)
.collect(Collectors.toList());

List<String> orderNoList = orderInfoList.stream().map(OrderInfoHtVO::getOrderNumber)
.collect(Collectors.toList());

List<InvoiceStatusVO> invoiceStatusVOList = applayInvoiceInfoService.
getInvoiceStatusByOrderList(orderIdList,orderNoList,orderInfoList);

Map<Integer,List<InvoiceStatusVO>> invoiceStatusVOMap = invoiceStatusVOList.stream().
collect(Collectors.groupingBy(InvoiceStatusVO::getOrderId));

List<ApplayInvoiceHongChongCountVO> applayInvoiceHongChongCountVOList = applayInvoiceInfoService
.searchApplayInvoiceHongChongCountListByOrderNoList(orderNoList);

Map<String,List<ApplayInvoiceHongChongCountVO>> applayInvoiceHongChongCountVOMap = applayInvoiceHongChongCountVOList.stream()
.collect(Collectors.groupingBy(ApplayInvoiceHongChongCountVO::getOrderNo));

List<PackageGoodsCountVO> packageGoodsCountVOList = orderInfoService
.searchPackageGoodsCountListByOrderIdList(orderIdList);

Map<Integer,List<PackageGoodsCountVO>> packageGoodsCountVOMap = packageGoodsCountVOList.stream()
.collect(Collectors.groupingBy(PackageGoodsCountVO::getOrderId));

for (OrderInfoHtVO orderInfoHtVO : orderInfoList) {

if(CollectionUtils.isNotEmpty(invoiceStatusVOMap.get(orderInfoHtVO.getOrderId()))){
    orderInfoHtVO.setInvoiceStatus(
    invoiceStatusVOMap.get(orderInfoHtVO.getOrderId()).get(0).getInvoiceStatus());
}else{
    orderInfoHtVO.setInvoiceStatus(0);
}

if(CollectionUtils.isNotEmpty(applayInvoiceHongChongCountVOMap.get(orderInfoHtVO
   .getOrderNumber()))){
   orderInfoHtVO.setIsHongChong(applayInvoiceHongChongCountVOMap
   .get(orderInfoHtVO.getOrderNumber()).get(0).getIsHongChong());
}else{
   orderInfoHtVO.setIsHongChong(0);
}

if(CollectionUtils.isNotEmpty(packageGoodsCountVOMap.get(orderInfoHtVO.getOrderId()))){
    orderInfoHtVO.setIsPackage(packageGoodsCountVOMap
    .get(orderInfoHtVO.getOrderId()).get(0).getIsPackage());
}else{
    orderInfoHtVO.setIsPackage(0);
}

}

}