Backend
The N+1 query problem: why the page is slow when every query is fast
A hundred sub-millisecond queries, a four-second page, and the two cuts the video could not afford: a batched second query is two points in time, and a thousand ids in an IN list is a problem of its own.