10. května 2019, 5:35
Jiří SamešBoston Bruins v noci na pátek, 10. května, porazili v prvním zápase finále Východní konference Carolinu Hurricanes 5:2. Autorem vítězného gólu se stal útočník Patrice Bergeron.
Patrice Bergeron (Boston Bruins)
Bergeron v čase 42:54 poslal Bruins díky přesilovkové trefě do vedení 3:2. Skóroval z mezikruží bez přípravy, po přihrávce od útočníka Brada Marchanda z pravé strany. Druhou asistenci si připsal útočník Jake DeBrusk.
Pro Bergerona šestý gól v letošním play-off, z toho pátý při přesilové hře.
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.084 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:17 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.902 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` 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`.`id` = '5018352')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
42.193 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` 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 (`recommend` = 1) AND (`post`.`id` NOT IN ('5018352')) ORDER BY `publish_date` DESC LIMIT 4
| 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.076 explain | SELECT `id`, `setting` FROM `web_settings` WHERE (`code` = 'article_advert') LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.682 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` 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`.`id` = 5018352)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.292 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` WHERE (`post`.`post_type_id` = 1) 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`.`id` IS NULL)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.055 explain | SELECT `post_2_tag`.*, `tag`.`name` FROM `post_2_tag` LEFT JOIN `tag` ON `post_2_tag`.`tag_id` = `tag`.`id` WHERE (`post_2_tag`.`post_id` = 5018352) AND (`post_2_tag`.`tag_type_id` = 1)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.058 explain | SELECT `post_2_category`.*, `category`.`name` FROM `post_2_category` LEFT JOIN `category` ON `post_2_category`.`category_id` = `category`.`id` WHERE (`post_2_category`.`post_id` = 5018352) AND (`post_2_category`.`hidden_in_post` = 0)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.228 explain | SELECT `id` FROM `post` WHERE (`id` IN (5018352))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.060 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id`, `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`surname` FROM `post_2_stats_player` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` ON `post_2_stats_player`.`stats_player_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` WHERE (`post_id` = 5018352)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.742 explain | SELECT `club`.*, `post_2_stats_club`.`stats_club_id`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name` FROM `post_2_stats_club` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON `post_2_stats_club`.`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 `post_2_stats_club`.`stats_club_id` = `club`.`id` WHERE (`post_id` = 5018352)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.349 explain | SELECT `id`, `name`, `surname` FROM `test_dev_nhlcz_s6_esports_cz`.`user` WHERE (`id` IN (129188))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.237 explain | SELECT `id`, `user_id` FROM `post_2_user` WHERE (`post_id` = '5018352')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.263 explain | SELECT `post_2_category`.*, `category`.`name` FROM `post_2_category` LEFT JOIN `category` ON `post_2_category`.`category_id` = `category`.`id` WHERE (`post_2_category`.`post_id` = '5018352') AND (`post_2_category`.`hidden_in_post` = 0) AND (`category`.`public` = 1) AND (`category`.`show_in_post` = 1) AND (`post_2_category`.`hidden_in_post` = 0)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.293 explain | SELECT `post_id`, `stats_player_id` FROM `post_2_stats_player` WHERE (`post_id` = '5018352')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.291 explain | SELECT `club`.*, `post_2_stats_club`.`stats_club_id`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name` FROM `post_2_stats_club` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON `post_2_stats_club`.`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 `post_2_stats_club`.`stats_club_id` = `club`.`id` WHERE (`post_id` = '5018352')
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.546 explain | SELECT `team`.*, `post_2_stats_team`.`stats_team_id`, `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name` FROM `post_2_stats_team` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON `post_2_stats_team`.`stats_team_id` = `team`.`id` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` ON `post_2_stats_team`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team`.`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)) WHERE (`post_id` = '5018352') AND (`team`.`stats_club_id` IS NOT NULL)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.170 explain | SELECT `id`, `name` FROM `category` WHERE (`id` IN (287))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.706 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` 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 (`topstory` IS NOT NULL OR `show_on_hompage` = 1) AND (`post`.`id` NOT IN ('5018352', 5030871, 5030847, 5030843, 5030790)) ORDER BY `publish_date` DESC LIMIT 4
| 4 |
no identity
https://test.nhlcz.s6.esports.cz/gol-dne-vitezna-trefa-patrice-bergerona-pri-presilove-hre/5018352
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 |
|
no | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
|
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 |
|
yes | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
Front:Article:Article:default |
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\Article\ArticlePresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArticlePresenter.php:27
Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.073 | SET NAMES 'utf8'/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:17 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.747 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` 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`.`id` = '5018352')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
35.581 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` 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 (`recommend` = 1) AND (`post`.`id` NOT IN ('5018352')) ORDER BY `publish_date` DESC LIMIT 4
| 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.278 explain | SELECT `id`, `setting` FROM `web_settings` WHERE (`code` = 'article_advert') LIMIT 1
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.381 explain | SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`, `test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` FROM `post` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` = `test_dev_nhlcz_s6_esports_cz`.`user`.`id` WHERE (`post`.`id` = '5018352')
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.529 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` 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`.`id` = 5018352)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.227 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` WHERE (`post`.`post_type_id` = 1) 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`.`id` IS NULL)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.202 explain | SELECT `post_2_tag`.*, `tag`.`name` FROM `post_2_tag` LEFT JOIN `tag` ON `post_2_tag`.`tag_id` = `tag`.`id` WHERE (`post_2_tag`.`post_id` = 5018352) AND (`post_2_tag`.`tag_type_id` = 1)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.192 explain | SELECT `post_2_category`.*, `category`.`name` FROM `post_2_category` LEFT JOIN `category` ON `post_2_category`.`category_id` = `category`.`id` WHERE (`post_2_category`.`post_id` = 5018352) AND (`post_2_category`.`hidden_in_post` = 0)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.156 explain | SELECT `id` FROM `post` WHERE (`id` IN (5018352))
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.285 explain | SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id`, `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`surname` FROM `post_2_stats_player` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` ON `post_2_stats_player`.`stats_player_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` WHERE (`post_id` = 5018352)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.636 explain | SELECT `club`.*, `post_2_stats_club`.`stats_club_id`, `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name` FROM `post_2_stats_club` LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON `post_2_stats_club`.`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 `post_2_stats_club`.`stats_club_id` = `club`.`id` WHERE (`post_id` = 5018352)
| 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.750 | UPDATE `post` SET `impression_count`=`impression_count` + 1 WHERE (`post`.`id` = '5018352')/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostRepository.php:186 | 1 |
no identity
https://test.nhlcz.s6.esports.cz/gol-dne-vitezna-trefa-patrice-bergerona-na-presilove-hre/5018352
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 |
|
no | Route |
klub/<id [0-9]+>[/<presenter>] |
module = Club |
Front |
|
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 |
|
yes | ArticleRoute |
<slug [a-zA-Z-0-9\-]+>/<id \d+> |
module = Article |
Front |
Front:Article:Article:default |
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\Article\ArticlePresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArticlePresenter.php:27