NHL.cz na Facebooku

NHL

Tipsport extraliga
29.10.2023 18:00
15. kolo

HC Škoda Plzeň

Plzeň

PLZ

5 : 2

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

HC VERVA Litvínov

Litvínov

LIT

Zápis o utkání

1. třetina

čas	tým	branky	asistence	typ gólu
Nebyla vstřelena žádná branka

čas	tým	vyloučení	trest
03:38	LIT	Andrej KUDRNA	2 min. podražení
07:10	PLZ	Michal HOUDEK	2 min. hrubost
09:47	PLZ	Jan SCHLEISS	2 min. příliš mnoho hráčů
16:02	PLZ	Tomáš MERTL	2 min. podražení
19:54	PLZ	Michal HOUDEK	2 min. podražení

2. třetina

čas	tým	branky	asistence	typ gólu
22:00	PLZ	Filip JANSA (2)	Kryštof HRABÍK (2)	5/5
Filip Jansa, Kryštof Hrabík, Daniel Malák, Michal Houdek, Jan Piskáček, Dominik Pavlát
Lukáš Válek, Andrej Kudrna, Petr Koblasa, Marek Baránek, Jindřich Abdul, Matej Tomek
26:00	PLZ	Daniel MALÁK (2)	Jan PISKÁČEK (3), Jakub POUR (1)	5/5
Daniel Malák, Filip Jansa, Kryštof Hrabík, Adam Jiříček, Jakub Pour, Dominik Pavlát
Kevin Czuczman, Liam Kirk, Jindřich Abdul, Janis Jaks, Lukáš Válek, Matej Tomek
29:57	LIT	Ondřej KAŠE (8)	David KAŠE (12)	5/5
Nicolas Hlava, David Kaše, Ondřej Kaše, Kevin Czuczman, Denis Zeman, Matej Tomek
Michal Houdek, Ondřej Matýs, Jan Schleiss, Jakub Lev, Petr Zámorský, Dominik Pavlát
34:45	PLZ	Aleksi LAAKSO (1) GV	Jan SCHLEISS (4), Miroslav INDRÁK (4)	5/4
Aleksi Laakso, Miroslav Indrák, Adam Jiříček, Aleksi Rekonen, Jan Schleiss, Dominik Pavlát
Patrik Demel, Kristaps Zile, Ondřej Kaše, Michal Gut, Matej Tomek

čas	tým	vyloučení	trest
22:29	LIT	Michal GUT	2 min. podražení
26:19	PLZ	Jan SCHLEISS	2 min. nedovolené bránění
34:25	LIT	Liam KIRK	2 min. vysoká hůl
35:06	PLZ	Jan SCHLEISS	2 min. hrubost
35:06	LIT	Janis JAKS	2 min. hrubost
37:06	LIT	Janis JAKS	2 min. hrubost

3. třetina

čas	tým	branky	asistence	typ gólu
50:09	PLZ	Tim SÖDERLUND (4)	Adrián HOLEŠINSKÝ (7)	5/5
Tim Söderlund, Adrián Holešinský, Jan Piskáček, Tomáš Mertl, Aleksi Laakso, Dominik Pavlát
Petr Koblasa, Andrej Kudrna, Janis Jaks, Michal Gut, Marek Baránek, Matej Tomek
58:15	LIT	Liam KIRK (6)	Matěj MAŠTALÍŘSKÝ (2), Jindřich ABDUL (8)	5/5
Janis Jaks, Marek Baránek, Jindřich Abdul, Matěj Maštalířský, Liam Kirk, Matej Tomek
Miroslav Indrák, Petr Zámorský, Jakub Pour, Aleksi Rekonen, Michal Houdek, Dominik Pavlát
58:56	PLZ	Aleksi LAAKSO (2)	Jan PISKÁČEK (4)	5/5
Aleksi Laakso, Jan Piskáček, Tim Söderlund, Adrián Holešinský, Jakub Lev, Dominik Pavlát
Ondřej Kaše, David Kaše, Nicolas Hlava, Petr Koblasa, Kristaps Zile, Kevin Czuczman

čas	tým	vyloučení	trest
51:51	PLZ	Miroslav INDRÁK	2 min. krosček
55:27	LIT	Jindřich ABDUL	podražení

Soupisky

