selectcount(*) as aggregate from (select `bravo_spaces`.*, CASEWHEN IFNULL( bravo_spaces.sale_price, 0 ) >0THEN bravo_spaces.sale_price ELSE bravo_spaces.price ENDAS tmp_min_price from `bravo_spaces` innerjoin `bravo_space_term` as `tt` on `tt`.`target_id` = `bravo_spaces`.`id` where `bravo_spaces`.`status` ='publish'and `tt`.`term_id` in ('30') and `bravo_spaces`.`deleted_at` isnullgroupby `bravo_spaces`.`id`) as `aggregate_table`5.84ms/modules/Space/Models/Space.php:1015tripura_nature_trails_and_resorts
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 2, 3, 4) and `bravo_locations`.`deleted_at` isnull1.38ms/modules/Space/Models/Space.php:1015tripura_nature_trails_and_resorts
Metadata
Bindings
0. 1
1. 2
2. 3
3. 4
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (1, 2, 3, 4)540μs/modules/Space/Models/Space.php:1015tripura_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 (3, 4, 18, 19) and `bravo_terms`.`deleted_at` isnull1.77ms/modules/Space/Controllers/SpaceController.php:79tripura_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 (3, 4, 18, 19)1.33ms/modules/Space/Controllers/SpaceController.php:79tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table