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: 21, time: 28.540 ms, default

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

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

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

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.072
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.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')

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

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

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)

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

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

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

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.262
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.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)

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

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

0.074
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.183
explain

SELECT `id`, `user_id` 
FROM `post_2_user` 
WHERE (`post_id` = '5018202')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post_2_user	ref	post_id	post_id	4	const	1

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

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)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post_2_category	ref	PRIMARY,category_id	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	Using where

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

0.153
explain

SELECT `post_id`, `stats_player_id` 
FROM `post_2_stats_player` 
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

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

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

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/temp/cache/latte/app-Front-Article-templates-Article-default-latte-d42cc623bbdaee503d733ca2e384307e.php:93

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)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	post_2_stats_team	ref	PRIMARY,stats_team_id	PRIMARY	4	const	1	Using index
1	PRIMARY	team	eq_ref	PRIMARY,stats_club_id	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post_2_stats_team.stats_team_id	1	Using where
1	PRIMARY	stats_team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post_2_stats_team.stats_team_id	1	Using index
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using filesort

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

0.064
explain

SELECT `id`, `name` 
FROM `category` 
WHERE (`id` IN (287))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	category	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:95

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

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: 21, time: 28.540 ms, default

Unlogged

Front:Article:Article:default