public function test_query() { $items = Category::select('c.category_id', 'c.parent_id', 'cd.name', DB::raw('(SELECT count(category_id) FROM oc_category) AS childrenCount'))->from('oc_category as c')->where('c.parent_id', 0)->where('cd.language_id', 1)->join('oc_category_description as cd', 'c.category_id', '=', 'cd.category_id')->orderBy('c.sort_order')->get(); $queries = DB::getQueryLog(); $last_query = end($queries); var_dump($last_query['query']); var_dump(count($items)); var_dump($items->count()); $this->assertNotNull($items->count()); }