drema2014 2016-12-13 06:08
浏览 219
已采纳

laravel关系查询两次?

//Eloquent relationship 
$customer = App\Customer::find($id); //1s query
return $orders = $customer->orders(); //2nd query

class 
public function orders() {
     return $this->hasMany('App\Order', 'customer_id')->get();
}

//Query builder, only query once
$data = DB::table('customers')
      ->select('orders.name...')
      ->leftJoin('orders', 'customers.id', '=', 'orders.customer_id')
      ->get();

I'm currently learning laravel, I was wondering when I use relationship to do left join query, is it will query twice?

If so which is better for performance? query builder left join can save one query which is the one I usually go with

  • 写回答

3条回答 默认 最新

  • dongzhuo3202 2016-12-13 06:12
    关注
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)
编辑
预览

报告相同问题?