selectcount(*) as aggregate from (select`bravo_tours`.* from`bravo_tours`where`bravo_tours`.`status` = 'publish'and`bravo_tours`.`deleted_at`isnullgroupby`bravo_tours`.`id`) as`aggregate_table`5.4ms/modules/Tour/Models/Tour.php:1082u924038830_fivelocation