NHL.cz na Facebooku

NHL

Tipsport extraliga
24.11.2023 17:30
21. kolo

HC VERVA Litvínov

Litvínov

LIT

6 : 4

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

HC Energie Karlovy Vary

Karlovy Vary

KVA

Zápis o utkání

1. třetina

čas	tým	branky	asistence	typ gólu
08:37	KVA	Jiří ČERNOCH (2)		5/5
Tomáš Havlín, Jiří Černoch, Tomáš Redlich, Dalimil Mikyska, Lukas Zetterberg, Dominik Frodl
Matěj Maštalířský, Kevin Czuczman, Nicolas Hlava, Radim Šalda, David Kaše, Šimon Zajíček
11:16	KVA	Jan HLADONIK (4)	Lukas ZETTERBERG (4), Michal PLUTNAR (8)	5/4
Jan Hladonik, Jiří Černoch, Ondřej Beránek, Michal Plutnar, Lukas Zetterberg, Dominik Frodl
Michal Gut, Ondřej Kaše, Kristaps Zile, Patrik Demel, Šimon Zajíček

čas	tým	vyloučení	trest
05:00	LIT	Ondřej KAŠE	2 min. hrubost
05:00	KVA	Filip KOFFER	2 min. napadení
10:19	LIT	Marek BARÁNEK	2 min. nedovolené bránění
11:57	KVA	Ondřej PROCHÁZKA	2 min. podražení
17:39	LIT	Marek BARÁNEK	2 min. zásah do oblasti hlavy a krku

2. třetina

čas	tým	branky	asistence	typ gólu
21:40	KVA	Filip KOFFER (4)		5/5
Filip Koffer, Joona Huttula, Lukas Zetterberg, Jiří Černoch, Ondřej Dlapa, Dominik Frodl
Matěj Maštalířský, Andrej Kudrna, Radim Šalda, Ondřej Jurčík, Kevin Czuczman, Šimon Zajíček
24:46	LIT	Liam KIRK (7)	Nicolas HLAVA (8)	5/4
Liam Kirk, Nicolas Hlava, Kristaps Zile, Ondřej Kaše, David Kaše, Šimon Zajíček
Ondřej Beránek, Jiří Černoch, Tomáš Havlín, Michal Plutnar, Dominik Frodl
28:47	LIT	Andrej KUDRNA (4)	Ondřej JURČÍK (2)	5/5
Andrej Kudrna, Pawel Zygmunt, Denis Zeman, Ondřej Jurčík, Radim Šalda, Šimon Zajíček
Michal Plutnar, Ondřej Beránek, Lukáš Pulpán, Jan Hladonik, Vít Jiskra, Dominik Frodl
30:04	LIT	Petr KOBLASA (10)	Jindřich ABDUL (10)	5/5
Petr Koblasa, David Kaše, Marek Baránek, Jindřich Abdul, Patrik Demel, Šimon Zajíček
Matěj Stříteský, Ondřej Beránek, Dalimil Mikyska, Filip Koffer, Vít Jiskra, Dominik Frodl
35:08	LIT	Liam KIRK (8)	Kristaps ZILE (4), Ondřej KAŠE (13)	5/4
Liam Kirk, Kristaps Zile, Ondřej Kaše, Nicolas Hlava, David Kaše, Šimon Zajíček
Vít Jiskra, Tomáš Redlich, Tomáš Havlín, Ondřej Dlapa, Dominik Frodl

čas	tým	vyloučení	trest
24:01	KVA	Ondřej DLAPA	2 min. podražení
24:46	LIT	Kristaps ZILE	2 min. hrubost
24:46	KVA	Tomáš HAVLÍN	2 min. hrubost
33:56	KVA	Michal PLUTNAR	2 min. zdržování hry / vystřelení nebo vyhození puku mimo hřiště

3. třetina

čas	tým	branky	asistence	typ gólu
46:17	LIT	Pawel ZYGMUNT (1) GV	Ondřej JURČÍK (3), Andrej KUDRNA (4)	5/5
Pawel Zygmunt, Ondřej Jurčík, Andrej Kudrna, Denis Zeman, Marek Baránek, Šimon Zajíček
Michal Plutnar, Ondřej Beránek, Lukáš Pulpán, Lukas Zetterberg, Jiří Černoch, Dominik Frodl
49:46	LIT	Jindřich ABDUL (7)		5/5
Jindřich Abdul, Kevin Czuczman, Kristaps Zile, Petr Koblasa, Liam Kirk, Šimon Zajíček
Tomáš Havlín, Filip Koffer, Tomáš Redlich, Vít Jiskra, Matěj Stříteský, Dominik Frodl
51:12	KVA	Matěj STŘÍTESKÝ (2)	Tomáš RACHŮNEK (9), Dávid GRÍGER (13)	5/4
Ondřej Procházka, Matěj Stříteský, Vít Jiskra, Dávid Gríger, Tomáš Rachůnek, Dominik Frodl
Radim Šalda, Michal Gut, Kevin Czuczman, Ondřej Kaše, Šimon Zajíček

