120.38 ms (87.37%)
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 (221188663654) "
]
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 (221188663654)' LIMIT 1 ;
Copy
4.22 ms (3.06%)
1
INSERT INTO client_balance_transaction (id , amount , created , manual , COMMENT , client_id ) VALUES (? , ? , ? , ? , ? , ? )
Parameters :
[
b"\x01 “ïIjg\x0F üØ\x17 »¨S_õ¯ "
6500.0
"2024-12-22 21:53:06 "
0
"Пополнение баланса Kaspi (221188663654) "
b"\x01 ˆ\x0E Cmy½7ŽÅ«>¬<ï\x01 "
]
INSERT INTO client_balance_transaction (id , amount , created , manual , COMMENT , client_id ) VALUES (0x0193EF496A670FFCD817BBA8535FF5AF , 6500 , '2024-12-22 21:53:06' , 0 , 'Пополнение баланса Kaspi (221188663654)' , 0x01880E436D79BD378EC5AB3EAC3CEF01 );
Copy
4.06 ms (2.95%)
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 ˆ\x0E Cmy½7ŽÅ«>¬<ï\x01 "
]
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 = 0x01880E436D79BD378EC5AB3EAC3CEF01 ;
Copy
3.30 ms (2.39%)
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 ê\x0E EÅ;æ|æƒ"Üe·n╦ "
]
SELECT t0 . contract_id AS contract_id_1 , t0 . equipment_id AS equipment_id_2 FROM contract_equipment t0 WHERE t0 . contract_id = 0x01880E458F3B917C919F229A65FA6ECB ;
Copy
2.68 ms (1.94%)
2
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 ˆ\x0E Dwb¦½“)Ý©€•¾š "
]
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 = 0x01880E447762A6BD9329DDA98095BE9A ;
Copy
1.33 ms (0.96%)
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.74 ms (0.54%)
1
UPDATE client SET amount = ? WHERE id = ?
Parameters :
[
6800.0
b"\x01 ˆ\x0E Cmy½7ŽÅ«>¬<ï\x01 "
]
UPDATE client SET amount = 6800 WHERE id = 0x01880E436D79BD378EC5AB3EAC3CEF01 ;
Copy
0.61 ms (0.44%)
1
"COMMIT"
0.19 ms (0.14%)
1
"START TRANSACTION"
"START TRANSACTION" ;
Copy
0.16 ms (0.11%)
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 = '02290' LIMIT 1 ;
Copy
0.12 ms (0.09%)
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 ˆ\x0E Cmy½7ŽÅ«>¬<ï\x01 "
]
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 = 0x01880E436D79BD378EC5AB3EAC3CEF01 ;
Copy