Database Queries

总计17条数据
TimeDurationTypeQuery
  
15:57:47.3042.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

15:57:47.3071.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

15:57:47.3100.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='8172'

15:57:47.3111.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id"=8172

15:57:47.31483.5 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8172) AND ("object_type"=20)

15:57:47.39811.2 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8172) AND ("object_type"=20)

15:57:47.4090.4 msDELETEDELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=8172) AND ("object_type"=20)

15:57:47.41089.0 msUPDATEUPDATE "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.4990.9 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8172) AND ("term_id"=15)

15:57:47.5000.7 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8172) AND ("object_type"=7)

15:57:47.5012.0 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=8172)

15:57:47.5041.9 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=8172)

15:57:47.50513.3 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8172) AND ("object_type"=20)

15:57:47.51911.4 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8172) AND ("object_type"=20)

15:57:47.5313.8 msDELETEDELETE FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=8172

15:57:47.5351.0 msINSERTINSERT 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.5361.1 msINSERTINSERT 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"