lundi 28 mars 2016

Laravel Eager Loading Not Working

I have the following in my index controller:

    $recipes = Recipe::with(['color', 'glass', 'garnishes', 'recipeLines.fraction','recipeLines.unitOfMeasure','recipeLines.brand','recipeLines.product','recipeLines.ingredient', 'method', 'howServed', 'equipment', 'uom', 'products'])->where('location', $this->getLocation())
        ->whereBetween('updat', array($this->getListFromDate(), $this->getListToDate()))
        ->paginate($this->getItemsPerPage());

I thought that by using with() that Laravel would change my model relationships from individual selects to joins when Recipe::all() is called but when I look at DB::connection('remoteRecipes')->getQueryLog() I see 50 select queries instead of one.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire