bahis siteleri

NHL.cz na Facebooku

  • Tipsport extraliga
  • 17.9.2023 16:00
  • 2. kolo

Zápis o utkání

1. třetina

čas tým branky asistence typ gólu
Nebyla vstřelena žádná branka
čas tým vyloučení trest
04:28 KLA Eduards TRALMAKS 2 min. podražení
09:48 PCE Patrik POULÍČEK 2 min. držení
17:07 KLA Chris MARTENET 2 min. napadení

2. třetina

čas tým branky asistence typ gólu
31:33 KLA Martin PROCHÁZKA (1) Jakub KLEPIŠ (1) 5/5
Martin Procházka, Jakub Klepiš, Richard Jarůšek, Jiří Ticháček, Chris Martenet, Adam Brízgala
Lukáš Radil, Robert Kousal, Jan Košťálek, Tomáš Zohorna, Tomáš Dvořák, Roman Will
35:07 PCE Tomáš ZOHORNA (1) Peter ČEREŠŇÁK (1), David MUSIL (1) 5/5
Lukáš Radil, Peter Čerešňák, Tomáš Zohorna, David Musil, Robert Kousal, Roman Will
Václav Veber, Ondřej Slováček, Richard Jarůšek, Jakub Klepiš, Martin Procházka, Adam Brízgala
39:34 PCE Patrik POULÍČEK (2) GV Peter ČEREŠŇÁK (2), Robert ŘÍČKA (2) 5/5
Matej Paulovič, Robert Říčka, Patrik Poulíček, Peter Čerešňák, David Musil, Roman Will
Jaromír Pytlík, Deven Sideroff, Chris Martenet, Jiří Ticháček, Eduards Tralmaks, Adam Brízgala
čas tým vyloučení trest
25:55 PCE Jan KOŠŤÁLEK 2 min. podražení
26:45 KLA Jake DOTCHIN 2 min. sekání

3. třetina

čas tým branky asistence typ gólu
58:25 PCE Tomáš HYKA (1) Robert KOUSAL (3), Lukáš SEDLÁK (1) 5/5
David Musil, Michal Hrádek, Robert Kousal, Tomáš Hyka, Lukáš Sedlák, Roman Will
Tomáš Plekanec, Deven Sideroff, Jakub Klepiš, Richard Jarůšek, Eduards Tralmaks, Jake Dotchin
čas tým vyloučení trest
43:49 KLA Tomáš PLEKANEC 2 min. podražení
47:19 KLA Jakub STRNAD 2 min. hákování
51:01 PCE Tomáš DVOŘÁK 2 min. podražení

Soupisky

Rytíři Kladno

Č P Hráč G A B +/- S H BS BULY IT
44 O Jake DOTCHIN 0 0 0 -1 3 0 2 24:09
96 O Tadeáš HEJDA 0 0 0 0 0 1 0 16:01
93 O Karel KLIKORKA 0 0 0 0 0 0 0 01:37
27 O Chris MARTENET 0 0 0 0 0 0 0 21:22
28 O Ondřej SLOVÁČEK 0 0 0 -1 1 0 3 15:39
26 O Jiří TICHÁČEK 0 0 0 0 4 0 0 20:08
5 O Václav VEBER 0 0 0 -1 1 0 1 15:52
41 Ú Jakub BABKA 0 0 0 0 1 0 0 67% 08:42
88 Ú Matěj BERAN 0 0 0 0 1 0 0 11:20
89 Ú Ondřej BLÁHA 0 0 0 0 2 0 0 10:17
91 Ú Richard JARŮŠEK 0 0 0 -1 1 0 0 15:42
21 Ú Jakub KLEPIŠ 0 1 1 -1 4 0 2 43% 17:52
43 Ú Antonín MELKA 0 0 0 0 1 0 0 12:38
14 Ú Tomáš PLEKANEC 0 0 0 -1 2 0 0 58% 24:10
23 Ú Martin PROCHÁZKA 1 0 1 0 1 0 1 11:10
20 Ú Jaromír PYTLÍK 0 0 0 -1 0 1 1 55% 12:43
97 Ú Deven SIDEROFF 0 0 0 -2 0 0 0 20:42
92 Ú Jakub STRNAD 0 0 0 0 0 0 0 13:27
55 Ú Eduards TRALMAKS 0 0 0 -2 0 0 0 16:15
Č P Hráč ČAS Z G %Z A T
1 B Adam BRÍZGALA 59:23 26 2 92.86 0 0
29 B Landon BOW

