我正在開展一個項目，需要以 Excel 格式導出產品銷售報告。我正在使用Maatwebsite/Laravel-Excel我有三個模型。產品.phpclass products extends Model{? ? protected $table='products';? ? public $timestamps = false;? ? protected $fillable? = ['image', 'asin','price','strategy_id'];? ? public function orderDetails()? ? {? ? ? ? return $this->hasMany(order_details::class, 'SKU', 'asin');? ? }}訂單.phpclass orders extends Model{? ? protected $table = 'orders';? ? public $timestamps = false;? ? protected $fillable = ['id','date','quantity','totalAmount'];? ? public function orderDetails()? ? {? ? ? ? return $this->hasMany(order_details::class);? ? }}訂單詳細信息.phpclass order_details extends Model{? ? protected $table = 'order_details';? ? protected $fillable = ['id','order_id','SKU','unitPrice','quantity','totalPrice'];? ? public function order()? ? {? ? ? ? return $this->belongsTo(orders::class);? ? }現在我想計算每個產品在過去 30 天、60 天和 90 天的銷售次數。注意事項產品.asin = order_detils.SKUorder_detail 表沒有訂單日期列。一個訂單可以有多個產品，且數量大于1。我當前的查詢是：-$products = products::query();// Some where clauses/filters$products = $products->get();foreach($products as $product){? ? // Getting the order_details which has this product? ? $orderIds = order_details::where('SKU','=',$product->asin)->pluck('order_id');? ? $product->sales30days = orders::whereIn('id', $orderIds)->whereBetween('date', [Carbon::now()->subDays(30), Carbon::now()])->sum('quantity');? ? $product->sales60days = orders::whereIn('id', $orderIds)->whereBetween('date', [Carbon::now()->subDays(60), Carbon::now()])->sum('quantity');? ? $product->sales90days = orders::whereIn('id', $orderIds)->whereBetween('date', [Carbon::now()->subDays(90), Carbon::now()])->sum('quantity');? ? $product->sales120days = orders::whereIn('id', $orderIds)->whereBetween('date', [Carbon::now()->subDays(120), Carbon::now()])->sum('quantity');? ? $product->totalSold = orders::whereIn('id', $orderIds)->sum('quantity');}上面的查詢給出了我需要的結果，但需要花費大量時間并且性能不友好。我有超過 100k 個產品。我有什么解決方案來優化這個查詢嗎？$products->paginate(100)我可以在 foreach 循環之后添加分頁嗎？