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条)

报告相同问题?

悬赏问题

  • ¥40 如果update 一个列名为参数的value
  • ¥15 基于51单片机的水位检测系统设计中LCD1602一直不显示
  • ¥15 OCS2安装出现问题,请大家给点意见
  • ¥15 ros小车启动launch文件报错
  • ¥15 vs2015到期想登陆但是登陆不上
  • ¥15 IPQ5018制作烧录固件,boot运行失败(操作系统-linux)(相关搜索:操作系统)(相关搜索:操作系统)
  • ¥20 icefall在librispeech基础上加入个人数据集
  • ¥30 keepalive高可用故障运维配置询问
  • ¥15 求帮助!国家电网内网u盘突然识别不出来了。
  • ¥15 matlab语音变速变调同时实现