QuerySets are lazy — nothing hits the database until you iterate, slice, len(), list() or print them. Chaining filters builds one SQL query. Field lookups Lookup SQL pricegte=10 price >= 10 nameicontains="dj" LIKE '%dj%' (case-insensitive) categoryname="Books" JOIN across a FK idin=[1, 2] IN (1, 2) createdyear=2026 date part stockisnull=True IS NULL Beyond filter Q(a) Q(b), Q(...) — OR / NOT conditions F("stock") - 1 — reference a column (atomic updates) annotate(n=Count("products")), aggregate(Avg("price")) selectrelated (FK, one JOIN) / prefetchrelated (reverse & M2M, second query) — fix N+1 queries only(), values(), exists(), update(), bulkcreate()