Time ms | SQL Query | Rows |
---|
0.065 | SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 0 |
1.727 | SHOW FULL TABLES
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 254 |
0.368 | SHOW FULL COLUMNS
FROM `adhoc_stream`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
0.187 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.397 | SHOW FULL COLUMNS
FROM `admin_module`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
0.187 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.409 | SHOW FULL COLUMNS
FROM `available_video`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 6 |
0.931 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.309 | SHOW FULL COLUMNS
FROM `best_player_poll`
/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 =
'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.425 | 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.162 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.402 | 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.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_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.376 | 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.538 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.266 | 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.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 =
'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.267 | 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.590 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.282 | SHOW FULL COLUMNS
FROM `bet_company`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.155 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bet_company'
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.269 | 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.320 | SHOW FULL COLUMNS
FROM `category`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 11 |
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 = '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.273 | SHOW FULL COLUMNS
FROM `color`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
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 = '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.287 | SHOW FULL COLUMNS
FROM `contest`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 6 |
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 = '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.302 | SHOW FULL COLUMNS
FROM `contest_answer`
/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 =
'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.269 | SHOW FULL COLUMNS
FROM `contest_answer_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.174 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.347 | SHOW FULL COLUMNS
FROM `contest_answer_value`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.173 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.346 | SHOW FULL COLUMNS
FROM `contest_question`
/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 =
'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.295 | SHOW FULL COLUMNS
FROM `contest_question_item`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
0.166 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'contest_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.282 | SHOW FULL COLUMNS
FROM `contest_question_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.178 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.390 | SHOW FULL COLUMNS
FROM `country`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.178 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'country'
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.400 | SHOW FULL COLUMNS
FROM `error`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
0.389 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.335 | SHOW FULL COLUMNS
FROM `error_type`
/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 = '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.383 | SHOW FULL COLUMNS
FROM `export_subscriber`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 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 =
'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.393 | SHOW FULL COLUMNS
FROM `facebook_ticket_competition`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 7 |
0.349 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.400 | SHOW FULL COLUMNS
FROM `file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
5.468 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.511 | SHOW FULL COLUMNS
FROM `file_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.291 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = '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.440 | SHOW FULL COLUMNS
FROM `file_source`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.260 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.398 | SHOW FULL COLUMNS
FROM `file_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.238 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'file_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.541 | SHOW FULL COLUMNS
FROM `file_type`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.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 = '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.417 | SHOW FULL COLUMNS
FROM `filedir`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
2.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 = '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.440 | SHOW FULL COLUMNS
FROM `fix_match`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
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 = '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.398 | SHOW FULL COLUMNS
FROM `folder`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.201 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = '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.386 | 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.234 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.380 | SHOW FULL COLUMNS
FROM `folder_2_tag`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
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 =
'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.399 | SHOW FULL COLUMNS
FROM `gallery`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
0.994 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.427 | SHOW FULL COLUMNS
FROM `gallery_2_file`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 9 |
2.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 =
'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.397 | SHOW FULL COLUMNS
FROM `gallery_image_text`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
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 =
'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.431 | SHOW FULL COLUMNS
FROM `gallery_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 14 |
2.158 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.364 | 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.201 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.362 | 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.230 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.453 | SHOW FULL COLUMNS
FROM `guess`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
0.165 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'guess'
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.350 | SHOW FULL COLUMNS
FROM `guess_2_photo`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
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_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.260 | SHOW FULL COLUMNS
FROM `guess_has_winner`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 2 |
0.193 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.296 | SHOW FULL COLUMNS
FROM `guess_vote`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 10 |
0.176 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = '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.281 | SHOW FULL COLUMNS
FROM `import`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 4 |
0.288 explain | SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_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.307 | SHOW FULL COLUMNS
FROM `import_problem`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 5 |
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 =
'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.279 | SHOW FULL COLUMNS
FROM `importer_watchdog`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 3 |
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 =
'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.259 | SHOW FULL COLUMNS
FROM `impression_article_count`
/var/home/www/nhlcz.s6.esports.cz/subdomains/dev/app/model/Match/MatchRepository.php:17 | 1 |