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`46.62ms/modules/Tour/Models/Tour.php:1082pubgyejb_journy
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 2, 6, 7, 11) and `bravo_locations`.`deleted_at` isnull2.12ms/modules/Tour/Models/Tour.php:1082pubgyejb_journy
Metadata
Bindings
0. 1
1. 2
2. 6
3. 7
4. 11
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (1, 2, 6, 7, 11)7.06ms/modules/Tour/Models/Tour.php:1082pubgyejb_journy
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_terms` where `bravo_terms`.`attr_id` in (1, 2) and `bravo_terms`.`deleted_at` isnull7.59ms/modules/Tour/Controllers/TourController.php:77pubgyejb_journy
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` in (1, 2)5.37ms/modules/Tour/Controllers/TourController.php:77pubgyejb_journy
Metadata
Hints
Use SELECT * only if you need all columns from table