$rights_sql="
SELECT
rights.id,lender_id,hold_money,get_score_dt,is_get_score
FROM
rights,loan
WHERE
rights.state in(0,1,6)
AND
from_rights_id=0
AND
hold_money>=200000
AND
loan.payback_date > '{$today}'
AND
rights.loan_id=loan.id
LIMIT
$offset,$limit
";
$rights_list = $rights_obj->Fetch($rights_sql);
if(!$rights_list){
$etime = microtime(true);//获取程序执行结束的时间
$total = $etime-$stime; //计算差值
echo 'the execute time is '.$total."\n";
exit;
}
SELECT
rights.id,lender_id,hold_money,get_score_dt,is_get_score
FROM
rights,loan
WHERE
rights.state in(0,1,6)
AND
from_rights_id=0
AND
hold_money>=200000
AND
loan.payback_date > '{$today}'
AND
rights.loan_id=loan.id
LIMIT
$offset,$limit
";
$rights_list = $rights_obj->Fetch($rights_sql);
if(!$rights_list){
$etime = microtime(true);//获取程序执行结束的时间
$total = $etime-$stime; //计算差值
echo 'the execute time is '.$total."\n";
exit;
}
$offset += $limit;
1.sql写的有些问题
2.判断有问题,如果返回false还是会追加
3.前提是有数据的时候在追加数据,判断放在后面.
4.错误判断写日志导致内存溢出的问题