https://1655948041.swtpos.de/cart/create Return to referer URL

Query Metrics

8 Database Queries
8 Different statements
71.70 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
40.40 ms
(56.34%)
1
UPDATE cart SET status = 0
Parameters:
[]
9.44 ms
(13.17%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.locked AS locked_4, t0.serial_number AS serial_number_5, t6.id AS id_7, t6.client_id AS client_id_8, t6.status AS status_9, t6.add_date AS add_date_10, t6.cashbox_id AS cashbox_id_11, t6.fiskaly_tss_id AS fiskaly_tss_id_12, t0.location_id AS location_id_13 FROM cashbox t0 LEFT JOIN fiskaly_client t6 ON t6.cashbox_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
8.17 ms
(11.39%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.street_address AS street_address_4, t0.postal_code AS postal_code_5, t0.address_locality AS address_locality_6, t0.address_addition AS address_addition_7, t0.address_country AS address_country_8, t0.telephone AS telephone_9, t0.website AS website_10, t0.email AS email_11, t0.fax_number AS fax_number_12, t0.show_address_on_receipt AS show_address_on_receipt_13, t0.show_contact_on_receipt AS show_contact_on_receipt_14, t15.id AS id_16, t15.tss_id AS tss_id_17, t15.admin_puk AS admin_puk_18, t15.admin_pin AS admin_pin_19, t15.is_initialized AS is_initialized_20, t15.has_admin AS has_admin_21, t15.status AS status_22, t15.is_disabled AS is_disabled_23, t15.add_date AS add_date_24, t15.location_id AS location_id_25 FROM location t0 LEFT JOIN fiskaly_tss t15 ON t15.location_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
7.59 ms
(10.58%)
1
"START TRANSACTION"
Parameters:
[]
3.43 ms
(4.78%)
1
"COMMIT"
Parameters:
[]
1.14 ms
(1.60%)
1
INSERT INTO cart (create_date, status, discount, discount_type, parked, park_date, finished, finished_date, name, save_date, saved, comment, closed, close_date, total, total_otax, total_fixed, total_otax_fixed, total_tax, total_tax_fixed, employee_id, location_id, cashbox_id, customer_id, cash_closure_id, customer_address_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2024-05-16 11:57:39"
  2 => "open"
  3 => null
  4 => null
  5 => 0
  6 => null
  7 => 0
  8 => null
  9 => null
  10 => null
  11 => 0
  12 => null
  13 => 0
  14 => null
  15 => null
  16 => null
  17 => null
  18 => null
  19 => null
  20 => null
  21 => 1
  22 => 1
  23 => 1
  24 => 1
  25 => null
  26 => 954
]
0.87 ms
(1.22%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.account_id AS account_id_5, t6.id AS id_7, t6.given_name AS given_name_8, t6.family_name AS family_name_9, t6.external_identifier AS external_identifier_10, t6.telephone AS telephone_11, t6.status AS status_12, t6.lock_pin AS lock_pin_13, t6.from_api AS from_api_14, t6.user_id AS user_id_15, t6.employee_group_id AS employee_group_id_16, t6.language_id AS language_id_17 FROM user t0 LEFT JOIN employee t6 ON t6.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
0.66 ms
(0.92%)
1
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.external_identifier AS external_identifier_3, t0.gender AS gender_4, t0.title AS title_5, t0.date_of_birth AS date_of_birth_6, t0.telephone AS telephone_7, t0.mobilephone AS mobilephone_8, t0.fax_number AS fax_number_9, t0.company AS company_10, t0.given_name AS given_name_11, t0.family_name AS family_name_12, t0.street_address AS street_address_13, t0.postal_code AS postal_code_14, t0.address_locality AS address_locality_15, t0.address_suburb AS address_suburb_16, t0.address_addition AS address_addition_17, t0.address_country AS address_country_18, t0.company_department AS company_department_19, t0.uuid AS uuid_20, t0.type AS type_21, t0.customer_id AS customer_id_22 FROM customer_address t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  954
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Employee No errors.
App\Entity\EmployeeGroup No errors.
App\Entity\Language No errors.
App\Entity\ApiToken No errors.
App\Entity\ReceiptUser No errors.
App\Entity\Cart No errors.
App\Entity\ReceiptEmployee No errors.
App\Entity\Cashbox No errors.
App\Entity\Location No errors.
App\Entity\CustomerAddress No errors.
App\Entity\Customer No errors.
App\Entity\Receipt No errors.
App\Entity\ReceiptCustomerAddress No errors.
App\Entity\ReceiptDocumentCustomerAddress No errors.
App\Entity\FiskalyTss No errors.
App\Entity\Stock No errors.
App\Entity\ReceiptLocation No errors.
App\Entity\DailyFinancialStatementLocation No errors.
App\Entity\Category No errors.
App\Entity\FiskalyClient No errors.
App\Entity\ReceiptCashbox No errors.
App\Entity\CashboxDeposit No errors.
App\Entity\CashboxWithdrawal No errors.
App\Entity\CashboxPaymentToSupplier No errors.
App\Entity\CashboxSession No errors.
App\Entity\DailyFinancialStatementCashbox No errors.
App\Entity\FiskalyTransaction No errors.
App\Entity\CartProduct No errors.
App\Entity\CartHistory No errors.
App\Entity\CartLog No errors.
App\Entity\CartProductToCart No errors.
App\Entity\Transaction No errors.
App\Entity\CashClosure No errors.
App\Entity\CustomerGroup No errors.
App\Entity\Discount No errors.
App\Entity\PriceGroup No errors.