bahis siteleri

NHL.cz na Facebooku

Zápasy a statistiky

Poř. Jméno Tým P Z Min. IG Z SP V P Prům. A TM SO
1 Paul Goodman Chicago Blackhawks B 1 60 5 0 0 0 1 5.00 0.00 0 0 0
2 Alfie Moore Chicago Blackhawks B 1 60 1 0 0 1 0 1.00 0.00 0 0 0
3 Mike Karakas Chicago Blackhawks B 8 525 15 0 0 6 2 1.71 0.00 0 0 2
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: 371.774 ms, default

Time msSQL QueryRows
0.083
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
0
2.451
SHOW FULL TABLES
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
254
0.636
SHOW FULL COLUMNS 
FROM `adhoc_stream`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
5
0.257
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/Post/PostRepository.php:17
0
0.519
SHOW FULL COLUMNS 
FROM `admin_module`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
0.229
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/Post/PostRepository.php:17
0
0.480
SHOW FULL COLUMNS 
FROM `available_video`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
1.569
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/Post/PostRepository.php:17
1
0.456
SHOW FULL COLUMNS 
FROM `best_player_poll`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
0.209
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/Post/PostRepository.php:17
2
0.418
SHOW FULL COLUMNS 
FROM `best_player_poll_category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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 =
'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/Post/PostRepository.php:17
1
0.409
SHOW FULL COLUMNS 
FROM `best_player_poll_coach`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
0.216
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/Post/PostRepository.php:17
2
0.469
SHOW FULL COLUMNS 
FROM `best_player_poll_coach_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.997
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/Post/PostRepository.php:17
1
0.362
SHOW FULL COLUMNS 
FROM `best_player_poll_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
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_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/Post/PostRepository.php:17
2
0.380
SHOW FULL COLUMNS 
FROM `best_player_poll_player_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
1.076
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/Post/PostRepository.php:17
1
0.363
SHOW FULL COLUMNS 
FROM `bet_company`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.173
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/Post/PostRepository.php:17
0
0.346
SHOW FULL COLUMNS 
FROM `bet_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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 = '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/Post/PostRepository.php:17
0
0.444
SHOW FULL COLUMNS 
FROM `category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
11
0.248
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/Post/PostRepository.php:17
3
0.411
SHOW FULL COLUMNS 
FROM `color`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
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 = '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/Post/PostRepository.php:17
0
0.381
SHOW FULL COLUMNS 
FROM `contest`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
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'
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/Post/PostRepository.php:17
0
0.388
SHOW FULL COLUMNS 
FROM `contest_answer`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.183
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/Post/PostRepository.php:17
1
0.385
SHOW FULL COLUMNS 
FROM `contest_answer_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
0.193
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/Post/PostRepository.php:17
2
0.392
SHOW FULL COLUMNS 
FROM `contest_answer_value`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
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 =
'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/Post/PostRepository.php:17
2
0.376
SHOW FULL COLUMNS 
FROM `contest_question`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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_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/Post/PostRepository.php:17
2
0.386
SHOW FULL COLUMNS 
FROM `contest_question_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
5
0.179
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/Post/PostRepository.php:17
1
0.341
SHOW FULL COLUMNS 
FROM `contest_question_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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 =
'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/Post/PostRepository.php:17
0
0.342
SHOW FULL COLUMNS 
FROM `country`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
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 = '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/Post/PostRepository.php:17
0
0.355
SHOW FULL COLUMNS 
FROM `error`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
5
0.364
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/Post/PostRepository.php:17
1
0.382
SHOW FULL COLUMNS 
FROM `error_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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 = '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/Post/PostRepository.php:17
0
0.381
SHOW FULL COLUMNS 
FROM `export_subscriber`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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 =
'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/Post/PostRepository.php:17
0
0.388
SHOW FULL COLUMNS 
FROM `facebook_ticket_competition`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
7
0.324
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/Post/PostRepository.php:17
0
0.429
SHOW FULL COLUMNS 
FROM `file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
5.794
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/Post/PostRepository.php:17
3
0.425
SHOW FULL COLUMNS 
FROM `file_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.238
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/Post/PostRepository.php:17
2
0.414
SHOW FULL COLUMNS 
FROM `file_source`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
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 = '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/Post/PostRepository.php:17
0
0.392
SHOW FULL COLUMNS 
FROM `file_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.193
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/Post/PostRepository.php:17
0
0.357
SHOW FULL COLUMNS 
FROM `file_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.188
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/Post/PostRepository.php:17
0
0.405
SHOW FULL COLUMNS 
FROM `filedir`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
2.753
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/Post/PostRepository.php:17
0
0.430
SHOW FULL COLUMNS 
FROM `fix_match`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.243
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/Post/PostRepository.php:17
0
0.365
SHOW FULL COLUMNS 
FROM `folder`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
0.168
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/Post/PostRepository.php:17
0
0.335
SHOW FULL COLUMNS 
FROM `folder_2_stats_club`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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 =
'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/Post/PostRepository.php:17
2
0.328
SHOW FULL COLUMNS 
FROM `folder_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.188
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/Post/PostRepository.php:17
2
0.370
SHOW FULL COLUMNS 
FROM `gallery`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
1.019
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/Post/PostRepository.php:17
0
0.369
SHOW FULL COLUMNS 
FROM `gallery_2_file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
9
2.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 =
'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/Post/PostRepository.php:17
3
0.350
SHOW FULL COLUMNS 
FROM `gallery_image_text`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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 =
'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/Post/PostRepository.php:17
1
0.447
SHOW FULL COLUMNS 
FROM `gallery_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
14
2.265
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/Post/PostRepository.php:17
1
0.413
SHOW FULL COLUMNS 
FROM `gallery_photo_2_stats_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.204
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/Post/PostRepository.php:17
2
0.372
SHOW FULL COLUMNS 
FROM `gallery_photo_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.225
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/Post/PostRepository.php:17
2
0.432
SHOW FULL COLUMNS 
FROM `guess`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
0.162
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/Post/PostRepository.php:17
0
0.356
SHOW FULL COLUMNS 
FROM `guess_2_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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 =
'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/Post/PostRepository.php:17
2
0.376
SHOW FULL COLUMNS 
FROM `guess_has_winner`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.174
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/Post/PostRepository.php:17
2
0.409
SHOW FULL COLUMNS 
FROM `guess_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
0.356
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/Post/PostRepository.php:17
1
0.495
SHOW FULL COLUMNS 
FROM `import`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.515
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/Post/PostRepository.php:17
0
0.431
SHOW FULL COLUMNS 
FROM `import_problem`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
5
0.253
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/Post/PostRepository.php:17
0
0.411
SHOW FULL COLUMNS 
FROM `importer_watchdog`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
0.249
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/Post/PostRepository.php:17
0
0.413
SHOW FULL COLUMNS 
FROM `impression_article_count`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
1

...and more

¤ ×

Unlogged

no identity

¤ ×

Front:League:PlayerStats:detailed

https://dev.nhlcz.s6.esports.cz/sezona/player-stats/detailni?stats-filter-season=1937&stats-filter-competition=5224&stats-filter-team=2388&stats-menu-section=goalkeeper

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
no Route zapas/<id \d+>[/<presenter>][/<action>] module = Match
presenter = Overview
action = default
Front
no Route / module = Home
presenter = Homepage
action = default
Front
no ArticleRoute <slug [a-zA-Z-0-9\-]+>/<id \d+> module = Article
presenter = Article
action = default
Front
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
yes LeagueRoute <id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] module = League
presenter = Overview
action = default
id = 
NULL
leagueId = 
NULL
Front Front:League:PlayerStats:detailed
id = 
1
leagueId = 
NULL
stats-filter-season = 1937
stats-filter-competition = 5224
stats-filter-team = 2388
stats-menu-section = goalkeeper
may Route <module>/<presenter>/<action>[/<id>] id = 
NULL
Front Front:Sezona:PlayerStats:detailni
id = 
NULL
stats-filter-season = 1937
stats-filter-competition = 5224
stats-filter-team = 2388
stats-menu-section = goalkeeper

Front\League\PlayerStatsPresenter::actionDetailed() in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/League/presenters/PlayerStatsPresenter.php:13

¤ ×

Queries: 520, time: 326.547 ms, default

Time msSQL QueryRows
0.058
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
0
2.481
SHOW FULL TABLES
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
254
0.612
SHOW FULL COLUMNS 
FROM `adhoc_stream`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
5
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 =
'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/Post/PostRepository.php:17
0
0.400
SHOW FULL COLUMNS 
FROM `admin_module`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
0.224
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/Post/PostRepository.php:17
0
0.391
SHOW FULL COLUMNS 
FROM `available_video`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
1.689
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/Post/PostRepository.php:17
1
0.415
SHOW FULL COLUMNS 
FROM `best_player_poll`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
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 =
'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/Post/PostRepository.php:17
2
0.334
SHOW FULL COLUMNS 
FROM `best_player_poll_category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
0.179
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/Post/PostRepository.php:17
1
0.419
SHOW FULL COLUMNS 
FROM `best_player_poll_coach`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
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 =
'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/Post/PostRepository.php:17
2
0.405
SHOW FULL COLUMNS 
FROM `best_player_poll_coach_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.895
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/Post/PostRepository.php:17
1
0.557
SHOW FULL COLUMNS 
FROM `best_player_poll_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
0.227
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/Post/PostRepository.php:17
2
0.367
SHOW FULL COLUMNS 
FROM `best_player_poll_player_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
1.061
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/Post/PostRepository.php:17
1
0.364
SHOW FULL COLUMNS 
FROM `bet_company`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.183
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/Post/PostRepository.php:17
0
0.350
SHOW FULL COLUMNS 
FROM `bet_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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_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/Post/PostRepository.php:17
0
0.417
SHOW FULL COLUMNS 
FROM `category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
11
0.274
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/Post/PostRepository.php:17
3
0.383
SHOW FULL COLUMNS 
FROM `color`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
0.195
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/Post/PostRepository.php:17
0
0.380
SHOW FULL COLUMNS 
FROM `contest`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
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 = '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/Post/PostRepository.php:17
0
0.361
SHOW FULL COLUMNS 
FROM `contest_answer`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
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_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/Post/PostRepository.php:17
1
0.360
SHOW FULL COLUMNS 
FROM `contest_answer_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
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 =
'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/Post/PostRepository.php:17
2
0.351
SHOW FULL COLUMNS 
FROM `contest_answer_value`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
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 =
'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/Post/PostRepository.php:17
2
0.398
SHOW FULL COLUMNS 
FROM `contest_question`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
6
0.209
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/Post/PostRepository.php:17
2
0.388
SHOW FULL COLUMNS 
FROM `contest_question_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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/Post/PostRepository.php:17
1
0.334
SHOW FULL COLUMNS 
FROM `contest_question_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.162
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/Post/PostRepository.php:17
0
0.337
SHOW FULL COLUMNS 
FROM `country`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
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 = '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/Post/PostRepository.php:17
0
0.350
SHOW FULL COLUMNS 
FROM `error`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
5
0.377
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/Post/PostRepository.php:17
1
0.322
SHOW FULL COLUMNS 
FROM `error_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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 = '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/Post/PostRepository.php:17
0
0.333
SHOW FULL COLUMNS 
FROM `export_subscriber`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
0.174
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/Post/PostRepository.php:17
0
0.341
SHOW FULL COLUMNS 
FROM `facebook_ticket_competition`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
7
0.291
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/Post/PostRepository.php:17
0
0.361
SHOW FULL COLUMNS 
FROM `file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
5.588
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/Post/PostRepository.php:17
3
0.350
SHOW FULL COLUMNS 
FROM `file_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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 = '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/Post/PostRepository.php:17
2
0.400
SHOW FULL COLUMNS 
FROM `file_source`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
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 = '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/Post/PostRepository.php:17
0
0.518
SHOW FULL COLUMNS 
FROM `file_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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 = '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/Post/PostRepository.php:17
0
0.352
SHOW FULL COLUMNS 
FROM `file_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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 = '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/Post/PostRepository.php:17
0
0.343
SHOW FULL COLUMNS 
FROM `filedir`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
2.889
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/Post/PostRepository.php:17
0
0.383
SHOW FULL COLUMNS 
FROM `fix_match`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.219
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/Post/PostRepository.php:17
0
0.359
SHOW FULL COLUMNS 
FROM `folder`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
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'
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/Post/PostRepository.php:17
0
0.367
SHOW FULL COLUMNS 
FROM `folder_2_stats_club`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.183
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/Post/PostRepository.php:17
2
0.332
SHOW FULL COLUMNS 
FROM `folder_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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 =
'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/Post/PostRepository.php:17
2
0.416
SHOW FULL COLUMNS 
FROM `gallery`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
1.000
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/Post/PostRepository.php:17
0
0.436
SHOW FULL COLUMNS 
FROM `gallery_2_file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
9
2.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 =
'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/Post/PostRepository.php:17
3
0.433
SHOW FULL COLUMNS 
FROM `gallery_image_text`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
5
0.183
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/Post/PostRepository.php:17
1
0.421
SHOW FULL COLUMNS 
FROM `gallery_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
14
2.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 =
'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/Post/PostRepository.php:17
1
0.373
SHOW FULL COLUMNS 
FROM `gallery_photo_2_stats_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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 =
'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/Post/PostRepository.php:17
2
0.379
SHOW FULL COLUMNS 
FROM `gallery_photo_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
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_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/Post/PostRepository.php:17
2
0.412
SHOW FULL COLUMNS 
FROM `guess`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
0.159
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/Post/PostRepository.php:17
0
0.286
SHOW FULL COLUMNS 
FROM `guess_2_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.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 =
'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/Post/PostRepository.php:17
2
0.276
SHOW FULL COLUMNS 
FROM `guess_has_winner`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
2
0.169
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/Post/PostRepository.php:17
2
0.355
SHOW FULL COLUMNS 
FROM `guess_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
10
0.746
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/Post/PostRepository.php:17
1
0.404
SHOW FULL COLUMNS 
FROM `import`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
4
0.345
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/Post/PostRepository.php:17
0
0.273
SHOW FULL COLUMNS 
FROM `import_problem`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
5
0.155
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/Post/PostRepository.php:17
0
0.304
SHOW FULL COLUMNS 
FROM `importer_watchdog`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
3
0.154
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/Post/PostRepository.php:17
0
0.248
SHOW FULL COLUMNS 
FROM `impression_article_count`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Post/PostRepository.php:17
1

...and more

¤ ×

Unlogged

no identity

¤ ×

Front:League:PlayerStats:detailed

https://dev.nhlcz.s6.esports.cz/sezona/player-stats/detailni?competition=5224&section=goalkeeper&teamId=2388

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
no Route zapas/<id \d+>[/<presenter>][/<action>] module = Match
presenter = Overview
action = default
Front
no Route / module = Home
presenter = Homepage
action = default
Front
no ArticleRoute <slug [a-zA-Z-0-9\-]+>/<id \d+> module = Article
presenter = Article
action = default
Front
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
yes LeagueRoute <id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] module = League
presenter = Overview
action = default
id = 
NULL
leagueId = 
NULL
Front Front:League:PlayerStats:detailed
id = 
1
leagueId = 
NULL
competition = 5224
section = goalkeeper
teamId = 2388
may Route <module>/<presenter>/<action>[/<id>] id = 
NULL
Front Front:Sezona:PlayerStats:detailni
id = 
NULL
competition = 5224
section = goalkeeper
teamId = 2388

Front\League\PlayerStatsPresenter::actionDetailed() in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/League/presenters/PlayerStatsPresenter.php:13

¤ ×