mysql查询性能多查询

我只是希望有人能帮助我加快4查询与多查询。

GOAL: a single multi query to function as the single queries below.

简单的查询，我正在检查一个表，看看用户是否被禁止，如果不是，我正在获取行id和更新它的视图计数1。如果用户被禁止，我不希望最后一个查询完成。

提前感谢您的帮助

当前性能在1200ms左右。 (facebook graph api查询+1000ms avg)。

注意: af_freefeed。pageid,af_ban。

ALSO:我一直在研究和参考http://www.php.net/manual/en/mysqli.multi-query.php，我只是看不出如何让这个配置与if()成多

$fconn = new mysqli($fdbhost, $fdbuser, $fdbpass, $fdbname) or die  ('Error connecting to mysqli');
// 12,000 rows for af_ban - bigint(255) : indexed
$q = sprintf('SELECT COUNT(pageid) AS numrowst FROM af_ban WHERE pageid = %s', $banpage);
$readtop = $fconn->query($q);
$rowtop = $readtop->fetch_assoc();
// 1.17 million rows for af_freefeed - bigint(255) : indexed
if($rowtop[numrowst] == 0){
$q = sprintf('SELECT COUNT(pageid) AS numrowsf FROM af_freefeed WHERE pageid = %s', $banpage);
$readf = $fconn->query($q);
$rowf = $readf->fetch_assoc();
// increment views
$read = $fconn->query("Update af_freefeed SET views = views + 1 WHERE pageid = ".$banpage."");
}
$q=$fconn->query("SELECT pagename,views,pageid FROM af_freefeed ORDER BY views DESC LIMIT 0, 20");
unset($q);
unset($rowf);
unset($rowtop);
mysqli_close($fconn);

1. 图形api: 1127.04610825ms.
2. 什么的:1.20711326599 ms。
3. 检查禁止:0.405788421631ms.
4. get row: 418.189229965ms.
5. 增量视图:472.24655151ms.
6. get top20: 94.31447983ms.

Multi_query #1如果用户被禁止，如何停止多查询?

可能的竞争者:943.8181ms。如果添加: 933.1279ms. if banned

1. 10ms的差异，如果退出循环被禁止。这让我相信循环是完成所有的查询之前，他们实际上应该被执行，"next_result"。或者我有一个错误，我如何循环函数。

2. 用$thread_id = $fconn->thread_id; $fconn->kill($thread_id);代替exit;如果被禁953.4719毫秒。没有收获。

$banpage='234232874008';
$query  = "SELECT pagename,views,pageid FROM af_freefeed ORDER BY views DESC LIMIT 0, 2;";
$query .= "SELECT pageid AS isbanned FROM af_ban WHERE pageid = '"".$banpage."'";";
$query .= "SELECT pageid AS isadded FROM af_freefeed WHERE pageid = '"".$banpage."'";";
$query .= "Update af_freefeed SET views = views + 1 WHERE pageid = '"".$banpage."'"";
/* execute multi query */
if ($fconn->multi_query($query)) {
   if ($result = $fconn->store_result()) {
      while ($row = $result->fetch_row()) {
            print_r($row).'<br />';
      }
      $result->free();
   }
if ($fconn->more_results()) {
    while ($fconn->next_result()){ 
        if($thisresult = $fconn->store_result()){                   
            while (is_array($row = $thisresult->fetch_array())) {               
                if(isset($row['isbanned'])){
                    if($row['isbanned']===''.$banpage.''){
                $thread_id = $fconn->thread_id;
                $fconn->kill($thread_id);
                    // exit; 
                    }
                }
            }
        }
    }
}           
}
unset($query);
unset($result);
unset($thisresult);

Multi_query #2"当前为基准"如何在next_result()后的结果集中删除重复字段?

2.667 ms。/1032.2499ms。但是print_r在$thisresults中显示重复的字段?

**Array
(
    [0] => 37
    [id] => 37
    [1] => 159616034235
    [pageid] => 159616034235
    [2] => 
    [userid] => 
    [3] => 30343
    [views] => 30343
    [4] => Walmart
    [pagename] => Walmart
)**

$query = "SELECT pageid AS isbanned FROM af_ban WHERE pageid = '"".$banpage."'";";
$query .= "SELECT pageid AS isadded FROM af_freefeed WHERE pageid = '"".$banpage."'";";
$query .= "SELECT * FROM af_freefeed ORDER BY views DESC LIMIT 0, 20";
//$query .= "Update af_freefeed SET views = views + 1 WHERE pageid = '"".$banpage."'"";
/* execute multi query */
echo '<pre>';
$i=0;
if ($fconn->multi_query($query)) {
   if ($result = $fconn->store_result()) {
        //$row = $result->fetch_assoc();    
      while ($row = $result->fetch_assoc()) {
        print_r($row).'<br />';
      }
      $result->free();
    }
if ($fconn->more_results()) {
    while ($fconn->next_result()){ 
        if($thisresult = $fconn->store_result()){       
             while ($row2 = $thisresult->fetch_array()) {
                if(isset($row2['isadded'])){
                    if($row2['isadded']===''.$banpage.''){
                        $addone = $fconn->query("Update af_freefeed SET views = views + 1 WHERE pageid = ".$banpage."");
                    }
                }   
                                print_r($row2); 
            }
        }
    }
}       
}
/* determine our thread id */
$thread_id = $fconn->thread_id;
/* Kill connection */
$fconn->kill($thread_id);
//
echo '</pre><hr/>';