视图问题

<?php
class FahuoViewModel extends ViewModel {
   public $viewFields  =array(
  'Fahuo' =>array('id','uid','sid','bid','xid','times','_type'=>'LEFT'),
  'Book' =>array('number'=>'bknum','bkname','price','_on'=>'SUBSTR(Fahuo.bid,0,9)=SUBSRT(Book.number,0,9)'),
  'Shop' =>array('number'=>'shopnum','pname','name'=>'shopname','_on'=>'Fahuo.sid=Shop.id'),
  'User' =>array('nickname'=>'username','_on'=>'Fahuo.uid=User.id'),
  );
}
?>
得到的SQL
SELECT COUNT(id) AS tp_count FROM wudi_fahuo Fahuo LEFT JOIN wudi_book Book ON SUBSTR(Fahuo.bid,`0`,9)=SUBSRT(Book.number,`0`,9) JOIN wudi_shop Shop ON Fahuo.sid=Shop.id JOIN wudi_user User ON Fahuo.uid=User.id WHERE ( Fahuo.uid = '6' ) LIMIT 1
bool(false)

ACTION
public function index() {
  $map = $this->_search ();
  if (method_exists ( $this, '_filter' )) {
   $this->_filter ( $map );
  }
  $model = D ("FahuoView");
  $this->_list ( $model, $map );
     print $model->getLastSql();
  $list = $model->where($map)->select();
  dump($list);
  $this->display ();
  return;
最后没有数据显示出来

我也是这个问题，求解