Paginator not working properly

[geofflancaster]

I'm trying to use the paginate() method to get specific items from the database. When I use "getQueryLog" it does not show that the query uses take() or skip().

I'm having issues with this because I have a large number of records and it seems to be retrieving too many which is causing too much memory to be used.

Does anyone have any ideas about this?

[jenssegers]

Are you using any group operations? Can you show me a code example (or a unit test)?

[geofflancaster]

I'm not using group operations, just order by but the query log shows it's grouping.

MyModel:
public function scopeWithSuccess($query) {
    return $query->withTrashed()->with('user')->where('status', '=', 1);
  }

Service:
$items = MyModel::withSuccess()->orderBy('created_at', 'DESC')->paginate(15, ['id','name']);
dd(\DB::getQueryLog());

Query Log Output:
array (size=2)
  0 => 
    array (size=3)
      'query' => string 'mymodels.aggregate([{"$match":{"$and":[{"status":"1"}]}},{"$group":{"_id":null,"aggregate":{"$sum":1}}}])' (length=105)
      'bindings' => 
        array (size=0)
          empty
      'time' => float 6.74
  1 => 
    array (size=3)
      'query' => string 'mymodels.find({"$and":[{"status":"1"}]},{"id":true,"name":true})' (length=64)
      'bindings' => 
        array (size=0)
          empty
      'time' => float 0.06

[geofflancaster]

any ideas of what could be causing this? I'm still having the issue. thanks.

[jenssegers]

The builder gets the cursor for all the results, and then calls skip and limit on the cursor.

[jenssegers]

Try the current version on master.

[geofflancaster]

Is it possible to merge this into a branch that is capable of running on laravel 4.2? We have not yet upgraded to 5.0.