Laravel Lens Only Returning 25 Items and No Pagination Links are Visible

I have created a lens as below. May I add that the big difference between this one and the one on the example page is that mine does not have a Group By clause.

The issue is that only 25 items are returned! At first I thought I was going blind but then I launched a new vanilla Laravel 5.8 project with Nova 2.0 and the issue is still there.

    {
        return $request->withOrdering($request->withFilters(
            $query->select('id', 'total', 'status')
        ));
    }

Laravel Nova Lens Documentation link https://nova.laravel.com/docs/1.0/lenses/defining-lenses.html

I then re-did the query with a group by clause and all of a sudden pagination links appeared. Can anyone please explain why this is so?