On my User model I have the following...
/**
* @return \Illuminate\Database\Eloquent\Relations\HasManyThrough
*/
public function transactions(): HasManyThrough
{
return $this->hasManyThrough(Transaction::class, Product::class);
}
/**
* @return int
*/
public function getNumberOfOrdersInLastSevenDaysAttribute()
{
$weekAgo = Carbon::now()->subWeek();
return $this->transactions()->whereDate('transactions.created_at', '>', $weekAgo)->count();
}
When I get all Users using my custom attribute even eager loading transactions I get an n+1 issue.
What options do I have to omit my n+1 problem?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire