class plugin_bullmarket_onlinetime { function plugin_bullmarket_onlinetime() { } }class plugin_bullmarket_onlinetime_forum{ function viewthread_sidebottom_output($a) { global $_G, $postlist; $result=array(); //根據(jù)應(yīng)用審核員返回結(jié)果，現(xiàn)對(duì)數(shù)據(jù)庫(kù)查詢進(jìn)行優(yōu)化，增加一次循環(huán)，用于將$postlist中的pid篩選為一維數(shù)組,以減少查詢次數(shù), //將分次查詢改成單次查詢，且改為聯(lián)合查詢 $pidlist=array(); foreach($postlist as $pids) { array_push($pidlist,$pids['pid']); } $totallist=DB::fetch_all("select total from ".DB::table("common_onlinetime ")." left join ".DB::table("forum_post ")." on ".DB::table("common_onlinetime ").".uid"."=".DB::table("forum_post ").".authorid where pid IN (%n)",array($pidlist)); for($i=0;$i<count($postlist);$i++) { $total=empty($totallist[$i]['total'])?"0":$totallist[$i]['total']; array_push($result,'<dl class="pil cl"><dt>'.lang('plugin/bullmarket_onlinetime', 's001') .'</dt><dd style="color:#F00">'.$total.lang('plugin/bullmarket_onlinetime', 's002').'</dd></dl>'); } return $result; }}