selectcount(*) 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`4.81ms/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
select*from `bravo_locations` where `bravo_locations`.`id` in (11) and `bravo_locations`.`deleted_at` isnull520μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_location_translations` where `locale` ='ar'and `bravo_location_translations`.`origin_id` in (11)390μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
Metadata
Bindings
0. ar
Hints
Use SELECT * only if you need all columns from table
select `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 (22, 23, 24, 25, 26, 27, 28, 29, 30) and `bravo_terms`.`deleted_at` isnull950μs/modules/Hotel/Controllers/HotelController.php:54u758002481_asfarbayt2
select*from `bravo_location_translations` where `locale` ='ar'and `bravo_location_translations`.`origin_id` in (11)360μs/modules/Hotel/Controllers/HotelController.php:91u758002481_asfarbayt2
Metadata
Bindings
0. ar
Hints
Use SELECT * only if you need all columns from table
selectMIN( price ) AS min_price ,
MAX( price ) AS max_price from `bravo_hotels` where `status` ='publish'and `bravo_hotels`.`deleted_at` isnull limit 1340μs/modules/Hotel/Models/Hotel.php:606u758002481_asfarbayt2
Metadata
Bindings
0. publish
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select `bravo_terms`.*, (selectcount(*) from `bravo_hotels` innerjoin `bravo_hotel_term` on `bravo_hotels`.`id` = `bravo_hotel_term`.`target_id` where `bravo_terms`.`id` = `bravo_hotel_term`.`term_id` and `bravo_hotels`.`deleted_at` isnull) as `hotel_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (5, 6, 7) and `bravo_terms`.`deleted_at` isnull3.92ms/modules/Hotel/Controllers/HotelController.php:99u758002481_asfarbayt2
select*from `bravo_attrs_translations` where `locale` ='ar'and `bravo_attrs_translations`.`origin_id` in (5, 6, 7)400μs/modules/Hotel/Controllers/HotelController.php:99u758002481_asfarbayt2
Metadata
Bindings
0. ar
Hints
Use SELECT * only if you need all columns from table