bahis siteleri

NHL.cz na Facebooku

  • Tipsport extraliga
  • 7.1.2024 17:00
  • 34. kolo
1 : 2
konec po prodloužení 1:0, 0:1, 0:0 - 0:1

Zápis o utkání

1. třetina

čas tým branky asistence typ gólu
02:04 KLA Deven SIDEROFF (7) Ondřej BLÁHA (3), Jiří TICHÁČEK (23) 5/5
Deven Sideroff, Ondřej Bláha, Jiří Ticháček, Jakub Babka, Tadeáš Hejda, Landon Bow
Christophe Lalancette, Aleš Jergl, Petr Kalina, Marek Zachar, Jeremie Blain, Jan Lukáš
čas tým vyloučení trest
03:22 KLA Jaromír JÁGR 2 min. hrubost
05:09 MHK Giorgio ESTEPHAN 2 min. hákování

2. třetina

čas tým branky asistence typ gólu
31:17 MHK Tomáš PAVELKA (7) Aleš JERGL (7) 5/4
Patrik Miškář, Oliver Okuliar, Tomáš Pavelka, Aleš Jergl, Jeremie Blain, Jan Lukáš
Antonín Melka, Tadeáš Hejda, Ondřej Slováček, Deven Sideroff, Landon Bow
čas tým vyloučení trest
26:24 KLA Tadeáš HEJDA 2 min. podražení
30:35 KLA Václav VEBER 2 min. krosček
36:01 MHK Alex TAMÁŠI 2 min. vysoká hůl
38:41 MHK David ŠŤASTNÝ 2 min. sekání

3. třetina

čas tým branky asistence typ gólu
Nebyla vstřelena žádná branka
čas tým vyloučení trest
50:05 MHK Bohumil JANK 2 min. hrubost
53:57 MHK Evan JASPER 2 min. nedovolené bránění

Prodloužení

čas tým branky asistence typ gólu
61:20 MHK Christophe LALANCETTE (7) GV Oliver OKULIAR (12) 3/3
Christophe Lalancette, Oliver Okuliar, Tomáš Pavelka, Jan Lukáš
Jakub Klepiš, Denis Kusý, Ondřej Slováček, Landon Bow
čas tým vyloučení trest
Nebylo žádné vyloučení

Soupisky

Rytíři Kladno

Č P Hráč G A B +/- S H BS BULY IT
96 O Tadeáš HEJDA 0 0 0 1 0 1 0 17:10
27 O Chris MARTENET 0 0 0 0 0 3 1 17:00
28 O Ondřej SLOVÁČEK 0 0 0 -1 0 0 3 22:07
26 O Jiří TICHÁČEK 0 1 1 1 1 1 0 24:25
5 O Václav VEBER 0 0 0 0 2 2 2 16:12
55 O Tomáš VORÁČEK 0 0 0 0 0 2 0 14:02
41 Ú Jakub BABKA 0 0 0 1 0 0 0 05:18
89 Ú Ondřej BLÁHA 0 1 1 1 1 0 0 100% 10:35
68 Ú Jaromír JÁGR 0 0 0 0 0 1 1 17:03
91 Ú Richard JARŮŠEK 0 0 0 0 0 1 0 0% 11:43
21 Ú Jakub KLEPIŠ 0 0 0 -1 3 0 1 53% 22:52
98 Ú Denis KUSÝ 0 0 0 -1 1 1 0 17:37
43 Ú Antonín MELKA 0 0 0 0 0 0 0 50% 13:14
23 Ú Martin PROCHÁZKA 0 0 0 0 0 4 0 100% 14:56
20 Ú Jaromír PYTLÍK 0 0 0 0 3 0 2 52% 23:12
97 Ú Deven SIDEROFF 1 0 1 1 2 0 0 100% 09:52
70 Ú Radek SMOLEŇÁK 0 0 0 0 3 1 0 17:43
34 Ú Eduards TRALMAKS 0 0 0 0 2 0 1 23:43
 
Č P Hráč ČAS Z G %Z A T
29 B Landon BOW 61:20 32 2 94.12 0 0
2 B David STAHL

Mountfield HK

