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: 1550707239
Cache:
Anfangszeit: 1550707239.4234
MP LOGGED_IN:
PHP_SELF::/Uebersicht/Produkt/1324 SCRIPT_URL:/Uebersicht/Produkt/1324
URL:Uebersicht:5:
URL:Produkt:5:
### URL: //Uebersicht/Produkt index: 2 Skript: "Uebersicht/Personen_Firmen.php" Header: "Uebersicht/Personen_Firmen_h.php"
SELBST_URL://Uebersicht/Produkt
Produkt:1324
Cache Ablauf:
Produkt:1324
Übersicht
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=1324; -- 0.117 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 = 1324; -- 0.118 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=1324 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.215 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=352; -- 0.088 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 = 352; -- 0.116 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=352 and p2 != 0 and rel="i" order by f1_PTyp != "c", f1_PTyp != "m", f1_PTyp != "r", f1_PTyp != "o"; -- 0.130 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=56; -- 0.106 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 = 56; -- 0.156 msselect p2 from f1_PV left join f1_Produkt on f1_Produkt.f1_Produkt=f1_PV.p2 where p1=56 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=200; -- 0.116 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.150 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.174 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.107 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.138 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.149 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="1324" and f1_Bild.copyright <= 0 group by f1_AufBild.f1_Bild order by p desc, qualitaet desc, spektakulaer desc, x desc limit 5; -- 1.933 ms
Kein passender Alias für "90" (Typ:o) gefunden!