select*from `bravo_tour_category` where (0=1or0=1and `status` ='publish') and `bravo_tour_category`.`deleted_at` isnull3.83msxwxrpgte_fulvagoTour.php#1003
Bindings
0: publish
Hints
0: Use SELECT * only if you need all columns from table
selectcount(*) 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`1.13msxwxrpgte_fulvagoTourController.php#51
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, 16, 17) and `bravo_terms`.`deleted_at` isnull2.36msxwxrpgte_fulvagoTourController.php#97