CarController.php#47bookingcore3.96msselectcount(*) 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`
CarController.php#47bookingcore450μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 3, 5, 6, 7, 8) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
CarController.php#87bookingcore1.49msselect `bravo_terms`.*, (selectcount(*) from `bravo_cars` innerjoin `bravo_car_term` on `bravo_cars`.`id` = `bravo_car_term`.`target_id` where `bravo_terms`.`id` = `bravo_car_term`.`term_id` and `bravo_cars`.`deleted_at` isnull) as `car_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (9, 10) and `bravo_terms`.`deleted_at` isnull