25. prosince 2020, 13:04
Patrik CzepiecZatímco juniorský výběr Kanady si své vůdčí osobnosti vybral poměrně dlouhou dobu před mistrovstvím světa do 20 let, mužstvo USA zvolilo jiný klíč a svého kapitána společně s asistenty jmenovalo den před zahajovacím utkáním turnaje. Před Camem Yorkem a jeho pobočníky Colem Caufieldem a Alexem Turcottem stojí náročný úkol: dovést USA po čtyřleté pauze zpátky ke zlatu.
Říká se, že juniorský program Spojených států amerických nemá ve světě obdoby. Experti se shodují, že nepotrvá dlouho a USA spolknou i kolébku ledního hokeje, tedy Kanadu. Jenže úspěchy z posledních let tuto tezi zdaleka nepotvrzují. Přestože USA vychovaly loňskou jedničku draftu Jacka Hughese, na triumf na juniorském šampionátu čekají už nějaký ten pátek.
Naposledy země hvězd a pruhů pozvedla juniorské zlato na přelomu let 2016 a 2017. Z tehdejšího týmu dnes již několik hráčů pravidelně nastupuje v NHL. Jake Oettinger a Tyler Parsons si dělají naději na post jedničky v Dallasu, respektive Calgary. Adam Fox vyrůstá u newyorských Rangers v kandidáta na Norris Trophy, Charlie McAvoy zase v Bostonu už možná definitivně zastínil Zdena Cháru. Clayton Keller v mladém věku táhne ofenzivu Arizony a Jack Roslovic (Winnipeg), Luke Kunin a Jordan Greenway (oba do loňské sezony Minnesota) jsou poctivými pracanty v řadách svých týmů.
Co vyroste ze současné skvadry, to zatím není zdaleka jasné. Jenže právě zvolení do podstatných pozic v týmové hierarchii může Cameronu Yorkovi, Coleu Caufieldovi a Alexi Turcottovi výrazně pomoci blíže do NHL.
York doposud působil na Univerzitě v Michiganu, kde hodlá dokončit i současnou sezonu. Před šampionátem stihl za osm utkání posbírat pět bodů, na draftu 2019 si jej Flyers vytáhli ze 14. místa pořadníku. Jestli u něj skauti něco vyzdvihují, pak velký přehled při bránění a celkovou schopnost odebírání kotoučů. Do sestavy Philadelphie se v posledních dvou letech prosadil nedraftovaný objev Philippe Myers, avšak York může být ještě silnější šálek kávy.
“Jsem opravdu vděčný klukům, že mě zvolili kapitánem,” přiznal York ve vyjádření pro theScore. “Je to obrovská pocta. Jsem opravdu zvědavý, co tento tým dokáže, protože disponuje velkým talentem. Zároveň tvoříme skvělou partu, staráme se jeden o druhého.”
USA nejsou pasovány do role jednoznačného favorita na zisk titulu. Ten se čeká zejména od domácí Kanady. Ta už ale v minulosti mnohokrát ukázala, že nedokáže unést tlak mistrovství světa konaného na její půdě. V roce 2019 skončila už ve čtvrtfinále. A právě ve zmiňovaném roce 2017 se USA přesvědčily, že jsou schopné svého úhlavního rivala porazit v nejdůležitější části turnaje. Tehdejší mužstvo ve strhujícím finále vyhrálo 5:4 po nájezdech, na poražené straně stála jména jako Carter Hart, Thomas Chabot, Anthony Cirelli či Mathew Barzal.
Také asistenti Cole Caufield a Alex Turcotte zakotvili v prvním kole draftu 2019. Caufield z patnáctého místa mířil do Montrealu, Turcotte znal svého zaměstnavatele dokonce už po pátém výběru, který tehdy vlastnili zástupci Los Angeles.
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.
Time ms | SQL Query | Rows | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.059 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 0 | ||||||||||||||||||||
2.207 | SHOW FULL TABLES/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 254 | ||||||||||||||||||||
0.363 | SHOW FULL COLUMNS FROM `adhoc_stream`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.173 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'adhoc_stream'
| 0 | ||||||||||||||||||||
0.388 | SHOW FULL COLUMNS FROM `admin_module`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
0.196 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'admin_module'
| 0 | ||||||||||||||||||||
0.336 | SHOW FULL COLUMNS FROM `available_video`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
1.268 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'available_video'
| 1 | ||||||||||||||||||||
0.358 | SHOW FULL COLUMNS FROM `best_player_poll`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
0.188 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll'
| 2 | ||||||||||||||||||||
0.320 | SHOW FULL COLUMNS FROM `best_player_poll_category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.158 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_category'
| 1 | ||||||||||||||||||||
0.350 | SHOW FULL COLUMNS FROM `best_player_poll_coach`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
0.192 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_coach'
| 2 | ||||||||||||||||||||
0.307 | SHOW FULL COLUMNS FROM `best_player_poll_coach_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.801 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_coach_vote'
| 1 | ||||||||||||||||||||
0.370 | SHOW FULL COLUMNS FROM `best_player_poll_player`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
0.201 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_player'
| 2 | ||||||||||||||||||||
0.294 | SHOW FULL COLUMNS FROM `best_player_poll_player_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.625 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_player_vote'
| 1 | ||||||||||||||||||||
0.300 | SHOW FULL COLUMNS FROM `bet_company`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.161 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bet_company'
| 0 | ||||||||||||||||||||
0.282 | SHOW FULL COLUMNS FROM `bet_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.147 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bet_type'
| 0 | ||||||||||||||||||||
0.320 | SHOW FULL COLUMNS FROM `category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 11 | ||||||||||||||||||||
0.211 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'category'
| 3 | ||||||||||||||||||||
0.295 | SHOW FULL COLUMNS FROM `color`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.169 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'color'
| 0 | ||||||||||||||||||||
0.304 | SHOW FULL COLUMNS FROM `contest`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
0.177 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest'
| 0 | ||||||||||||||||||||
0.276 | SHOW FULL COLUMNS FROM `contest_answer`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.163 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_answer'
| 1 | ||||||||||||||||||||
0.270 | SHOW FULL COLUMNS FROM `contest_answer_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.167 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_answer_item'
| 2 | ||||||||||||||||||||
0.284 | SHOW FULL COLUMNS FROM `contest_answer_value`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.173 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_answer_value'
| 2 | ||||||||||||||||||||
0.302 | SHOW FULL COLUMNS FROM `contest_question`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
0.169 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question'
| 2 | ||||||||||||||||||||
0.302 | SHOW FULL COLUMNS FROM `contest_question_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.162 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question_item'
| 1 | ||||||||||||||||||||
0.257 | SHOW FULL COLUMNS FROM `contest_question_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.161 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question_type'
| 0 | ||||||||||||||||||||
0.283 | SHOW FULL COLUMNS FROM `country`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.160 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'country'
| 0 | ||||||||||||||||||||
0.277 | SHOW FULL COLUMNS FROM `error`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.257 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'error'
| 1 | ||||||||||||||||||||
0.302 | SHOW FULL COLUMNS FROM `error_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.175 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'error_type'
| 0 | ||||||||||||||||||||
0.356 | SHOW FULL COLUMNS FROM `export_subscriber`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.163 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'export_subscriber'
| 0 | ||||||||||||||||||||
0.366 | SHOW FULL COLUMNS FROM `facebook_ticket_competition`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 7 | ||||||||||||||||||||
0.298 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'facebook_ticket_competition'
| 0 | ||||||||||||||||||||
0.464 | SHOW FULL COLUMNS FROM `file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
5.385 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file'
| 3 | ||||||||||||||||||||
0.389 | SHOW FULL COLUMNS FROM `file_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.173 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_2_tag'
| 2 | ||||||||||||||||||||
0.326 | SHOW FULL COLUMNS FROM `file_source`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.162 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_source'
| 0 | ||||||||||||||||||||
0.342 | SHOW FULL COLUMNS FROM `file_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.148 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_tag'
| 0 | ||||||||||||||||||||
0.302 | SHOW FULL COLUMNS FROM `file_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.170 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_type'
| 0 | ||||||||||||||||||||
0.354 | SHOW FULL COLUMNS FROM `filedir`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
1.321 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'filedir'
| 0 | ||||||||||||||||||||
0.271 | SHOW FULL COLUMNS FROM `fix_match`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.146 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'fix_match'
| 0 | ||||||||||||||||||||
0.377 | SHOW FULL COLUMNS FROM `folder`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.164 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'folder'
| 0 | ||||||||||||||||||||
0.288 | SHOW FULL COLUMNS FROM `folder_2_stats_club`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.182 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'folder_2_stats_club'
| 2 | ||||||||||||||||||||
0.289 | SHOW FULL COLUMNS FROM `folder_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.181 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'folder_2_tag'
| 2 | ||||||||||||||||||||
0.288 | SHOW FULL COLUMNS FROM `gallery`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.605 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery'
| 0 | ||||||||||||||||||||
0.324 | SHOW FULL COLUMNS FROM `gallery_2_file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 9 | ||||||||||||||||||||
1.410 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_2_file'
| 3 | ||||||||||||||||||||
0.317 | SHOW FULL COLUMNS FROM `gallery_image_text`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.181 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_image_text'
| 1 | ||||||||||||||||||||
0.386 | SHOW FULL COLUMNS FROM `gallery_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 14 | ||||||||||||||||||||
1.332 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_photo'
| 1 | ||||||||||||||||||||
0.318 | SHOW FULL COLUMNS FROM `gallery_photo_2_stats_player`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.171 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_photo_2_stats_player'
| 2 | ||||||||||||||||||||
0.260 | SHOW FULL COLUMNS FROM `gallery_photo_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.156 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_photo_2_tag'
| 2 | ||||||||||||||||||||
0.281 | SHOW FULL COLUMNS FROM `guess`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
0.123 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess'
| 0 | ||||||||||||||||||||
0.276 | SHOW FULL COLUMNS FROM `guess_2_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.170 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_2_photo'
| 2 | ||||||||||||||||||||
0.277 | SHOW FULL COLUMNS FROM `guess_has_winner`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.147 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_has_winner'
| 2 | ||||||||||||||||||||
0.314 | SHOW FULL COLUMNS FROM `guess_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
0.172 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_vote'
| 1 | ||||||||||||||||||||
0.291 | SHOW FULL COLUMNS FROM `import`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.331 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'import'
| 0 | ||||||||||||||||||||
0.294 | SHOW FULL COLUMNS FROM `import_problem`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.186 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'import_problem'
| 0 | ||||||||||||||||||||
0.286 | SHOW FULL COLUMNS FROM `importer_watchdog`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.167 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'importer_watchdog'
| 0 | ||||||||||||||||||||
0.272 | SHOW FULL COLUMNS FROM `impression_article_count`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 1 |
...and more
no identity
https://dev.nhlcz.s6.esports.cz/kdo-povede-usa-za-patym-titulem-budouci-tahoun-defenzivy-flyers/5022739
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
test/<presenter>/<action>[/<id>] |
module = Test |
Test |
|
no | Route |
<module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] |
action = default |
Export |
|
no | Route |
admin/<module>/<presenter>/<action>[/<id>] |
module = Dashboard |
Admin |
|
no | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
|
no | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
|
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/infinitive-scroll |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
yes | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
Front:Article:Article:default |
no | ArticleCompatRoute |
<slug [a-zA-Z-0-9\-]+> |
module = Article |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] |
module = League |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> |
module = MinorLeague |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] |
module = League |
Front |
|
no | Route |
<module>/<presenter>/<action>[/<id>] |
id = |
Front |
Front\Article\ArticlePresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/Article/presenters/ArticlePresenter.php:27