1
0.59 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . first_name AS first_name_5 , t0 . last_name AS last_name_6 , t0 . avatar AS avatar_7 FROM user t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . first_name AS first_name_5 , t0 . last_name AS last_name_6 , t0 . avatar AS avatar_7 FROM user t0 WHERE t0 . id = 4 ;
Copy
2
0.41 ms
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . name AS name_3 , t0 . construction_site_cost_center AS construction_site_cost_center_4 , t0 . order_date AS order_date_5 , t0 . start_time AS start_time_6 , t0 . end_time AS end_time_7 , t0 . repeat_order AS repeat_order_8 , t0 . repeat_order_amount AS repeat_order_amount_9 , t0 . daily_use AS daily_use_10 , t0 . night_operation AS night_operation_11 , t0 . delivery_note_mail AS delivery_note_mail_12 , t0 . contact_person AS contact_person_13 , t0 . contact_person_phone AS contact_person_phone_14 , t0 . description AS description_15 , t0 . customer_not_present AS customer_not_present_16 , t0 . delivery_note_driver_text AS delivery_note_driver_text_17 , t0 . contact_id AS contact_id_18 , t0 . vehicle_id AS vehicle_id_19 , t0 . driver_id AS driver_id_20 , t0 . unloading_point_id AS unloading_point_id_21 , t0 . loading_point_id AS loading_point_id_22 , t0 . signature_id AS signature_id_23 , t0 . delivery_note_id AS delivery_note_id_24 , t0 . invoice_id AS invoice_id_25 FROM order_order t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . name AS name_3 , t0 . construction_site_cost_center AS construction_site_cost_center_4 , t0 . order_date AS order_date_5 , t0 . start_time AS start_time_6 , t0 . end_time AS end_time_7 , t0 . repeat_order AS repeat_order_8 , t0 . repeat_order_amount AS repeat_order_amount_9 , t0 . daily_use AS daily_use_10 , t0 . night_operation AS night_operation_11 , t0 . delivery_note_mail AS delivery_note_mail_12 , t0 . contact_person AS contact_person_13 , t0 . contact_person_phone AS contact_person_phone_14 , t0 . description AS description_15 , t0 . customer_not_present AS customer_not_present_16 , t0 . delivery_note_driver_text AS delivery_note_driver_text_17 , t0 . contact_id AS contact_id_18 , t0 . vehicle_id AS vehicle_id_19 , t0 . driver_id AS driver_id_20 , t0 . unloading_point_id AS unloading_point_id_21 , t0 . loading_point_id AS loading_point_id_22 , t0 . signature_id AS signature_id_23 , t0 . delivery_note_id AS delivery_note_id_24 , t0 . invoice_id AS invoice_id_25 FROM order_order t0 WHERE t0 . id = 149 ;
Copy
3
0.30 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . license_plate AS license_plate_3 , t0 . type AS type_4 , t0 . deleted_at AS deleted_at_5 , t0 . primary_driver_id AS primary_driver_id_6 , t0 . deleted_by_user_id AS deleted_by_user_id_7 FROM vehicle t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . license_plate AS license_plate_3 , t0 . type AS type_4 , t0 . deleted_at AS deleted_at_5 , t0 . primary_driver_id AS primary_driver_id_6 , t0 . deleted_by_user_id AS deleted_by_user_id_7 FROM vehicle t0 WHERE t0 . id = 6 ;
Copy
4
0.25 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . first_name AS first_name_5 , t0 . last_name AS last_name_6 , t0 . avatar AS avatar_7 FROM user t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . first_name AS first_name_5 , t0 . last_name AS last_name_6 , t0 . avatar AS avatar_7 FROM user t0 WHERE t0 . id = 7 ;
Copy
5
0.19 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . amount AS amount_3 , t0 . description AS description_4 , t0 . position AS position_5 , t0 . price AS price_6 , t0 . order_charge_id AS order_charge_id_7 , t0 . unit_id AS unit_id_8 FROM order_charge t0 WHERE t0 . order_charge_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . amount AS amount_3 , t0 . description AS description_4 , t0 . position AS position_5 , t0 . price AS price_6 , t0 . order_charge_id AS order_charge_id_7 , t0 . unit_id AS unit_id_8 FROM order_charge t0 WHERE t0 . order_charge_id = 149 ;
Copy
6
0.22 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . short_name AS short_name_3 , t0 . deleted_at AS deleted_at_4 , t0 . deleted_by_user_id AS deleted_by_user_id_5 FROM unit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . short_name AS short_name_3 , t0 . deleted_at AS deleted_at_4 , t0 . deleted_by_user_id AS deleted_by_user_id_5 FROM unit t0 WHERE t0 . id = 2 ;
Copy
7
0.21 ms
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . amount AS amount_3 , t0 . unit_id AS unit_id_4 , t0 . charge_id AS charge_id_5 FROM order_weigh_grade t0 WHERE t0 . charge_id = ?
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . amount AS amount_3 , t0 . unit_id AS unit_id_4 , t0 . charge_id AS charge_id_5 FROM order_weigh_grade t0 WHERE t0 . charge_id = 194 ;
Copy
8
0.22 ms
SELECT t0 . id AS id_1 , t0 . system_date_time AS system_date_time_2 , t0 . user_date AS user_date_3 , t0 . user_time AS user_time_4 , t0 . type AS type_5 , t0 . order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0 . order_relation_id = ? ORDER BY t0 . system_date_time DESC
SELECT t0 . id AS id_1 , t0 . system_date_time AS system_date_time_2 , t0 . user_date AS user_date_3 , t0 . user_time AS user_time_4 , t0 . type AS type_5 , t0 . order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0 . order_relation_id = 149 ORDER BY t0 . system_date_time DESC ;
Copy
9
0.20 ms
SELECT t0 . id AS id_1 , t0 . filename AS filename_2 , t0 . updated_at AS updated_at_3 , t0 . original_name AS original_name_4 , t0 . from_driver AS from_driver_5 , t0 . order_document_id AS order_document_id_6 FROM order_document t0 WHERE t0 . order_document_id = ?
SELECT t0 . id AS id_1 , t0 . filename AS filename_2 , t0 . updated_at AS updated_at_3 , t0 . original_name AS original_name_4 , t0 . from_driver AS from_driver_5 , t0 . order_document_id AS order_document_id_6 FROM order_document t0 WHERE t0 . order_document_id = 149 ;
Copy
10
0.22 ms
SELECT v0_ . id AS id_0 , v0_ . name AS name_1 , v0_ . license_plate AS license_plate_2 , v0_ . type AS type_3 , v0_ . deleted_at AS deleted_at_4 , v0_ . primary_driver_id AS primary_driver_id_5 , v0_ . deleted_by_user_id AS deleted_by_user_id_6 FROM vehicle v0_ WHERE v0_ . id IN (? ) ORDER BY v0_ . name ASC
SELECT v0_ . id AS id_0 , v0_ . name AS name_1 , v0_ . license_plate AS license_plate_2 , v0_ . type AS type_3 , v0_ . deleted_at AS deleted_at_4 , v0_ . primary_driver_id AS primary_driver_id_5 , v0_ . deleted_by_user_id AS deleted_by_user_id_6 FROM vehicle v0_ WHERE v0_ . id IN ('6' ) ORDER BY v0_ . name ASC ;
Copy
11
0.19 ms
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . roles AS roles_2 , u0_ . password AS password_3 , u0_ . first_name AS first_name_4 , u0_ . last_name AS last_name_5 , u0_ . avatar AS avatar_6 FROM user u0_ WHERE u0_ . id IN (? )
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . roles AS roles_2 , u0_ . password AS password_3 , u0_ . first_name AS first_name_4 , u0_ . last_name AS last_name_5 , u0_ . avatar AS avatar_6 FROM user u0_ WHERE u0_ . id IN ('7' );
Copy
12
0.18 ms
SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . short_name AS short_name_2 , u0_ . deleted_at AS deleted_at_3 , u0_ . deleted_by_user_id AS deleted_by_user_id_4 FROM unit u0_ WHERE u0_ . id IN (? )
SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . short_name AS short_name_2 , u0_ . deleted_at AS deleted_at_3 , u0_ . deleted_by_user_id AS deleted_by_user_id_4 FROM unit u0_ WHERE u0_ . id IN ('2' );
Copy
13
0.20 ms
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . amount AS amount_3 , t0 . unit_id AS unit_id_4 , t0 . charge_id AS charge_id_5 FROM order_weigh_grade t0 WHERE t0 . charge_id = ?
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . amount AS amount_3 , t0 . unit_id AS unit_id_4 , t0 . charge_id AS charge_id_5 FROM order_weigh_grade t0 WHERE t0 . charge_id = 194 ;
Copy
14
0.21 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . amount AS amount_3 , t0 . description AS description_4 , t0 . position AS position_5 , t0 . price AS price_6 , t0 . order_charge_id AS order_charge_id_7 , t0 . unit_id AS unit_id_8 FROM order_charge t0 WHERE t0 . order_charge_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . amount AS amount_3 , t0 . description AS description_4 , t0 . position AS position_5 , t0 . price AS price_6 , t0 . order_charge_id AS order_charge_id_7 , t0 . unit_id AS unit_id_8 FROM order_charge t0 WHERE t0 . order_charge_id = 149 ;
Copy
15
0.22 ms
SELECT t0 . id AS id_1 , t0 . system_date_time AS system_date_time_2 , t0 . user_date AS user_date_3 , t0 . user_time AS user_time_4 , t0 . type AS type_5 , t0 . order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0 . order_relation_id = ? ORDER BY t0 . system_date_time DESC
SELECT t0 . id AS id_1 , t0 . system_date_time AS system_date_time_2 , t0 . user_date AS user_date_3 , t0 . user_time AS user_time_4 , t0 . type AS type_5 , t0 . order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0 . order_relation_id = 149 ORDER BY t0 . system_date_time DESC ;
Copy
16
0.19 ms
SELECT t0 . id AS id_1 , t0 . filename AS filename_2 , t0 . updated_at AS updated_at_3 , t0 . original_name AS original_name_4 , t0 . from_driver AS from_driver_5 , t0 . order_document_id AS order_document_id_6 FROM order_document t0 WHERE t0 . order_document_id = ?
SELECT t0 . id AS id_1 , t0 . filename AS filename_2 , t0 . updated_at AS updated_at_3 , t0 . original_name AS original_name_4 , t0 . from_driver AS from_driver_5 , t0 . order_document_id AS order_document_id_6 FROM order_document t0 WHERE t0 . order_document_id = 149 ;
Copy
17
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
18
0.27 ms
UPDATE order_order SET construction_site_cost_center = ? WHERE id = ?
UPDATE order_order SET construction_site_cost_center = NULL WHERE id = 149 ;
Copy
19
0.11 ms
UPDATE order_charge SET amount = ? , price = ? WHERE id = ?
Parameters :
[
"1 "
"85 "
194
]
UPDATE order_charge SET amount = '1' , price = '85' WHERE id = 194 ;
Copy
20
3.24 ms
"COMMIT"