POST https://www.textilwork.com/kasse/positionen/0/Nein/14675/new

Query Metrics

6 Database Queries
6 Different statements
25.96 ms Query time
0 Invalid entities
5449 Managed entities

Queries

Group similar statements

# Time Info
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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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
Parameters:
[]
4 1.30 ms
"START TRANSACTION"
Parameters:
[]
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
]
6 2.38 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\SDArtikelVerkauf 5446
App\Entity\User 1
App\Entity\Kassenbeleg 1
App\Entity\KassenbelegPositionen 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Kassenbeleg No errors.
App\Entity\SDArtikelVerkauf No errors.
App\Entity\KassenbelegPositionen No errors.