Use SELECT * only if you need all columns from table
Backtrace
14. /modules/Tour/Models/Tour.php:1103
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`860μs/modules/Tour/Blocks/ListTours.php:178jamaicataxi
select*from `bravo_locations` where `bravo_locations`.`id` in (2, 7) and `bravo_locations`.`deleted_at` isnull300μs/modules/Tour/Blocks/ListTours.php:178jamaicataxi
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:5
select*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (2, 7)280μs/modules/Tour/Blocks/ListTours.php:178jamaicataxi
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:5
select*from `user_wishlist` where `object_model` ='tour'and `user_id` =0and `user_wishlist`.`object_id` in (14, 15, 16, 18, 33)260μs/modules/Tour/Blocks/ListTours.php:178jamaicataxi
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:5
select*from `bravo_tour_translations` where `locale` ='en'and `bravo_tour_translations`.`origin_id` in (14, 15, 16, 18, 33)400μs/modules/Tour/Blocks/ListTours.php:178jamaicataxi
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:1103
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`640μs/modules/Tour/Blocks/ListTours.php:178jamaicataxi
Metadata
Bindings
0. publish
1. 1
Backtrace
15. /modules/Tour/Blocks/ListTours.php:178
16. /modules/Tour/Blocks/ListTours.php:157
19. /modules/Template/Blocks/RootBlock.php:10
22. /modules/Page/Models/Page.php:82
23. view::Page::frontend.detail:5
select*from `bravo_tour_category` where `id` in ('4', '3', '2', '1', '2') and `status` ='publish'and `bravo_tour_category`.`deleted_at` isnull770μs/modules/Tour/Blocks/BoxCategoryTour.php:69jamaicataxi
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 (9, 10, 11)1.44ms/modules/News/Blocks/ListNews.php:134jamaicataxi
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:5
select*from `core_news_category` where `core_news_category`.`id` in (1, 4) and `core_news_category`.`deleted_at` isnull1.29ms/modules/News/Blocks/ListNews.php:134jamaicataxi
Metadata
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:5
select*from `bravo_tours` where `bravo_tours`.`id` =18and `bravo_tours`.`deleted_at` isnull limit 1740μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi
Metadata
Bindings
0. 18
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
Backtrace
19. /modules/Core/Walkers/MenuWalker.php:36
20. /modules/Core/Walkers/MenuWalker.php:50
21. /modules/Core/Walkers/MenuWalker.php:50
22. /modules/Core/Walkers/MenuWalker.php:19
23. /app/Helpers/AppHelper.php:121
select*from `bravo_tours` where `bravo_tours`.`id` =16and `bravo_tours`.`deleted_at` isnull limit 1450μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi
Metadata
Bindings
0. 16
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
Backtrace
19. /modules/Core/Walkers/MenuWalker.php:36
20. /modules/Core/Walkers/MenuWalker.php:50
21. /modules/Core/Walkers/MenuWalker.php:50
22. /modules/Core/Walkers/MenuWalker.php:19
23. /app/Helpers/AppHelper.php:121
select*from `bravo_tours` where `bravo_tours`.`id` =15and `bravo_tours`.`deleted_at` isnull limit 1350μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi
Metadata
Bindings
0. 15
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
Backtrace
19. /modules/Core/Walkers/MenuWalker.php:36
20. /modules/Core/Walkers/MenuWalker.php:50
21. /modules/Core/Walkers/MenuWalker.php:50
22. /modules/Core/Walkers/MenuWalker.php:19
23. /app/Helpers/AppHelper.php:121
select*from `core_pages` where `core_pages`.`id` =10and `core_pages`.`deleted_at` isnull limit 1340μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi
Metadata
Bindings
0. 10
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan