n+1
public function index(Request $request)
{
$search_query = $request->get('search');
$nebulizations = Nebulization::query();
if ($search_query){
$nebulizations->search($search_query);
}
$nebulizations = $nebulizations->with(['patient','nurse','medicineNebulizations'])->latest()->paginate(10)->withQueryString();
return view('nebulizations.index', compact('nebulizations'));
}
this gives me 10queries, and it takes 1s to load a single record. the medicine relations are coming from MedicineNebulization
{
$search_query = $request->get('search');
$nebulizations = Nebulization::query();
if ($search_query){
$nebulizations->search($search_query);
}
$nebulizations = $nebulizations->with(['patient','nurse','medicineNebulizations'])->latest()->paginate(10)->withQueryString();
return view('nebulizations.index', compact('nebulizations'));
}
this gives me 10queries, and it takes 1s to load a single record. the medicine relations are coming from MedicineNebulization
