select*from `core_news_category` where `core_news_category`.`id` in (1, 2, 4, 7) and `core_news_category`.`deleted_at` isnull1.47ms/modules/Page/Controllers/PageController.php:103need4cruise
Metadata
Hints
Use SELECT * only if you need all columns from table
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`5.8ms/modules/Hotel/Blocks/ListHotel.php:161need4cruise
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 2, 5) and `bravo_locations`.`deleted_at` isnull3.06ms/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Hotel/Blocks/ListHotel.php:161
21. /modules/Hotel/Blocks/ListHotel.php:140
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
select*from `bravo_location_translations` where `locale` ='fr'and `bravo_location_translations`.`origin_id` in (1, 2, 5)1.3ms/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. fr
Hints
Use SELECT * only if you need all columns from table
Backtrace
25. /modules/Hotel/Blocks/ListHotel.php:161
26. /modules/Hotel/Blocks/ListHotel.php:140
29. /modules/Template/Blocks/RootBlock.php:10
32. /modules/Page/Models/Page.php:82
33. view::Page::frontend.detail:4
select*from `user_wishlist` where `object_model` ='hotel'and `user_id` =0and `user_wishlist`.`object_id` in (7, 8, 9, 10, 11)1.48ms/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. hotel
1. 0
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Hotel/Blocks/ListHotel.php:161
21. /modules/Hotel/Blocks/ListHotel.php:140
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
select*from `bravo_hotel_translations` where `locale` ='fr'and `bravo_hotel_translations`.`origin_id` in (7, 8, 9, 10, 11) and `bravo_hotel_translations`.`deleted_at` isnull3.1ms/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. fr
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Hotel/Blocks/ListHotel.php:161
21. /modules/Hotel/Blocks/ListHotel.php:140
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
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 (7, 8, 9, 10, 11) and `bravo_terms`.`deleted_at` isnull4.52ms/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. 6
Backtrace
19. /modules/Hotel/Blocks/ListHotel.php:161
20. /modules/Hotel/Blocks/ListHotel.php:140
23. /modules/Template/Blocks/RootBlock.php:10
26. /modules/Page/Models/Page.php:82
27. view::Page::frontend.detail:4
select*from `bravo_terms_translations` where `locale` ='fr'and `bravo_terms_translations`.`origin_id` in (42, 43, 44, 45, 46, 47, 48)1.18ms/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. fr
Hints
Use SELECT * only if you need all columns from table
selectcount(`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` isnull760μs/modules/Hotel/Models/Hotel.php:730need4cruise
selectcount(`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` isnull770μs/modules/Hotel/Models/Hotel.php:730need4cruise
selectcount(`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` isnull410μs/modules/Hotel/Models/Hotel.php:730need4cruise
selectcount(`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` isnull420μs/modules/Hotel/Models/Hotel.php:730need4cruise
selectcount(`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` isnull510μs/modules/Hotel/Models/Hotel.php:730need4cruise
selectcount(`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` isnull520μs/modules/Hotel/Models/Hotel.php:730need4cruise
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`1.4ms/modules/Hotel/Blocks/ListHotel.php:161need4cruise
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 2, 3, 5) and `bravo_locations`.`deleted_at` isnull430μs/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Hotel/Blocks/ListHotel.php:161
21. /modules/Hotel/Blocks/ListHotel.php:140
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
select*from `bravo_location_translations` where `locale` ='fr'and `bravo_location_translations`.`origin_id` in (1, 2, 3, 5)440μs/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. fr
Hints
Use SELECT * only if you need all columns from table
Backtrace
25. /modules/Hotel/Blocks/ListHotel.php:161
26. /modules/Hotel/Blocks/ListHotel.php:140
29. /modules/Template/Blocks/RootBlock.php:10
32. /modules/Page/Models/Page.php:82
33. view::Page::frontend.detail:4
select*from `user_wishlist` where `object_model` ='hotel'and `user_id` =0and `user_wishlist`.`object_id` in (1, 2, 3, 4, 5, 6, 7, 8)330μs/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. hotel
1. 0
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Hotel/Blocks/ListHotel.php:161
21. /modules/Hotel/Blocks/ListHotel.php:140
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
select*from `bravo_hotel_translations` where `locale` ='fr'and `bravo_hotel_translations`.`origin_id` in (1, 2, 3, 4, 5, 6, 7, 8) and `bravo_hotel_translations`.`deleted_at` isnull360μs/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. fr
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Hotel/Blocks/ListHotel.php:161
21. /modules/Hotel/Blocks/ListHotel.php:140
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
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 (1, 2, 3, 4, 5, 6, 7, 8) and `bravo_terms`.`deleted_at` isnull620μs/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. 6
Backtrace
19. /modules/Hotel/Blocks/ListHotel.php:161
20. /modules/Hotel/Blocks/ListHotel.php:140
23. /modules/Template/Blocks/RootBlock.php:10
26. /modules/Page/Models/Page.php:82
27. view::Page::frontend.detail:4
select*from `bravo_terms_translations` where `locale` ='fr'and `bravo_terms_translations`.`origin_id` in (42, 43, 44, 45, 46, 47, 48)310μs/modules/Hotel/Blocks/ListHotel.php:161need4cruise
Metadata
Bindings
0. fr
Hints
Use SELECT * only if you need all columns from table