bahis siteleri

NHL.cz na Facebooku

ALEŠ JERGL

narozen

18.4.1994

výška

182 cm

věk

30 let

váha

72 kg

post

útočník

hůl

pravá

Play off Tipsport extraligy 2023-2024

zápasů 3  
gólů 1  
asistencí 2  
bodů 3  
± body 2  
tm 0  

Celá kariéra

soutěž klub z g a b +/- + - tm gv gp go
2009-2010 ELSD SD Olomouc 4 0 0 0 0 0 0 0 0 0 0
ELSD II – A SD Olomouc 4 0 0 0 0 0 0 0 0 0 0
ELMD MD Olomouc 33 19 16 35 7 36 29 16 0 5 1
ELMD – V MD Olomouc 33 19 16 35 7 36 29 16 5 5 1
2010-2011 ELSD SD Olomouc 41 17 12 29 15 42 27 38 0 6 0
ELSD – V SD Olomouc 26 8 4 12 2 18 16 30 1 3 0
ELSD II – B SD Olomouc 15 9 8 17 13 24 11 8 0 3 0
ELSD – play off SD Olomouc 3 0 0 0 -4 0 4 2 0 0 0
2011-2012 Noen ELJ J Olomouc 12 0 3 3 -5 7 12 8 0 0 0
Noen ELJ – V J Olomouc 2 0 0 0 -2 0 2 0 0 0 0
Noen ELJ II J Olomouc 10 0 3 3 -3 7 10 8 0 0 0
ELSD SD Olomouc 36 19 24 43 17 43 26 48 2 4 3
ELSD – V SD Olomouc 25 14 11 25 9 26 17 34 2 2 1
ELSD II – B SD Olomouc 11 5 13 18 8 17 9 14 0 2 2
ELSD – play off SD Olomouc 4 1 2 3 -1 3 4 6 0 0 0
2012-2013 Baráž o extraligu HC Olomouc 2 0 0 0 0 0 0 0 0 0 0
Noen ELJ J Olomouc 40 15 16 31 2 33 31 24 2 6 0
Noen ELJ – I. část J Olomouc 31 12 13 25 2 26 24 16 2 5 0
Noen ELJ – II – o play off A J Olomouc 9 3 3 6 0 7 7 8 0 1 0
Noen ELJ – play off J Olomouc 6 2 4 6 6 8 2 8 1 1 0
2013-2014 Baráž o extraligu HC Olomouc 11 1 1 2 1 3 2 2 0 0 0
1. liga HC Olomouc 28 6 6 12 8 15 7 10 2 1 0
1. liga - play off HC Olomouc 11 0 1 1 1 1 0 4 0 0 0
Noen ELJ J Olomouc 28 19 26 45 16 40 24 12 2 3 3
Noen ELJ – II – o play off A J Olomouc 2 3 0 3 0 2 2 2 0 1 0
Noen ELJ – I. část J Olomouc 26 16 26 42 16 38 22 10 2 2 3
2014-2015 Tipsport extraliga HC Olomouc 22 1 1 2 -4 4 8 8 0 0 0
Tipsport extraliga – o umístění HC Olomouc 1 0 0 0 -1 0 1 0 0 0 0
Baráž o extraligu HC Olomouc 4 0 0 0 -1 0 1 0 0 0 0
1. liga HC Dukla Jihlava 12 2 7 9 5 9 4 14 0 0 0
1. liga - play off HC Dukla Jihlava 12 1 4 5 -2 5 7 14 0 1 0
DHL ELJ J Olomouc 29 28 26 54 14 35 21 26 5 8 4
DHL ELJ – I. část J Olomouc 21 19 20 39 8 24 16 24 4 4 4
DHL ELJ – II. část – B J Olomouc 8 9 6 15 6 11 5 2 1 4 0
2015-2016 Tipsport extraliga HC Olomouc 22 5 2 7 6 9 3 4 0 0 0
Baráž o extraligu HC Dukla Jihlava 10 1 0 1 -9 3 12 10 0 1 0
WSM Liga HC Dukla Jihlava 19 1 9 10 3 12 9 10 0 0 0
WSM Liga - play off HC Dukla Jihlava 10 3 5 8 2 7 5 12 1 1 0
2016-2017 Tipsport extraliga HC Olomouc 7 0 1 1 0 1 1 0 0 0 0
Baráž o extraligu HC Dukla Jihlava 9 0 2 2 2 4 2 2 0 0 0
WSM Liga HC Dukla Jihlava 45 13 14 27 17 29 12 30 3 3 1
WSM Liga – play off HC Dukla Jihlava 12 3 2 5 -1 4 5 12 1 1 0
2017-2018 Tipsport extraliga HC Olomouc 35 2 3 5 9 17 8 6 0 0 0
Generali play off HC Olomouc 8 0 3 3 -2 2 4 0 0 0 0
WSM Liga AZ RESIDOMO Havířov 6 2 4 6 2 4 2 4 1 0 0
2018-2019 Tipsport extraliga HC Olomouc 44 14 13 27 4 24 20 18 1 5 0
Generali play off HC Olomouc 7 3 1 4 2 2 0 0 1 1 0
CHANCE LIGA AZ RESIDOMO Havířov 7 2 5 7 5 9 4 8 0 0 0
2019-2020 Tipsport extraliga Mountfield HK 48 8 17 25 4 24 20 8 1 5 0
Generali Česká pojišťovna play off Mountfield HK 2 2 2 4 3 4 1 0 0 0 0
2020-2021 Tipsport extraliga Mountfield HK 43 6 4 10 -7 17 24 12 2 1 0
Generali Česká Cup Mountfield HK 6 1 2 3 0 2 2 2 0 0 0
Generali Česká Cup – sk. C Mountfield HK 6 1 2 3 0 2 2 2 0 0 0
Generali Česká Cup – play off Mountfield HK 1 0 0 0 0 0 0 0 0 0 0
Generali Česká pojišťovna play off Mountfield HK 7 1 1 2 -2 2 4 0 1 1 0
2021-2022 Tipsport extraliga Mountfield HK 55 14 24 38 18 44 26 20 3 2 0
Generali Česká pojišťovna play off Mountfield HK 5 2 2 4 -1 3 4 6 0 0 0
2022-2023 Tipsport extraliga Mountfield HK 52 17 14 31 12 35 23 51 3 3 0
Generali Česká pojišťovna play off Mountfield HK 16 3 5 8 -3 6 9 4 1 3 0
2023-2024 Tipsport extraliga Mountfield HK 44 8 11 19 -1 24 25 28 2 0 0
Play off Tipsport extraligy Mountfield HK 3 1 2 3 2 2 0 0 0 1 0
soutěž klub z g a b +/- + - tm gv gp go
Vše Extraliga 2 klub 428 88 108 196 39 222 183 167 15 22 0
Baráž o extraligu 2 klub 36 2 3 5 -7 10 17 14 0 1 0
CHANCE LIGA 3 klub 162 33 57 90 40 95 55 118 8 7 1
DHL extraliga juniorů 1 klub 115 64 75 139 33 123 90 78 10 18 7
Extraliga staršího dorostu 1 klub 88 37 38 75 27 88 61 94 2 10 3
Extraliga mladšího dorostu 1 klub 33 19 16 35 7 36 29 16 0 5 1

