bahis siteleri

NHL.cz na Facebooku

NHL
  • Tipsport extraliga
  • 29.9.2023 17:30
  • 6. kolo

HC VERVA Litvínov

Litvínov

LIT
5 : 2
konec 2:0, 0:2, 3:0

BK Mladá Boleslav

Ml. Boleslav

MBL

Zápis o utkání

1. třetina

čas tým branky asistence typ gólu
03:45 LIT David KAŠE (3) Kevin CZUCZMAN (1), Denis ZEMAN (1) 5/5
David Kaše, Kevin Czuczman, Denis Zeman, Ondřej Kaše, Nicolas Hlava, Matej Tomek
Juhamatti Aaltonen, Róbert Lantoši, David Bernad, Martin Pláněk, Matti Järvinen, Jan Růžička
10:03 LIT Jindřich ABDUL (5) Marek BARÁNEK (3) 5/4
Jindřich Abdul, Marek Baránek, Petr Koblasa, Matúš Sukeľ, Andrej Kudrna, Matej Tomek
Matti Järvinen, Martin Pláněk, Adam Jánošík, Juhamatti Aaltonen, Jan Růžička
čas tým vyloučení trest
04:28 LIT Radim ŠALDA 2 min. podražení
07:32 MBL Matti JÄRVINEN 2 min. nedovolené bránění
09:02 MBL Zach OSBURN 2 min. napadení
18:57 LIT Liam KIRK 2 min. krosček

2. třetina

čas tým branky asistence typ gólu
24:41 MBL Róbert LANTOŠI (4) Juhamatti AALTONEN (3), Ondřej ROMAN (4) 5/5
Juhamatti Aaltonen, Aleš Čech, Ondřej Roman, Adam Jánošík, Róbert Lantoši, Jan Růžička
Petr Koblasa, Janis Jaks, Radim Šalda, Pawel Zygmunt, Ondřej Jurčík, Matej Tomek
36:36 MBL Sebastián MALÁT (1) Tomáš ŠMERHA (1), Martin PLÁNĚK (1) 5/5
Tomáš Fořt, Sebastián Malát, Radek Jeřábek, Tomáš Šmerha, Martin Pláněk, Jan Růžička
Radim Šalda, Liam Kirk, Marek Baránek, Jindřich Abdul, Lukáš Válek, Matej Tomek
čas tým vyloučení trest
24:59 LIT David KAŠE 2 min. podražení
28:24 LIT David KAŠE 2 min. podražení
33:19 MBL Aleš ČECH 2 min. podražení

3. třetina

čas tým branky asistence typ gólu
47:35 LIT Andrej KUDRNA (1) GV Matúš SUKEĽ (1), Petr KOBLASA (3) 5/5
Andrej Kudrna, Matúš Sukeľ, Petr Koblasa, Denis Zeman, Radim Šalda, Matej Tomek
Róbert Lantoši, Tim Söderlund, Zach Osburn, Ondřej Roman, Filip Pyrochta, Jan Růžička
55:23 LIT Matúš SUKEĽ (1) Patrik DEMEL (1) 4/5
Matúš Sukeľ, Patrik Demel, Martin Havelka, Marek Baránek, Matej Tomek
Juhamatti Aaltonen, Pavol Skalický, Matti Järvinen, Róbert Lantoši, Filip Pyrochta, Tomáš Fořt
59:37 LIT Ondřej KAŠE (3) Jindřich ABDUL (2) 5/5
Ondřej Kaše, Jindřich Abdul, Patrik Demel, Ondřej Jurčík, Kristaps Zile, Matej Tomek
Zach Osburn, Pavol Skalický, Róbert Lantoši, Juhamatti Aaltonen, Matti Järvinen, Filip Pyrochta
čas tým vyloučení trest
49:43 MBL Matti JÄRVINEN 2 min. hrubost
51:49 MBL Zach OSBURN 2 min. krosček
52:57 LIT Marek BARÁNEK 2 min. zásah do oblasti hlavy a krku
54:49 LIT Kevin CZUCZMAN 2 min. sekání

Soupisky

HC VERVA Litvínov

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

BK Mladá Boleslav

Č P Hráč G A B +/- S H BS BULY IT
17 O David BERNAD 0 0 0 -1 0 0 2 02:36
5 O Aleš ČECH 0 0 0 1 2 0 1 16:24
3 O Adam JÁNOŠÍK 0 0 0 1 1 0 2 19:12
72 O Radek JEŘÁBEK 0 0 0 1 0 0 4 10:46
2 O Zach OSBURN 0 0 0 -2 3 1 4 23:01
19 O Martin PLÁNĚK 0 1 1 0 1 1 4 16:14
24 O Filip PYROCHTA 0 0 0 -3 6 0 2 21:27
50 Ú Juhamatti AALTONEN 0 1 1 -2 4 0 0 18:56
21 Ú David DVOŘÁČEK 0 0 0 0 0 0 0 10:56
12 Ú Tomáš FOŘT 0 0 0 0 3 0 1 50% 14:42
71 Ú Matti JÄRVINEN 0 0 0 -3 1 0 0 61% 20:26
16 Ú Róbert LANTOŠI 1 0 1 -3 2 0 0 0% 18:26
82 Ú Sebastián MALÁT 1 0 1 1 1 0 0 50% 12:53
23 Ú Ondřej ROMAN 0 1 1 0 2 0 1 59% 15:11
28 Ú Pavol SKALICKÝ 0 0 0 -2 2 1 0 18:14
11 Ú Tim SÖDERLUND 0 0 0 -1 1 1 0 14:13
91 Ú Jan STRÁNSKÝ 0 0 0 0 2 2 1 0% 12:56
42 Ú Filip SUCHÝ 0 0 0 0 4 0 0 25% 13:28
55 Ú Tomáš ŠMERHA 0 1 1 1 2 1 0 11:22
Č P Hráč ČAS Z G %Z A T
33 B Jan RŮŽIČKA 57:05 17 3 85.00 0 0
35 B Filip NOVOTNÝ
67%
Počet diváků 4028 Zimní stadion Ivana Hlinky 6011
Hlavní rozhodčí: Petr ÚlehlaJakub Šindel
Čároví rozhodčí: Miroslav LhotskýStanislav Hnát
Střely po třetinách 10:11, 5:15, 7:11
Vyloučení 6:5
Vyšší tresty 0:0
Využití 1:0
V oslabení 1:0
Střely na branku 20:37
Blokované střely 19:22
Zásahy brankářů 35:17
Hity 3:7
Trestné minuty 12:10

