bahis siteleri

NHL.cz na Facebooku

  • Tipsport extraliga
  • 12.1.2024 18:00
  • 35. kolo

Zápis o utkání

1. třetina

čas tým branky asistence typ gólu
14:27 OLO Dalibor ŘEZNÍČEK (5) Michal KUNC (10) 5/5
Rok Macuh, Michal Kunc, Dalibor Řezníček, Tomáš Černý, Jan Bambula, Branislav Konrád
Lukáš Kaňák, Jakub Kos, Jan Ščotka, Tomáš Marcinko, Kristián Pospíšil, Jan Kavan
19:53 KOM Martin ZAŤOVIČ (9) Lukáš CINGEL (12) 5/5
Martin Zaťovič, Lukáš Cingel, Jan Ščotka, Jakub Flek, Zach Osburn, Jan Kavan
Jakub Orsava, Lukáš Anděl, Jakub Sirota, Pavel Musil, Dalibor Řezníček, Branislav Konrád
čas tým vyloučení trest
04:09 OLO Jan BAMBULA 2 min. hákování

2. třetina

čas tým branky asistence typ gólu
32:00 KOM Jakub FLEK (9) Lukáš CINGEL (13) 5/5
Jakub Flek, Lukáš Cingel, Daniel Gazda, Jan Zahradníček, Martin Zaťovič, Jan Kavan
Lukáš Klimek, David Škůrek, Jan Švrček, Jan Bambula, Lukáš Anděl, Branislav Konrád
33:24 OLO Jakub NAVRÁTIL (11) Alex RAŠNER (7), Lukáš NAHODIL (7) 5/5
Alex Rašner, Jan Káňa, Dalibor Řezníček, Lukáš Nahodil, Jakub Navrátil, Branislav Konrád
Denis Svoboda, Marek Ďaloga, Petr Kratochvíl, Martin Kohout, Andrej Kollár, Jan Kavan
39:50 KOM Andrej KOLLÁR (1) Martin ZAŤOVIČ (9), Jakub FLEK (19) 5/4
Andrej Kollár, Martin Zaťovič, Jakub Flek, Jan Ščotka, Daniel Gazda, Jan Kavan
David Škůrek, Jan Švrček, Jan Bambula, Jan Knotek, Branislav Konrád
čas tým vyloučení trest
22:08 KOM Lukáš CINGEL 2 min. podražení
28:15 KOM Lukáš KAŇÁK 2 min. nedovolené bránění
34:02 KOM Tomáš MARCINKO 2 min. hrubost
34:02 OLO Jan KNOTEK 2 min. hrubost
39:40 OLO Dalibor ŘEZNÍČEK 2 min. držení

3. třetina

čas tým branky asistence typ gólu
57:21 KOM Andrej KOLLÁR (2) GV Jakub KOS (5) 5/5
Andrej Kollár, Jakub Flek, Jakub Kos, Jan Zahradníček, Lukáš Kaňák, Jan Kavan
Rok Macuh, Alex Rašner, Jan Bambula, Dalibor Řezníček, Tomáš Černý, Branislav Konrád
59:36 OLO Michal KUNC (9) Jakub NAVRÁTIL (13), Jakub ORSAVA (8) 5/3
Jakub Navrátil, Rok Macuh, Lukáš Klimek, Michal Kunc, Jakub Sirota, Jakub Orsava
Lukáš Cingel, Marek Ďaloga, Jan Ščotka, Jan Kavan
čas tým vyloučení trest
51:55 KOM Kristián POSPÍŠIL 2 min. hrubost
51:55 OLO Jan KÁŇA 2 min. sekání
53:55 OLO Jan KÁŇA 2 min. hrubost
55:08 KOM Jakub KOS 2 min. podražení
55:19 KOM Lukáš CINGEL 2 min. hrubost
55:19 OLO Dalibor ŘEZNÍČEK 2 min. nedovolené bránění
55:19 OLO Silvester KUSKO 2 min. nesportovní chování
58:13 KOM Jan ZAHRADNÍČEK 2 min. sekání
58:34 KOM Jakub FLEK 2 min. vysoká hůl

Soupisky

HC Kometa Brno

Č P Hráč G A B +/- S H BS BULY IT
8 O Marek ĎALOGA 0 0 0 -1 3 1 2 20:57
43 O Daniel GAZDA 0 0 0 1 0 0 0 18:31
24 O Lukáš KAŇÁK 0 0 0 0 0 0 0 11:58
2 O Zach OSBURN 0 0 0 1 2 1 2 22:29
91 O Denis SVOBODA 0 0 0 -1 1 0 0 02:27
23 O Jan ŠČOTKA 0 0 0 0 1 0 4 25:19
13 O Jan ZAHRADNÍČEK 0 0 0 2 0 0 3 14:15
6 Ú Lukáš CINGEL 0 2 2 2 0 0 0 69% 15:13
9 Ú Jakub FLEK 1 1 2 3 5 0 1 16:06
92 Ú Petr HOLÍK 0 0 0 0 4 0 0 70% 15:50
64 Ú Martin KOHOUT 0 0 0 -1 0 0 2 06:33
72 Ú Andrej KOLLÁR 2 0 2 0 4 0 1 50% 13:18
15 Ú Jakub KOS 0 1 1 0 0 0 0 14:17
21 Ú Petr KRATOCHVÍL 0 0 0 -1 1 0 0 06:50
65 Ú Tomáš MARCINKO 0 0 0 -1 1 0 0 38% 19:03
89 Ú Steve MOSES 0 0 0 0 3 1 0 16:28
94 Ú Zdeněk OKÁL 0 0 0 0 2 1 1 15:31
88 Ú Kristián POSPÍŠIL 0 0 0 -1 1 0 0 16:10
26 Ú Martin ZAŤOVIČ 1 1 2 2 3 0 0 100% 15:22
Č P Hráč ČAS Z G %Z A T
1 B Jan KAVAN 60:00 29 3 90.63 0 0
29 B Štěpán LUKEŠ

HC Olomouc

Č P Hráč G A B +/- S H BS BULY IT
48 O Tomáš ČERNÝ 0 0 0 0 2 0 1 10:35
23 O Jiří ONDRUŠEK 0 0 0 0 3 0 2 19:43
27 O Alex RAŠNER 0 1 1 0 4 0 1 14:18
14 O Dalibor ŘEZNÍČEK 1 0 1 0 1 0 0 18:41
2 O Jakub SIROTA 0 0 0 -1 1 0 0 17:01
3 O David ŠKŮREK 0 0 0 -1 0 0 2 16:28
51 O Jan ŠVRČEK 0 0 0 -1 2 0 1 16:43
24 Ú Lukáš ANDĚL 0 0 0 -2 1 0 1 53% 14:36
72 Ú Jan BAMBULA 0 0 0 -1 0 0 2 17:46
9 Ú Jan KÁŇA 0 0 0 1 2 1 0 13:27
61 Ú Lukáš KLIMEK 0 0 0 -1 2 0 0 14:26
12 Ú Jan KNOTEK 0 0 0 0 1 0 0 42% 13:55
22 Ú Michal KUNC 1 1 2 1 3 1 0 17:30
91 Ú Silvester KUSKO 0 0 0 0 1 0 0 0% 18:14
47 Ú Rok MACUH 0 0 0 0 2 0 0 50% 19:27
87 Ú Pavel MUSIL 0 0 0 -1 0 0 1 05:25
19 Ú Lukáš NAHODIL 0 1 1 1 1 0 0 20% 16:00
88 Ú Jakub NAVRÁTIL 1 1 2 1 4 0 0 16:09
32 Ú Jakub ORSAVA 0 1 1 -1 2 0 1 13:23
Č P Hráč ČAS Z G %Z A T
42 B Branislav KONRÁD 57:54 27 4 87.10 0 0
1 B Marian MÜNCH
87%
Počet diváků 6686 Winning Group Arena 7700
Hlavní rozhodčí: Pavel ObadalFilip Vrba
Čároví rozhodčí: Michal AxmanVladimír Rožánek
Střely po třetinách 11:5, 8:14, 12:13
Vyloučení 8:7
Vyšší tresty 0:0
Využití 1:1
V oslabení 0:0
Střely na branku 31:32
Blokované střely 16:12
Zásahy brankářů 29:27
Hity 4:2
Trestné minuty 16:14
Tisk
RSS | Kontakt | Všeobecné obchodní podmínky a pravidla | Cookies | Nastavení soukromí | Reklama - Provozovatel BPA sport marketing a.s. ve spolupráci s eSports, s.r.o.

ISSN 1214-5718 | dotazy na redakci: redakce@nhl.cz, obchod/reklama: obchod@hokej.cz, technický provoz: webmaster@hokej.cz

© Copyright - Všechna loga a známky NHL, loga a známky týmů NHL, jakožto další vlastnické materiály včetně log konferencí a obrázků Stanley Cupu jsou vlastnictvím NHL, NHL Enterprises, L.P. a příslušných týmů. © NHL Enterprises, L.P. Všechna práva vyhrazena.

 

Queries: 70, time: 127.793 ms, default