Reprezentační kariéra

soutěž klub z g a b +/- + - tm gv gp go
2012-2013 Reprezentace 19 (celá sezona) Česko 19 1 0 0 0 0 0 0 2 0 0 0
Reprezentace 19 – příp. Česko 19 1 0 0 0 0 0 0 2 0 0 0
Turnaj pěti v Porubě - 19 Česko 19 3 1 0 1 -1 1 2 0 0 0 0
2013-2014 Reprezentace 20 (celá sezona) Česko 20 3 0 0 0 0 0 0 2 0 0 0
Reprezentace 20 – příp. Česko 20 3 0 0 0 0 0 0 2 0 0 0
Reprezentace 19 (celá sezona) Česko 19 3 0 3 3 2 3 1 4 0 0 0
Reprezentace 19 – příp. Česko 19 3 0 3 3 2 3 1 4 0 0 0
soutěž z g a b +/- + - tm gv gp go
Vše Reprezentace U20 10 1 3 4 1 4 3 8 0 0 0
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: 199, time: 181.150 ms, default

Time msSQL QueryRows
0.059
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17
0
0.056
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.217
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.144
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
34.172
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` = '14654') 
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_player15const135Using 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
2.180
explain
SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '14654') 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_player15const10Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268
1
0.787
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`,
`club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`,
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`, `club`.`id` `clubId` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IN (1711))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_teamconstPRIMARYPRIMARY4const1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4const1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYclubeq_refPRIMARYPRIMARY4const1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club.id1
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
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.063
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.079
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` = '14654') 
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_player15const135Using 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.062
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.443
explain
SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '14654') 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_player15const10Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268
1
1.162
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`,
`club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`,
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IN (1711))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_teamconstPRIMARYPRIMARY4const1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4const1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYclubeq_refPRIMARYPRIMARY4const1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club.id1
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
1
6.122
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.`value` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`match_bet` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` 
WHERE (`stats_team_home_id` IN (1711) OR `stats_team_guest_id` IN (1711)) AND
(DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) >= CURDATE()) AND
(`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`bet_type_code` = 'link') 
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` ASC 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchindex_mergePRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2fk_stats_match_stats_team1,fk_stats_match_stats_team25,5767Using union(fk_stats_match_stats_team1,fk_stats_match_stats_team2); Using where; Using filesort
1SIMPLEmatch_beteq_refPRIMARY,match_bet_bet_typePRIMARY64test_dev_nhlcz_s6_esports_cz.stats_match.id,const1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/components/Stats.php:102
0
1.287
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` = '14654') 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_id5const136Using 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
15
0.055
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.043
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
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` = '14654')
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.043
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.079
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.043
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.053
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.036
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.043
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.947
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` = '14654') 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_id5const136Using 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
2
0.054
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
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` = '14654')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
1.909
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` = '14654') AND (`competition`.`season` = 2009) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcompetitionrefPRIMARY,sezonasezona4const102Using 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
2
2.069
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` = '14654') AND (`stats_competition_id` = 807)
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.375
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` = '14654') AND (`team`.`id` = 591) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 807)
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.276
explain
SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '14654') AND (`stats_competition_id` = 807) 
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.124
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` = '14654') AND (`stats_competition_id` = 6632)
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.811
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` = '14654') AND (`team`.`id` = 618) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6632)
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.316
explain
SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '14654') AND (`stats_competition_id` = 6632) 
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.656
explain
SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '14654') AND (`competition`.`season` = 2010) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcompetitionrefPRIMARY,sezonasezona4const101Using 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
2
1.182
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` = '14654') AND (`stats_competition_id` = 933)
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.373
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` = '14654') AND (`team`.`id` = 591) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 933)
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.370
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` = '14654') AND (`stats_competition_id` = 933) 
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.218
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` = '14654') AND (`stats_competition_id` = 957)
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.563
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` = '14654') AND (`team`.`id` = 591) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 957)
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.467
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` = '14654') AND (`stats_competition_id` = 957) 
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
2.437
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` = '14654') AND (`competition`.`season` = 2011) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const136Using 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
1.432
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` = '14654') AND (`stats_competition_id` = 1015)
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.415
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` = '14654') AND (`team`.`id` = 192) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1015)
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.407
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` = '14654') AND (`stats_competition_id` = 1015) 
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.498
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` = '14654') AND (`stats_competition_id` = 1014)
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.220
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` = '14654') AND (`team`.`id` = 591) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1014)
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.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` = '14654') AND (`stats_competition_id` = 1014) 
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.345
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` = '14654') AND (`stats_competition_id` = 1116)
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.528
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` = '14654') AND (`team`.`id` = 591) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1116)
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.298
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` = '14654') AND (`stats_competition_id` = 1116) 
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.656
explain
SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '14654') AND (`competition`.`season` = 2012) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const136Using 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.970
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` = '14654') AND (`stats_competition_id` = 1210)
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.230
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` = '14654') AND (`team`.`id` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1210)
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.283
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` = '14654') AND (`stats_competition_id` = 1210) 
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.356
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` = '14654') AND (`stats_competition_id` = 1147)
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.804
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` = '14654') AND (`team`.`id` = 192) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1147)
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.310
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` = '14654') AND (`stats_competition_id` = 1147) 
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.764
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` = '14654') AND (`stats_competition_id` = 1471)
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.459
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` = '14654') AND (`team`.`id` = 192) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1471)
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.277
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` = '14654') AND (`stats_competition_id` = 1471) 
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.641
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` = '14654') AND (`competition`.`season` = 2013) 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_id5const136Using 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
4
3.226
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` = '14654') AND (`stats_competition_id` = 3591)
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.692
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` = '14654') AND (`team`.`id` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 3591)
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.390
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` = '14654') AND (`stats_competition_id` = 3591) 
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.694
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` = '14654') AND (`stats_competition_id` = 2231)
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.689
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` = '14654') AND (`team`.`id` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 2231)
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.703
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` = '14654') AND (`stats_competition_id` = 2231) 
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.830
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` = '14654') AND (`stats_competition_id` = 3601)
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.704
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` = '14654') AND (`team`.`id` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 3601)
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.394
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` = '14654') AND (`stats_competition_id` = 3601) 
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.463
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` = '14654') AND (`stats_competition_id` = 2551)
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.929
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` = '14654') AND (`team`.`id` = 192) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 2551)
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.934
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` = '14654') AND (`stats_competition_id` = 2551) 
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.701
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` = '14654') AND (`competition`.`season` = 2014) 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_id5const136Using 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
6
0.642
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` = '14654') AND (`stats_competition_id` = 3941)
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.828
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` = '14654') AND (`team`.`id` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 3941)
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.627
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` = '14654') AND (`stats_competition_id` = 3941) 
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.977
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` = '14654') AND (`stats_competition_id` = 5496)
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.970
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` = '14654') AND (`team`.`id` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5496)
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.499
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` = '14654') AND (`stats_competition_id` = 5496) 
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.284
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` = '14654') AND (`stats_competition_id` = 5543)
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.010
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` = '14654') AND (`team`.`id` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5543)
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.438
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` = '14654') AND (`stats_competition_id` = 5543) 
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.576
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` = '14654') AND (`stats_competition_id` = 4161)
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.705
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` = '14654') AND (`team`.`id` = 16) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 4161)
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.683
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` = '14654') AND (`stats_competition_id` = 4161) 
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.067
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` = '14654') AND (`stats_competition_id` = 5493)
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.588
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` = '14654') AND (`team`.`id` = 16) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5493)
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.316
explain
SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '14654') AND (`stats_competition_id` = 5493) 
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.765
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` = '14654') AND (`stats_competition_id` = 5719)
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.910
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` = '14654') AND (`team`.`id` = 192) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5719)
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.358
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` = '14654') AND (`stats_competition_id` = 5719) 
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

...and more

¤ ×

Unlogged

no identity

¤ ×

Front:Player:Overview:default

https://test.nhlcz.s6.esports.cz/hrac/14654?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 = 14654
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 = 14654
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.323 ms, default

Time msSQL QueryRows
0.074
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17
0
0.249
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` = '14654')
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/14654?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 = 14654
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 = 14654
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

¤ ×