CodeIgniter’s Active Record resets itself after every get(), which is what you want almost always and a nuisance exactly once per paginated listing: the total and the page…
On every request WordPress fetches all options with autoload set to yes in one query, unserialises the lot and holds it as a single alloptions entry. That is…