bahis siteleri

NHL.cz na Facebooku

NHL

ROMAN VRÁBLÍK

narozen

25.1.1990

výška

188 cm

věk

35 let

váha

84 kg

post

obránce

hůl

levá

Tipsport extraliga 2023-2024

zápasů 17  
gólů 0  
asistencí 3  
bodů 3  
± body 0  
tm 6  

Celá kariéra

soutěž klub z g a b +/- + - tm gv gp go
2004-2005 ELD D Písek 7 2 1 3 -1 6 7 2 0 1 0
ELD – A – III. část D Písek 7 2 1 3 -1 6 7 2 0 1 0
2005-2006 ELD D České Budějovice 47 1 6 7 10 35 25 62 0 0 0
ELD – A – I. část D České Budějovice 18 0 0 0 -5 8 13 12 0 0 0
ELD – společná D České Budějovice 20 1 3 4 11 17 6 36 0 0 0
ELD – A – III. část D České Budějovice 9 0 3 3 4 10 6 14 0 0 0
ELD – play off D České Budějovice 3 0 0 0 0 0 0 10 0 0 0
2006-2007 ELJ – play off J České Budějovice 1 0 0 0 -1 0 1 2 0 0 0
ELD D České Budějovice 43 6 20 26 19 47 28 82 0 4 0
ELD – A D České Budějovice 43 6 20 26 19 47 28 82 0 4 0
ELD – play off D České Budějovice 5 0 1 1 -5 2 7 8 0 0 0
2007-2008 ELJ J Slavia Praha 9 1 1 2 -3 3 6 4 0 1 0
ELJ J České Budějovice 14 0 1 1 -8 3 11 10 0 0 0
ELJ Celkem 23 1 2 3 -11 6 17 14 0 1 0
ELJ – play off J Slavia Praha 1 0 0 0 0 0 0 0 0 0 0
2008-2009 O2 extraliga – o umístění HC Mountfield 2 0 0 0 -1 1 2 0 0 0 0
ELJ J České Budějovice 46 4 5 9 14 39 25 52 2 3 0
ELJ – play off J České Budějovice 7 2 0 2 3 7 4 8 0 0 0
2009-2010 2. liga - S IHC Písek 1 0 0 0 0 0 0 0 0 0 0
Noen ELJ J České Budějovice 37 3 15 18 -4 21 25 63 0 1 0
Noen ELJ – Z J České Budějovice 17 1 2 3 -9 5 14 35 0 0 0
Noen ELJ II – Z – B J České Budějovice 8 1 3 4 -2 3 5 16 0 1 0
Noen ELJ III – B J České Budějovice 12 1 10 11 7 13 6 12 0 0 0
2010-2011 1. liga IHC Písek 43 3 2 5 -15 14 29 42 0 0 0
1. liga - I. část IHC Písek 29 2 0 2 -14 7 21 24 0 0 0
1. liga - II. část - B IHC Písek 14 1 2 3 -1 7 8 18 0 0 0
Baráž o 1. ligu IHC Písek 7 0 0 0 -7 2 9 12 0 0 0
2011-2012 Tipsport extraliga HC Mountfield 17 1 0 1 -3 4 7 6 0 0 0
1. liga IHC Písek 16 2 2 4 2 8 6 6 0 1 0
Noen ELJ J České Budějovice 2 0 1 1 -1 0 1 4 0 0 0
Noen ELJ II J České Budějovice 2 0 1 1 -1 0 1 4 0 0 0
2012-2013 Tipsport extraliga HC Mountfield 52 0 6 6 3 20 17 34 0 0 0
Česká pojišťovna play off HC Mountfield 5 0 1 1 -1 2 3 2 0 0 0
2013-2014 1. liga ČEZ Motor České Budějovice 36 2 6 8 -8 16 24 6 0 1 0
1. liga - O baráž ČEZ Motor České Budějovice 10 4 4 8 2 10 8 0 0 1 0
2014-2015 Baráž o extraligu ČEZ Motor České Budějovice 12 2 5 7 -1 7 8 4 0 1 0
1. liga ČEZ Motor České Budějovice 52 9 16 25 10 48 38 20 1 3 1
1. liga - play off ČEZ Motor České Budějovice 11 2 2 4 3 10 7 8 0 1 0
2015-2016 WSM Liga ČEZ Motor České Budějovice 42 6 14 20 19 44 25 22 1 4 0
WSM Liga - play off ČEZ Motor České Budějovice 9 0 5 5 0 4 4 4 0 0 0
2016-2017 Baráž o extraligu ČEZ Motor České Budějovice 10 0 2 2 3 4 1 6 0 0 0
WSM Liga ČEZ Motor České Budějovice 50 8 17 25 15 38 23 16 1 4 0
WSM Liga – play off ČEZ Motor České Budějovice 9 1 2 3 5 5 0 27 0 1 0
2017-2018 Tipsport extraliga HC Škoda Plzeň 2 0 0 0 -1 0 1 0 0 0 0
Generali play off HC Škoda Plzeň 4 0 1 1 -3 0 3 0 0 0 0
WSM Liga ČEZ Motor České Budějovice 47 2 15 17 23 40 17 16 0 0 0
WSM Liga – play off ČEZ Motor České Budějovice 5 1 1 2 0 4 4 0 0 0 0
2018-2019 Tipsport extraliga HC Škoda Plzeň 51 2 7 9 4 34 30 24 0 0 0
Generali play off HC Škoda Plzeň 14 1 1 2 0 5 5 10 0 0 0
2019-2020 Tipsport extraliga HC Škoda Plzeň 51 3 5 8 -3 28 31 32 2 0 0
2020-2021 Tipsport extraliga HC Škoda Plzeň 42 0 5 5 10 29 19 38 0 0 0
Generali Česká Cup HC Škoda Plzeň 6 1 1 2 -1 4 5 0 1 0 0
Generali Česká Cup – sk. A HC Škoda Plzeň 6 1 1 2 -1 4 5 0 1 0 0
Generali Česká Cup – play off HC Škoda Plzeň 2 0 0 0 -1 0 1 2 0 0 0
Generali Česká pojišťovna play off HC Škoda Plzeň 3 0 0 0 0 1 1 0 0 0 0
2021-2022 Generali Česká pojišťovna play off HC Motor České Budějovice 10 0 3 3 4 8 4 4 0 0 0
Tipsport extraliga HC Motor České Budějovice 55 4 11 15 8 38 30 32 0 2 0
2022-2023 Tipsport extraliga HC Motor České Budějovice 52 6 9 15 -6 30 36 26 2 4 0
2023-2024 Tipsport extraliga Banes Motor Č. Budějovice 17 0 3 3 0 12 12 6 0 0 0
soutěž klub z g a b +/- + - tm gv gp go
Vše Extraliga 2 klub 385 18 53 71 9 216 207 216 5 6 0
Baráž o extraligu 1 klub 22 2 7 9 2 11 9 10 0 1 0
CHANCE LIGA 2 klub 330 40 86 126 56 241 185 167 3 16 1
Baráž o 1. ligu 1 klub 7 0 0 0 -7 2 9 12 0 0 0
2. liga 1 klub 1 0 0 0 0 0 0 0 0 0 0
DHL extraliga juniorů 2 klub 117 10 23 33 0 73 73 143 2 5 0
Extraliga dorostu 2 klub 105 9 28 37 23 90 67 164 0 5 0

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: 759, time: 453.699 ms, default

