bahis siteleri

NHL.cz na Facebooku

  • 2. liga – Východ
  • 11.11.2023 18:00
  • 14. kolo

Zápis o utkání

1. třetina

čas tým branky asistence typ gólu
06:16 HOM Vojtěch DOBIÁŠ (4) Jiří KARAFIÁT (6), Filip WEINTRITT (4)
10:12 HOM Jiří KARAFIÁT (7) GV Dominik LUŽA (8), David POLESNÝ (4)
čas tým vyloučení trest
05:14 NJI Stanislav BÁCHOR 2 min. zdržování hry / vystřelení nebo vyhození puku mimo hřiště
11:57 NJI Jakub HRUŠKA 2 min. podražení

2. třetina

čas tým branky asistence typ gólu
28:55 HOM Petr KREJČÍ (3) Adam LACIGA (4), Jakub NĚMEC (4)
34:59 NJI Roman MALINÍK (5) Stanislav BÁCHOR (7), David KVĚTOŇ (5)
35:08 HOM Jiří KARAFIÁT (8) Vojtěch DOBIÁŠ (10), Jan ŠVEJDA (2)
čas tým vyloučení trest
21:36 HOM David RAUŠ podražení
24:06 NJI Viktor BERKA 2 min. podražení
34:25 HOM Erik HLOŽÁNEK 2 min. hákování
37:55 NJI Roman MALINÍK 2 min. podražení
37:55 HOM Petr KREJČÍ 2 min. nafilmovaný pád

3. třetina

čas tým branky asistence typ gólu
51:39 HOM Matěj MACH (5)
52:30 HOM Filip WEINTRITT (2) Jakub SAJDL (1), Jan ŠVEJDA (3)
čas tým vyloučení trest
43:27 HOM Adam LACIGA 2 min. nedovolené bránění
54:57 NJI Stanislav BÁCHOR 2 min. hákování
55:03 HOM David RAUŠ 2 min. podražení

Soupisky

HK Nový Jičín

Č P Hráč G A B +/- S H BS BULY IT
71 O Stanislav BÁCHOR 0 1 1 0 0 0 0 00:00
2 O Martin DUDÁŠ 0 0 0 0 0 0 0 00:00
16 O Tomáš HANÁK 0 0 0 0 0 0 0 00:00
12 O Jan HOLÁŇ 0 0 0 0 0 0 0 00:00
14 O Jakub HRUŠKA 0 0 0 0 0 0 0 00:00
15 O Petr KUBOŠ 0 0 0 0 0 0 0 00:00
78 Ú Viktor BERKA 0 0 0 0 0 0 0 00:00
43 Ú Adam FLOK 0 0 0 0 0 0 0 00:00
27 Ú Robin GEBAUER 0 0 0 0 0 0 0 00:00
18 Ú Dan HANDL 0 0 0 0 0 0 0 00:00
25 Ú Adam HILŠER 0 0 0 0 0 0 0 00:00
92 Ú Viktor KONEČNÝ 0 0 0 0 0 0 0 00:00
26 Ú David KVĚTOŇ 0 1 1 0 0 0 0 00:00
95 Ú Roman MALINÍK 1 0 1 0 0 0 0 00:00
19 Ú Pavel MATĚJ 0 0 0 0 0 0 0 00:00
57 Ú Rostislav OLESZ 0 0 0 0 0 0 0 00:00
23 Ú Martin ŠKARKA 0 0 0 0 0 0 0 00:00
11 Ú Patrik TARNOCZY 0 0 0 0 0 0 0 00:00
 
 
Č P Hráč ČAS Z G %Z A T
42 B Daniel ŠIMONŮ 60:00 0 6 0 0 0
33 B Filip HOŘEJŠÍ

SHKM Hodonín

Č P Hráč G A B +/- S H BS BULY IT
69 O Matěj BÍLEK 0 0 0 0 0 0 0 00:00
77 O Jakub NĚMEC 0 1 1 0 0 0 0 00:00
80 O David POLESNÝ 0 1 1 0 0 0 0 00:00
28 O Tomáš SEDLÁČEK 0 0 0 0 0 0 0 00:00
66 O Jan ŠVEJDA 0 2 2 0 0 0 0 00:00
7 O Luka ZORKO 0 0 0 0 0 0 0 00:00
16 Ú Adam BACHÁNEK 0 0 0 0 0 0 0 00:00
81 Ú Vojtěch DOBIÁŠ 1 1 2 0 0 0 0 00:00
10 Ú Erik HLOŽÁNEK 0 0 0 0 0 0 0 00:00
11 Ú Jiří KARAFIÁT 2 1 3 0 0 0 0 00:00
15 Ú Petr KREJČÍ 1 0 1 0 0 0 0 00:00
98 Ú Adam LACIGA 0 1 1 0 0 0 0 00:00
92 Ú Dominik LUŽA 0 1 1 0 0 0 0 00:00
19 Ú Matěj MACH 1 0 1 0 0 0 0 00:00
5 Ú Libor MACHÁŇ 0 0 0 0 0 0 0 00:00
44 Ú Matěj NOVÁK 0 0 0 0 0 0 0 00:00
94 Ú David RAUŠ 0 0 0 0 0 0 0 00:00
71 Ú Jakub SAJDL 0 1 1 0 0 0 0 00:00
23 Ú Jan ŠTĚDRÝ 0 0 0 0 0 0 0 00:00
91 Ú Filip WEINTRITT 1 1 2 0 0 0 0 00:00
Č P Hráč ČAS Z G %Z A T
35 B Dominik PITÁK 60:00 0 1 0 0 0
32 B Ondřej DOLÍŠKA
43%
Počet diváků 857 Zimní stadion města Nový Jičín 2000
Hlavní rozhodčí: Petr Blaha
Čároví rozhodčí: Radek JurčíkMartin Tvrdý
Střely po třetinách 0:2, 1:2, 0:2
Vyloučení 5:4
Vyšší tresty 0:1
Využití 0:0
V oslabení 0:0
Střely na branku 1:6
Blokované střely 0:0
Zásahy brankářů 0:0
Hity 0:0
Trestné minuty 10:8
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: 631, time: 397.379 ms, default

