| Time ms | SQL Query | Rows |
|---|
| 0.057 | SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17 | 0 |
0.061
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` = '1173')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_player | const | PRIMARY | PRIMARY | 4 | const | 1 | |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33 | 1 |
0.206
explain | SELECT `id`, `name`, `surname`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.151
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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 |
3.222
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173')
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_players | ref | stats_player_id,fk_stats_players_stats_player1 | stats_player_id | 5 | const | 111 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_players.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_players.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.471
explain | SELECT `id`, `stats_team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`
WHERE (`stats_player_id` = '1173') 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 | 11 | Using where; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268 | 0 |
0.376
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` IS NULL AND FALSE)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | | | | | | | | Impossible WHERE | | 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 | 0 |
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` = '1173')
| 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.056
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.043
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.559
explain | SELECT `id`, `stats_team_id`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`
WHERE (`stats_player_id` = '1173') 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 | 11 | Using where; Using filesort |
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268 | 0 |
0.339
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` IS NULL AND FALSE)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | | | | | | | | Impossible WHERE | | 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 | 0 |
0.845
explain | SELECT DISTINCT `sea`.*
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') 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_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | stats_player_id | 5 | const | 111 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_players.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_players.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 | 15 |
0.064
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.043
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.038
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.060
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.035
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.038
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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` = '1173')
| 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.039
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.039
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.038
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.040
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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` = '1173')
| 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.040
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.037
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.038
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.851
explain | SELECT DISTINCT `sea`.*
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') 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_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | stats_player_id | 5 | const | 111 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | competition | eq_ref | PRIMARY | PRIMARY | 4 | test_dev_nhlcz_s6_esports_cz.stats_players.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_players.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.043
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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` = '1173')
| 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` = '1173')
| 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.037
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.040
explain | SELECT `id`, `position`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player`
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '1173')
| 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.554
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') AND (`competition`.`season` = 1993) 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 | 6 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 4171)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.926
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 294) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 4171)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.355
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 4171)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.925
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 4221)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.518
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 294) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 4221)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.276
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 4221)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.588
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') AND (`competition`.`season` = 1994) 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 | 5 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.478
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 4181)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.228
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 13) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 4181)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.377
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 4181)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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 `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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 4251)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.688
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 13) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 4251)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.269
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 4251)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.615
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') AND (`competition`.`season` = 1995) 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 | 5 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.848
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 4191)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.497
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 294) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 4191)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.378
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 4191)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.491
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 4271)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.560
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 294) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 4271)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.272
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 4271)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.447
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') AND (`competition`.`season` = 1997) 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 | 5 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.555
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 5343)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.509
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 2383) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5343)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.344
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 5343)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.743
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 5344)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.536
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 2383) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5344)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.398
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 5344)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.531
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') AND (`competition`.`season` = 1998) 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 | 5 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.968
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 177)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.916
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 3) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 177)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.247
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 177)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.644
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 4331)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.440
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 3) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 4331)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.300
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 4331)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.548
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') AND (`competition`.`season` = 1999) 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 | 40 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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 |
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 35)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.546
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 35)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.299
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 35)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.520
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.459
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 3) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 1)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.247
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 1)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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 `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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 7)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.411
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 3) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 7)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.267
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 7)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.502
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 5347)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 2398) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5347)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.440
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 5347)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.718
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 5348)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.561
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 2398) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5348)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.278
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 5348)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.587
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') AND (`competition`.`season` = 2000) 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 | 44 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.849
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 19)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.554
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 19)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.285
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 19)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.501
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 34)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.010
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 34)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.312
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 34)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.649
explain | SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` = '1173') AND (`competition`.`season` = 2001) 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 | 51 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.522
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 41)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.483
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 41)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.290
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 41)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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.535
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`stats_competition_id` = 27)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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_players.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.509
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_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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_players`.`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` = '1173') AND (`team`.`id` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 27)
| 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_players | ref | stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1 | 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_players.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.385
explain | SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index`
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players`
WHERE (`summary` = 0) AND (`stats_player_id` = '1173') AND (`stats_competition_id` = 27)
GROUP BY `stats_competition_id`
HAVING COUNT(*) > 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | stats_players | ref | stats_player_id,fk_stats_players_stats_player1,fk_stats_players_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 |
803.3 ms
39.29 MB
169 queries / 87.8 ms
Front:Player:Overview:default