bahis siteleri

NHL.cz na Facebooku

Německý mladík proti Torontu řádil a prohloubil jeho herní krizi

9. listopadu 2023, 19:50

Viktor Pavlovec

Pět proher z posledních šesti bitev. To je hrozivá bilance Maple Leafs, kteří na domácím ledě nestačili na Ottawu. Javorové listy si svou krizi vybraly ve dvanácté minutě třetí části po trefě Dominika Kubalíka. Tim Stützle, který drze připravil závěrečnou trefu, na sebe upozornil čtyřmi body a jeho útok jich nasbíral celkem deset.

Tim Stützle v utkání zaznamenal gól a tři asistence. Jeho Ottawa Senators vstřelila tři góly v řadě během tří minut a jedenácti sekund v závěrečné části základní hrací doby. Toronto tak opět inkasovalo moře branek a padlo 3:6. V součtu z posledních tří duelů spadlo do klece Maple Leafs hrozivých 17 puků!

„Cítil jsem, že dnes večer chci hrát s pukem co nejvíce a myslím, že se rozjela celá naše lajna,” řekl Stützle. „Celý zápas jsme měli puk na holích, vytvářeli jsme si šance a zůstávali na puku.”     

Naopak klání opět nevyšlo Torontu, které ztratilo zápas během pár minut, kdy za vyrovnaného stavu 3:3 udeřili Senátoři a rázem vedli o tři trefy. 

„Bojovali jsme docela dobře, ale dostali jsme tvrdou ránu, a pak jsme to nějak prohráli,” řekl útočník Maple Leafs William Nylander. „Ale myslím, že čelíme jen nepřízni osudu. Potřebujeme růst a budovat. Máme tady spoustu nových kluků, takže budujeme týmovou chemii a pracujeme na tom.”

S herním výpadkem byl výrazně nespokojen hlavní lodivod střídačky Toronta.

„Musíme dát naši hru do pořádku a udělat vše, co je v našich silách, abychom se o sebe v tabulce postarali. Musíme také pomoci klukům, kteří se na svých postech trápí.”

„Některé naše chyby byly individuální, některé kolektivní v rámci týmu. Oslavujeme kluky, kteří dosahují velkých čísel v tabulce kanadského bodování, ale nemluvíme dost o tom, jak se trápíme v obraně. To je realita. Musíme dát přednost té herní strategii, abychom nedostávali tolik branek. 

Ottawa zvítězila po dvou neúspěších a snaží se dokázat svým nespokojeným fanouškům, že jde jen o malé výkyvy a tým je v dobré formě.

„Mluvili jsme o tom několik týdnů,” řekl Giroux. „Chceme hrát konzistentně. Ze zápasu máme dobrý pocit. Jsme spokojeni s tím, jak jsme hráli.”

„Je to těžké, vždy chcete vyhrát,” řekl Stützle. „Nesnáším prohry. Myslím, že to tak má celý tým, každý v kabině ví, že jde jen o vítězství v zápasech. Je kolem nás spousta mediálního šumu, ale myslím, že jsme ukázali, že umíme vyhrávat. Podle mě jsme hráli skvěle. Korpisalo byl také skvělý a držel nás celou dobu ve hře.“

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

Time msSQL QueryRows
0.121
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:17
0
1.218
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` = '5029974')
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
22.953
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 ('5029974')) 
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.222
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.689
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` = '5029974')
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.450
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` = 5029974)
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.238
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.228
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` = 5029974) 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.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` = 5029974) 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
0
0.199
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` = 5029974)
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.245
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` = 5029974)
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.775
UPDATE `post` 
SET `impression_count`=`impression_count` + 1 
WHERE (`post`.`id` = '5029974')
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:186
1
22.581
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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEleagueconstPRIMARY,codecode768const1Using index
1SIMPLEcompetitionrefPRIMARY,league_idleague_id5const273Using where; Using index
1SIMPLEstats_matchrefPRIMARY,fk_stats_match_stats_competition1fk_stats_match_stats_competition15test_dev_nhlcz_s6_esports_cz.competition.id21Using where
1SIMPLEmatch_betrefPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/presenters/BasePresenter.php:112
0
0.168
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`user` 
WHERE (`id` IN (129349))
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.145
explain
SELECT `id`, `user_id` 
FROM `post_2_user` 
WHERE (`post_id` = '5029974')
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.242
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` = '5029974') 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.157
explain
SELECT `post_id`, `stats_player_id` 
FROM `post_2_stats_player` 
WHERE (`post_id` = '5029974')
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.266
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` = '5029974')
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.706
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` = '5029974') 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.826
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 ('5029974', 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/nemecky-mladik-proti-torontu-radil-a-prohloubil-jeho-herni-krizi/5029974

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 = nemecky-mladik-proti-torontu-radil-a-prohloubil-jeho-herni-krizi
id = 5029974
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

¤ ×