bug: paginated api endpoints are not optimized for big tables

[altergui]

since merging #1329 all paginated queries perform pretty badly, but with small datasets it's not an issue.

i hotfixed /chain/blocks in c3cf08a
but we should really fix all indexer.List* queries before it becomes a problem in the future