Query Metrics
3
Database Queries
3
Different statements
6.72 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.38 ms |
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"
]
|
2 | 1.94 ms |
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
]
|
3 | 1.40 ms |
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. |