Django select_related and prefetch_related for N+1 query optimization

                  from django.db.models import Prefetch
from django.views.generic import ListView
from .models import Post, Comment


class PostListView(ListView):
    model = Post
    template_name = 'blog/post_list.html'
    context_object_name = 'posts'

    def get_queryset(self):
        # Optimize author (ForeignKey) and tags (ManyToMany)
        # Also prefetch recent comments with custom queryset
        recent_comments = Comment.objects.filter(
            approved=True
        ).select_related('author').order_by('-created_at')[:5]

        return Post.objects.select_related(
            'author'
        ).prefetch_related(
            'tags',
            Prefetch('comments', queryset=recent_comments)
        ).filter(published=True)