DEBUG INFO:
Zpracovani skriptu trvalo 1680139875.182 sekund.

Pocet dotazu: 5

• select jmeno, prijmeni, datum_narozeni, vyska, vaha, drzeni_hole as hul, '' as popisek,'' as pozice, fotka,fotka_ze_hry from osoba where id = 111
• SELECT sum(zp) as z, sum(vg) as vg, sum(rg) as rg, sum(pg) as pg, sum(og) as og, sum(trest2) as trest2, sum(trest5) as trest5, sum(trest10) as trest10, sum(CK) as ck, sum(tm) as tm, sum(plus) - sum(minus) as plusminus, sum(g) as g, sum(a) as a, druzstvo_soutez.nazev, druzstvo_soutez.id_druzstvo as id_druzstvo, druzstvo_soutez.id_soutez as id_soutez, soutez.zkraceny_nazev as nazev_souteze, typ_souteze, cast_souteze, sezona FROM `zapas_roznov_soupiska` inner join zapas on id_zapas = zapas.id inner join soutez on zapas.id_soutez = soutez.id inner join druzstvo_soutez on druzstvo_soutez.id_druzstvo = zapas.id_druzstvo_roznov and druzstvo_soutez.id_soutez = zapas.id_soutez where id_osoba = 111 and zapas_roznov_soupiska.post <> 'G' and soutez.sezona>2008 group by id_osoba, zapas.id_soutez order by typ_souteze,sezona desc,cast_souteze desc, nazev asc, nazev_souteze asc
• SELECT z, vg, rg, pg, og, 0 as trest2, 0 as trest5, 0 as trest10, 0 as ck, tm, plusminus, g, a, druzstvo as nazev,soutez as nazev_souteze, typ_souteze, 0 as cast_souteze, sezona FROM `hrac_statistiky_archiv` where id_osoba = 111 order by typ_souteze,cast_souteze desc, sezona desc, nazev asc, nazev_souteze asc
• select prijmeni,jmeno, sum(t.zapasu) as z, 0*sum(t.g) as g, sum(t.a) as a, sum(t.tm) as tm, sum(t.so) as so, sum(t.vyher) as v, sum(t.remiz) as r, sum(t.proher) as p, sum(t.odchytany_cas) as odchytany_cas, sum(t.strel) as strel,sum(t.obdrzenych) as obdrzenych, 100*sum(uspesnost) as uspesnost,id_brankar,t.id_soutez, soutez.zkraceny_nazev as nazev_souteze, soutez.typ_souteze, soutez.cast_souteze, soutez.pocet_tretin,soutez.cas_na_tretinu, soutez.sezona , druzstvo_soutez.nazev as druzstvo from ( SELECT count(zapas_roznov_brankar.id_zapas) as zapasu, sum(if(roznov_golu > souper_golu,1,0)) as vyher, sum(if(roznov_golu = souper_golu,1,0)) as remiz, sum(if(roznov_golu < souper_golu,1,0)) as proher, sum(g) as g, sum(a) as a, sum(2*trest2 + 5*trest5 + 10*trest10) as tm, sum(ciste_konto) as so, sum(odchytany_cas) as odchytany_cas, sum(zapas_roznov_brankar.strel) as strel,sum(obdrzenych) as obdrzenych, if(zapas_roznov_brankar.strel=0,1,if(zapas_roznov_brankar.strel < obdrzenych,0,(sum(zapas_roznov_brankar.strel)-sum(obdrzenych))/sum(zapas_roznov_brankar.strel))) as uspesnost, id_brankar,zapas.id_soutez,prijmeni,jmeno ,zapas.id_druzstvo_roznov FROM `zapas_roznov_brankar` inner join zapas on zapas_roznov_brankar.id_zapas = zapas.id inner join zapas_detail on zapas_roznov_brankar.id_zapas = zapas_detail.id_zapas inner join zapas_roznov_soupiska on zapas_roznov_soupiska.id_zapas = zapas_roznov_brankar.id_zapas and zapas_roznov_brankar.cislo_brankar = zapas_roznov_soupiska.cislo inner join osoba on id_brankar = osoba.id where zapas_roznov_brankar.strel is not null and id_brankar=111 group by id_brankar,zapas.id_soutez union SELECT count(zapas_roznov_brankar.id_zapas) as zapasu, sum(if(roznov_golu > souper_golu,1,0)) as vyher, sum(if(roznov_golu = souper_golu,1,0)) as remiz, sum(if(roznov_golu < souper_golu,1,0)) as proher, sum(g) as g, sum(a) as a, sum(2*trest2 + 5*trest5 + 10*trest10) as tm, sum(ciste_konto) as so, sum(odchytany_cas) as odchytany_cas, sum(zapas_roznov_brankar.strel) as strel,sum(obdrzenych) as obdrzenych, null as uspesnost, id_brankar,zapas.id_soutez,prijmeni,jmeno ,zapas.id_druzstvo_roznov FROM `zapas_roznov_brankar` inner join zapas on zapas_roznov_brankar.id_zapas = zapas.id inner join zapas_detail on zapas_roznov_brankar.id_zapas = zapas_detail.id_zapas inner join zapas_roznov_soupiska on zapas_roznov_soupiska.id_zapas = zapas_roznov_brankar.id_zapas and zapas_roznov_brankar.cislo_brankar = zapas_roznov_soupiska.cislo inner join osoba on id_brankar = osoba.id where zapas_roznov_brankar.strel is null and id_brankar=111 group by id_brankar,zapas.id_soutez ) as t inner join soutez on t.id_soutez = soutez.id inner join druzstvo_soutez on t.id_soutez = druzstvo_soutez.id_soutez and druzstvo_soutez.id_druzstvo=t.id_druzstvo_roznov where soutez.sezona>2008 group by id_brankar,t.id_soutez order by soutez.sezona desc, soutez.poradi_ligy asc, soutez.cast_souteze desc
• (select zapas.id, id_druzstvo_roznov as id_druzstvo, zapas.datum as datum, zapas.zacatek_utkani, zapas.cislo_kola as kolo, zapas.id_soutez, soutez.typ_souteze, soutez.cast_souteze, soutez.zkraceny_nazev as nazev_souteze, souper.nazev as souper, hala.nazev as hala, hala.id_fis as id_hala_fis from zapas left join hala on hala.id = id_hala inner join soutez on zapas.id_soutez=soutez.id inner join druzstvo_soutez as roznov on id_druzstvo_roznov=roznov.id_druzstvo and soutez.id=roznov.id_soutez left join druzstvo_souper as souper on souper.id=id_druzstvo_souper where soutez.sezona=2022 and date_add(datum,interval TIME_TO_SEC(ifnull(zacatek_utkani,0)) second) > NOW() - interval 4 hour ) union ( select id, id_druzstvo, datum, zacatek_utkani, cislo_kola kolo, 0 as id_soutez, if(kolo_nebo_turnaj = 1, 'liga','turnaj') as typ_souteze, if(kolo_nebo_turnaj = 1, 'zakladni','playoff') as cast_souteze, typ_zapasu nazev_souteze, souper, misto hala, 0 from 1fbkroznovorg3.kalendar where date_add(datum,interval TIME_TO_SEC(zacatek_utkani) second) >= now() - interval 4 hour ) order by datum asc, zacatek_utkani asc, kolo asc