NHL.cz na Facebooku

NHL

Gól dne: Ze skvělé práce Benna těžil Radulov

21. dubna 2019, 5:23

Uplynulá 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.

Užij si zábavu a radost ze hry u Fortuny

Tohle musíte vidět!

Aktuálně z nhl.cz

Dětský reportér, školní sektory a chorea místo výtvarky. Tak vypadá výchova nových fanoušků v Třinci

15. března 2024, 14:00

nhl.cz doporučuje

Swayman & Ullmark. Dojemné přátelství, které ale nemůže trvat věčně

11. března 2024, 15:30

Velké překvapení v NHL! San Jose pustilo Tomáše Hertla ke konkurenci

8. března 2024, 21:06

Uzávěrka přestupů NHL 2024

8. března 2024, 16:00

Další Dostálova noc: Dvaapadesát zákroků a nájezd dvě vteřiny před koncem!

2. března 2024, 10:00

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: 16, time: 52.356 ms, default

Time ms

SQL Query

Rows

0.065

SET NAMES 'utf8'

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:17

0.829
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')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	post	const	PRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_index	PRIMARY	4	const	1
3	DEPENDENT SUBQUERY								Impossible WHERE noticed after reading const tables
2	DEPENDENT SUBQUERY	photo	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:508

24.756
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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	post	index_merge	PRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_index,recommend	recommend,fk_post_post_state,fk_post_post_type	1,4,4		344	Using intersect(recommend,fk_post_post_state,fk_post_post_type); Using where; Using filesort
3	DEPENDENT SUBQUERY	file	eq_ref	PRIMARY,id_UNIQUE	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.file_id	1
2	DEPENDENT SUBQUERY	photo	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.photo_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArticlePresenter.php:61

0.240
explain

SELECT `id`, `setting` 
FROM `web_settings` 
WHERE (`code` = 'article_advert') 
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	web_settings	ref	code	code	767	const	1	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Setting/SettingService.php:55

0.519
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)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	post	const	PRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_index	PRIMARY	4	const	1
3	DEPENDENT SUBQUERY								Impossible WHERE noticed after reading const tables
2	DEPENDENT SUBQUERY	photo	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:508

0.236
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)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY								Impossible WHERE
3	DEPENDENT SUBQUERY	file	eq_ref	PRIMARY,id_UNIQUE	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.file_id	1
2	DEPENDENT SUBQUERY	photo	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.photo_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:630

0.193
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)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post_2_tag	ref	PRIMARY,tag_type_id	PRIMARY	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,id_UNIQUE	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post_2_tag.tag_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:201

0.249
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)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post_2_category	ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	category	eq_ref	PRIMARY,id_UNIQUE	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post_2_category.category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:202

0.160
explain

SELECT `id` 
FROM `post` 
WHERE (`id` IN (5018202))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1	Using index

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:202

0.211
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)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post_2_stats_player	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	stats_player	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post_2_stats_player.stats_player_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:230

0.257
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)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	post_2_stats_club	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	PRIMARY	stats_club	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post_2_stats_club.stats_club_id	1	Using index
1	PRIMARY	stats_club_name	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.stats_club.id	1
1	PRIMARY	club	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post_2_stats_club.stats_club_id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id	1	Using where; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:243

0.701

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

22.215
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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	league	const	PRIMARY,code	code	768	const	1	Using index
1	SIMPLE	competition	ref	PRIMARY,league_id	league_id	5	const	273	Using where; Using index
1	SIMPLE	stats_match	ref	PRIMARY,fk_stats_match_stats_competition1	fk_stats_match_stats_competition1	5	test_dev_nhlcz_s6_esports_cz.competition.id	21	Using where
1	SIMPLE	match_bet	ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_match.id	1	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/presenters/BasePresenter.php:112

0.246
explain

SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`user` 
WHERE (`id` IN (129063))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Article-templates-Article-default-latte-d42cc623bbdaee503d733ca2e384307e.php:194

0.573
explain

SELECT `id`, `code`, `setting` 
FROM `web_settings` 
WHERE (`section` = 'homepage')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	web_settings	ref	section	section	767	const	6	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Social/Links/HomepageSocial.php:48

0.906
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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	post	ref	PRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,topstory,show_on_hompage,post_article_base_index	post_article_base_index	8	const,const	11314	Using where
3	DEPENDENT SUBQUERY	file	eq_ref	PRIMARY,id_UNIQUE	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.file_id	1
2	DEPENDENT SUBQUERY	photo	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.photo_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/test-app-Front-templates-blocks-articles-latte-e8402771c740c09b2165a479ad74b8b0.php:39

¤ ×

Unlogged

no identity

¤ ×

Front:Article:Article:default

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 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`
no	`Route`	`klub/<id [0-9]+>[/<presenter>]`	`module = Club presenter = Overview action = default id = NULL`	`Front`
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`
yes	`ArticleRoute`	`<slug [a-zA-Z-0-9\-]+>/<id \d+>`	`module = Article presenter = Article action = default`	`Front`	`Front:Article:Article:default slug = gol-dne-ze-skvele-prace-benna-tezil-radulov id = 5018202`
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\Article\ArticlePresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArticlePresenter.php:27

¤ ×

NHL.cz na Facebooku

Gól dne: Ze skvělé práce Benna těžil Radulov

Aktuálně z nhl.cz

Dětský reportér, školní sektory a chorea místo výtvarky. Tak vypadá výchova nových fanoušků v Třinci

Závod o play-off pokračuje. V akci Red Wings, Islanders i Capitals

Odměna za spolehlivé výkony. McMann se dočká zvýšení platu

Pohádková sezona? Hyman nahání padesátku, vyrovnal Gretzkyho

nhl.cz doporučuje

Swayman & Ullmark. Dojemné přátelství, které ale nemůže trvat věčně

Velké překvapení v NHL! San Jose pustilo Tomáše Hertla ke konkurenci

Uzávěrka přestupů NHL 2024

Další Dostálova noc: Dvaapadesát zákroků a nájezd dvě vteřiny před koncem!

NHL.cz

Projekty

Organizace

Sociální sítě

Queries: 16, time: 52.356 ms, default

Unlogged

Front:Article:Article:default