ListHotel.php#159aarnatours290425_abhi_tNt1.55msselectcount(*) 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`
ListHotel.php#159aarnatours290425_abhi_tNt490μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
ListHotel.php#159aarnatours290425_abhi_tNt410μsselect*from `bravo_location_translations` where `locale` ='egy'and `bravo_location_translations`.`origin_id` in (1)
Bindings
0:egy
Hints
Use SELECT * only if you need all columns from table
ListHotel.php#159aarnatours290425_abhi_tNt490μsselect*from `bravo_hotel_translations` where `locale` ='egy'and `bravo_hotel_translations`.`origin_id` in (1, 2, 3, 4) and `bravo_hotel_translations`.`deleted_at` isnull
Bindings
0:egy
Hints
Use SELECT * only if you need all columns from table
ListHotel.php#159aarnatours290425_abhi_tNt970μsselect `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` isnull
Space.php#720aarnatours290425_abhi_tNt970μsselectcount(`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` isnull
Hotel.php#730aarnatours290425_abhi_tNt730μsselectcount(`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` isnull
Tour.php#818aarnatours290425_abhi_tNt650μsselectcount(`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` isnull
Space.php#720aarnatours290425_abhi_tNt1.09msselectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=3and `bravo_locations`.`_rgt` <=4where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull
Hotel.php#730aarnatours290425_abhi_tNt840μsselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=3and `bravo_locations`.`_rgt` <=4where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Tour.php#818aarnatours290425_abhi_tNt750μsselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=3and `bravo_locations`.`_rgt` <=4where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Space.php#720aarnatours290425_abhi_tNt920μsselectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=5and `bravo_locations`.`_rgt` <=6where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull
Hotel.php#730aarnatours290425_abhi_tNt930μsselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=5and `bravo_locations`.`_rgt` <=6where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Tour.php#818aarnatours290425_abhi_tNt1.24msselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=5and `bravo_locations`.`_rgt` <=6where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Space.php#720aarnatours290425_abhi_tNt970μsselectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=7and `bravo_locations`.`_rgt` <=8where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull
Hotel.php#730aarnatours290425_abhi_tNt850μsselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=7and `bravo_locations`.`_rgt` <=8where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Tour.php#818aarnatours290425_abhi_tNt1.03msselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=7and `bravo_locations`.`_rgt` <=8where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Space.php#720aarnatours290425_abhi_tNt1.12msselectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=9and `bravo_locations`.`_rgt` <=10where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull
Hotel.php#730aarnatours290425_abhi_tNt2.91msselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=9and `bravo_locations`.`_rgt` <=10where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Tour.php#818aarnatours290425_abhi_tNt1.03msselectcount(`bravo_tours`.`id`) as aggregate from `bravo_tours` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >=9and `bravo_locations`.`_rgt` <=10where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnull
Space.php#720aarnatours290425_abhi_tNt990μsselectcount(`bravo_spaces`.`id`) as aggregate from `bravo_spaces` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_spaces`.`location_id` and `bravo_locations`.`_lft` >=11and `bravo_locations`.`_rgt` <=12where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnull
Hotel.php#730aarnatours290425_abhi_tNt960μsselectcount(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >=11and `bravo_locations`.`_rgt` <=12where `bravo_hotels`.`status` ='publish'and `bravo_hotels`.`deleted_at` isnull
Tour.php#818aarnatours290425_abhi_tNt760μ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
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.67msselectcount(*) 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_tNt790μ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_tNt720μsselect*from `bravo_location_translations` where `locale` ='egy'and `bravo_location_translations`.`origin_id` in (1, 2)
Bindings
0:egy
Hints
Use SELECT * only if you need all columns from table
ListSpace.php#156aarnatours290425_abhi_tNt1.68msselectcount(*) 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`
ListSpace.php#156aarnatours290425_abhi_tNt520μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 4) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
ListSpace.php#156aarnatours290425_abhi_tNt430μsselect*from `bravo_location_translations` where `locale` ='egy'and `bravo_location_translations`.`origin_id` in (1, 4)
Bindings
0:egy
Hints
Use SELECT * only if you need all columns from table
ListSpace.php#156aarnatours290425_abhi_tNt560μsselect*from `bravo_space_translations` where `locale` ='egy'and `bravo_space_translations`.`origin_id` in (4, 5, 7, 11) and `bravo_space_translations`.`deleted_at` isnull
Bindings
0:egy
Hints
Use SELECT * only if you need all columns from table
ListCar.php#153aarnatours290425_abhi_tNt2.39msselectcount(*) 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`
ListCar.php#153aarnatours290425_abhi_tNt580μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 3, 6, 7, 8) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
ListEvent.php#154aarnatours290425_abhi_tNt1.5msselectcount(*) 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`
ListEvent.php#154aarnatours290425_abhi_tNt590μsselect*from `bravo_locations` where `bravo_locations`.`id` in (2, 4, 6, 7) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
ListEvent.php#154aarnatours290425_abhi_tNt1.02msselect*from `bravo_event_translations` where `locale` ='egy'and `bravo_event_translations`.`origin_id` in (6, 9, 11, 12) and `bravo_event_translations`.`deleted_at` isnull
Bindings
0:egy
Hints
Use SELECT * only if you need all columns from table
ListBoat.php#152aarnatours290425_abhi_tNt1.95msselectcount(*) 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`
ListBoat.php#152aarnatours290425_abhi_tNt650μsselect*from `bravo_locations` where `bravo_locations`.`id` in (1, 3) and `bravo_locations`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table
ListBoat.php#152aarnatours290425_abhi_tNt510μsselect*from `bravo_location_translations` where `locale` ='egy'and `bravo_location_translations`.`origin_id` in (1, 3)
Bindings
0:egy
Hints
Use SELECT * only if you need all columns from table
ListBoat.php#152aarnatours290425_abhi_tNt540μsselect*from `bravo_boat_translations` where `locale` ='egy'and `bravo_boat_translations`.`origin_id` in (1, 2, 3, 4) and `bravo_boat_translations`.`deleted_at` isnull
Bindings
0:egy
Hints
Use SELECT * only if you need all columns from table
ListNews.php#134aarnatours290425_abhi_tNt1.12msselect*from `core_news_category` where `core_news_category`.`id` in (1, 2, 3, 4) and `core_news_category`.`deleted_at` isnull
Hints
Use SELECT * only if you need all columns from table