SELECT `Event`.`id`, `Event`.`name`, `Event`.`slug`, `Event`.`start_date`, `Event`.`use_end_date`, `Event`.`end_date`, `Event`.`has_onsite_registration`, `Event`.`send_duplicate_email`, `Event`.`onsite_date`, `Event`.`onsite_date_tz`, `Event`.`contact_name`, `Event`.`contact_email`, `Event`.`contact_phone`, `Event`.`race_url`, `Event`.`logo`, `Event`.`mobile_logo`, `Event`.`background_image`, `Event`.`dir`, `Event`.`page_bg_color`, `Event`.`highlight_color`, `Event`.`table_row_color`, `Event`.`title_color`, `Event`.`alter_table_row_color`, `Event`.`alter_title_color`, `Event`.`hide_registration_search`, `Event`.`hide_fee_schedule`, `Event`.`success_message`, `Event`.`has_onsite_success_message`, `Event`.`onsite_success_message`, `Event`.`event_description`, `Event`.`instructions`, `Event`.`has_onsite_instructions`, `Event`.`onsite_instructions`, `Event`.`additional_information`, `Event`.`email_message`, `Event`.`bulk_email_message`, `Event`.`search_help_text`, `Event`.`charity_message`, `Event`.`end_edit_date`, `Event`.`template_id`, `Event`.`event_hide`, `Event`.`created`, `Event`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`path`, `Template`.`status`, `Template`.`created`, `Template`.`modified`, `Roster`.`id`, `Roster`.`event_id`, `Roster`.`file`, `Roster`.`dir`, `Roster`.`limit_results`, `Roster`.`limit`, `Roster`.`created`, `Roster`.`modified` FROM `ttiming_core`.`events` AS `Event` LEFT JOIN `ttiming_core`.`templates` AS `Template` ON (`Event`.`template_id` = `Template`.`id`) LEFT JOIN `ttiming_core`.`rosters` AS `Roster` ON (`Roster`.`event_id` = `Event`.`id`) WHERE `Event`.`id` = 309 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Race`.`id`, `Race`.`event_id`, `Race`.`form_type`, `Race`.`name`, `Race`.`date`, `Race`.`registration_open_date`, `Race`.`registration_close_date`, `Race`.`include_social_sharing`, `Race`.`base_entry_fee`, `Race`.`base_processing_fee`, `Race`.`bulk_price`, `Race`.`bulk_processing_fee`, `Race`.`bulk_limit`, `Race`.`allow_bulk_reg`, `Race`.`description`, `Race`.`sort`, `Race`.`created`, `Race`.`modified` FROM `ttiming_core`.`races` AS `Race` WHERE '2025-08-22' BETWEEN `Race`.`registration_open_date` AND `Race`.`registration_close_date` AND `Race`.`event_id` = (309) ORDER BY `Race`.`sort` ASC, `Race`.`form_type` ASC | 0 | 0 | 2 | maybe slow |