| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT COUNT(*) AS `count` FROM `ttiming_core`.`races` AS `Race` WHERE `Race`.`id` = 2609 | 1 | 1 | 4 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `ttiming_core`.`races` AS `Race` WHERE `Race`.`id` = 2609 AND '2026-05-01' BETWEEN `Race`.`registration_open_date` AND `Race`.`registration_close_date` | 1 | 1 | 1 | |
| SELECT `Race`.*, `Race`.`id` FROM `ttiming_core`.`races` AS `Race` WHERE `Race`.`id` = 2609 LIMIT 1 | 1 | 1 | 20 | maybe slow |
| SELECT `Coupon`.`id`, `Coupon`.`event_id`, `Coupon`.`race_id`, `Coupon`.`code`, `Coupon`.`discount`, `Coupon`.`discount_type`, `Coupon`.`apply_limit`, `Coupon`.`limit`, `Coupon`.`expiration_date` FROM `ttiming_core`.`coupons` AS `Coupon` WHERE `Coupon`.`race_id` = (2609) | 10 | 10 | 5 | maybe slow |
| SELECT `RacesFormElement`.`id`, `RacesFormElement`.`race_id`, `RacesFormElement`.`form_element_id`, `RacesFormElement`.`data`, `RacesFormElement`.`required`, `RacesFormElement`.`status`, `RacesFormElement`.`display_date`, `RacesFormElement`.`discontinue_date`, `RacesFormElement`.`use_help_text`, `RacesFormElement`.`help_text`, `RacesFormElement`.`sort`, `RacesFormElement`.`created`, `RacesFormElement`.`modified` FROM `ttiming_core`.`races_form_elements` AS `RacesFormElement` WHERE ((`RacesFormElement`.`status` = 1) OR (((`RacesFormElement`.`status` = 2) AND ('2026-05-01' BETWEEN `RacesFormElement`.`display_date` AND `RacesFormElement`.`discontinue_date`)))) AND `RacesFormElement`.`race_id` = (2609) ORDER BY - `RacesFormElement`.`sort` DESC, `RacesFormElement`.`created` ASC | 15 | 15 | 43 | maybe slow |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 9 | 1 | 1 | 3 | maybe slow |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 1 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 2 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 3 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 10 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 4 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 5 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 6 | 1 | 1 | 2 | maybe slow |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 9 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 12 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 11 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 11 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 11 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 10 | 1 | 1 | 1 | |
| SELECT `FormElement`.`id`, `FormElement`.`name`, `FormElement`.`file_name`, `FormElement`.`icon`, `FormElement`.`validations`, `FormElement`.`created`, `FormElement`.`modified` FROM `ttiming_core`.`form_elements` AS `FormElement` WHERE `FormElement`.`id` = 9 | 1 | 1 | 1 | |
| SELECT `Waiver`.`id`, `Waiver`.`name`, `Waiver`.`event_id`, `Waiver`.`text`, `Waiver`.`created`, `Waiver`.`modified`, `RacesWaiver`.`id`, `RacesWaiver`.`race_id`, `RacesWaiver`.`waiver_id`, `RacesWaiver`.`created`, `RacesWaiver`.`modified` FROM `ttiming_core`.`waivers` AS `Waiver` JOIN `ttiming_core`.`races_waivers` AS `RacesWaiver` ON (`RacesWaiver`.`race_id` = 2609 AND `RacesWaiver`.`waiver_id` = `Waiver`.`id`) | 1 | 1 | 8 | maybe slow |
| SELECT `Coupon`.`id`, `Coupon`.`event_id`, `Coupon`.`race_id`, `Coupon`.`code`, `Coupon`.`discount`, `Coupon`.`discount_type`, `Coupon`.`apply_limit`, `Coupon`.`limit`, `Coupon`.`expiration_date` FROM `ttiming_core`.`coupons` AS `Coupon` WHERE `Coupon`.`event_id` = 720 AND `Coupon`.`race_id` IS NULL | 2 | 2 | 28 | maybe slow |
| SELECT `VolunteerPosition`.`id`, `VolunteerPosition`.`race_id`, `VolunteerPosition`.`time`, `VolunteerPosition`.`leader`, `VolunteerPosition`.`position`, `VolunteerPosition`.`num_slots`, `VolunteerPosition`.`num_slots_used`, `VolunteerPosition`.`location`, `VolunteerPosition`.`sort_position`, `VolunteerPosition`.`created`, `VolunteerPosition`.`modified` FROM `ttiming_core`.`volunteer_positions` AS `VolunteerPosition` WHERE `VolunteerPosition`.`race_id` = 2609 ORDER BY `sort_position` asc | 0 | 0 | 4 | maybe slow |
| SELECT `PricingChange`.`id`, `PricingChange`.`race_id`, `PricingChange`.`entry_fee`, `PricingChange`.`processing_fee`, `PricingChange`.`start_date`, `PricingChange`.`end_date`, `PricingChange`.`created`, `PricingChange`.`modified` FROM `ttiming_core`.`pricing_changes` AS `PricingChange` WHERE `PricingChange`.`race_id` = 2609 AND '2026-05-01' BETWEEN `PricingChange`.`start_date` AND `PricingChange`.`end_date` LIMIT 1 | 0 | 0 | 3 | maybe slow |
| SELECT `Race`.`base_entry_fee` FROM `ttiming_core`.`races` AS `Race` WHERE `id` = 2609 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `Race`.`base_processing_fee` FROM `ttiming_core`.`races` AS `Race` WHERE `id` = 2609 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Event`.`id`, `Event`.`has_onsite_registration`, `Event`.`onsite_date`, `Event`.`onsite_date_tz` FROM `ttiming_core`.`events` AS `Event` WHERE `Event`.`id` = 720 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| 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` FROM `ttiming_core`.`events` AS `Event` LEFT JOIN `ttiming_core`.`templates` AS `Template` ON (`Event`.`template_id` = `Template`.`id`) WHERE `Event`.`id` = 720 LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `Race`.`name`, `Race`.`date`, `Event`.`name`, `Event`.`logo`, `Event`.`additional_information`, `Event`.`id` FROM `ttiming_core`.`races` AS `Race` LEFT JOIN `ttiming_core`.`events` AS `Event` ON (`Race`.`event_id` = `Event`.`id`) WHERE `Race`.`id` = 2609 LIMIT 1 | 1 | 1 | 6 | maybe slow |
| SELECT `Charity`.`id`, `Charity`.`event_id`, `Charity`.`name`, `Charity`.`contact_email`, `Charity`.`contact_name`, `Charity`.`email_report`, `Charity`.`do_not_display`, `Charity`.`created`, `Charity`.`modified` FROM `ttiming_core`.`charities` AS `Charity` WHERE `Charity`.`event_id` = 720 AND `Charity`.`do_not_display` = '0' ORDER BY `name` ASC | 0 | 0 | 11 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `ttiming_core`.`races` AS `Race` WHERE `Race`.`id` = 2609 | 1 | 1 | 2 | maybe slow |
| SELECT `Race`.`name`, `Race`.`date`, `Event`.`name`, `Event`.`logo`, `Event`.`additional_information`, `Event`.`id` FROM `ttiming_core`.`races` AS `Race` LEFT JOIN `ttiming_core`.`events` AS `Event` ON (`Race`.`event_id` = `Event`.`id`) WHERE `Race`.`id` = 2609 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `PricingChange`.`id`, `PricingChange`.`race_id`, `PricingChange`.`entry_fee`, `PricingChange`.`processing_fee`, `PricingChange`.`start_date`, `PricingChange`.`end_date`, `PricingChange`.`created`, `PricingChange`.`modified` FROM `ttiming_core`.`pricing_changes` AS `PricingChange` WHERE `PricingChange`.`race_id` = 2609 AND '2026-05-01' BETWEEN `PricingChange`.`start_date` AND `PricingChange`.`end_date` LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Race`.`base_entry_fee` FROM `ttiming_core`.`races` AS `Race` WHERE `id` = 2609 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Race`.`base_processing_fee` FROM `ttiming_core`.`races` AS `Race` WHERE `id` = 2609 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Event`.`slug` FROM `ttiming_core`.`events` AS `Event` WHERE `Event`.`id` = 720 LIMIT 1 | 1 | 1 | 2 | maybe slow |