Laravel 5.1 数据库添加索引之后,数据查询不出,什么原因?
昨天数据库进行优化,对表的两个字段添加了索引。
创建索引的SQL情况如下:ALTER TABLE inventory ADD KEY inventory_gid_sstatu(gid,sstatu);
使用 Laravel 5.1 ,MySQL 5.6
// iid 主键 ,gid 类似商品id , sstatu 卖出的状态 oid是账单号
Inventory::orderBy(isset($data['sort'])?$data['sort']:"iid",isset($data['order'])?$data['order']:"asc")
->where(function($query) use($data){
if(isset($data['gid']) && $data['gid'] != ''){
$query->where('gid',$data['gid']);
}
if(isset($data['sstatu']) && $data['sstatu'] != ''){
$query->where('sstatu',$data['sstatu'] == 0 ?false:true);
}
if(isset($data['oid']) && $data['oid'] != ''){
$query->where('oid',$data['oid']);
}
})->paginate($data['rows']);
推荐文章: