| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Setting`.`id`, `Setting`.`site_language`, `Setting`.`site_name`, `Setting`.`site_slogan`, `Setting`.`user_registrations`, `Setting`.`email_alerts`, `Setting`.`map_zoom`, `Setting`.`sport_type`, `Setting`.`show_gallery`, `Setting`.`show_coach_pictures`, `Setting`.`show_coach_email`, `Setting`.`show_coach_phone`, `Setting`.`show_player_pictures`, `Setting`.`show_player_last_names`, `Setting`.`points_per_win`, `Setting`.`points_per_tie`, `Setting`.`address_line_1`, `Setting`.`address_line_2`, `Setting`.`address_line_3`, `Setting`.`address_line_4`, `Setting`.`site_email`, `Setting`.`site_email_transport`, `Setting`.`site_auto_approve`, `Setting`.`site_host`, `Setting`.`site_port`, `Setting`.`site_timeout`, `Setting`.`site_username`, `Setting`.`site_password`, `Setting`.`site_tls`, `Setting`.`site_use_captcha`, `Setting`.`site_public_captcha_key`, `Setting`.`site_private_captcha_key`, `Setting`.`google_link`, `Setting`.`twitter_link`, `Setting`.`facebook_link`, `Setting`.`youtube_link`, `Setting`.`created`, `Setting`.`updated` FROM `bdso_darts_liga`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Division`.`id`, `Division`.`name`, `Division`.`team_counter`, `Division`.`created`, `Division`.`updated` FROM `bdso_darts_liga`.`divisions` AS `Division` WHERE 1 = 1 ORDER BY `Division`.`name` ASC | 2 | 2 | 0 | |
| SELECT `Team`.`id`, `Team`.`division_id`, `Team`.`club_id`, `Team`.`name`, `Team`.`image`, `Team`.`points`, `Team`.`wins`, `Team`.`losses`, `Team`.`ties`, `Team`.`ot_wins`, `Team`.`ot_losses`, `Team`.`goals_for`, `Team`.`goals_against`, `Team`.`created`, `Team`.`updated` FROM `bdso_darts_liga`.`teams` AS `Team` WHERE `Team`.`division_id` IN (1, 4) ORDER BY `Team`.`points` DESC | 17 | 17 | 0 | |
| SELECT `MatchMode`.`id`, `MatchMode`.`division_id`, `MatchMode`.`name`, `MatchMode`.`min_player`, `MatchMode`.`max_player`, `MatchMode`.`matches`, `MatchMode`.`innings`, `MatchMode`.`notes`, `MatchMode`.`created`, `MatchMode`.`updated` FROM `bdso_darts_liga`.`match_modes` AS `MatchMode` WHERE `MatchMode`.`division_id` IN (1, 4) | 2 | 2 | 0 | |
| SELECT `Blog`.`id`, `Blog`.`title` FROM `bdso_darts_liga`.`blog` AS `Blog` WHERE 1 = 1 ORDER BY `Blog`.`created` DESC LIMIT 5 | 4 | 4 | 0 | |
| SELECT `Game`.`id`, `Game`.`venue_id`, `Game`.`game_date`, `Game`.`game_round`, `Game`.`division_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_score`, `Game`.`away_score`, `Game`.`overtime_ind`, `Game`.`publish_score`, `Game`.`created`, `Game`.`updated`, `Venue`.`id`, `Venue`.`name`, `Venue`.`street`, `Venue`.`city`, `Venue`.`prov`, `Venue`.`postal_code`, `Venue`.`image`, `Venue`.`created`, `Venue`.`updated`, `Division`.`id`, `Division`.`name`, `Division`.`team_counter`, `Division`.`created`, `Division`.`updated`, `HomeTeam`.`id`, `HomeTeam`.`division_id`, `HomeTeam`.`club_id`, `HomeTeam`.`name`, `HomeTeam`.`image`, `HomeTeam`.`points`, `HomeTeam`.`wins`, `HomeTeam`.`losses`, `HomeTeam`.`ties`, `HomeTeam`.`ot_wins`, `HomeTeam`.`ot_losses`, `HomeTeam`.`goals_for`, `HomeTeam`.`goals_against`, `HomeTeam`.`created`, `HomeTeam`.`updated`, `AwayTeam`.`id`, `AwayTeam`.`division_id`, `AwayTeam`.`club_id`, `AwayTeam`.`name`, `AwayTeam`.`image`, `AwayTeam`.`points`, `AwayTeam`.`wins`, `AwayTeam`.`losses`, `AwayTeam`.`ties`, `AwayTeam`.`ot_wins`, `AwayTeam`.`ot_losses`, `AwayTeam`.`goals_for`, `AwayTeam`.`goals_against`, `AwayTeam`.`created`, `AwayTeam`.`updated` FROM `bdso_darts_liga`.`games` AS `Game` LEFT JOIN `bdso_darts_liga`.`venues` AS `Venue` ON (`Game`.`venue_id` = `Venue`.`id`) LEFT JOIN `bdso_darts_liga`.`divisions` AS `Division` ON (`Game`.`division_id` = `Division`.`id`) LEFT JOIN `bdso_darts_liga`.`teams` AS `HomeTeam` ON (`Game`.`home_team_id` = `HomeTeam`.`id`) LEFT JOIN `bdso_darts_liga`.`teams` AS `AwayTeam` ON (`Game`.`away_team_id` = `AwayTeam`.`id`) WHERE `Game`.`game_date` >= '2025-12-13 16:27:45' ORDER BY `Game`.`game_date` ASC LIMIT 3 | 0 | 0 | 0 | |
| SELECT `Page`.`id`, `Page`.`page_title`, `Page`.`permanent_code` FROM `bdso_darts_liga`.`pages` AS `Page` WHERE `Page`.`publish` = '1' | 1 | 1 | 0 | |
| SELECT `Contact`.`id`, `Contact`.`name`, `Contact`.`email`, `Contact`.`subject`, `Contact`.`body`, `Contact`.`read`, `Contact`.`created`, `Contact`.`updated` FROM `bdso_darts_liga`.`contacts` AS `Contact` WHERE `Contact`.`read` = '' ORDER BY `Contact`.`created` DESC LIMIT 5 | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `bdso_darts_liga`.`contacts` AS `Contact` WHERE `Contact`.`read` = '' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `bdso_darts_liga`.`coaches` AS `Coach` WHERE `Coach`.`id` = 2 | 1 | 1 | 0 | |
| SELECT `Coach`.`id`, `Coach`.`first_name`, `Coach`.`last_name`, `Coach`.`role`, `Coach`.`image`, `Coach`.`email_address`, `Coach`.`phone`, `Coach`.`notes`, `Coach`.`created`, `Coach`.`updated` FROM `bdso_darts_liga`.`coaches` AS `Coach` WHERE `Coach`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Team`.`id`, `Team`.`division_id`, `Team`.`club_id`, `Team`.`name`, `Team`.`image`, `Team`.`points`, `Team`.`wins`, `Team`.`losses`, `Team`.`ties`, `Team`.`ot_wins`, `Team`.`ot_losses`, `Team`.`goals_for`, `Team`.`goals_against`, `Team`.`created`, `Team`.`updated`, `CoachesTeam`.`coach_id`, `CoachesTeam`.`team_id` FROM `bdso_darts_liga`.`teams` AS `Team` JOIN `bdso_darts_liga`.`coaches_teams` AS `CoachesTeam` ON (`CoachesTeam`.`coach_id` = 2 AND `CoachesTeam`.`team_id` = `Team`.`id`) | 1 | 1 | 1 | |
