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: 1524538344
Cache:
Anfangszeit: 1524538344.6465
MP LOGGED_IN:
PHP_SELF::/overview/product/1173 SCRIPT_URL:/overview/product/1173
URL:overview:5:
URL:product:5:
### URL: //overview/product index: 2 Skript: "Uebersicht/Personen_Firmen.php" Header: "Uebersicht/Personen_Firmen_h.php"
SELBST_URL://overview/product
Produkt:1173
Cache Ablauf:
Produkt:1173
Overview
select f1_Produkt.name, f1_Produkt.f1_Firma, f1_PTyp.api_inter as typ_name from f1_Produkt left join f1_PTyp using (f1_PTyp) where f1_Produkt=1173; -- 0.276 msselect f1_PE_Wert.f1_PE_Wert, f1_PTyp.api_Inter as typ_name, typ, f1_PE_Kategorie.api_Inter as kat_name, f1_PE_Kategorie.einheit, f1_PE_Wert.wert from f1_PE_Wert left join f1_PE_Kategorie using(f1_PE_Kategorie) left join f1_PTyp using(f1_PTyp) where f1_Produkt = 1173; -- 0.237 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=1173 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.319 msselect f1_Produkt.name, f1_Produkt.f1_Firma, f1_PTyp.api_inter as typ_name from f1_Produkt left join f1_PTyp using (f1_PTyp) where f1_Produkt=263; -- 0.093 msselect f1_PE_Wert.f1_PE_Wert, f1_PTyp.api_Inter as typ_name, typ, f1_PE_Kategorie.api_Inter as kat_name, f1_PE_Kategorie.einheit, f1_PE_Wert.wert from f1_PE_Wert left join f1_PE_Kategorie using(f1_PE_Kategorie) left join f1_PTyp using(f1_PTyp) where f1_Produkt = 263; -- 0.142 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=263 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.153 msselect f1_Produkt.name, f1_Produkt.f1_Firma, f1_PTyp.api_inter as typ_name from f1_Produkt left join f1_PTyp using (f1_PTyp) where f1_Produkt=12; -- 0.124 msselect f1_PE_Wert.f1_PE_Wert, f1_PTyp.api_Inter as typ_name, typ, f1_PE_Kategorie.api_Inter as kat_name, f1_PE_Kategorie.einheit, f1_PE_Wert.wert from f1_PE_Wert left join f1_PE_Kategorie using(f1_PE_Kategorie) left join f1_PTyp using(f1_PTyp) where f1_Produkt = 12; -- 0.134 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=12 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.162 msselect f1_Produkt.name, f1_Produkt.f1_Firma, f1_PTyp.api_inter as typ_name from f1_Produkt left join f1_PTyp using (f1_PTyp) where f1_Produkt=200; -- 0.122 msselect f1_PE_Wert.f1_PE_Wert, f1_PTyp.api_Inter as typ_name, typ, f1_PE_Kategorie.api_Inter as kat_name, f1_PE_Kategorie.einheit, f1_PE_Wert.wert from f1_PE_Wert left join f1_PE_Kategorie using(f1_PE_Kategorie) left join f1_PTyp using(f1_PTyp) where f1_Produkt = 200; -- 0.115 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=200 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.141 msselect f1_Produkt.name, f1_Produkt.f1_Firma, f1_PTyp.api_inter as typ_name from f1_Produkt left join f1_PTyp using (f1_PTyp) where f1_Produkt=205; -- 0.131 msselect f1_PE_Wert.f1_PE_Wert, f1_PTyp.api_Inter as typ_name, typ, f1_PE_Kategorie.api_Inter as kat_name, f1_PE_Kategorie.einheit, f1_PE_Wert.wert from f1_PE_Wert left join f1_PE_Kategorie using(f1_PE_Kategorie) left join f1_PTyp using(f1_PTyp) where f1_Produkt = 205; -- 0.157 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=205 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.142 msselect 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="d" and f1_AufBild.wert="1173" and f1_Bild.copyright <= 0 group by f1_AufBild.f1_Bild order by p desc, qualitaet desc, spektakulaer desc, x desc limit 5; -- 1.904 ms
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "1173" (Typ:d) gefunden!