Query Metrics

11 Database Queries
11 Different statements
147.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
133.63 ms
(90.83%)
1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created AS created_3, t0.manual AS manual_4, t0.comment AS comment_5, t0.client_id AS client_id_6, t7.id AS id_8, t7.accrued AS accrued_9, t7.created AS created_10, t7.manual AS manual_11, t7.comment AS comment_12, t7.transaction_id AS transaction_id_13, t7.contract_id AS contract_id_14 FROM client_balance_transaction t0 LEFT JOIN contract_invoice t7 ON t7.transaction_id = t0.id WHERE t0.comment = ? LIMIT 1
Parameters:
[
  "Пополнение баланса Kaspi (224491717996)"
]
3.92 ms
(2.66%)
1
SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.paid AS paid_4, t0.created AS created_5, t0.client_id AS client_id_6, t7.city AS city_8, t7.street AS street_9, t7.house AS house_10, t7.apartment AS apartment_11, t7.contract_id AS contract_id_12, t0.commutator_id AS commutator_id_13 FROM contract t0 LEFT JOIN contract_location t7 ON t7.contract_id = t0.id WHERE t0.client_id = ?
Parameters:
[
  b"\x01‚fá¹k\x01ÛéœÈ‹Ê©4+"
]
2.55 ms
(1.73%)
1
SELECT t0.contract_id AS contract_id_1, t0.equipment_id AS equipment_id_2 FROM contract_equipment t0 WHERE t0.contract_id = ?
Parameters:
[
  b"\x01‚fãöÎ\x15Ù„£ÿPëàˆâ"
]
2.17 ms
(1.48%)
1
INSERT INTO client_balance_transaction (id, amount, created, manual, COMMENT, client_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  b"\x01ù├¹-Øì¯é®b9à‗╚Ò"
  3400.0
  "2025-07-01 08:15:07"
  0
  "Пополнение баланса Kaspi (224491717996)"
  b"\x01‚fá¹k\x01ÛéœÈ‹Ê©4+"
]
2.11 ms
(1.44%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.model AS model_4, t0.serial AS serial_5, t0.address AS address_6, t0.port AS port_7, t0.price AS price_8 FROM equipment t0 WHERE t0.id = ?
Parameters:
[
  b"\x01‚fãvCSC¸ˆ¹Â\rå²y"
]
1.34 ms
(0.91%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.login AS login_4, t0.password AS password_5, t0.script AS script_6 FROM commutator t0 WHERE t0.id = ?
Parameters:
[
  b"\x01Å‗├2┐Èò¼sÕ®╬\x13\x14´"
]
0.38 ms
(0.25%)
1
UPDATE client SET amount = ? WHERE id = ?
Parameters:
[
  4000.0
  b"\x01‚fá¹k\x01ÛéœÈ‹Ê©4+"
]
0.31 ms
(0.21%)
1
SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.paid AS paid_4, t0.created AS created_5, t0.client_id AS client_id_6, t7.city AS city_8, t7.street AS street_9, t7.house AS house_10, t7.apartment AS apartment_11, t7.contract_id AS contract_id_12, t0.commutator_id AS commutator_id_13 FROM contract t0 LEFT JOIN contract_location t7 ON t7.contract_id = t0.id WHERE t0.number = ? LIMIT 1
Parameters:
[
  "02146"
]
0.29 ms
(0.20%)
1
"START TRANSACTION"
Parameters:
[]
0.22 ms
(0.15%)
1
"COMMIT"
Parameters:
[]
0.20 ms
(0.13%)
1
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.amount AS amount_6, t7.name AS name_8, t7.surname AS surname_9, t7.patronymic AS patronymic_10, t7.value AS value_11, t7.number AS number_12, t7.issued AS issued_13, t7.department AS department_14, t7.client_id AS client_id_15 FROM client t0 LEFT JOIN client_identification t7 ON t7.client_id = t0.id WHERE t0.id = ?
Parameters:
[
  b"\x01‚fá¹k\x01ÛéœÈ‹Ê©4+"
]

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.