15:57:47.304 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
15:57:47.307 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:57:47.310 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='8172' |
15:57:47.311 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id"=8172 |
15:57:47.314 | 83.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8172) AND ("object_type"=20) |
15:57:47.398 | 11.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8172) AND ("object_type"=20) |
15:57:47.409 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=8172) AND ("object_type"=20) |
15:57:47.410 | 89.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=8172) AND ("object_type"=20)) OR (("target_id"=8172) AND ("target_object_type"=20)) |
15:57:47.499 | 0.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8172) AND ("term_id"=15) |
15:57:47.500 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8172) AND ("object_type"=7) |
15:57:47.501 | 2.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=8172) |
15:57:47.504 | 1.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=8172) |
15:57:47.505 | 13.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8172) AND ("object_type"=20) |
15:57:47.519 | 11.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8172) AND ("object_type"=20) |
15:57:47.531 | 3.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=8172 |
15:57:47.535 | 1.0 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\Reimbursements', 8172, '', '', 1001, '114.244.128.96') |
15:57:47.536 | 1.1 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/reimbursement/delete', '{"id":"8172","web_access_token":"Hlt1ZmLXNhK2kSIyrIUGksUdIH0iseH7"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u62a5\u9500\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"mod":0}', FALSE, '2025-09-17 15:57:47') RETURNING "id" |