HotelController.php#48aarnatours290425_abhi_tNt3.98msselectcount(*) as aggregate from (select `bravo_hotels`.*from `bravo_hotels` where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnullgroupby `bravo_hotels`.`id`) as `aggregate_table`
HotelController.php#48aarnatours290425_abhi_tNt580μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 2, 3, 5) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
HotelController.php#48aarnatours290425_abhi_tNt1.36msselect `bravo_terms`.*, `bravo_hotel_term`.`target_id` as `laravel_through_key` from `bravo_terms` innerjoin `bravo_hotel_term` on `bravo_hotel_term`.`term_id` = `bravo_terms`.`id` where `bravo_terms`.`attr_id` ='6'and `bravo_hotel_term`.`target_id` in (3, 4, 5, 6, 7, 8, 9, 10, 11) and `bravo_terms`.`deleted_at` isnull
Hotel.php#606aarnatours290425_abhi_tNt750μsselectMIN( price ) AS min_price ,
MAX( price ) AS max_price from `bravo_hotels` where `status` ='publish'and `bravo_hotels`.`deleted_at` isnull limit 1
Bindings
0:publish
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
HotelController.php#86aarnatours290425_abhi_tNt710μsselect*from `bravo_terms` where `bravo_terms`.`attr_id` in (5, 6, 7) and `bravo_terms`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
HotelController.php#86aarnatours290425_abhi_tNt490μsselect*from `bravo_attrs_translations` where `locale` ='en'and `bravo_attrs_translations`.`origin_id` in (5, 6, 7)
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table