SELECT runs.date, users.name, runs.running, runs.walking
FROM runs JOIN users ON users.id = runs.userid ORDER BY runs.date DESC
LIMIT ? OFFSET ?
| ID | PARENT | NOTUSED | DETAIL |
|---|---|---|---|
| 8 | 0 | 216 | SCAN runs |
| 10 | 0 | 45 | SEARCH users USING INTEGER PRIMARY KEY (rowid=?) |
| 25 | 0 | 0 | USE TEMP B-TREE FOR ORDER BY |