bahis siteleri

NHL.cz na Facebooku

ROBIN SAPOUŠEK

narozen

11.3.2004

výška

184 cm

věk

20 let

váha

67 kg

post

útočník

hůl

levá

Reprezentace 20 (celá sezona) 2023-2024

zápasů 12  
gólů 5  
asistencí 4  
bodů 9  
± body 0  
tm 14  

Celá kariéra

soutěž klub z g a b +/- + - tm gv gp go
2016-2017 Mládežnické MČR krajů 2017 Karlovarský kraj 3 1 0 1 -1 1 2 0 0 0 0
Mládežnické MČR krajů 2017 – sk. Karlovarský kraj 3 1 0 1 -1 1 2 0 0 0 0
2017-2018 Olympiáda dětí a mládeže Karlovarský kraj 6 3 3 6 0 0 0 1 0 0 0
Olympiáda dětí a mládeže – sk. B Karlovarský kraj 6 3 3 6 0 0 0 1 0 0 0
ELIOD ELMD MD Karlovy Vary 12 1 2 3 2 5 3 12 0 0 0
ELIOD ELMD – Z MD Karlovy Vary 3 1 1 2 3 3 0 0 0 0 0
ELIOD ELMD – 2. část – sk. C MD Karlovy Vary 9 0 1 1 -1 2 3 12 0 0 0
Turnaje výběrů VTM U14 Výběr 14 Západ 4 0 0 0 -5 1 6 0 0 0 0
Turnaj výběrů VTM U14 I Výběr 14 Západ 2 0 0 0 -5 1 6 0 0 0 0
Turnaj výběrů VTM U14 II Výběr 14 Západ 2 0 0 0 0 0 0 0 0 0 0
2018-2019 ELIOD ELD D Karlovy Vary 33 14 11 25 -6 30 36 30 3 3 1
ELIOD ELD – Z D Karlovy Vary 14 5 4 9 -8 11 19 4 1 3 0
ELIOD ELD – 2. část – C D Karlovy Vary 19 9 7 16 2 19 17 26 2 0 1
Mládežnické MČR krajů 2019 Karlovarský kraj 6 3 1 4 0 0 0 2 2 0 0
Mládežnické MČR krajů 2019 – sk. A Karlovarský kraj 6 3 1 4 0 0 0 2 2 0 0
Turnaj výběrů VTM U15 Výběr 15 Západ 2 2 1 3 2 3 1 0 1 0 0
2019-2020 ELIOD ELD D Karlovy Vary 39 19 15 34 10 41 31 16 1 6 0
ELIOD ELD – Západ D Karlovy Vary 16 13 6 19 10 20 10 6 1 5 0
ELIOD ELD – o pořadí v play off D Karlovy Vary 23 6 9 15 0 21 21 10 0 1 0
2020-2021 Tipsport extraliga HC Energie Karlovy Vary 2 0 0 0 -1 0 1 0 0 0 0
ELD D Karlovy Vary 5 4 5 9 6 10 4 4 2 0 0
ELD – Západ D Karlovy Vary 5 4 5 9 6 10 4 4 2 0 0
JLA J Karlovy Vary 9 2 2 4 -3 6 9 2 1 0 0
JLA – z.č. J Karlovy Vary 9 2 2 4 -3 6 9 2 1 0 0
2021-2022 DHL ELJ J Karlovy Vary 20 5 8 13 6 21 15 18 0 1 0
DHL ELJ – z. č. J Karlovy Vary 11 3 5 8 7 14 7 10 0 1 0
DHL ELJ – o účast v play off B J Karlovy Vary 9 2 3 5 -1 7 8 8 0 0 0
DHL ELJ – play off J Karlovy Vary 4 0 1 1 1 2 1 0 0 0 0
2022-2023 Tipsport extraliga HC Energie Karlovy Vary 12 0 0 0 -3 2 5 0 0 0 0
DHL ELJ J Karlovy Vary 21 15 14 29 9 22 13 12 0 6 1
soutěž klub z g a b +/- + - tm gv gp go
Vše Extraliga 1 klub 14 0 0 0 -4 2 6 0 0 0 0
DHL extraliga juniorů 1 klub 45 20 23 43 16 45 29 30 0 7 1
Extraliga dorostu 1 klub 77 37 31 68 10 81 71 50 6 9 1
Mládežnické MČR krajů 1 klub 15 7 4 11 -1 1 2 3 2 0 0
Juniorská liga akademií 1 klub 9 2 2 4 -3 6 9 2 1 0 0
Extraliga mladšího dorostu 1 klub 12 1 2 3 2 5 3 12 0 0 0
Turnaje výběrů VTM 2 klub 6 2 1 3 -3 4 7 0 1 0 0

Reprezentační kariéra

soutěž klub z g a b +/- + - tm gv gp go
2019-2020 Reprezentace 16 (celá sezona) Česko 16 14 1 5 6 2 2 0 2 0 0 1
Reprezentace 16 – příp. Česko 16 7 1 2 3 2 2 0 0 0 0 1
Wolfgang Rud Cup – 16 Česko 16 4 0 3 3 0 0 0 0 0 0 0
Turnaj čtyř v Göteborgu – 16 Česko 16 3 0 0 0 0 0 0 2 0 0 0
2020-2021 Reprezentace 17 (celá sezona) Česko 17 3 0 0 0 0 0 0 0 0 0 0
Reprezentace 17 – příp. Česko 17 3 0 0 0 0 0 0 0 0 0 0
2021-2022 Reprezentace 18 (celá sezona) Česko 18 24 3 5 8 -1 8 9 10 0 0 1
Reprezentace 18 – příp. Česko 18 10 2 2 4 2 5 3 2 0 0 1
Hlinka Gretzky Cup Česko 18 4 0 1 1 -1 2 3 4 0 0 0
Chablais Hockey Trophy – 18 Česko 18 4 1 2 3 0 0 0 0 0 0 0
MS 18 – 2022 Česko 18 6 0 0 0 -2 1 3 4 0 0 0
2022-2023 Reprezentace 20 (celá sezona) Česko 20 11 1 3 4 -2 1 3 2 0 0 0
Turnaj čtyř v Rovaniemi – 20 Česko 20 2 1 1 2 0 0 0 2 0 0 0
Turnaj pěti v Porubě – 20 Česko 20 3 0 0 0 -2 1 3 0 0 0 0
Reprezentace 20 – příp. Česko 20 2 0 1 1 0 0 0 0 0 0 0
MS 20 – 2023 Česko 20 4 0 1 1 0 0 0 0 0 0 0
2023-2024 Reprezentace 20 (celá sezona) Česko 20 12 5 4 9 0 0 0 14 0 0 0
Reprezentace 20 – příp. Česko 20 5 2 2 4 0 0 0 10 0 0 0
Turnaj pěti v Nyköpingu – 20 Česko 20 3 1 1 2 0 0 0 0 0 0 0
MS 20 – 2024 Česko 20 4 2 1 3 0 0 0 4 0 0 0
soutěž z g a b +/- + - tm gv gp go
Vše Reprezentace U20 64 10 17 27 -1 11 12 28 0 0 2
RSS | Kontakt | Všeobecné obchodní podmínky a pravidla | Cookies | Nastavení soukromí | Reklama - Provozovatel BPA sport marketing a.s. ve spolupráci s eSports, s.r.o.

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.

 

Queries: 96, time: 61.007 ms, default

Time msSQL QueryRows
0.073
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17
0
0.092
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` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.213
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.165
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
1.462
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` = '10082779') 
ORDER BY .`stats_competition`.`season` DESC, IFNULL(.`league`.`rank`, 9223372036854775807),
.`stats_competition`.`priority` DESC 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1fk_stats_players_stats_player15const121Using where; Using temporary; Using filesort
1SIMPLEstats_competitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.league_id1
1SIMPLEcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1
1SIMPLEseaeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.season1
1SIMPLEleaeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:59
1
0.418
explain
SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '10082779') 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_teamreffk_stats_player_2_team_stats_player1fk_stats_player_2_team_stats_player15const13Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268
0
0.408
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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYImpossible WHERE
4DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id1Using where; Using filesort
3DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:133
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` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.227
explain
SELECT `id`, `code`, `name` 
FROM `test_dev_nhlcz_s6_esports_cz`.`country` 
WHERE (`id` IN (1))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcountryconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Player-templates-Overview-default-latte-f9f4e0ca40eb66803765d76f0f9a91f6.php:37
1
0.065
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.475
explain
SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '10082779') 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_teamreffk_stats_player_2_team_stats_player1fk_stats_player_2_team_stats_player15const13Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268
0
0.500
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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYImpossible WHERE
4DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id1Using where; Using filesort
3DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/components/Stats.php:87
0
0.970
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` = '10082779') 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEseaeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.season1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:89
7
0.046
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.041
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
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` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
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` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.051
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.038
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
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` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.603
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` = '10082779') 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEseaeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.season1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:113
5
0.040
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.032
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.033
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.033
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.031
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.626
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` = '10082779') AND (`competition`.`season` = 2016) 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`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
1
0.523
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` = '10082779') AND (`stats_competition_id` = 5989)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
1.012
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` = '10082779') AND (`team`.`id` = 1101) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5989)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
1
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` = '10082779') AND (`stats_competition_id` = 5989) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.657
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` = '10082779') AND (`competition`.`season` = 2017) 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`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
3
0.545
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` = '10082779') AND (`stats_competition_id` = 6186)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
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` = '10082779') AND (`team`.`id` = 1101) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6186)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
1
0.392
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` = '10082779') AND (`stats_competition_id` = 6186) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.522
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` = '10082779') AND (`stats_competition_id` = 6158)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
1.110
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` = '10082779') AND (`team`.`id` = 597) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6158)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
2
0.341
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` = '10082779') AND (`stats_competition_id` = 6158) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.657
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` = '10082779') AND (`stats_competition_id` = 6234)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
1.035
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` = '10082779') AND (`team`.`id` = 2705) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6234)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
2
0.304
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` = '10082779') AND (`stats_competition_id` = 6234) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.644
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` = '10082779') AND (`competition`.`season` = 2018) 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`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
3
0.541
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` = '10082779') AND (`stats_competition_id` = 6244)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
1.664
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` = '10082779') AND (`team`.`id` = 184) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6244)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
2
0.255
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` = '10082779') AND (`stats_competition_id` = 6244) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.556
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` = '10082779') AND (`stats_competition_id` = 6408)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
0.916
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` = '10082779') AND (`team`.`id` = 1101) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6408)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
1
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` = '10082779') AND (`stats_competition_id` = 6408) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.722
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` = '10082779') AND (`stats_competition_id` = 6469)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
0.589
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` = '10082779') AND (`team`.`id` = 2702) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6469)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition15const1Using where
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id16const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
0
0.352
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` = '10082779') AND (`stats_competition_id` = 6469) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.679
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` = '10082779') AND (`competition`.`season` = 2019) 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`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
1
0.521
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` = '10082779') AND (`stats_competition_id` = 6511)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
5.741
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` = '10082779') AND (`team`.`id` = 184) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6511)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
2
0.412
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` = '10082779') AND (`stats_competition_id` = 6511) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.829
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` = '10082779') 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`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcompetitionrefPRIMARY,sezonasezona4const71Using where; Using temporary; Using filesort
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,test_dev_nhlcz_s6_esports_cz.competition.id1Using where; Using index
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
3
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` = '10082779') AND (`stats_competition_id` = 6630)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
0.651
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` = '10082779') AND (`team`.`id` = 5) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6630)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition15const1Using where
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id16const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
0
0.371
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` = '10082779') AND (`stats_competition_id` = 6630) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.628
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` = '10082779') AND (`stats_competition_id` = 6639)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
1.695
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` = '10082779') AND (`team`.`id` = 184) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6639)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
1
0.346
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` = '10082779') AND (`stats_competition_id` = 6639) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.565
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` = '10082779') AND (`stats_competition_id` = 6643)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
0.573
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` = '10082779') AND (`team`.`id` = 173) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6643)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition15const1Using where
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id16const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
1
0.267
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` = '10082779') AND (`stats_competition_id` = 6643) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.530
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` = '10082779') 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`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
2
0.522
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` = '10082779') AND (`stats_competition_id` = 6697)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
1.813
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` = '10082779') AND (`team`.`id` = 173) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6697)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
2
0.258
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` = '10082779') AND (`stats_competition_id` = 6697) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.545
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` = '10082779') AND (`stats_competition_id` = 6703)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
0.553
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` = '10082779') AND (`team`.`id` = 173) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6703)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition15const1Using where
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id16const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
0
0.347
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` = '10082779') AND (`stats_competition_id` = 6703) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.569
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` = '10082779') AND (`competition`.`season` = 2022) 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`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
2
0.472
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` = '10082779') AND (`stats_competition_id` = 6877)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
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_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` = '10082779') AND (`team`.`id` = 5) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6877)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition15const1Using where
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id16const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
0
0.259
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` = '10082779') AND (`stats_competition_id` = 6877) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
0.502
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` = '10082779') AND (`stats_competition_id` = 6887)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
0.602
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` = '10082779') AND (`team`.`id` = 173) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6887)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition15const1Using where
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id16const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
0
0.405
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` = '10082779') AND (`stats_competition_id` = 6887) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219
0
1.520
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` = '10082779') 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`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player15const121Using where; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,league_idPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/test-app-Front-Player-components-stats-latte-ff3adcf960ce4b422889acb793ea93d0.php:136
7
0.725
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` = '10082779') AND (`competition`.`season` = 2019) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 1) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
1
0.503
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` = '10082779') AND (`stats_competition_id` = 6527)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
1.675
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` = '10082779') AND (`team`.`id` = 302) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6527)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
3
0.501
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` = '10082779') 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` = 1) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcompetitionrefPRIMARY,sezonasezona4const71Using where; Using temporary; Using filesort
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,test_dev_nhlcz_s6_esports_cz.competition.id1Using where; Using index
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
1
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` = '10082779') AND (`stats_competition_id` = 6658)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_competition1,fk_stats_players_stats_player15,51Using intersect(fk_stats_players_stats_competition1,fk_stats_players_stats_player1); Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
0.520
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` = '10082779') AND (`team`.`id` = 301) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6658)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition15const1Using where
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id16const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
1
0.503
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` = '10082779') 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` = 1) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
1
0.477
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` = '10082779') AND (`stats_competition_id` = 6711)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
2.199
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` = '10082779') AND (`team`.`id` = 369) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6711)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
4
0.510
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` = '10082779') AND (`competition`.`season` = 2022) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 1) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
1
0.427
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` = '10082779') AND (`stats_competition_id` = 6929)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
2.112
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` = '10082779') AND (`team`.`id` = 140) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6929)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
4
0.576
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` = '10082779') 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` = 1) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const122Using where; Using index; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,sezonaPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEcategoryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.stats_category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107
1
0.533
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` = '10082779') AND (`stats_competition_id` = 7090)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id10const,const2Using where
1PRIMARYcompetitionconstPRIMARYPRIMARY4const1
1PRIMARYteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157
1
2.144
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` = '10082779') AND (`team`.`id` = 140) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 7090)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_competition_treereffk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193
3
1.123
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`,
IF(`competition`.`competition_age_id` = 1, 'Reprezentační zápasy', 'Reprezentační zápasy
mládeže') AS `league`, `league`.`name` AS `league`, 0 AS `isBarage`, 0 AS `clubs` 
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_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '10082779') AND (`competition`.`statistics_visible` =
1) AND (`competition`.`league_id` IS NOT NULL) AND (`competition`.`repre` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) 
GROUP BY `competition`.`competition_age_id` = 1 
ORDER BY `league`.`rank` ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_player15const121Using where; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARY,league_idPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/test-app-Front-Player-components-stats-latte-ff3adcf960ce4b422889acb793ea93d0.php:136
1
0.832
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` = '10082779') 
ORDER BY `publish_date` DESC 
LIMIT 4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpost_2_stats_playerrefPRIMARY,stats_player_idstats_player_id4const1Using where; Using index; Using temporary; Using filesort
1PRIMARYposteq_refPRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_indexPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_player.post_id1Using where
3DEPENDENT SUBQUERYfileeq_refPRIMARY,id_UNIQUEPRIMARY4test_dev_nhlcz_s6_esports_cz.post.file_id1
2DEPENDENT SUBQUERYphotoeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post.photo_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/test-app-Front-templates-blocks-articles-latte-e8402771c740c09b2165a479ad74b8b0.php:39
0
¤ ×

Unlogged

no identity

¤ ×

Front:Player:Overview:default

https://test.nhlcz.s6.esports.cz/hrac/10082779?stats-section=club

Matched? Class Mask Defaults Module Request
no Route test/<presenter>/<action>[/<id>] module = Test
id = 
NULL
Test
no Route <module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] action = default
param1 = 
NULL
param2 = 
NULL
param3 = 
NULL
Export
no Route admin/<module>/<presenter>/<action>[/<id>] module = Dashboard
presenter = Homepage
action = default
id = 
NULL
Admin
yes Route hrac/<id [0-9]+>[/<presenter>] module = Player
presenter = Overview
action = default
Front Front:Player:Overview:default
id = 10082779
stats-section = club
no Route klub/<id [0-9]+>[/<presenter>] module = Club
presenter = Overview
action = default
id = 
NULL
Front
no Route /clanky module = Home
presenter = Article
action = default
Front
no Route /priklepy module = News
presenter = News
action = default
Front
no Route /vyhledavani module = Search
presenter = Search
action = default
Front
no Route /archiv-clanku[/<action>][/<id \d+>] module = Article
presenter = Archive
action = default
id = 
NULL
Front
no Route zapas/<id \d+>[/<presenter>][/<action>] module = Match
presenter = Overview
action = default
Front
no Route / module = Home
presenter = Homepage
action = default
Front
may ArticleRoute <slug [a-zA-Z-0-9\-]+>/<id \d+> module = Article
presenter = Article
action = default
Front Front:Article:Article:default
slug = hrac
id = 10082779
stats-section = club
no ArticleCompatRoute <slug [a-zA-Z-0-9\-]+> module = Article
presenter = Article
action = default
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] module = League
presenter = Page
action = default
leagueId = 
NULL
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> module = MinorLeague
presenter = Section
action = default
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] module = League
presenter = Overview
action = default
id = 
NULL
leagueId = 
NULL
Front
no Route <module>/<presenter>/<action>[/<id>] id = 
NULL
Front

Front\Player\OverviewPresenter::renderDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:22

¤ ×

Queries: 2, time: 0.379 ms, default

Time msSQL QueryRows
0.091
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17
0
0.288
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` = '10082779')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
¤ ×

