selectcount(*) as aggregate from (select `bravo_cars`.*from `bravo_cars` innerjoin `bravo_car_term` as `attr_1` on `attr_1`.`target_id` = `bravo_cars`.`id` innerjoin `bravo_terms` as `term_1` on `term_1`.`id` = `attr_1`.`term_id` and `term_1`.`slug` in ('sedan') where `bravo_cars`.`status` ='publish'and `bravo_cars`.`deleted_at` isnullgroupby `bravo_cars`.`id`) as `aggregate_table`6.63ms/modules/Car/Controllers/CarController.php:48wopeca5_dev
select*from `bravo_locations` where `bravo_locations`.`id` in (12) and `bravo_locations`.`deleted_at` isnull1.05ms/modules/Car/Controllers/CarController.php:48wopeca5_dev
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (12)870μs/modules/Car/Controllers/CarController.php:48wopeca5_dev
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_car_translations` where `locale` ='en'and `bravo_car_translations`.`origin_id` in (23, 35, 38, 39, 40) and `bravo_car_translations`.`deleted_at` isnull1.03ms/modules/Car/Controllers/CarController.php:48wopeca5_dev
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
select `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, 17, 18, 19, 20, 21) and `bravo_terms`.`deleted_at` isnull29.12ms/modules/Car/Controllers/CarController.php:92wopeca5_dev