21. dubna 2019, 5:23
Vojtěch BalonUplynulá noc sice nabídla jen tři zápasy, o krásné góly ale nebyla nouze. Za zmínku stojí například trefa Briana Littlea z Winnipegu či druhý gól washingtonského Nicklase Bäckströma, gólem dne jsme ale nakonec vyhlásili jednu ze dvou tref Alexandra Radulova.
Ruský bohatýr už při svém prvním gólu těžil ze skvělé přihrávky od Tylera Seguina, po níž mu stačilo trefit prázdnou branku. Ještě obdivuhodnější pas ale vymyslel o pár minut později Jamie Benn, který za brankou chytře odstavil hvězdné beky Ryana Ellise i Romana Josiho a poté našel v předbrankovém prostoru volného Radulova, který se nezmýlil.
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.054 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:17 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.675 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` = '5018202')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
22.881 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 ('5018202')) ORDER BY `publish_date` DESC LIMIT 4
| 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.072 explain | SELECT `id`, `setting` FROM `web_settings` WHERE (`code` = 'article_advert') LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.264 explain | SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`, `test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` FROM `post` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` = `test_dev_nhlcz_s6_esports_cz`.`user`.`id` WHERE (`post`.`id` = '5018202')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.532 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` = 5018202)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.223 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.213 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` = 5018202) AND (`post_2_tag`.`tag_type_id` = 1)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.180 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` = 5018202) AND (`post_2_category`.`hidden_in_post` = 0)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.262 explain | SELECT `id` FROM `post` WHERE (`id` IN (5018202))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.185 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` = 5018202)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.243 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` = 5018202)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.656 | UPDATE `post` SET `impression_count`=`impression_count` + 1 WHERE (`post`.`id` = '5018202')/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:186 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.074 explain | SELECT `id`, `name`, `surname` FROM `test_dev_nhlcz_s6_esports_cz`.`user` WHERE (`id` IN (129063))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.183 explain | SELECT `id`, `user_id` FROM `post_2_user` WHERE (`post_id` = '5018202')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.227 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` = '5018202') AND (`post_2_category`.`hidden_in_post` = 0) AND (`category`.`public` = 1) AND (`category`.`show_in_post` = 1) AND (`post_2_category`.`hidden_in_post` = 0)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.153 explain | SELECT `post_id`, `stats_player_id` FROM `post_2_stats_player` WHERE (`post_id` = '5018202')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.275 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` = '5018202')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.279 explain | SELECT `team`.*, `post_2_stats_team`.`stats_team_id`, `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name` FROM `post_2_stats_team` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `post_2_stats_team`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` ON `post_2_stats_team`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`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)) WHERE (`post_id` = '5018202') AND (`team`.`stats_club_id` IS NOT NULL)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.064 explain | SELECT `id`, `name` FROM `category` WHERE (`id` IN (287))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.845 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 ('5018202', 5030871, 5030847, 5030843, 5030790)) ORDER BY `publish_date` DESC LIMIT 4
| 4 |
no identity
https://test.nhlcz.s6.esports.cz/gol-dne-ze-skvele-prace-benna-tezil-radulov/5018202
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