Unlogged

no identity

¤ ×

Front:Player:Overview:default stats-section!

https://test.nhlcz.s6.esports.cz/hrac/10082779?do=stats-section&stats-section=club

Matched? Class Mask Defaults Module Request
no Route test/<presenter>/<action>[/<id>] module = Test
id = 
NULL
Test
no Route <module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] action = default
param1 = 
NULL
param2 = 
NULL
param3 = 
NULL
Export
no Route admin/<module>/<presenter>/<action>[/<id>] module = Dashboard
presenter = Homepage
action = default
id = 
NULL
Admin
yes Route hrac/<id [0-9]+>[/<presenter>] module = Player
presenter = Overview
action = default
Front Front:Player:Overview:default
id = 10082779
do = stats-section
stats-section = club
no Route klub/<id [0-9]+>[/<presenter>] module = Club
presenter = Overview
action = default
id = 
NULL
Front
no Route /clanky module = Home
presenter = Article
action = default
Front
no Route /priklepy module = News
presenter = News
action = default
Front
no Route /vyhledavani module = Search
presenter = Search
action = default
Front
no Route /archiv-clanku[/<action>][/<id \d+>] module = Article
presenter = Archive
action = default
id = 
NULL
Front
no Route zapas/<id \d+>[/<presenter>][/<action>] module = Match
presenter = Overview
action = default
Front
no Route / module = Home
presenter = Homepage
action = default
Front
may ArticleRoute <slug [a-zA-Z-0-9\-]+>/<id \d+> module = Article
presenter = Article
action = default
Front Front:Article:Article:default
slug = hrac
id = 10082779
do = stats-section
stats-section = club
no ArticleCompatRoute <slug [a-zA-Z-0-9\-]+> module = Article
presenter = Article
action = default
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] module = League
presenter = Page
action = default
leagueId = 
NULL
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> module = MinorLeague
presenter = Section
action = default
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] module = League
presenter = Overview
action = default
id = 
NULL
leagueId = 
NULL
Front
no Route <module>/<presenter>/<action>[/<id>] id = 
NULL
Front

Front\Player\OverviewPresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:8

¤ ×