| 1 |
1.21 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.10 ms |
SELECT t0.id AS id_1, t0.belegnr AS belegnr_2, t0.belegdat AS belegdat_3, t0.nlid AS nlid_4, t0.adrcode AS adrcode_5, t0.plzkunde AS plzkunde_6, t0.vortext AS vortext_7, t0.marktid AS marktid_8, t0.internetbnr AS internetbnr_9, t0.nachtext AS nachtext_10, t0.zahlungsart AS zahlungsart_11, t0.bezahltam AS bezahltam_12, t0.gedruckt AS gedruckt_13, t0.kabid AS kabid_14, t0.fiktiv AS fiktiv_15, t0.lastuser AS lastuser_16, t0.lastchange AS lastchange_17 FROM kassenbeleg t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.belegnr AS belegnr_2, t0.belegdat AS belegdat_3, t0.nlid AS nlid_4, t0.adrcode AS adrcode_5, t0.plzkunde AS plzkunde_6, t0.vortext AS vortext_7, t0.marktid AS marktid_8, t0.internetbnr AS internetbnr_9, t0.nachtext AS nachtext_10, t0.zahlungsart AS zahlungsart_11, t0.bezahltam AS bezahltam_12, t0.gedruckt AS gedruckt_13, t0.kabid AS kabid_14, t0.fiktiv AS fiktiv_15, t0.lastuser AS lastuser_16, t0.lastchange AS lastchange_17 FROM kassenbeleg t0 WHERE t0.id = 14675;
|
| 3 |
18.86 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 ORDER BY t0.artikelnr ASC
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 ORDER BY t0.artikelnr ASC;
|
| 4 |
1.30 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 5 |
1.10 ms |
INSERT INTO kassenbeleg_positionen (belegnr, artikelnr, bemerkung, menge, epbrutto, epbruttokg, mwstsatz, aufabschlagproz, verkaufszeit, insteuer) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
7341
"06000050"
"3,5mm"
1.0
5.0
0.0
0.19
0.0
null
null
]
INSERT INTO kassenbeleg_positionen (belegnr, artikelnr, bemerkung, menge, epbrutto, epbruttokg, mwstsatz, aufabschlagproz, verkaufszeit, insteuer) VALUES (7341, '06000050', '3,5mm', 1, 5, 0, 0.19, 0, NULL, NULL);
|
| 6 |
2.38 ms |
"COMMIT"
|