Time msSQL QueryRows
0.088
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchRepository.php:17
0
1.400
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` = '2908841')
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.160
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.152
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.125
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.136
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` = 10098724)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.117
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` = 31781)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
23.583
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`match_bet`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`match_bet` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` 
WHERE (DATE(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime`) = CURDATE()) AND
(`league`.`code` = 'nhl') AND (`test_dev_nhlcz_s6_esports_cz`.`match_bet`.`stats_match_id` IS NOT
NULL) 
LIMIT 100
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEleagueconstPRIMARY,codecode768const1Using index
1SIMPLEcompetitionrefPRIMARY,league_idleague_id5const273Using where; Using index
1SIMPLEstats_matchrefPRIMARY,fk_stats_match_stats_competition1fk_stats_match_stats_competition15test_dev_nhlcz_s6_esports_cz.competition.id21Using where
1SIMPLEmatch_betrefPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_match.id1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/presenters/BasePresenter.php:112
0
0.168
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` = '2908841')
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.291
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (22))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34
1
0.150
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (22))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34
1
0.199
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (24))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.152
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (24))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.073
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.050
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.823
explain
SELECT `id`, `period`, `score_home`, `score_guest` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = '2908841') 
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.171
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` = '2908841')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.170
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2908841') 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.165
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2908841') 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
12.967
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` = 2908841) 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_match15const7Using 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.756
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` = 2908841) AND (`from` BETWEEN 1 AND 1200) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const15Using 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.883
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` = 2908841) 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_match15const7Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
0
1.856
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_goal`.*, `club`.`shortcut` AS `team`, `scorer`.`name`,
`scorer`.`surname`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `assistant_primary`.`name` AS
`primary_name`, `assistant_primary`.`surname` AS `primary_surname`, `country_primary`.`name` AS
`primary_country`, `country_primary`.`code` AS `primary_country_code`, `assistant_secondary`.`name`
AS `secondary_name`, `assistant_secondary`.`surname` AS `secondary_surname`,
`country_secondary`.`name` AS `secondary_country`, `country_secondary`.`code` AS
`secondary_country_code`, `player_positive1`.`name` AS `positive1_name`,
`player_positive1`.`surname` AS `positive1_surname`, `player_positive2`.`name` AS `positive2_name`,
`player_positive2`.`surname` AS `positive2_surname`, `player_positive3`.`name` AS `positive3_name`,
`player_positive3`.`surname` AS `positive3_surname`, `player_positive4`.`name` AS `positive4_name`,
`player_positive4`.`surname` AS `positive4_surname`, `player_positive5`.`name` AS `positive5_name`,
`player_positive5`.`surname` AS `positive5_surname`, `player_positive_goalkeeper`.`name` AS
`positive_goalkeeper_name`, `player_positive_goalkeeper`.`surname` AS `positive_goalkeeper_surname`,
`player_negative1`.`name` AS `negative1_name`, `player_negative1`.`surname` AS `negative1_surname`,
`player_negative2`.`name` AS `negative2_name`, `player_negative2`.`surname` AS `negative2_surname`,
`player_negative3`.`name` AS `negative3_name`, `player_negative3`.`surname` AS `negative3_surname`,
`player_negative4`.`name` AS `negative4_name`, `player_negative4`.`surname` AS `negative4_surname`,
`player_negative5`.`name` AS `negative5_name`, `player_negative5`.`surname` AS `negative5_surname`,
`player_negative_goalkeeper`.`name` AS `negative_goalkeeper_name`,
`player_negative_goalkeeper`.`surname` AS `negative_goalkeeper_surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON `team`.`stats_club_id` =
`club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `scorer` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_scorer_id` = `scorer`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `scorer`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_primary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_primary_id` =
`assistant_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_primary` ON
`assistant_primary`.`country_id` = `country_primary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `assistant_secondary` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_assistant_secondary_id` =
`assistant_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` AS `country_secondary` ON
`assistant_secondary`.`country_id` = `country_secondary`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive1_id` = `player_positive1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive2_id` = `player_positive2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive3_id` = `player_positive3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive4_id` = `player_positive4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive5_id` = `player_positive5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_positive_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_positive_goalkeeper_id` =
`player_positive_goalkeeper`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative1` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative1_id` = `player_negative1`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative2` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative2_id` = `player_negative2`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative3` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative3_id` = `player_negative3`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative4` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative4_id` = `player_negative4`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative5` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative5_id` = `player_negative5`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player_negative_goalkeeper` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goal`.`stats_player_negative_goalkeeper_id` =
`player_negative_goalkeeper`.`id` 
WHERE (`stats_match_id` = 2908841) 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_match15const7Using 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.569
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` = 2908841) AND (`from` BETWEEN 1201 AND 2400) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const15Using 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
5
1.001
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` = 2908841) 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_match15const7Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEscorereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_scorer_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.scorer.country_id1
1SIMPLEassistant_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_primary_id1
1SIMPLEcountry_primaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_primary.country_id1
1SIMPLEassistant_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_assistant_secondary_id1
1SIMPLEcountry_secondaryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.assistant_secondary.country_id1
1SIMPLEplayer_positive1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive1_id1
1SIMPLEplayer_positive2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive2_id1
1SIMPLEplayer_positive3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive3_id1
1SIMPLEplayer_positive4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive4_id1
1SIMPLEplayer_positive5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive5_id1
1SIMPLEplayer_positive_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_positive_goalkeeper_id1
1SIMPLEplayer_negative1eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative1_id1
1SIMPLEplayer_negative2eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative2_id1
1SIMPLEplayer_negative3eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative3_id1
1SIMPLEplayer_negative4eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative4_id1
1SIMPLEplayer_negative5eq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative5_id1
1SIMPLEplayer_negative_goalkeepereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_goal.stats_player_negative_goalkeeper_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:595
0
1.133
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` = 2908841) 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_match15const7Using 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.824
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` = 2908841) AND (`from` BETWEEN 2401 AND 3600) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const15Using 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
9
1.223
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` = 2908841) 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_match15const7Using 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.167
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` = '2908841')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.177
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` = '2908841')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const7Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:58
7
0.158
explain
SELECT `id`, `datetime` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908841')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.146
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.187
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.159
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
46.502
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 (6886, 19881, 17397, 19881, 10098724, 6886, 17397, 10098724, 10082389, 11223,
30611, 31781, 14657, 9949, 30611, 31781, 12797)) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` < '2024-01-12 18:00:00') 
GROUP BY `stats_player_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchrefPRIMARY,datumcas,fk_stats_match_stats_competition1fk_stats_match_stats_competition15const364Using where; Using temporary; Using filesort
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14test_dev_nhlcz_s6_esports_cz.stats_match.id10Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:94
11
0.167
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` = 2908841)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
1.420
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` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 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.568
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` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 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.146
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` = 2908841)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
4.553
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` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 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.631
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` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 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.189
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` = 2908841)
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.282
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38572))
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.144
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38573))
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 (38586))
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.125
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38540))
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.042
explain
SELECT `stats_team_home_id` AS `team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = 2908841)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.383
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` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 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
1.813
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908841) AND (`stats_team_id` = 22) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348
1
2.044
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908841) AND (`stats_team_id` = 22) AND (`length` = 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368
1
1.823
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908841) AND (`stats_team_id` = 22) AND (`length` != 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388
0
0.251
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` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 
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.150
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908841)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const7Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
7
1.527
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908841) AND (`stats_team_id` = 22) AND (`shooting` IS NULL OR `shooting`
= 0) AND (`shootout` IS NULL OR `shootout` = 0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalindex_mergefk_stats_goal_stats_match1,stats_team_idfk_stats_goal_stats_match1,stats_team_id5,41Using intersect(fk_stats_goal_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411
4
0.048
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` = 2908841)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.626
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` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 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
4.754
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908841) AND (`stats_team_id` = 24) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348
1
1.821
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908841) AND (`stats_team_id` = 24) AND (`length` = 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368
1
1.917
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908841) AND (`stats_team_id` = 24) AND (`length` != 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyindex_mergefk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match1,stats_team_id5,41Using intersect(fk_stats_penalty_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388
0
0.284
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` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 
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.047
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908841)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const7Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
7
2.117
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908841) AND (`stats_team_id` = 24) AND (`shooting` IS NULL OR `shooting`
= 0) AND (`shootout` IS NULL OR `shootout` = 0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalindex_mergefk_stats_goal_stats_match1,stats_team_idfk_stats_goal_stats_match1,stats_team_id5,41Using intersect(fk_stats_goal_stats_match1,stats_team_id); Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:411
3
0.438
explain
SELECT MAX(`period`) AS `max` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908841)
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.076
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` = 2908841)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.377
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` = 22) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 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.285
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908841) AND (`stats_player_id` IN (10093587, 15242)) 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.058
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` = 2908841)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.393
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` = 24) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908841) 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.015
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908841) AND (`stats_player_id` IN (32651, 10083816)) 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.251
explain
SELECT `id`, `period`, `score_guest`, `score_home` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = 2908841)
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/2908841

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

¤ ×