selectcount(*) as aggregate from (select`bravo_hotels`.* from`bravo_hotels`where`bravo_hotels`.`status` = 'publish'and`bravo_hotels`.`deleted_at`isnullgroupby`bravo_hotels`.`id`) as`aggregate_table`7.01ms/modules/Hotel/Controllers/HotelController.php:54tripsap_new