Time msSQL QueryRows
0.090
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
0
1.805
SHOW FULL TABLES
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
254
0.446
SHOW FULL COLUMNS 
FROM `adhoc_stream`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
5
0.236
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.346
SHOW FULL COLUMNS 
FROM `admin_module`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
10
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 =
'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.337
SHOW FULL COLUMNS 
FROM `available_video`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
6
1.610
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.528
SHOW FULL COLUMNS 
FROM `best_player_poll`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
10
0.217
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.295
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.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 =
'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.878
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.178
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.277
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
0.636
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.277
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.165
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.296
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
0.615
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.270
SHOW FULL COLUMNS 
FROM `bet_company`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
4
0.142
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.259
SHOW FULL COLUMNS 
FROM `bet_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.142
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.299
SHOW FULL COLUMNS 
FROM `category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
11
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 = '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.262
SHOW FULL COLUMNS 
FROM `color`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
3
0.150
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.386
SHOW FULL COLUMNS 
FROM `contest`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
6
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'
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.373
SHOW FULL COLUMNS 
FROM `contest_answer`
/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 =
'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.346
SHOW FULL COLUMNS 
FROM `contest_answer_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
3
0.259
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.327
SHOW FULL COLUMNS 
FROM `contest_answer_value`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
4
0.181
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.326
SHOW FULL COLUMNS 
FROM `contest_question`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
6
0.157
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.311
SHOW FULL COLUMNS 
FROM `contest_question_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
5
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_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.371
SHOW FULL COLUMNS 
FROM `contest_question_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.144
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.453
SHOW FULL COLUMNS 
FROM `country`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
3
0.145
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.274
SHOW FULL COLUMNS 
FROM `error`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
5
0.254
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.258
SHOW FULL COLUMNS 
FROM `error_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.142
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.295
SHOW FULL COLUMNS 
FROM `export_subscriber`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
3
0.146
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.296
SHOW FULL COLUMNS 
FROM `facebook_ticket_competition`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
7
0.222
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.290
SHOW FULL COLUMNS 
FROM `file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
10
3.102
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.259
SHOW FULL COLUMNS 
FROM `file_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.147
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.269
SHOW FULL COLUMNS 
FROM `file_source`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
3
0.146
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.277
SHOW FULL COLUMNS 
FROM `file_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.135
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.243
SHOW FULL COLUMNS 
FROM `file_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.141
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.328
SHOW FULL COLUMNS 
FROM `filedir`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
4
1.309
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.275
SHOW FULL COLUMNS 
FROM `fix_match`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
4
0.160
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.252
SHOW FULL COLUMNS 
FROM `folder`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
3
0.147
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.240
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.160
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.266
SHOW FULL COLUMNS 
FROM `folder_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.165
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.295
SHOW FULL COLUMNS 
FROM `gallery`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
3
0.580
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.321
SHOW FULL COLUMNS 
FROM `gallery_2_file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
9
1.313
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.270
SHOW FULL COLUMNS 
FROM `gallery_image_text`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
5
0.152
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.315
SHOW FULL COLUMNS 
FROM `gallery_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
14
1.329
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.276
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.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 =
'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.239
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.157
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.283
SHOW FULL COLUMNS 
FROM `guess`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
10
0.129
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.243
SHOW FULL COLUMNS 
FROM `guess_2_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.145
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.240
SHOW FULL COLUMNS 
FROM `guess_has_winner`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
2
0.153
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.273
SHOW FULL COLUMNS 
FROM `guess_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
10
0.166
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.364
SHOW FULL COLUMNS 
FROM `import`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
4
0.314
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.395
SHOW FULL COLUMNS 
FROM `import_problem`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
5
0.157
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.310
SHOW FULL COLUMNS 
FROM `importer_watchdog`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17
3
0.139
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.303
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/2909933

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

¤ ×