Time msSQL QueryRows
0.058
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		0
1.653
SHOW FULL TABLES
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		254
0.394
SHOW FULL COLUMNS 
FROM `adhoc_stream`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		5
0.208
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/Player/PlayerRepository.php:17		0
0.422
SHOW FULL COLUMNS 
FROM `admin_module`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		10
0.233
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/Player/PlayerRepository.php:17		0
0.307
SHOW FULL COLUMNS 
FROM `available_video`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		6
0.905
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/Player/PlayerRepository.php:17		1
0.383
SHOW FULL COLUMNS 
FROM `best_player_poll`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		10
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 =
'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/Player/PlayerRepository.php:17		2
0.270
SHOW FULL COLUMNS 
FROM `best_player_poll_category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
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 =
'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/Player/PlayerRepository.php:17		1
0.391
SHOW FULL COLUMNS 
FROM `best_player_poll_coach`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		6
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 =
'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/Player/PlayerRepository.php:17		2
0.270
SHOW FULL COLUMNS 
FROM `best_player_poll_coach_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		4
0.611
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/Player/PlayerRepository.php:17		1
0.276
SHOW FULL COLUMNS 
FROM `best_player_poll_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.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/Player/PlayerRepository.php:17		2
1.373
SHOW FULL COLUMNS 
FROM `best_player_poll_player_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		4
0.972
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/Player/PlayerRepository.php:17		1
0.276
SHOW FULL COLUMNS 
FROM `bet_company`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		4
0.184
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/Player/PlayerRepository.php:17		0
0.316
SHOW FULL COLUMNS 
FROM `bet_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
0.211
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/Player/PlayerRepository.php:17		0
0.433
SHOW FULL COLUMNS 
FROM `category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		11
0.256
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/Player/PlayerRepository.php:17		3
0.362
SHOW FULL COLUMNS 
FROM `color`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
0.148
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/Player/PlayerRepository.php:17		0
0.384
SHOW FULL COLUMNS 
FROM `contest`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		6
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 = '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/Player/PlayerRepository.php:17		0
0.266
SHOW FULL COLUMNS 
FROM `contest_answer`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		4
0.201
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/Player/PlayerRepository.php:17		1
0.315
SHOW FULL COLUMNS 
FROM `contest_answer_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
0.206
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/Player/PlayerRepository.php:17		2
0.360
SHOW FULL COLUMNS 
FROM `contest_answer_value`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		4
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 =
'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/Player/PlayerRepository.php:17		2
0.299
SHOW FULL COLUMNS 
FROM `contest_question`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		6
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 =
'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/Player/PlayerRepository.php:17		2
0.345
SHOW FULL COLUMNS 
FROM `contest_question_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		5
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 =
'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/Player/PlayerRepository.php:17		1
0.281
SHOW FULL COLUMNS 
FROM `contest_question_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
0.137
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/Player/PlayerRepository.php:17		0
0.273
SHOW FULL COLUMNS 
FROM `country`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
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 = '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/Player/PlayerRepository.php:17		0
1.438
SHOW FULL COLUMNS 
FROM `error`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		5
0.373
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/Player/PlayerRepository.php:17		1
0.528
SHOW FULL COLUMNS 
FROM `error_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
0.242
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/Player/PlayerRepository.php:17		0
1.523
SHOW FULL COLUMNS 
FROM `export_subscriber`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
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 =
'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/Player/PlayerRepository.php:17		0
0.285
SHOW FULL COLUMNS 
FROM `facebook_ticket_competition`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		7
0.215
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/Player/PlayerRepository.php:17		0
0.318
SHOW FULL COLUMNS 
FROM `file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		10
2.940
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/Player/PlayerRepository.php:17		3
0.319
SHOW FULL COLUMNS 
FROM `file_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
0.151
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/Player/PlayerRepository.php:17		2
0.413
SHOW FULL COLUMNS 
FROM `file_source`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
0.148
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/Player/PlayerRepository.php:17		0
0.272
SHOW FULL COLUMNS 
FROM `file_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
0.138
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/Player/PlayerRepository.php:17		0
0.289
SHOW FULL COLUMNS 
FROM `file_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.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 = '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/Player/PlayerRepository.php:17		0
0.307
SHOW FULL COLUMNS 
FROM `filedir`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		4
1.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/Player/PlayerRepository.php:17		0
2.641
SHOW FULL COLUMNS 
FROM `fix_match`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		4
13.673
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/Player/PlayerRepository.php:17		0
0.426
SHOW FULL COLUMNS 
FROM `folder`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
0.156
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/Player/PlayerRepository.php:17		0
0.337
SHOW FULL COLUMNS 
FROM `folder_2_stats_club`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
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 =
'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/Player/PlayerRepository.php:17		2
0.442
SHOW FULL COLUMNS 
FROM `folder_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
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_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/Player/PlayerRepository.php:17		2
0.239
SHOW FULL COLUMNS 
FROM `gallery`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
0.538
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/Player/PlayerRepository.php:17		0
0.262
SHOW FULL COLUMNS 
FROM `gallery_2_file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		9
1.417
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/Player/PlayerRepository.php:17		3
0.239
SHOW FULL COLUMNS 
FROM `gallery_image_text`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		5
0.189
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/Player/PlayerRepository.php:17		1
0.286
SHOW FULL COLUMNS 
FROM `gallery_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		14
1.156
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/Player/PlayerRepository.php:17		1
0.254
SHOW FULL COLUMNS 
FROM `gallery_photo_2_stats_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
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 =
'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/Player/PlayerRepository.php:17		2
0.238
SHOW FULL COLUMNS 
FROM `gallery_photo_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
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 =
'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/Player/PlayerRepository.php:17		2
0.477
SHOW FULL COLUMNS 
FROM `guess`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		10
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 = '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/Player/PlayerRepository.php:17		0
0.268
SHOW FULL COLUMNS 
FROM `guess_2_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		2
0.177
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/Player/PlayerRepository.php:17		2
0.234
SHOW FULL COLUMNS 
FROM `guess_has_winner`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.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 =
'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/Player/PlayerRepository.php:17		2
0.325
SHOW FULL COLUMNS 
FROM `guess_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		10
0.138
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/Player/PlayerRepository.php:17		1
0.244
SHOW FULL COLUMNS 
FROM `import`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		4
0.281
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/Player/PlayerRepository.php:17		0
0.316
SHOW FULL COLUMNS 
FROM `import_problem`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		5
0.180
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/Player/PlayerRepository.php:17		0
0.257
SHOW FULL COLUMNS 
FROM `importer_watchdog`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		3
0.128
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/Player/PlayerRepository.php:17		0
0.249
SHOW FULL COLUMNS 
FROM `impression_article_count`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17		1

...and more

¤ ×

Front:Player:Overview:default

https://dev.nhlcz.s6.esports.cz/hrac/10250?stats-section=club

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
yes Route hrac/<id [0-9]+>[/<presenter>] module = Player
presenter = Overview
action = default
 Front Front:Player:Overview:default
id = 10250
stats-section = club
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
no Route zapas/<id \d+>[/<presenter>][/<action>] module = Match
presenter = Overview
action = default
 Front
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 = hrac
id = 10250
stats-section = club
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\Player\OverviewPresenter::renderDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/Player/presenters/OverviewPresenter.php:22

¤ ×