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`5.33msnautygocom_masterliveBoatController.php#46
select*from `bravo_locations` where `bravo_locations`.`id` in (62, 63, 65, 66, 69) and `bravo_locations`.`deleted_at` isnull580μsnautygocom_masterliveBoatController.php#46
Hints
0: 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 1870μsnautygocom_masterliveBoat.php#538
Bindings
0: publish
Hints
0:LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select `bravo_terms`.*, (selectcount(*) from `bravo_boats` innerjoin `bravo_boat_term` on `bravo_boats`.`id` = `bravo_boat_term`.`target_id` where `bravo_terms`.`id` = `bravo_boat_term`.`term_id` and `bravo_boats`.`deleted_at` isnull) as `boat_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (15) and `bravo_terms`.`deleted_at` isnull4.92msnautygocom_masterliveBoatController.php#86
select*from `bravo_attrs_translations` where `locale` ='es'and `bravo_attrs_translations`.`origin_id` in (15)830μsnautygocom_masterliveBoatController.php#86
Bindings
0: es
Hints
0: Use SELECT * only if you need all columns from table