30. května 2019, 6:00
Jiří SamešV noci na čtvrtek 30. května byl na programu play-off National Hockey League druhý zápas finále Stanley Cupu. Rozhodovalo jej prodloužení, úspěch přitom tentokrát zaznamenali hokejisté St. Louis Blues.
Carl Gunnarsson (St. Louis Blues)
Vítězný gól druhého finálového zápasu vstřelil v čase 63:51, při signalizované výhodě, obránce Carl Gunnarsson. Skóroval prudkou střelou od modré čáry bez přípravy, z pravé strany. Do statistik zapsal svůj vůbec první gól v play-off.
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.060 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:17 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.603 explain | SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS `nameTitle`, IF(`post`.`photo_id` IS NOT NULL, ( SELECT `photo`.`url` FROM `photo` WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, ( SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` FROM `file` WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` FROM `post` WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <= NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND `post`.`unpublish_date` >= NOW())) AND (`post`.`id` = '5018498')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
24.875 explain | SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS `nameTitle`, IF(`post`.`photo_id` IS NOT NULL, ( SELECT `photo`.`url` FROM `photo` WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, ( SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` FROM `file` WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` FROM `post` WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <= NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND `post`.`unpublish_date` >= NOW())) AND (`recommend` = 1) AND (`post`.`id` NOT IN ('5018498')) ORDER BY `publish_date` DESC LIMIT 4
| 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.146 explain | SELECT `id`, `setting` FROM `web_settings` WHERE (`code` = 'article_advert') LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.455 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.201 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` = 'section')
| 162 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.642 explain | SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS `nameTitle`, IF(`post`.`photo_id` IS NOT NULL, ( SELECT `photo`.`url` FROM `photo` WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, ( SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` FROM `file` WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` FROM `post` WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <= NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND `post`.`unpublish_date` >= NOW())) AND (`post`.`id` = 5018498)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.319 explain | SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS `nameTitle`, IF(`post`.`photo_id` IS NOT NULL, ( SELECT `photo`.`url` FROM `photo` WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, ( SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` FROM `file` WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` FROM `post` WHERE (`post`.`post_type_id` = 1) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <= NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND `post`.`unpublish_date` >= NOW())) AND (`post`.`id` IS NULL)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.266 explain | SELECT `post_2_tag`.*, `tag`.`name` FROM `post_2_tag` LEFT JOIN `tag` ON `post_2_tag`.`tag_id` = `tag`.`id` WHERE (`post_2_tag`.`post_id` = 5018498) AND (`post_2_tag`.`tag_type_id` = 1)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.279 explain | SELECT `post_2_category`.*, `category`.`name` FROM `post_2_category` LEFT JOIN `category` ON `post_2_category`.`category_id` = `category`.`id` WHERE (`post_2_category`.`post_id` = 5018498) AND (`post_2_category`.`hidden_in_post` = 0)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.257 explain | SELECT `id` FROM `post` WHERE (`id` IN (5018498))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.310 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id`, `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`surname` FROM `post_2_stats_player` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` ON `post_2_stats_player`.`stats_player_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` WHERE (`post_id` = 5018498)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.341 explain | SELECT `club`.*, `post_2_stats_club`.`stats_club_id`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name` FROM `post_2_stats_club` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON `post_2_stats_club`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND (`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = ( SELECT `id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >= `nameTable`.`from`) DESC LIMIT 1)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `post_2_stats_club`.`stats_club_id` = `club`.`id` WHERE (`post_id` = 5018498)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.891 | UPDATE `post` SET `impression_count`=`impression_count` + 1 WHERE (`post`.`id` = '5018498')/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:186 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
37.665 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
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.213 explain | SELECT `id`, `name`, `surname` FROM `test_dev_nhlcz_s6_esports_cz`.`user` WHERE (`id` IN (129188))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.842 explain | SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS `nameTitle`, IF(`post`.`photo_id` IS NOT NULL, ( SELECT `photo`.`url` FROM `photo` WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, ( SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` FROM `file` WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` FROM `post` WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <= NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND `post`.`unpublish_date` >= NOW())) AND (`topstory` IS NOT NULL OR `show_on_hompage` = 1) AND (`post`.`id` NOT IN ('5018498', 5030871, 5030847, 5030843, 5030790)) ORDER BY `publish_date` DESC LIMIT 4
| 4 |
no identity
https://test.nhlcz.s6.esports.cz/gol-dne-delovka-carla-gunnarssona-rozhodujici-trefa-druheho-finaloveho-zapasu/5018498
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 |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
yes | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
Front:Article:Article:default |
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\Article\ArticlePresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArticlePresenter.php:27