mysql cpu使用率飙升问题

Question

异步不阻塞高并发时 cpu使用率飙升
CompletableFuture secondpayNum = CompletableFuture.supplyAsync(() -> PayStatService.getPaySuccessByNum(dateS, dateE, "1", channel,productId), taskExecutor);
CompletableFuture secondpayNum = CompletableFuture.supplyAsync(() -> PayStatService.getPaySuccessByNum(dateS, dateE, "2", channel,productId), taskExecutor);
CompletableFuture secondpayNum = CompletableFuture.supplyAsync(() -> PayStatService.getPaySuccessByNum(dateS, dateE, "3", channel,productId), taskExecutor);
CompletableFuture secondpayNum = CompletableFuture.supplyAsync(() -> PayStatService.getPaySuccessByNum(dateS, dateE, "4", channel,productId), taskExecutor);
。
。
。
总共统计30次

insert 获取的数据secondpayNum.get()

然后把数据入库 查询的是同一个sql(连表查询) sql执行时长小于1s 执行次数100*30 导致cpu一直使用率都90%多