1.667 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` `competition`, `extra_time`.`code`
`extra_time_code`, `contumacy`.`code` `contumacy_code`, `phase`.`name` `phase_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season`, `sheet_state`.`name` `sheetStateName`,
`team_home_logo`.`path` `team_home_logo`, `team_guest_logo`.`path` `team_guest_logo`,
`team_home_name`.`name` `team_home_name`, `team_guest_name`.`name` `team_guest_name`,
`club_home`.`shortcut` AS `shortcut_home`, `club_guest`.`shortcut` AS `shortcut_guest`,
`club_home`.`nickname` AS `nickname_home`, `club_guest`.`nickname` AS `nickname_guest`,
`club_home_name`.`name` `club_home_name`, `club_guest_name`.`name` `club_guest_name`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_home` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_home_id` = `team_home`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_guest` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_guest_id` = `team_guest`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_home_name` ON `team_home`.`id` =
`team_home_name`.`stats_team_id` AND (`team_home_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `team_home_name`.`stats_team_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_guest_name` ON `team_guest`.`id`
= `team_guest_name`.`stats_team_id` AND (`team_guest_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `team_guest_name`.`stats_team_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_home` ON `team_home`.`stats_club_id`
= `club_home`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_home_logo` ON `club_home`.`id` =
`team_home_logo`.`stats_club_id` AND (`team_home_logo`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable`
WHERE `nameTable`.`stats_club_id` = `team_home_logo`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_guest` ON
`team_guest`.`stats_club_id` = `club_guest`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_guest_logo` ON `club_guest`.`id`
= `team_guest_logo`.`stats_club_id` AND (`team_guest_logo`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable`
WHERE `nameTable`.`stats_club_id` = `team_guest_logo`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` AS `club_home_name` ON `club_home`.`id` =
`club_home_name`.`stats_club_id` AND (`club_home_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable`
WHERE `nameTable`.`stats_club_id` = `club_home_name`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` AS `club_guest_name` ON `club_guest`.`id`
= `club_guest_name`.`stats_club_id` AND (`club_guest_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable`
WHERE `nameTable`.`stats_club_id` = `club_guest_name`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_extra_time` AS `extra_time` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`extra_time` = `extra_time`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_contumacy` AS `contumacy` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`contumacy` = `contumacy`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_phase` AS `phase` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`phase` = `phase`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_sheet_state` AS `sheet_state` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`sheet_state` = `sheet_state`.`code`
WHERE (`team_home`.`id` IS NOT NULL) AND (`team_guest`.`id` IS NOT NULL) AND (`team_home_name`.`id`
IS NOT NULL) AND (`team_guest_name`.`id` IS NOT NULL) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908830')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | stats_match | const | PRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2 | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_home | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_guest | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | club_home | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_home_name | ref | PRIMARY,stats_team_id | stats_team_id | 5 | const | 1 | Using where | 1 | PRIMARY | team_guest_name | ref | PRIMARY,stats_team_id | stats_team_id | 5 | const | 1 | Using where | 1 | PRIMARY | team_home_logo | ref | stats_club_id | stats_club_id | 5 | const | 10 | | 1 | PRIMARY | club_guest | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_guest_logo | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest.id | 1 | | 1 | PRIMARY | club_home_name | ref | stats_club_id | stats_club_id | 5 | const | 10 | | 1 | PRIMARY | club_guest_name | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest.id | 1 | | 1 | PRIMARY | stats_competition | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | extra_time | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | contumacy | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | phase | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | sheet_state | eq_ref | PRIMARY | PRIMARY | 767 | const | 1 | | 7 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest_name.stats_club_id | 1 | Using where; Using filesort | 6 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_home_name.stats_club_id | 1 | Using where; Using filesort | 5 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.team_guest_logo.stats_club_id | 1 | Using where; Using filesort | 4 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.team_home_logo.stats_club_id | 1 | Using where; Using filesort | 3 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team_guest_name.stats_team_id | 1 | Using where; Using filesort | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team_home_name.stats_team_id | 1 | Using where; Using filesort | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/BasePresenter.php:29 | 1 |
0.539 explain | SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode`
FROM `zone`
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id`
LEFT JOIN `zone_template_2_stats_league` ON `zone_template`.`id` =
`zone_template_2_stats_league`.`zone_template_id`
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id`
WHERE (`zone_template`.`code` = 'league') AND (`zone_template_2_stats_league`.`stats_league_id` = 3)
GROUP BY `zone_position`.`id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zone_template_2_stats_league | ref | PRIMARY,stats_league_id | stats_league_id | 4 | const | 1 | Using where; Using index; Using temporary; Using filesort | 1 | SIMPLE | zone_template | eq_ref | PRIMARY,code | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.zone_template_2_stats_league.zone_template_id | 1 | Using where | 1 | SIMPLE | zone | ref | zone_template_id_zone_position_id,zone_template_id | zone_template_id_zone_position_id | 4 | test_dev_nhlcz_s6_esports_cz.zone_template_2_stats_league.zone_template_id | 17 | | 1 | SIMPLE | zone_position | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.zone.zone_position_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:185 | 0 |