大数据量数据库查询建议

Question

$cardNoBegin=1;$cardNoEnd=10000;$where['number']=array('between',[$cardNoBegin,$cardNoEnd]);$list=VipCardModel::where($where)->field('id,number,issue_uid,rank')->select();foreach($listas&$value){//只想到foreach来处理，但是这样很奇怪，觉得这样处理不对。$value['name']=UserModel::where(array('id'=>$value['issue_uid']))->value('name');}

Answer 1

shmiyle同学已经正确的回答了这个问题，我在他的基础上优化一下,提升一点效率$where['number']=array('between',[$cardNoBegin,$cardNoEnd]);$list=VipCardModel::where($where)->field('id,number,issue_uid,rank')->select();$issueUidList=array_unique((array_column($list,'issue_uid')));unset($list);//查询用户信息$userList=UserModel::where(array('id'=>array('in',$issueUidList)))->value('name');$userInfoList=array_column($userList,'name','id');foreach($listas$key=>$value){$list[$key]['name']=$userInfoList[$value['issue_uid']]??'';}

Answer 2

这样肯定是不可取的，循环里面执行查询。可以试试with$list=VipCardModel::where($where)->with('user')->field('id,number,issue_uid,rank')->select();