db_default:FALK
db_switch: prog: f1stat, type=m, sub:"", ro: 0
prog="f1stat": Connect to MySQL Database on /clx/sys/fifo/mysql.sock...
db_default:FALK
login:, bid:
No Cookie
db_default:FALK
Jetzt: 1537858606
Cache:
Anfangszeit: 1537858606.7593
MP LOGGED_IN:
PHP_SELF::/overview/person/PO-Connor SCRIPT_URL:/overview/person/PO-Connor
URL:overview:5:
URL:person:1:
URL:PO-Connor::
### URL: //overview/person index: 2 Skript: "Uebersicht/Personen_Firmen.php" Header: "Uebersicht/Personen_Firmen_h.php"
SELBST_URL://overview/person
Produkt:
select vorname, nachname, tmp_wms, f1_Person.aktiv is not null as akt, f1_Person.land, geb_ort.name as geb_ort_name, s_ort.name as s_ort_name, gebjahr, gebmonat, gebtag, sjahr, smonat, stag, Land_en.name as landname from f1_Person left join f1_Ort as geb_ort on geb_ort.f1_Ort = f1_Person.gebort left join f1_Ort as s_ort on s_ort.f1_Ort = f1_Person.sort left join Land_en on id=f1_Person.land where f1_Person = 550; -- 0.431 ms
Cache Ablauf:
Produkt:
Overview
Person:550
select count(*) as t, sum(punkte) as psum, sum(wmpunkte) as wmsum from f1_Rennergebnis where f1_Person = 550
select max(prio) as p, f1_Bild.f1_Bild, x, y, ((nachbearbeiten is not null) or (spaeter is not null)) as n, copyright, inhaber from f1_AufBild left join f1_Bild using(f1_Bild) where f1_AufBild.typ="p" and f1_AufBild.wert="550" and f1_Bild.copyright <= 0 group by f1_AufBild.f1_Bild order by p desc, qualitaet desc, spektakulaer desc, x desc limit 5; -- 3.089 ms
