java在for循环中调用sql导致速度过慢

for (DeclareCategory dc :list){
     ParameterVO parameter = new ParameterVO();
     parameter.setId(dc.getId());
     List<Stage> stages = stageMapper.getdeclaryStagePing(parameter);
     dc.setStage(stages);
    }

public ParameterVO packeParam(List<DeclareCategory> list){
   //提取出所有DC的id
   List<Long> dcIds = new ArrayList<>();
   for (DeclareCategory dc : list){
     dcIds.add(dc.getId());
   }
   //封装传入参数
   ParameterVO parameter=new ParameterVO();
   parameter.setArray(dcIds);
   return parameter;
  }

public class ResultStageVO {

   private Long declareCategoryId;

   private List<Stage> list;
   
   //get、set自行补齐
   }

<resultMap type="com.ruoyi.declare.vo.ResultStageVO" id="StageResultList">
   <result column="declare_category_id" property="declareCategoryId"/>
   <collection property="list" ofType="com.ruoyi.common.core.domain.entity.Stage">
      <result property="id" column="id"/>
      <result property="projectId" column="project_id"/>
      ......
   </collection>
</resultMap>

SELECT
         s.*,
         p.*
      FROM
         project p,
      WHERE
         p.id = s.project_id
         AND
         <foreach item="array" collection="array" open="(" separator="or" close=")">
            p.declare_category_id = ${array}
         </foreach>
      GROUP BY s.id

List<ResultStageVO> getDeclaryStageShen(ParameterVO parameter);