![]() |
Švýcarsko Švýcarsko SUI | 2 | ČT 08. 02. (1:0, 0:1, 1:3) | 4 |
|
![]() |
![]() |
Švédsko Švédsko SWE | 5 | SO 10. 02. (3:0, 2:0, 0:2) | 2 |
|
![]() |
![]() |
Švýcarsko Švýcarsko SUI | 3 | NE 11. 02. (1:0, 1:2, 1:3) | 5 |
|
![]() |
ISSN 1214-5718 | dotazy na redakci: redakce@nhl.cz, obchod/reklama: obchod@hokej.cz, technický provoz: webmaster@hokej.cz
© Copyright - Všechna loga a známky NHL, loga a známky týmů NHL, jakožto další vlastnické materiály včetně log konferencí a obrázků Stanley Cupu jsou vlastnictvím NHL, NHL Enterprises, L.P. a příslušných týmů. © NHL Enterprises, L.P. Všechna práva vyhrazena.
Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.084 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubRepository.php:15 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.585 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` = '136')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.085 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')
| 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.352 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')
| 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.167 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` = '136')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.198 explain | SELECT `id`, `code`, `setting` FROM `web_settings` WHERE (`section` = 'common')
| 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.496 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` = '136')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
59.439 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` = '136') ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` DESC, IFNULL(`league`.`rank`, 9223372036854775807) LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
41.116 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` = 136) 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
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.671 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`=7135)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.552 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` = '136')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.150 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` = '136')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
41.635 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` = '136') ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` DESC, IFNULL(`league`.`rank`, 9223372036854775807) LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.415 explain | SELECT DISTINCT `test_dev_nhlcz_s6_esports_cz`.`season`.* 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`.`season` ON `competition`.`season` = `test_dev_nhlcz_s6_esports_cz`.`season`.`year` WHERE ((`stats_team_home_id` = 136 OR `stats_team_guest_id` = 136)) ORDER BY `year` DESC
| 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.738 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.*, `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` AS `competition` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition` 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` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` = 136) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` = 2023) AND (`virtual` = 0) ORDER BY `priority` DESC
| 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.224 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_category`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_category` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_category`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`stats_category_id` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7177)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
9.859 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*, `extra_time`.`code` `extra_time_code`, `phase`.`name` `phase_name`, `team_home_logo`.`path` `team_home_logo`, `team_guest_logo`.`path` `team_guest_logo`, `team_home_name`.`name` `team_home_name`, `team_guest_name`.`name` `team_guest_name`, `club_home`.`shortcut` AS `shortcut_home`, `club_guest`.`shortcut` AS `shortcut_guest`, `club_home`.`nickname` AS `nickname_home`, `club_guest`.`nickname` AS `nickname_guest`, `period1`.`score_home` AS `score_home_period1`, `period1`.`score_guest` AS `score_guest_period1`, `period2`.`score_home` AS `score_home_period2`, `period2`.`score_guest` AS `score_guest_period2`, `period3`.`score_home` AS `score_home_period3`, `period3`.`score_guest` AS `score_guest_period3`, `period4`.`score_home` AS `score_home_period4`, `period4`.`score_guest` AS `score_guest_period4`, `period5`.`score_home` AS `score_home_period5`, `period5`.`score_guest` AS `score_guest_period5` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_home` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_home_id` = `team_home`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_guest` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_guest_id` = `team_guest`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_home_name` ON `team_home`.`id` = `team_home_name`.`stats_team_id` AND (`team_home_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `team_home_name`.`stats_team_id` ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_guest_name` ON `team_guest`.`id` = `team_guest_name`.`stats_team_id` AND (`team_guest_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` WHERE `nameTable`.`stats_team_id` = `team_guest_name`.`stats_team_id` ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_home` ON `team_home`.`stats_club_id` = `club_home`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_home_logo` ON `club_home`.`id` = `team_home_logo`.`stats_club_id` AND (`team_home_logo`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` WHERE `nameTable`.`stats_club_id` = `team_home_logo`.`stats_club_id` ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_guest` ON `team_guest`.`stats_club_id` = `club_guest`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_guest_logo` ON `club_guest`.`id` = `team_guest_logo`.`stats_club_id` AND (`team_guest_logo`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` WHERE `nameTable`.`stats_club_id` = `team_guest_logo`.`stats_club_id` ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period1` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period1`.`stats_match_id` AND (`period1`.`period` = 1) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period2` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period2`.`stats_match_id` AND (`period2`.`period` = 2) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period3` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period3`.`stats_match_id` AND (`period3`.`period` = 3) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period4` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period4`.`stats_match_id` AND (`period4`.`period` = 4) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period5` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period5`.`stats_match_id` AND (`period5`.`period` = 5) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_extra_time` AS `extra_time` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`extra_time` = `extra_time`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_phase` AS `phase` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`phase` = `phase`.`id` WHERE (`team_home`.`id` IS NOT NULL) AND (`team_guest`.`id` IS NOT NULL) AND (`team_home_name`.`id` IS NOT NULL) AND (`team_guest_name`.`id` IS NOT NULL) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = 7177) AND ((`stats_team_home_id` = 136 OR `stats_team_guest_id` = 136)) AND (`datetime` IS NOT NULL) ORDER BY `datetime`
| 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.297 explain | SELECT * FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` WHERE (`id` IN (7177))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.792 explain | SELECT `datetime`, `note`, `tv`.* FROM `test_dev_nhlcz_s6_esports_cz`.`tv_2_match` LEFT JOIN `tv` ON `test_dev_nhlcz_s6_esports_cz`.`tv_2_match`.`tv_id` = `tv`.`id` WHERE (`stats_match_id` = 2912676) AND (`tv`.`visible` = 1)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.173 explain | SELECT `datetime`, `note`, `tv`.* FROM `test_dev_nhlcz_s6_esports_cz`.`tv_2_match` LEFT JOIN `tv` ON `test_dev_nhlcz_s6_esports_cz`.`tv_2_match`.`tv_id` = `tv`.`id` WHERE (`stats_match_id` = 2912679) AND (`tv`.`visible` = 1)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.203 explain | SELECT `datetime`, `note`, `tv`.* FROM `test_dev_nhlcz_s6_esports_cz`.`tv_2_match` LEFT JOIN `tv` ON `test_dev_nhlcz_s6_esports_cz`.`tv_2_match`.`tv_id` = `tv`.`id` WHERE (`stats_match_id` = 2912680) AND (`tv`.`visible` = 1)
| 0 |
https://test.nhlcz.s6.esports.cz/klub/136/zapasy
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
test/<presenter>/<action>[/<id>] |
module = Test |
Test |
|
no | Route |
<module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] |
action = default |
Export |
|
no | Route |
admin/<module>/<presenter>/<action>[/<id>] |
module = Dashboard |
Admin |
|
no | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
|
yes | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
Front:Club:Match:default |
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
no | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
|
no | ArticleCompatRoute |
<slug [a-zA-Z-0-9\-]+> |
module = Article |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] |
module = League |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> |
module = MinorLeague |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] |
module = League |
Front |
|
no | Route |
<module>/<presenter>/<action>[/<id>] |
id = |
Front |
Front\Club\MatchPresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Club/presenters/MatchPresenter.php:8