| Time ms | SQL Query | Rows |
|---|
| 0.053 | SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17 | 0 |
0.073
explain | SELECT `id`, `name`, `surname`, `country_id`, `photo`, `date_of_birth`, `height`, `weight`,
`position`, `stick`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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 |
25.080
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.164
explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.164
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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 |
17.077
explain | SELECT `competition`.`id` AS `competition_id`, `competition`.`name`, `competition`.`league_id`,
`sea`.`name` AS `season`, `lea`.`code` AS `leagueCode`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`league_id` = `league`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `lea` ON `competition`.`league_id` =
`lea`.`id`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272')
ORDER BY .`stats_competition`.`season` DESC, IFNULL(.`league`.`rank`, 9223372036854775807),
.`stats_competition`.`priority` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1 | stats_player_id | 5 | const | 141 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | | | 1 | SIMPLE | league | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_competition.league_id | 1 | | | 1 | SIMPLE | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | | | 1 | SIMPLE | sea | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.season | 1 | | | 1 | SIMPLE | lea | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.league_id | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:59 | 1 |
3.338
explain | SELECT `id`, `stats_team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`
WHERE (`stats_player_id` = '13272') AND (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from`
< NOW()) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` > NOW() OR
UNIX_TIMESTAMP(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to`) <= 0 OR
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` IS NULL)
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_player_2_team | ref | fk_stats_player_2_team_stats_player1 | fk_stats_player_2_team_stats_player1 | 5 | const | 15 | Using where; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268 | 1 |
1.251
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`,
`club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`,
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`, `club`.`id` `clubId`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable`
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable`
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC
LIMIT 1))
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IN (769))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 1 | PRIMARY | stats_club | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index | | 1 | PRIMARY | stats_club_name | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_club.id | 1 | | | 1 | PRIMARY | club | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_club_logo | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club.id | 1 | | | 4 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id | 1 | Using where; Using filesort | | 3 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id | 1 | Using where; Using filesort | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:133 | 1 |
0.087
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.172
explain | SELECT `id`, `code`, `name`
FROM `test_dev_nhlcz_s6_esports_cz`.`country`
WHERE (`id` IN (1))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | country | const | PRIMARY | PRIMARY | 4 | const | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Player-templates-Overview-default-latte-f9f4e0ca40eb66803765d76f0f9a91f6.php:37 | 1 |
0.103
explain | SELECT `competition`.`id` AS `competition_id`, `competition`.`name`, `competition`.`league_id`,
`sea`.`name` AS `season`, `lea`.`code` AS `leagueCode`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`league_id` = `league`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `lea` ON `competition`.`league_id` =
`lea`.`id`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272')
ORDER BY .`stats_competition`.`season` DESC, IFNULL(.`league`.`rank`, 9223372036854775807),
.`stats_competition`.`priority` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1 | stats_player_id | 5 | const | 141 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | | | 1 | SIMPLE | league | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_competition.league_id | 1 | | | 1 | SIMPLE | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | | | 1 | SIMPLE | sea | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.season | 1 | | | 1 | SIMPLE | lea | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.league_id | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:59 | 1 |
0.087
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.406
explain | SELECT `id`, `stats_team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`
WHERE (`stats_player_id` = '13272') AND (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from`
< NOW()) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` > NOW() OR
UNIX_TIMESTAMP(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to`) <= 0 OR
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` IS NULL)
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_player_2_team | ref | fk_stats_player_2_team_stats_player1 | fk_stats_player_2_team_stats_player1 | 5 | const | 15 | Using where; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268 | 1 |
0.711
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`,
`club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`,
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable`
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC
LIMIT 1))
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable`
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC
LIMIT 1))
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IN (769))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 1 | PRIMARY | stats_club | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index | | 1 | PRIMARY | stats_club_name | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_club.id | 1 | | | 1 | PRIMARY | club | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_club_logo | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.club.id | 1 | | | 4 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id | 1 | Using where; Using filesort | | 3 | DEPENDENT SUBQUERY | nameTable | ref | stats_club_id | stats_club_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id | 1 | Using where; Using filesort | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/components/Stats.php:87 | 1 |
17.014
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.`value`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match`
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 (`stats_team_home_id` IN (769) OR `stats_team_guest_id` IN (769)) AND
(DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) >= CURDATE()) AND
(`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`bet_type_code` = 'link')
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` ASC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_match | index_merge | PRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2 | fk_stats_match_stats_team1,fk_stats_match_stats_team2 | 5,5 | | 670 | Using union(fk_stats_match_stats_team1,fk_stats_match_stats_team2); Using where; Using filesort | | 1 | SIMPLE | match_bet | eq_ref | PRIMARY,match_bet_bet_type | PRIMARY | 64 | test_dev_nhlcz_s6_esports_cz.stats_match.id,const | 1 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/components/Stats.php:102 | 0 |
0.806
explain | SELECT DISTINCT `sea`.*
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`competition`.`repre` = 0) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL)
ORDER BY `sea`.`year` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 5 | const | 141 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | sea | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.season | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:89 | 16 |
0.046
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.072
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.066
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.047
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.041
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.066
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.063
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.073
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.066
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.061
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.058
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.047
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.047
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.050
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.052
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.055
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.586
explain | SELECT DISTINCT `sea`.*
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`competition`.`repre` = 1) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL)
ORDER BY `sea`.`year` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 5 | const | 141 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | sea | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.season | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:113 | 5 |
0.045
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.044
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.044
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.044
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.045
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13272')
| 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.526
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_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`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`competition`.`season` = 2008) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0)
ORDER BY `league`.`rank` ASC, `isBarage`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | competition | ref | PRIMARY,sezona | sezona | 4 | const | 65 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,test_dev_nhlcz_s6_esports_cz.competition.id | 1 | Using where; Using index | | 1 | SIMPLE | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | league | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.league_id | 1 | | | 1 | SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.stats_category_id | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107 | 2 |
0.977
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 712)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.797
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 209) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 712)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.289
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 712)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.723
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 742)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.422
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 209) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 742)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.285
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 742)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.618
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_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`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`competition`.`season` = 2009) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0)
ORDER BY `league`.`rank` ASC, `isBarage`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | competition | ref | PRIMARY,sezona | sezona | 4 | const | 102 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,test_dev_nhlcz_s6_esports_cz.competition.id | 1 | Using where; Using index | | 1 | SIMPLE | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | league | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.league_id | 1 | | | 1 | SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.stats_category_id | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107 | 2 |
1.069
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 807)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
1.307
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 584) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 807)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1); Using where | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 2 |
0.284
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 807)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.868
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 6632)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
1.168
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 607) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 6632)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | fk_stats_goalkeepers_stats_team1,fk_stats_goalkeepers_stats_player1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_team1,fk_stats_goalkeepers_stats_player1); Using where | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 1 |
0.272
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 6632)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.657
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_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`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`competition`.`season` = 2010) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0)
ORDER BY `league`.`rank` ASC, `isBarage`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | competition | ref | PRIMARY,sezona | sezona | 4 | const | 101 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,test_dev_nhlcz_s6_esports_cz.competition.id | 1 | Using where; Using index | | 1 | SIMPLE | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | league | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.league_id | 1 | | | 1 | SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.stats_category_id | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107 | 5 |
2.035
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 893)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1); Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.699
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 142) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 893)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.363
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 893)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1); Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
1.008
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 965)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.628
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 142) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 965)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1); Using where | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 1 |
0.282
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 965)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.428
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 959)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.981
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 196) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 959)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1); Using where | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 2 |
0.276
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 959)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.987
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 933)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.716
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 584) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 933)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1); Using where | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 2 |
0.273
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 933)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.437
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 957)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.416
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 584) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 957)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.277
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 957)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.591
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_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`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`competition`.`season` = 2011) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0)
ORDER BY `league`.`rank` ASC, `isBarage`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 5 | const | 141 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | competition | eq_ref | PRIMARY,sezona | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | league | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.league_id | 1 | | | 1 | SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.stats_category_id | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107 | 4 |
1.147
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 992)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.709
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 124) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 992)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 2 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.283
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 992)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.449
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1002)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.635
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 142) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1002)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1); Using where | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 1 |
0.262
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1002)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.823
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1117)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1); Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.404
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 196) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1117)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.327
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1117)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1); Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.737
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1014)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.715
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 584) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1014)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_team1); Using where | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 2 |
0.291
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1014)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.533
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_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`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`competition`.`season` = 2012) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0)
ORDER BY `league`.`rank` ASC, `isBarage`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 5 | const | 141 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | competition | eq_ref | PRIMARY,sezona | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | league | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.league_id | 1 | | | 1 | SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.stats_category_id | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107 | 2 |
0.720
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1135)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.416
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 124) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1135)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 2 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.291
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1135)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
1.062
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1311)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1); Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.391
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 124) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1311)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 2 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.344
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1311)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1); Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.628
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_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`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`competition`.`season` = 2013) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0)
ORDER BY `league`.`rank` ASC, `isBarage`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 5 | const | 141 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | competition | eq_ref | PRIMARY,sezona | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition2 | 5 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | SIMPLE | league | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.league_id | 1 | | | 1 | SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.competition.stats_category_id | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107 | 4 |
0.840
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1621)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.809
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1621)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 2 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.268
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 1621)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.757
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 3581)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
2.435
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 3581)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 2 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.278
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 3581)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.457
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 2231)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
0.419
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`team`.`id` = 124) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 2231)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | team | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | stats_competition_tree | ref | fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2 | fk_stats_competition_tree_stats_competition1 | 5 | const | 1 | Using where | | 1 | PRIMARY | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1 | stats_player_id | 16 | const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const | 1 | Using where | | 1 | PRIMARY | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_competition_id | 1 | Using where | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | const | 2 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193 | 0 |
0.362
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 2231)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_goalkeepers | ref | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | stats_player_id | 10 | const,const | 2 | Using where |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219 | 0 |
0.642
explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL)
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable`
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC
LIMIT 1))
WHERE (`summary` = 0) AND (`stats_player_id` = '13272') AND (`stats_competition_id` = 3601)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_goalkeepers | index_merge | stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1 | fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1 | 5,5 | | 1 | Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_player1); Using where | | 1 | PRIMARY | competition | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | PRIMARY | team | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id | 1 | | | 1 | PRIMARY | stats_team_name | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.team.id | 1 | | | 2 | DEPENDENT SUBQUERY | nameTable | ref | stats_team_id | stats_team_id | 5 | test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id | 1 | Using where; Using temporary; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157 | 1 |
1 166.5 ms
39.51 MB
206 queries / 187.0 ms
Front:Player:Overview:default