Time ms | SQL Query | Rows |
---|
0.082 | SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchRepository.php:17 | 0 |
2.146 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` `competition`, `extra_time`.`code`
`extra_time_code`, `contumacy`.`code` `contumacy_code`, `phase`.`name` `phase_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season`, `sheet_state`.`name` `sheetStateName`,
`team_home_logo`.`path` `team_home_logo`, `team_guest_logo`.`path` `team_guest_logo`,
`team_home_name`.`name` `team_home_name`, `team_guest_name`.`name` `team_guest_name`,
`club_home`.`shortcut` AS `shortcut_home`, `club_guest`.`shortcut` AS `shortcut_guest`,
`club_home`.`nickname` AS `nickname_home`, `club_guest`.`nickname` AS `nickname_guest`,
`club_home_name`.`name` `club_home_name`, `club_guest_name`.`name` `club_guest_name`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_home` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_home_id` = `team_home`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_guest` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_guest_id` = `team_guest`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_home_name` ON `team_home`.`id` =
`team_home_name`.`stats_team_id` AND (`team_home_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `team_home_name`.`stats_team_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_guest_name` ON `team_guest`.`id`
= `team_guest_name`.`stats_team_id` AND (`team_guest_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `team_guest_name`.`stats_team_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_home` ON `team_home`.`stats_club_id`
= `club_home`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_home_logo` ON `club_home`.`id` =
`team_home_logo`.`stats_club_id` AND (`team_home_logo`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable`
WHERE `nameTable`.`stats_club_id` = `team_home_logo`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_guest` ON
`team_guest`.`stats_club_id` = `club_guest`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_guest_logo` ON `club_guest`.`id`
= `team_guest_logo`.`stats_club_id` AND (`team_guest_logo`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable`
WHERE `nameTable`.`stats_club_id` = `team_guest_logo`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` AS `club_home_name` ON `club_home`.`id` =
`club_home_name`.`stats_club_id` AND (`club_home_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable`
WHERE `nameTable`.`stats_club_id` = `club_home_name`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` AS `club_guest_name` ON `club_guest`.`id`
= `club_guest_name`.`stats_club_id` AND (`club_guest_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable`
WHERE `nameTable`.`stats_club_id` = `club_guest_name`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_extra_time` AS `extra_time` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`extra_time` = `extra_time`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_contumacy` AS `contumacy` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`contumacy` = `contumacy`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_phase` AS `phase` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`phase` = `phase`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_sheet_state` AS `sheet_state` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`sheet_state` = `sheet_state`.`code`
WHERE (`team_home`.`id` IS NOT NULL) AND (`team_guest`.`id` IS NOT NULL) AND (`team_home_name`.`id`
IS NOT NULL) AND (`team_guest_name`.`id` IS NOT NULL) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908765')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | stats_match | const | PRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2 | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_home | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_guest | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | club_home | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_home_name | ref | PRIMARY,stats_team_id | stats_team_id | 5 | const | 1 | Using where | 1 | PRIMARY | team_guest_name | ref | PRIMARY,stats_team_id | stats_team_id | 5 | const | 1 | Using where | 1 | PRIMARY | team_home_logo | ref | stats_club_id | stats_club_id | 5 | const | 10 | | 1 | PRIMARY | club_guest | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_guest_logo | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest.id | 1 | | 1 | PRIMARY | club_home_name | ref | stats_club_id | stats_club_id | 5 | const | 10 | | 1 | PRIMARY | club_guest_name | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest.id | 1 | | 1 | PRIMARY | stats_competition | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | extra_time | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | contumacy | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | phase | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | sheet_state | eq_ref | PRIMARY | PRIMARY | 767 | const | 1 | | 7 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest_name.stats_club_id | 1 | Using where; Using filesort | 6 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_home_name.stats_club_id | 1 | Using where; Using filesort | 5 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.team_guest_logo.stats_club_id | 1 | Using where; Using filesort | 4 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.team_home_logo.stats_club_id | 1 | Using where; Using filesort | 3 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team_guest_name.stats_team_id | 1 | Using where; Using filesort | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team_home_name.stats_team_id | 1 | Using where; Using filesort | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/BasePresenter.php:29 | 1 |
0.253 explain | SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname`
FROM `post`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id`
WHERE (`post`.`id` IS NULL)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | | | | | | | | Impossible WHERE | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69 | 0 |
0.338 explain | SELECT `id`, `league_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition`
WHERE (`id` IN (7071))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/OverviewPresenter.php:71 | 1 |
0.157 explain | SELECT `id`, `code`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_league`
WHERE (`id` IN (3))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_league | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/OverviewPresenter.php:71 | 1 |
0.530 explain | SELECT `id`, `name`, `surname`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = 13592)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33 | 1 |
0.206 explain | SELECT `id`, `name`, `surname`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = 5790686)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33 | 1 |
0.185 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` `competition`, `extra_time`.`code`
`extra_time_code`, `contumacy`.`code` `contumacy_code`, `phase`.`name` `phase_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season`, `sheet_state`.`name` `sheetStateName`,
`team_home_logo`.`path` `team_home_logo`, `team_guest_logo`.`path` `team_guest_logo`,
`team_home_name`.`name` `team_home_name`, `team_guest_name`.`name` `team_guest_name`,
`club_home`.`shortcut` AS `shortcut_home`, `club_guest`.`shortcut` AS `shortcut_guest`,
`club_home`.`nickname` AS `nickname_home`, `club_guest`.`nickname` AS `nickname_guest`,
`club_home_name`.`name` `club_home_name`, `club_guest_name`.`name` `club_guest_name`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_home` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_home_id` = `team_home`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_guest` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_guest_id` = `team_guest`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_home_name` ON `team_home`.`id` =
`team_home_name`.`stats_team_id` AND (`team_home_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `team_home_name`.`stats_team_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_guest_name` ON `team_guest`.`id`
= `team_guest_name`.`stats_team_id` AND (`team_guest_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `team_guest_name`.`stats_team_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_home` ON `team_home`.`stats_club_id`
= `club_home`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_home_logo` ON `club_home`.`id` =
`team_home_logo`.`stats_club_id` AND (`team_home_logo`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable`
WHERE `nameTable`.`stats_club_id` = `team_home_logo`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_guest` ON
`team_guest`.`stats_club_id` = `club_guest`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_guest_logo` ON `club_guest`.`id`
= `team_guest_logo`.`stats_club_id` AND (`team_guest_logo`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable`
WHERE `nameTable`.`stats_club_id` = `team_guest_logo`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` AS `club_home_name` ON `club_home`.`id` =
`club_home_name`.`stats_club_id` AND (`club_home_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable`
WHERE `nameTable`.`stats_club_id` = `club_home_name`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` AS `club_guest_name` ON `club_guest`.`id`
= `club_guest_name`.`stats_club_id` AND (`club_guest_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable`
WHERE `nameTable`.`stats_club_id` = `club_guest_name`.`stats_club_id`
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_extra_time` AS `extra_time` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`extra_time` = `extra_time`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_contumacy` AS `contumacy` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`contumacy` = `contumacy`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_phase` AS `phase` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`phase` = `phase`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_sheet_state` AS `sheet_state` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`sheet_state` = `sheet_state`.`code`
WHERE (`team_home`.`id` IS NOT NULL) AND (`team_guest`.`id` IS NOT NULL) AND (`team_home_name`.`id`
IS NOT NULL) AND (`team_guest_name`.`id` IS NOT NULL) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908765')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | stats_match | const | PRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2 | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_home | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_guest | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | club_home | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_home_name | ref | PRIMARY,stats_team_id | stats_team_id | 5 | const | 1 | Using where | 1 | PRIMARY | team_guest_name | ref | PRIMARY,stats_team_id | stats_team_id | 5 | const | 1 | Using where | 1 | PRIMARY | team_home_logo | ref | stats_club_id | stats_club_id | 5 | const | 10 | | 1 | PRIMARY | club_guest | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | team_guest_logo | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest.id | 1 | | 1 | PRIMARY | club_home_name | ref | stats_club_id | stats_club_id | 5 | const | 10 | | 1 | PRIMARY | club_guest_name | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest.id | 1 | | 1 | PRIMARY | stats_competition | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | extra_time | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | contumacy | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | phase | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | PRIMARY | sheet_state | eq_ref | PRIMARY | PRIMARY | 767 | const | 1 | | 7 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_guest_name.stats_club_id | 1 | Using where; Using filesort | 6 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club_home_name.stats_club_id | 1 | Using where; Using filesort | 5 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.team_guest_logo.stats_club_id | 1 | Using where; Using filesort | 4 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.team_home_logo.stats_club_id | 1 | Using where; Using filesort | 3 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team_guest_name.stats_team_id | 1 | Using where; Using filesort | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team_home_name.stats_team_id | 1 | Using where; Using filesort | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:31 | 1 |
0.201 explain | SELECT `id`, `stats_club_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team`
WHERE (`id` IN (18))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_team | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34 | 1 |
0.127 explain | SELECT `id`, `nickname`, `shortcut`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club`
WHERE (`id` IN (18))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_club | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34 | 1 |
0.108 explain | SELECT `id`, `stats_club_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team`
WHERE (`id` IN (22))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_team | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35 | 1 |
0.103 explain | SELECT `id`, `nickname`, `shortcut`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club`
WHERE (`id` IN (22))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_club | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35 | 1 |
0.041 explain | SELECT `id`, `league_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition`
WHERE (`id` IN (7071))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:45 | 1 |
0.036 explain | SELECT `id`, `code`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_league`
WHERE (`id` IN (3))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_league | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:45 | 1 |
0.870 explain | SELECT `id`, `period`, `score_home`, `score_guest`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period`
WHERE (`stats_match_id` = '2908765')
ORDER BY `period`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match_period | ref | stats_match_id_period | stats_match_id_period | 4 | const | 4 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/PeriodHelper.php:70 | 4 |
0.204 explain | SELECT `id`, `onlajny_id`, `post_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908765')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30 | 1 |
0.239 explain | SELECT `id`
FROM `available_video`
WHERE (`stats_match_id` = '2908765') AND (`type` = 'match')
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | available_video | ref | stats_match_id,type,stats_match_id_type | stats_match_id | 4 | const | 1 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Video/VideoService.php:109 | 0 |
0.179 explain | SELECT `id`
FROM `available_video`
WHERE (`stats_match_id` = '2908765') AND (`type` = 'cut')
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | available_video | ref | stats_match_id,type,stats_match_id_type | stats_match_id | 4 | const | 1 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Video/VideoService.php:109 | 0 |
2.335 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id`
WHERE (`stats_match_id` = 2908765) AND (`shootout` IS NULL OR `shootout` = 0) AND (`time` BETWEEN 1
AND 1200)
ORDER BY `time`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | scorer | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.scorer.country_id | 1 | | 1 | SIMPLE | assistant_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id | 1 | | 1 | SIMPLE | country_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id | 1 | | 1 | SIMPLE | assistant_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id | 1 | | 1 | SIMPLE | country_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id | 1 | | 1 | SIMPLE | player_positive1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id | 1 | | 1 | SIMPLE | player_positive2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id | 1 | | 1 | SIMPLE | player_positive3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id | 1 | | 1 | SIMPLE | player_positive4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id | 1 | | 1 | SIMPLE | player_positive5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id | 1 | | 1 | SIMPLE | player_positive_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id | 1 | | 1 | SIMPLE | player_negative1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id | 1 | | 1 | SIMPLE | player_negative2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id | 1 | | 1 | SIMPLE | player_negative3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id | 1 | | 1 | SIMPLE | player_negative4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id | 1 | | 1 | SIMPLE | player_negative5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id | 1 | | 1 | SIMPLE | player_negative_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595 | 3 |
1.328 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.*, `club`.`shortcut` AS `team`,
`player`.`name`, `player`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
WHERE (`stats_match_id` = 2908765) AND (`from` BETWEEN 1 AND 1200)
ORDER BY `from`, `to`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | ref | fk_stats_penalty_stats_match1 | fk_stats_penalty_stats_match1 | 5 | const | 12 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | player | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.player.country_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177 | 4 |
0.859 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id`
WHERE (`stats_match_id` = 2908765) AND (`shooting` = 1) AND (`shootout` IS NULL OR `shootout` = 0)
AND (`time` BETWEEN 1 AND 1200)
ORDER BY `time`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | scorer | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.scorer.country_id | 1 | | 1 | SIMPLE | assistant_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id | 1 | | 1 | SIMPLE | country_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id | 1 | | 1 | SIMPLE | assistant_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id | 1 | | 1 | SIMPLE | country_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id | 1 | | 1 | SIMPLE | player_positive1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id | 1 | | 1 | SIMPLE | player_positive2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id | 1 | | 1 | SIMPLE | player_positive3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id | 1 | | 1 | SIMPLE | player_positive4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id | 1 | | 1 | SIMPLE | player_positive5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id | 1 | | 1 | SIMPLE | player_positive_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id | 1 | | 1 | SIMPLE | player_negative1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id | 1 | | 1 | SIMPLE | player_negative2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id | 1 | | 1 | SIMPLE | player_negative3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id | 1 | | 1 | SIMPLE | player_negative4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id | 1 | | 1 | SIMPLE | player_negative5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id | 1 | | 1 | SIMPLE | player_negative_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595 | 0 |
1.524 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id`
WHERE (`stats_match_id` = 2908765) AND (`shootout` IS NULL OR `shootout` = 0) AND (`time` BETWEEN
1201 AND 2400)
ORDER BY `time`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | scorer | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.scorer.country_id | 1 | | 1 | SIMPLE | assistant_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id | 1 | | 1 | SIMPLE | country_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id | 1 | | 1 | SIMPLE | assistant_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id | 1 | | 1 | SIMPLE | country_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id | 1 | | 1 | SIMPLE | player_positive1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id | 1 | | 1 | SIMPLE | player_positive2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id | 1 | | 1 | SIMPLE | player_positive3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id | 1 | | 1 | SIMPLE | player_positive4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id | 1 | | 1 | SIMPLE | player_positive5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id | 1 | | 1 | SIMPLE | player_positive_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id | 1 | | 1 | SIMPLE | player_negative1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id | 1 | | 1 | SIMPLE | player_negative2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id | 1 | | 1 | SIMPLE | player_negative3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id | 1 | | 1 | SIMPLE | player_negative4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id | 1 | | 1 | SIMPLE | player_negative5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id | 1 | | 1 | SIMPLE | player_negative_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595 | 4 |
0.447 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.*, `club`.`shortcut` AS `team`,
`player`.`name`, `player`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
WHERE (`stats_match_id` = 2908765) AND (`from` BETWEEN 1201 AND 2400)
ORDER BY `from`, `to`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | ref | fk_stats_penalty_stats_match1 | fk_stats_penalty_stats_match1 | 5 | const | 12 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | player | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.player.country_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177 | 6 |
0.921 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id`
WHERE (`stats_match_id` = 2908765) AND (`shooting` = 1) AND (`shootout` IS NULL OR `shootout` = 0)
AND (`time` BETWEEN 1201 AND 2400)
ORDER BY `time`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | scorer | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.scorer.country_id | 1 | | 1 | SIMPLE | assistant_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id | 1 | | 1 | SIMPLE | country_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id | 1 | | 1 | SIMPLE | assistant_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id | 1 | | 1 | SIMPLE | country_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id | 1 | | 1 | SIMPLE | player_positive1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id | 1 | | 1 | SIMPLE | player_positive2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id | 1 | | 1 | SIMPLE | player_positive3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id | 1 | | 1 | SIMPLE | player_positive4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id | 1 | | 1 | SIMPLE | player_positive5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id | 1 | | 1 | SIMPLE | player_positive_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id | 1 | | 1 | SIMPLE | player_negative1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id | 1 | | 1 | SIMPLE | player_negative2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id | 1 | | 1 | SIMPLE | player_negative3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id | 1 | | 1 | SIMPLE | player_negative4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id | 1 | | 1 | SIMPLE | player_negative5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id | 1 | | 1 | SIMPLE | player_negative_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595 | 0 |
0.712 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id`
WHERE (`stats_match_id` = 2908765) AND (`shootout` IS NULL OR `shootout` = 0) AND (`time` BETWEEN
2401 AND 3600)
ORDER BY `time`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | scorer | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.scorer.country_id | 1 | | 1 | SIMPLE | assistant_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id | 1 | | 1 | SIMPLE | country_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id | 1 | | 1 | SIMPLE | assistant_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id | 1 | | 1 | SIMPLE | country_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id | 1 | | 1 | SIMPLE | player_positive1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id | 1 | | 1 | SIMPLE | player_positive2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id | 1 | | 1 | SIMPLE | player_positive3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id | 1 | | 1 | SIMPLE | player_positive4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id | 1 | | 1 | SIMPLE | player_positive5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id | 1 | | 1 | SIMPLE | player_positive_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id | 1 | | 1 | SIMPLE | player_negative1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id | 1 | | 1 | SIMPLE | player_negative2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id | 1 | | 1 | SIMPLE | player_negative3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id | 1 | | 1 | SIMPLE | player_negative4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id | 1 | | 1 | SIMPLE | player_negative5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id | 1 | | 1 | SIMPLE | player_negative_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595 | 0 |
0.328 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.*, `club`.`shortcut` AS `team`,
`player`.`name`, `player`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
WHERE (`stats_match_id` = 2908765) AND (`from` BETWEEN 2401 AND 3600)
ORDER BY `from`, `to`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | ref | fk_stats_penalty_stats_match1 | fk_stats_penalty_stats_match1 | 5 | const | 12 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | player | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.player.country_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177 | 2 |
0.635 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id`
WHERE (`stats_match_id` = 2908765) AND (`shooting` = 1) AND (`shootout` IS NULL OR `shootout` = 0)
AND (`time` BETWEEN 2401 AND 3600)
ORDER BY `time`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where; Using filesort | 1 | SIMPLE | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id | 1 | | 1 | SIMPLE | club | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.team.stats_club_id | 1 | | 1 | SIMPLE | scorer | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.scorer.country_id | 1 | | 1 | SIMPLE | assistant_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id | 1 | | 1 | SIMPLE | country_primary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id | 1 | | 1 | SIMPLE | assistant_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id | 1 | | 1 | SIMPLE | country_secondary | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id | 1 | | 1 | SIMPLE | player_positive1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id | 1 | | 1 | SIMPLE | player_positive2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id | 1 | | 1 | SIMPLE | player_positive3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id | 1 | | 1 | SIMPLE | player_positive4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id | 1 | | 1 | SIMPLE | player_positive5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id | 1 | | 1 | SIMPLE | player_positive_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id | 1 | | 1 | SIMPLE | player_negative1 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id | 1 | | 1 | SIMPLE | player_negative2 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id | 1 | | 1 | SIMPLE | player_negative3 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id | 1 | | 1 | SIMPLE | player_negative4 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id | 1 | | 1 | SIMPLE | player_negative5 | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id | 1 | | 1 | SIMPLE | player_negative_goalkeeper | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595 | 0 |
0.160 explain | SELECT `id`, `stats_competition_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908765')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30 | 1 |
0.176 explain | SELECT `id`, `stats_player_scorer_id`, `stats_player_assistant_primary_id`,
`stats_player_assistant_secondary_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = '2908765')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:58 | 7 |
0.150 explain | SELECT `id`, `datetime`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908765')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30 | 1 |
0.144 explain | SELECT `id`, `virtual`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7071)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionService.php:368 | 1 |
0.200 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_previous_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_previous_competition`.`stats_previous_competition_id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_previous_competition`.`stats_competition_id` = 7071)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_previous_competition | ref | fk_stats_previous_competition_stats_competition1,fk_stats_previous_competition_stats_competition2 | fk_stats_previous_competition_stats_competition1 | 5 | const | 1 | Using where | 1 | SIMPLE | stats_competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_previous_competition.stats_previous_competition_id | 1 | Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionService.php:374 | 0 |
0.138 explain | SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition`
WHERE (`id` IN (7071))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_competition | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchPlayer/MatchPlayerFacade.php:64 | 1 |
53.631 explain | SELECT `stats_player_id`, SUM(`goals`) `goal`, SUM(`assistances`) `assistance`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` IN (7071)) AND
(`stats_player_id` IN (13592, 10097779, 54066, 15225, 17397, 10099575, 5790686, 19881, 17303,
5790686, 9904, 19881, 17303, 14193, 17303, 14491, 12321, 5790686, 18089, 9904)) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` < '2023-12-03 15:00:00')
GROUP BY `stats_player_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | ref | PRIMARY,datumcas,fk_stats_match_stats_competition1 | fk_stats_match_stats_competition1 | 5 | const | 364 | Using where; Using temporary; Using filesort | 1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | test_dev_nhlcz_s6_esports_cz.stats_match.id | 10 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:94 | 14 |
0.173 explain | SELECT `stats_team_home_id` AS `team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454 | 1 |
4.978 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 18) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765) AND
(`player`.`position` != 'GK')
ORDER BY `position`, `player`.`surname`, `jersey`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where; Using temporary; Using filesort | 1 | SIMPLE | player | eq_ref | PRIMARY,post | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id | 1 | Using where | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.player.country_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499 | 19 |
1.320 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`jersey`,
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id`, `gk`.`saves`,
`gk`.`lost_goals`, `gk`.`minutes_played`, `gk`.`time_on_ice`, `gk`.`saves` + `gk`.`lost_goals` AS
`shots_against`, `attended`, `penalties`, `assistances`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 18) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765) AND
(`player`.`position` = 'GK')
ORDER BY `gk`.`order` IS NULL, `gk`.`order`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where; Using temporary; Using filesort | 1 | SIMPLE | player | eq_ref | PRIMARY,post | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id | 1 | Using where | 1 | SIMPLE | gk | ref | stats_player_2_match_id | stats_player_2_match_id | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.player.country_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499 | 2 |
0.183 explain | SELECT `stats_team_guest_id` AS `team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454 | 1 |
1.017 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765) AND
(`player`.`position` != 'GK')
ORDER BY `position`, `player`.`surname`, `jersey`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where; Using temporary; Using filesort | 1 | SIMPLE | player | eq_ref | PRIMARY,post | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id | 1 | Using where | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.player.country_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499 | 19 |
0.804 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`jersey`,
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id`, `gk`.`saves`,
`gk`.`lost_goals`, `gk`.`minutes_played`, `gk`.`time_on_ice`, `gk`.`saves` + `gk`.`lost_goals` AS
`shots_against`, `attended`, `penalties`, `assistances`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765) AND
(`player`.`position` = 'GK')
ORDER BY `gk`.`order` IS NULL, `gk`.`order`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where; Using temporary; Using filesort | 1 | SIMPLE | player | eq_ref | PRIMARY,post | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id | 1 | Using where | 1 | SIMPLE | gk | ref | stats_player_2_match_id | stats_player_2_match_id | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id | 1 | | 1 | SIMPLE | country | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.player.country_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499 | 2 |
0.348 explain | SELECT IF(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stadium_capacity`,
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stadium_capacity`, `club`.`capacity`) AS `capacity`,
`visitors`, `club`.`stadium_name` AS `stadium`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_home` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_home_id` = `team_home`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team_home`.`stats_club_id` =
`club`.`id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | SIMPLE | team_home | const | PRIMARY | PRIMARY | 4 | const | 1 | | 1 | SIMPLE | club | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:251 | 1 |
0.130 explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee`
WHERE (`id` IN (38666))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_referee | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467 | 1 |
0.118 explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee`
WHERE (`id` IN (38497))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_referee | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467 | 1 |
0.222 explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee`
WHERE (`id` IN (38506))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_referee | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467 | 1 |
0.149 explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee`
WHERE (`id` IN (38531))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_referee | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467 | 1 |
0.067 explain | SELECT `stats_team_home_id` AS `team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454 | 1 |
0.540 explain | SELECT SUM(`gk`.`saves`) AS `saves`, SUM(`gk`.`lost_goals`) AS `lost`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 18) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765) AND
(`player`.`position` = 'GK')
GROUP BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where | 1 | SIMPLE | player | eq_ref | PRIMARY,post | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id | 1 | Using where | 1 | SIMPLE | gk | ref | stats_player_2_match_id | stats_player_2_match_id | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:310 | 1 |
5.205 explain | SELECT SUM(`length`) AS `length`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908765) AND (`stats_team_id` = 18)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | index_merge | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1,stats_team_id | 5,4 | | 1 | Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348 | 1 |
2.146 explain | SELECT COUNT(*) AS `penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908765) AND (`stats_team_id` = 18) AND (`length` = 2)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | index_merge | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1,stats_team_id | 5,4 | | 1 | Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368 | 1 |
2.168 explain | SELECT COUNT(*) AS `penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908765) AND (`stats_team_id` = 18) AND (`length` != 2)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | index_merge | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1,stats_team_id | 5,4 | | 1 | Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388 | 1 |
0.406 explain | SELECT SUM(`hits`) AS `hits`, SUM(`faceoffs`) AS `faceoffs`, SUM(`faceoffs_won`) AS `faceoffs_won`,
SUM(`blocks`) AS `blocks`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 18) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1 | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:324 | 1 |
0.180 explain | SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where; Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398 | 7 |
2.731 explain | SELECT *
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = 2908765) AND (`stats_team_id` = 18) AND (`shooting` IS NULL OR `shooting`
= 0) AND (`shootout` IS NULL OR `shootout` = 0)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | index_merge | fk_stats_goal_stats_match1,stats_team_id | fk_stats_goal_stats_match1,stats_team_id | 5,4 | | 1 | Using intersect(fk_stats_goal_stats_match1,stats_team_id); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411 | 1 |
0.042 explain | SELECT `stats_team_guest_id` AS `team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454 | 1 |
0.465 explain | SELECT SUM(`gk`.`saves`) AS `saves`, SUM(`gk`.`lost_goals`) AS `lost`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765) AND
(`player`.`position` = 'GK')
GROUP BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where | 1 | SIMPLE | player | eq_ref | PRIMARY,post | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id | 1 | Using where | 1 | SIMPLE | gk | ref | stats_player_2_match_id | stats_player_2_match_id | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:310 | 1 |
2.525 explain | SELECT SUM(`length`) AS `length`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908765) AND (`stats_team_id` = 22)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | index_merge | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1,stats_team_id | 5,4 | | 1 | Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348 | 1 |
1.872 explain | SELECT COUNT(*) AS `penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908765) AND (`stats_team_id` = 22) AND (`length` = 2)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | index_merge | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1,stats_team_id | 5,4 | | 1 | Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368 | 1 |
1.809 explain | SELECT COUNT(*) AS `penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908765) AND (`stats_team_id` = 22) AND (`length` != 2)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_penalty | index_merge | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1,stats_team_id | 5,4 | | 1 | Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388 | 1 |
0.403 explain | SELECT SUM(`hits`) AS `hits`, SUM(`faceoffs`) AS `faceoffs`, SUM(`faceoffs_won`) AS `faceoffs_won`,
SUM(`blocks`) AS `blocks`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1 | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:324 | 1 |
0.040 explain | SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | ref | fk_stats_goal_stats_match1 | fk_stats_goal_stats_match1 | 5 | const | 7 | Using where; Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398 | 7 |
1.173 explain | SELECT *
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = 2908765) AND (`stats_team_id` = 22) AND (`shooting` IS NULL OR `shooting`
= 0) AND (`shootout` IS NULL OR `shootout` = 0)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goal | index_merge | fk_stats_goal_stats_match1,stats_team_id | fk_stats_goal_stats_match1,stats_team_id | 5,4 | | 1 | Using intersect(fk_stats_goal_stats_match1,stats_team_id); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411 | 6 |
0.435 explain | SELECT MAX(`period`) AS `max`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period`
WHERE (`stats_match_id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goalkeeper_2_match_period | ref | stats_match_id_stats_player_id_period | stats_match_id_stats_player_id_period | 4 | const | 12 | Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:79 | 1 |
0.061 explain | SELECT `stats_team_home_id` AS `team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454 | 1 |
0.409 explain | SELECT `stats_player_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 18) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765) AND
(`player`.`position` = 'GK')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where | 1 | SIMPLE | player | eq_ref | PRIMARY,post | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id | 1 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:155 | 2 |
1.504 explain | SELECT SUM(`saves`) AS `saves`, `period`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period`
WHERE (`stats_match_id` = 2908765) AND (`stats_player_id` IN (10078861, 3331756)) AND (`period` > 0)
GROUP BY `period`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goalkeeper_2_match_period | range | stats_match_id_stats_player_id_period,stats_player_id | stats_match_id_stats_player_id_period | 12 | | 6 | Using where; Using temporary; Using filesort | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142 | 3 |
0.068 explain | SELECT `stats_team_guest_id` AS `team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match | const | PRIMARY | PRIMARY | 4 | const | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454 | 1 |
0.412 explain | SELECT `stats_player_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908765) AND
(`player`.`position` = 'GK')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | ref | stats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attended | fk_stats_player_2_match_stats_match1 | 4 | const | 42 | Using where | 1 | SIMPLE | player | eq_ref | PRIMARY,post | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id | 1 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:155 | 2 |
0.350 explain | SELECT SUM(`saves`) AS `saves`, `period`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period`
WHERE (`stats_match_id` = 2908765) AND (`stats_player_id` IN (15242, 10093587)) AND (`period` > 0)
GROUP BY `period`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_goalkeeper_2_match_period | range | stats_match_id_stats_player_id_period,stats_player_id | stats_match_id_stats_player_id_period | 12 | | 4 | Using where; Using temporary; Using filesort | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142 | 3 |
0.197 explain | SELECT `id`, `period`, `score_guest`, `score_home`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period`
WHERE (`stats_match_id` = 2908765)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_match_period | ref | stats_match_id_period | stats_match_id_period | 4 | const | 4 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:93 | 4 |