bahis siteleri

NHL.cz na Facebooku

  • Tipsport extraliga
  • 23.1.2024 17:30
  • 39. kolo

Zápis o utkání

1. třetina

čas tým branky asistence typ gólu
10:37 MBL David DVOŘÁČEK (2) Aleš ČECH (6), Tomáš PITULE (1) 5/5
David Dvořáček, Aleš Čech, Tomáš Pitule, Filip Pavlík, Joachim Rohdin, Jan Růžička
David Němeček, Tomáš Tomek, Miroslav Forman, Michal Vitouch, Jan Buchtele, Oldřich Cichoň
12:27 MBL Joachim ROHDIN (3) Petr GEWIESE (4), Sebastián MALÁT (6) 5/5
Joachim Rohdin, Petr Gewiese, Sebastián Malát, Matti Järvinen, Filip Pavlík, Jan Růžička
Michael Krutil, Vladimír Sobotka, Michal Řepík, Pavel Kousal, Michal Kempný, Oldřich Cichoň
čas tým vyloučení trest
18:05 SPA Miroslav FORMAN 2 min. krosček

2. třetina

čas tým branky asistence typ gólu
35:03 SPA Roman HORÁK (14) Miroslav FORMAN (8), Michal ŘEPÍK (18) 5/4
Miroslav Forman, Michal Řepík, Roman Horák, Filip Chlapík, Michal Kempný, Oldřich Cichoň
Filip Pavlík, Pavol Skalický, Tomáš Fořt, Petr Gewiese, Jan Růžička
36:02 MBL Ondřej ROHLÍK (1) GV Ondřej ROMAN (9), Sebastián MALÁT (7) 5/5
Ondřej Rohlík, Ondřej Roman, Alex Lintuniemi, David Bernad, Sebastián Malát, Jan Růžička
Michal Vitouch, Jakub Krejčík, Michal Moravčík, Pavel Kousal, Petr Hauser, Oldřich Cichoň
39:59 SPA Roman HORÁK (15) Michal ŘEPÍK (19), Filip CHLAPÍK (21) 5/5
Roman Horák, Filip Chlapík, Michal Řepík, Michal Kempný, Miroslav Forman, Oldřich Cichoň
Adam Jánošík, Alex Lintuniemi, Filip Pyrochta, Matti Järvinen, Joachim Rohdin, Jan Růžička
čas tým vyloučení trest
33:49 MBL Ondřej ROMAN 2 min. hákování
37:50 MBL Filip PYROCHTA 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
45:30 SPA Tomáš TOMEK 2 min. podražení
48:06 SPA Pavel KOUSAL 2 min. hákování
51:50 SPA Michael KRUTIL 2 min. nedovolené bránění

Soupisky

BK Mladá Boleslav

Č P Hráč G A B +/- S H BS BULY IT
17 O David BERNAD 0 0 0 1 0 0 3 11:25
5 O Aleš ČECH 0 1 1 1 0 0 1 10:42
44 O Petr GEWIESE 0 1 1 1 1 0 2 19:25
3 O Adam JÁNOŠÍK 0 0 0 -1 2 0 3 16:05
10 O Alex LINTUNIEMI 0 0 0 0 0 0 1 19:47
45 O Filip PAVLÍK 0 0 0 2 0 1 5 21:19
24 O Filip PYROCHTA 0 0 0 -1 2 1 2 20:22
21 Ú David DVOŘÁČEK 1 0 1 1 2 0 0 13:22
12 Ú Tomáš FOŘT 0 0 0 0 2 0 1 69% 21:33
9 Ú Vojtěch HRADEC 0 0 0 0 1 0 0 07:47
71 Ú Matti JÄRVINEN 0 0 0 0 1 0 0 67% 16:49
82 Ú Sebastián MALÁT 0 2 2 2 0 0 0 19:04
20 Ú Tomáš PITULE 0 1 1 1 1 0 1 33% 08:34
75 Ú Joachim ROHDIN 1 0 1 1 2 0 2 17:55
18 Ú Ondřej ROHLÍK 1 0 1 1 3 0 0 17:28
23 Ú Ondřej ROMAN 0 1 1 1 0 0 0 60% 17:01
28 Ú Pavol SKALICKÝ 0 0 0 0 1 0 1 19:44
55 Ú Tomáš ŠMERHA 0 0 0 0 0 0 0 10:40
49 Ú Jan ZÁVORA 0 0 0 0 0 0 1 05:38
Č P Hráč ČAS Z G %Z A T
33 B Jan RŮŽIČKA 60:00 33 2 94.29 0 0
35 B Filip NOVOTNÝ

HC Sparta Praha

Č P Hráč G A B +/- S H BS BULY IT
24 O Aaron IRVING 0 0 0 0 2 0 1 20:44
6 O Michal KEMPNÝ 0 0 0 0 0 0 1 24:19
36 O Jakub KREJČÍK 0 0 0 -1 2 0 1 18:15
5 O Michael KRUTIL 0 0 0 -1 0 0 1 11:07
73 O Michal MORAVČÍK 0 0 0 -1 2 0 0 20:25
77 O David NĚMEČEK 0 0 0 -1 0 1 0 17:36
33 O Tomáš TOMEK 0 0 0 -1 1 0 0 33% 08:23
47 Ú Jan BUCHTELE 0 0 0 -1 2 1 0 13:44
88 Ú Miroslav FORMAN 0 1 1 0 5 0 0 18:47
93 Ú Petr HAUSER 0 0 0 -1 2 0 0 10:26
51 Ú Roman HORÁK 2 0 2 1 2 1 1 53% 22:43
14 Ú Filip CHLAPÍK 0 1 1 1 4 1 0 100% 20:47
23 Ú Pavel KOUSAL 0 0 0 -2 4 0 0 16:23
97 Ú Radek MUŽÍK 0 0 0 0 2 0 0 08:49
46 Ú Ondřej NAJMAN 0 0 0 0 2 0 0 33% 16:48
26 Ú Michal ŘEPÍK 0 2 2 0 2 0 0 0% 18:53
71 Ú Vladimír SOBOTKA 0 0 0 -1 1 0 0 0% 06:29
28 Ú Michal VITOUCH 0 0 0 -2 1 0 0 40% 11:00
55 Ú Jakub ŽMOLA 0 0 0 0 1 0 0 25% 06:42
Č P Hráč ČAS Z G %Z A T
29 B Oldřich CICHOŇ 57:42 15 3 83.33 0 0
32 B Josef KOŘENÁŘ
71%
Počet diváků 2970 ŠKOENERGO Aréna 4200
Hlavní rozhodčí: Petr ÚlehlaJakub Šindel
Čároví rozhodčí: Miroslav LhotskýStanislav Hnát
Střely po třetinách 8:8, 7:18, 3:9
Vyloučení 2:4
Vyšší tresty 0:0
Využití 0:1
V oslabení 0:0
Střely na branku 18:35
Blokované střely 23:5
Zásahy brankářů 33:15
Hity 2:4
Trestné minuty 4:8
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: 69, time: 107.964 ms, default

Time msSQL QueryRows
0.076
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchRepository.php:17
0
2.392
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` = '2908867')
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.237
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.077
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.066
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.038
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` = 15662)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.201
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` = 10339)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.199
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` = '2908867')
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.051
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (89))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34
1
0.032
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (89))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34
1
0.248
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (8))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.143
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (8))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.063
explain
SELECT `id`, `league_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`id` IN (7071))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:45
1
0.064
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.567
explain
SELECT `id`, `period`, `score_home`, `score_guest` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = '2908867') 
ORDER BY `period`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_match_periodrefstats_match_id_periodstats_match_id_period4const4Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/PeriodHelper.php:70
4
0.238
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` = '2908867')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.201
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2908867') 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.157
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2908867') 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.562
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` = 2908867) 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_match15const5Using 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
2
0.916
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` = 2908867) AND (`from` BETWEEN 1 AND 1200) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const6Using 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
1
0.723
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` = 2908867) 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_match15const5Using 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.921
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` = 2908867) 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_match15const5Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
3
0.298
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` = 2908867) AND (`from` BETWEEN 1201 AND 2400) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const6Using 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.716
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` = 2908867) 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_match15const5Using 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.612
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` = 2908867) 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_match15const5Using 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.366
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` = 2908867) AND (`from` BETWEEN 2401 AND 3600) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const6Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEplayereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177
3
0.795
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` = 2908867) 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_match15const5Using 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.154
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` = '2908867')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.173
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` = '2908867')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const5Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:58
5
0.131
explain
SELECT `id`, `datetime` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908867')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.063
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.042
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.060
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
73.899
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 (12539, 10083954, 10181, 10104093, 12268, 10079113, 1902370, 8810, 10079113,
10339, 10560, 8701, 10339, 8701, 15568)) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` < '2024-01-23 17:30: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
12
0.257
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` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.875
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` = 89) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) AND
(`player`.`position` != 'GK') 
ORDER BY `position`, `player`.`surname`, `jersey`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where; Using temporary; Using filesort
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499
19
1.319
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` = 89) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) AND
(`player`.`position` = 'GK') 
ORDER BY `gk`.`order` IS NULL, `gk`.`order`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where; Using temporary; Using filesort
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499
2
0.157
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` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
4.494
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` = 8) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) AND
(`player`.`position` != 'GK') 
ORDER BY `position`, `player`.`surname`, `jersey`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where; Using temporary; Using filesort
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499
19
0.700
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` = 8) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) AND
(`player`.`position` = 'GK') 
ORDER BY `gk`.`order` IS NULL, `gk`.`order`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where; Using temporary; Using filesort
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:499
2
0.552
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` = 2908867)
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.126
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.138
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38497))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_refereeconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467
1
0.147
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38510))
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.143
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38518))
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.067
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` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.537
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` = 89) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) AND
(`player`.`position` = 'GK') 
GROUP BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:310
1
0.305
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908867) AND (`stats_team_id` = 89) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const6Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348
1
0.179
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908867) AND (`stats_team_id` = 89) AND (`length` = 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const6Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368
1
0.220
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908867) AND (`stats_team_id` = 89) AND (`length` != 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const6Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388
0
0.321
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` = 89) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchreffk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1fk_stats_player_2_match_stats_match14const42Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:324
1
0.186
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const5Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
5
0.284
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908867) AND (`stats_team_id` = 89) 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_match15const5Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411
3
0.066
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` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.539
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` = 8) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) AND
(`player`.`position` = 'GK') 
GROUP BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:310
1
3.560
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908867) AND (`stats_team_id` = 8) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const6Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348
1
0.163
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908867) AND (`stats_team_id` = 8) AND (`length` = 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const6Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368
1
0.183
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908867) AND (`stats_team_id` = 8) AND (`length` != 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const6Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388
0
0.290
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` = 8) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchreffk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1fk_stats_player_2_match_stats_match14const42Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:324
1
0.042
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const5Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
5
2.204
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908867) AND (`stats_team_id` = 8) 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_match15const5Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411
2
0.395
explain
SELECT MAX(`period`) AS `max` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalkeeper_2_match_periodrefstats_match_id_stats_player_id_periodstats_match_id_stats_player_id_period4const8Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:79
1
0.067
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` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.432
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` = 89) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) AND
(`player`.`position` = 'GK')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:155
2
0.563
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908867) AND (`stats_player_id` IN (15662, 11407)) AND (`period` > 0) 
GROUP BY `period`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalkeeper_2_match_periodrangestats_match_id_stats_player_id_period,stats_player_idstats_match_id_stats_player_id_period124Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142
3
0.062
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` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.398
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` = 8) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908867) AND
(`player`.`position` = 'GK')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:155
2
1.331
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908867) AND (`stats_player_id` IN (10081891, 18658)) AND (`period` > 0) 
GROUP BY `period`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalkeeper_2_match_periodrangestats_match_id_stats_player_id_period,stats_player_idstats_match_id_stats_player_id_period124Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142
3
0.181
explain
SELECT `id`, `period`, `score_guest`, `score_home` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = 2908867)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_match_periodrefstats_match_id_periodstats_match_id_period4const4
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:93
4
¤ ×

Front:Match:Overview:default

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

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

¤ ×