NHL.cz na Facebooku

NHL

Tipsport extraliga
20.10.2023 17:30
12. kolo

HC VERVA Litvínov

Litvínov

LIT

6 : 3

konec 2:2, 4:0, 0:1

HC VÍTKOVICE RIDERA

Vítkovice

VIT

Zápis o utkání

1. třetina

čas	tým	branky	asistence	typ gólu
01:28	VIT	Dominik LAKATOŠ (5)	Willie RASKOB (7)	5/5
Patrik Zdráhal, Willie Raskob, Petr Chlán, Dominik Lakatoš, Juraj Mikuš, Lukáš Klimeš
Janis Jaks, Marek Baránek, Nicolas Hlava, Ondřej Kaše, David Kaše, Šimon Zajíček
04:19	LIT	Ondřej KAŠE (7)		5/5
Ondřej Kaše, Nicolas Hlava, David Kaše, Denis Zeman, Kevin Czuczman, Šimon Zajíček
Patrik Zdráhal, Dominik Lakatoš, Matěj Prčík, Petr Gewiese, Petr Chlán, Lukáš Klimeš
13:39	LIT	Petr KOBLASA (7)	Jindřich ABDUL (6), Marek BARÁNEK (5)	5/4
Petr Koblasa, Jindřich Abdul, Marek Baránek, Matúš Sukeľ, Andrej Kudrna, Šimon Zajíček
Petr Gewiese, Petr Chlán, Juraj Mikuš, Petr Fridrich, Lukáš Klimeš
19:50	VIT	Peter KRIEGER (4)	Marek KALUS (7), Dominik LAKATOŠ (8)	5/4
Peter Mueller, Dominik Lakatoš, Marek Kalus, Stuart Thomas Percy, Peter Krieger, Lukáš Klimeš
Matúš Sukeľ, Kevin Czuczman, Martin Havelka, Denis Zeman, Šimon Zajíček

čas	tým	vyloučení	trest
11:57	VIT	Mario GRMAN	2 min. podražení
14:55	VIT	Petr CHLÁN	2 min. hákování
17:32	LIT	Andrej KUDRNA	2 min. zdržování hry / zašlapování puku
17:32	VIT	Mario GRMAN	2 min. zdržování hry / zašlapování puku
19:13	LIT	Janis JAKS	2 min. nedovolené bránění

2. třetina

čas	tým	branky	asistence	typ gólu
30:51	LIT	Matúš SUKEĽ (4)	Andrej KUDRNA (3)	5/5
Matúš Sukeľ, Marek Baránek, Andrej Kudrna, Petr Koblasa, Janis Jaks, Šimon Zajíček
Rastislav Dej, Patrik Zdráhal, Dominik Lakatoš, Matěj Prčík, Petr Gewiese, Lukáš Klimeš
31:18	LIT	David KAŠE (5) GV	Ondřej KAŠE (8), Nicolas HLAVA (6)	5/5
David Kaše, Ondřej Kaše, Nicolas Hlava, Denis Zeman, Kevin Czuczman, Šimon Zajíček
Roberts Bukarts, Stuart Thomas Percy, Mario Grman, Peter Krieger, Peter Mueller, Lukáš Klimeš
32:24	LIT	David KAŠE (6)	Marek BARÁNEK (6)	5/5
David Kaše, Marek Baránek, Patrik Demel, Liam Kirk, Lukáš Válek, Andrej Kudrna
Vojtěch Lednický, Willie Raskob, Juraj Mikuš, Marek Kalus, Valentin Claireaux, Lukáš Klimeš
35:18	LIT	Liam KIRK (3)	Lukáš VÁLEK (1)	5/5
Liam Kirk, Lukáš Válek, Jindřich Abdul, Marek Baránek, Janis Jaks, Šimon Zajíček
Jakub Kotala, Petr Fridrich, Mario Grman, Josef Krejsa, Stuart Thomas Percy, Matěj Machovský

čas	tým	vyloučení	trest
36:06	LIT	Kristaps ZILE	2 min. hrubost
36:06	VIT	Dominik LAKATOŠ	2 min. hrubost
37:38	LIT	Kevin CZUCZMAN	2 min. podražení

3. třetina

čas	tým	branky	asistence	typ gólu
41:04	VIT	Dominik LAKATOŠ (6)		5/5
Willie Raskob, Petr Chlán, Dominik Lakatoš, Patrik Zdráhal, Juraj Mikuš, Matěj Machovský
Liam Kirk, Janis Jaks, Marek Baránek, Lukáš Válek, Ondřej Kaše, Šimon Zajíček

čas	tým	vyloučení	trest
52:56	VIT	Patrik ZDRÁHAL	2 min. podražení
54:18	VIT	Matěj PRČÍK	2 min. krosček
57:56	VIT	Patrik ZDRÁHAL	2 min. sekání
57:56	VIT	Patrik ZDRÁHAL	2 min. nesportovní chování

Soupisky

