soutěž | klub | z | g | a | b | +/- | + | - | tm | gv | gp | go | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2012-2013 | 2. liga | SC Kolín | 28 | 1 | 4 | 5 | 0 | 0 | 0 | 8 | 0 | 1 | 0 | |
2. liga - S | SC Kolín | 26 | 0 | 3 | 3 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | ||
2. liga - play off - S | SC Kolín | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | ||
2013-2014 | Baráž o 1. ligu | SC Kolín | 8 | 2 | 5 | 7 | 0 | 7 | 7 | 6 | 0 | 1 | 0 | |
2. liga – Z | SC Kolín | 30 | 4 | 3 | 7 | 0 | 0 | 0 | 10 | 1 | 0 | 0 | ||
2. liga - play off - Z | SC Kolín | 11 | 0 | 6 | 6 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | ||
2014-2015 | 2. liga - play off - Z | SC Kolín | 6 | 1 | 2 | 3 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | |
2. liga | SC Kolín | 31 | 12 | 14 | 26 | 0 | 0 | 0 | 18 | 1 | 0 | 0 | ||
2. liga – Z | SC Kolín | 31 | 12 | 14 | 26 | 0 | 0 | 0 | 18 | 1 | 0 | 0 | ||
2015-2016 | 2. liga – Z | SC Kolín | 33 | 8 | 28 | 36 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | |
2. liga - play off - Z | SC Kolín | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | ||
2016-2017 | 2. liga – S | SC Kolín | 35 | 12 | 16 | 28 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | |
2. liga – play off – ZS | SC Kolín | 7 | 3 | 1 | 4 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | ||
2017-2018 | 2. liga – S | SC Kolín | 33 | 9 | 11 | 20 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | |
2. liga – play off – ZS | SC Kolín | 7 | 3 | 2 | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | ||
2018-2019 | 2. liga | SC Kolín | 33 | 16 | 20 | 36 | 0 | 0 | 0 | 28 | 2 | 0 | 0 | |
2. liga – Sever a Střed | SC Kolín | 33 | 16 | 20 | 36 | 0 | 0 | 0 | 28 | 2 | 0 | 0 | ||
2. liga – play off – SS | SC Kolín | 7 | 0 | 3 | 3 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | ||
2019-2020 | 2. liga – Střed | SC Kolín | 40 | 7 | 18 | 25 | 1 | 1 | 0 | 20 | 1 | 2 | 0 | |
2020-2021 | CHANCE LIGA | SC Kolín | 34 | 3 | 4 | 7 | -13 | 14 | 27 | 26 | 0 | 0 | 0 | |
2021-2022 | CHANCE LIGA | SC Marimex Kolín | 31 | 3 | 2 | 5 | 0 | 8 | 8 | 6 | 0 | 1 | 0 | |
2. liga – Jih | BK Havlíčkův Brod | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
2022-2023 | 2. liga | HC Benátky nad Jizerou | 28 | 10 | 15 | 25 | 7 | 23 | 16 | 20 | 0 | 4 | 0 | |
2023-2024 | 2. liga | HC Benátky nad Jizerou | 19 | 2 | 8 | 10 | 0 | 0 | 0 | 8 | 0 | 1 | 0 | |
2. liga – Západ | HC Benátky nad Jizerou | 19 | 2 | 8 | 10 | 0 | 0 | 0 | 8 | 0 | 1 | 0 | ||
soutěž | klub | z | g | a | b | +/- | + | - | tm | gv | gp | go | ||
Vše | CHANCE LIGA | 1 klub | 65 | 6 | 6 | 12 | -13 | 22 | 35 | 32 | 0 | 1 | 0 | |
Baráž o 1. ligu | 1 klub | 8 | 2 | 5 | 7 | 0 | 7 | 7 | 6 | 0 | 1 | 0 | ||
2. liga | 3 klub | 357 | 89 | 151 | 240 | 8 | 24 | 16 | 235 | 5 | 8 | 0 |
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.
Time ms | SQL Query | Rows | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.063 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 0 | ||||||||||||||||||||
1.687 | SHOW FULL TABLES/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 254 | ||||||||||||||||||||
0.352 | SHOW FULL COLUMNS FROM `adhoc_stream`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
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 = 'adhoc_stream'
| 0 | ||||||||||||||||||||
0.414 | SHOW FULL COLUMNS FROM `admin_module`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
0.176 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'admin_module'
| 0 | ||||||||||||||||||||
0.293 | SHOW FULL COLUMNS FROM `available_video`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 6 | ||||||||||||||||||||
0.948 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'
| 1 | ||||||||||||||||||||
0.296 | SHOW FULL COLUMNS FROM `best_player_poll`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
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 = 'best_player_poll'
| 2 | ||||||||||||||||||||
0.356 | 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.150 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_category'
| 1 | ||||||||||||||||||||
0.353 | 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.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 = 'best_player_poll_coach'
| 2 | ||||||||||||||||||||
0.262 | 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.617 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'
| 1 | ||||||||||||||||||||
0.297 | 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.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 = 'best_player_poll_player'
| 2 | ||||||||||||||||||||
0.650 | 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.646 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'
| 1 | ||||||||||||||||||||
0.286 | SHOW FULL COLUMNS FROM `bet_company`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
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 = 'bet_company'
| 0 | ||||||||||||||||||||
0.353 | SHOW FULL COLUMNS FROM `bet_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.161 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'
| 0 | ||||||||||||||||||||
0.301 | SHOW FULL COLUMNS FROM `category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 11 | ||||||||||||||||||||
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 = 'category'
| 3 | ||||||||||||||||||||
0.276 | 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'
| 0 | ||||||||||||||||||||
0.279 | SHOW FULL COLUMNS FROM `contest`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 6 | ||||||||||||||||||||
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 = 'contest'
| 0 | ||||||||||||||||||||
0.295 | SHOW FULL COLUMNS FROM `contest_answer`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
0.158 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'
| 1 | ||||||||||||||||||||
0.274 | SHOW FULL COLUMNS FROM `contest_answer_item`/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 = 'contest_answer_item'
| 2 | ||||||||||||||||||||
0.264 | SHOW FULL COLUMNS FROM `contest_answer_value`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
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_answer_value'
| 2 | ||||||||||||||||||||
0.272 | SHOW FULL COLUMNS FROM `contest_question`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 6 | ||||||||||||||||||||
0.149 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'
| 2 | ||||||||||||||||||||
0.295 | SHOW FULL COLUMNS FROM `contest_question_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
0.146 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question_item'
| 1 | ||||||||||||||||||||
0.253 | SHOW FULL COLUMNS FROM `contest_question_type`/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 = 'contest_question_type'
| 0 | ||||||||||||||||||||
0.267 | SHOW FULL COLUMNS FROM `country`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
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 = 'country'
| 0 | ||||||||||||||||||||
0.284 | SHOW FULL COLUMNS FROM `error`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
0.276 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'
| 1 | ||||||||||||||||||||
0.261 | SHOW FULL COLUMNS FROM `error_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.146 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'error_type'
| 0 | ||||||||||||||||||||
0.270 | SHOW FULL COLUMNS FROM `export_subscriber`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
0.150 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'export_subscriber'
| 0 | ||||||||||||||||||||
0.280 | SHOW FULL COLUMNS FROM `facebook_ticket_competition`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 7 | ||||||||||||||||||||
0.241 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'
| 0 | ||||||||||||||||||||
0.296 | SHOW FULL COLUMNS FROM `file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
2.951 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'
| 3 | ||||||||||||||||||||
0.294 | SHOW FULL COLUMNS FROM `file_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.149 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'
| 2 | ||||||||||||||||||||
0.256 | SHOW FULL COLUMNS FROM `file_source`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
0.140 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'
| 0 | ||||||||||||||||||||
0.268 | SHOW FULL COLUMNS FROM `file_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.134 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'
| 0 | ||||||||||||||||||||
0.263 | SHOW FULL COLUMNS FROM `file_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.142 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_type'
| 0 | ||||||||||||||||||||
0.360 | SHOW FULL COLUMNS FROM `filedir`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
1.370 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'
| 0 | ||||||||||||||||||||
0.300 | SHOW FULL COLUMNS FROM `fix_match`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
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 = 'fix_match'
| 0 | ||||||||||||||||||||
0.268 | SHOW FULL COLUMNS FROM `folder`/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 = 'folder'
| 0 | ||||||||||||||||||||
0.259 | 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.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 = 'folder_2_stats_club'
| 2 | ||||||||||||||||||||
0.265 | SHOW FULL COLUMNS FROM `folder_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.199 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'folder_2_tag'
| 2 | ||||||||||||||||||||
0.261 | SHOW FULL COLUMNS FROM `gallery`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
0.522 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'
| 0 | ||||||||||||||||||||
0.299 | SHOW FULL COLUMNS FROM `gallery_2_file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 9 | ||||||||||||||||||||
1.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_2_file'
| 3 | ||||||||||||||||||||
0.268 | SHOW FULL COLUMNS FROM `gallery_image_text`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.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 = 'gallery_image_text'
| 1 | ||||||||||||||||||||
0.306 | SHOW FULL COLUMNS FROM `gallery_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 14 | ||||||||||||||||||||
1.320 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'
| 1 | ||||||||||||||||||||
0.263 | 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'
| 2 | ||||||||||||||||||||
0.271 | 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.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 = 'gallery_photo_2_tag'
| 2 | ||||||||||||||||||||
0.294 | SHOW FULL COLUMNS FROM `guess`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
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 = 'guess'
| 0 | ||||||||||||||||||||
0.294 | SHOW FULL COLUMNS FROM `guess_2_photo`/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_2_photo'
| 2 | ||||||||||||||||||||
0.260 | SHOW FULL COLUMNS FROM `guess_has_winner`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
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 = 'guess_has_winner'
| 2 | ||||||||||||||||||||
0.309 | SHOW FULL COLUMNS FROM `guess_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
0.164 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_vote'
| 1 | ||||||||||||||||||||
0.380 | SHOW FULL COLUMNS FROM `import`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
0.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 = 'import'
| 0 | ||||||||||||||||||||
0.275 | SHOW FULL COLUMNS FROM `import_problem`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
0.164 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'import_problem'
| 0 | ||||||||||||||||||||
0.310 | SHOW FULL COLUMNS FROM `importer_watchdog`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
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 = 'importer_watchdog'
| 0 | ||||||||||||||||||||
0.335 | 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
no identity
https://dev.nhlcz.s6.esports.cz/hrac/19073?stats-section=club
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
test/<presenter>/<action>[/<id>] |
module = Test |
Test |
|
no | Route |
<module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] |
action = default |
Export |
|
no | Route |
admin/<module>/<presenter>/<action>[/<id>] |
module = Dashboard |
Admin |
|
yes | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
Front:Player:Overview:default |
no | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
|
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/infinitive-scroll |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
may | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
Front:Article:Article:default |
no | ArticleCompatRoute |
<slug [a-zA-Z-0-9\-]+> |
module = Article |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] |
module = League |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> |
module = MinorLeague |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] |
module = League |
Front |
|
no | Route |
<module>/<presenter>/<action>[/<id>] |
id = |
Front |
Front\Player\OverviewPresenter::renderDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/Player/presenters/OverviewPresenter.php:22
Time ms | SQL Query | Rows | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.087 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 0 | ||||||||||||||||||||
2.500 | SHOW FULL TABLES/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 254 | ||||||||||||||||||||
0.560 | SHOW FULL COLUMNS FROM `adhoc_stream`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
0.300 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'
| 0 | ||||||||||||||||||||
0.504 | SHOW FULL COLUMNS FROM `admin_module`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
0.353 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'
| 0 | ||||||||||||||||||||
0.387 | SHOW FULL COLUMNS FROM `available_video`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 6 | ||||||||||||||||||||
1.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 = 'available_video'
| 1 | ||||||||||||||||||||
0.375 | SHOW FULL COLUMNS FROM `best_player_poll`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
0.223 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'
| 2 | ||||||||||||||||||||
0.417 | 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.207 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_category'
| 1 | ||||||||||||||||||||
0.386 | 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.202 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_coach'
| 2 | ||||||||||||||||||||
0.389 | 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.697 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'
| 1 | ||||||||||||||||||||
0.297 | 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'
| 2 | ||||||||||||||||||||
0.303 | 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.635 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'
| 1 | ||||||||||||||||||||
0.298 | SHOW FULL COLUMNS FROM `bet_company`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
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 = 'bet_company'
| 0 | ||||||||||||||||||||
0.264 | SHOW FULL COLUMNS FROM `bet_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
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 = 'bet_type'
| 0 | ||||||||||||||||||||
0.305 | SHOW FULL COLUMNS FROM `category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 11 | ||||||||||||||||||||
0.202 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'category'
| 3 | ||||||||||||||||||||
0.266 | SHOW FULL COLUMNS FROM `color`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
0.163 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'color'
| 0 | ||||||||||||||||||||
0.288 | SHOW FULL COLUMNS FROM `contest`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 6 | ||||||||||||||||||||
0.158 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'
| 0 | ||||||||||||||||||||
0.252 | SHOW FULL COLUMNS FROM `contest_answer`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
0.166 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_answer'
| 1 | ||||||||||||||||||||
0.251 | SHOW FULL COLUMNS FROM `contest_answer_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
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_item'
| 2 | ||||||||||||||||||||
0.308 | SHOW FULL COLUMNS FROM `contest_answer_value`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
0.172 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'
| 2 | ||||||||||||||||||||
0.292 | SHOW FULL COLUMNS FROM `contest_question`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.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_question'
| 2 | ||||||||||||||||||||
0.290 | SHOW FULL COLUMNS FROM `contest_question_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
0.176 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question_item'
| 1 | ||||||||||||||||||||
0.275 | SHOW FULL COLUMNS FROM `contest_question_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.153 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question_type'
| 0 | ||||||||||||||||||||
0.276 | SHOW FULL COLUMNS FROM `country`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
0.163 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'country'
| 0 | ||||||||||||||||||||
0.346 | SHOW FULL COLUMNS FROM `error`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
0.275 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'
| 1 | ||||||||||||||||||||
0.280 | SHOW FULL COLUMNS FROM `error_type`/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 = 'error_type'
| 0 | ||||||||||||||||||||
0.272 | SHOW FULL COLUMNS FROM `export_subscriber`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.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 = 'export_subscriber'
| 0 | ||||||||||||||||||||
0.295 | SHOW FULL COLUMNS FROM `facebook_ticket_competition`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 7 | ||||||||||||||||||||
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 = 'facebook_ticket_competition'
| 0 | ||||||||||||||||||||
0.314 | SHOW FULL COLUMNS FROM `file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
2.947 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'
| 3 | ||||||||||||||||||||
0.284 | SHOW FULL COLUMNS FROM `file_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
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 = 'file_2_tag'
| 2 | ||||||||||||||||||||
0.281 | SHOW FULL COLUMNS FROM `file_source`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
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 = 'file_source'
| 0 | ||||||||||||||||||||
0.283 | SHOW FULL COLUMNS FROM `file_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.167 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'
| 0 | ||||||||||||||||||||
0.306 | SHOW FULL COLUMNS FROM `file_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
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 = 'file_type'
| 0 | ||||||||||||||||||||
0.296 | SHOW FULL COLUMNS FROM `filedir`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
1.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 = 'filedir'
| 0 | ||||||||||||||||||||
0.272 | SHOW FULL COLUMNS FROM `fix_match`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
0.200 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'fix_match'
| 0 | ||||||||||||||||||||
0.265 | SHOW FULL COLUMNS FROM `folder`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.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 = 'folder'
| 0 | ||||||||||||||||||||
0.305 | 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.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 = 'folder_2_stats_club'
| 2 | ||||||||||||||||||||
0.359 | SHOW FULL COLUMNS FROM `folder_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
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 = 'folder_2_tag'
| 2 | ||||||||||||||||||||
0.380 | SHOW FULL COLUMNS FROM `gallery`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
1.073 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'
| 0 | ||||||||||||||||||||
0.413 | SHOW FULL COLUMNS FROM `gallery_2_file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 9 | ||||||||||||||||||||
2.517 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'
| 3 | ||||||||||||||||||||
0.420 | SHOW FULL COLUMNS FROM `gallery_image_text`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
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 = 'gallery_image_text'
| 1 | ||||||||||||||||||||
0.414 | SHOW FULL COLUMNS FROM `gallery_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 14 | ||||||||||||||||||||
2.028 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'
| 1 | ||||||||||||||||||||
0.356 | 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.202 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_photo_2_stats_player'
| 2 | ||||||||||||||||||||
0.331 | 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.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 = 'gallery_photo_2_tag'
| 2 | ||||||||||||||||||||
0.404 | 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'
| 0 | ||||||||||||||||||||
0.295 | SHOW FULL COLUMNS FROM `guess_2_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 2 | ||||||||||||||||||||
0.160 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_2_photo'
| 2 | ||||||||||||||||||||
0.289 | SHOW FULL COLUMNS FROM `guess_has_winner`/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 = 'guess_has_winner'
| 2 | ||||||||||||||||||||
0.293 | SHOW FULL COLUMNS FROM `guess_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 10 | ||||||||||||||||||||
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 = 'guess_vote'
| 1 | ||||||||||||||||||||
0.266 | SHOW FULL COLUMNS FROM `import`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 4 | ||||||||||||||||||||
0.276 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'
| 0 | ||||||||||||||||||||
0.295 | SHOW FULL COLUMNS FROM `import_problem`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 5 | ||||||||||||||||||||
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 = 'import_problem'
| 0 | ||||||||||||||||||||
0.354 | SHOW FULL COLUMNS FROM `importer_watchdog`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Player/PlayerRepository.php:17 | 3 | ||||||||||||||||||||
0.146 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'importer_watchdog'
| 0 | ||||||||||||||||||||
0.246 | 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
no identity
https://dev.nhlcz.s6.esports.cz/hrac/19073?do=stats-section&stats-section=club
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
test/<presenter>/<action>[/<id>] |
module = Test |
Test |
|
no | Route |
<module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] |
action = default |
Export |
|
no | Route |
admin/<module>/<presenter>/<action>[/<id>] |
module = Dashboard |
Admin |
|
yes | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
Front:Player:Overview:default |
no | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
|
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/infinitive-scroll |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
may | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
Front:Article:Article:default |
no | ArticleCompatRoute |
<slug [a-zA-Z-0-9\-]+> |
module = Article |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] |
module = League |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> |
module = MinorLeague |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] |
module = League |
Front |
|
no | Route |
<module>/<presenter>/<action>[/<id>] |
id = |
Front |
Front\Player\OverviewPresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/Player/presenters/OverviewPresenter.php:8