Time ms | SQL Query | Rows |
---|
0.090 | SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
1.805 | SHOW FULL TABLES
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 254 |
0.446 | SHOW FULL COLUMNS
FROM `adhoc_stream`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
0.236 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'adhoc_stream'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.346 | SHOW FULL COLUMNS
FROM `admin_module`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
0.218 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'admin_module'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.337 | SHOW FULL COLUMNS
FROM `available_video`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 6 |
1.610 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'available_video'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.528 | SHOW FULL COLUMNS
FROM `best_player_poll`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
0.217 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'best_player_poll'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.295 | SHOW FULL COLUMNS
FROM `best_player_poll_category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.190 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'best_player_poll_category'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.878 | SHOW FULL COLUMNS
FROM `best_player_poll_coach`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 6 |
0.178 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'best_player_poll_coach'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.277 | SHOW FULL COLUMNS
FROM `best_player_poll_coach_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.636 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'best_player_poll_coach_vote'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.277 | SHOW FULL COLUMNS
FROM `best_player_poll_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 6 |
0.165 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'best_player_poll_player'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.296 | SHOW FULL COLUMNS
FROM `best_player_poll_player_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.615 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'best_player_poll_player_vote'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.270 | SHOW FULL COLUMNS
FROM `bet_company`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.142 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bet_company'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.259 | SHOW FULL COLUMNS
FROM `bet_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.142 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bet_type'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.299 | SHOW FULL COLUMNS
FROM `category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 11 |
0.186 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'category'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.262 | SHOW FULL COLUMNS
FROM `color`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.150 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'color'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.386 | SHOW FULL COLUMNS
FROM `contest`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 6 |
0.185 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'contest'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.373 | SHOW FULL COLUMNS
FROM `contest_answer`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.196 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'contest_answer'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.346 | SHOW FULL COLUMNS
FROM `contest_answer_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.259 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'contest_answer_item'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.327 | SHOW FULL COLUMNS
FROM `contest_answer_value`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.181 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'contest_answer_value'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.326 | SHOW FULL COLUMNS
FROM `contest_question`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 6 |
0.157 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'contest_question'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.311 | SHOW FULL COLUMNS
FROM `contest_question_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
0.200 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'contest_question_item'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.371 | SHOW FULL COLUMNS
FROM `contest_question_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.144 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'contest_question_type'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.453 | SHOW FULL COLUMNS
FROM `country`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.145 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'country'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.274 | SHOW FULL COLUMNS
FROM `error`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
0.254 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'error'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.258 | SHOW FULL COLUMNS
FROM `error_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.142 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'error_type'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.295 | SHOW FULL COLUMNS
FROM `export_subscriber`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.146 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'export_subscriber'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.296 | SHOW FULL COLUMNS
FROM `facebook_ticket_competition`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 7 |
0.222 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'facebook_ticket_competition'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.290 | SHOW FULL COLUMNS
FROM `file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
3.102 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.259 | SHOW FULL COLUMNS
FROM `file_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.147 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_2_tag'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.269 | SHOW FULL COLUMNS
FROM `file_source`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.146 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_source'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.277 | SHOW FULL COLUMNS
FROM `file_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.135 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_tag'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.243 | SHOW FULL COLUMNS
FROM `file_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.141 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_type'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.328 | SHOW FULL COLUMNS
FROM `filedir`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
1.309 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'filedir'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.275 | SHOW FULL COLUMNS
FROM `fix_match`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.160 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'fix_match'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.252 | SHOW FULL COLUMNS
FROM `folder`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.147 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'folder'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.240 | SHOW FULL COLUMNS
FROM `folder_2_stats_club`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.160 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'folder_2_stats_club'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.266 | SHOW FULL COLUMNS
FROM `folder_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.165 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'folder_2_tag'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.295 | SHOW FULL COLUMNS
FROM `gallery`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.580 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'gallery'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.321 | SHOW FULL COLUMNS
FROM `gallery_2_file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 9 |
1.313 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'gallery_2_file'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.270 | SHOW FULL COLUMNS
FROM `gallery_image_text`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
0.152 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'gallery_image_text'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.315 | SHOW FULL COLUMNS
FROM `gallery_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 14 |
1.329 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'gallery_photo'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.276 | SHOW FULL COLUMNS
FROM `gallery_photo_2_stats_player`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.164 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'gallery_photo_2_stats_player'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.239 | SHOW FULL COLUMNS
FROM `gallery_photo_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.157 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'gallery_photo_2_tag'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.283 | SHOW FULL COLUMNS
FROM `guess`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
0.129 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.243 | SHOW FULL COLUMNS
FROM `guess_2_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.145 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'guess_2_photo'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.240 | SHOW FULL COLUMNS
FROM `guess_has_winner`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.153 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'guess_has_winner'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.273 | SHOW FULL COLUMNS
FROM `guess_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
0.166 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess_vote'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |
0.364 | SHOW FULL COLUMNS
FROM `import`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.314 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'import'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.395 | SHOW FULL COLUMNS
FROM `import_problem`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
0.157 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'import_problem'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.310 | SHOW FULL COLUMNS
FROM `importer_watchdog`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.139 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'importer_watchdog'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | KEY_COLUMN_USAGE | ALL | | TABLE_SCHEMA,TABLE_NAME | | | | Using where; Open_full_table; Scanned 0 databases | /var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
0.303 | SHOW FULL COLUMNS
FROM `impression_article_count`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |