NHL.cz na Facebooku

NHL

Tipsport extraliga
15.10.2023 17:30
11. kolo

HC VERVA Litvínov

Litvínov

LIT

5 : 4

konec po prodloužení 1:2, 1:1, 2:1 - 1:0

Rytíři Kladno

Kladno

KLA

Zápis o utkání

1. třetina

čas	tým	branky	asistence	typ gólu
05:14	LIT	David KAŠE (4)	Nicolas HLAVA (5), Ondřej KAŠE (6)	5/4
David Kaše, Janis Jaks, Nicolas Hlava, Liam Kirk, Ondřej Kaše, Matej Tomek
Antonín Melka, Jakub Strnad, Tadeáš Hejda, Jake Dotchin, Adam Brízgala
16:50	KLA	Eduards TRALMAKS (5)	Jake DOTCHIN (5), Denis KUSÝ (2)	5/3
Jiří Ticháček, Denis Kusý, Eduards Tralmaks, Jake Dotchin, Radek Smoleňák, Adam Brízgala
Matúš Sukeľ, Radim Šalda, Kristaps Zile, Matej Tomek
17:50	KLA	Radek SMOLEŇÁK (3)	Jiří TICHÁČEK (7), Eduards TRALMAKS (1)	5/3
Jiří Ticháček, Jake Dotchin, Radek Smoleňák, Eduards Tralmaks, Denis Kusý, Adam Brízgala
Patrik Demel, Kristaps Zile, Michal Gut, Matej Tomek

čas	tým	vyloučení	trest
02:26	LIT	Liam KIRK	2 min. podražení
04:50	KLA	Ondřej SLOVÁČEK	2 min. podražení
11:00	KLA	Radek SMOLEŇÁK	2 min. podražení
16:29	LIT	Patrik DEMEL	2 min. zdržování hry / vystřelení nebo vyhození puku mimo hřiště
16:39	LIT	Kevin CZUCZMAN	2 min. podražení
17:27	LIT	Denis ZEMAN	2 min. vysoká hůl
19:27	LIT	Denis ZEMAN	2 min. vysoká hůl

2. třetina

čas	tým	branky	asistence	typ gólu
25:31	KLA	Deven SIDEROFF (1)	Ondřej SLOVÁČEK (3)	5/5
Deven Sideroff, Ondřej Slováček, Ondřej Bláha, Václav Veber, Jaromír Pytlík, Adam Brízgala
Janis Jaks, Lukáš Válek, Kristaps Zile, Jindřich Abdul, Liam Kirk, Matej Tomek
35:52	LIT	Petr KOBLASA (6)	David KAŠE (9), Ondřej KAŠE (7)	5/4
Petr Koblasa, David Kaše, Ondřej Kaše, Liam Kirk, Janis Jaks, Matej Tomek
Václav Veber, Antonín Melka, Ondřej Slováček, Tadeáš Hejda, Adam Brízgala

čas	tým	vyloučení	trest
27:24	KLA	Chris MARTENET	2 min. podražení
33:38	KLA	Tadeáš HEJDA	2 min. hákování
33:58	KLA	Ondřej BLÁHA	2 min. hákování
39:50	KLA	Jakub STRNAD	2 min. sekání

3. třetina

čas	tým	branky	asistence	typ gólu
52:33	KLA	Deven SIDEROFF (2)	Martin PROCHÁZKA (2), Jiří TICHÁČEK (8)	5/5
Deven Sideroff, Chris Martenet, Jaromír Pytlík, Martin Procházka, Jiří Ticháček, Adam Brízgala
Radim Šalda, Liam Kirk, Andrej Kudrna, Jindřich Abdul, Janis Jaks, Matej Tomek
53:46	LIT	Matúš SUKEĽ (3)	Kevin CZUCZMAN (3), Denis ZEMAN (2)	5/5
Matúš Sukeľ, Kevin Czuczman, Andrej Kudrna, Denis Zeman, Petr Koblasa, Matej Tomek
Jakub Babka, Tadeáš Hejda, Jakub Strnad, Ondřej Bláha, Jake Dotchin, Adam Brízgala
57:11	LIT	Kristaps ZILE (1)	David KAŠE (10)	5/5
Kristaps Zile, David Kaše, Jindřich Abdul, Ondřej Kaše, Kevin Czuczman, Matej Tomek
Chris Martenet, Radek Smoleňák, Jakub Klepiš, Jakub Strnad, Ondřej Slováček, Adam Brízgala

čas	tým	vyloučení	trest
44:03	LIT	Radim ŠALDA	2 min. podražení
46:27	KLA	Jakub BABKA	2 min. podražení

Prodloužení

čas	tým	branky	asistence	typ gólu
63:22	LIT	Ondřej KAŠE (6) GV	David KAŠE (11)	3/3
Ondřej Kaše, David Kaše, Patrik Demel, Matej Tomek
Jaromír Pytlík, Jake Dotchin, Deven Sideroff, Adam Brízgala

čas	tým	vyloučení	trest
Nebylo žádné vyloučení

Soupisky

HC VERVA Litvínov

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
27	O	Kevin CZUCZMAN	0	1	1	2	3	0	0		17:59
3	O	Patrik DEMEL	0	0	0	1	1	1	0		18:38
72	O	Janis JAKS	0	0	0	-2	3	1	0		19:04
93	O	Jan STREJČEK	0	0	0	0	2	1	0		08:11
41	O	Radim ŠALDA	0	0	0	-1	2	0	0		10:47
90	O	Denis ZEMAN	0	1	1	1	0	2	1		15:48
7	O	Kristaps ZILE	1	0	1	0	1	0	3		20:27
24	Ú	Jindřich ABDUL	0	0	0	-1	0	0	0		17:05
62	Ú	Michal GUT	0	0	0	0	2	0	0	25%	07:43
75	Ú	Martin HAVELKA	0	0	0	0	0	0	2		06:46
77	Ú	Nicolas HLAVA	0	1	1	0	6	0	0		17:05
64	Ú	Ondřej JURČÍK	0	0	0	0	0	1	0	0%	07:40
25	Ú	David KAŠE	1	3	4	2	7	0	1	41%	20:57
73	Ú	Ondřej KAŠE	1	2	3	2	4	0	0		24:48
94	Ú	Liam KIRK	0	0	0	-2	1	0	0	30%	19:29
10	Ú	Petr KOBLASA	1	0	1	1	3	0	0		19:02
17	Ú	Andrej KUDRNA	0	0	0	0	1	1	0		16:46
91	Ú	Matúš SUKEĽ	1	0	1	1	3	0	1	64%	20:15
23	Ú	Lukáš VÁLEK	0	0	0	-1	0	0	0		08:46

Č	P	Hráč	ČAS	Z	G	%Z	A	T
42	B	Matej TOMEK	63:22	23	4	85.19	0	0
34	B	~~Šimon ZAJÍČEK~~

Rytíři Kladno

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
44	O	Jake DOTCHIN	0	1	1	-2	1	1	0		25:17
96	O	Tadeáš HEJDA	0	0	0	-1	2	0	2		18:21
27	O	Chris MARTENET	0	0	0	0	1	1	3		16:22
28	O	Ondřej SLOVÁČEK	0	1	1	0	0	0	3		19:45
26	O	Jiří TICHÁČEK	0	2	2	1	5	1	0		20:58
5	O	Václav VEBER	0	0	0	1	0	1	2		14:14
41	Ú	Jakub BABKA	0	0	0	-1	0	0	0	57%	10:50
88	Ú	~~Matěj BERAN~~
89	Ú	Ondřej BLÁHA	0	0	0	0	1	1	0		14:31
91	Ú	Richard JARŮŠEK	0	0	0	0	4	0	0	0%	16:06
21	Ú	Jakub KLEPIŠ	0	0	0	-1	1	0	0	59%	20:38
98	Ú	Denis KUSÝ	0	1	1	0	1	0	1		13:20
43	Ú	Antonín MELKA	0	0	0	0	0	1	0	44%	12:39
23	Ú	Martin PROCHÁZKA	0	1	1	1	2	0	0		09:58
20	Ú	Jaromír PYTLÍK	0	0	0	1	1	1	2	47%	19:32
97	Ú	Deven SIDEROFF	2	0	2	1	3	1	2	100%	15:43
70	Ú	Radek SMOLEŇÁK	1	0	1	-1	2	1	0	100%	14:34
92	Ú	Jakub STRNAD	0	0	0	-2	1	0	0		13:08
34	Ú	Eduards TRALMAKS	1	1	2	0	2	2	1	50%	19:50

Č	P	Hráč	ČAS	Z	G	%Z	A	T
1	B	Adam BRÍZGALA	63:22	34	5	87.18	0	0
29	B	~~Landon BOW~~

88%

Počet diváků 5217 Zimní stadion Ivana Hlinky 5944

Hlavní rozhodčí:	Jan JarošLukáš Květoň
Čároví rozhodčí:	Jakub FrodlDaniel Hynek
Střely po třetinách	15:12, 11:6, 11:8, 2:1
Vyloučení	6:7
Vyšší tresty	0:0
Využití	2:2
V oslabení	0:0
Střely na branku	39:27
Blokované střely	8:16
Zásahy brankářů	23:34
Hity	7:11
Trestné minuty	12:14

Nejlepší hráči utkání

David
KAŠE útočník

Deven
SIDEROFF útočník

Tisk

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: 637, time: 450.241 ms, default

Time ms

SQL Query

Rows

0.053

SET NAMES 'utf8'

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

1.681

SHOW FULL TABLES

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

254

0.299

