selectcount(*) as aggregate from (select `bravo_cars`.*from `bravo_cars` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_cars`.`status` ='publish'and `bravo_cars`.`deleted_at` isnullgroupby `bravo_cars`.`id`) as `aggregate_table`2.62ms/modules/Car/Models/Car.php:963tripura_nature_trails_and_resorts
select*from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` isnull590μs/modules/Car/Models/Car.php:963tripura_nature_trails_and_resorts
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (1)450μs/modules/Car/Models/Car.php:963tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_car_translations` where `bravo_car_translations`.`origin_id` in (1, 2, 4, 13, 14) and `bravo_car_translations`.`deleted_at` isnull520μs/modules/Car/Models/Car.php:963tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_terms` where `bravo_terms`.`attr_id` in (9, 10, 24, 25) and `bravo_terms`.`deleted_at` isnull1.57ms/modules/Car/Controllers/CarController.php:71tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` in (9, 10, 24, 25)830μs/modules/Car/Controllers/CarController.php:71tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table