bahis siteleri

NHL.cz na Facebooku

HC VÍTKOVICE RIDERA

Poř. Jméno Tým P Z G A B +/- + - TM
1 Yohann Auvitu HC VÍTKOVICE RIDERA O 3 1 1 2 -1 1 2 2
2 Rihards Bukarts HC VÍTKOVICE RIDERA Ú 3 1 1 2 -2 0 2 0
3 Petr Fridrich HC VÍTKOVICE RIDERA Ú 3 1 1 2 0 1 1 4
4 Stuart Thomas Percy HC VÍTKOVICE RIDERA O 3 1 0 1 -2 0 2 0
5 Willie Raskob HC VÍTKOVICE RIDERA O 3 0 1 1 -2 0 2 4
6 Valentin Claireaux HC VÍTKOVICE RIDERA Ú 3 0 1 1 0 1 1 0
7 Peter Krieger HC VÍTKOVICE RIDERA Ú 3 0 1 1 -2 0 2 2
8 Marcel Barinka HC VÍTKOVICE RIDERA Ú 3 0 1 1 0 1 1 0
9 Patrik Zdráhal HC VÍTKOVICE RIDERA Ú 3 0 1 1 -1 1 2 0
10 Matěj Přibyl HC VÍTKOVICE RIDERA Ú 1 0 0 0 0 0 0 0
11 Petr Chlán HC VÍTKOVICE RIDERA Ú 2 0 0 0 0 0 0 0
12 Marek Kalus HC VÍTKOVICE RIDERA Ú 3 0 0 0 -1 0 1 2
13 Matěj Prčík HC VÍTKOVICE RIDERA O 3 0 0 0 -2 0 2 31
14 Roman Půček HC VÍTKOVICE RIDERA Ú 3 0 0 0 0 0 0 0
15 Mario Grman HC VÍTKOVICE RIDERA O 3 0 0 0 0 0 0 4
16 Vojtěch Lednický HC VÍTKOVICE RIDERA Ú 3 0 0 0 1 1 0 2
17 Roberts Bukarts HC VÍTKOVICE RIDERA Ú 3 0 0 0 -2 0 2 0
18 Juraj Mikuš HC VÍTKOVICE RIDERA O 3 0 0 0 0 0 0 0
19 Rastislav Dej HC VÍTKOVICE RIDERA Ú 3 0 0 0 0 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: 21, time: 186.890 ms, default

