bahis siteleri

NHL.cz na Facebooku

TOMÁŠ REDLICH

narozen

12.2.1993

výška

186 cm

věk

31 let

váha

84 kg

post

útočník

hůl

levá

Play off Tipsport extraligy 2023-2024

zápasů 3  
gólů 0  
asistencí 1  
bodů 1  
± body 1  
tm 4  
RSS | Kontakt | Všeobecné obchodní podmínky a pravidla | Cookies | Nastavení soukromí | Reklama - Provozovatel BPA sport marketing a.s. ve spolupráci s eSports, s.r.o.

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.

 

Queries: 15, time: 13.256 ms, default

Time msSQL QueryRows
0.061
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17
0
0.200
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` = '13325')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.177
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13325')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.134
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13325')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
1.344
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` = '13325') 
ORDER BY .`stats_competition`.`season` DESC, IFNULL(.`league`.`rank`, 9223372036854775807),
.`stats_competition`.`priority` DESC 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1stats_player_id5const104Using where; Using temporary; Using filesort
1SIMPLEstats_competitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.league_id1
1SIMPLEcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1
1SIMPLEseaeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.season1
1SIMPLEleaeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.league_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:59
1
0.376
explain
SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '13325') 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_teamreffk_stats_player_2_team_stats_player1fk_stats_player_2_team_stats_player15const6Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268
1
0.685
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`,
`club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`,
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`, `club`.`id` `clubId` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IN (5))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_teamconstPRIMARYPRIMARY4const1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4const1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYclubeq_refPRIMARYPRIMARY4const1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club.id1
4DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id1Using where; Using filesort
3DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:133
1
0.061
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13325')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.060
explain
SELECT `id`, `code`, `name` 
FROM `test_dev_nhlcz_s6_esports_cz`.`country` 
WHERE (`id` IN (1))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcountryconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Player-templates-Overview-default-latte-f9f4e0ca40eb66803765d76f0f9a91f6.php:37
1
0.046
explain
SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '13325')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.404
explain
SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '13325') 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_teamreffk_stats_player_2_team_stats_player1fk_stats_player_2_team_stats_player15const6Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268
1
0.714
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`,
`club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`,
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IN (5))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_teamconstPRIMARYPRIMARY4const1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5const1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4const1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYclubeq_refPRIMARYPRIMARY4const1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club.id1
4DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id1Using where; Using filesort
3DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/components/Stats.php:87
1
6.983
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.`value` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`match_bet` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` 
WHERE (`stats_team_home_id` IN (5) OR `stats_team_guest_id` IN (5)) AND
(DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) >= CURDATE()) AND
(`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`bet_type_code` = 'link') 
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` ASC 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchindex_mergePRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2fk_stats_match_stats_team1,fk_stats_match_stats_team25,51631Using union(fk_stats_match_stats_team1,fk_stats_match_stats_team2); Using where; Using filesort
1SIMPLEmatch_beteq_refPRIMARY,match_bet_bet_typePRIMARY64test_dev_nhlcz_s6_esports_cz.stats_match.id,const1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/components/Stats.php:102
0
0.786
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`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year` 
WHERE (`summary` = 0) AND (`stats_player_id` = '13325') AND (`competition`.`repre` = 0) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`league`.`code` = 'nhl') 
ORDER BY `sea`.`year` ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEleagueconstPRIMARY,codecode768const1Using index; Using temporary; Using filesort
1SIMPLEstats_playersrefstats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1stats_player_id5const104Using where; Using index
1SIMPLEcompetitioneq_refPRIMARY,league_idPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id1Using where
1SIMPLEseaeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.season1
1SIMPLEstats_competition_treereffk_stats_competition_tree_stats_competition2fk_stats_competition_tree_stats_competition25test_dev_nhlcz_s6_esports_cz.competition.id1Using where; Distinct
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:101
0
1.225
explain
SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS
`nameTitle`, IF(`post`.`photo_id` IS NOT NULL, (
SELECT `photo`.`url` 
FROM `photo` 
WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, (
SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` 
FROM `file` 
WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` 
FROM `post` 
LEFT JOIN `post_2_stats_player` ON `post`.`id` = `post_2_stats_player`.`post_id` 
WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <=
NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND
`post`.`unpublish_date` >= NOW())) AND (`post_2_stats_player`.`stats_player_id` = '13325') 
ORDER BY `publish_date` DESC 
LIMIT 4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYpost_2_stats_playerrefPRIMARY,stats_player_idstats_player_id4const1Using where; Using index; Using temporary; Using filesort
1PRIMARYposteq_refPRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_indexPRIMARY4test_dev_nhlcz_s6_esports_cz.post_2_stats_player.post_id1Using where
3DEPENDENT SUBQUERYfileeq_refPRIMARY,id_UNIQUEPRIMARY4test_dev_nhlcz_s6_esports_cz.post.file_id1
2DEPENDENT SUBQUERYphotoeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.post.photo_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/test-app-Front-templates-blocks-articles-latte-e8402771c740c09b2165a479ad74b8b0.php:39
0
¤ ×

Front:Player:Overview:default

https://test.nhlcz.s6.esports.cz/hrac/13325

Matched? Class Mask Defaults Module Request
no Route test/<presenter>/<action>[/<id>] module = Test
id = 
NULL
Test
no Route <module (xml.*|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>] action = default
param1 = 
NULL
param2 = 
NULL
param3 = 
NULL
Export
no Route admin/<module>/<presenter>/<action>[/<id>] module = Dashboard
presenter = Homepage
action = default
id = 
NULL
Admin
yes Route hrac/<id [0-9]+>[/<presenter>] module = Player
presenter = Overview
action = default
Front Front:Player:Overview:default
id = 13325
no Route klub/<id [0-9]+>[/<presenter>] module = Club
presenter = Overview
action = default
id = 
NULL
Front
no Route /clanky module = Home
presenter = Article
action = default
Front
no Route /priklepy module = News
presenter = News
action = default
Front
no Route /vyhledavani module = Search
presenter = Search
action = default
Front
no Route /archiv-clanku[/<action>][/<id \d+>] module = Article
presenter = Archive
action = default
id = 
NULL
Front
no Route zapas/<id \d+>[/<presenter>][/<action>] module = Match
presenter = Overview
action = default
Front
no Route / module = Home
presenter = Homepage
action = default
Front
may ArticleRoute <slug [a-zA-Z-0-9\-]+>/<id \d+> module = Article
presenter = Article
action = default
Front Front:Article:Article:default
slug = hrac
id = 13325
no ArticleCompatRoute <slug [a-zA-Z-0-9\-]+> module = Article
presenter = Article
action = default
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>] module = League
presenter = Page
action = default
leagueId = 
NULL
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+> module = MinorLeague
presenter = Section
action = default
Front
no LeagueRoute <id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>] module = League
presenter = Overview
action = default
id = 
NULL
leagueId = 
NULL
Front
no Route <module>/<presenter>/<action>[/<id>] id = 
NULL
Front

Front\Player\OverviewPresenter::renderDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:22

¤ ×