bahis siteleri

NHL.cz na Facebooku

  • Tipsport extraliga
  • 14.2.2024 18:00
  • 44. kolo

Zápis o utkání

1. třetina

čas tým branky asistence typ gólu
01:22 PCE Jan KOŠŤÁLEK (5) Tomáš ZOHORNA (19), Robert KOUSAL (28) 5/5
Jan Košťálek, Tomáš Zohorna, Robert Kousal, Lukáš Radil, Tomáš Dvořák, Roman Will
Juraj Mikuš, Marcel Barinka, Mario Grman, Patrik Zdráhal, Petr Fridrich, Lukáš Klimeš
06:41 PCE Adam MUSIL (5) Ondřej VÁLA (8), Tomáš HYKA (21) 5/5
Adam Musil, Ondřej Vála, Tomáš Hyka, Jan Kolář, Richard Pánik, Roman Will
Jakub Kotala, Matěj Prčík, Petr Chlán, Yohann Auvitu, Dominik Lakatoš, Lukáš Klimeš
čas tým vyloučení trest
16:49 VIT Petr CHLÁN 2 min. vysoká hůl
19:52 VIT Marcel BARINKA 2 min. podražení

2. třetina

čas tým branky asistence typ gólu
20:12 PCE Tomáš ZOHORNA (5) Robert KOUSAL (29) 5/4
Tomáš Zohorna, Robert Kousal, Jan Košťálek, Adam Musil, Matej Paulovič, Roman Will
Petr Fridrich, Petr Chlán, Juraj Mikuš, Mario Grman, Lukáš Klimeš
23:38 PCE Martin ŠVEC (1) GV Tomáš HYKA (22), Adam MUSIL (6) 5/5
Martin Švec, Tomáš Hyka, Adam Musil, Richard Pánik, Ondřej Vála, Roman Will
Rihards Bukarts, Patrik Zdráhal, Stuart Thomas Percy, Willie Raskob, Valentin Claireaux, Lukáš Klimeš
24:33 VIT Marcel BARINKA (8) Petr FRIDRICH (8), Patrik ZDRÁHAL (11) 5/5
Matěj Prčík, Yohann Auvitu, Marcel Barinka, Patrik Zdráhal, Petr Fridrich, Matěj Machovský
Robert Říčka, Tomáš Dvořák, Lukáš Radil, Matej Paulovič, Jan Košťálek, Roman Will
26:40 PCE Adam MUSIL (6) Tomáš HYKA (23) 5/5
Adam Musil, Tomáš Hyka, David Musil, Libor Hájek, Richard Pánik, Roman Will
Tomáš Šoustal, Mario Grman, Matěj Prčík, Rihards Bukarts, Valentin Claireaux, Matěj Machovský
28:54 VIT Roberts BUKARTS (12) Yohann AUVITU (8), Peter KRIEGER (8) 5/5
Roberts Bukarts, Jonáš Peterek, Peter Krieger, Yohann Auvitu, Matěj Prčík, Matěj Machovský
Tomáš Vondráček, Patrik Poulíček, Jan Mandát, Libor Hájek, David Musil, Roman Will
29:42 VIT Valentin CLAIREAUX (2) Rihards BUKARTS (3) 5/5
Rihards Bukarts, Willie Raskob, Valentin Claireaux, Patrik Zdráhal, Stuart Thomas Percy, Matěj Machovský
Richard Pánik, Tomáš Dvořák, Adam Musil, Tomáš Hyka, Jan Košťálek, Roman Will
čas tým vyloučení trest
Nebylo žádné vyloučení

Soupisky

HC Dynamo Pardubice

Č P Hráč G A B +/- S H BS BULY IT
7 O Tomáš DVOŘÁK 0 0 0 -1 0 0 6 21:10
24 O Libor HÁJEK 0 0 0 0 3 1 0 18:19
29 O Jan KOLÁŘ 0 0 0 1 0 0 1 19:26
33 O Jan KOŠŤÁLEK 1 0 1 -1 2 0 0 20:50
8 O David MUSIL 0 0 0 0 1 0 0 17:57
12 O Martin ŠVEC 1 0 1 1 1 0 0 01:32
14 O Ondřej VÁLA 0 1 1 2 1 0 0 17:32
38 Ú Tomáš HYKA 0 3 3 2 1 0 0 14:47
90 Ú Robert KOUSAL 0 2 2 1 2 0 0 16:07
89 Ú Jan MANDÁT 0 0 0 -1 1 0 0 15:18
11 Ú Adam MUSIL 2 1 3 2 3 0 0 40% 15:03
28 Ú Richard PÁNIK 0 0 0 2 2 2 0 0% 15:02
67 Ú Matej PAULOVIČ 0 0 0 -1 0 0 0 22% 13:59
44 Ú Patrik POULÍČEK 0 0 0 -1 3 0 1 47% 15:52
69 Ú Lukáš RADIL 0 0 0 0 1 0 2 17:54
71 Ú Ondřej ROHLÍK 0 0 0 0 0 0 0 11:18
62 Ú Robert ŘÍČKA 0 0 0 -1 3 0 0 15:43
55 Ú Tomáš VONDRÁČEK 0 0 0 -1 0 0 0 14:14
79 Ú Tomáš ZOHORNA 1 1 2 1 3 0 0 29% 17:13
Č P Hráč ČAS Z G %Z A T
22 B Roman WILL 60:00 20 3 86.96 0 0
39 B Dominik PAVLÁT

HC VÍTKOVICE RIDERA

Č P Hráč G A B +/- S H BS BULY IT
81 O Yohann AUVITU 0 1 1 1 2 0 2 20:36
7 O Mario GRMAN 0 0 0 -2 0 0 1 17:47
17 O Radek JEŘÁBEK
2 O Juraj MIKUŠ 0 0 0 -1 1 0 2 19:03
43 O Stuart Thomas PERCY 0 0 0 0 1 0 2 21:07
24 O Matěj PRČÍK 0 0 0 0 0 1 2 20:45
22 O Willie RASKOB 0 0 0 0 1 0 1 20:04
91 Ú Marcel BARINKA 1 0 1 0 1 0 0 47% 16:17
13 Ú Rihards BUKARTS 0 1 1 -1 1 1 0 14:50
71 Ú Roberts BUKARTS 1 0 1 1 2 0 1 15:27
28 Ú Valentin CLAIREAUX 1 0 1 -1 1 0 0 79% 14:25
12 Ú Petr FRIDRICH 0 1 1 0 2 0 1 15:14
15 Ú Petr CHLÁN 0 0 0 -1 1 0 1 70% 14:52
72 Ú Jakub KOTALA 0 0 0 -1 2 1 2 13:35
26 Ú Peter KRIEGER 0 1 1 1 0 0 0 57% 14:41
31 Ú Dominik LAKATOŠ 0 0 0 -1 3 0 1 15:02
95 Ú Jonáš PETEREK 0 0 0 1 3 0 1 100% 14:39
41 Ú Tomáš ŠOUSTAL 0 0 0 -1 1 1 0 13:52
25 Ú Patrik ZDRÁHAL 0 1 1 0 1 0 0 15:32
Č P Hráč ČAS Z G %Z A T
33 B Lukáš KLIMEŠ 23:38 8 4 66.67 0 0
35 B Matěj MACHOVSKÝ 35:28 14 1 93.33 0 0
84%
Počet diváků 8592 enteria arena 10194
Hlavní rozhodčí: Antonín JeřábekPeter Stano
Čároví rozhodčí: Jakub FrodlJosef Špůr
Střely po třetinách 8:7, 14:6, 5:10
Vyloučení 0:2
Vyšší tresty 0:0
Využití 1:0
V oslabení 0:0
Střely na branku 27:23
Blokované střely 10:17
Zásahy brankářů 20:22
Hity 3:4
Trestné minuty 0:4
Tisk
RSS | Kontakt | Všeobecné obchodní podmínky a pravidla | Cookies | Nastavení soukromí | Reklama - Provozovatel BPA sport marketing a.s. ve spolupráci s eSports, s.r.o.

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

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

 

Queries: 69, time: 139.299 ms, default

Time msSQL QueryRows
0.091
SET NAMES 'utf8'
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchRepository.php:17
0
1.476
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` = '2908905')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_matchconstPRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2PRIMARY4const1
1PRIMARYteam_homeconstPRIMARYPRIMARY4const1
1PRIMARYteam_guestconstPRIMARYPRIMARY4const1
1PRIMARYclub_homeconstPRIMARYPRIMARY4const1
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
1PRIMARYteam_home_namerefPRIMARY,stats_team_idstats_team_id5const2Using where
1PRIMARYteam_guest_namerefPRIMARY,stats_team_idstats_team_id5const2Using where
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.076
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.061
explain
SELECT `id`, `league_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`id` IN (7071))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Match/presenters/OverviewPresenter.php:71
1
0.069
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.179
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` = 49651)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.143
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` = 5919098)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_playerconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33
1
0.185
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`name` `competition`, `extra_time`.`code`
`extra_time_code`, `contumacy`.`code` `contumacy_code`, `phase`.`name` `phase_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`season`, `sheet_state`.`name` `sheetStateName`,
`team_home_logo`.`path` `team_home_logo`, `team_guest_logo`.`path` `team_guest_logo`,
`team_home_name`.`name` `team_home_name`, `team_guest_name`.`name` `team_guest_name`,
`club_home`.`shortcut` AS `shortcut_home`, `club_guest`.`shortcut` AS `shortcut_guest`,
`club_home`.`nickname` AS `nickname_home`, `club_guest`.`nickname` AS `nickname_guest`,
`club_home_name`.`name` `club_home_name`, `club_guest_name`.`name` `club_guest_name` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_home` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_home_id` = `team_home`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team_guest` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_team_guest_id` = `team_guest`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_home_name` ON `team_home`.`id` =
`team_home_name`.`stats_team_id` AND (`team_home_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `team_home_name`.`stats_team_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` AS `team_guest_name` ON `team_guest`.`id`
= `team_guest_name`.`stats_team_id` AND (`team_guest_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `team_guest_name`.`stats_team_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_home` ON `team_home`.`stats_club_id`
= `club_home`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_home_logo` ON `club_home`.`id` =
`team_home_logo`.`stats_club_id` AND (`team_home_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `team_home_logo`.`stats_club_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club_guest` ON
`team_guest`.`stats_club_id` = `club_guest`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` AS `team_guest_logo` ON `club_guest`.`id`
= `team_guest_logo`.`stats_club_id` AND (`team_guest_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `team_guest_logo`.`stats_club_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` AS `club_home_name` ON `club_home`.`id` =
`club_home_name`.`stats_club_id` AND (`club_home_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `club_home_name`.`stats_club_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` AS `club_guest_name` ON `club_guest`.`id`
= `club_guest_name`.`stats_club_id` AND (`club_guest_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `club_guest_name`.`stats_club_id` 
ORDER BY IFNULL(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` BETWEEN `nameTable`.`from`
AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` <= `nameTable`.`to`) DESC, (`nameTable`.`to`
IS NULL AND `test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` >= `nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_extra_time` AS `extra_time` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`extra_time` = `extra_time`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_contumacy` AS `contumacy` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`contumacy` = `contumacy`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_match_phase` AS `phase` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`phase` = `phase`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_sheet_state` AS `sheet_state` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`sheet_state` = `sheet_state`.`code` 
WHERE (`team_home`.`id` IS NOT NULL) AND (`team_guest`.`id` IS NOT NULL) AND (`team_home_name`.`id`
IS NOT NULL) AND (`team_guest_name`.`id` IS NOT NULL) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908905')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYstats_matchconstPRIMARY,fk_stats_match_stats_team1,fk_stats_match_stats_team2PRIMARY4const1
1PRIMARYteam_homeconstPRIMARYPRIMARY4const1
1PRIMARYteam_guestconstPRIMARYPRIMARY4const1
1PRIMARYclub_homeconstPRIMARYPRIMARY4const1
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
1PRIMARYteam_home_namerefPRIMARY,stats_team_idstats_team_id5const2Using where
1PRIMARYteam_guest_namerefPRIMARY,stats_team_idstats_team_id5const2Using where
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.062
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (12))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34
1
0.060
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (12))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:34
1
0.221
explain
SELECT `id`, `stats_club_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
WHERE (`id` IN (7))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_teamconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.141
explain
SELECT `id`, `nickname`, `shortcut` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
WHERE (`id` IN (7))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_clubconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:35
1
0.062
explain
SELECT `id`, `league_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`id` IN (7071))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/MatchOverview/MatchOverview.php:45
1
0.071
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.584
explain
SELECT `id`, `period`, `score_home`, `score_guest` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = '2908905') 
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.273
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` = '2908905')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.239
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2908905') 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.151
explain
SELECT `id` 
FROM `available_video` 
WHERE (`stats_match_id` = '2908905') AND (`type` = 'cut') 
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavailable_videorefstats_match_id,type,stats_match_id_typestats_match_id4const1Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Video/VideoService.php:109
0
1.424
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` = 2908905) 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_match15const8Using 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.832
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` = 2908905) AND (`from` BETWEEN 1 AND 1200) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const2Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEplayereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177
2
0.850
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` = 2908905) 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_match15const8Using 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.597
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` = 2908905) 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_match15const8Using 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
6
0.260
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` = 2908905) AND (`from` BETWEEN 1201 AND 2400) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const2Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEplayereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177
0
0.659
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` = 2908905) 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_match15const8Using 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.673
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` = 2908905) 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_match15const8Using 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.249
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` = 2908905) AND (`from` BETWEEN 2401 AND 3600) 
ORDER BY `from`, `to`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1fk_stats_penalty_stats_match15const2Using where; Using filesort
1SIMPLEteameq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_team_id1
1SIMPLEclubeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.team.stats_club_id1
1SIMPLEplayereq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_penalty.stats_player_id1
1SIMPLEcountryeq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.player.country_id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:177
0
0.674
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` = 2908905) 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_match15const8Using 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.153
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` = '2908905')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.147
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` = '2908905')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const8Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Counting/SeasonStatsCounter/SeasonStatsPreCounter.php:58
8
0.137
explain
SELECT `id`, `datetime` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`id` = '2908905')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Match/MatchService.php:30
1
0.058
explain
SELECT `id`, `virtual` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = 7071)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_competitionconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionService.php:368
1
0.042
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_previous_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_previous_competition`.`stats_previous_competition_id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_previous_competition`.`stats_competition_id` = 7071)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_previous_competitionreffk_stats_previous_competition_stats_competition1,fk_stats_previous_competition_stats_competition2fk_stats_previous_competition_stats_competition15const1Using where
1SIMPLEstats_competitioneq_refPRIMARYPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_previous_competition.stats_previous_competition_id1Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionService.php:374
0
0.044
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
104.136
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 (14506, 9032, 10438, 49651, 17809, 12581, 9032, 10438, 10097481, 12581, 49651,
49651, 12581, 38171, 37111, 14150, 5919098, 5917821, 10101862, 10097120, 15827)) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_match`.`datetime` < '2024-02-14 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
15
0.350
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` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
1.362
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.*,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 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.873
explain
SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`jersey`,
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id`, `gk`.`saves`,
`gk`.`lost_goals`, `gk`.`minutes_played`, `gk`.`time_on_ice`, `gk`.`saves` + `gk`.`lost_goals` AS
`shots_against`, `attended`, `penalties`, `assistances`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `player`.`name`,
`player`.`surname`, `player`.`position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 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.145
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` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
4.122
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` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 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.732
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` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 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.407
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` = 2908905)
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.070
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38647))
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.553
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (14602))
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.131
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38502))
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.149
explain
SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_referee` 
WHERE (`id` IN (38507))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_refereeconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Match-templates-Overview-default-latte-d5c02d25e16e11c3dca51e30d7359927.php:467
1
0.036
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` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.586
explain
SELECT SUM(`gk`.`saves`) AS `saves`, SUM(`gk`.`lost_goals`) AS `lost` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match` AS `gk` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`id` = `gk`.`stats_player_2_match_id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) AND
(`player`.`position` = 'GK') 
GROUP BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_player_2_matchrefstats_player_id,fk_stats_player_2_match_stats_player1,fk_stats_player_2_match_stats_match1,fk_stats_player_2_match_stats_team1,stats_player_id_stats_match_id_attendedfk_stats_player_2_match_stats_match14const42Using where
1SIMPLEplayereq_refPRIMARY,postPRIMARY4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.stats_player_id1Using where
1SIMPLEgkrefstats_player_2_match_idstats_player_2_match_id4test_dev_nhlcz_s6_esports_cz.stats_player_2_match.id1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:310
1
0.173
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908905) AND (`stats_team_id` = 12) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348
0
0.172
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908905) AND (`stats_team_id` = 12) AND (`length` = 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368
0
0.127
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908905) AND (`stats_team_id` = 12) AND (`length` != 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388
0
0.263
explain
SELECT SUM(`hits`) AS `hits`, SUM(`faceoffs`) AS `faceoffs`, SUM(`faceoffs_won`) AS `faceoffs_won`,
SUM(`blocks`) AS `blocks` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 
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.144
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const8Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
8
1.093
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908905) AND (`stats_team_id` = 12) 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
5
0.039
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` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.434
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` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 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
2.812
explain
SELECT SUM(`length`) AS `length` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908905) AND (`stats_team_id` = 7) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:348
1
0.198
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908905) AND (`stats_team_id` = 7) AND (`length` = 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:368
1
0.185
explain
SELECT COUNT(*) AS `penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_penalty` 
WHERE (`stats_match_id` = 2908905) AND (`stats_team_id` = 7) AND (`length` != 2) 
GROUP BY `stats_match_id`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_penaltyreffk_stats_penalty_stats_match1,stats_team_idfk_stats_penalty_stats_match15const2Using where
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:388
0
0.333
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` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 
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.091
explain
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalreffk_stats_goal_stats_match1fk_stats_goal_stats_match15const8Using where; Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:398
8
2.938
explain
SELECT * 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goal` 
WHERE (`stats_match_id` = 2908905) AND (`stats_team_id` = 7) 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.472
explain
SELECT MAX(`period`) AS `max` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_goalkeeper_2_match_periodrefstats_match_id_stats_player_id_periodstats_match_id_stats_player_id_period4const12Using index
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:79
1
0.063
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` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.414
explain
SELECT `stats_player_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_player_id` = `player`.`id` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_team_id` = 12) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 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.291
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908905) AND (`stats_player_id` IN (10989, 18455)) 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.064
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` = 2908905)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstats_matchconstPRIMARYPRIMARY4const1
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:454
1
0.416
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` = 7) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_match`.`stats_match_id` = 2908905) 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.786
explain
SELECT SUM(`saves`) AS `saves`, `period` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeeper_2_match_period` 
WHERE (`stats_match_id` = 2908905) AND (`stats_player_id` IN (13132, 12013)) 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_period126Using where; Using temporary; Using filesort
/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/MatchStats/MatchStats.php:142
3
0.197
explain
SELECT `id`, `period`, `score_guest`, `score_home` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_match_period` 
WHERE (`stats_match_id` = 2908905)
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/2908905

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

¤ ×