翻到第 5000 页
LIMIT 20 OFFSET 100000 —— 它是怎么找到第 100001 行的？
Copy the prompt, then pick a model. It plays the interviewer and asks you through it scene by scene instead of handing you the answer.
On a phone with the app installed, the system opens the app directly. Links cannot open external apps inside WeChat — open it in a browser first.
The copied text ends with the answer key the model grades you against. Don't read it yourself first — working it out on your own is the point.
答案朴素得让人不舒服：一条条数过去。知道这一句之后，「为什么加了索引还是慢」「为什么第一页快最后一页慢」就都不用问了。
但这一份的一半重量在另一边：换成游标分页之后你放弃了什么。跳页没了、总页数没了、收藏的「第 37 页」也没了 —— 说不出这几条的，只是抄了一个方案。收尾时它会把「只说了技术代价」的地方单独标出来。
最后还问一句很少有人问的：到底是谁在翻第 5000 页？
What this one drills
This prompt in the repo (the answer key is at the end of that file — you'll see it)
Have you done this one?
Sign in to mark this one as practised — next time you come back you'll see when you did it.
Notes from people who did this one
How to use this
These are learning drills: the model guides, it does not corner you. When you get stuck it first asks which layer you are stuck at (never heard of it / know it but not why / know why but cannot apply it), then decides what to give. It only explains after guiding twice, and then asks you to say it back in your own words.
It assumes MySQL / InnoDB by default — half the traps here are implementation details, and clustered indexes, back-to-the-table lookups and gap locks work differently elsewhere. PostgreSQL or anything else is fine: say so in your first message and it will follow your engine, calling out where the conclusions differ.
How to start
- Pick one, open it, copy the prompt.
- Paste it into a fresh, empty chat, and say which engine and version you use first (say nothing and it assumes MySQL 8).
- Then say nothing else and wait for its first question.
Four commands you can call out any time
跳过Move on to the next scene换个说法Explain this bit from another angle直说吧Give the full answer, then make me say it back复盘Jump straight to the wrap-up card
Three traps
- Do not read the answer key at the end first — the "what people get wrong" section is the answer to every question in the drill.
- Expect to be pushed for numbers. "A bit faster", "saves IO" gets cut off on the spot: how many rows? how many times? how many times faster? A conclusion with no number behind it is memorised.
- The moment it starts praising you, point it back at the "do not praise me" rule. Guiding is not coddling.
Start with the composite index one — it is the foundation here; "locks sit on index records" and "why is it scanning so many rows" both lean on its one-line model. If concurrency is biting you in production, start with read-modify-write instead; if queries are slow, start with the execution plan one.
Sign in to write a note.