DEBUG INFO:
Zpracovani skriptu trvalo 1675376038.053 sekund.

Pocet dotazu: 3

• select zapas.id, zapas_detail.id_zapas, zapas.datum as datum, time_format(zapas.zacatek_utkani,'%H:%i') as zacatek_utkani, zapas.cislo_kola, soutez.sezona as sezona, soutez.zkraceny_nazev, soutez.typ_souteze, soutez.cast_souteze, roznov.id_soutez, zapas.id_druzstvo_poradatel, if ( zapas_detail.id_zapas = null, '-:-', concat(roznov_golu,':',souper_golu,upresneni_vysledku) ) as vysledek, roznov.nazev as roznov, souper.nazev as souper, roznov_domaci, id_druzstvo_roznov, hala.nazev as hala, hala.id as id_hala, hala.id_fis as id_hala_fis, roznov_golu, souper_golu, upresneni_vysledku, '/loga/pie_roznov.gif' as roznov_pie, ifnull(souper.pie_logo, '/loga/pie_no_logo.gif') as souper_pie, if(id_zapas is null,0,1) as odehran from zapas left join zapas_detail on zapas_detail.id_zapas = zapas.id 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 datum = '2022-11-20' order by datum, zacatek_utkani, id_druzstvo, poradi_ligy, cislo_kola
• select * from zapas limit 1
• select id_druzstvo as id,druzstvo_fbk_v_sezone.nazev, pohlavi from druzstvo_fbk_v_sezone inner join druzstvo on id_druzstvo = druzstvo.id inner join kategorie_druzstev on id_kategorie_druzstev = kategorie_druzstev.id_kategorie where sezona = 2022 order by id_kategorie_druzstev, pohlavi, id_druzstvo

DEBUG INFO:
Zpracovani skriptu trvalo 1675376038.0533 sekund.

Pocet dotazu: 1

• (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