SHOW FULL COLUMNS 
FROM `adhoc_stream`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

5

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.307

SHOW FULL COLUMNS 
FROM `admin_module`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

10

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.283

SHOW FULL COLUMNS 
FROM `available_video`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

6

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.288

SHOW FULL COLUMNS 
FROM `best_player_poll`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

10

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.354

SHOW FULL COLUMNS 
FROM `best_player_poll_category`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.281

SHOW FULL COLUMNS 
FROM `best_player_poll_coach`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

6

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.284

SHOW FULL COLUMNS 
FROM `best_player_poll_coach_vote`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

4

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.272

SHOW FULL COLUMNS 
FROM `best_player_poll_player`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

6

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.296

SHOW FULL COLUMNS 
FROM `best_player_poll_player_vote`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

4

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.268

SHOW FULL COLUMNS 
FROM `bet_company`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

4

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.274

SHOW FULL COLUMNS 
FROM `bet_type`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.280

SHOW FULL COLUMNS 
FROM `category`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

11

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

0.251

SHOW FULL COLUMNS 
FROM `color`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.266

SHOW FULL COLUMNS 
FROM `contest`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

6

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.250

SHOW FULL COLUMNS 
FROM `contest_answer`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

4

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.262

SHOW FULL COLUMNS 
FROM `contest_answer_item`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.254

SHOW FULL COLUMNS 
FROM `contest_answer_value`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

4

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.264

SHOW FULL COLUMNS 
FROM `contest_question`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

6

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.269

SHOW FULL COLUMNS 
FROM `contest_question_item`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

5

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.253

SHOW FULL COLUMNS 
FROM `contest_question_type`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.256

SHOW FULL COLUMNS 
FROM `country`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.285

SHOW FULL COLUMNS 
FROM `error`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

5

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.257

SHOW FULL COLUMNS 
FROM `error_type`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.409

SHOW FULL COLUMNS 
FROM `export_subscriber`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.404

SHOW FULL COLUMNS 
FROM `facebook_ticket_competition`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

7

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.317

SHOW FULL COLUMNS 
FROM `file`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

10

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

0.350

SHOW FULL COLUMNS 
FROM `file_2_tag`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

3.476

SHOW FULL COLUMNS 
FROM `file_source`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.267

SHOW FULL COLUMNS 
FROM `file_tag`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.335

SHOW FULL COLUMNS 
FROM `file_type`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.289

SHOW FULL COLUMNS 
FROM `filedir`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

4

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.333

SHOW FULL COLUMNS 
FROM `fix_match`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

4

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.413

SHOW FULL COLUMNS 
FROM `folder`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.309

SHOW FULL COLUMNS 
FROM `folder_2_stats_club`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.273

SHOW FULL COLUMNS 
FROM `folder_2_tag`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.296

SHOW FULL COLUMNS 
FROM `gallery`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.289

SHOW FULL COLUMNS 
FROM `gallery_2_file`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

9

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

0.301

SHOW FULL COLUMNS 
FROM `gallery_image_text`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

5

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.348

SHOW FULL COLUMNS 
FROM `gallery_photo`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

14

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.357

SHOW FULL COLUMNS 
FROM `gallery_photo_2_stats_player`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.264

SHOW FULL COLUMNS 
FROM `gallery_photo_2_tag`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.338

SHOW FULL COLUMNS 
FROM `guess`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

10

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.648

SHOW FULL COLUMNS 
FROM `guess_2_photo`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.284

SHOW FULL COLUMNS 
FROM `guess_has_winner`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

2

0.314

SHOW FULL COLUMNS 
FROM `guess_vote`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

10

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

0.279

SHOW FULL COLUMNS 
FROM `import`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

4

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.324

SHOW FULL COLUMNS 
FROM `import_problem`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

5

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.283

SHOW FULL COLUMNS 
FROM `importer_watchdog`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

3

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'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	KEY_COLUMN_USAGE	ALL		TABLE_SCHEMA,TABLE_NAME				Using where; Open_full_table; Scanned 0 databases

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

0

0.255

SHOW FULL COLUMNS 
FROM `impression_article_count`

/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17

1

...and more

¤ ×

Front:Match:Overview:default

https://dev.nhlcz.s6.esports.cz/zapas/2908663

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`
yes	`Route`	`zapas/<id \d+>[/<presenter>][/<action>]`	`module = Match presenter = Overview action = default`	`Front`	`Front:Match:Overview:default id = 2908663`
no	`Route`	`/`	`module = Home presenter = Homepage action = default`	`Front`
may	`ArticleRoute`	`<slug [a-zA-Z-0-9\-]+>/<id \d+>`	`module = Article presenter = Article action = default`	`Front`	`Front:Article:Article:default slug = zapas id = 2908663`
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\Match\OverviewPresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/Match/presenters/OverviewPresenter.php:54

¤ ×