selectcount(*) as aggregate from (select `bravo_spaces`.*from `bravo_spaces` where `bravo_spaces`.`status` ='publish'and `bravo_spaces`.`deleted_at` isnullgroupby `bravo_spaces`.`id`) as `aggregate_table`4msmobi_mobillyaSpaceController.php#53
select*from `bravo_locations` where `bravo_locations`.`id` in (1, 3, 4) and `bravo_locations`.`deleted_at` isnull570μsmobi_mobillyaSpaceController.php#53
Hints
0: Use SELECT * only if you need all columns from table
select `bravo_terms`.*, (selectcount(*) from `bravo_spaces` innerjoin `bravo_space_term` on `bravo_spaces`.`id` = `bravo_space_term`.`target_id` where `bravo_terms`.`id` = `bravo_space_term`.`term_id` and `bravo_spaces`.`deleted_at` isnull) as `space_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (3, 4, 16) and `bravo_terms`.`deleted_at` isnull7msmobi_mobillyaSpaceController.php#92
select*from `bravo_attrs_translations` where `locale` ='fa'and `bravo_attrs_translations`.`origin_id` in (3, 4, 16)840μsmobi_mobillyaSpaceController.php#92
Bindings
0: fa
Hints
0: Use SELECT * only if you need all columns from table