Laravel Programming Tutorials, Guides & Best Practices

Add query parameters for sorting:

   public function index(Request $request)
   {
       $sortBy = $request->get('sort_by', 'id');
       $sortOrder = $request->get('sort_order', 'asc');

       $posts = Post::orderBy($sortBy, $sortOrder)->paginate(10);

       return response()->json([
           'data' => $posts->items(),
           'meta' => [
               'current_page' => $posts->currentPage(),
               'per_page' => $posts->perPage(),
               'total' => $posts->total(),
               'last_page' => $posts->lastPage(),
           ],
           'links' => [
               'next' => $posts->nextPageUrl(),
               'previous' => $posts->previousPageUrl(),
           ],
       ]);
   }

• Always check for N+1 issues using tools like Debugbar or Telescope.
• Eager load relationships with with() for related data you know you’ll need.
• Use lazy loading sparingly for conditional data fetching.
• Test your queries regularly to ensure they are optimized.

The N+1 query problem is a common performance pitfall in Laravel applications, but with proper techniques like eager loading, lazy loading, and query optimization, you can resolve it effectively. Always monitor your queries, minimize redundant data fetching, and adopt best practices to build high-performing Laravel applications.