| 1 |
1.19 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 3;
|
| 2 |
1.19 ms |
SELECT t0.id AS id_1, t0.artikelnr AS artikelnr_2, t0.eancode AS eancode_3, t0.sortierung AS sortierung_4, t0.artikelbez AS artikelbez_5, t0.artikelsuchtext AS artikelsuchtext_6, t0.artikelbeschreibung AS artikelbeschreibung_7, t0.mwstsatz AS mwstsatz_8, t0.einheit AS einheit_9, t0.epbrutto AS epbrutto_10, t0.mindestbestand AS mindestbestand_11, t0.mengeinve AS mengeinve_12, t0.spruch AS spruch_13, t0.lieferant AS lieferant_14, t0.kommissionsgeber AS kommissionsgeber_15, t0.epbruttokg AS epbruttokg_16, t0.mwstsatzkg AS mwstsatzkg_17, t0.epverkherst AS epverkherst_18, t0.lastuser AS lastuser_19, t0.lastchange AS lastchange_20 FROM sdartikel_verkauf t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.artikelnr AS artikelnr_2, t0.eancode AS eancode_3, t0.sortierung AS sortierung_4, t0.artikelbez AS artikelbez_5, t0.artikelsuchtext AS artikelsuchtext_6, t0.artikelbeschreibung AS artikelbeschreibung_7, t0.mwstsatz AS mwstsatz_8, t0.einheit AS einheit_9, t0.epbrutto AS epbrutto_10, t0.mindestbestand AS mindestbestand_11, t0.mengeinve AS mengeinve_12, t0.spruch AS spruch_13, t0.lieferant AS lieferant_14, t0.kommissionsgeber AS kommissionsgeber_15, t0.epbruttokg AS epbruttokg_16, t0.mwstsatzkg AS mwstsatzkg_17, t0.epverkherst AS epverkherst_18, t0.lastuser AS lastuser_19, t0.lastchange AS lastchange_20 FROM sdartikel_verkauf t0 WHERE t0.id = 4081;
|
| 3 |
1.18 ms |
SELECT s0_.id AS id_0, s0_.artikelnr AS artikelnr_1, s0_.eancode AS eancode_2, s0_.sortierung AS sortierung_3, s0_.artikelbez AS artikelbez_4, s0_.artikelsuchtext AS artikelsuchtext_5, s0_.artikelbeschreibung AS artikelbeschreibung_6, s0_.mwstsatz AS mwstsatz_7, s0_.einheit AS einheit_8, s0_.epbrutto AS epbrutto_9, s0_.mindestbestand AS mindestbestand_10, s0_.mengeinve AS mengeinve_11, s0_.spruch AS spruch_12, s0_.lieferant AS lieferant_13, s0_.kommissionsgeber AS kommissionsgeber_14, s0_.epbruttokg AS epbruttokg_15, s0_.mwstsatzkg AS mwstsatzkg_16, s0_.epverkherst AS epverkherst_17, s0_.lastuser AS lastuser_18, s0_.lastchange AS lastchange_19 FROM sdartikel_verkauf s0_ WHERE s0_.artikelnr < ? ORDER BY s0_.artikelnr DESC LIMIT 1
Parameters: [
"KT977152"
]
SELECT s0_.id AS id_0, s0_.artikelnr AS artikelnr_1, s0_.eancode AS eancode_2, s0_.sortierung AS sortierung_3, s0_.artikelbez AS artikelbez_4, s0_.artikelsuchtext AS artikelsuchtext_5, s0_.artikelbeschreibung AS artikelbeschreibung_6, s0_.mwstsatz AS mwstsatz_7, s0_.einheit AS einheit_8, s0_.epbrutto AS epbrutto_9, s0_.mindestbestand AS mindestbestand_10, s0_.mengeinve AS mengeinve_11, s0_.spruch AS spruch_12, s0_.lieferant AS lieferant_13, s0_.kommissionsgeber AS kommissionsgeber_14, s0_.epbruttokg AS epbruttokg_15, s0_.mwstsatzkg AS mwstsatzkg_16, s0_.epverkherst AS epverkherst_17, s0_.lastuser AS lastuser_18, s0_.lastchange AS lastchange_19 FROM sdartikel_verkauf s0_ WHERE s0_.artikelnr < 'KT977152' ORDER BY s0_.artikelnr DESC LIMIT 1;
|
| 4 |
1.01 ms |
SELECT dateiname
FROM sdartikel_bilder
WHERE bildtyp = 'Labelbild'
AND artikelnr = ?
Parameters: [
"KT977040"
]
SELECT dateiname
FROM sdartikel_bilder
WHERE bildtyp = 'Labelbild'
AND artikelnr = 'KT977040';
|
| 5 |
1.04 ms |
SELECT dateiname
FROM sdartikel_bilder
WHERE artikelnr = ?
AND (bildtyp <> 'Labelbild'
OR bildtyp IS NULL);
Parameters: [
"KT977040"
]
SELECT dateiname
FROM sdartikel_bilder
WHERE artikelnr = 'KT977040'
AND (bildtyp <> 'Labelbild'
OR bildtyp IS NULL);;
|
| 6 |
4.26 ms |
SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.akadtitel AS akadtitel_3, t0.nachname AS nachname_4, t0.vorname AS vorname_5, t0.firmenname AS firmenname_6, t0.taetigkeit AS taetigkeit_7, t0.abteilung AS abteilung_8, t0.adresszusatz AS adresszusatz_9, t0.strasse AS strasse_10, t0.plz AS plz_11, t0.ort AS ort_12, t0.bundesland AS bundesland_13, t0.land AS land_14, t0.kundennummer AS kundennummer_15, t0.adresstyp AS adresstyp_16, t0.geburtsdatum AS geburtsdatum_17, t0.privatdienstl AS privatdienstl_18, t0.notizen AS notizen_19, t0.internetbesteller AS internetbesteller_20, t0.eigeneadresse AS eigeneadresse_21, t0.lastuser AS lastuser_22, t0.lastchange AS lastchange_23 FROM sdadressen t0 ORDER BY t0.nachname ASC, t0.vorname ASC
SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.akadtitel AS akadtitel_3, t0.nachname AS nachname_4, t0.vorname AS vorname_5, t0.firmenname AS firmenname_6, t0.taetigkeit AS taetigkeit_7, t0.abteilung AS abteilung_8, t0.adresszusatz AS adresszusatz_9, t0.strasse AS strasse_10, t0.plz AS plz_11, t0.ort AS ort_12, t0.bundesland AS bundesland_13, t0.land AS land_14, t0.kundennummer AS kundennummer_15, t0.adresstyp AS adresstyp_16, t0.geburtsdatum AS geburtsdatum_17, t0.privatdienstl AS privatdienstl_18, t0.notizen AS notizen_19, t0.internetbesteller AS internetbesteller_20, t0.eigeneadresse AS eigeneadresse_21, t0.lastuser AS lastuser_22, t0.lastchange AS lastchange_23 FROM sdadressen t0 ORDER BY t0.nachname ASC, t0.vorname ASC;
|
| 7 |
1.38 ms |
SELECT belegnr FROM kassenbeleg WHERE id = ?
SELECT belegnr FROM kassenbeleg WHERE id = 14934;
|
| 8 |
1.32 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 9 |
1.16 ms |
UPDATE sdartikel_verkauf SET artikelbeschreibung = ?, epbruttokg = ?, lastchange = ? WHERE id = ?
Parameters: [
"""
Gewicht: 80g,\n
Lauflänge: 320m,\n
Nadelstärke: 2-2,5mm\n
Zusammensetzung: 75% Wolle, 25% Polyamid\n
waschbar: bei 40°
"""
11.95
"2026-10-19 16:48:00"
5497
]
UPDATE sdartikel_verkauf SET artikelbeschreibung = 'Gewicht: 80g,
Lauflänge: 320m,
Nadelstärke: 2-2,5mm
Zusammensetzung: 75% Wolle, 25% Polyamid
waschbar: bei 40°', epbruttokg = 11.95, lastchange = '2026-10-19 16:48:00' WHERE id = 5497;
|
| 10 |
2.99 ms |
"COMMIT"
|