EventController.php#53bookingcore910μsselectcount(*) as aggregate from (select `bravo_events`.*from `bravo_events` innerjoin `bravo_locations` on `bravo_locations`.`id` = `bravo_events`.`location_id` and `bravo_locations`.`_lft` >=3and `bravo_locations`.`_rgt` <=4where `bravo_events`.`status` ='publish'and `bravo_events`.`deleted_at` isnullgroupby `bravo_events`.`id`) as `aggregate_table`
EventController.php#53bookingcore380μsselect*from `bravo_location_translations` where `locale` ='ja'and `bravo_location_translations`.`origin_id` in (2)
Bindings
0:ja
Hints
Use SELECT * only if you need all columns from table
EventController.php#53bookingcore480μsselect*from `bravo_event_translations` where `locale` ='ja'and `bravo_event_translations`.`origin_id` in (4, 5, 6, 7) and `bravo_event_translations`.`deleted_at` isnull
Bindings
0:ja
Hints
Use SELECT * only if you need all columns from table
EventController.php#94bookingcore890μsselect `bravo_terms`.*, (selectcount(*) from `bravo_events` innerjoin `bravo_event_term` on `bravo_events`.`id` = `bravo_event_term`.`target_id` where `bravo_terms`.`id` = `bravo_event_term`.`term_id` and `bravo_events`.`deleted_at` isnull) as `event_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (11) and `bravo_terms`.`deleted_at` isnull