BoatController.php#42aarnatours290425_abhi_tNt2.79msselectcount(*) as aggregate from (select `bravo_boats`.*from `bravo_boats` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_boats`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_boats`.`status` ='publish'and `bravo_boats`.`deleted_at` isnullgroupby `bravo_boats`.`id`) as `aggregate_table`
BoatController.php#42aarnatours290425_abhi_tNt610μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
BoatController.php#42aarnatours290425_abhi_tNt450μsselect*from `bravo_location_translations` where `locale` ='ja'and `bravo_location_translations`.`origin_id` in (1)
Bindings
0:ja
Hints
Use SELECT * only if you need all columns from table
Boat.php#538aarnatours290425_abhi_tNt520μsselectMIN( min_price ) AS min_price ,
MAX( min_price ) AS max_price from `bravo_boats` where `status` ='publish'and `bravo_boats`.`deleted_at` isnull limit 1
Bindings
0:publish
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
BoatController.php#80aarnatours290425_abhi_tNt780μsselect*from `bravo_terms` where `bravo_terms`.`attr_id` in (14, 15) and `bravo_terms`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
BoatController.php#80aarnatours290425_abhi_tNt470μsselect*from `bravo_attrs_translations` where `locale` ='ja'and `bravo_attrs_translations`.`origin_id` in (14, 15)
Bindings
0:ja
Hints
Use SELECT * only if you need all columns from table