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());
}
