https://1655948041.swtpos.de/receiptqrcode/9167

Query Metrics

3 Database Queries
3 Different statements
6.72 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.38 ms
(50.33%)
1
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.status AS status_3, t0.discount AS discount_4, t0.discount_type AS discount_type_5, t0.comment AS comment_6, t0.total AS total_7, t0.total_otax AS total_otax_8, t0.total_fixed AS total_fixed_9, t0.total_otax_fixed AS total_otax_fixed_10, t0.total_tax AS total_tax_11, t0.total_tax_fixed AS total_tax_fixed_12, t0.cart_total AS cart_total_13, t0.cart_total_otax AS cart_total_otax_14, t0.cart_total_fixed AS cart_total_fixed_15, t0.cart_total_otax_fixed AS cart_total_otax_fixed_16, t0.cart_total_tax AS cart_total_tax_17, t0.cart_total_tax_fixed AS cart_total_tax_fixed_18, t0.number AS number_19, t0.uuid AS uuid_20, t0.canceled AS canceled_21, t0.reversal_receipt AS reversal_receipt_22, t0.receipt_cashbox_id AS receipt_cashbox_id_23, t0.receipt_location_id AS receipt_location_id_24, t0.receipt_employee_id AS receipt_employee_id_25, t0.customer_id AS customer_id_26, t0.customer_address_id AS customer_address_id_27, t0.daily_financial_statement_id AS daily_financial_statement_id_28 FROM receipt t0 WHERE t0.id = ?
Parameters:
[
  "9167"
]
1.94 ms
(28.89%)
1
SELECT t0.id AS id_1, t0.transaction_id AS transaction_id_2, t0.start_date AS start_date_3, t0.update_date AS update_date_4, t0.finish_date AS finish_date_5, t0.started AS started_6, t0.updated AS updated_7, t0.finished AS finished_8, t0.qr_code_data AS qr_code_data_9, t0.fiskaly_client_id AS fiskaly_client_id_10, t0.receipt_id AS receipt_id_11 FROM fiskaly_transaction t0 WHERE t0.receipt_id = ?
Parameters:
[
  9167
]
1.40 ms
(20.78%)
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
]

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\ApiToken No errors.
App\Entity\Receipt No errors.
App\Entity\ReceiptCashbox No errors.
App\Entity\ReceiptLocation No errors.
App\Entity\ReceiptEmployee No errors.
App\Entity\Customer No errors.
App\Entity\CustomerAddress No errors.
App\Entity\DailyFinancialStatement No errors.
App\Entity\ReceiptCustomer No errors.
App\Entity\ReceiptCustomerAddress No errors.
App\Entity\ReceiptCustomerGroup No errors.
App\Entity\ReceiptDiscount No errors.
App\Entity\ReceiptPrice No errors.
App\Entity\ReceiptPriceGroup No errors.
App\Entity\ReceiptProduct No errors.
App\Entity\ReceiptScalePrice No errors.
App\Entity\ReceiptTax No errors.
App\Entity\ReceiptUnit No errors.
App\Entity\ReceiptUser No errors.
App\Entity\ReceiptEmployeeGroup No errors.
App\Entity\ReceiptCartProduct No errors.
App\Entity\ReceiptDocument No errors.
App\Entity\FiskalyTransaction No errors.
App\Entity\ReceiptTransaction No errors.
App\Entity\ReceiptContraAccount No errors.
App\Entity\Reversal No errors.
App\Entity\FiskalyReceiptType No errors.
App\Entity\FiskalyClient No errors.
App\Entity\FiskalyTransactionRevision No errors.
App\Entity\Language No errors.
App\Entity\User No errors.
App\Entity\Employee No errors.
App\Entity\EmployeeGroup No errors.
App\Entity\Cart No errors.
App\Entity\Cashbox No errors.