Nejlepší hráči utkání

Patrik
DEMEL obránce
Róbert
LANTOŠI útočník
Tisk

NHL.cz

Projekty

Organizace

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

Time msSQL QueryRows
0.096
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
1.770
SHOW FULL TABLES
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		254
0.511
SHOW FULL COLUMNS 
FROM `adhoc_stream`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		5
0.251
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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
0.205
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.492
SHOW FULL COLUMNS 
FROM `available_video`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		6
0.970
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		1
0.360
SHOW FULL COLUMNS 
FROM `best_player_poll`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		10
0.207
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.380
SHOW FULL COLUMNS 
FROM `best_player_poll_category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.182
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		1
0.417
SHOW FULL COLUMNS 
FROM `best_player_poll_coach`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		6
0.200
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.390
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
1.051
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		1
0.415
SHOW FULL COLUMNS 
FROM `best_player_poll_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		6
0.214
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.357
SHOW FULL COLUMNS 
FROM `best_player_poll_player_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		4
1.029
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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 `bet_company`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		4
0.196
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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 `bet_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.187
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.432
SHOW FULL COLUMNS 
FROM `category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		11
0.255
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.393
SHOW FULL COLUMNS 
FROM `color`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.187
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.485
SHOW FULL COLUMNS 
FROM `contest`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		6
0.164
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.384
SHOW FULL COLUMNS 
FROM `contest_answer`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		4
0.186
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		1
0.386
SHOW FULL COLUMNS 
FROM `contest_answer_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.218
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.357
SHOW FULL COLUMNS 
FROM `contest_answer_value`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		4
0.200
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.377
SHOW FULL COLUMNS 
FROM `contest_question`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		6
0.194
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.942
SHOW FULL COLUMNS 
FROM `contest_question_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		5
0.185
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		1
0.350
SHOW FULL COLUMNS 
FROM `contest_question_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.170
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.465
SHOW FULL COLUMNS 
FROM `country`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.198
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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 `error`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		5
0.408
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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 `error_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.175
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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 `export_subscriber`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.176
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.389
SHOW FULL COLUMNS 
FROM `facebook_ticket_competition`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		7
0.302
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.405
SHOW FULL COLUMNS 
FROM `file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		10
5.975
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.367
SHOW FULL COLUMNS 
FROM `file_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.197
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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 `file_source`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.190
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.438
SHOW FULL COLUMNS 
FROM `file_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.176
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.360
SHOW FULL COLUMNS 
FROM `file_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.186
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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 `filedir`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		4
2.431
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.371
SHOW FULL COLUMNS 
FROM `fix_match`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		4
0.220
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.486
SHOW FULL COLUMNS 
FROM `folder`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.171
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.342
SHOW FULL COLUMNS 
FROM `folder_2_stats_club`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.192
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing 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 `folder_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.187
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.376
SHOW FULL COLUMNS 
FROM `gallery`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
1.042
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.402
SHOW FULL COLUMNS 
FROM `gallery_2_file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		9
2.338
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.386
SHOW FULL COLUMNS 
FROM `gallery_image_text`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		5
0.228
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		1
0.491
SHOW FULL COLUMNS 
FROM `gallery_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		14
2.130
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		1
0.366
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
0.192
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.383
SHOW FULL COLUMNS 
FROM `gallery_photo_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.289
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.415
SHOW FULL COLUMNS 
FROM `guess`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		10
0.192
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.391
SHOW FULL COLUMNS 
FROM `guess_2_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.202
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.351
SHOW FULL COLUMNS 
FROM `guess_has_winner`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.199
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		2
0.411
SHOW FULL COLUMNS 
FROM `guess_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		10
0.205
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		1
0.363
SHOW FULL COLUMNS 
FROM `import`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		4
0.499
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.348
SHOW FULL COLUMNS 
FROM `import_problem`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		5
0.191
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.326
SHOW FULL COLUMNS 
FROM `importer_watchdog`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		3
0.163
explain
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'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEKEY_COLUMN_USAGEALLTABLE_SCHEMA,TABLE_NAMEUsing where; Open_full_table; Scanned 0 databases
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17		0
0.314
SHOW FULL COLUMNS 
FROM `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/2908628

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 = 2908628
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 = 2908628
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

¤ ×