Time ms | SQL Query | Rows |
---|
0.104 | SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchRepository.php:17 | 0 |
2.151 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` = '2908609')
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.289 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.296 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.168 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.155 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` = 18089)
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.138 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` = 14203)
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.481 explain | SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode`
FROM `zone`
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id`
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id`
WHERE (`zone_template`.`code` = 'default')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zone_template | ref | PRIMARY,code | code | 302 | const | 1 | Using where; Using index | 1 | SIMPLE | zone | ref | zone_template_id_zone_position_id,zone_template_id | zone_template_id_zone_position_id | 4 | test_dev_nhlcz_s6_esports_cz.zone_template.id | 17 | | 1 | SIMPLE | zone_position | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.zone.zone_position_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:182 | 27 |
0.615 explain | SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode`
FROM `zone`
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id`
LEFT JOIN `zone_template_2_stats_league` ON `zone_template`.`id` =
`zone_template_2_stats_league`.`zone_template_id`
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id`
WHERE (`zone_template`.`code` = 'league') AND (`zone_template_2_stats_league`.`stats_league_id` = 3)
GROUP BY `zone_position`.`id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zone_template_2_stats_league | ref | PRIMARY,stats_league_id | stats_league_id | 4 | const | 1 | Using where; Using index; Using temporary; Using filesort | 1 | SIMPLE | zone_template | eq_ref | PRIMARY,code | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.zone_template_2_stats_league.zone_template_id | 1 | Using where | 1 | SIMPLE | zone | ref | zone_template_id_zone_position_id,zone_template_id | zone_template_id_zone_position_id | 4 | test_dev_nhlcz_s6_esports_cz.zone_template_2_stats_league.zone_template_id | 17 | | 1 | SIMPLE | zone_position | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.zone.zone_position_id | 1 | | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:185 | 0 |
0.204 explain | SELECT `id`, `code`
FROM `zone_position`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zone_position | index | | code | 302 | | 27 | Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:210 | 27 |
41.617 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.*
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`match_bet` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id`
WHERE (DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) = CURDATE()) AND
(`league`.`code` = 'nhl') AND (`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` IS NOT
NULL)
LIMIT 100
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | league | const | PRIMARY,code | code | 768 | const | 1 | Using index | 1 | SIMPLE | competition | ref | PRIMARY,league_id | league_id | 5 | const | 273 | Using where; Using index | 1 | SIMPLE | stats_match | ref | PRIMARY,fk_stats_match_stats_competition1 | fk_stats_match_stats_competition1 | 5 | test_dev_nhlcz_s6_esports_cz.competition.id | 21 | Using where | 1 | SIMPLE | match_bet | ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_match.id | 1 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/presenters/BasePresenter.php:112 | 0 |
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` = '2908609')
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.257 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:34 | 1 |
0.167 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:34 | 1 |
0.145 explain | SELECT `id`, `stats_club_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team`
WHERE (`id` IN (823))
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.154 explain | SELECT `id`, `nickname`, `shortcut`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club`
WHERE (`id` IN (823))
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.046 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.048 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 |
1.202 explain | SELECT `id`, `period`, `score_home`, `score_guest`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period`
WHERE (`stats_match_id` = '2908609')
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.411 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` = '2908609')
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.262 explain | SELECT `id`
FROM `available_video`
WHERE (`stats_match_id` = '2908609') 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.217 explain | SELECT `id`
FROM `available_video`
WHERE (`stats_match_id` = '2908609') 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.699 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` = 2908609) 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 | 5 | 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 | 2 |
1.026 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` = 2908609) 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 | 7 | 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 | 1 |
1.198 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` = 2908609) 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 | 5 | 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.719 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` = 2908609) 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 | 5 | 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 | 1 |
0.543 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` = 2908609) 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 | 7 | 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 |
1.163 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` = 2908609) 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 | 5 | 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.309 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` = 2908609) 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 | 5 | 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 | 2 |
9.333 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` = 2908609) 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 | 7 | 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 |
1.302 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` = 2908609) 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 | 5 | 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.155 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` = '2908609')
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.169 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` = '2908609')
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 | 5 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:58 | 5 |
0.149 explain | SELECT `id`, `datetime`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908609')
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.151 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.185 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.207 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 |
21.094 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 (19881, 18089, 10099575, 18089, 19881, 17303, 14203, 15634, 10096404, 13667,
10083186, 14203)) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` < '2023-09-22
18: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 | 9 |
0.261 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` = 2908609)
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.750 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` = 2908609) 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.020 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` = 2908609) 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.159 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` = 2908609)
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 |
9.074 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` = 823) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908609) 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 | index_merge | 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,fk_stats_player_2_match_stats_team1 | 4,4 | | 1 | Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); 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 |
4.000 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` = 823) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908609) 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 | index_merge | 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,fk_stats_player_2_match_stats_team1 | 4,4 | | 1 | Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); 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.469 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` = 2908609)
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 |
1.105 explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee`
WHERE (`id` IN (38573))
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.142 explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee`
WHERE (`id` IN (38537))
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.128 explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee`
WHERE (`id` IN (38648))
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.465 explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee`
WHERE (`id` IN (965))
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.044 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` = 2908609)
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.713 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` = 2908609) 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 |
3.188 explain | SELECT SUM(`length`) AS `length`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908609) 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 | ref | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1 | 5 | const | 7 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348 | 1 |
0.209 explain | SELECT COUNT(*) AS `penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908609) 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 | ref | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1 | 5 | const | 7 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368 | 1 |
0.187 explain | SELECT COUNT(*) AS `penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908609) 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 | ref | fk_stats_penalty_stats_match1,stats_team_id | fk_stats_penalty_stats_match1 | 5 | const | 7 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388 | 0 |
0.367 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` = 2908609)
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.166 explain | SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = 2908609)
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 | 5 | Using where; Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398 | 5 |
1.635 explain | SELECT *
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = 2908609) 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 | ref | fk_stats_goal_stats_match1,stats_team_id | fk_stats_goal_stats_match1 | 5 | const | 5 | Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411 | 2 |
0.047 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` = 2908609)
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.050 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` = 823) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908609) 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 | index_merge | 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,fk_stats_player_2_match_stats_team1 | 4,4 | | 1 | Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); 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.650 explain | SELECT SUM(`length`) AS `length`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908609) AND (`stats_team_id` = 823)
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.160 explain | SELECT COUNT(*) AS `penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908609) AND (`stats_team_id` = 823) 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.109 explain | SELECT COUNT(*) AS `penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`
WHERE (`stats_match_id` = 2908609) AND (`stats_team_id` = 823) 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 | 0 |
10.179 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` = 823) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908609)
GROUP BY `stats_match_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | index_merge | fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1 | fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1 | 4,4 | | 1 | Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); Using where | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:324 | 1 |
0.058 explain | SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = 2908609)
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 | 5 | Using where; Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398 | 5 |
2.631 explain | SELECT *
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal`
WHERE (`stats_match_id` = 2908609) AND (`stats_team_id` = 823) 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 | 3 |
0.609 explain | SELECT MAX(`period`) AS `max`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period`
WHERE (`stats_match_id` = 2908609)
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 | 8 | Using index | /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:79 | 1 |
0.062 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` = 2908609)
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.712 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` = 2908609) 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 |
3.134 explain | SELECT SUM(`saves`) AS `saves`, `period`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period`
WHERE (`stats_match_id` = 2908609) AND (`stats_player_id` IN (10449, 15242)) 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.066 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` = 2908609)
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 |
7.382 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` = 823) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908609) AND
(`player`.`position` = 'GK')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | stats_player_2_match | index_merge | 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,fk_stats_player_2_match_stats_team1 | 4,4 | | 1 | Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); 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.246 explain | SELECT SUM(`saves`) AS `saves`, `period`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period`
WHERE (`stats_match_id` = 2908609) AND (`stats_player_id` IN (40031, 3084138)) 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.253 explain | SELECT `id`, `period`, `score_guest`, `score_home`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period`
WHERE (`stats_match_id` = 2908609)
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 |