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`3.5msdrtu_drturkListHotel.php#161
select*from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` isnull1.18msdrtu_drturkListHotel.php#161
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Hotel/Blocks/ListHotel.php:161
22. modules/Hotel/Blocks/ListHotel.php:140
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `user_wishlist` where `object_model` ='hotel'and `user_id` =0and `user_wishlist`.`object_id` in (1, 2, 3, 4)940μsdrtu_drturkListHotel.php#161
Bindings
0: hotel
1: 0
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Hotel/Blocks/ListHotel.php:161
22. modules/Hotel/Blocks/ListHotel.php:140
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `bravo_hotel_translations` where `locale` ='en'and `bravo_hotel_translations`.`origin_id` in (1, 2, 3, 4) and `bravo_hotel_translations`.`deleted_at` isnull1.08msdrtu_drturkListHotel.php#161
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Hotel/Blocks/ListHotel.php:161
22. modules/Hotel/Blocks/ListHotel.php:140
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
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) and `bravo_terms`.`deleted_at` isnull1.46msdrtu_drturkListHotel.php#161
Bindings
0: 6
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:5
select*from `bravo_terms_translations` where `locale` ='en'and `bravo_terms_translations`.`origin_id` in (42, 43, 44, 45, 46, 47, 48)1.22msdrtu_drturkListHotel.php#161
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
0: Use SELECT * only if you need all columns from table
Backtrace
15. modules/Location/Blocks/ListLocations.php:168
16. modules/Location/Blocks/ListLocations.php:132
19. modules/Template/Blocks/RootBlock.php:10
22. modules/Page/Models/Page.php:82
23. view::Page::frontend.detail:5
select*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (6, 7, 10, 16, 17, 34)1.01msdrtu_drturkListLocations.php#168
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
20. modules/Location/Blocks/ListLocations.php:168
21. modules/Location/Blocks/ListLocations.php:132
24. modules/Template/Blocks/RootBlock.php:10
27. modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:5
selectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull1.1msdrtu_drturkSpace.php#748
selectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull2.25msdrtu_drturkHotel.php#730
selectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull1.16msdrtu_drturkTour.php#814
selectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull1.55msdrtu_drturkSpace.php#748
selectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull1.27msdrtu_drturkHotel.php#730
selectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull1.12msdrtu_drturkTour.php#814
selectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull1.32msdrtu_drturkSpace.php#748
selectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull1.67msdrtu_drturkHotel.php#730
selectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull1.34msdrtu_drturkTour.php#814
selectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull1.49msdrtu_drturkSpace.php#748
selectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull1.41msdrtu_drturkHotel.php#730
selectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull1.2msdrtu_drturkTour.php#814
selectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull1.68msdrtu_drturkSpace.php#748
selectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull1.55msdrtu_drturkHotel.php#730
selectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull1.1msdrtu_drturkTour.php#814
selectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull1.11msdrtu_drturkSpace.php#748
selectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull1.12msdrtu_drturkHotel.php#730
selectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=1and `bravo_locations`.`_rgt` <=2where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull1.32msdrtu_drturkTour.php#814
select*from `bravo_tour_category` where (0=1or0=1and `status` ='publish') and `bravo_tour_category`.`deleted_at` isnull1.1msdrtu_drturkTour.php#1004
Bindings
0: publish
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
15. modules/Tour/Models/Tour.php:1004
16. modules/Tour/Blocks/ListTours.php:176
17. modules/Tour/Blocks/ListTours.php:157
20. modules/Template/Blocks/RootBlock.php:10
23. 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`4.26msdrtu_drturkListTours.php#178
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 2) and `bravo_locations`.`deleted_at` isnull920μsdrtu_drturkListTours.php#178
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Tour/Blocks/ListTours.php:178
22. modules/Tour/Blocks/ListTours.php:157
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `user_wishlist` where `object_model` ='tour'and `user_id` =0and `user_wishlist`.`object_id` in (1, 2, 3, 4, 5, 6)990μsdrtu_drturkListTours.php#178
Bindings
0: tour
1: 0
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Tour/Blocks/ListTours.php:178
22. modules/Tour/Blocks/ListTours.php:157
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `bravo_tour_translations` where `locale` ='en'and `bravo_tour_translations`.`origin_id` in (1, 2, 3, 4, 5, 6)1.15msdrtu_drturkListTours.php#178
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Tour/Blocks/ListTours.php:178
22. modules/Tour/Blocks/ListTours.php:157
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
selectcount(*) as aggregate from (select `bravo_spaces`.*from `bravo_spaces` where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnullgroupby `bravo_spaces`.`id`) as `aggregate_table`2.68msdrtu_drturkListSpace.php#156
select*from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` isnull2.5msdrtu_drturkListSpace.php#156
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Space/Blocks/ListSpace.php:156
22. modules/Space/Blocks/ListSpace.php:133
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `user_wishlist` where `object_model` ='space'and `user_id` =0and `user_wishlist`.`object_id` in (8, 9, 10, 11)1.7msdrtu_drturkListSpace.php#156
Bindings
0: space
1: 0
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Space/Blocks/ListSpace.php:156
22. modules/Space/Blocks/ListSpace.php:133
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `bravo_space_translations` where `locale` ='en'and `bravo_space_translations`.`origin_id` in (8, 9, 10, 11) and `bravo_space_translations`.`deleted_at` isnull1.74msdrtu_drturkListSpace.php#156
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Space/Blocks/ListSpace.php:156
22. modules/Space/Blocks/ListSpace.php:133
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
selectcount(*) as aggregate from (select `bravo_cars`.*from `bravo_cars` where `bravo_cars`.`status` ='publish'and `bravo_cars`.`deleted_at` isnullgroupby `bravo_cars`.`id`) as `aggregate_table`3.35msdrtu_drturkListCar.php#153
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 3, 6, 7, 8) and `bravo_locations`.`deleted_at` isnull1.11msdrtu_drturkListCar.php#153
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Car/Blocks/ListCar.php:153
22. modules/Car/Blocks/ListCar.php:132
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (6, 7)1.57msdrtu_drturkListCar.php#153
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
26. modules/Car/Blocks/ListCar.php:153
27. modules/Car/Blocks/ListCar.php:132
30. modules/Template/Blocks/RootBlock.php:10
33. modules/Page/Models/Page.php:82
34. view::Page::frontend.detail:5
select*from `user_wishlist` where `object_model` ='car'and `user_id` =0and `user_wishlist`.`object_id` in (6, 7, 8, 9, 10, 11, 12, 13)1.16msdrtu_drturkListCar.php#153
Bindings
0: car
1: 0
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Car/Blocks/ListCar.php:153
22. modules/Car/Blocks/ListCar.php:132
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `bravo_car_translations` where `locale` ='en'and `bravo_car_translations`.`origin_id` in (6, 7, 8, 9, 10, 11, 12, 13) and `bravo_car_translations`.`deleted_at` isnull1.33msdrtu_drturkListCar.php#153
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Car/Blocks/ListCar.php:153
22. modules/Car/Blocks/ListCar.php:132
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
selectcount(*) as aggregate from (select `bravo_events`.*from `bravo_events` where `bravo_events`.`status` ='publish'and `bravo_events`.`deleted_at` isnullgroupby `bravo_events`.`id`) as `aggregate_table`3.26msdrtu_drturkListEvent.php#154
select*from `bravo_locations` where `bravo_locations`.`id` in (2, 4, 6, 7) and `bravo_locations`.`deleted_at` isnull1.39msdrtu_drturkListEvent.php#154
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Event/Blocks/ListEvent.php:154
22. modules/Event/Blocks/ListEvent.php:133
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (6, 7)1.06msdrtu_drturkListEvent.php#154
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
26. modules/Event/Blocks/ListEvent.php:154
27. modules/Event/Blocks/ListEvent.php:133
30. modules/Template/Blocks/RootBlock.php:10
33. modules/Page/Models/Page.php:82
34. view::Page::frontend.detail:5
select*from `user_wishlist` where `object_model` ='event'and `user_id` =0and `user_wishlist`.`object_id` in (6, 9, 11, 12)870μsdrtu_drturkListEvent.php#154
Bindings
0: event
1: 0
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Event/Blocks/ListEvent.php:154
22. modules/Event/Blocks/ListEvent.php:133
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `bravo_event_translations` where `locale` ='en'and `bravo_event_translations`.`origin_id` in (6, 9, 11, 12) and `bravo_event_translations`.`deleted_at` isnull730μsdrtu_drturkListEvent.php#154
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Event/Blocks/ListEvent.php:154
22. modules/Event/Blocks/ListEvent.php:133
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
selectcount(*) as aggregate from (select `bravo_boats`.*from `bravo_boats` where `bravo_boats`.`status` ='publish'and `bravo_boats`.`deleted_at` isnullgroupby `bravo_boats`.`id`) as `aggregate_table`2.25msdrtu_drturkListBoat.php#152
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 3) and `bravo_locations`.`deleted_at` isnull640μsdrtu_drturkListBoat.php#152
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Boat/Blocks/ListBoat.php:152
22. modules/Boat/Blocks/ListBoat.php:131
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `user_wishlist` where `object_model` ='boat'and `user_id` =0and `user_wishlist`.`object_id` in (1, 2, 3, 4)1.31msdrtu_drturkListBoat.php#152
Bindings
0: boat
1: 0
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
21. modules/Boat/Blocks/ListBoat.php:152
22. modules/Boat/Blocks/ListBoat.php:131
25. modules/Template/Blocks/RootBlock.php:10
28. modules/Page/Models/Page.php:82
29. view::Page::frontend.detail:5
select*from `bravo_boat_translations` where `locale` ='en'and `bravo_boat_translations`.`origin_id` in (1, 2, 3, 4) and `bravo_boat_translations`.`deleted_at` isnull2msdrtu_drturkListBoat.php#152
Bindings
0: en
Hints
0: 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, 4, 5, 6)1.39msdrtu_drturkListNews.php#134
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
Backtrace
20. modules/News/Blocks/ListNews.php:134
21. modules/News/Blocks/ListNews.php:89
24. modules/Template/Blocks/RootBlock.php:10
27. modules/Page/Models/Page.php:82
28. view::Page::frontend.detail:5
select*from `core_news_category` where `core_news_category`.`id` in (1, 2, 3, 4) and `core_news_category`.`deleted_at` isnull1.64msdrtu_drturkListNews.php#134
Hints
0: Use SELECT * only if you need all columns from table