NHL.cz na Facebooku

NHL

Tipsport extraliga
17.9.2023 17:30
2. kolo

HC VERVA Litvínov

Litvínov

LIT

4 : 2

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

HC Škoda Plzeň

Plzeň

PLZ

Zápis o utkání

1. třetina

čas	tým	branky	asistence	typ gólu
05:12	LIT	Jindřich ABDUL (1)	Marek BARÁNEK (1)	5/4
Jindřich Abdul, Marek Baránek, Andrej Kudrna, Matúš Sukeľ, Petr Koblasa, Matej Tomek
Jan Piskáček, Jan Schleiss, Jakub Lev, Michal Houdek, Samuel Hlavaj
08:25	LIT	David KAŠE (1)	Nicolas HLAVA (1), Ondřej KAŠE (1)	5/5
David Kaše, Nicolas Hlava, Ondřej Kaše, Radim Šalda, Marek Baránek, Matej Tomek
Tomáš Dujsík, Kryštof Hrabík, Petr Straka, Michal Houdek, Jakub Lev, Samuel Hlavaj
09:19	PLZ	Jan SCHLEISS (1)	Michal HOUDEK (2), Adam BENÁK (1)	5/5
Adam Benák, Tomáš Dujsík, Michal Houdek, Adrián Holešinský, Jan Schleiss, Samuel Hlavaj
Patrik Demel, Kristaps Zile, Jindřich Abdul, Lukáš Válek, Liam Kirk, Matej Tomek

čas	tým	vyloučení	trest
04:49	PLZ	Tomáš MERTL	2 min. držení
05:39	LIT	Ondřej KAŠE	2 min. podražení
11:52	LIT	Liam KIRK	2 min. hákování
14:11	LIT	David KAŠE	2 min. hrubost
14:11	PLZ	Jakub LEV	2 min. hrubost
17:14	LIT	Patrik DEMEL	2 min. podražení

2. třetina

čas	tým	branky	asistence	typ gólu
23:40	LIT	Ondřej KAŠE (1) GV	Janis JAKS (1)	5/4
Ondřej Kaše, Janis Jaks, David Kaše, Liam Kirk, Matúš Sukeľ, Matej Tomek
Tomáš Dujsík, David Kvasnička, Petr Straka, Tomáš Mertl, Samuel Hlavaj
38:04	PLZ	Jakub POUR (1)	Kryštof HRABÍK (1)	5/4
Aleksi Rekonen, Luke Adam, Kryštof Hrabík, Jakub Pour, Adam Jiříček, Samuel Hlavaj
Kristaps Zile, Andrej Kudrna, Kevin Czuczman, Ondřej Jurčík, Matej Tomek

čas	tým	vyloučení	trest
23:34	LIT	Nicolas HLAVA	2 min. hrubost
23:34	PLZ	Michal HOUDEK	2 min. hrubost
23:34	PLZ	Jan SCHLEISS	5 min. zásah do oblasti hlavy a krku
23:34	PLZ	Jan SCHLEISS	20 min. zásah do oblasti hlavy a krku
24:32	PLZ	Jakub POUR	2 min. krosček
28:41	PLZ	Petr ZÁMORSKÝ	2 min. krosček
32:13	PLZ	Jan PISKÁČEK	2 min. podražení
36:37	LIT	Nicolas HLAVA	2 min. podražení

3. třetina

čas	tým	branky	asistence	typ gólu
59:19	LIT	David KAŠE (2)		5/5
David Kaše, Ondřej Kaše, Andrej Kudrna, Kristaps Zile, Patrik Demel, Matej Tomek
Jakub Lev, Adam Benák, Adrián Holešinský, Jakub Pour, Luke Adam, Petr Zámorský

čas	tým	vyloučení	trest
46:17	LIT	Martin HAVELKA	2 min. nedovolené bránění
48:27	PLZ	Kryštof HRABÍK	2 min. sekání
53:22	LIT	Patrik DEMEL	2 min. sekání
56:19	LIT	Marek BARÁNEK	2 min. krosček
60:00	LIT	Kristaps ZILE	2 min. zdržování hry / zašlapování puku
60:00	LIT	Patrik DEMEL	2 min. hrubost
60:00	PLZ	Michal HOUDEK	2 min. hrubost

Soupisky

