select*from `core_news_category` where `core_news_category`.`id` in (1, 2, 4, 7) and `core_news_category`.`deleted_at` isnull1.46ms/modules/Page/Controllers/PageController.php:103need4cruise
Metadata
Hints
Use SELECT * only if you need all columns from table
Use SELECT * only if you need all columns from table
Backtrace
14. /modules/Tour/Models/Tour.php:1003
15. /modules/Tour/Blocks/ListTours.php:176
16. /modules/Tour/Blocks/ListTours.php:157
19. /modules/Template/Blocks/RootBlock.php:10
22. /modules/Page/Models/Page.php:82
selectcount(*) as aggregate from (select `bravo_tours`.*from `bravo_tours` where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnullgroupby `bravo_tours`.`id`) as `aggregate_table`3.73ms/modules/Tour/Blocks/ListTours.php:178need4cruise
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 2) and `bravo_locations`.`deleted_at` isnull310μs/modules/Tour/Blocks/ListTours.php:178need4cruise
Metadata
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Tour/Blocks/ListTours.php:178
21. /modules/Tour/Blocks/ListTours.php:157
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` ='en'and `bravo_location_translations`.`origin_id` in (1, 2)320μs/modules/Tour/Blocks/ListTours.php:178need4cruise
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
Backtrace
25. /modules/Tour/Blocks/ListTours.php:178
26. /modules/Tour/Blocks/ListTours.php:157
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` ='tour'and `user_id` =0and `user_wishlist`.`object_id` in (1, 2, 3, 4, 5)1.43ms/modules/Tour/Blocks/ListTours.php:178need4cruise
Metadata
Bindings
0. tour
1. 0
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Tour/Blocks/ListTours.php:178
21. /modules/Tour/Blocks/ListTours.php:157
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
select*from `bravo_tour_translations` where `locale` ='en'and `bravo_tour_translations`.`origin_id` in (1, 2, 3, 4, 5)2.78ms/modules/Tour/Blocks/ListTours.php:178need4cruise
Metadata
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
14. /modules/Tour/Models/Tour.php:1003
15. /modules/Tour/Blocks/ListTours.php:176
16. /modules/Tour/Blocks/ListTours.php:157
19. /modules/Template/Blocks/RootBlock.php:10
22. /modules/Page/Models/Page.php:82
selectcount(*) as aggregate from (select `bravo_tours`.*from `bravo_tours` where `bravo_tours`.`status` ='publish'and `bravo_tours`.`is_featured` =1and `bravo_tours`.`deleted_at` isnullgroupby `bravo_tours`.`id`) as `aggregate_table`1.24ms/modules/Tour/Blocks/ListTours.php:178need4cruise
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 2) and `bravo_locations`.`deleted_at` isnull500μs/modules/Tour/Blocks/ListTours.php:178need4cruise
Metadata
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Tour/Blocks/ListTours.php:178
21. /modules/Tour/Blocks/ListTours.php:157
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` ='en'and `bravo_location_translations`.`origin_id` in (1, 2)510μs/modules/Tour/Blocks/ListTours.php:178need4cruise
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
Backtrace
25. /modules/Tour/Blocks/ListTours.php:178
26. /modules/Tour/Blocks/ListTours.php:157
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` ='tour'and `user_id` =0and `user_wishlist`.`object_id` in (2, 3, 4, 6)540μs/modules/Tour/Blocks/ListTours.php:178need4cruise
Metadata
Bindings
0. tour
1. 0
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Tour/Blocks/ListTours.php:178
21. /modules/Tour/Blocks/ListTours.php:157
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
select*from `bravo_tour_translations` where `locale` ='en'and `bravo_tour_translations`.`origin_id` in (2, 3, 4, 6)320μs/modules/Tour/Blocks/ListTours.php:178need4cruise
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
Backtrace
20. /modules/Tour/Blocks/ListTours.php:178
21. /modules/Tour/Blocks/ListTours.php:157
24. /modules/Template/Blocks/RootBlock.php:10
27. /modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:4
select*from `bravo_tour_category` where `id` in ('4', '3', '2', '1', '2') and `status` ='publish'and `bravo_tour_category`.`deleted_at` isnull1.01ms/modules/Tour/Blocks/BoxCategoryTour.php:69need4cruise
Metadata
Bindings
0. 4
1. 3
2. 2
3. 1
4. 2
5. publish
Hints
Use SELECT * only if you need all columns from table
select*from `core_news_translations` where `locale` ='en'and `core_news_translations`.`origin_id` in (1, 2, 3)440μs/modules/News/Blocks/ListNews.php:134need4cruise
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
Backtrace
19. /modules/News/Blocks/ListNews.php:134
20. /modules/News/Blocks/ListNews.php:89
23. /modules/Template/Blocks/RootBlock.php:10
26. /modules/Page/Models/Page.php:82
27. view::Page::frontend.detail:4
select*from `core_news_category` where `core_news_category`.`id` in (1, 3, 4) and `core_news_category`.`deleted_at` isnull500μs/modules/News/Blocks/ListNews.php:134need4cruise
Metadata
Hints
Use SELECT * only if you need all columns from table