Query Metrics
8
Database Queries
8
Different statements
71.70 ms
Query time
0
Invalid entities
Grouped Statements
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. |