HC Škoda Plzeň

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
3	O	Michal HOUDEK	0	0	0	-1	0	3	0		13:59
5	O	Adam JIŘÍČEK	0	0	0	1	1	0	1		10:53
65	O	David KVASNIČKA	0	0	0	0	0	0	2		18:09
90	O	Aleksi LAAKSO	2	0	2	2	3	0	3		22:50
8	O	Daniel MALÁK	1	0	1	2	4	0	1		13:28
75	O	Jan PISKÁČEK	0	2	2	3	0	1	2		16:44
20	O	Petr ZÁMORSKÝ	0	0	0	-2	1	0	2		19:52
89	Ú	Adrián HOLEŠINSKÝ	0	1	1	2	3	0	0		15:15
11	Ú	Kryštof HRABÍK	0	1	1	2	1	0	1		15:05
95	Ú	Miroslav INDRÁK	0	1	1	-1	3	0	0	40%	13:21
14	Ú	Filip JANSA	1	0	1	2	1	0	0	50%	13:20
30	Ú	Jakub LEV	0	0	0	0	0	0	0	62%	16:30
81	Ú	Ondřej MATÝS	0	0	0	-1	0	0	1		08:01
86	Ú	Tomáš MERTL	0	0	0	1	0	0	0	50%	20:34
64	Ú	Jakub POUR	0	1	1	0	2	1	1		15:54
18	Ú	Aleksi REKONEN	0	0	0	-1	2	1	2		13:30
84	Ú	Jan SCHLEISS	0	1	1	-1	2	1	0		15:32
12	Ú	Tim SÖDERLUND	1	0	1	2	1	0	0		16:47
34	Ú	Jakub ŠILER	0	0	0	0	0	0	2		05:54

Č	P	Hráč	ČAS	Z	G	%Z	A	T
39	B	Dominik PAVLÁT	60:00	36	2	94.74	0	0
31	B	~~Samuel HLAVAJ~~

HC VERVA Litvínov

Č	P	Hráč	G	A	B	+/-	S	H	BS	BULY	IT
63	O	Marek BARÁNEK	0	0	0	-1	2	0	0		17:31
27	O	Kevin CZUCZMAN	0	0	0	-1	0	0	2		14:35
3	O	Patrik DEMEL	0	0	0	0	2	0	3		16:05
72	O	Janis JAKS	0	0	0	-1	5	0	0		16:47
41	O	Radim ŠALDA	0	0	0	0	1	0	1		14:26
90	O	Denis ZEMAN	0	0	0	1	2	1	1		11:52
7	O	Kristaps ZILE	0	0	0	-1	0	0	4		15:26
24	Ú	Jindřich ABDUL	0	1	1	-1	2	0	0		14:30
62	Ú	Michal GUT	0	0	0	-1	2	0	1	67%	13:42
75	Ú	Martin HAVELKA	0	0	0	0	0	0	0		13:25
77	Ú	Nicolas HLAVA	0	0	0	0	2	0	1		18:17
64	Ú	Ondřej JURČÍK	0	0	0	0	1	0	1	44%	14:38
25	Ú	David KAŠE	0	1	1	0	4	1	0	50%	20:14
73	Ú	Ondřej KAŠE	1	0	1	0	2	0	1	0%	21:50
94	Ú	Liam KIRK	1	0	1	0	2	0	0	35%	16:49
10	Ú	Petr KOBLASA	0	0	0	-3	0	0	1		14:16
17	Ú	Andrej KUDRNA	0	0	0	-2	5	0	0		14:19
21	Ú	Matěj MAŠTALÍŘSKÝ	0	1	1	1	2	0	0		07:44
23	Ú	Lukáš VÁLEK	0	0	0	-2	4	0	0	60%	15:24

Č	P	Hráč	ČAS	Z	G	%Z	A	T
42	B	Matej TOMEK	59:30	19	4	82.61	0	0
34	B	~~Šimon ZAJÍČEK~~

70%

Počet diváků 5264 LOGSPEED CZ Aréna 7536

Hlavní rozhodčí:	Jan HribikMatěj Sýkora
Čároví rozhodčí:	Daniel HynekMichal Zíka
Střely po třetinách	2:16, 13:8, 9:14
Vyloučení	7:5
Vyšší tresty	0:1
Využití	1:0
V oslabení	0:0
Střely na branku	23:38
Blokované střely	18:16
Zásahy brankářů	36:19
Hity	7:2
Trestné minuty	14:10

Nejlepší hráči utkání

Dominik
PAVLÁT brankář

Ondřej
KAŠE ú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: 439.367 ms, default

Time ms

SQL Query

Rows

0.055

SET NAMES 'utf8'

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

0

1.648

SHOW FULL TABLES

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

254

0.466

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

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

SHOW FULL COLUMNS 
FROM `available_video`

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

6

SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME 
FROM information_schema.KEY_COLUMN_USAGE 
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'available_video'

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

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

1

0.288

SHOW FULL COLUMNS 
FROM `best_player_poll`

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

10

SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME 
FROM information_schema.KEY_COLUMN_USAGE 
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'best_player_poll'

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

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

2

0.272

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

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

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

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

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

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

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

SHOW FULL COLUMNS 
FROM `color`

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

3

SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME 
FROM information_schema.KEY_COLUMN_USAGE 
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'color'

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

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

0

0.266

SHOW FULL COLUMNS 
FROM `contest`

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

6

SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME 
FROM information_schema.KEY_COLUMN_USAGE 
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest'

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

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

0

0.259

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

¤ ×