HC Dynamo Pardubice

Č P Hráč G A B +/- S H BS BULY IT
41 O Peter ČEREŠŇÁK 0 2 2 2 3 0 2 22:32
7 O Tomáš DVOŘÁK 0 0 0 -1 2 0 1 16:32
77 O Michal HRÁDEK 0 0 0 1 0 0 0 16:39
33 O Jan KOŠŤÁLEK 0 0 0 -1 3 0 0 17:08
8 O David MUSIL 0 1 1 3 2 0 0 21:46
14 O Ondřej VÁLA 0 0 0 0 1 0 1 16:46
81 Ú David CIENCIALA 0 0 0 0 1 0 0 15:09
38 Ú Tomáš HYKA 1 0 1 1 2 0 0 16:47
90 Ú Robert KOUSAL 0 1 1 1 1 0 0 15:10
89 Ú Jan MANDÁT 0 0 0 0 2 0 1 15:27
67 Ú Matej PAULOVIČ 0 0 0 1 0 0 0 12:02
44 Ú Patrik POULÍČEK 1 0 1 1 1 0 0 60% 18:47
69 Ú Lukáš RADIL 0 0 0 0 1 0 0 13:05
27 Ú Daniel RÁKOS 0 0 0 0 3 0 1 36% 13:24
62 Ú Robert ŘÍČKA 0 1 1 1 1 0 0 14:59
23 Ú Lukáš SEDLÁK 0 1 1 1 3 0 0 48% 17:22
25 Ú Tomáš URBAN
55 Ú Tomáš VONDRÁČEK 0 0 0 0 0 0 0 13:39
79 Ú Tomáš ZOHORNA 1 0 1 0 3 0 1 42% 15:37
Č P Hráč ČAS Z G %Z A T
22 B Roman WILL 60:00 21 1 95.45 0 0
35 B Milan KLOUČEK
66%
Počet diváků 3432 ČEZ Stadion 5200
Hlavní rozhodčí: Jiří OndráčekJan Jaroš
Čároví rozhodčí: Josef ŠpůrPetr Šimánek
Střely po třetinách 6:11, 11:10, 5:8
Vyloučení 5:3
Vyšší tresty 0:0
Využití 0:0
V oslabení 0:0
Střely na branku 22:28
Blokované střely 10:7
Zásahy brankářů 26:21
Hity 2:0
Trestné minuty 10:6
Tisk
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: 70, time: 126.681 ms, default

