NHL.cz na Facebooku

NHL

Gól dne: Dělovka Carla Gunnarssona, rozhodující trefa druhého finálového zápasu

30. května 2019, 6:00

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.

Druhý finálový zápas rozhodovalo prodloužení, Blues srovnali stav série

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: 30.025 ms, default

Time ms

SQL Query

Rows

0.052

SET NAMES 'utf8'

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

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

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

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.074
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.326
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` = '5018498')

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

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

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

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

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

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

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

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

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

0.181
explain

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

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

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

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.231
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) 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.145
explain

SELECT `post_id`, `stats_player_id` 
FROM `post_2_stats_player` 
WHERE (`post_id` = '5018498')

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

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.249
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` = '5018498') 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.144
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.716
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

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-delovka-carla-gunnarssona-rozhodujici-trefa-druheho-finaloveho-zapasu/5018498

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-delovka-carla-gunnarssona-rozhodujici-trefa-druheho-finaloveho-zapasu id = 5018498`
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: Dělovka Carla Gunnarssona, rozhodující trefa druhého finálového zápasu

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: 30.025 ms, default

Unlogged

Front:Article:Article:default