selectcount(*) as aggregate from (select `bravo_events`.*, CASEWHEN IFNULL( bravo_events.sale_price, 0 ) >0THEN bravo_events.sale_price ELSE bravo_events.price ENDAS tmp_min_price from `bravo_events` where `bravo_events`.`status` ='publish'and `bravo_events`.`deleted_at` isnullgroupby `bravo_events`.`id`) as `aggregate_table`5.58ms/modules/Event/Models/Event.php:1014tripura_nature_trails_and_resorts
select*from `bravo_locations` where `bravo_locations`.`id` in ('', 1, 2, 5, 6) and `bravo_locations`.`deleted_at` isnull630μs/modules/Event/Models/Event.php:1014tripura_nature_trails_and_resorts
Metadata
Bindings
0.
1. 1
2. 2
3. 5
4. 6
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, 5, 6)480μs/modules/Event/Models/Event.php:1014tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_terms` where `bravo_terms`.`attr_id` in (11, 26) and `bravo_terms`.`deleted_at` isnull700μs/modules/Event/Controllers/EventController.php:77tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` in (11, 26)450μs/modules/Event/Controllers/EventController.php:77tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table