soutěž | klub | z | g | a | b | +/- | + | - | tm | gv | gp | go | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2007-2008 | ELJ – play out | J Mladá Boleslav | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
ELD | D Mladá Boleslav | 46 | 20 | 13 | 33 | 2 | 41 | 39 | 62 | 3 | 4 | 0 | ||
ELD – play off | D Mladá Boleslav | 3 | 0 | 1 | 1 | 1 | 2 | 1 | 2 | 0 | 0 | 0 | ||
2008-2009 | ELJ | J Mladá Boleslav | 26 | 5 | 2 | 7 | 5 | 12 | 7 | 10 | 0 | 0 | 0 | |
ELJ – play off | J Mladá Boleslav | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
2009-2010 | O2 extraliga – o umístění | BK Mladá Boleslav | 1 | 0 | 0 | 0 | -2 | 0 | 2 | 0 | 0 | 0 | 0 | |
Noen ELJ | J Mladá Boleslav | 50 | 12 | 17 | 29 | 12 | 34 | 22 | 60 | 0 | 2 | 0 | ||
Noen ELJ – Z | J Mladá Boleslav | 20 | 3 | 3 | 6 | 3 | 10 | 7 | 14 | 0 | 0 | 0 | ||
Noen ELJ II – Z – A | J Mladá Boleslav | 10 | 4 | 3 | 7 | 1 | 7 | 6 | 10 | 0 | 1 | 0 | ||
Noen ELJ III – A | J Mladá Boleslav | 20 | 5 | 11 | 16 | 8 | 17 | 9 | 36 | 0 | 1 | 0 | ||
Noen ELJ – play off | J Mladá Boleslav | 3 | 0 | 1 | 1 | -1 | 1 | 2 | 0 | 0 | 0 | 0 | ||
2010-2011 | Tipsport extraliga – o umístění | BK Mladá Boleslav | 4 | 0 | 1 | 1 | -2 | 1 | 3 | 0 | 0 | 0 | 0 | |
Tipsport extraliga | BK Mladá Boleslav | 1 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | ||
Baráž o extraligu | BK Mladá Boleslav | 4 | 0 | 0 | 0 | -3 | 0 | 3 | 0 | 0 | 0 | 0 | ||
Noen ELJ | J Mladá Boleslav | 48 | 39 | 26 | 65 | 31 | 66 | 35 | 54 | 6 | 14 | 1 | ||
Noen ELJ – I. část | J Mladá Boleslav | 38 | 31 | 17 | 48 | 21 | 49 | 28 | 46 | 6 | 11 | 1 | ||
Noen ELJ – II. část – B | J Mladá Boleslav | 10 | 8 | 9 | 17 | 10 | 17 | 7 | 8 | 0 | 3 | 0 | ||
2011-2012 | Tipsport extraliga – o umístění | BK Mladá Boleslav | 3 | 0 | 1 | 1 | 1 | 1 | 0 | 2 | 0 | 0 | 0 | |
Tipsport extraliga | BK Mladá Boleslav | 12 | 0 | 0 | 0 | -1 | 0 | 1 | 2 | 0 | 0 | 0 | ||
Baráž o extraligu | BK Mladá Boleslav | 1 | 0 | 0 | 0 | -2 | 0 | 2 | 0 | 0 | 0 | 0 | ||
1. liga | HC Stadion Litoměřice | 26 | 7 | 7 | 14 | 6 | 18 | 12 | 18 | 0 | 0 | 0 | ||
1. liga - O baráž | HC Stadion Litoměřice | 4 | 2 | 3 | 5 | 3 | 4 | 1 | 0 | 0 | 2 | 0 | ||
Noen ELJ | J Mladá Boleslav | 15 | 4 | 8 | 12 | 8 | 12 | 4 | 22 | 1 | 1 | 0 | ||
Noen ELJ – Z | J Mladá Boleslav | 14 | 4 | 8 | 12 | 9 | 12 | 3 | 22 | 1 | 1 | 0 | ||
Noen ELJ II | J Mladá Boleslav | 1 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | ||
2012-2013 | 1. liga - O baráž | HC Berounští Medvědi | 8 | 4 | 6 | 10 | -6 | 6 | 12 | 2 | 1 | 2 | 0 | |
1. liga | HC Berounští Medvědi | 17 | 6 | 6 | 12 | -3 | 12 | 15 | 10 | 2 | 0 | 0 | ||
1. liga | BK Mladá Boleslav | 28 | 3 | 3 | 6 | 9 | 11 | 2 | 22 | 0 | 0 | 0 | ||
1. liga | Celkem | 45 | 9 | 9 | 18 | 6 | 23 | 17 | 32 | 2 | 0 | 0 | ||
2. liga | NED Hockey Nymburk | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
2. liga - S | NED Hockey Nymburk | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
Noen ELJ | J Mladá Boleslav | 1 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | ||
Noen ELJ – I. část | J Mladá Boleslav | 1 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | ||
2013-2014 | Tipsport extraliga | HC ČSOB Pojišťovna Pardubice | 1 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | |
Baráž o extraligu | BK Mladá Boleslav | 11 | 2 | 0 | 2 | -1 | 7 | 8 | 6 | 0 | 0 | 0 | ||
1. liga | BK Mladá Boleslav | 51 | 16 | 16 | 32 | 17 | 30 | 13 | 74 | 1 | 2 | 2 | ||
1. liga - play off | BK Mladá Boleslav | 8 | 1 | 1 | 2 | 1 | 2 | 1 | 31 | 0 | 0 | 0 | ||
2014-2015 | Česká pojišťovna play off | BK Mladá Boleslav | 9 | 1 | 1 | 2 | -1 | 4 | 5 | 2 | 1 | 0 | 0 | |
Tipsport extraliga | BK Mladá Boleslav | 52 | 9 | 11 | 20 | -7 | 28 | 35 | 42 | 1 | 2 | 0 | ||
1. liga | HC Dukla Jihlava | 1 | 1 | 1 | 2 | 0 | 1 | 1 | 2 | 1 | 0 | 0 | ||
2015-2016 | Česká pojišťovna play off | BK Mladá Boleslav | 10 | 2 | 4 | 6 | 0 | 6 | 6 | 40 | 0 | 1 | 0 | |
Tipsport extraliga | BK Mladá Boleslav | 47 | 16 | 12 | 28 | 24 | 35 | 11 | 28 | 4 | 1 | 2 | ||
2016-2017 | Generali play off | BK Mladá Boleslav | 5 | 1 | 0 | 1 | -1 | 3 | 4 | 0 | 0 | 0 | 0 | |
Tipsport extraliga | BK Mladá Boleslav | 51 | 16 | 14 | 30 | 9 | 35 | 26 | 50 | 1 | 8 | 1 | ||
2017-2018 | Tipsport extraliga – o umístění | BK Mladá Boleslav | 3 | 1 | 2 | 3 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | |
Tipsport extraliga | BK Mladá Boleslav | 52 | 10 | 10 | 20 | -8 | 26 | 34 | 32 | 2 | 3 | 0 | ||
2018-2019 | Generali play off | Bílí Tygři Liberec | 17 | 3 | 2 | 5 | 4 | 9 | 5 | 2 | 1 | 0 | 0 | |
Tipsport extraliga | Bílí Tygři Liberec | 52 | 16 | 17 | 33 | 4 | 31 | 27 | 30 | 4 | 8 | 0 | ||
2019-2020 | Tipsport extraliga | Bílí Tygři Liberec | 49 | 21 | 18 | 39 | 5 | 32 | 27 | 14 | 3 | 8 | 1 | |
2020-2021 | Generali Česká Cup | Bílí Tygři Liberec | 6 | 2 | 1 | 3 | -2 | 3 | 5 | 0 | 1 | 1 | 0 | |
Generali Česká Cup – sk. B | Bílí Tygři Liberec | 6 | 2 | 1 | 3 | -2 | 3 | 5 | 0 | 1 | 1 | 0 | ||
Generali Česká Cup – play off | Bílí Tygři Liberec | 2 | 2 | 2 | 4 | 2 | 4 | 2 | 4 | 0 | 0 | 0 | ||
Generali Česká pojišťovna play off | Bílí Tygři Liberec | 16 | 2 | 12 | 14 | 0 | 10 | 10 | 4 | 0 | 0 | 0 | ||
Tipsport extraliga | Bílí Tygři Liberec | 51 | 19 | 22 | 41 | 13 | 47 | 34 | 30 | 1 | 3 | 0 | ||
soutěž | klub | z | g | a | b | +/- | + | - | tm | gv | gp | go | ||
Vše | Extraliga | 3 klub | 444 | 121 | 130 | 251 | 38 | 277 | 239 | 284 | 19 | 35 | 4 | |
Baráž o extraligu | 1 klub | 16 | 2 | 0 | 2 | -6 | 7 | 13 | 6 | 0 | 0 | 0 | ||
CHANCE LIGA | 4 klub | 143 | 40 | 43 | 83 | 27 | 84 | 57 | 159 | 5 | 6 | 2 | ||
2. liga | 1 klub | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
DHL extraliga juniorů | 1 klub | 146 | 60 | 54 | 114 | 54 | 125 | 71 | 146 | 7 | 17 | 1 | ||
Extraliga dorostu | 1 klub | 49 | 20 | 14 | 34 | 3 | 43 | 40 | 64 | 3 | 4 | 0 |
soutěž | klub | z | g | a | b | +/- | + | - | tm | gv | gp | go | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016-2017 | Reprezentace A | Česko | 8 | 2 | 1 | 3 | 1 | 4 | 3 | 2 | 0 | 0 | 0 | |
Karjala Cup 2016 | Česko | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ||
Švédské hokejové hry 2017 | Česko | 2 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||
Euro Hockey Challenge | Česko | 4 | 1 | 1 | 2 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | ||
2017-2018 | Reprezentace A | Česko | 2 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |
Reprezentace – příp. | Česko | 2 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||
2018-2019 | Reprezentace A | Česko | 8 | 1 | 0 | 1 | -6 | 2 | 8 | 0 | 0 | 0 | 0 | |
Beijer Hockey Games 2019 | Česko | 3 | 0 | 0 | 0 | -1 | 1 | 2 | 0 | 0 | 0 | 0 | ||
Channel One Cup 2018 | Česko | 3 | 1 | 0 | 1 | -2 | 1 | 3 | 0 | 0 | 0 | 0 | ||
Karjala Cup 2018 | Česko | 2 | 0 | 0 | 0 | -3 | 0 | 3 | 0 | 0 | 0 | 0 | ||
2019-2020 | Reprezentace A | Česko | 5 | 0 | 0 | 0 | -6 | 0 | 6 | 2 | 0 | 0 | 0 | |
Beijer Hockey Games 2020 | Česko | 2 | 0 | 0 | 0 | -3 | 0 | 3 | 2 | 0 | 0 | 0 | ||
Channel One Cup 2019 | Česko | 3 | 0 | 0 | 0 | -3 | 0 | 3 | 0 | 0 | 0 | 0 | ||
2020-2021 | Reprezentace A | Česko | 18 | 4 | 4 | 8 | 3 | 11 | 8 | 14 | 0 | 2 | 0 | |
Karjala Cup 2020 | Česko | 2 | 0 | 1 | 1 | 1 | 1 | 0 | 4 | 0 | 0 | 0 | ||
Channel One Cup 2020 | Česko | 3 | 1 | 2 | 3 | 3 | 4 | 1 | 2 | 0 | 0 | 0 | ||
Beijer Hockey Games 2021 | Česko | 3 | 2 | 1 | 3 | -2 | 2 | 4 | 2 | 0 | 2 | 0 | ||
MS 2021 | Česko | 6 | 1 | 0 | 1 | 2 | 3 | 1 | 4 | 0 | 0 | 0 | ||
Reprezentace – příp. | Česko | 2 | 0 | 0 | 0 | -1 | 0 | 1 | 2 | 0 | 0 | 0 | ||
České hokejové hry 2021 | Česko | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||
2021-2022 | Reprezentace A | Česko | 4 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | |
OH 2022 | Česko | 4 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | ||
2022-2023 | Reprezentace A | Česko | 13 | 4 | 5 | 9 | 7 | 7 | 0 | 6 | 0 | 2 | 0 | |
Karjala Cup 2022 | Česko | 3 | 2 | 2 | 4 | 3 | 3 | 0 | 2 | 0 | 1 | 0 | ||
Euro Hockey Challenge 2023 | Česko | 5 | 2 | 3 | 5 | 4 | 4 | 0 | 0 | 0 | 1 | 0 | ||
České hokejové hry 2023 | Česko | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
MS 2023 | Česko | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | ||
2023-2024 | Reprezentace A | Česko | 5 | 3 | 2 | 5 | 3 | 5 | 2 | 0 | 0 | 1 | 0 | |
Karjala Cup 2023 | Česko | 3 | 3 | 2 | 5 | 2 | 4 | 2 | 0 | 0 | 1 | 0 | ||
Swiss Ice Hockey Games 2023 | Česko | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ||
soutěž | z | g | a | b | +/- | + | - | tm | gv | gp | go | |||
Vše | Reprezentační zápasy mužů | 63 | 14 | 13 | 27 | 1 | 30 | 29 | 24 | 0 | 5 | 0 |
ISSN 1214-5718 | dotazy na redakci: redakce@nhl.cz, obchod/reklama: obchod@hokej.cz, technický provoz: webmaster@hokej.cz
© Copyright - Všechna loga a známky NHL, loga a známky týmů NHL, jakožto další vlastnické materiály včetně log konferencí a obrázků Stanley Cupu jsou vlastnictvím NHL, NHL Enterprises, L.P. a příslušných týmů. © NHL Enterprises, L.P. Všechna práva vyhrazena.
Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.065 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.071 explain | SELECT `id`, `name`, `surname`, `country_id`, `photo`, `date_of_birth`, `height`, `weight`, `position`, `stick` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
27.450 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` = `league`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`match_bet` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` WHERE (DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) = CURDATE()) AND (`league`.`code` = 'nhl') AND (`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` IS NOT NULL) LIMIT 100
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.353 explain | SELECT `id`, `name`, `surname` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.500 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.620 explain | SELECT `competition`.`id` AS `competition_id`, `competition`.`name`, `competition`.`league_id`, `sea`.`name` AS `season`, `lea`.`code` AS `leagueCode`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`league_id` = `league`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `lea` ON `competition`.`league_id` = `lea`.`id` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') ORDER BY .`stats_competition`.`season` DESC, IFNULL(.`league`.`rank`, 9223372036854775807), .`stats_competition`.`priority` DESC LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.419 explain | SELECT `id`, `stats_team_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` WHERE (`stats_player_id` = '12586') AND (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` < NOW()) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` > NOW() OR UNIX_TIMESTAMP(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to`) <= 0 OR `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` IS NULL) ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` DESC
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.464 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`, `club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`, `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`, `club`.`id` `clubId` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IS NULL AND FALSE)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.052 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.066 explain | SELECT `id`, `code`, `name` FROM `test_dev_nhlcz_s6_esports_cz`.`country` WHERE (`id` IN (1))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.068 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.436 explain | SELECT `id`, `stats_team_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` WHERE (`stats_player_id` = '12586') AND (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` < NOW()) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` > NOW() OR UNIX_TIMESTAMP(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to`) <= 0 OR `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` IS NULL) ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` DESC
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.416 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`, `club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`, `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IS NULL AND FALSE)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.207 explain | SELECT DISTINCT `sea`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`competition`.`repre` = 0) AND (`competition`.`statistics_visible` = 1) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) ORDER BY `sea`.`year` ASC
| 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.069 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.067 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.074 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.074 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.056 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.048 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.068 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.049 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.049 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.042 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.039 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.060 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.035 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.039 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.849 explain | SELECT DISTINCT `sea`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`competition`.`repre` = 1) AND (`competition`.`statistics_visible` = 1) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) ORDER BY `sea`.`year` ASC
| 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.061 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.061 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.059 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.067 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.066 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.074 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.067 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.066 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.859 explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` = `league`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON `competition`.`stats_category_id` = `category`.`id` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`competition`.`season` = 2007) AND (`competition`.`statistics_visible` = 1) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND (`competition`.`repre` = 0) ORDER BY `league`.`rank` ASC, `isBarage`
| 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.609 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 686)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.585 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 236) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 686)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.404 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 686) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.747 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 640)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.549 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 203) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 640)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.257 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 640) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.706 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 684)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.543 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 203) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 684)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.351 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 684) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.618 explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` = `league`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON `competition`.`stats_category_id` = `category`.`id` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`competition`.`season` = 2008) AND (`competition`.`statistics_visible` = 1) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND (`competition`.`repre` = 0) ORDER BY `league`.`rank` ASC, `isBarage`
| 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.514 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 714)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.575 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 236) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 714)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.316 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 714) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.581 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 744)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.596 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 236) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 744)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.273 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 744) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.661 explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` = `league`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON `competition`.`stats_category_id` = `category`.`id` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`competition`.`season` = 2009) AND (`competition`.`statistics_visible` = 1) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND (`competition`.`repre` = 0) ORDER BY `league`.`rank` ASC, `isBarage`
| 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.484 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 763)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.434 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 89) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 763)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.274 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 763) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.470 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 819)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.168 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 236) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 819)
| 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.251 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 819) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.445 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 865)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.540 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 236) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 865)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.266 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 865) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.656 explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` = `league`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON `competition`.`stats_category_id` = `category`.`id` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`competition`.`season` = 2010) AND (`competition`.`statistics_visible` = 1) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND (`competition`.`repre` = 0) ORDER BY `league`.`rank` ASC, `isBarage`
| 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.671 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 878)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.641 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 89) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 878)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.375 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 878) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.678 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 877)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.932 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 89) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 877)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.410 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 877) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.807 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 885)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.800 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 89) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 885)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.333 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 885) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.561 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 959)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.812 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 236) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 959)
| 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.356 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 959) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.726 explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` = `league`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON `competition`.`stats_category_id` = `category`.`id` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`competition`.`season` = 2011) AND (`competition`.`statistics_visible` = 1) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND (`competition`.`repre` = 0) ORDER BY `league`.`rank` ASC, `isBarage`
| 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.604 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 991)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.473 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 89) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 991)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.387 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 991) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.574 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 990)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.535 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 89) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 990)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.316 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 990) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.516 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 994)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.456 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 89) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 994)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.434 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 994) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.480 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 992)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.435 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 500) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 992)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.482 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 992) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.639 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 1115)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.474 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 500) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1115)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.506 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 1115) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.663 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 1015)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.889 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 236) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1015)
| 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.282 explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 1015) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.241 explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` = `league`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON `competition`.`stats_category_id` = `category`.`id` WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`competition`.`season` = 2012) AND (`competition`.`statistics_visible` = 1) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND (`competition`.`repre` = 0) ORDER BY `league`.`rank` ASC, `isBarage`
| 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.674 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`stats_competition_id` = 1136)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.768 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id` AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id` `competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND (`competition`.`id` IS NOT NULL) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC LIMIT 1)) WHERE (`summary` = 0) AND (`stats_player_id` = '12586') AND (`team`.`id` = 26) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1136)
| 0 |
...and more
no identity
https://test.nhlcz.s6.esports.cz/hrac/12586?stats-section=club
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
test/<presenter>/<action>[/<id>] |
module = Test |
Test |
|
no | Route |
<module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] |
action = default |
Export |
|
no | Route |
admin/<module>/<presenter>/<action>[/<id>] |
module = Dashboard |
Admin |
|
yes | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
Front:Player:Overview:default |
no | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
|
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
may | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
Front:Article:Article:default |
no | ArticleCompatRoute |
<slug [a-zA-Z-0-9\-]+> |
module = Article |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] |
module = League |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> |
module = MinorLeague |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] |
module = League |
Front |
|
no | Route |
<module>/<presenter>/<action>[/<id>] |
id = |
Front |
Front\Player\OverviewPresenter::renderDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:22
Time ms | SQL Query | Rows | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.055 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17 | 0 | ||||||||||||||||||||
0.267 explain | SELECT `id`, `name`, `surname`, `country_id`, `photo`, `date_of_birth`, `height`, `weight`, `position`, `stick` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '12586')
| 1 |
no identity
https://test.nhlcz.s6.esports.cz/hrac/12586?do=stats-section&stats-section=club
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
test/<presenter>/<action>[/<id>] |
module = Test |
Test |
|
no | Route |
<module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] |
action = default |
Export |
|
no | Route |
admin/<module>/<presenter>/<action>[/<id>] |
module = Dashboard |
Admin |
|
yes | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
Front:Player:Overview:default |
no | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
|
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
may | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
Front:Article:Article:default |
no | ArticleCompatRoute |
<slug [a-zA-Z-0-9\-]+> |
module = Article |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] |
module = League |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> |
module = MinorLeague |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] |
module = League |
Front |
|
no | Route |
<module>/<presenter>/<action>[/<id>] |
id = |
Front |
Front\Player\OverviewPresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:8