HC VERVA Litvínov

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
63	O	Marek BARÁNEK	0	1	1	1	2	0	0		18:16
27	O	Kevin CZUCZMAN	0	0	0	0	3	2	1		16:34
3	O	Patrik DEMEL	0	0	0	0	2	0	1		18:03
72	O	Janis JAKS	0	1	1	0	2	0	0		18:50
41	O	Radim ŠALDA	0	0	0	1	0	0	0		06:33
90	O	Denis ZEMAN	0	0	0	0	0	0	0		16:26
7	O	Kristaps ZILE	0	0	0	0	4	0	1		19:33
24	Ú	Jindřich ABDUL	1	0	1	-1	2	0	0		12:12
75	Ú	Martin HAVELKA	0	0	0	0	1	1	1		07:34
77	Ú	Nicolas HLAVA	0	1	1	1	3	2	0		17:47
64	Ú	Ondřej JURČÍK	0	0	0	0	2	1	0	33%	14:47
25	Ú	David KAŠE	2	0	2	2	7	0	0	50%	18:32
73	Ú	Ondřej KAŠE	1	1	2	2	4	2	0	100%	23:37
94	Ú	Liam KIRK	0	0	0	-1	4	0	1	35%	14:35
10	Ú	Petr KOBLASA	0	0	0	0	4	1	0		13:53
17	Ú	Andrej KUDRNA	0	0	0	1	5	0	1		15:41
91	Ú	Matúš SUKEĽ	0	0	0	0	1	1	0	52%	24:33
23	Ú	Lukáš VÁLEK	0	0	0	-1	0	0	0	0%	08:18
12	Ú	Pawel ZYGMUNT	0	0	0	0	1	0	1		13:00

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

HC Škoda Plzeň

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
63	O	Tomáš DUJSÍK	0	0	0	0	3	0	0		17:39
3	O	Michal HOUDEK	0	1	1	0	2	0	0		15:23
5	O	Adam JIŘÍČEK	0	0	0	0	0	1	0		13:57
65	O	David KVASNIČKA	0	0	0	0	0	0	2		17:09
75	O	Jan PISKÁČEK	0	0	0	0	1	0	3		14:58
20	O	Petr ZÁMORSKÝ	0	0	0	-1	2	0	0		25:52
91	Ú	Luke ADAM	0	0	0	-1	1	0	1	68%	11:47
9	Ú	Adam BENÁK	0	1	1	0	1	0	1	0%	16:01
89	Ú	Adrián HOLEŠINSKÝ	0	0	0	0	0	0	2		15:39
11	Ú	Kryštof HRABÍK	0	1	1	-1	0	2	0	29%	14:47
95	Ú	Miroslav INDRÁK	0	0	0	0	0	0	0	100%	15:24
14	Ú	Filip JANSA	0	0	0	0	0	0	0	100%	08:22
30	Ú	Jakub LEV	0	0	0	-2	4	0	1	56%	22:19
81	Ú	Ondřej MATÝS	0	0	0	0	0	0	0		11:16
86	Ú	Tomáš MERTL	0	0	0	0	3	0	0	43%	15:27
64	Ú	Jakub POUR	1	0	1	-1	2	0	1		18:16
18	Ú	Aleksi REKONEN	0	0	0	0	2	1	1		14:29
84	Ú	Jan SCHLEISS	1	0	1	1	2	0	0		08:01
23	Ú	Petr STRAKA	0	0	0	-1	2	1	0		10:55

Č	P	Hráč	ČAS	Z	G	%Z	A	T
31	B	Samuel HLAVAJ	58:11	43	3	93.48	0	0
39	B	~~Dominik PAVLÁT~~

67%

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

Hlavní rozhodčí:	Tomáš VeselýLuděk Pilný
Čároví rozhodčí:	Jiří OndráčekDavid Thuma
Střely po třetinách	12:10, 21:9, 14:6
Vyloučení	11:8
Vyšší tresty	0:2
Využití	2:1
V oslabení	0:0
Střely na branku	46:25
Blokované střely	7:12
Zásahy brankářů	23:43
Hity	10:5
Trestné minuty	22:41

Nejlepší hráči utkání

David
KAŠE útočník

Samuel
HLAVAJ brankář

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: 399.676 ms, default

Time ms

SQL Query

Rows

0.056

SET NAMES 'utf8'

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

0

1.745

SHOW FULL TABLES

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

254

0.298

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

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

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

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

4.440

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

¤ ×