10:36:42.579 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L' |
10:36:42.583 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
10:36:42.585 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"='37025' |
10:36:42.588 | 12.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=37025) AND ("object_type"=19) |
10:36:42.601 | 11.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=37025) AND ("object_type"=19) |
10:36:42.612 | 3.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=37025) AND ("object_type"=19) |
10:36:42.617 | 49.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_user_action_logs" SET "is_delete"=TRUE WHERE (("object_id"=37025) AND ("object_type"=19)) OR (("target_id"=37025) AND ("target_object_type"=19)) |
10:36:42.667 | 971.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=37025) AND ("object_type"=19)) OR (("target_id"=37025) AND ("target_object_type"=19)) |
10:36:43.639 | 1.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id"=37025) |
10:36:43.641 | 11.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=37025) AND ("object_type"=19) |
10:36:43.652 | 11.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=37025) AND ("object_type"=19) |
10:36:43.664 | 5.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_work_logs" WHERE "id"=37025 |
10:36:43.669 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\WorkLogs', 37025, '', '', 5016, '223.104.41.148') |
10:36:43.672 | 1.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 2, 1141, 'v2/work-log/delete', '{"access_token":"J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L","device_type":"2","id":"37025","posttime":"1750818944","token":"52f9860323882cd7da39869fb235fbd2","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5de5\u4f5c\u65e5\u5fd7\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}]}', FALSE, '2025-06-25 10:36:43') RETURNING "id" |