php foreach优化,请问各位PHP怎样优化foreach 带sql

foreach ($res['xsumpre'] as $key => $value) {

$fsql="select count(*) from (SELECT sum(sumprem) FROM datatom.fccont where

signdate BETWEEN '$stime' AND '$etime' AND

agentcode in(select agentcode from datatom.shouxian_faagenttree

where agentstate not in('01','02') and OUTWORKDATE between '$stime' AND '$etime')

GROUP BY agentcode having sum(sumprem) <= '$value' ORDER BY sum ) as a";

$fres=$this->pgdb->mpg_select($fsql)['0']['count'];

// var_dump($value,$fres['0']['count']);

$res['tate'][]=round($fres/$zres['0']['count'],4)*100;

}

return $res;### 问题描述

问题出现的环境背景及自己尝试过哪些方法

接口比较慢

相关代码

// 请把代码文本粘贴到下方(请勿用图片代替代码)

你期待的结果是什么？实际看到的错误信息又是什么？

xsumpre 的数量和tate的数量一致

{

"code": 0,

"data": {

"xsumpre": [

1001066,

2002132,

3003198,

4004264,

5005330,

6006396,

7007462,

8008528,

9009594,

10010660

],

"quit": 12.21,

"tate": [

0.46,

0.46,

0.46,

0.46,

0.46,

0.46,

0.46,

0.46,

0.46,

0.46

]

},

"msg": "success"

}