Codeigniter + MySql：将COUNT集成到此查询中以避免在分页时出现双重查询

Since pagination in Codeigniter (IMHO) lack some good stuff for easier implementation when using filters (beginning letter, category, etc.), even though my pagination is fully functional and working - i have two queries running and the only difference between them is that one of them has LIMIT (and OFFSET) at the end. This second query is needed because i have to get the total number of rows and with my "main" query i can't get it because it has LIMIT so it returns limited number of rows.Since pagination in Codeigniter (IMHO) lack som