django-在另一个prefetch_related中使用prefetch_related

from django.db import models
from django.db.models import Prefetch

class Author(models.Model):
    name = models.CharField(max_length=100)

class Book(models.Model):
    title = models.CharField(max_length=100)
    author = models.ForeignKey(Author, on_delete=models.CASCADE)

class Publisher(models.Model):
    name = models.CharField(max_length=100)
    books = models.ManyToManyField(Book)

# 使用prefetch_related优化查询
authors = Author.objects.prefetch_related(
    Prefetch('book_set', queryset=Book.objects.prefetch_related('author'))
)

# 在另一个prefetch_related中使用prefetch_related
publishers = Publisher.objects.prefetch_related(
    Prefetch('books', queryset=Book.objects.prefetch_related('author'))
)