Use SELECT * only if you need all columns from table
Backtrace
modules/Tour/Models/Tour.php:1008
modules/Tour/Blocks/ListTours.php:176
modules/Tour/Blocks/ListTours.php:157
modules/Page/Models/Page.php:82
view::Page::frontend.detail:5
ListTours.php#178aarnatours290425_abhi_tNt2.43msselectcount(*) 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#178aarnatours290425_abhi_tNt800μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 2) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
ListTours.php#178aarnatours290425_abhi_tNt940μsselect*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (1, 2)
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
modules/Tour/Models/Tour.php:1008
modules/Tour/Blocks/ListTours.php:176
modules/Tour/Blocks/ListTours.php:157
modules/Page/Models/Page.php:82
view::Page::frontend.detail:5
ListTours.php#178aarnatours290425_abhi_tNt2.16msselectcount(*) 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`
ListTours.php#178aarnatours290425_abhi_tNt810μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 2) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
ListTours.php#178aarnatours290425_abhi_tNt670μsselect*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (1, 2)
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table
BoxCategoryTour.php#69aarnatours290425_abhi_tNt870μsselect*from `bravo_tour_category` where `id` in ('4', '3', '2', '1', '2') and `status` ='publish'and `bravo_tour_category`.`deleted_at` isnull
Bindings
0:4
1:3
2:2
3:1
4:2
5:publish
Hints
Use SELECT * only if you need all columns from table
ListNews.php#134aarnatours290425_abhi_tNt610μsselect*from `core_news_translations` where `locale` ='en'and `core_news_translations`.`origin_id` in (1, 2, 3)
Bindings
0:en
Hints
Use SELECT * only if you need all columns from table
ListNews.php#134aarnatours290425_abhi_tNt740μsselect*from `core_news_category` where `core_news_category`.`id` in (1, 2, 4) and `core_news_category`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table