//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