HC VERVA Litvínov

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
63	O	Marek BARÁNEK	0	2	2	1	2	0	1		18:19
27	O	Kevin CZUCZMAN	0	0	0	2	1	1	1		13:53
3	O	Patrik DEMEL	0	0	0	1	1	0	3		17:48
72	O	Janis JAKS	0	0	0	0	3	1	2		20:47
41	O	Radim ŠALDA	0	0	0	0	0	1	0		10:06
90	O	Denis ZEMAN	0	0	0	2	2	2	1		12:38
7	O	Kristaps ZILE	0	0	0	0	1	2	1		17:34
24	Ú	Jindřich ABDUL	0	1	1	1	7	0	0		15:12
62	Ú	Michal GUT	0	0	0	0	2	1	0	30%	10:28
75	Ú	Martin HAVELKA	0	0	0	0	0	2	0		10:11
77	Ú	Nicolas HLAVA	0	1	1	1	4	1	0		20:02
64	Ú	Ondřej JURČÍK	0	0	0	0	3	1	1	57%	10:42
25	Ú	David KAŠE	2	0	2	2	4	0	1	38%	19:56
73	Ú	Ondřej KAŠE	1	1	2	0	6	0	1		20:02
94	Ú	Liam KIRK	1	0	1	1	5	0	0	63%	17:30
10	Ú	Petr KOBLASA	1	0	1	1	2	1	1		16:18
17	Ú	Andrej KUDRNA	0	1	1	2	1	0	2		16:28
91	Ú	Matúš SUKEĽ	1	0	1	1	1	0	0	53%	14:58
23	Ú	Lukáš VÁLEK	0	1	1	1	1	0	1		11:50

Č	P	Hráč	ČAS	Z	G	%Z	A	T
34	B	Šimon ZAJÍČEK	59:44	24	3	88.89	0	0
42	B	~~Matej TOMEK~~

HC VÍTKOVICE RIDERA

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
44	O	Petr GEWIESE	0	0	0	-2	1	1	1		19:36
7	O	Mario GRMAN	0	0	0	-2	2	0	1		20:05
2	O	Juraj MIKUŠ	0	0	0	1	0	1	0		21:40
43	O	Stuart Thomas PERCY	0	0	0	-2	1	0	3		19:32
24	O	Matěj PRČÍK	0	0	0	-2	1	2	2		18:47
22	O	Willie RASKOB	0	1	1	1	1	0	2		16:40
71	Ú	Roberts BUKARTS	0	0	0	-1	2	0	2		16:26
28	Ú	Valentin CLAIREAUX	0	0	0	-1	0	0	0	60%	14:57
27	Ú	Rastislav DEJ	0	0	0	-1	1	0	1	57%	06:32
12	Ú	Petr FRIDRICH	0	0	0	-1	3	0	4		14:24
15	Ú	Petr CHLÁN	0	0	0	1	1	0	1	39%	18:09
11	Ú	Marek KALUS	0	1	1	-1	1	2	0		15:16
72	Ú	Jakub KOTALA	0	0	0	-1	3	2	1	50%	10:37
25	Ú	Josef KREJSA	0	0	0	-1	0	2	1		08:48
26	Ú	Peter KRIEGER	1	0	1	-1	1	0	0	52%	16:19
31	Ú	Dominik LAKATOŠ	2	1	3	0	5	2	0		14:26
23	Ú	Vojtěch LEDNICKÝ	0	0	0	-1	0	1	0		04:57
88	Ú	Peter MUELLER	0	0	0	-1	2	0	0	100%	17:12
55	Ú	Patrik ZDRÁHAL	0	0	0	0	2	0	1		13:23

Č	P	Hráč	ČAS	Z	G	%Z	A	T
33	B	Lukáš KLIMEŠ	32:24	22	5	81.48	0	0
35	B	Matěj MACHOVSKÝ	27:36	18	1	94.74	0	0

84%

Počet diváků 5025 Zimní stadion Ivana Hlinky 6011

Hlavní rozhodčí:	Adam KikaLukáš Květoň
Čároví rozhodčí:	Jiří OndráčekDavid Thuma
Střely po třetinách	14:7, 16:14, 16:6
Vyloučení	4:8
Vyšší tresty	0:0
Využití	1:1
V oslabení	0:0
Střely na branku	46:27
Blokované střely	16:20
Zásahy brankářů	24:40
Hity	13:13
Trestné minuty	8:16

Nejlepší hráči utkání

Ondřej
KAŠE útočník

Dominik
LAKATOŠ ú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: 634, time: 362.077 ms, default

Time ms

SQL Query

Rows

0.077

SET NAMES 'utf8'

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

0

1.678

SHOW FULL TABLES

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

254

0.429

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.399

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.377

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.368

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.353

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.262

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.243

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.340

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.384

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.334

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.311

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.347

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.400

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.379

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.354

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.356

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.357

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.487

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.494

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.333

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.448

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.405

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.281

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.381

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.344

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.331

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.320

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

0.287

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.306

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.280

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.294

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.455

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.424

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.324

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.402

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.261

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.343

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.290

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.332

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.283

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.282

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.351

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.261

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.267

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.369

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.276

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.263

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.314

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.458

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/2908669

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 = 2908669`
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 = 2908669`
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

¤ ×