select*from `bravo_tour_category` where (`slug` in ('packages') or `id` in ('packages') and `status` ='publish') and `bravo_tour_category`.`deleted_at` isnull10.53msairbusholidaysTour.php#1004
Bindings
0: packages
1: packages
2: publish
Hints
0: Use SELECT * only if you need all columns from table
selectcount(*) as aggregate from (select `bravo_tours`.*from `bravo_tours` innerjoin `bravo_tour_category` as `tc0` on `tc0`.`id` = `bravo_tours`.`category_id` and `tc0`.`_lft` >=13and `tc0`.`_rgt` <=14where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnullgroupby `bravo_tours`.`id`) as `aggregate_table`14.82msairbusholidaysTourController.php#54
select*from `bravo_locations` where `bravo_locations`.`id` in (9, 17, 22) and `bravo_locations`.`deleted_at` isnull7.87msairbusholidaysTourController.php#54
Hints
0: Use SELECT * only if you need all columns from table
select*from `bravo_location_translations` where `locale` ='es'and `bravo_location_translations`.`origin_id` in (9, 17, 22)9.82msairbusholidaysTourController.php#54
Bindings
0: es
Hints
0: Use SELECT * only if you need all columns from table
select*from `bravo_tour_category_translations` where `locale` ='es'and `bravo_tour_category_translations`.`origin_id` in (6, 7, 21)1.77msairbusholidaysTourController.php#86
Bindings
0: es
Hints
0: 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 (25, 26) and `bravo_terms`.`deleted_at` isnull33.14msairbusholidaysTourController.php#96
select*from `bravo_attrs_translations` where `locale` ='es'and `bravo_attrs_translations`.`origin_id` in (25, 26)2.45msairbusholidaysTourController.php#96
Bindings
0: es
Hints
0: Use SELECT * only if you need all columns from table