čas	tým	vyloučení	trest
42:25	LIT	Michal GUT	2 min. faul loktem
45:10	LIT	David KAŠE	2 min. zdržování hry / zašlapování puku
45:10	KVA	Jan HLADONIK	2 min. zdržování hry / zašlapování puku
50:24	LIT	David KAŠE	2 min. vysoká hůl
52:44	KVA	Matěj STŘÍTESKÝ	2 min. držení
56:10	KVA	Jiří ČERNOCH	2 min. vysoká hůl

Soupisky

HC VERVA Litvínov

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
63	O	Marek BARÁNEK	0	0	0	2	1	1	0		17:55
27	O	Kevin CZUCZMAN	0	0	0	-1	0	0	0		19:28
3	O	Patrik DEMEL	0	0	0	1	1	0	1		20:35
87	O	Fabien KOČÍ	0	0	0	0	0	0	0		04:04
41	O	Radim ŠALDA	0	0	0	-1	1	2	1		12:20
90	O	Denis ZEMAN	0	0	0	2	1	0	0		14:29
7	O	Kristaps ZILE	0	1	1	1	5	1	0		24:42
24	Ú	Jindřich ABDUL	1	1	2	2	4	0	0		18:51
62	Ú	Michal GUT	0	0	0	0	0	0	0	60%	06:52
75	Ú	Martin HAVELKA	0	0	0	0	0	0	1		04:59
77	Ú	Nicolas HLAVA	0	1	1	-1	1	2	0		21:03
64	Ú	Ondřej JURČÍK	0	2	2	1	1	1	2	17%	13:35
25	Ú	David KAŠE	0	0	0	0	1	0	2	28%	20:21
73	Ú	Ondřej KAŠE	0	1	1	0	4	1	1		21:42
94	Ú	Liam KIRK	2	0	2	1	7	0	0	26%	21:43
10	Ú	Petr KOBLASA	1	0	1	2	5	0	0		17:42
17	Ú	Andrej KUDRNA	1	1	2	1	3	0	0	0%	15:00
21	Ú	Matěj MAŠTALÍŘSKÝ	0	0	0	-2	0	0	0		05:28
12	Ú	Pawel ZYGMUNT	1	0	1	2	4	1	0		12:02

Č	P	Hráč	ČAS	Z	G	%Z	A	T
34	B	Šimon ZAJÍČEK	60:00	32	4	88.89	0	0
42	B	~~Matej TOMEK~~

HC Energie Karlovy Vary

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
72	O	Ondřej DLAPA	0	0	0	1	0	2	1		19:29
77	O	Tomáš HAVLÍN	0	0	0	0	0	1	1		12:35
4	O	Joona HUTTULA	0	0	0	1	1	0	1		14:34
22	O	Dalimil MIKYSKA	0	0	0	0	0	0	0		14:33
7	O	Michal PLUTNAR	0	1	1	-2	2	0	3		20:27
51	O	Lukáš PULPÁN	0	0	0	-2	2	0	2		13:41
11	O	Matěj STŘÍTESKÝ	1	0	1	-2	3	1	1		17:50
8	Ú	Ondřej BERÁNEK	0	0	0	-3	4	1	0		20:09
20	Ú	Jan BERNOVSKÝ	0	0	0	0	1	0	0		08:24
21	Ú	Jiří ČERNOCH	1	0	1	1	3	0	0	85%	16:21
12	Ú	Dávid GRÍGER	0	1	1	0	1	0	1	72%	20:07
67	Ú	Jan HLADONIK	1	0	1	-1	4	0	1	100%	16:03
23	Ú	Vít JISKRA	0	0	0	-3	3	0	1	75%	16:26
19	Ú	Filip KOFFER	1	0	1	-1	2	0	1		10:09
76	Ú	David KOFROŇ	0	0	0	0	0	0	0	55%	08:48
82	Ú	Ondřej PROCHÁZKA	0	0	0	0	6	0	0		19:01
30	Ú	Tomáš RACHŮNEK	0	1	1	0	3	0	1		19:46
17	Ú	Tomáš REDLICH	0	0	0	0	1	0	0		11:50
91	Ú	Lukas ZETTERBERG	0	1	1	1	0	0	0		09:36

Č	P	Hráč	ČAS	Z	G	%Z	A	T
44	B	Dominik FRODL	58:35	33	6	84.62	0	0
85	B	~~Vladislav HABAL~~

86%

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

Hlavní rozhodčí:	Jan HribikJiří Ondráček
Čároví rozhodčí:	Jiří SvobodaDavid Klouček
Střely po třetinách	10:8, 15:11, 14:17
Vyloučení	7:8
Vyšší tresty	0:0
Využití	2:2
V oslabení	0:0
Střely na branku	39:36
Blokované střely	8:14
Zásahy brankářů	32:33
Hity	9:5
Trestné minuty	14:16

Nejlepší hráči utkání

Liam
KIRK útočník

Jiří
ČERNOCH ú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: 393.326 ms, default

Time ms

SQL Query

Rows

0.085

SET NAMES 'utf8'

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

0

1.670

SHOW FULL TABLES

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

254

0.325

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

¤ ×