PageHelper uses our query SQL to conduct count query by default in paging query. However, in the case of complicated SQL or large amount of data, how do we conduct count query manually?
Page interceptor intercepts SQL
Here PageHelper goes back to matching the query Id+”_COUNT” as the default count query
Make count query
Pagination in PageHelper