selectcount(*) as aggregate from (select `bravo_spaces`.*, CASEWHEN IFNULL( bravo_spaces.sale_price, 0 ) >0THEN bravo_spaces.sale_price ELSE bravo_spaces.price ENDAS tmp_min_price from `bravo_spaces` where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnullgroupby `bravo_spaces`.`id`) as `aggregate_table`60.35ms/modules/Hajj/Models/Hajj.php:1023nariaholidays_main
select*from `bravo_terms` where `bravo_terms`.`attr_id` in (3, 4, 16) and `bravo_terms`.`deleted_at` isnull3.81ms/modules/Hajj/Controllers/HajjController.php:85nariaholidays_main
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` in (3, 4, 16)25.21ms/modules/Hajj/Controllers/HajjController.php:85nariaholidays_main
Metadata
Hints
Use SELECT * only if you need all columns from table