douchun1900 2016-01-06 05:24
浏览 30
已采纳

Laravel 5:默认情况下Eloquent急切加载吗?

I got this structure:

School -> hasMany -> Classes

So when I tried the codes below via artisan tinker

App\School::with('schoolclasses')->find(2283)->schoolclasses;

I can get the classes without problem.

But when I tried without the with I still get the same result without problem:

App\School::find(2283)->schoolclasses;

Does Eloquent eager loads by default? If so, how to disable it?

  • 写回答

2条回答 默认 最新

  • douchun1859 2016-01-06 08:12
    关注

    No, Laravel does not eager load by default. Lets take this step by step. Lets ignore ->schoolclasses; for a moment.

    App\School::with('schoolclasses')->find(2283);
    

    This will query the database twice. First, it will get the School with a primary key of 2283. Then, it will immediately query the database and get all the related schoolclasses.

    App\School::find(2283);
    

    This will only query the database once. It will only get the School. There is no eager loading done so far. If you debug and keep track of your database queries, you will see that this will only query the database once while eager loading will query it twice.

    When you try to access the schoolclasses by doing ->schoolclasses;, everything actually works. So why do you get the same results? It is a bit deceptive, but it's not the same. When you try to access the schoolclasses, Laravel will check if it has already been eager loaded. If so, it will return the collection of schoolclasses. No querying is done. It just immediately returns them. However, if you did not eager load them, Laravel will query the database on the spot and get the schoolclasses. Ultimately, for this particular example, you get the same results, but when you query the database is different.

    However, this is actually a poor example of the main benefit to eager loading.

    The main benefit of eager loading is to alleviate the N + 1 query problem. Lets say you want to get 5 schools and all of its classes. Without eager loading, this is what you would do:

    $schools = School::take(5)->get();
    
    foreach ($schools as $school)
    {
        $schoolclasses = $school->schoolclasses;
    }
    

    That is a total of 6 queries for such a simple task. I added comments below to understand where the queries are coming from:

    $schools = School::take(5)->get(); // First query
    
    foreach ($schools as $school)
    {
        // For each school, you are querying the database again to get its related classes.
        // 5 schools = 5 more queries
        $schoolclasses = $school->schoolclasses;
    }
    

    However, if you eager load everything, you only have two queries:

    // Two queries here that fetches everything
    $schools = School::with('schoolclasses')->take(5)->get();
    
    foreach ($schools as $school)
    {
        // No more queries are done to get the classes because
        // they have already been eager loaded
        $schoolclasses = $school->schoolclasses;
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 Paddleocr:out of memory error on GPU
  • ¥30 51单片机C语言数码管驱动单片机为AT89C52
  • ¥100 只改动本课件的 cal_portfolio_weight_series(decision_date), 跑完本课件。设计一个信息比率尽量高的策略。
  • ¥20 如何在visual studio 2022中添加ImageMagick库
  • ¥50 如何实现uniapp编译的微信小程序做可回溯视频
  • ¥15 求Houdini使用行家,付费。价格面议。
  • ¥15 前端高拍仪调用问题报错
  • ¥15 想用octave解决这个数学问题
  • ¥15 Centos新建的临时ip无法上网,如何解决?
  • ¥15 海康威视如何实现客户端软件对设备语音请求的处理。