bahis siteleri

NHL.cz na Facebooku

NHL

PREVIEW: Islanders jdou do sezony s téměř nezměněným kádrem

19. září 2022, 19:30

Denisa Veselá

Od Ostrovanů se v uplynulém ročníku čekalo hodně. Nakonec však nepostoupili ani do vyřazovacích bojů. Během léta se však moc změn neudálo a do nového ročníku půjdou s téměř totožným celkem. Škatulata však proběhla na postu hlavního trenéra.

Loňská sezona budila mezi fanoušky veliká očekávání, však v uplynulých dvou ročnících se Isles dostali až do finále konference, v obou dvou případech však padli s Tampo Bay. V sezoně 2021/2022 na tyto úspěchy nenavázali a neprobojovali se ani do play off. Od druhé divoké karty, kterou si na Východě vybojoval Washington, je dělilo 16 bodů.

Kde jsou posily?

V průběhu léta se šuškalo, že se budou dít veliké věci. Naznačoval to i generální manažer Lou Lamoriello, ale nakonec se plány poněkud změnily a obrovská změna nastala pouze v trenérském obsazení. Od týmu byl odvolán Barry Trotz, kterého nahradí nováček mezi hlavními trenéry v NHL Lane Lambert. Bývalý hokejový útočník má však prostředí klubu kvalitně zmapované, jelikož od roku 2018 v Islanders působil jako pravá ruka hlavního trenéra, nyní se dočkal povýšení.

Jedinou velkou událostí, co se hráčského obsazení týče, byla výměna, která se uskutečnila ještě před výběrem nováčků. Ostrované poslali do Montrealu 13. volbu v 1. kole draftu, na oplátku obdrželi podpisová práva na ruského obránce Alexandera Romanova a volbu ve 4. kole.

Další aktivita na trhu s volnými hráči příliš nebyla. Došlo pouze na podepsání hráčů do zásoby či na farmu, ale žádné velké jméno na Long Island nezamíří. Dlouho se spekulovalo o příchodu Nazema Kadriho, ten však svou budoucnost viděl v Calgary.

Prodloužení smluv

Jedinou aktivitou, ve které Lou nezaostal byl podpis smluv s některými ostřílenými hokejisty. Nového kontraktu se dočkal pilíř obrany Noah Dobson, který podepsal na tři roky, během kterých si dohromady přijde na 12 milionů dolarů.

Podepsán byl i nováček Romanov, který zůstane také tři roky a roční výplata bude mít hodnotu 2,5 milionu.

Další oporou s jednocestným kontraktem je Kieffer Bellows, čtyřiadvacetiletý útočník dostal smlouvu pouze na rok v hodnotě 1,2 milionu dolarů. Čtvrtým do party je obránce Sebastian Aho, který podepsal na dva roky jen těsně nad úrovní ligového minima.

Jak tedy vypadá soupiska?

V brance pokračuje ozkoušená ruská dvojice Sorokin, Varlamov. Sice se na začátku ročníku čekalo, že jasnou jedničkou bude Varlamov, nakonec dopadlo vše jinak. Více prostoru dostal nakonec Ilja Sorokin, který byl o chlup lepší i řečí čísel. Předvedl mnoho parádních zákroků, úspěšnost zásahů se vyšplhala na 92,5 % a průměrně dostával 2,4 góly na zápas. Navrch se pyšnil i sedmi vychytanými nulami, mezi maskovanými muži zaostal v této statistice jen za Markströmem.

V obraně zažil průlomový ročník Noah Dobson, který si vysloužil novou smlouvu. Jak bude fungovat jeho spolupráce s Romanovem? To se uvidí, oba obránci jsou spíše ofenzivní, takže by mohli velmi často podporovat útok. Dále můžeme pozorovat starší mazáky Pulocka a Pelecha, kteří patří k defenzivním oporám mužstva.

Největší hvězdou útočných řad je bezesporu Matthew Barzal, který pravidelně sbírá hodně kanadských bodů. Do NHL vlétl jako uragán, v sezoně 2017/2018 posbíral 85 bodů, od té doby však své kariérní bodové maximum nedokázal vylepšit. Vloni se vedlo i Brocku Nelsonovi, který nastřílel 37 branek, čímž vytvořil své osobní maximum a v centru první formace se mu skvěle daří.

Nejmladším útočníkem na soupisce je Oliver Wahlstrom, kterému bude po následujícím ročníku končit nováčkovská smlouva. Dvaadvacetiletý útočník zatím odehrál v NHL 126 utkání, ve kterých si připsal 45 bodů. Definitivní přesun za moře by měl udělat Aatu Räty, počítá se s ním na farmě v Bridgeportu.

Predikce

Islanders by rádi opět útočili na play off. Jejich výhodou může být téměř nezměněný kádr oproti předchozímu roku a jistá sehranost, pokud tedy zůstanou útoky pospolu. Ale nic to nemění na tom, že jsou ve velmi těžké situaci, hladových vlčáků o pár míst ve vyřazovacích bojích je moc. V Metropolitní divizi by pod sebe museli dostat hned několik ambiciózních týmů. O postup zabojuje Carolina, Rangers, Pittsburgh či Washington. Postup Ostrovanů do play off sice není nemožný, ale pravděpodobnost je malá.

Založte si účet u Tipsportu a získejte vstupní bonus až 50 000 Kč! Navíc dostanete zdarma 500 Kč na své první sázky!

Aktuálně z nhl.cz

Tampa Bay má co vracet Dallasu, Arizona hostí Washington

4. prosince 2023, 20:55

