Django Academy · 课时

用于外键的 select_related

在一次查询中 JOIN 关联行

用于外键的 select_related 是 CoddyKit 上的免费 Django Academy 课时。这是第 2 节课，共 4 节。你可以在下方免费阅读本课时的完整内容 — 然后在浏览器中使用内置代码编辑器和全天候 AI 导师进行实践。这是 Django Academy 学习路径的一部分，你的进度在网页和 CoddyKit 应用中同步。 Django Academy 课程共包含 4 节课。

本课时的部分内容尚未翻译，以英文显示。

Meet select_related

select_related tells Django to fetch related rows up front in the same query, so loops stop firing extra trips. ⚡

It Uses a JOIN

Under the hood it adds a SQL JOIN, pulling the parent and its related row together in one efficient round trip.

The Basic Call

Pass the related field name to select_related on your queryset, and the join happens automatically when the data loads.

books = Book.objects.select_related('author')

From 101 to 1

Now looping over those books and reading each author runs a single query instead of one hundred and one. Same code, huge win.

for book in books:
    print(book.author.name)

When It Fits

Use it for ForeignKey and OneToOne fields, where each object points to exactly one related row that a join can grab.

Not for Many

It does not work for many-to-many or reverse one-to-many links, because a join cannot fold many rows into one cleanly.

Follow the Chain

You can span multiple hops with double underscores, joining across more than one foreign key in a single query.

Book.objects.select_related('author__publisher')

Several at Once

Pass several field names to grab multiple relations together, all stitched into the same optimized query.

Order.objects.select_related('customer', 'product')

It Is Lazy Too

The query still waits until you actually use the data, so chaining filters and order_by before it stays cheap and flexible.

Mind the Width

Joins add columns, so do not over-select. Grab only the relations you truly read to keep each row lean.

A Reflex Worth Building

See a foreign key accessed in a loop? Reach for select_related first. It becomes second nature fast. 🎯

Quick Check

Pick the right tool for this relationship.

Recap

select_related joins ForeignKey and OneToOne data in one query, killing N+1 for single-row links. Chain hops with double underscores. ✅

常见问题解答

「用于外键的 select_related」课时是免费的吗？

是的 — 「用于外键的 select_related」的完整文本可在网页上免费阅读。要进行交互式练习（内置代码编辑器和全天候 AI 导师）并解锁 Django Academy 课程的其余内容，请升级到 CoddyKit PRO。 Django Academy 课程共包含 4 节课。

「用于外键的 select_related」这节课中我会学到什么？

在一次查询中 JOIN 关联行你通过在浏览器中直接运行的动手代码来练习 Django Academy，全天候 AI 导师会在你学习这节课的过程中回答你的问题。

学习 Django Academy 需要有经验吗？

无需任何先前经验。CoddyKit 上的 Django Academy 课程适合初学者到高级学习者，你可以从这里开始或从头开始，按照自己的节奏学习。这是第 2 节课，共 4 节。

「用于外键的 select_related」课时需要多长时间？

大多数 CoddyKit 课程大约需要 5–10 分钟。每节课都很精短且互动，所以你能稳步进步，并在网页和应用中从离开的地方继续。

我能在这节 Django Academy 课中编写并运行代码吗？

能。每节 Django Academy 课都包含内置代码编辑器，你可以在浏览器中直接编写并运行真实代码，并获得即时 AI 反馈 — 无需本地设置。

此课程中的所有课时

← 返回 Django Academy