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) "
]
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 = 'Пополнение баланса Kaspi (224491717996)' LIMIT 1 ;
Copy
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+ "
]
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 = 0x018266E1B96B01DBE99CC88BCAA9342B ;
Copy
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ëàˆâ "
]
SELECT t0 . contract_id AS contract_id_1 , t0 . equipment_id AS equipment_id_2 FROM contract_equipment t0 WHERE t0 . contract_id = 0x018266E3F6CE15D984A3FF50EBE088E2 ;
Copy
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+ "
]
INSERT INTO client_balance_transaction (id , amount , created , manual , COMMENT , client_id ) VALUES (0x0197C3FB2D9D8DEE82A9623985F2C8E3 , 3400 , '2025-07-01 08:15:07' , 0 , 'Пополнение баланса Kaspi (224491717996)' , 0x018266E1B96B01DBE99CC88BCAA9342B );
Copy
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 "
]
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 = 0x018266E376435343B888B9C20DE5B279 ;
Copy
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 ´ "
]
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 = 0x018FF2C332BFD495AC73E5A9CE1314EF ;
Copy
0.38 ms (0.25%)
1
UPDATE client SET amount = ? WHERE id = ?
Parameters :
[
4000.0
b"\x01 ‚fá¹k\x01 ÛéœÈ‹Ê©4+ "
]
UPDATE client SET amount = 4000 WHERE id = 0x018266E1B96B01DBE99CC88BCAA9342B ;
Copy
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
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 = '02146' LIMIT 1 ;
Copy
0.29 ms (0.20%)
1
"START TRANSACTION"
"START TRANSACTION" ;
Copy
0.22 ms (0.15%)
1
"COMMIT"
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+ "
]
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 = 0x018266E1B96B01DBE99CC88BCAA9342B ;
Copy