2. července 2020, 7:00
Jiří LacinaJe to trochu paradox. NHL tři a půl měsíce stojí, hráči nehrají, přesto se řada z nich při pohledu na bankovní účet zaraduje. Podle informace ESPN, kterou převzala většina zámořských serverů, vyplatily kluby NHL 1. července hráčům plné podpisové bonusy.
Jak se sluší a patří.
Celkově má jít o sumu přes 300 miliónů dolarů. Nebezpečný precedens se poslední dobou rozjel v NHL jako sněhová koule. Je možné, že budou chtít majitelé tuto praxi do budoucna omezit. Zatím jede vše ve starých kolejích. Obě strany se toto úterý dohodly, že nebudou platby navzdory tíživé aktuální situaci zadržovat ani odkládat.
The expectation is that NHL players will be paid their 2020-21 contract year signing bonuses tomorrow on July 1, as scheduled. That’s an NHL expenditure of more than $300 million.
— Bob McKenzie (@TSNBobMcKenzie) July 1, 2020
Hráči jsou normálně placení v základní části ve čtrnáctidenních termínech. Podpisový bonus znamená, že dostanou část této sumy na začátku sezóny, většinou k 1. červenci. Vrcholem ekonomického exhibicionismu se stala výplata drtivé většiny roční mzdy v tento den (aspoň část musí být vyplácena standardně). Mistrem v rozdávání je Kyle Dubas z Toronta.
Největší sumy putovaly podle capfriendly.com na účty Austona Matthewse (15,2 mil.) a Mitche Marnera (14,3 mil.). Pro představu, po výplatě těchto částek rozdělí klub v nadcházející sezóně oběma v běžných výplatách už jen po 700 tisících. Svoje dostal loni a předloni (15,25 a 14,99 mil.) také John Tavares, letos to bude už "jen" 11,99 mil. Connor McDavid z Edmontonu zinkasuje 13 miliónů. Jezdec Artěmij Panarin 12 mil.
Za normálních okolností nemusí tento způsob až tolik vadit, pokud je klub dostatečně likvidní. Tzn. má dost hotovosti. Toronto patří k nejbohatším organizacím v NHL, nepochybně disponuje i největšími úvěrovými rámci. Aktuální situace je ale mimořádná. Minulá základní část nebyla dohrána a výdaje začínají předbíhat příjmy. Nikdo navíc neví, kdy a za jakých okolností vůbec začne další sezóna.
Je to jako platit dopředu za nákup, přesněji řečeno roční nákup(y), o nichž netušíte, zda a kdy vám budou doručeny. Právě o tohle hráčům, respektive jejich agentům, šlo.
V západním světě se tomu říká sociální jistoty.
Liga i Hráčská asociace nadále intenzivně jednají o volbě lokalit pro dohrání sezóny, jasno bude možná brzo také o podobě nové kolektivní smlouvy. Novinářské veličiny - Elliotte Friedman a Pierre LeBrun - už ve středu souběžně informovaly, že hokejisté možná nebudou chybět na příští olympiádě.
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.075 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 0 | ||||||||||||||||||||
1.671 | SHOW FULL TABLES/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 254 | ||||||||||||||||||||
0.358 | SHOW FULL COLUMNS FROM `adhoc_stream`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.193 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.352 | SHOW FULL COLUMNS FROM `admin_module`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
0.207 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.305 | SHOW FULL COLUMNS FROM `available_video`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
0.992 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.174 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.283 | 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.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 = 'best_player_poll_category'
| 1 | ||||||||||||||||||||
0.281 | 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.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_coach'
| 2 | ||||||||||||||||||||
0.274 | 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.650 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.276 | 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.183 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.277 | 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.635 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.294 | SHOW FULL COLUMNS FROM `bet_company`/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 = 'bet_company'
| 0 | ||||||||||||||||||||
0.275 | SHOW FULL COLUMNS FROM `bet_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
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 = 'bet_type'
| 0 | ||||||||||||||||||||
0.303 | SHOW FULL COLUMNS FROM `category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 11 | ||||||||||||||||||||
0.217 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.262 | SHOW FULL COLUMNS FROM `color`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
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 = 'color'
| 0 | ||||||||||||||||||||
0.269 | SHOW FULL COLUMNS FROM `contest`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
0.139 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.265 | SHOW FULL COLUMNS FROM `contest_answer`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.152 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.280 | SHOW FULL COLUMNS FROM `contest_answer_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.153 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.296 | SHOW FULL COLUMNS FROM `contest_answer_value`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.153 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.263 | SHOW FULL COLUMNS FROM `contest_question`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 6 | ||||||||||||||||||||
0.153 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.288 | SHOW FULL COLUMNS FROM `contest_question_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
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 = 'contest_question_item'
| 1 | ||||||||||||||||||||
0.243 | SHOW FULL COLUMNS FROM `contest_question_type`/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 = 'contest_question_type'
| 0 | ||||||||||||||||||||
0.258 | SHOW FULL COLUMNS FROM `country`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
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 = 'country'
| 0 | ||||||||||||||||||||
0.297 | SHOW FULL COLUMNS FROM `error`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.280 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.273 | 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.368 | SHOW FULL COLUMNS FROM `export_subscriber`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
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 = 'export_subscriber'
| 0 | ||||||||||||||||||||
0.351 | SHOW FULL COLUMNS FROM `facebook_ticket_competition`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 7 | ||||||||||||||||||||
0.238 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.295 | SHOW FULL COLUMNS FROM `file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
3.223 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.269 | SHOW FULL COLUMNS FROM `file_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.152 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.246 | SHOW FULL COLUMNS FROM `file_source`/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 = 'file_source'
| 0 | ||||||||||||||||||||
0.259 | SHOW FULL COLUMNS FROM `file_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.133 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.349 | SHOW FULL COLUMNS FROM `file_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
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 = 'file_type'
| 0 | ||||||||||||||||||||
0.287 | SHOW FULL COLUMNS FROM `filedir`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
1.464 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.270 | SHOW FULL COLUMNS FROM `fix_match`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
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 = 'fix_match'
| 0 | ||||||||||||||||||||
0.268 | SHOW FULL COLUMNS FROM `folder`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.142 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.306 | 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.165 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.254 | SHOW FULL COLUMNS FROM `folder_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
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 = 'folder_2_tag'
| 2 | ||||||||||||||||||||
0.281 | SHOW FULL COLUMNS FROM `gallery`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.606 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.404 | SHOW FULL COLUMNS FROM `gallery_2_file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 9 | ||||||||||||||||||||
2.295 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.492 | SHOW FULL COLUMNS FROM `gallery_image_text`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.219 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.479 | SHOW FULL COLUMNS FROM `gallery_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 14 | ||||||||||||||||||||
2.035 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.332 | 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.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_photo_2_stats_player'
| 2 | ||||||||||||||||||||
0.271 | 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.230 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.418 | SHOW FULL COLUMNS FROM `guess`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
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 = 'guess'
| 0 | ||||||||||||||||||||
0.268 | SHOW FULL COLUMNS FROM `guess_2_photo`/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_2_photo'
| 2 | ||||||||||||||||||||
0.239 | SHOW FULL COLUMNS FROM `guess_has_winner`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 2 | ||||||||||||||||||||
0.202 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.288 | SHOW FULL COLUMNS FROM `guess_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 10 | ||||||||||||||||||||
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 = 'guess_vote'
| 1 | ||||||||||||||||||||
0.268 | SHOW FULL COLUMNS FROM `import`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 4 | ||||||||||||||||||||
0.346 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.250 | SHOW FULL COLUMNS FROM `import_problem`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 5 | ||||||||||||||||||||
0.191 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.239 | SHOW FULL COLUMNS FROM `importer_watchdog`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17 | 3 | ||||||||||||||||||||
0.134 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.328 | 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/nehrajeme-bohatneme-nhl-vyplatila-podpisove-bonusy-jen-toronto-60-milionu/5021557
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