Optimizing MySQL Pagination for Groups of Records

Using Doctrine to Retrieve Books with No Comments: A Simplified Approach to Database Interactions in PHP

To help with the problem, I will reformat the code and provide additional context as needed.