bahis siteleri

NHL.cz na Facebooku

Hráčům dochází trpělivost. Hrát v Arizoně se moc nedá, jak se máme vyrovnat NBA, láteří Hyman

22. února 2024, 12:00

David Zlomek

Mullet Arena, ve které hrají své domácí zápasy Arizona Coyotes, je miniaturní stadion, který dělá lize spíše ostudu. Původně je to stadion pro univerzitní hokej s kapacitou pouhých 4 600 fanoušků. Plusem je, že tam vždy panuje dobrá a hlučná atmosféra. Pro hostující tým je to tedy jedinečný zážitek.

"Je fajn hrát jednou nebo dvakrát, ale odehrát tady 41 zápasů, to není ideální," řekl útočník Oilers Zach Hyman. "LeBron James nehraje před pěti tisíci lidmi. Tak proč by měl Connor McDavid? Je to trochu šílené. Chceme být ve stejné sféře jako NFL, NBA nebo MLB. Tak takhle to přeci nejde."

Ve svém zklamání rozhodně není sám.

"Je zklamání, že něco takového dovolíme," řekl útočník Maple Leafs Ryan Reaves. "Víte, pět tisíc fanoušků není to, o čem NHL je. Snažíme se rozvíjet hokej a tímhle se tedy moc neposouváme."

Kapacita je výrazně nižší než v Canada Life Centre ve Winnipegu (15 325 diváků), které bylo dlouho nejmenším stadionem v NHL, dokud se Coyotes nepřestěhovali do Mullett Areny. 

"Je třeba s tím něco udělat. Ať už se přestěhují v rámci Arizony, nebo odtamtud odejdou. Podle mě na to není nejlepší pohled," řekl Reaves.

Výkonný ředitel Hráčské asociace NHL Marty Walsh dal najevo svou nespokojenost během víkendu hvězd NHL v Torontu a označil situaci za nepřijatelnou.

Co bude dál? Majitel Coyotes Alex Meruelo doufá, že na jaře koupí v aukci na severu Phoenixu nemovitost pro výstavbu, jejíž součástí by byl hokejový stadion s kapacitou 16 tisíc míst. V nejlepším případě by se po koupi ihned začalo kopat do země a mohlo by být otevřeno v sezoně 2027/28. To by znamenalo celkem pět ročníků v Mullett Areně.

Hovoří se ale také o relokaci, jelikož projevila zájem města jako Salt Lake City a Atlanta, zatímco stadiony připravené pro NHL existují v Quebecu, Houstonu a Kansas City.

Hráči si tak musí počkat a nic neovlivní. "Alespoň mají dobrý led," prohodil Reaves.

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

RSS | Kontakt | Všeobecné obchodní podmínky a pravidla | Cookies | Nastavení soukromí | Reklama - Provozovatel BPA sport marketing a.s. ve spolupráci s eSports, s.r.o.

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: 20, time: 48.679 ms, default

