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: 1550535994
Cache:
Anfangszeit: 1550535994.863
MP LOGGED_IN:
PHP_SELF::/overview/product/1526 SCRIPT_URL:/overview/product/1526
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:1526
Cache Ablauf:
Produkt:1526
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=1526; -- 0.148 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 = 1526; -- 0.193 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=1526 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.256 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=443; -- 0.137 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 = 443; -- 0.129 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=443 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.193 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=45; -- 0.120 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 = 45; -- 0.161 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=45 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.189 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=197; -- 0.139 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 = 197; -- 0.143 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=197 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.185 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=204; -- 0.121 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 = 204; -- 0.126 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=204 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.177 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="1526" and f1_Bild.copyright <= 0 group by f1_AufBild.f1_Bild order by p desc, qualitaet desc, spektakulaer desc, x desc limit 5; -- 2.631 ms