soutěž | klub | z | g | a | b | +/- | + | - | tm | gv | gp | go | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-2021 | Tipsport extraliga | HC VERVA Litvínov | 52 | 12 | 6 | 18 | 4 | 44 | 40 | 62 | 2 | 5 | 0 | |
Generali Česká Cup | HC VERVA Litvínov | 2 | 0 | 0 | 0 | 1 | 3 | 2 | 0 | 0 | 0 | 0 | ||
Generali Česká Cup – sk. B | HC VERVA Litvínov | 2 | 0 | 0 | 0 | 1 | 3 | 2 | 0 | 0 | 0 | 0 | ||
Generali Česká Cup – play off | HC VERVA Litvínov | 2 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | ||
Generali Česká pojišťovna play off | HC VERVA Litvínov | 3 | 0 | 0 | 0 | -4 | 0 | 4 | 2 | 0 | 0 | 0 | ||
2021-2022 | Tipsport extraliga | HC VERVA Litvínov | 52 | 10 | 15 | 25 | -12 | 41 | 53 | 34 | 1 | 4 | 0 | |
2023-2024 | Tipsport extraliga | HC Sparta Praha | 49 | 6 | 10 | 16 | 13 | 45 | 32 | 36 | 1 | 3 | 0 | |
soutěž | klub | z | g | a | b | +/- | + | - | tm | gv | gp | go | ||
Vše | Extraliga | 2 klub | 160 | 28 | 31 | 59 | 1 | 133 | 132 | 134 | 4 | 12 | 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.071 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.089 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` = '318533')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.215 explain | SELECT `id`, `name`, `surname` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '318533')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.264 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '318533')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.522 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` = '318533') ORDER BY .`stats_competition`.`season` DESC, IFNULL(.`league`.`rank`, 9223372036854775807), .`stats_competition`.`priority` DESC LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.380 explain | SELECT `id`, `stats_team_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` WHERE (`stats_player_id` = '318533') 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
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.630 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` IN (8))
| 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` = '318533')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.193 explain | SELECT `id`, `code`, `name` FROM `test_dev_nhlcz_s6_esports_cz`.`country` WHERE (`id` IN (4))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.098 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` = '318533') ORDER BY .`stats_competition`.`season` DESC, IFNULL(.`league`.`rank`, 9223372036854775807), .`stats_competition`.`priority` DESC LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.072 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '318533')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.392 explain | SELECT `id`, `stats_team_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` WHERE (`stats_player_id` = '318533') 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
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.886 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` IN (8))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
15.944 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.`value` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 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 (`stats_team_home_id` IN (8) OR `stats_team_guest_id` IN (8)) AND (DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) >= CURDATE()) AND (`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`bet_type_code` = 'link') ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` ASC LIMIT 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.509 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` = '318533') 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
| 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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` = '318533')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.044 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '318533')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.044 explain | SELECT `id`, `position` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '318533')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.381 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` = '318533') 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
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.470 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` = '318533') AND (`competition`.`season` = 2020) 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.526 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` = '318533') AND (`stats_competition_id` = 6630)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.481 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` = '318533') AND (`team`.`id` = 823) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6630)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.354 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` = '318533') AND (`stats_competition_id` = 6630) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.494 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` = '318533') AND (`stats_competition_id` = 6633)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.049 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` = '318533') AND (`team`.`id` = 823) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6633)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.249 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` = '318533') AND (`stats_competition_id` = 6633) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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_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` = '318533') AND (`stats_competition_id` = 6638)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.785 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` = '318533') AND (`team`.`id` = 823) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6638)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.276 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` = '318533') AND (`stats_competition_id` = 6638) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.513 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` = '318533') AND (`stats_competition_id` = 6689)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.475 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` = '318533') AND (`team`.`id` = 823) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6689)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.268 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` = '318533') AND (`stats_competition_id` = 6689) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.395 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` = '318533') AND (`competition`.`season` = 2021) 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`
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.940 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` = '318533') AND (`stats_competition_id` = 6705)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.643 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` = '318533') AND (`team`.`id` = 823) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6705)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.418 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` = '318533') AND (`stats_competition_id` = 6705) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.599 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` = '318533') AND (`competition`.`season` = 2023) 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`
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.691 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` = '318533') AND (`stats_competition_id` = 7071)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.621 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` = '318533') AND (`team`.`id` = 8) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 7071)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.339 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` = '318533') AND (`stats_competition_id` = 7071) GROUP BY `stats_competition_id` HAVING COUNT(*) > 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.974 explain | SELECT `competition`.`name` AS `competition`, `competition`.`league_id`, COUNT(DISTINCT `team`.`stats_club_id`) AS `clubs`, 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`, `league`.`name` AS `league`, `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_category` AS `category` ON `competition`.`stats_category_id` = `category`.`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_team` AS `team` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` WHERE (`summary` = 0) AND (`stats_player_id` = '318533') AND (`competition`.`statistics_visible` = 1) AND (`competition`.`league_id` IS NOT NULL) AND (`competition`.`repre` = 0) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) GROUP BY `competition`.`league_id`, `category`.`type` = 'barg' ORDER BY `league`.`rank` ASC, `isBarage`
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.843 explain | SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS `nameTitle`, IF(`post`.`photo_id` IS NOT NULL, ( SELECT `photo`.`url` FROM `photo` WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, ( SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` FROM `file` WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` FROM `post` LEFT JOIN `post_2_stats_player` ON `post`.`id` = `post_2_stats_player`.`post_id` WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <= NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND `post`.`unpublish_date` >= NOW())) AND (`post_2_stats_player`.`stats_player_id` = '318533') ORDER BY `publish_date` DESC LIMIT 4
| 0 |
no identity
https://test.nhlcz.s6.esports.cz/hrac/318533?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.086 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17 | 0 | ||||||||||||||||||||
0.221 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` = '318533')
| 1 |
no identity
https://test.nhlcz.s6.esports.cz/hrac/318533?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