$sql=$empire->query("select tagid from {$dbtbpre}enewstagsdata where classid='$classid' and id='$id'");
while($r=$empire->fetch($sql)){
$add=$empire->fetch1("select * from {$dbtbpre}enewstags where tagid='$r[tagid]' limit 1");
$addr=$empire->fetch1("select * from {$dbtbpre}dp_itag where tagid='$r[tagid]' limit 1");
if(!$dp_itag['ishtml']){
iTagDelCache($addr['tagid'],$addr['py']);
}else{
iTagHtml($add,$addr);
}
} 看见这两串就知道这个性能不怎么样的!它在循环中执行了多次数据库查询 |