Č P Hráč G A B +/- S H BS BULY IT
55 O Jeremie BLAIN 0 0 0 -1 0 0 3 21:10
17 O Ralfs FREIBERGS 0 0 0 0 0 0 0 19:00
72 O Bohumil JANK 0 0 0 0 4 2 3 18:10
29 O Petr KALINA 0 0 0 -1 0 1 2 22:02
19 O Tomáš PAVELKA 1 0 1 1 3 0 0 19:18
9 O Martin PLÁNĚK 0 0 0 0 5 0 2 18:31
15 Ú Jan EBERLE 0 0 0 0 3 1 0 09:27
88 Ú Giorgio ESTEPHAN 0 0 0 0 1 0 0 43% 16:50
71 Ú Matěj CHALUPA 0 0 0 0 0 0 0 04:23
46 Ú Evan JASPER 0 0 0 0 0 0 0 11:05
26 Ú Aleš JERGL 0 1 1 -1 3 0 0 100% 15:06
21 Ú Christophe LALANCETTE 1 0 1 0 4 0 0 50% 14:50
56 Ú Patrik MIŠKÁŘ 0 0 0 0 0 0 0 38% 20:32
8 Ú Oliver OKULIAR 0 1 1 1 4 1 0 16:09
94 Ú Jordann PERRET 0 0 0 0 0 0 1 15:06
62 Ú Radek PILAŘ 0 0 0 0 0 0 0 83% 13:08
92 Ú David ŠŤASTNÝ 0 0 0 0 4 0 1 14:46
25 Ú Alex TAMÁŠI 0 0 0 0 2 0 1 11% 12:43
69 Ú Marek ZACHAR 0 0 0 -1 1 0 1 09:56
Č P Hráč ČAS Z G %Z A T
31 B Jan LUKÁŠ 61:20 17 1 94.44 0 0
41 B Eetu LAURIKAINEN
44%
Počet diváků 2289 ČEZ Stadion 5200
Hlavní rozhodčí: Roman MrkvaPetr Úlehla
Čároví rozhodčí: Michal ZíkaPetr Šimánek
Střely po třetinách 6:6, 7:15, 4:11, 1:2
Vyloučení 3:5
Vyšší tresty 0:0
Využití 0:1
V oslabení 0:0
Střely na branku 18:34
Blokované střely 11:14
Zásahy brankářů 32:17
Hity 17:5
Trestné minuty 6:10
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: 72, time: 159.158 ms, default

Time msSQL QueryRows
0.072
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchRepository.php:17
0
3.704
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` = '2908832')
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_id5const1Using 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.095
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.062
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.047
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.226
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` = 5607427)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.163
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` = 15275)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.185
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` = '2908832')
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_id5const1Using 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.064
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.061
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.143
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (1711))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.165
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (1711))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.061
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.061
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.188
explain
SELECT `id`, `period`, `score_home`, `score_guest` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = '2908832') 
ORDER BY `period`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_match_periodrefstats_match_id_periodstats_match_id_period4const5Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/PeriodHelper.php:70
5
0.274
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` = '2908832')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.260
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2908832') 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.203
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2908832') 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.884
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` = 2908832) 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_match15const3Using 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.802
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` = 2908832) 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
2
1.161
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` = 2908832) 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_match15const3Using 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.126
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` = 2908832) 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_match15const3Using 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.578
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` = 2908832) 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
4
1.171
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` = 2908832) 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_match15const3Using 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.034
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` = 2908832) 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_match15const3Using 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
6.893
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` = 2908832) 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
2
0.938
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` = 2908832) 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_match15const3Using 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.856
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` = 2908832) AND (`shootout` IS NULL OR `shootout` = 0) AND (`time` > 3600) 
ORDER BY `time`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const3Using 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.409
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` = 2908832) AND (`from` > 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
0
0.786
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` = 2908832) AND (`shooting` = 1) AND (`shootout` IS NULL OR `shootout` = 0)
AND (`time` > 3600) 
ORDER BY `time`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const3Using 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.184
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` = '2908832')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.148
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` = '2908832')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const3Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:58
3
0.130
explain
SELECT `id`, `datetime` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908832')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.042
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.046
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.042
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
44.817
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 (5669947, 31281, 10081972, 12962, 14654, 318379, 10079544)) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` < '2024-01-07 17: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
7
0.180
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` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
8.271
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` = 2908832) 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
18
8.168
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` = 2908832) 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.184
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` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
11.032
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` = 1711) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908832) 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
6.801
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` = 1711) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908832) 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.294
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` = 2908832)
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.156
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38838))
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.135
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38649))
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.128
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38531))
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.050
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.046
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` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
7.515
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` = 2908832) 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
2.064
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908832) 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
2.068
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908832) 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
2.631
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908832) 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
4.242
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` = 2908832) 
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.159
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const3Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
3
0.274
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908832) AND (`stats_team_id` = 828) 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_match15const3Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411
1
0.046
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` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
5.138
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` = 1711) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908832) 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
2.699
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908832) AND (`stats_team_id` = 1711) 
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.388
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908832) AND (`stats_team_id` = 1711) 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.354
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908832) AND (`stats_team_id` = 1711) 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
5.218
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` = 1711) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908832) 
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.045
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const3Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
3
1.239
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908832) AND (`stats_team_id` = 1711) 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_match15const3Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411
2
0.171
explain
SELECT MAX(`period`) AS `max` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalkeeper_2_match_periodrefstats_match_id_stats_player_id_periodstats_match_id_stats_player_id_period4const10Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:79
1
0.064
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` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
7.595
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` = 2908832) 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.518
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908832) AND (`stats_player_id` IN (10084498, 18916)) 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_period125Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142
4
0.045
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` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
5.773
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` = 1711) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908832) 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
3.182
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908832) AND (`stats_player_id` IN (11905, 10109927)) 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_period125Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142
4
0.204
explain
SELECT `id`, `period`, `score_guest`, `score_home` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = 2908832)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_match_periodrefstats_match_id_periodstats_match_id_period4const5
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:93
5
¤ ×

Front:Match:Overview:default

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

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 = 2908832
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 = 2908832
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

¤ ×