Time msSQL QueryRows
0.065
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubRepository.php:15
0
0.662
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
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_logo` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_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_club`.`id` = '7')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_clubconstPRIMARYPRIMARY4const1
1PRIMARYstats_club_namerefstats_club_idstats_club_id5const2
1PRIMARYstats_club_logorefstats_club_idstats_club_id5const4
3DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Club/presenters/BasePresenter.php:32
1
20.408
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`match_bet` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` 
WHERE (DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) = CURDATE()) AND
(`league`.`code` = 'nhl') AND (`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` IS NOT
NULL) 
LIMIT 100
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEleagueconstPRIMARY,codecode768const1Using index
1SIMPLEcompetitionrefPRIMARY,league_idleague_id5const273Using where; Using index
1SIMPLEstats_matchrefPRIMARY,fk_stats_match_stats_competition1fk_stats_match_stats_competition15test_dev_nhlcz_s6_esports_cz.competition.id21Using where
1SIMPLEmatch_betrefPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/presenters/BasePresenter.php:112
0
0.330
explain
SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode` 
FROM `zone` 
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id` 
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id` 
WHERE (`zone_template`.`code` = 'default')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEzone_templaterefPRIMARY,codecode302const1Using where; Using index
1SIMPLEzonerefzone_template_id_zone_position_id,zone_template_idzone_template_id_zone_position_id4test_dev_nhlcz_s6_esports_cz.zone_template.id17
1SIMPLEzone_positioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.zone.zone_position_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:182
27
0.315
explain
SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode` 
FROM `zone` 
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id` 
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id` 
WHERE (`zone_template`.`code` = 'club')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEzone_templaterefPRIMARY,codecode302const1Using where; Using index
1SIMPLEzonerefzone_template_id_zone_position_id,zone_template_idzone_template_id_zone_position_id4test_dev_nhlcz_s6_esports_cz.zone_template.id17
1SIMPLEzone_positioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.zone.zone_position_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:185
27
0.202
explain
SELECT `id`, `banner`, `banner_second` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` = '7')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubService.php:39
1
0.549
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
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_logo` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_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_club`.`id` = '7')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_clubconstPRIMARYPRIMARY4const1
1PRIMARYstats_club_namerefstats_club_idstats_club_id5const2
1PRIMARYstats_club_logorefstats_club_idstats_club_id5const4
3DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubFacade.php:67
1
49.104
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_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_team_2_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`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_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_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 (`club`.`id` = '7') 
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` DESC, IFNULL(`league`.`rank`,
9223372036854775807) 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYclubconstPRIMARYPRIMARY4const1Using temporary; Using filesort
1PRIMARYstats_teamrefstats_club_idstats_club_id5const11Using where
1PRIMARYstats_team_2_competitionrefstats_team_id,fk_stats_team_2_competition_stats_teamstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id7Using index
1PRIMARYstats_competitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_competition_id1
1PRIMARYleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.league_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team.stats_club_id1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_team.stats_club_id4
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/model/Team/TeamFacade.php:196
1
45.948
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` =
`test_dev_nhlcz_s6_esports_cz`.`season`.`year` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_players` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`season`.`id` IS NOT NULL) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` = 7) AND (`virtual` = 0)
AND (`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`id` IS NOT NULL) 
ORDER BY `season` DESC, IFNULL(`league`.`rank`, 9223372036854775807), `priority` DESC 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_team_2_competitionrefstats_team_id,fk_stats_team_2_competition_stats_team,fk_stats_team_2_competition_stats_competition1stats_team_id5const87Using where; Using index; Using temporary; Using filesort
1SIMPLEstats_competitioneq_refPRIMARY,sezona,virtualPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_competition_id1Using where
1SIMPLEseasoneq_refPRIMARY,idPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.season1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.league_id1
1SIMPLEstats_playersrefPRIMARY,fk_stats_players_stats_competition1fk_stats_players_stats_competition15test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_competition_id253Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:299
1
0.337
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.*, `phase`.`name` AS `phase_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_category`.`type` AS `type`, `league`.`code` AS `league_code`,
`league_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_phase` AS `phase` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`phase` = `phase`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`stats_category_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_category`.`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` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id`=7196)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
1SIMPLEphaseconstPRIMARYPRIMARY4const1
1SIMPLEstats_categoryconstPRIMARYPRIMARY4const1
1SIMPLEleagueconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:181
1
0.601
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`social`.`code`, `url` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_2_social` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`social` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club_2_social`.`social_id` =
`test_dev_nhlcz_s6_esports_cz`.`social`.`id` 
WHERE (`stats_club_id` = '7')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_club_2_socialrefPRIMARYPRIMARY4const6
1SIMPLEsocialeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_club_2_social.social_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Social/Links/ClubSocial.php:24
6
0.072
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`social`.`code`, `url` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_2_social` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`social` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club_2_social`.`social_id` =
`test_dev_nhlcz_s6_esports_cz`.`social`.`id` 
WHERE (`stats_club_id` = '7')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_club_2_socialrefPRIMARYPRIMARY4const6
1SIMPLEsocialeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_club_2_social.social_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Social/Links/ClubSocial.php:24
6
45.528
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_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_team_2_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`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_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_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 (`club`.`id` = '7') 
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` DESC, IFNULL(`league`.`rank`,
9223372036854775807) 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYclubconstPRIMARYPRIMARY4const1Using temporary; Using filesort
1PRIMARYstats_teamrefstats_club_idstats_club_id5const11Using where
1PRIMARYstats_team_2_competitionrefstats_team_id,fk_stats_team_2_competition_stats_teamstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id7Using index
1PRIMARYstats_competitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_competition_id1
1PRIMARYleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.league_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team.stats_club_id1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_team.stats_club_id4
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/model/Team/TeamFacade.php:196
1
0.164
explain
SELECT `id`, `league_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7196)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionRepository.php:97
1
7.463
explain
SELECT DISTINCT `test_dev_nhlcz_s6_esports_cz`.`season`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` =
`test_dev_nhlcz_s6_esports_cz`.`season`.`year` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_players` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`season`.`id` IS NOT NULL) AND (`league_id` = 3) AND
(`virtual` = 0) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`id` IS NOT NULL) 
ORDER BY `year` DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionrefPRIMARY,sezona,virtual,league_idleague_id5const186Using where; Using temporary; Using filesort
1SIMPLEseasoneq_refPRIMARY,idPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.season1Using where
1SIMPLEstats_playersrefPRIMARY,fk_stats_players_stats_competition1fk_stats_players_stats_competition15test_dev_nhlcz_s6_esports_cz.stats_competition.id253Using where; Using index; Distinct
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/PlayerStats/Filter/Filter.php:170
32
0.804
explain
SELECT DISTINCT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` =
`test_dev_nhlcz_s6_esports_cz`.`season`.`year` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_players` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`season`.`id` IS NOT NULL) AND (`season` = 2023) AND
(`league_id` = 3) AND (`virtual` = 0) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`id` IS
NOT NULL) 
ORDER BY `virtual` DESC, `priority` DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEseasonconstPRIMARY,idPRIMARY4const1Using temporary; Using filesort
1SIMPLEstats_competitionindex_mergePRIMARY,sezona,virtual,league_idsezona,league_id4,57Using intersect(sezona,league_id); Using where
1SIMPLEstats_playersrefPRIMARY,fk_stats_players_stats_competition1fk_stats_players_stats_competition15test_dev_nhlcz_s6_esports_cz.stats_competition.id253Using where; Using index; Distinct
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/PlayerStats/Filter/Filter.php:191
2
4.201
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_2_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`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_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_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_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_competition`.`season` = 2023) AND (`league`.`id` = 3)
AND (`club`.`id` IS NOT NULL) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7196) 
ORDER BY `team_name`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_competitionconstPRIMARY,sezona,league_idPRIMARY4const1Using temporary; Using filesort
1PRIMARYleagueconstPRIMARYPRIMARY4const1Using index
1PRIMARYstats_team_2_competitionrefstats_team_id,fk_stats_team_2_competition_stats_team,fk_stats_team_2_competition_stats_competition1fk_stats_team_2_competition_stats_competition15const8Using where
1PRIMARYstats_teameq_refPRIMARY,stats_club_idPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_team_id1Using where
1PRIMARYclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team.stats_club_id1Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.club.id1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_team.stats_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/components/PlayerStats/Filter/Filter.php:208
8
0.081
explain
SELECT `id`, `code`, `name` 
FROM `test_dev_nhlcz_s6_esports_cz`.`country` 
ORDER BY `name`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcountryALL41Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/PlayerStats/PlayerFilter/PlayerBaseFilter.php:134
41
0.074
explain
SELECT `id`, `code`, `name` 
FROM `test_dev_nhlcz_s6_esports_cz`.`country` 
ORDER BY `name`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcountryALL41Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/PlayerStats/PlayerFilter/PlayerBaseFilter.php:134
41
5.107
explain
SELECT `player`.`date_of_birth`, `goals`, `assistances`, `player`.`id` AS `player_id`,
`player`.`name`, `player`.`surname`, `player`.`photo`, `player`.`position`,
`player`.`date_of_birth`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `team`.`stats_club_id` `club_id`,
`team`.`id` `team_id`, `club`.`shortcut`, `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`, `goals`, `assistances`,
`matches`, `points`, `score`, `points_plus`, `points_minus`, `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
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(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 `team`.`stats_club_id` =
`club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `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_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)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`summary` = 1) AND (`stats_competition_id` = 7196) AND (`player`.`position` != 'GK') AND
(`team`.`id` = 7)
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_competition1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_competition1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const2
1PRIMARYclubeq_refPRIMARYPRIMARY4const1
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club.id1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club.id1
1PRIMARYplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_player_id1Using where
1PRIMARYcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_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/components/PlayerStats/BaseFactory.php:44
19
4.876
explain
SELECT `player`.`date_of_birth`, `goals`, `assistances`, `player`.`id` AS `player_id`,
`player`.`name`, `player`.`surname`, `player`.`photo`, `player`.`position`,
`player`.`date_of_birth`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `team`.`stats_club_id` `club_id`,
`team`.`id` `team_id`, `club`.`shortcut`, `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`, `goals`, `assistances`,
`matches`, `points`, `score`, `points_plus`, `points_minus`, `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
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(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 `team`.`stats_club_id` =
`club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `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_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)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`summary` = 1) AND (`stats_competition_id` = 7196) AND (`player`.`position` != 'GK') AND
(`team`.`id` = 7) 
ORDER BY `score` DESC, `goals` DESC, `matches` ASC 
LIMIT 40
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYteamconstPRIMARYPRIMARY4const1Using filesort
1PRIMARYstats_playersindex_mergestats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1fk_stats_players_stats_competition1,fk_stats_players_stats_team15,51Using intersect(fk_stats_players_stats_competition1,fk_stats_players_stats_team1); Using where
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const2
1PRIMARYclubeq_refPRIMARYPRIMARY4const1
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club.id1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club.id1
1PRIMARYplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_player_id1Using where
1PRIMARYcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_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/temp/cache/latte/Front-components-PlayerStats-Info-columns-latte-191bdf229637d37abc0e2bd7580424f7.php:45
19
¤ ×

Front:Club:Stats:default

https://test.nhlcz.s6.esports.cz/klub/7/statistiky

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
no Route hrac/<id [0-9]+>[/<presenter>] module = Player
presenter = Overview
action = default
Front
yes Route klub/<id [0-9]+>[/<presenter>] module = Club
presenter = Overview
action = default
id = 
NULL
Front Front:Club:Stats:default
id = 7
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
no ArticleRoute <slug [a-zA-Z-0-9\-]+>/<id \d+> module = Article
presenter = Article
action = default
Front
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\Club\StatsPresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Club/presenters/StatsPresenter.php:22

¤ ×