bahis siteleri

NHL.cz na Facebooku

Švýcarsko

Únor 2024

Švýcarsko Švýcarsko SUI 2 ČT 08. 02. (1:0, 0:1, 1:3) 4
Finsko Finsko FIN
Švédsko Švédsko SWE 5 SO 10. 02. (3:0, 2:0, 0:2) 2
Švýcarsko Švýcarsko SUI
Švýcarsko Švýcarsko SUI 3 NE 11. 02. (1:0, 1:2, 1:3) 5
Česko Česko CZE
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: 21, time: 165.230 ms, default

Time msSQL QueryRows
0.084
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubRepository.php:15
0
0.585
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')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_clubconstPRIMARYPRIMARY4const1
1PRIMARYstats_club_namerefstats_club_idstats_club_id5const1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5const1
3DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Club/presenters/BasePresenter.php:32
1
0.085
explain
SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode` 
FROM `zone` 
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id` 
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id` 
WHERE (`zone_template`.`code` = 'default')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEzone_templaterefPRIMARY,codecode302const1Using where; Using index
1SIMPLEzonerefzone_template_id_zone_position_id,zone_template_idzone_template_id_zone_position_id4test_dev_nhlcz_s6_esports_cz.zone_template.id17
1SIMPLEzone_positioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.zone.zone_position_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:182
27
0.352
explain
SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode` 
FROM `zone` 
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id` 
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id` 
WHERE (`zone_template`.`code` = 'club')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEzone_templaterefPRIMARY,codecode302const1Using where; Using index
1SIMPLEzonerefzone_template_id_zone_position_id,zone_template_idzone_template_id_zone_position_id4test_dev_nhlcz_s6_esports_cz.zone_template.id17
1SIMPLEzone_positioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.zone.zone_position_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:185
27
0.167
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')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubService.php:39
1
0.198
explain
SELECT `id`, `code`, `setting` 
FROM `web_settings` 
WHERE (`section` = 'common')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEweb_settingsrefsectionsection767const3Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Setting/Common/CommonSetting.php:16
3
0.496
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')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_clubconstPRIMARYPRIMARY4const1
1PRIMARYstats_club_namerefstats_club_idstats_club_id5const1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5const1
3DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Club/ClubFacade.php:67
1
59.439
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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYclubconstPRIMARYPRIMARY4const1Using temporary; Using filesort
1PRIMARYstats_teamrefstats_club_idstats_club_id5const10Using where
1PRIMARYstats_team_2_competitionrefstats_team_id,fk_stats_team_2_competition_stats_teamstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id7Using index
1PRIMARYstats_competitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_competition_id1
1PRIMARYleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.league_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team.stats_club_id1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_team.stats_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/model/Team/TeamFacade.php:196
1
41.116
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_team_2_competitionrefstats_team_id,fk_stats_team_2_competition_stats_team,fk_stats_team_2_competition_stats_competition1stats_team_id5const103Using where; Using index; Using temporary; Using filesort
1SIMPLEstats_competitioneq_refPRIMARY,sezona,virtualPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_competition_id1Using where
1SIMPLEseasoneq_refPRIMARY,idPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.season1Using where
1SIMPLEleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.league_id1
1SIMPLEstats_playersrefPRIMARY,fk_stats_players_stats_competition1fk_stats_players_stats_competition15test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_competition_id253Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:299
1
0.671
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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
1SIMPLEphaseconstPRIMARYPRIMARY4const1
1SIMPLEstats_categoryconstPRIMARYPRIMARY4const1
1SIMPLEleagueconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:181
1
0.552
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')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_club_2_socialrefPRIMARYPRIMARY4const1
1SIMPLEsocialeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_club_2_social.social_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Social/Links/ClubSocial.php:24
0
1.150
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')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_club_2_socialrefPRIMARYPRIMARY4const1
1SIMPLEsocialeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_club_2_social.social_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Social/Links/ClubSocial.php:24
0
41.635
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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYclubconstPRIMARYPRIMARY4const1Using temporary; Using filesort
1PRIMARYstats_teamrefstats_club_idstats_club_id5const10Using where
1PRIMARYstats_team_2_competitionrefstats_team_id,fk_stats_team_2_competition_stats_teamstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id7Using index
1PRIMARYstats_competitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team_2_competition.stats_competition_id1
1PRIMARYleagueeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_competition.league_id1
1PRIMARYstats_team_namerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_team.id1
1PRIMARYstats_clubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_team.stats_club_id1Using index
1PRIMARYstats_club_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_club.id1
1PRIMARYstats_club_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.stats_team.stats_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/model/Team/TeamFacade.php:196
1
4.415
explain
SELECT DISTINCT `test_dev_nhlcz_s6_esports_cz`.`season`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` ON `competition`.`season` =
`test_dev_nhlcz_s6_esports_cz`.`season`.`year` 
WHERE ((`stats_team_home_id` = 136 OR `stats_team_guest_id` = 136)) 
ORDER BY `year` DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchindex_mergefk_stats_match_stats_team1,fk_stats_match_stats_team2fk_stats_match_stats_team1,fk_stats_match_stats_team25,5243Using union(fk_stats_match_stats_team1,fk_stats_match_stats_team2); Using where; Using temporary; Using filesort
1SIMPLEcompetitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.stats_competition_id1
1SIMPLEseasoneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.competition.season1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/ClubMatch/Filter/Filter.php:109
24
1.738
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.*,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` AS `competition` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition` 
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` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team_2_competition`.`stats_team_id` = 136) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season` = 2023) AND (`virtual` = 0) 
ORDER BY `priority` DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionrefPRIMARY,sezona,virtualsezona4const130Using where; Using filesort
1SIMPLEstats_team_2_competitionrefstats_team_id,fk_stats_team_2_competition_stats_team,fk_stats_team_2_competition_stats_competition1stats_team_id10const,test_dev_nhlcz_s6_esports_cz.stats_competition.id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/ClubMatch/Filter/Filter.php:126
3
0.224
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_category`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_category` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_category`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`stats_category_id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7177)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARY,fk_stats_competition_stats_category1PRIMARY4const1
1SIMPLEstats_categoryconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionCategoryFacade.php:81
1
9.859
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*, `extra_time`.`code` `extra_time_code`,
`phase`.`name` `phase_name`, `team_home_logo`.`path` `team_home_logo`, `team_guest_logo`.`path`
`team_guest_logo`, `team_home_name`.`name` `team_home_name`, `team_guest_name`.`name`
`team_guest_name`, `club_home`.`shortcut` AS `shortcut_home`, `club_guest`.`shortcut` AS
`shortcut_guest`, `club_home`.`nickname` AS `nickname_home`, `club_guest`.`nickname` AS
`nickname_guest`, `period1`.`score_home` AS `score_home_period1`, `period1`.`score_guest` AS
`score_guest_period1`, `period2`.`score_home` AS `score_home_period2`, `period2`.`score_guest` AS
`score_guest_period2`, `period3`.`score_home` AS `score_home_period3`, `period3`.`score_guest` AS
`score_guest_period3`, `period4`.`score_home` AS `score_home_period4`, `period4`.`score_guest` AS
`score_guest_period4`, `period5`.`score_home` AS `score_home_period5`, `period5`.`score_guest` AS
`score_guest_period5` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_home` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_home_id` = `team_home`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_guest` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_guest_id` = `team_guest`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_home_name` ON `team_home`.`id` =
`team_home_name`.`stats_team_id` AND (`team_home_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `team_home_name`.`stats_team_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_guest_name` ON `team_guest`.`id`
= `team_guest_name`.`stats_team_id` AND (`team_guest_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `team_guest_name`.`stats_team_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_home` ON `team_home`.`stats_club_id`
= `club_home`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_home_logo` ON `club_home`.`id` =
`team_home_logo`.`stats_club_id` AND (`team_home_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `team_home_logo`.`stats_club_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_guest` ON
`team_guest`.`stats_club_id` = `club_guest`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_guest_logo` ON `club_guest`.`id`
= `team_guest_logo`.`stats_club_id` AND (`team_guest_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `team_guest_logo`.`stats_club_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period1`.`stats_match_id` AND
(`period1`.`period` = 1) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period2`.`stats_match_id` AND
(`period2`.`period` = 2) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period3`.`stats_match_id` AND
(`period3`.`period` = 3) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period4`.`stats_match_id` AND
(`period4`.`period` = 4) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` AS `period5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = `period5`.`stats_match_id` AND
(`period5`.`period` = 5) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_extra_time` AS `extra_time` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`extra_time` = `extra_time`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_phase` AS `phase` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`phase` = `phase`.`id` 
WHERE (`team_home`.`id` IS NOT NULL) AND (`team_guest`.`id` IS NOT NULL) AND (`team_home_name`.`id`
IS NOT NULL) AND (`team_guest_name`.`id` IS NOT NULL) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = 7177) AND
((`stats_team_home_id` = 136 OR `stats_team_guest_id` = 136)) AND (`datetime` IS NOT NULL) 
ORDER BY `datetime`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_matchrefdatumcas,fk_stats_match_stats_competition1,fk_stats_match_stats_team1,fk_stats_match_stats_team2fk_stats_match_stats_competition15const6Using where; Using filesort
1PRIMARYteam_homeeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.stats_team_home_id1Using where
1PRIMARYclub_homeeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team_home.stats_club_id1
1PRIMARYteam_home_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_home.id1
1PRIMARYteam_guesteq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.stats_team_guest_id1Using where
1PRIMARYclub_guesteq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team_guest.stats_club_id1
1PRIMARYteam_guest_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_guest.id1
1PRIMARYteam_home_namerefPRIMARY,stats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team_home.id1Using where
1PRIMARYteam_guest_namerefPRIMARY,stats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.stats_match.stats_team_guest_id1Using where
1PRIMARYperiod1eq_refstats_match_id_periodstats_match_id_period8test_dev_nhlcz_s6_esports_cz.stats_match.id,const1
1PRIMARYperiod2eq_refstats_match_id_periodstats_match_id_period8test_dev_nhlcz_s6_esports_cz.stats_match.id,const1
1PRIMARYperiod3eq_refstats_match_id_periodstats_match_id_period8test_dev_nhlcz_s6_esports_cz.stats_match.id,const1
1PRIMARYperiod4eq_refstats_match_id_periodstats_match_id_period8test_dev_nhlcz_s6_esports_cz.stats_match.id,const1
1PRIMARYperiod5eq_refstats_match_id_periodstats_match_id_period8test_dev_nhlcz_s6_esports_cz.stats_match.id,const1
1PRIMARYextra_timeeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.extra_time1
1PRIMARYphaseeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.phase1
5DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.team_guest_logo.stats_club_id1Using where; Using temporary; Using filesort
4DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.team_home_logo.stats_club_id1Using where; Using temporary; Using filesort
3DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team_guest_name.stats_team_id1Using where; Using temporary; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team_home_name.stats_team_id1Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/Convert/MatchToArray.php:18
3
0.297
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`id` IN (7177))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/templates-blocks-matchTable-latte-52f5496236ea4edf60f1cf7da037d180.php:45
1
1.792
explain
SELECT `datetime`, `note`, `tv`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`tv_2_match` 
LEFT JOIN `tv` ON `test_dev_nhlcz_s6_esports_cz`.`tv_2_match`.`tv_id` = `tv`.`id` 
WHERE (`stats_match_id` = 2912676) AND (`tv`.`visible` = 1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtv_2_matchreftv_id,stats_match_idstats_match_id4const1
1SIMPLEtveq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.tv_2_match.tv_id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchFacade.php:523
0
0.173
explain
SELECT `datetime`, `note`, `tv`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`tv_2_match` 
LEFT JOIN `tv` ON `test_dev_nhlcz_s6_esports_cz`.`tv_2_match`.`tv_id` = `tv`.`id` 
WHERE (`stats_match_id` = 2912679) AND (`tv`.`visible` = 1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtv_2_matchreftv_id,stats_match_idstats_match_id4const1
1SIMPLEtveq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.tv_2_match.tv_id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchFacade.php:523
0
0.203
explain
SELECT `datetime`, `note`, `tv`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`tv_2_match` 
LEFT JOIN `tv` ON `test_dev_nhlcz_s6_esports_cz`.`tv_2_match`.`tv_id` = `tv`.`id` 
WHERE (`stats_match_id` = 2912680) AND (`tv`.`visible` = 1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtv_2_matchreftv_id,stats_match_idstats_match_id4const1
1SIMPLEtveq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.tv_2_match.tv_id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchFacade.php:523
0
¤ ×

Front:Club:Match:default

https://test.nhlcz.s6.esports.cz/klub/136/zapasy

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
no Route hrac/<id [0-9]+>[/<presenter>] module = Player
presenter = Overview
action = default
Front
yes Route klub/<id [0-9]+>[/<presenter>] module = Club
presenter = Overview
action = default
id = 
NULL
Front Front:Club:Match:default
id = 136
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
no ArticleRoute <slug [a-zA-Z-0-9\-]+>/<id \d+> module = Article
presenter = Article
action = default
Front
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\Club\MatchPresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Club/presenters/MatchPresenter.php:8

¤ ×