Tour.php#1013bookingcore9.02msselect*from `bravo_tour_category` where (0=1or0=1and `status` ='publish') and `bravo_tour_category`.`deleted_at` isnull
Bindings
0:publish
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Models/Tour.php:1013
modules/Tour/Blocks/ListTours.php:176
modules/Tour/Blocks/ListTours.php:157
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
ListTours.php#178bookingcore900μsselectcount(*) 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`
ListTours.php#178bookingcore480μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 7, 8) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Blocks/ListTours.php:178
modules/Tour/Blocks/ListTours.php:157
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListTours.php#178bookingcore430μsselect*from `bravo_location_translations` where `locale` ='ja'and `bravo_location_translations`.`origin_id` in (1, 7, 8)
Bindings
0:ja
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Blocks/ListTours.php:178
modules/Tour/Blocks/ListTours.php:157
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListTours.php#178bookingcore440μsselect*from `user_wishlist` where `object_model` ='tour'and `user_id` =0and `user_wishlist`.`object_id` in (12, 13, 14, 15, 16)
Bindings
0:tour
1:0
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Blocks/ListTours.php:178
modules/Tour/Blocks/ListTours.php:157
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListTours.php#178bookingcore440μsselect*from `bravo_tour_translations` where `locale` ='ja'and `bravo_tour_translations`.`origin_id` in (12, 13, 14, 15, 16)
Bindings
0:ja
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#168bookingcore490μsselect*from `bravo_location_translations` where `locale` ='ja'and `bravo_location_translations`.`origin_id` in (6, 7, 8, 9, 10)
Bindings
0:ja
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
Tour.php#823bookingcore650μsselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=19and `bravo_locations`.`_rgt` <=20where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Tour.php#823bookingcore780μsselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=17and `bravo_locations`.`_rgt` <=18where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Tour.php#823bookingcore580μsselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=15and `bravo_locations`.`_rgt` <=16where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Tour.php#823bookingcore590μsselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=13and `bravo_locations`.`_rgt` <=14where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Tour.php#823bookingcore590μsselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=11and `bravo_locations`.`_rgt` <=12where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Tour.php#1013bookingcore360μsselect*from `bravo_tour_category` where (0=1or0=1and `status` ='publish') and `bravo_tour_category`.`deleted_at` isnull
Bindings
0:publish
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Models/Tour.php:1013
modules/Tour/Blocks/ListTours.php:176
modules/Tour/Blocks/ListTours.php:157
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
ListTours.php#178bookingcore740μsselectcount(*) 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`
ListTours.php#178bookingcore430μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 2, 3) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Blocks/ListTours.php:178
modules/Tour/Blocks/ListTours.php:157
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListTours.php#178bookingcore380μsselect*from `bravo_location_translations` where `locale` ='ja'and `bravo_location_translations`.`origin_id` in (1, 2, 3)
Bindings
0:ja
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Blocks/ListTours.php:178
modules/Tour/Blocks/ListTours.php:157
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListTours.php#178bookingcore380μsselect*from `user_wishlist` where `object_model` ='tour'and `user_id` =0and `user_wishlist`.`object_id` in (1, 2, 3, 4, 5, 6, 7, 8)
Bindings
0:tour
1:0
Hints
Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Blocks/ListTours.php:178
modules/Tour/Blocks/ListTours.php:157
modules/Template/Blocks/RootBlock.php:10
modules/Page/Models/Page.php:82
view::Page::frontend.detail:4
ListTours.php#178bookingcore400μsselect*from `bravo_tour_translations` where `locale` ='ja'and `bravo_tour_translations`.`origin_id` in (1, 2, 3, 4, 5, 6, 7, 8)
Bindings
0:ja
Hints
Use SELECT * only if you need all columns from table