1Hardgeneral⏱ 45sHow does Django's `select_related` differ from `prefetch_related` for optimizing related-object queries?📎▼AThey are identicalBselect_related performs a SQL JOIN to fetch related objects in one query (for foreign key/one-to-one); prefetch_related issues a separate query per relation and joins the results in Python (needed for many-to-many/reverse foreign keys)Cprefetch_related always performs a JOIN as wellDselect_related is used exclusively for many-to-many fields