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: 1539944928
Cache:
Anfangszeit: 1539944928.705
MP LOGGED_IN:
PHP_SELF::/panoramica/persona/MikeFisher SCRIPT_URL:/panoramica/persona/MikeFisher
URL:panoramica:5:
URL:persona:1:
URL:MikeFisher::
### URL: //panoramica/persona index: 2 Skript: "Uebersicht/Personen_Firmen.php" Header: "Uebersicht/Personen_Firmen_h.php"
SELBST_URL://panoramica/persona
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_it.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_it on id=f1_Person.land where f1_Person = 287; -- 0.212 ms
Cache Ablauf:
Produkt:
Panoramica
Person:287
select count(*) as t, sum(punkte) as psum, sum(wmpunkte) as wmsum from f1_Rennergebnis where f1_Person = 287
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="287" and f1_Bild.copyright <= 0 group by f1_AufBild.f1_Bild order by p desc, qualitaet desc, spektakulaer desc, x desc limit 5; -- 1.889 ms
Kein passender Alias für "75" (Typ:o) gefunden!
select f1_Kurve, f1_Ort, bild, f1_Kurve.name, f1_Kurventyp_it.name as typname from f1_Kurve left join f1_Kurventyp_it on f1_Kurventyp_it.id = typ where f1_Kurve=1041; -- 0.200 msselect name from f1_KurveInStrecke where f1_Kurve=1041 and name != "" group by name; -- 0.107 ms