Time msSQL QueryRows
0.076
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchRepository.php:17
0
2.750
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` `competition`, `extra_time`.`code`
`extra_time_code`, `contumacy`.`code` `contumacy_code`, `phase`.`name` `phase_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season`, `sheet_state`.`name` `sheetStateName`,
`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`,
`club_home_name`.`name` `club_home_name`, `club_guest_name`.`name` `club_guest_name` 
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_club_name` AS `club_home_name` ON `club_home`.`id` =
`club_home_name`.`stats_club_id` AND (`club_home_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `club_home_name`.`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_name` AS `club_guest_name` ON `club_guest`.`id`
= `club_guest_name`.`stats_club_id` AND (`club_guest_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `club_guest_name`.`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_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 
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_contumacy` AS `contumacy` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`contumacy` = `contumacy`.`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` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_sheet_state` AS `sheet_state` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`sheet_state` = `sheet_state`.`code` 
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`.`id` = '2907822')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_matchconstPRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2PRIMARY4const1
1PRIMARYteam_homeconstPRIMARYPRIMARY4const1
1PRIMARYteam_guestconstPRIMARYPRIMARY4const1
1PRIMARYclub_homeconstPRIMARYPRIMARY4const1
1PRIMARYteam_home_namerefPRIMARY,stats_team_idstats_team_id5const1Using where
1PRIMARYteam_guest_namerefPRIMARY,stats_team_idstats_team_id5const2Using where
1PRIMARYteam_home_logorefstats_club_idstats_club_id5const10
1PRIMARYclub_guesteq_refPRIMARYPRIMARY4const1
1PRIMARYteam_guest_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_guest.id1
1PRIMARYclub_home_namerefstats_club_idstats_club_id5const10
1PRIMARYclub_guest_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_guest.id1
1PRIMARYstats_competitioneq_refPRIMARYPRIMARY4const1
1PRIMARYextra_timeeq_refPRIMARYPRIMARY4const1
1PRIMARYcontumacyeq_refPRIMARYPRIMARY4const1
1PRIMARYphaseeq_refPRIMARYPRIMARY4const1
1PRIMARYsheet_stateeq_refPRIMARYPRIMARY767const1
7DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_guest_name.stats_club_id1Using where; Using filesort
6DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_home_name.stats_club_id1Using where; Using filesort
5DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.team_guest_logo.stats_club_id1Using where; Using filesort
4DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.team_home_logo.stats_club_id1Using where; Using filesort
3DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team_guest_name.stats_team_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team_home_name.stats_team_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/BasePresenter.php:29
1
0.990
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` IS NULL)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEImpossible WHERE
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69
0
0.197
explain
SELECT `id`, `league_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`id` IN (7071))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/OverviewPresenter.php:71
1
0.160
explain
SELECT `id`, `code` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_league` 
WHERE (`id` IN (3))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_leagueconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/OverviewPresenter.php:71
1
0.216
explain
SELECT `id`, `name`, `surname`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = 17213)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.156
explain
SELECT `id`, `name`, `surname`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = 16240)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
44.742
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.* 
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`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
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 (DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) = CURDATE()) AND
(`league`.`code` = 'nhl') AND (`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` IS NOT
NULL) 
LIMIT 100
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEleagueconstPRIMARY,codecode768const1Using index
1SIMPLEcompetitionrefPRIMARY,league_idleague_id5const273Using where; Using index
1SIMPLEstats_matchrefPRIMARY,fk_stats_match_stats_competition1fk_stats_match_stats_competition15test_dev_nhlcz_s6_esports_cz.competition.id21Using where
1SIMPLEmatch_betrefPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/presenters/BasePresenter.php:112
0
0.225
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` `competition`, `extra_time`.`code`
`extra_time_code`, `contumacy`.`code` `contumacy_code`, `phase`.`name` `phase_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season`, `sheet_state`.`name` `sheetStateName`,
`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`,
`club_home_name`.`name` `club_home_name`, `club_guest_name`.`name` `club_guest_name` 
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_club_name` AS `club_home_name` ON `club_home`.`id` =
`club_home_name`.`stats_club_id` AND (`club_home_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `club_home_name`.`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_name` AS `club_guest_name` ON `club_guest`.`id`
= `club_guest_name`.`stats_club_id` AND (`club_guest_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `club_guest_name`.`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_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 
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_contumacy` AS `contumacy` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`contumacy` = `contumacy`.`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` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_sheet_state` AS `sheet_state` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`sheet_state` = `sheet_state`.`code` 
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`.`id` = '2907822')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_matchconstPRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2PRIMARY4const1
1PRIMARYteam_homeconstPRIMARYPRIMARY4const1
1PRIMARYteam_guestconstPRIMARYPRIMARY4const1
1PRIMARYclub_homeconstPRIMARYPRIMARY4const1
1PRIMARYteam_home_namerefPRIMARY,stats_team_idstats_team_id5const1Using where
1PRIMARYteam_guest_namerefPRIMARY,stats_team_idstats_team_id5const2Using where
1PRIMARYteam_home_logorefstats_club_idstats_club_id5const10
1PRIMARYclub_guesteq_refPRIMARYPRIMARY4const1
1PRIMARYteam_guest_logorefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_guest.id1
1PRIMARYclub_home_namerefstats_club_idstats_club_id5const10
1PRIMARYclub_guest_namerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_guest.id1
1PRIMARYstats_competitioneq_refPRIMARYPRIMARY4const1
1PRIMARYextra_timeeq_refPRIMARYPRIMARY4const1
1PRIMARYcontumacyeq_refPRIMARYPRIMARY4const1
1PRIMARYphaseeq_refPRIMARYPRIMARY4const1
1PRIMARYsheet_stateeq_refPRIMARYPRIMARY767const1
7DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_guest_name.stats_club_id1Using where; Using filesort
6DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.club_home_name.stats_club_id1Using where; Using filesort
5DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.team_guest_logo.stats_club_id1Using where; Using filesort
4DEPENDENT SUBQUERYnameTablerefstats_club_idstats_club_id5test_dev_nhlcz_s6_esports_cz.team_home_logo.stats_club_id1Using where; Using filesort
3DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team_guest_name.stats_team_id1Using where; Using filesort
2DEPENDENT SUBQUERYnameTablerefstats_team_idstats_team_id5test_dev_nhlcz_s6_esports_cz.team_home_name.stats_team_id1Using where; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:31
1
0.224
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (828))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34
1
0.180
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (828))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34
1
0.165
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (12))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.179
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (12))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.063
explain
SELECT `id`, `league_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`id` IN (7071))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:45
1
0.082
explain
SELECT `id`, `code` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_league` 
WHERE (`id` IN (3))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_leagueconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:45
1
0.742
explain
SELECT `id`, `period`, `score_home`, `score_guest` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = '2907822') 
ORDER BY `period`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_match_periodrefstats_match_id_periodstats_match_id_period4const4Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/PeriodHelper.php:70
4
0.937
explain
SELECT `id`, `onlajny_id`, `post_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2907822')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.287
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2907822') AND (`type` = 'match') 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavailable_videorefstats_match_id,type,stats_match_id_typestats_match_id4const1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Video/VideoService.php:109
0
0.220
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2907822') AND (`type` = 'cut') 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavailable_videorefstats_match_id,type,stats_match_id_typestats_match_id4const1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Video/VideoService.php:109
0
1.789
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id` 
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_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`shootout` IS NULL OR `shootout` = 0) AND (`time` BETWEEN 1
AND 1200) 
ORDER BY `time`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
0
1.152
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.*, `club`.`shortcut` AS `team`,
`player`.`name`, `player`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_team_id` = `team`.`id` 
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_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`from` BETWEEN 1 AND 1200) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const8Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEplayereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177
3
1.398
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id` 
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_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`shooting` = 1) AND (`shootout` IS NULL OR `shootout` = 0)
AND (`time` BETWEEN 1 AND 1200) 
ORDER BY `time`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
0
1.595
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id` 
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_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`shootout` IS NULL OR `shootout` = 0) AND (`time` BETWEEN
1201 AND 2400) 
ORDER BY `time`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
3
0.380
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.*, `club`.`shortcut` AS `team`,
`player`.`name`, `player`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_team_id` = `team`.`id` 
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_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`from` BETWEEN 1201 AND 2400) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const8Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEplayereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177
2
0.963
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id` 
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_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`shooting` = 1) AND (`shootout` IS NULL OR `shootout` = 0)
AND (`time` BETWEEN 1201 AND 2400) 
ORDER BY `time`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
0
1.410
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id` 
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_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`shootout` IS NULL OR `shootout` = 0) AND (`time` BETWEEN
2401 AND 3600) 
ORDER BY `time`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
1
0.424
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.*, `club`.`shortcut` AS `team`,
`player`.`name`, `player`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_team_id` = `team`.`id` 
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_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_penalty`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`from` BETWEEN 2401 AND 3600) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const8Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEplayereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177
3
1.265
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id` 
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_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id` 
WHERE (`stats_match_id` = 2907822) AND (`shooting` = 1) AND (`shootout` IS NULL OR `shootout` = 0)
AND (`time` BETWEEN 2401 AND 3600) 
ORDER BY `time`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
0
0.340
explain
SELECT `id`, `stats_competition_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2907822')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.283
explain
SELECT `id`, `stats_player_scorer_id`, `stats_player_assistant_primary_id`,
`stats_player_assistant_secondary_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = '2907822')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:58
4
0.219
explain
SELECT `id`, `datetime` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2907822')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.599
explain
SELECT `id`, `virtual` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7071)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionService.php:368
1
0.277
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`.`stats_previous_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_previous_competition`.`stats_previous_competition_id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_previous_competition`.`stats_competition_id` = 7071)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_previous_competitionreffk_stats_previous_competition_stats_competition1,fk_stats_previous_competition_stats_competition2fk_stats_previous_competition_stats_competition15const1Using where
1SIMPLEstats_competitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_previous_competition.stats_previous_competition_id1Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionService.php:374
0
0.181
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`id` IN (7071))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchPlayer/MatchPlayerFacade.php:64
1
8.238
explain
SELECT `stats_player_id`, SUM(`goals`) `goal`, SUM(`assistances`) `assistance` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` IN (7071)) AND
(`stats_player_id` IN (13766, 2219, 9032, 16240, 11411, 15476, 16240, 10315, 12581, 10438, 12978))
AND (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` < '2023-09-17 16:00:00') 
GROUP BY `stats_player_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchrefPRIMARY,datumcas,fk_stats_match_stats_competition1fk_stats_match_stats_competition15const364Using where; Using temporary; Using filesort
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14test_dev_nhlcz_s6_esports_cz.stats_match.id10Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:94
10
0.166
explain
SELECT `stats_team_home_id` AS `team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
10.103
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 828) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) AND
(`player`.`position` != 'GK') 
ORDER BY `position`, `player`.`surname`, `jersey`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchindex_mergestats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team14,41Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); Using where; Using temporary; Using filesort
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499
19
8.545
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`jersey`,
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id`, `gk`.`saves`,
`gk`.`lost_goals`, `gk`.`minutes_played`, `gk`.`time_on_ice`, `gk`.`saves` + `gk`.`lost_goals` AS
`shots_against`, `attended`, `penalties`, `assistances`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 828) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) AND
(`player`.`position` = 'GK') 
ORDER BY `gk`.`order` IS NULL, `gk`.`order`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchindex_mergestats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team14,41Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); Using where; Using temporary; Using filesort
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499
2
0.190
explain
SELECT `stats_team_guest_id` AS `team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
1.169
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) AND
(`player`.`position` != 'GK') 
ORDER BY `position`, `player`.`surname`, `jersey`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where; Using temporary; Using filesort
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499
19
1.122
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`jersey`,
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id`, `gk`.`saves`,
`gk`.`lost_goals`, `gk`.`minutes_played`, `gk`.`time_on_ice`, `gk`.`saves` + `gk`.`lost_goals` AS
`shots_against`, `attended`, `penalties`, `assistances`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) AND
(`player`.`position` = 'GK') 
ORDER BY `gk`.`order` IS NULL, `gk`.`order`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where; Using temporary; Using filesort
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499
2
0.371
explain
SELECT IF(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stadium_capacity`,
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stadium_capacity`, `club`.`capacity`) AS `capacity`,
`visitors`, `club`.`stadium_name` AS `stadium` 
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_club` AS `club` ON `team_home`.`stats_club_id` =
`club`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
1SIMPLEteam_homeconstPRIMARYPRIMARY4const1
1SIMPLEclubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:251
1
0.488
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38815))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_refereeconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467
1
0.148
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38771))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_refereeconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467
1
0.147
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38507))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_refereeconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467
1
0.255
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38524))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_refereeconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467
1
0.060
explain
SELECT `stats_team_home_id` AS `team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
6.955
explain
SELECT SUM(`gk`.`saves`) AS `saves`, SUM(`gk`.`lost_goals`) AS `lost` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 828) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) AND
(`player`.`position` = 'GK') 
GROUP BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchindex_mergestats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team14,41Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:310
1
7.061
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2907822) AND (`stats_team_id` = 828) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348
1
1.094
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2907822) AND (`stats_team_id` = 828) AND (`length` = 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368
1
1.871
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2907822) AND (`stats_team_id` = 828) AND (`length` != 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388
0
3.523
explain
SELECT SUM(`hits`) AS `hits`, SUM(`faceoffs`) AS `faceoffs`, SUM(`faceoffs_won`) AS `faceoffs_won`,
SUM(`blocks`) AS `blocks` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 828) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchindex_mergefk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team14,41Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:324
1
0.147
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
4
1.976
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2907822) AND (`stats_team_id` = 828) AND (`shooting` IS NULL OR `shooting`
= 0) AND (`shootout` IS NULL OR `shootout` = 0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalindex_mergefk_stats_goal_stats_match1,stats_team_idfk_stats_goal_stats_match1,stats_team_id5,41Using intersect(fk_stats_goal_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411
1
0.049
explain
SELECT `stats_team_guest_id` AS `team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.476
explain
SELECT SUM(`gk`.`saves`) AS `saves`, SUM(`gk`.`lost_goals`) AS `lost` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) AND
(`player`.`position` = 'GK') 
GROUP BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:310
1
0.252
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2907822) AND (`stats_team_id` = 12) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const8Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348
1
0.171
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2907822) AND (`stats_team_id` = 12) AND (`length` = 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const8Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368
1
0.189
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2907822) AND (`stats_team_id` = 12) AND (`length` != 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const8Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388
0
0.305
explain
SELECT SUM(`hits`) AS `hits`, SUM(`faceoffs`) AS `faceoffs`, SUM(`faceoffs_won`) AS `faceoffs_won`,
SUM(`blocks`) AS `blocks` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchreffk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1fk_stats_player_2_match_stats_match14const42Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:324
1
0.044
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const4Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
4
0.246
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2907822) AND (`stats_team_id` = 12) AND (`shooting` IS NULL OR `shooting`
= 0) AND (`shootout` IS NULL OR `shootout` = 0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1,stats_team_idfk_stats_goal_stats_match15const4Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411
3
0.176
explain
SELECT MAX(`period`) AS `max` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalkeeper_2_match_periodrefstats_match_id_stats_player_id_periodstats_match_id_stats_player_id_period4const8Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:79
1
0.042
explain
SELECT `stats_team_home_id` AS `team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
3.761
explain
SELECT `stats_player_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 828) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) AND
(`player`.`position` = 'GK')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchindex_mergestats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team14,41Using intersect(fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1); Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:155
2
1.492
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2907822) AND (`stats_player_id` IN (17213, 10084498)) AND (`period` > 0) 
GROUP BY `period`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalkeeper_2_match_periodrangestats_match_id_stats_player_id_period,stats_player_idstats_match_id_stats_player_id_period124Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142
3
0.050
explain
SELECT `stats_team_guest_id` AS `team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.475
explain
SELECT `stats_player_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2907822) AND
(`player`.`position` = 'GK')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:155
2
0.230
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2907822) AND (`stats_player_id` IN (10989, 18731)) AND (`period` > 0) 
GROUP BY `period`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalkeeper_2_match_periodrangestats_match_id_stats_player_id_period,stats_player_idstats_match_id_stats_player_id_period124Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142
3
0.227
explain
SELECT `id`, `period`, `score_guest`, `score_home` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = 2907822)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_match_periodrefstats_match_id_periodstats_match_id_period4const4
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:93
4
¤ ×

Front:Match:Overview:default

https://test.nhlcz.s6.esports.cz/zapas/2907822

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
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
yes Route zapas/<id \d+>[/<presenter>][/<action>] module = Match
presenter = Overview
action = default
Front Front:Match:Overview:default
id = 2907822
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 = zapas
id = 2907822
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\Match\OverviewPresenter::actionDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/OverviewPresenter.php:54

¤ ×