select*from `bravo_tour_category` where (0=1or0=1and `status` ='publish') and `bravo_tour_category`.`deleted_at` isnull1.79ms/modules/Tour/Models/Tour.php:1003ntslibya_new
Metadata
Bindings
0. publish
Hints
Use SELECT * only if you need all columns from table
selectcount(*) as aggregate from (select `bravo_tours`.*, CASEWHEN IFNULL( bravo_tours.sale_price, 0 ) >0THEN bravo_tours.sale_price ELSE bravo_tours.price ENDAS tmp_min_price from `bravo_tours` where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnullgroupby `bravo_tours`.`id`) as `aggregate_table`800μs/modules/Tour/Controllers/TourController.php:51ntslibya_new
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 2) and `bravo_locations`.`deleted_at` isnull380μs/modules/Tour/Controllers/TourController.php:51ntslibya_new
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (1, 2)300μs/modules/Tour/Controllers/TourController.php:51ntslibya_new
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
select `bravo_terms`.*, (selectcount(*) from `bravo_tours` innerjoin `bravo_tour_term` on `bravo_tours`.`id` = `bravo_tour_term`.`tour_id` where `bravo_terms`.`id` = `bravo_tour_term`.`term_id` and `bravo_tours`.`deleted_at` isnull) as `tour_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (1, 2) and `bravo_terms`.`deleted_at` isnull1.6ms/modules/Tour/Controllers/TourController.php:97ntslibya_new
select*from `bravo_attrs_translations` where `locale` ='en'and `bravo_attrs_translations`.`origin_id` in (1, 2)310μs/modules/Tour/Controllers/TourController.php:97ntslibya_new
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_tour_category_translations` where `locale` ='en'and `bravo_tour_category_translations`.`origin_id` in (4)270μsview::Tour::frontend.layouts.search.loop-grid:24ntslibya_new
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_tour_category_translations` where `locale` ='en'and `bravo_tour_category_translations`.`origin_id` in (2)220μsview::Tour::frontend.layouts.search.loop-grid:24ntslibya_new
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_tour_category_translations` where `locale` ='en'and `bravo_tour_category_translations`.`origin_id` in (2)180μsview::Tour::frontend.layouts.search.loop-grid:24ntslibya_new
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_tour_category_translations` where `locale` ='en'and `bravo_tour_category_translations`.`origin_id` in (2)160μsview::Tour::frontend.layouts.search.loop-grid:24ntslibya_new
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_tour_category_translations` where `locale` ='en'and `bravo_tour_category_translations`.`origin_id` in (2)160μsview::Tour::frontend.layouts.search.loop-grid:24ntslibya_new
Metadata
Bindings
0. en
Hints
Use SELECT * only if you need all columns from table