selectcount(*) as aggregate from (select `bravo_boats`.*from `bravo_boats` where `bravo_boats`.`status` ='publish'and `bravo_boats`.`deleted_at` isnullgroupby `bravo_boats`.`id`) as `aggregate_table`4.79ms/modules/Boat/Models/Boat.php:949tripura_nature_trails_and_resorts
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 3, 5, 6, 7) and `bravo_locations`.`deleted_at` isnull1.23ms/modules/Boat/Models/Boat.php:949tripura_nature_trails_and_resorts
Metadata
Bindings
0. 1
1. 3
2. 5
3. 6
4. 7
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (1, 3, 5, 6, 7)920μs/modules/Boat/Models/Boat.php:949tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_boat_translations` where `bravo_boat_translations`.`origin_id` in (3, 5, 8, 9, 10) and `bravo_boat_translations`.`deleted_at` isnull600μs/modules/Boat/Models/Boat.php:949tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
selectMIN( min_price ) AS min_price ,
MAX( min_price ) AS max_price from `bravo_boats` where `status` ='publish'and `bravo_boats`.`deleted_at` isnull limit 1640μs/modules/Boat/Models/Boat.php:548tripura_nature_trails_and_resorts
Metadata
Bindings
0. publish
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `bravo_terms` where `bravo_terms`.`attr_id` in (14, 15, 27) and `bravo_terms`.`deleted_at` isnull860μs/modules/Boat/Controllers/BoatController.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 (14, 15, 27)650μs/modules/Boat/Controllers/BoatController.php:71tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table