Database Queries

总计18条数据
TimeDurationTypeQuery
  
16:27:44.4272.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1000

16:27:44.4301.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

16:27:44.4330.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='8159'

16:27:44.4341.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id"=8159

16:27:44.4351.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id"=8159) ORDER BY "id"

16:27:44.43916.5 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8159) AND ("object_type"=20)

16:27:44.45511.8 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8159) AND ("object_type"=20)

16:27:44.4670.4 msDELETEDELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=8159) AND ("object_type"=20)

16:27:44.468105.7 msUPDATEUPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=8159) AND ("object_type"=20)) OR (("target_id"=8159) AND ("target_object_type"=20))

16:27:44.57611.8 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8159) AND ("term_id"=15)

16:27:44.5901.2 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8159) AND ("object_type"=7)

16:27:44.5917.8 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=8159)

16:27:44.5993.8 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=8159)

16:27:44.60320.1 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8159) AND ("object_type"=20)

16:27:44.62311.3 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8159) AND ("object_type"=20)

16:27:44.6353.9 msDELETEDELETE FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=8159

16:27:44.6391.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\Reimbursements', 8159, '', '', 1000, '114.244.128.96')

16:27:44.6411.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 5, 'vue/reimbursement/delete', '{"id":"8159","web_access_token":"4lmnUHibaD9OEefzriQnJ9ZtXEOZJrDT"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u62a5\u9500\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"mod":0}', FALSE, '2025-09-17 16:27:44') RETURNING "id"