ListHotel.php#161bookingcore1.22msselectcount(*) 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`
ListHotel.php#161bookingcore980μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 2, 5) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore860μsselect*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (1, 2, 5)
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore850μsselect*from `user_wishlist` where `object_model` ='hotel'and `user_id` =0and `user_wishlist`.`object_id` in (7, 8, 9, 10, 11)
Bindings
0:hotel
1:0
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore900μsselect*from `bravo_hotel_translations` where `locale` ='en'and `bravo_hotel_translations`.`origin_id` in (7, 8, 9, 10, 11) and `bravo_hotel_translations`.`deleted_at` isnull
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore1.34msselect `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 (7, 8, 9, 10, 11) and `bravo_terms`.`deleted_at` isnull
Bindings
0:6
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore49.4msselect*from `bravo_terms_translations` where `locale` ='en'and `bravo_terms_translations`.`origin_id` in (42, 43, 44, 45, 46, 47, 48)
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table
Use SELECT * only if you need all columns from table
Backtrace
modules/Location/Blocks/ListLocations.php:168
modules/Location/Blocks/ListLocations.php:132
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListLocations.php#168bookingcore910μsselect*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (5, 6, 7, 8, 9, 10)
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Location/Blocks/ListLocations.php:168
modules/Location/Blocks/ListLocations.php:132
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
Hotel.php#730bookingcore1.08msselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=19and `bravo_locations`.`_rgt` <=20where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Hotel.php#730bookingcore1.02msselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=17and `bravo_locations`.`_rgt` <=18where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Hotel.php#730bookingcore1.07msselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=15and `bravo_locations`.`_rgt` <=16where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Hotel.php#730bookingcore1.14msselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=13and `bravo_locations`.`_rgt` <=14where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Hotel.php#730bookingcore1.04msselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=11and `bravo_locations`.`_rgt` <=12where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Hotel.php#730bookingcore1.03msselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=9and `bravo_locations`.`_rgt` <=10where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
ListHotel.php#161bookingcore1.14msselectcount(*) 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`
ListHotel.php#161bookingcore1.01msselect*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
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore900μsselect*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (1, 2, 3, 5)
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore980μsselect*from `user_wishlist` where `object_model` ='hotel'and `user_id` =0and `user_wishlist`.`object_id` in (1, 2, 3, 4, 5, 6, 7, 8)
Bindings
0:hotel
1:0
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore890μsselect*from `bravo_hotel_translations` where `locale` ='en'and `bravo_hotel_translations`.`origin_id` in (1, 2, 3, 4, 5, 6, 7, 8) and `bravo_hotel_translations`.`deleted_at` isnull
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore1.28msselect `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 (1, 2, 3, 4, 5, 6, 7, 8) and `bravo_terms`.`deleted_at` isnull
Bindings
0:6
Backtrace
modules/Hotel/Blocks/ListHotel.php:161
modules/Hotel/Blocks/ListHotel.php:140
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListHotel.php#161bookingcore890μsselect*from `bravo_terms_translations` where `locale` ='en'and `bravo_terms_translations`.`origin_id` in (42, 43, 44, 45, 46, 47, 48)
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table