STOP USING SELECT * — HERE IS THE PROOF
Rant incoming.
Every beginner tutorial on the planet teaches SELECT *. Then nobody tells you to stop. So the production query on the leaderboard pulls 18 columns from the threads table to use three. EXPLAIN QUERY PLAN shows the same index hit either way, but the bytes shipped off the disk are six times higher.
Bench: 100k row threads table, SELECT * vs SELECT threadId, title, lastpost. Average over 1000 runs:
SELECT * — 28.4ms
SELECT threadId, title, lastpost — 4.1ms
Same index. Same plan. Six fewer columns. The query planner cannot save you from your own column list.
If you are writing a new query today, list the columns. Always.