关闭。这个问题需要更多focused .它目前不接受答案。












想改善这个问题吗？更新问题，使其仅关注一个问题 editing this post .

2年前关闭。




Improve this question




我有以下 Eloquent 查询，它大量使用了 relationships在模型上，它有效。

这里是:

$trip = ModelLocale::where("lang",$lang)
                    ->where("slug",$slug)
                    ->where('mainmodel_id',$id)
                    ->with(['mainmodel' => function ($query) use ($id)
                    {
                        $query
                            ->where('id', $id)
                            ->with(['convertedPrices' => function ($nestedQuery) use($id)
                            {
                                $nestedQuery
                                    ->where('model_id', $id)
                                    ->where('currency', Function::getCurrency());
                            }])
                            ->with(['othermodel','othermodel2', /** */, 'othermodel5']);
                    }])
                    ->first();

-Model 1:
--Many properties
--Relations:
---Model 2
----Many properties
----Relations:
-----Model 3
-----Model 4
-----etc

$model->model_relationship->model_relationship->atrribute

ModelLocale {#246 ▼
  #fillable: array:1 [▶]
  #connection: "mysql"
  #table: "model_locales"
  #primaryKey: "id"
  #keyType: "int"
  +incrementing: true
  #with: []
  #withCount: []
  #perPage: 15
  +exists: true
  +wasRecentlyCreated: false
  #attributes: array:8 [▼
    "id" => 580
    "main_model_id" => 290
    "title" => "Dolor dolores et hic."
    "slug" => "dolor-dolores-et-hic"
    "body" => "Enim consequuntur aliquam et iste aut incidunt corporis voluptates. Est sapiente doloribus est inventore delectus. Quia sequi doloremque nesciunt nulla non minu ▶"
    "lang" => "fj"
    "created_at" => "2019-01-16 19:17:43"
    "updated_at" => "2019-01-16 19:17:43"
  ]
  #original: array:8 [▶]
  #changes: []
  #casts: []
  #dates: []
  #dateFormat: null
  #appends: []
  #dispatchesEvents: []
  #observables: []
  #relations: array:1 [▼
    "MainModel" => MainModel{#255 ▼
      #guarded: array:1 [▶]
      #hidden: array:2 [▶]
      #connection: "mysql"
      #table: "mainmodels"
      #primaryKey: "id"
      #keyType: "int"
      +incrementing: true
      #with: []
      #withCount: []
      #perPage: 15
      +exists: true
      +wasRecentlyCreated: false
      #attributes: array:16 [▼
        "id" => 290
        "model2_id" => 17
        "model3_id" => 0
        "model4_id" => 451
        "price" => "385.00"
        "created_at" => "2019-01-16 19:17:42"
        "updated_at" => "2019-01-16 19:17:43"
      ]
      #original: array:16 [▶]
      #changes: []
      #casts: []
      #dates: []
      #dateFormat: null
      #appends: []
      #dispatchesEvents: []
      #observables: []
      #relations: array:7 [▼
        "model3" => Model 3{#267 ▶}
        "model4" => Model 4{#264 ▶}
        "model5" => Model 5{#307 ▼
          #guarded: array:1 [▶]
          #connection: "mysql"
          #table: "model5s"
          #primaryKey: "id"
          #keyType: "int"
          +incrementing: true
          #with: []
          #withCount: []
          #perPage: 15
          +exists: true
          +wasRecentlyCreated: false
          #attributes: array:7 [▶]
          #original: array:7 [▶]
          #changes: []
          #casts: []
          #dates: []
          #dateFormat: null
          #appends: []
          #dispatchesEvents: []
          #observables: []
          #relations: []
          #touches: []
          +timestamps: true
          #hidden: []
          #visible: []
          #fillable: []
        }
        "model6" => Collection {#311 ▶}
        "model7" => Collection {#312 ▶}
        "model8" => null
        "model9" => Collection {#368 ▶}
      ]
      #touches: []
      +timestamps: true
      #visible: []
      #fillable: []
    }
  ]
  #touches: []
  +timestamps: true
  #hidden: []
  #visible: []
  #guarded: array:1 [▶]
}

最佳答案

有两件事我会建议。

首先，将查询限制为在可能的情况下仅预先加载特定列。

You may not always need every column from the relationships you are retrieving. For this reason, Eloquent allows you to specify which columns of the relationship you would like to retrieve:

$users = App\Book::with('author:id,name')->get();

关于php - Laravel 5(.7) 用多重关系组织模型/集合，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/54228530/