$company_info = $model->where($this->where)->order('MAX(refreshtime)DESC, MAX(id) DESC')->limit(0,39)->group('uid')->getfield('distinct uid,count(id) as jobs_num');
echo(count($company_info));$this->where 的代码是
Array ( [key] => Array ( [0] => match_mode [1] => Array ( [0] => +(city11_127_1304_0_0_0 city11_127_1304_0_0 city11_127_1304_0 city11_127_1304 city11_127 city11) ) ) )
没有 $this->where 的时候 数量是 39个 或者 其他50 可以自由控制 可是加了这个 $this->where 后 数量 死活只显示 30个 这个是什么原因数据肯定不止这些的这里涉及到 mysql match array 的问题 有数量限制吗 真是搞不懂
echo(count($company_info));$this->where 的代码是
Array ( [key] => Array ( [0] => match_mode [1] => Array ( [0] => +(city11_127_1304_0_0_0 city11_127_1304_0_0 city11_127_1304_0 city11_127_1304 city11_127 city11) ) ) )
没有 $this->where 的时候 数量是 39个 或者 其他50 可以自由控制 可是加了这个 $this->where 后 数量 死活只显示 30个 这个是什么原因数据肯定不止这些的这里涉及到 mysql match array 的问题 有数量限制吗 真是搞不懂
echo $company_info->_sql(); 都不行呢
显示39个SELECT distinct uid,count(id) as jobs_num FROM `rcyw_jobs_search` WHERE MATCH (`key`) AGAINST ("+(city11_127_1304_0_0_0 city11_127_1304_0_0 city11_127_1304_0 city11_127_1304 city11_127 city11)" IN BOOLEAN MODE) GROUP BY uid LIMIT 0,39
显示30个SELECT * FROM `rcyw_jobs_search` WHERE MATCH (`key`) AGAINST ("+(city11_127_1304_0_0_0 city11_127_1304_0_0 city11_127_1304_0 city11_127_1304 city11_127 city11)" IN BOOLEAN MODE) GROUP BY uid LIMIT 0,39
显示30个SELECT * FROM `rcyw_jobs_search` WHERE MATCH (`key`) AGAINST ("+(city11_127_1304_0_0_0 city11_127_1304_0_0 city11_127_1304_0 city11_127_1304 city11_127 city11)" IN BOOLEAN MODE) LIMIT 0,39
显示 39 个
只显示 30 个
还是显示 30个