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.072 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 0 | ||||||||||||||||||||
2.324 | SHOW FULL TABLES/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 254 | ||||||||||||||||||||
1.617 | SHOW FULL COLUMNS FROM `adhoc_stream`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
14.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 = 'adhoc_stream'
| 0 | ||||||||||||||||||||
0.417 | SHOW FULL COLUMNS FROM `admin_module`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
0.232 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.375 | SHOW FULL COLUMNS FROM `available_video`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
1.657 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.382 | SHOW FULL COLUMNS FROM `best_player_poll`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
3.787 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.583 | SHOW FULL COLUMNS FROM `best_player_poll_category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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_category'
| 1 | ||||||||||||||||||||
0.383 | SHOW FULL COLUMNS FROM `best_player_poll_coach`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
20.157 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_coach'
| 2 | ||||||||||||||||||||
0.634 | SHOW FULL COLUMNS FROM `best_player_poll_coach_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
1.340 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.480 | SHOW FULL COLUMNS FROM `best_player_poll_player`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
0.259 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_player'
| 2 | ||||||||||||||||||||
0.661 | SHOW FULL COLUMNS FROM `best_player_poll_player_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
1.124 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.422 | SHOW FULL COLUMNS FROM `bet_company`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
2.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 = 'bet_company'
| 0 | ||||||||||||||||||||
17.566 | SHOW FULL COLUMNS FROM `bet_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.222 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bet_type'
| 0 | ||||||||||||||||||||
0.431 | SHOW FULL COLUMNS FROM `category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 11 | ||||||||||||||||||||
0.737 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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 | ||||||||||||||||||||
1.131 | SHOW FULL COLUMNS FROM `color`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.602 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.445 | SHOW FULL COLUMNS FROM `contest`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'contest'
| 0 | ||||||||||||||||||||
0.400 | SHOW FULL COLUMNS FROM `contest_answer`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.212 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.399 | SHOW FULL COLUMNS FROM `contest_answer_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.236 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_answer_item'
| 2 | ||||||||||||||||||||
0.399 | SHOW FULL COLUMNS FROM `contest_answer_value`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.252 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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 | ||||||||||||||||||||
5.875 | SHOW FULL COLUMNS FROM `contest_question`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
0.277 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.437 | SHOW FULL COLUMNS FROM `contest_question_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
0.259 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question_item'
| 1 | ||||||||||||||||||||
0.395 | SHOW FULL COLUMNS FROM `contest_question_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'contest_question_type'
| 0 | ||||||||||||||||||||
0.450 | SHOW FULL COLUMNS FROM `country`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.252 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.448 | SHOW FULL COLUMNS FROM `error`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
1.074 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.829 | SHOW FULL COLUMNS FROM `error_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.211 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'error_type'
| 0 | ||||||||||||||||||||
0.419 | SHOW FULL COLUMNS FROM `export_subscriber`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.218 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'export_subscriber'
| 0 | ||||||||||||||||||||
0.427 | SHOW FULL COLUMNS FROM `facebook_ticket_competition`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 7 | ||||||||||||||||||||
0.365 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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 | ||||||||||||||||||||
4.780 | SHOW FULL COLUMNS FROM `file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
5.284 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.432 | SHOW FULL COLUMNS FROM `file_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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 = 'file_2_tag'
| 2 | ||||||||||||||||||||
0.427 | SHOW FULL COLUMNS FROM `file_source`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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 = 'file_source'
| 0 | ||||||||||||||||||||
0.400 | SHOW FULL COLUMNS FROM `file_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.213 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.390 | SHOW FULL COLUMNS FROM `file_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'file_type'
| 0 | ||||||||||||||||||||
0.399 | SHOW FULL COLUMNS FROM `filedir`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
2.512 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.488 | SHOW FULL COLUMNS FROM `fix_match`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.268 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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 | ||||||||||||||||||||
4.510 | SHOW FULL COLUMNS FROM `folder`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'folder'
| 0 | ||||||||||||||||||||
0.413 | SHOW FULL COLUMNS FROM `folder_2_stats_club`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.231 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.386 | SHOW FULL COLUMNS FROM `folder_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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 = 'folder_2_tag'
| 2 | ||||||||||||||||||||
7.825 | SHOW FULL COLUMNS FROM `gallery`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
1.091 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.578 | SHOW FULL COLUMNS FROM `gallery_2_file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 9 | ||||||||||||||||||||
1.279 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.572 | SHOW FULL COLUMNS FROM `gallery_image_text`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
3.341 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.696 | SHOW FULL COLUMNS FROM `gallery_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 14 | ||||||||||||||||||||
2.470 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.713 | SHOW FULL COLUMNS FROM `gallery_photo_2_stats_player`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.221 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.752 | SHOW FULL COLUMNS FROM `gallery_photo_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.255 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_photo_2_tag'
| 2 | ||||||||||||||||||||
0.732 | SHOW FULL COLUMNS FROM `guess`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
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 = 'guess'
| 0 | ||||||||||||||||||||
0.280 | SHOW FULL COLUMNS FROM `guess_2_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'guess_2_photo'
| 2 | ||||||||||||||||||||
0.442 | SHOW FULL COLUMNS FROM `guess_has_winner`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'guess_has_winner'
| 2 | ||||||||||||||||||||
0.516 | SHOW FULL COLUMNS FROM `guess_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
0.182 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_vote'
| 1 | ||||||||||||||||||||
0.305 | SHOW FULL COLUMNS FROM `import`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.323 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.432 | SHOW FULL COLUMNS FROM `import_problem`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
0.182 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'import_problem'
| 0 | ||||||||||||||||||||
0.483 | SHOW FULL COLUMNS FROM `importer_watchdog`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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 = 'importer_watchdog'
| 0 | ||||||||||||||||||||
0.271 | SHOW FULL COLUMNS FROM `impression_article_count`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 1 |
...and more
no identity
https://dev.nhlcz.s6.esports.cz/klub/44/statistiky?stats-filter-season=2023&stats-filter-competition=7088&stats-filter-team=44&stats-menu-section=info&stats-view-order=p&stats-view-direction=desc
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 |
|
no | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
|
yes | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
Front:Club:Stats:default |
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 |
|
no | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
|
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\Club\StatsPresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/Club/presenters/StatsPresenter.php:22
Time ms | SQL Query | Rows | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.055 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 0 | ||||||||||||||||||||
2.247 | SHOW FULL TABLES/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 254 | ||||||||||||||||||||
0.325 | SHOW FULL COLUMNS FROM `adhoc_stream`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
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 = 'adhoc_stream'
| 0 | ||||||||||||||||||||
0.415 | SHOW FULL COLUMNS FROM `admin_module`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
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 = 'admin_module'
| 0 | ||||||||||||||||||||
0.402 | SHOW FULL COLUMNS FROM `available_video`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
1.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 = 'available_video'
| 1 | ||||||||||||||||||||
0.509 | SHOW FULL COLUMNS FROM `best_player_poll`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
0.254 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll'
| 2 | ||||||||||||||||||||
10.100 | SHOW FULL COLUMNS FROM `best_player_poll_category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.256 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_category'
| 1 | ||||||||||||||||||||
0.431 | SHOW FULL COLUMNS FROM `best_player_poll_coach`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
0.232 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.401 | SHOW FULL COLUMNS FROM `best_player_poll_coach_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.962 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.415 | SHOW FULL COLUMNS FROM `best_player_poll_player`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
0.242 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_player'
| 2 | ||||||||||||||||||||
0.499 | SHOW FULL COLUMNS FROM `best_player_poll_player_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
1.126 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.482 | SHOW FULL COLUMNS FROM `bet_company`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
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 = 'bet_company'
| 0 | ||||||||||||||||||||
0.376 | SHOW FULL COLUMNS FROM `bet_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'bet_type'
| 0 | ||||||||||||||||||||
0.457 | SHOW FULL COLUMNS FROM `category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 11 | ||||||||||||||||||||
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 = 'category'
| 3 | ||||||||||||||||||||
0.387 | SHOW FULL COLUMNS FROM `color`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.206 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'color'
| 0 | ||||||||||||||||||||
0.401 | SHOW FULL COLUMNS FROM `contest`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
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'
| 0 | ||||||||||||||||||||
0.419 | SHOW FULL COLUMNS FROM `contest_answer`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.208 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_answer'
| 1 | ||||||||||||||||||||
0.424 | SHOW FULL COLUMNS FROM `contest_answer_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.213 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.465 | SHOW FULL COLUMNS FROM `contest_answer_value`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.214 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_answer_value'
| 2 | ||||||||||||||||||||
0.490 | SHOW FULL COLUMNS FROM `contest_question`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
0.215 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question'
| 2 | ||||||||||||||||||||
0.390 | SHOW FULL COLUMNS FROM `contest_question_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
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 = 'contest_question_item'
| 1 | ||||||||||||||||||||
0.436 | SHOW FULL COLUMNS FROM `contest_question_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'contest_question_type'
| 0 | ||||||||||||||||||||
0.392 | SHOW FULL COLUMNS FROM `country`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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 = 'country'
| 0 | ||||||||||||||||||||
0.394 | SHOW FULL COLUMNS FROM `error`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
0.401 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.512 | SHOW FULL COLUMNS FROM `error_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.189 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'error_type'
| 0 | ||||||||||||||||||||
0.489 | SHOW FULL COLUMNS FROM `export_subscriber`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'export_subscriber'
| 0 | ||||||||||||||||||||
0.433 | SHOW FULL COLUMNS FROM `facebook_ticket_competition`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 7 | ||||||||||||||||||||
0.339 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.446 | SHOW FULL COLUMNS FROM `file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
5.612 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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 | ||||||||||||||||||||
24.569 | SHOW FULL COLUMNS FROM `file_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.212 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.359 | SHOW FULL COLUMNS FROM `file_source`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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 = 'file_source'
| 0 | ||||||||||||||||||||
0.343 | SHOW FULL COLUMNS FROM `file_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'file_tag'
| 0 | ||||||||||||||||||||
0.356 | SHOW FULL COLUMNS FROM `file_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
2.231 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.356 | SHOW FULL COLUMNS FROM `filedir`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
2.441 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.382 | SHOW FULL COLUMNS FROM `fix_match`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.246 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.456 | SHOW FULL COLUMNS FROM `folder`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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'
| 0 | ||||||||||||||||||||
0.546 | SHOW FULL COLUMNS FROM `folder_2_stats_club`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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 = 'folder_2_stats_club'
| 2 | ||||||||||||||||||||
0.363 | SHOW FULL COLUMNS FROM `folder_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.211 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'folder_2_tag'
| 2 | ||||||||||||||||||||
0.378 | SHOW FULL COLUMNS FROM `gallery`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.903 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.531 | SHOW FULL COLUMNS FROM `gallery_2_file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 9 | ||||||||||||||||||||
2.451 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.610 | SHOW FULL COLUMNS FROM `gallery_image_text`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
0.233 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_image_text'
| 1 | ||||||||||||||||||||
0.451 | SHOW FULL COLUMNS FROM `gallery_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 14 | ||||||||||||||||||||
2.347 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.368 | SHOW FULL COLUMNS FROM `gallery_photo_2_stats_player`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.215 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery_photo_2_stats_player'
| 2 | ||||||||||||||||||||
0.367 | SHOW FULL COLUMNS FROM `gallery_photo_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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_photo_2_tag'
| 2 | ||||||||||||||||||||
0.493 | SHOW FULL COLUMNS FROM `guess`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
0.196 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess'
| 0 | ||||||||||||||||||||
0.459 | SHOW FULL COLUMNS FROM `guess_2_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.226 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.368 | SHOW FULL COLUMNS FROM `guess_has_winner`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.213 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.496 | SHOW FULL COLUMNS FROM `guess_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
0.222 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_vote'
| 1 | ||||||||||||||||||||
0.417 | SHOW FULL COLUMNS FROM `import`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.489 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.393 | SHOW FULL COLUMNS FROM `import_problem`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
0.232 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.420 | SHOW FULL COLUMNS FROM `importer_watchdog`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'importer_watchdog'
| 0 | ||||||||||||||||||||
0.501 | SHOW FULL COLUMNS FROM `impression_article_count`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 1 |
...and more
no identity
https://dev.nhlcz.s6.esports.cz/klub/44/statistiky?stats-filter-season=2023&stats-filter-competition=7088&stats-filter-team=44&stats-menu-section=info&stats-view-order=p&stats-view-direction=desc&do=stats-view-sort
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 |
|
no | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
|
yes | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
Front:Club:Stats:default |
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 |
|
no | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
|
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\Club\StatsPresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/Club/presenters/StatsPresenter.php:8
Time ms | SQL Query | Rows | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.051 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 0 | ||||||||||||||||||||
2.274 | SHOW FULL TABLES/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 254 | ||||||||||||||||||||
0.318 | SHOW FULL COLUMNS FROM `adhoc_stream`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'adhoc_stream'
| 0 | ||||||||||||||||||||
0.431 | SHOW FULL COLUMNS FROM `admin_module`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'admin_module'
| 0 | ||||||||||||||||||||
0.328 | SHOW FULL COLUMNS FROM `available_video`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
1.539 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.435 | SHOW FULL COLUMNS FROM `best_player_poll`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
0.196 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll'
| 2 | ||||||||||||||||||||
0.387 | SHOW FULL COLUMNS FROM `best_player_poll_category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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_category'
| 1 | ||||||||||||||||||||
0.397 | SHOW FULL COLUMNS FROM `best_player_poll_coach`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
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 = 'best_player_poll_coach'
| 2 | ||||||||||||||||||||
0.312 | SHOW FULL COLUMNS FROM `best_player_poll_coach_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.663 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.310 | SHOW FULL COLUMNS FROM `best_player_poll_player`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
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_player'
| 2 | ||||||||||||||||||||
0.288 | SHOW FULL COLUMNS FROM `best_player_poll_player_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.611 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'best_player_poll_player_vote'
| 1 | ||||||||||||||||||||
0.275 | SHOW FULL COLUMNS FROM `bet_company`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.147 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bet_company'
| 0 | ||||||||||||||||||||
0.264 | SHOW FULL COLUMNS FROM `bet_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.145 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bet_type'
| 0 | ||||||||||||||||||||
0.306 | SHOW FULL COLUMNS FROM `category`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 11 | ||||||||||||||||||||
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 = 'category'
| 3 | ||||||||||||||||||||
0.267 | SHOW FULL COLUMNS FROM `color`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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 = 'color'
| 0 | ||||||||||||||||||||
0.277 | SHOW FULL COLUMNS FROM `contest`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
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'
| 0 | ||||||||||||||||||||
0.270 | SHOW FULL COLUMNS FROM `contest_answer`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
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 = 'contest_answer'
| 1 | ||||||||||||||||||||
0.262 | SHOW FULL COLUMNS FROM `contest_answer_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'contest_answer_item'
| 2 | ||||||||||||||||||||
0.270 | SHOW FULL COLUMNS FROM `contest_answer_value`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
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 = 'contest_answer_value'
| 2 | ||||||||||||||||||||
0.289 | SHOW FULL COLUMNS FROM `contest_question`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 6 | ||||||||||||||||||||
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 = 'contest_question'
| 2 | ||||||||||||||||||||
0.284 | SHOW FULL COLUMNS FROM `contest_question_item`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
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 = 'contest_question_item'
| 1 | ||||||||||||||||||||
0.612 | SHOW FULL COLUMNS FROM `contest_question_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.198 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest_question_type'
| 0 | ||||||||||||||||||||
0.382 | SHOW FULL COLUMNS FROM `country`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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 = 'country'
| 0 | ||||||||||||||||||||
0.343 | SHOW FULL COLUMNS FROM `error`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
0.316 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.294 | SHOW FULL COLUMNS FROM `error_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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 = 'error_type'
| 0 | ||||||||||||||||||||
0.325 | SHOW FULL COLUMNS FROM `export_subscriber`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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 = 'export_subscriber'
| 0 | ||||||||||||||||||||
0.323 | SHOW FULL COLUMNS FROM `facebook_ticket_competition`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 7 | ||||||||||||||||||||
0.264 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.346 | SHOW FULL COLUMNS FROM `file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
6.751 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.390 | SHOW FULL COLUMNS FROM `file_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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_2_tag'
| 2 | ||||||||||||||||||||
0.370 | SHOW FULL COLUMNS FROM `file_source`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.214 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_source'
| 0 | ||||||||||||||||||||
0.363 | SHOW FULL COLUMNS FROM `file_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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'
| 0 | ||||||||||||||||||||
0.368 | SHOW FULL COLUMNS FROM `file_type`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'file_type'
| 0 | ||||||||||||||||||||
0.426 | SHOW FULL COLUMNS FROM `filedir`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
1.577 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.303 | SHOW FULL COLUMNS FROM `fix_match`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
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 = 'fix_match'
| 0 | ||||||||||||||||||||
0.304 | SHOW FULL COLUMNS FROM `folder`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
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 = 'folder'
| 0 | ||||||||||||||||||||
0.316 | SHOW FULL COLUMNS FROM `folder_2_stats_club`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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_stats_club'
| 2 | ||||||||||||||||||||
0.305 | SHOW FULL COLUMNS FROM `folder_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
0.196 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'folder_2_tag'
| 2 | ||||||||||||||||||||
0.311 | SHOW FULL COLUMNS FROM `gallery`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.554 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.315 | SHOW FULL COLUMNS FROM `gallery_2_file`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 9 | ||||||||||||||||||||
1.287 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.408 | SHOW FULL COLUMNS FROM `gallery_image_text`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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'
| 1 | ||||||||||||||||||||
0.357 | SHOW FULL COLUMNS FROM `gallery_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 14 | ||||||||||||||||||||
1.374 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.384 | SHOW FULL COLUMNS FROM `gallery_photo_2_stats_player`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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 = 'gallery_photo_2_stats_player'
| 2 | ||||||||||||||||||||
0.266 | SHOW FULL COLUMNS FROM `gallery_photo_2_tag`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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 = 'gallery_photo_2_tag'
| 2 | ||||||||||||||||||||
0.354 | SHOW FULL COLUMNS FROM `guess`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 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 = 'guess'
| 0 | ||||||||||||||||||||
0.276 | SHOW FULL COLUMNS FROM `guess_2_photo`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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 = 'guess_2_photo'
| 2 | ||||||||||||||||||||
0.289 | SHOW FULL COLUMNS FROM `guess_has_winner`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 2 | ||||||||||||||||||||
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 = 'guess_has_winner'
| 2 | ||||||||||||||||||||
0.307 | SHOW FULL COLUMNS FROM `guess_vote`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 10 | ||||||||||||||||||||
0.157 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_vote'
| 1 | ||||||||||||||||||||
0.285 | SHOW FULL COLUMNS FROM `import`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 4 | ||||||||||||||||||||
0.314 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'import'
| 0 | ||||||||||||||||||||
0.262 | SHOW FULL COLUMNS FROM `import_problem`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 5 | ||||||||||||||||||||
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 = 'import_problem'
| 0 | ||||||||||||||||||||
0.247 | SHOW FULL COLUMNS FROM `importer_watchdog`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 3 | ||||||||||||||||||||
0.137 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'importer_watchdog'
| 0 | ||||||||||||||||||||
0.223 | SHOW FULL COLUMNS FROM `impression_article_count`/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Club/ClubRepository.php:15 | 1 |
...and more
no identity
https://dev.nhlcz.s6.esports.cz/klub/44/statistiky?do=stats-view-sort&stats-view-direction=desc&stats-view-order=p
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 |
|
no | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
|
yes | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
Front:Club:Stats:default |
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 |
|
no | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
|
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\Club\StatsPresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/Front/Club/presenters/StatsPresenter.php:8