ListCar.php#153aarnatours290425_abhi_tNt1.78msselectcount(*) as aggregate from (select `bravo_cars`.*from `bravo_cars` where `bravo_cars`.`status` ='publish'and `bravo_cars`.`deleted_at` isnullgroupby `bravo_cars`.`id`) as `aggregate_table`
ListCar.php#153aarnatours290425_abhi_tNt790μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 3, 6, 7, 8) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table