Hynes vrátil hráčům ztracené sebevědomí a Minnesota se začíná pomalu zvedat

4. prosince 2023, 18:50

Vyznání jako od Sinatry! I love you, baby, slyšel Marchand od fanoušků. Dostal i santovskou čepici

4. prosince 2023, 15:00

Gretzky, Dionne, Pálffy? Ne, Králem asistencí je krotitel Lavin ze Slovinska

4. prosince 2023, 14:15

nhl.cz doporučuje

Hughes Family. Poprvé. Pohromadě. Proti sobě

4. prosince 2023, 16:15

Největší rivality v NHL: Volná jízda pro šestici vyvolených

3. prosince 2023, 17:58

Realita kolem Coreyho Perryho? Alkohol a zničená paní Bedardová

1. prosince 2023, 11:30

Největší rivality v NHL: Montreal vs. Toronto

26. listopadu 2023, 13:00

NHL.cz

Projekty

Organizace

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: 598, time: 334.338 ms, default

Time msSQL QueryRows
0.071
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
1.700
SHOW FULL TABLES
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		254
0.415
SHOW FULL COLUMNS 
FROM `adhoc_stream`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		5
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 =
'adhoc_stream'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.351
SHOW FULL COLUMNS 
FROM `admin_module`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		10
0.185
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		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.921
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.308
SHOW FULL COLUMNS 
FROM `best_player_poll`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		10
0.185
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.272
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.159
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.285
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.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 =
'best_player_poll_coach'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.238
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.638
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.359
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.179
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.374
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.680
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.276
SHOW FULL COLUMNS 
FROM `bet_company`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		4
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 = 'bet_company'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.265
SHOW FULL COLUMNS 
FROM `bet_type`
/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 = 'bet_type'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.319
SHOW FULL COLUMNS 
FROM `category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		11
0.189
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
0.288
SHOW FULL COLUMNS 
FROM `color`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
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 = 'color'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.292
SHOW FULL COLUMNS 
FROM `contest`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		6
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.406
SHOW FULL COLUMNS 
FROM `contest_answer`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		4
0.199
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.306
SHOW FULL COLUMNS 
FROM `contest_answer_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
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_answer_item'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.269
SHOW FULL COLUMNS 
FROM `contest_answer_value`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		4
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_answer_value'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.327
SHOW FULL COLUMNS 
FROM `contest_question`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		6
0.222
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.308
SHOW FULL COLUMNS 
FROM `contest_question_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		5
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 =
'contest_question_item'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.284
SHOW FULL COLUMNS 
FROM `contest_question_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 =
'contest_question_type'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.366
SHOW FULL COLUMNS 
FROM `country`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
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 = 'country'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.293
SHOW FULL COLUMNS 
FROM `error`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		5
0.276
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.274
SHOW FULL COLUMNS 
FROM `error_type`
/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 = 'error_type'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.327
SHOW FULL COLUMNS 
FROM `export_subscriber`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
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 =
'export_subscriber'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.308
SHOW FULL COLUMNS 
FROM `facebook_ticket_competition`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		7
0.252
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.365
SHOW FULL COLUMNS 
FROM `file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		10
4.949
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		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.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 = 'file_2_tag'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.286
SHOW FULL COLUMNS 
FROM `file_source`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
0.159
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.312
SHOW FULL COLUMNS 
FROM `file_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
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 = 'file_tag'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.276
SHOW FULL COLUMNS 
FROM `file_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
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 = 'file_type'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.258
SHOW FULL COLUMNS 
FROM `filedir`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		4
1.304
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.252
SHOW FULL COLUMNS 
FROM `fix_match`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		4
0.204
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.308
SHOW FULL COLUMNS 
FROM `folder`
/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 = 'folder'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.358
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.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 =
'folder_2_stats_club'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.373
SHOW FULL COLUMNS 
FROM `folder_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
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 =
'folder_2_tag'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.395
SHOW FULL COLUMNS 
FROM `gallery`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
1.036
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.403
SHOW FULL COLUMNS 
FROM `gallery_2_file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		9
2.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 =
'gallery_2_file'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
0.367
SHOW FULL COLUMNS 
FROM `gallery_image_text`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		5
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 =
'gallery_image_text'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.420
SHOW FULL COLUMNS 
FROM `gallery_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		14
1.242
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.286
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.155
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.268
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.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 =
'gallery_photo_2_tag'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.331
SHOW FULL COLUMNS 
FROM `guess`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		10
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 = 'guess'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.293
SHOW FULL COLUMNS 
FROM `guess_2_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
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 =
'guess_2_photo'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.275
SHOW FULL COLUMNS 
FROM `guess_has_winner`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
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_has_winner'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		2
0.308
SHOW FULL COLUMNS 
FROM `guess_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		10
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 = 'guess_vote'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		1
0.300
SHOW FULL COLUMNS 
FROM `import`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		4
0.308
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.435
SHOW FULL COLUMNS 
FROM `import_problem`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		5
0.185
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.355
SHOW FULL COLUMNS 
FROM `importer_watchdog`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		3
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 =
'importer_watchdog'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17		0
0.283
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

¤ ×

Unlogged

no identity

¤ ×

Front:Article:Article:default

https://dev.nhlcz.s6.esports.cz/preview-islanders-jdou-do-sezony-s-temer-nezmenenym-kadrem/5027261

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 /infinitive-scroll module = Home
presenter = Homepage
action = infinitiveScroll
 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 = preview-islanders-jdou-do-sezony-s-temer-nezmenenym-kadrem
id = 5027261
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/dev/app/Front/Article/presenters/ArticlePresenter.php:27

¤ ×