9. května 2016, 9:00
David BalášOsm dní. Jen tak dlouho zůstal bez práce uznávaný kouč Bruce Boudreau. Poté co jej propustilo vedení Anaheimu, kývl jedenašedesátiletý muž velmi záhy na nabídku Minnesoty. Zároveň tím však překazil plány ottawskému generálnímu manažerovi Pierru Dorionovi, jenž ho chtěl získat do svých řad. Dorion však dlouho neotálel a ani ne čtyřiadvacet hodin nato angažoval Guye Bouchera, který se do NHL vrací po téměř dvouletém působení ve Švýcarsku.
„Poslední tři týdny Pierre spolu s kolegy hledali usilovně toho nejvhodnějšího kandidáta, který má tým nasměrovat na správnou cestu. Po prostudování všech detailů o možných adeptech jsme dospěli k jednoznačnému verdiktu, že Guy je tím pravým člověkem. Chtěli jsme prvotřídního trenéra a takového jsme v něm našli. Nemůžu být šťastnější,“ volil diplomatická slova vlastník Senátorů Eugene Melnyk, který nechtěl naplno přiznat, že Boucher byl pravděpodobně náhradní možností za Boudreaua.
Jisté ovšem je, že byl Kanaďan mezi dvěma nejžhavějšími kandidáty. Už před pár dny totiž Melnyk médiím prozradil, že svému generálnímu manažerovi zadal jasný úkol: Sniž do víkendu výběr na pouhé dva kouče a z nich jednoho vybereme. Poté co Boudreau podepsal s Minnesotou, volba bez váhání padla na Bouchera.
Ten nyní bude moci znovu dokázat, co v něm vězí. V lize koučoval naposledy ve výlukou zkrácené sezoně 2012/2013 Tampu Bay a během svého angažmá dovedl tým v roce 2011 až do finále Východní konference. Právě poslední sezona u Blesků mu však nevyšla podle představ a vedení klubu jej nahradilo Jonem Cooperem. Boucher se odebral do Švýcarska, kde s Bernem vyhrál Švýcarský pohár. I tam však nakonec dostal vyhazov, když mu nevyšel podle představ vstup do letošního ročníku.
Vedení Ottawy si od čtyřiačtyřicetiletého muže s jizvou na pravé tváři slibuje postrčení mužstva k lepším výkonům. Senátoři dvakrát z posledních třech sezon neproklouzli do play-off, a když už se do něj v nedávné době dostali, za devět let se jim podařilo ovládnout jedinou sérii. Letos navíc týmu brána do vyřazovacích bojů zůstala vzdálená o jedenáct bodů.
Boucher bude mít k dispozici poměrně silnou sestavu plnou mladíků, se kterými by mohl mít slušný prostor k manévrování. V obraně bude spoléhat na jednoho z nejlepších obránců na světě Erika Karlssona, vepředu zase na nadějné borce Mika Hoffmana, Bobby Ryana či Kyla Turrise a Marka Stona. Ti všichni jsou v perfektním věku a v příští sezoně by mohli mít ještě výraznější vliv na hru svého týmu.
Vítěz Spenglerova poháru – nejstaršího hokejového turnaje planety – z konce minulého roku, kdy se mu zadařilo s národním výběrem Kanady, se do zámoří málem vydal už před současnou sezony. Loni na jaře po něm vážně pošilhávalo Toronto, se kterým se Boucher několikrát sešel. Slavný klub s javorovým listem na dresu však nakonec v květnu ukázal prstem na jistotu v podobě Mika Babcocka.
Boucher snahu o návrat na nejzářivější scénu nevzdal a nyní před ním leží další velká výzva. Uspěje bývalý nejlepší trenér roku AHL a dovede talentované mužstvo Ottawy do play-off?
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.056 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 0 | ||||||||||||||||||||
2.178 | SHOW FULL TABLES/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 254 | ||||||||||||||||||||
0.336 | SHOW FULL COLUMNS FROM `adhoc_stream`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.141 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.457 | SHOW FULL COLUMNS FROM `admin_module`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
0.216 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.303 | SHOW FULL COLUMNS FROM `available_video`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
1.481 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.412 | SHOW FULL COLUMNS FROM `best_player_poll`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
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 = 'best_player_poll'
| 2 | ||||||||||||||||||||
0.363 | 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.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 = 'best_player_poll_category'
| 1 | ||||||||||||||||||||
0.427 | 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.299 | 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.560 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.303 | 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.399 | 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.703 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.344 | SHOW FULL COLUMNS FROM `bet_company`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.136 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.253 | SHOW FULL COLUMNS FROM `bet_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.168 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.276 | SHOW FULL COLUMNS FROM `category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 11 | ||||||||||||||||||||
0.187 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.292 | SHOW FULL COLUMNS FROM `color`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.137 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.308 | SHOW FULL COLUMNS FROM `contest`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
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 = 'contest'
| 0 | ||||||||||||||||||||
0.240 | SHOW FULL COLUMNS FROM `contest_answer`/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 = 'contest_answer'
| 1 | ||||||||||||||||||||
0.264 | SHOW FULL COLUMNS FROM `contest_answer_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
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 = 'contest_answer_item'
| 2 | ||||||||||||||||||||
0.344 | SHOW FULL COLUMNS FROM `contest_answer_value`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
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 = 'contest_answer_value'
| 2 | ||||||||||||||||||||
0.322 | SHOW FULL COLUMNS FROM `contest_question`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
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 = 'contest_question'
| 2 | ||||||||||||||||||||
0.366 | SHOW FULL COLUMNS FROM `contest_question_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.178 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.359 | SHOW FULL COLUMNS FROM `contest_question_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
1.856 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.449 | SHOW FULL COLUMNS FROM `country`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.143 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.284 | SHOW FULL COLUMNS FROM `error`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.260 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.259 | SHOW FULL COLUMNS FROM `error_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.143 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.261 | SHOW FULL COLUMNS FROM `export_subscriber`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.141 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.273 | SHOW FULL COLUMNS FROM `facebook_ticket_competition`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 7 | ||||||||||||||||||||
0.218 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.284 | SHOW FULL COLUMNS FROM `file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
3.137 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.262 | SHOW FULL COLUMNS FROM `file_2_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_2_tag'
| 2 | ||||||||||||||||||||
0.311 | SHOW FULL COLUMNS FROM `file_source`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
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 = 'file_source'
| 0 | ||||||||||||||||||||
0.472 | SHOW FULL COLUMNS FROM `file_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
1.347 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.354 | SHOW FULL COLUMNS FROM `file_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.143 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.277 | SHOW FULL COLUMNS FROM `filedir`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
1.378 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.267 | SHOW FULL COLUMNS FROM `fix_match`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.176 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.287 | SHOW FULL COLUMNS FROM `folder`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.150 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.381 | 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.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 = 'folder_2_stats_club'
| 2 | ||||||||||||||||||||
0.345 | SHOW FULL COLUMNS FROM `folder_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.151 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.273 | SHOW FULL COLUMNS FROM `gallery`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.566 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.288 | SHOW FULL COLUMNS FROM `gallery_2_file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 9 | ||||||||||||||||||||
1.360 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.268 | SHOW FULL COLUMNS FROM `gallery_image_text`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
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 = 'gallery_image_text'
| 1 | ||||||||||||||||||||
0.332 | SHOW FULL COLUMNS FROM `gallery_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 14 | ||||||||||||||||||||
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 = 'gallery_photo'
| 1 | ||||||||||||||||||||
0.259 | 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.150 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.247 | 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.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 = 'gallery_photo_2_tag'
| 2 | ||||||||||||||||||||
0.284 | SHOW FULL COLUMNS FROM `guess`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
0.143 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.260 | SHOW FULL COLUMNS FROM `guess_2_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.157 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.307 | SHOW FULL COLUMNS FROM `guess_has_winner`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.154 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.384 | SHOW FULL COLUMNS FROM `guess_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
0.150 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.269 | SHOW FULL COLUMNS FROM `import`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.270 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.258 | SHOW FULL COLUMNS FROM `import_problem`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
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 = 'import_problem'
| 0 | ||||||||||||||||||||
0.260 | SHOW FULL COLUMNS FROM `importer_watchdog`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.143 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.286 | 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/ze-svycarska-zpatky-do-nhl-ottawa-povolala-ke-kormidlu-guye-bouchera/5009427
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