Time msSQL QueryRows
0.078
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:17
0
0.947
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` = '5030735')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpostconstPRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_indexPRIMARY4const1
3DEPENDENT SUBQUERYImpossible WHERE noticed after reading const tables
2DEPENDENT SUBQUERYphotoconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:508
1
43.069
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 ('5030735')) 
ORDER BY `publish_date` DESC 
LIMIT 4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpostindex_mergePRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_index,recommendrecommend,fk_post_post_state,fk_post_post_type1,4,4344Using intersect(recommend,fk_post_post_state,fk_post_post_type); Using where; Using filesort
3DEPENDENT SUBQUERYfileeq_refPRIMARY,id_UNIQUEPRIMARY4test_dev_nhlcz_s6_esports_cz.post.file_id1
2DEPENDENT SUBQUERYphotoeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post.photo_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArticlePresenter.php:61
4
0.053
explain
SELECT `id`, `setting` 
FROM `web_settings` 
WHERE (`code` = 'article_advert') 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEweb_settingsrefcodecode767const1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Setting/SettingService.php:55
1
0.266
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` = '5030735')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostconstPRIMARY,id_UNIQUEPRIMARY4const1
1SIMPLEuserconstPRIMARY,id_UNIQUEPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69
1
0.511
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` = 5030735)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpostconstPRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_indexPRIMARY4const1
3DEPENDENT SUBQUERYImpossible WHERE noticed after reading const tables
2DEPENDENT SUBQUERYphotoconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:508
1
0.207
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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYImpossible WHERE
3DEPENDENT SUBQUERYfileeq_refPRIMARY,id_UNIQUEPRIMARY4test_dev_nhlcz_s6_esports_cz.post.file_id1
2DEPENDENT SUBQUERYphotoeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post.photo_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:630
0
0.181
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` = 5030735) AND (`post_2_tag`.`tag_type_id` = 1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_2_tagrefPRIMARY,tag_type_idPRIMARY4const1Using where
1SIMPLEtageq_refPRIMARY,id_UNIQUEPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_tag.tag_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:201
0
0.178
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` = 5030735) AND (`post_2_category`.`hidden_in_post` = 0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_2_categoryrefPRIMARYPRIMARY4const1Using where
1SIMPLEcategoryeq_refPRIMARY,id_UNIQUEPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_category.category_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:202
1
0.118
explain
SELECT `id` 
FROM `post` 
WHERE (`id` IN (5030735))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostconstPRIMARY,id_UNIQUEPRIMARY4const1Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:202
1
0.195
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` = 5030735)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_2_stats_playerrefPRIMARYPRIMARY4const1Using index
1SIMPLEstats_playereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_player.stats_player_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:230
0
0.254
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` = 5030735)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpost_2_stats_clubrefPRIMARYPRIMARY4const1Using index
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_club.stats_club_id1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_club.stats_club_id1
2DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:243
0
0.513
UPDATE `post` 
SET `impression_count`=`impression_count` + 1 
WHERE (`post`.`id` = '5030735')
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:186
1
0.174
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`user` 
WHERE (`id` IN (129083))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARY,id_UNIQUEPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Article-templates-Article-default-latte-d42cc623bbdaee503d733ca2e384307e.php:194
1
0.165
explain
SELECT `id`, `user_id` 
FROM `post_2_user` 
WHERE (`post_id` = '5030735')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_2_userrefpost_idpost_id4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Article-templates-Article-default-latte-d42cc623bbdaee503d733ca2e384307e.php:61
0
0.217
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` = '5030735') 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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_2_categoryrefPRIMARY,category_idPRIMARY4const1Using where
1SIMPLEcategoryeq_refPRIMARY,id_UNIQUEPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_category.category_id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Article-templates-Article-default-latte-d42cc623bbdaee503d733ca2e384307e.php:93
0
0.125
explain
SELECT `post_id`, `stats_player_id` 
FROM `post_2_stats_player` 
WHERE (`post_id` = '5030735')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_2_stats_playerrefPRIMARYPRIMARY4const1Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Article-templates-Article-default-latte-d42cc623bbdaee503d733ca2e384307e.php:93
0
0.265
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` = '5030735')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpost_2_stats_clubrefPRIMARYPRIMARY4const1Using index
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_club.stats_club_id1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_club.stats_club_id1
2DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using 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
0.246
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` = '5030735') AND (`team`.`stats_club_id` IS NOT NULL)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpost_2_stats_teamrefPRIMARY,stats_team_idPRIMARY4const1Using index
1PRIMARYteameq_refPRIMARY,stats_club_idPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_team.stats_team_id1Using where
1PRIMARYstats_teameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_team.stats_team_id1Using index
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id1
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using 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
0.917
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 ('5030735', 5030871, 5030847, 5030843, 5030790)) 
ORDER BY `publish_date` DESC 
LIMIT 4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpostrefPRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,topstory,show_on_hompage,post_article_base_indexpost_article_base_index8const,const11314Using where
3DEPENDENT SUBQUERYfileeq_refPRIMARY,id_UNIQUEPRIMARY4test_dev_nhlcz_s6_esports_cz.post.file_id1
2DEPENDENT SUBQUERYphotoeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post.photo_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/test-app-Front-templates-blocks-articles-latte-e8402771c740c09b2165a479ad74b8b0.php:39
4
¤ ×

Unlogged

no identity

¤ ×

Front:Article:Article:default

https://test.nhlcz.s6.esports.cz/hracum-dochazi-trpelivost-hrat-v-arizone-se-moc-neda-jak-se-mame-vyrovnat-nba-lateri-hyman/5030735

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 = hracum-dochazi-trpelivost-hrat-v-arizone-se-moc-neda-jak-se-mame-vyrovnat-nba-lateri-hyman
id = 5030735
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

¤ ×