Poř. | Jméno | Tým | P | Z | G | A | B | +/- | + | - | TM |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | Tanner Richard | Švýcarsko | Ú | 3 | 1 | 1 | 2 | 1 | 1 | 0 | 2 |
2 | Lino Martschini | Švýcarsko | Ú | 3 | 0 | 2 | 2 | 0 | 0 | 0 | 0 |
3 | Dean Kukan | Švýcarsko | O | 3 | 1 | 0 | 1 | -2 | 0 | 2 | 0 |
4 | Calvin Thürkauf | Švýcarsko | Ú | 3 | 1 | 0 | 1 | 0 | 1 | 1 | 4 |
5 | Dominik Egli | Švýcarsko | O | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 |
6 | Sandro Schmid | Švýcarsko | Ú | 2 | 0 | 0 | 0 | -2 | 0 | 2 | 2 |
7 | Tobias Geisser | Švýcarsko | O | 2 | 0 | 0 | 0 | -1 | 0 | 1 | 0 |
8 | Valentin Nussbaumer | Švýcarsko | Ú | 2 | 0 | 0 | 0 | -1 | 0 | 1 | 2 |
9 | Dario Simion | Švýcarsko | Ú | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
10 | Mirco Müller | Švýcarsko | O | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
11 | André Heim | Švýcarsko | Ú | 2 | 0 | 0 | 0 | -1 | 0 | 1 | 0 |
12 | Fabian Heldner | Švýcarsko | O | 2 | 0 | 0 | 0 | -1 | 0 | 1 | 0 |
13 | Marco Lehmann | Švýcarsko | Ú | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
14 | Sven Senteler | Švýcarsko | Ú | 3 | 0 | 0 | 0 | -1 | 0 | 1 | 0 |
15 | Simon Le Coultre | Švýcarsko | O | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
16 | Christian Marti | Švýcarsko | O | 3 | 0 | 0 | 0 | -2 | 0 | 2 | 2 |
17 | Christoph Bertschy | Švýcarsko | Ú | 3 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |
18 | Fabrice Herzog | Švýcarsko | Ú | 3 | 0 | 0 | 0 | -1 | 0 | 1 | 0 |
19 | Sven Andrighetto | Švýcarsko | Ú | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
20 | Andres Ambühl | Švýcarsko | Ú | 3 | 0 | 0 | 0 | -1 | 0 | 1 | 0 |
21 | Damien Riat | Švýcarsko | Ú | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |
22 | Tim Berni | Švýcarsko | O | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
ISSN 1214-5718 | dotazy na redakci: redakce@nhl.cz, obchod/reklama: obchod@hokej.cz, technický provoz: webmaster@hokej.cz
© Copyright - Všechna loga a známky NHL, loga a známky týmů NHL, jakožto další vlastnické materiály včetně log konferencí a obrázků Stanley Cupu jsou vlastnictvím NHL, NHL Enterprises, L.P. a příslušných týmů. © NHL Enterprises, L.P. Všechna práva vyhrazena.
Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.088 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubRepository.php:15 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.593 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`, `test_dev_nhlcz_s6_esports_cz`.`stats_club`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 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_logo` ON `test_dev_nhlcz_s6_esports_cz`.`stats_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_club`.`id` = '136')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
30.993 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_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_team_2_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`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_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_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 (`club`.`id` = '136') ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` DESC, IFNULL(`league`.`rank`, 9223372036854775807) LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.073 explain | SELECT `id`, `league_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7135)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.230 explain | SELECT `id`, `banner`, `banner_second` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` = '136')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.139 explain | SELECT `id`, `code`, `setting` FROM `web_settings` WHERE (`section` = 'common')
| 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.452 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`, `test_dev_nhlcz_s6_esports_cz`.`stats_club`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 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_logo` ON `test_dev_nhlcz_s6_esports_cz`.`stats_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_club`.`id` = '136')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
29.355 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_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_team_2_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`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_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_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 (`club`.`id` = '136') ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` DESC, IFNULL(`league`.`rank`, 9223372036854775807) LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.318 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.*, `phase`.`name` AS `phase_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_category`.`type` AS `type`, `league`.`code` AS `league_code`, `league_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_phase` AS `phase` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`phase` = `phase`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`stats_category_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_category`.`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` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id`=7135)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.412 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`social`.`code`, `url` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_2_social` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`social` ON `test_dev_nhlcz_s6_esports_cz`.`stats_club_2_social`.`social_id` = `test_dev_nhlcz_s6_esports_cz`.`social`.`id` WHERE (`stats_club_id` = '136')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.063 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`social`.`code`, `url` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_2_social` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`social` ON `test_dev_nhlcz_s6_esports_cz`.`stats_club_2_social`.`social_id` = `test_dev_nhlcz_s6_esports_cz`.`social`.`id` WHERE (`stats_club_id` = '136')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.074 explain | SELECT `id`, `code`, `name` FROM `test_dev_nhlcz_s6_esports_cz`.`country` ORDER BY `name`
| 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.096 explain | SELECT `id`, `code`, `name` FROM `test_dev_nhlcz_s6_esports_cz`.`country` ORDER BY `name`
| 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.159 explain | SELECT `player`.`date_of_birth`, `goals`, `assistances`, `player`.`id` AS `player_id`, `player`.`name`, `player`.`surname`, `player`.`photo`, `player`.`position`, `player`.`date_of_birth`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`, `test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `team`.`stats_club_id` `club_id`, `team`.`id` `team_id`, `club`.`shortcut`, `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`, `goals`, `assistances`, `matches`, `points`, `score`, `points_plus`, `points_minus`, `penalties` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_player_id` = `player`.`id` 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(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 `team`.`stats_club_id` = `club`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `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_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)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` = `test_dev_nhlcz_s6_esports_cz`.`country`.`id` WHERE (`summary` = 1) AND (`stats_competition_id` = '7135') AND (`player`.`position` != 'GK') AND (`team`.`id` = '136')
| 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.036 explain | SELECT `player`.`date_of_birth`, `goals`, `assistances`, `player`.`id` AS `player_id`, `player`.`name`, `player`.`surname`, `player`.`photo`, `player`.`position`, `player`.`date_of_birth`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`, `test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `team`.`stats_club_id` `club_id`, `team`.`id` `team_id`, `club`.`shortcut`, `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`, `goals`, `assistances`, `matches`, `points`, `score`, `points_plus`, `points_minus`, `penalties` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_player_id` = `player`.`id` 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(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 `team`.`stats_club_id` = `club`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `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_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)) LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` = `test_dev_nhlcz_s6_esports_cz`.`country`.`id` WHERE (`summary` = 1) AND (`stats_competition_id` = '7135') AND (`player`.`position` != 'GK') AND (`team`.`id` = '136') ORDER BY `score` DESC, `goals` DESC, `matches` ASC LIMIT 40
| 22 |
no identity
https://test.nhlcz.s6.esports.cz/klub/136/statistiky?stats-filter-season=2023&stats-filter-competition=7135&stats-filter-team=136&stats-menu-section=info
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
test/<presenter>/<action>[/<id>] |
module = Test |
Test |
|
no | Route |
<module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] |
action = default |
Export |
|
no | Route |
admin/<module>/<presenter>/<action>[/<id>] |
module = Dashboard |
Admin |
|
no | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
|
yes | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
Front:Club:Stats:default |
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
no | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
|
no | ArticleCompatRoute |
<slug [a-zA-Z-0-9\-]+> |
module = Article |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] |
module = League |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> |
module = MinorLeague |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] |
module = League |
Front |
|
no | Route |
<module>/<presenter>/<action>[/<id>] |
id = |
Front |
Front\Club\StatsPresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Club/presenters/StatsPresenter.php:22
Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.085 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubRepository.php:15 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.740 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`, `test_dev_nhlcz_s6_esports_cz`.`stats_club`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 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_logo` ON `test_dev_nhlcz_s6_esports_cz`.`stats_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_club`.`id` = '136')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
55.776 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_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_team_2_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`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_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_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 (`club`.`id` = '136') ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` DESC, IFNULL(`league`.`rank`, 9223372036854775807) LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
43.367 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` = `test_dev_nhlcz_s6_esports_cz`.`season`.`year` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_competition_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_players` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`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` WHERE (`test_dev_nhlcz_s6_esports_cz`.`season`.`id` IS NOT NULL) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` = 136) AND (`virtual` = 0) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`id` IS NOT NULL) ORDER BY `season` DESC, IFNULL(`league`.`rank`, 9223372036854775807), `priority` DESC LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.168 explain | SELECT `id`, `league_id` FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7135)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.984 explain | SELECT DISTINCT `test_dev_nhlcz_s6_esports_cz`.`season`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` = `test_dev_nhlcz_s6_esports_cz`.`season`.`year` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_players` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` WHERE (`test_dev_nhlcz_s6_esports_cz`.`season`.`id` IS NOT NULL) AND (`league_id` = 23) AND (`virtual` = 0) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`id` IS NOT NULL) ORDER BY `year` DESC
| 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.650 explain | SELECT DISTINCT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.* FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` = `test_dev_nhlcz_s6_esports_cz`.`season`.`year` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_players` ON `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` WHERE (`test_dev_nhlcz_s6_esports_cz`.`season`.`id` IS NOT NULL) AND (`season` = 2023) AND (`league_id` = 23) AND (`virtual` = 0) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`id` IS NOT NULL) ORDER BY `virtual` DESC, `priority` DESC
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.241 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_2_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`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_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_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_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_competition`.`season` = 2023) AND (`league`.`id` = 23) AND (`club`.`id` IS NOT NULL) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7135) ORDER BY `team_name`
| 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.055 explain | SELECT `id`, `code`, `name` FROM `test_dev_nhlcz_s6_esports_cz`.`country` ORDER BY `name`
| 41 |
no identity
https://test.nhlcz.s6.esports.cz/klub/136/statistiky?do=stats-playerFilter-reset
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
test/<presenter>/<action>[/<id>] |
module = Test |
Test |
|
no | Route |
<module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] |
action = default |
Export |
|
no | Route |
admin/<module>/<presenter>/<action>[/<id>] |
module = Dashboard |
Admin |
|
no | Route |
hrac/<id [0-9]+>[/<presenter>] |
module = Player |
Front |
|
yes | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
Front:Club:Stats:default |
no | Route |
/clanky |
module = Home |
Front |
|
no | Route |
/priklepy |
module = News |
Front |
|
no | Route |
/vyhledavani |
module = Search |
Front |
|
no | Route |
/archiv-clanku[/<action>][/<id \d+>] |
module = Article |
Front |
|
no | Route |
zapas/<id \d+>[/<presenter>][/<action>] |
module = Match |
Front |
|
no | Route |
/ |
module = Home |
Front |
|
no | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
|
no | ArticleCompatRoute |
<slug [a-zA-Z-0-9\-]+> |
module = Article |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] |
module = League |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> |
module = MinorLeague |
Front |
|
no | LeagueRoute |
<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] |
module = League |
Front |
|
no | Route |
<module>/<presenter>/<action>[/<id>] |
id = |
Front |
Front\Club\StatsPresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Club/presenters/StatsPresenter.php:8