1
5.79 ms
SELECT t0 . uuid AS uuid_1 , t0 . username AS username_2 , t0 . email AS email_3 , t0 . timezone AS timezone_4 , t0 . password_hash AS password_hash_5 , t0 . password_changed_at AS password_changed_at_6 , t0 . is_active AS is_active_7 , t0 . is_admin AS is_admin_8 , t0 . created_by AS created_by_9 , t0 . updated_by AS updated_by_10 FROM users t0 WHERE t0 . uuid = ?
Parameters :
[
"019a737a-e670-7415-ab36-5ec0bb1437d5 "
]
SELECT t0 . uuid AS uuid_1 , t0 . username AS username_2 , t0 . email AS email_3 , t0 . timezone AS timezone_4 , t0 . password_hash AS password_hash_5 , t0 . password_changed_at AS password_changed_at_6 , t0 . is_active AS is_active_7 , t0 . is_admin AS is_admin_8 , t0 . created_by AS created_by_9 , t0 . updated_by AS updated_by_10 FROM users t0 WHERE t0 . uuid = '019a737a-e670-7415-ab36-5ec0bb1437d5' ;
Copy
2
3.32 ms
SELECT t0 . uuid AS uuid_1 , t0 . gender AS gender_2 , t0 . style_uuid AS style_uuid_3 , t0 . life_sphere_uuid AS life_sphere_uuid_4 , t0 . created_by AS created_by_5 , t0 . updated_by AS updated_by_6 FROM groups t0 WHERE t0 . uuid = ? LIMIT 1
Parameters :
[
"019a4f1d-a48e-743b-8177-635d0c53d684 "
]
SELECT t0 . uuid AS uuid_1 , t0 . gender AS gender_2 , t0 . style_uuid AS style_uuid_3 , t0 . life_sphere_uuid AS life_sphere_uuid_4 , t0 . created_by AS created_by_5 , t0 . updated_by AS updated_by_6 FROM groups t0 WHERE t0 . uuid = '019a4f1d-a48e-743b-8177-635d0c53d684' LIMIT 1 ;
Copy
3
3.09 ms
SELECT t0 . uuid AS uuid_1 , t0 . name AS name_2 , t0 . name_en AS name_en_3 , t0 . look_type_season AS look_type_season_4 , t0 . catalog_uuid AS catalog_uuid_5 , t0 . layer_uuid AS layer_uuid_6 , t0 . created_by AS created_by_7 , t0 . updated_by AS updated_by_8 FROM items t0 WHERE t0 . uuid = ? LIMIT 1
Parameters :
[
"019a6d90-e68c-718b-9393-66acf744f7cd "
]
SELECT t0 . uuid AS uuid_1 , t0 . name AS name_2 , t0 . name_en AS name_en_3 , t0 . look_type_season AS look_type_season_4 , t0 . catalog_uuid AS catalog_uuid_5 , t0 . layer_uuid AS layer_uuid_6 , t0 . created_by AS created_by_7 , t0 . updated_by AS updated_by_8 FROM items t0 WHERE t0 . uuid = '019a6d90-e68c-718b-9393-66acf744f7cd' LIMIT 1 ;
Copy
4
3.07 ms
SELECT t0 . uuid AS uuid_1 , t0 . group_uuid AS group_uuid_2 , t0 . item_uuid AS item_uuid_3 , t0 . created_by AS created_by_4 , t0 . updated_by AS updated_by_5 FROM group_items t0 WHERE t0 . group_uuid = ? AND t0 . item_uuid = ? LIMIT 1
Parameters :
[
"019a4f1d-a48e-743b-8177-635d0c53d684 "
"019a6d90-e68c-718b-9393-66acf744f7cd "
]
SELECT t0 . uuid AS uuid_1 , t0 . group_uuid AS group_uuid_2 , t0 . item_uuid AS item_uuid_3 , t0 . created_by AS created_by_4 , t0 . updated_by AS updated_by_5 FROM group_items t0 WHERE t0 . group_uuid = '019a4f1d-a48e-743b-8177-635d0c53d684' AND t0 . item_uuid = '019a6d90-e68c-718b-9393-66acf744f7cd' LIMIT 1 ;
Copy
5
3.07 ms
SELECT t0 . group_item_uuid AS group_item_uuid_1 , t0 . characteristic_value_uuid AS characteristic_value_uuid_2 , t0 . characteristic_uuid AS characteristic_uuid_3 , t0 . created_by AS created_by_4 , t0 . updated_by AS updated_by_5 FROM group_item_characteristic_values t0 WHERE t0 . group_item_uuid = ?
Parameters :
[
"019c56ca-0b49-784f-9891-ac768e213bd2 "
]
SELECT t0 . group_item_uuid AS group_item_uuid_1 , t0 . characteristic_value_uuid AS characteristic_value_uuid_2 , t0 . characteristic_uuid AS characteristic_uuid_3 , t0 . created_by AS created_by_4 , t0 . updated_by AS updated_by_5 FROM group_item_characteristic_values t0 WHERE t0 . group_item_uuid = '019c56ca-0b49-784f-9891-ac768e213bd2' ;
Copy
6
2.18 ms
SELECT t0 . group_item_uuid AS group_item_uuid_1 , t0 . nomenclature_uuid AS nomenclature_uuid_2 , t0 . created_by AS created_by_3 , t0 . updated_by AS updated_by_4 FROM group_item_nomenclatures t0 WHERE t0 . group_item_uuid = ?
Parameters :
[
"019c56ca-0b49-784f-9891-ac768e213bd2 "
]
SELECT t0 . group_item_uuid AS group_item_uuid_1 , t0 . nomenclature_uuid AS nomenclature_uuid_2 , t0 . created_by AS created_by_3 , t0 . updated_by AS updated_by_4 FROM group_item_nomenclatures t0 WHERE t0 . group_item_uuid = '019c56ca-0b49-784f-9891-ac768e213bd2' ;
Copy
7
0.39 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
8
4.10 ms
DELETE FROM group_items WHERE uuid = ?
Parameters :
[
"019c56ca-0b49-784f-9891-ac768e213bd2 "
]
DELETE FROM group_items WHERE uuid = '019c56ca-0b49-784f-9891-ac768e213bd2' ;
Copy
9
2.16 ms
"COMMIT"