Z Boleslavi je to pro dnešek vše. Děkuji za pozornost.
Třinec nejprve otevřel skóre, pak bleskově Boleslav srovnala. Ve druhé třetině si Třinec vrátil vedení, o které hosté přišli při power-play Boleslavi v závěru. Ale bod navíc přece získává Třinec a Bruslařům zůstává aspoň ten bod. S takovým soupeřem je tento bod dobrý, ale hosté zvládli nájezdy přece mnohem lépe.
Konec zápasu.
V samostatných nájezdech zvítězil tým HC Oceláři Třinec.
Autorem vítězné branky je DANIEL VOŽENÍLEK.
Martin RŮŽIČKA proměňuje.
David BERNAD proměňuje.
Tak nájezd se bude opakovat.
David BERNAD neproměňuje. A nájezd se asi zopakuje. Mazanec totiž Bernada fauloval.
Daniel VOŽENÍLEK proměňuje.
Róbert LANTOŠI neproměňuje.
Richard PÁNIK neproměňuje.
Střídání v týmu BK Mladá Boleslav:
ze hřiště odchází Jan Růžička, přichází Filip Novotný.
Ondřej ROMAN neproměňuje.
Petr VRÁNA proměňuje.
Alex LINTUNIEMI proměňuje.
Andrej NESTRAŠIL proměňuje.
Samostatné nájezdy začínají.
Už jednou se na ledě ŠKOENERGO Areny rozhodovalo mezi těmito dvěma soupeři v rozstřelu. Minule byl úspěšnější Třinec. Jak to ale dopadne nyní?
Jelikož prodloužení nepřineslo rozuzlení, čekají nás ještě nájezdy.
65:00
Prodloužení skončilo.
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.075 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchRepository.php:17 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.497 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*, `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` `competition`, `extra_time`.`code` `extra_time_code`, `contumacy`.`code` `contumacy_code`, `phase`.`name` `phase_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season`, `sheet_state`.`name` `sheetStateName`, `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`, `club_home_name`.`name` `club_home_name`, `club_guest_name`.`name` `club_guest_name` 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_club_name` AS `club_home_name` ON `club_home`.`id` = `club_home_name`.`stats_club_id` AND (`club_home_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` WHERE `nameTable`.`stats_club_id` = `club_home_name`.`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_name` AS `club_guest_name` ON `club_guest`.`id` = `club_guest_name`.`stats_club_id` AND (`club_guest_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` WHERE `nameTable`.`stats_club_id` = `club_guest_name`.`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_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 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_contumacy` AS `contumacy` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`contumacy` = `contumacy`.`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` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_sheet_state` AS `sheet_state` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`sheet_state` = `sheet_state`.`code` 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`.`id` = '2908817')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.186 explain | SELECT `id`, `league_id`, `season` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` WHERE (`id` IN (7071))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.124 explain | SELECT `id`, `code` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_league` WHERE (`id` IN (3))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.211 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*, `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` `competition`, `extra_time`.`code` `extra_time_code`, `contumacy`.`code` `contumacy_code`, `phase`.`name` `phase_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season`, `sheet_state`.`name` `sheetStateName`, `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`, `club_home_name`.`name` `club_home_name`, `club_guest_name`.`name` `club_guest_name` 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_club_name` AS `club_home_name` ON `club_home`.`id` = `club_home_name`.`stats_club_id` AND (`club_home_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` WHERE `nameTable`.`stats_club_id` = `club_home_name`.`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_name` AS `club_guest_name` ON `club_guest`.`id` = `club_guest_name`.`stats_club_id` AND (`club_guest_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` WHERE `nameTable`.`stats_club_id` = `club_guest_name`.`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_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 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_contumacy` AS `contumacy` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`contumacy` = `contumacy`.`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` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_sheet_state` AS `sheet_state` ON `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`sheet_state` = `sheet_state`.`code` 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`.`id` = '2908817')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.190 explain | SELECT `id`, `stats_club_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` WHERE (`id` IN (89))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.135 explain | SELECT `id`, `nickname`, `shortcut` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` WHERE (`id` IN (89))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.692 explain | SELECT `id`, `stats_club_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` WHERE (`id` IN (11))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.168 explain | SELECT `id`, `nickname`, `shortcut` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` WHERE (`id` IN (11))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.126 explain | SELECT `id`, `league_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` WHERE (`id` IN (7071))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.045 explain | SELECT `id`, `code` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_league` WHERE (`id` IN (3))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.863 explain | SELECT `id`, `period`, `score_home`, `score_guest` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` WHERE (`stats_match_id` = '2908817') ORDER BY `period`
| 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.152 explain | SELECT `id`, `onlajny_id`, `post_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908817')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.180 explain | SELECT `id` FROM `available_video` WHERE (`stats_match_id` = '2908817') AND (`type` = 'match') LIMIT 1
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.136 explain | SELECT `id` FROM `available_video` WHERE (`stats_match_id` = '2908817') AND (`type` = 'cut') LIMIT 1
| 0 |
https://test.nhlcz.s6.esports.cz/zapas/2908817/on-line
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 |
|
no | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
|
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
yes | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
Front:Match:Online:default |
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\Match\OnlinePresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/OnlinePresenter.php:8