Database Queries

总计17条数据
TimeDurationTypeQuery
  
11:41:54.9832.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1000

11:41:54.9861.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

11:41:54.9890.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='8063'

11:41:54.9901.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id"=8063) ORDER BY "id"

11:41:54.99316.4 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8063) AND ("object_type"=20)

11:41:55.01012.8 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8063) AND ("object_type"=20)

11:41:55.0230.4 msDELETEDELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=8063) AND ("object_type"=20)

11:41:55.02384.7 msUPDATEUPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=8063) AND ("object_type"=20)) OR (("target_id"=8063) AND ("target_object_type"=20))

11:41:55.1080.4 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8063) AND ("term_id"=15)

11:41:55.1090.2 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8063) AND ("object_type"=7)

11:41:55.1091.9 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=8063)

11:41:55.1111.7 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=8063)

11:41:55.11313.1 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8063) AND ("object_type"=20)

11:41:55.12611.1 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8063) AND ("object_type"=20)

11:41:55.1384.2 msDELETEDELETE FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=8063

11:41:55.1421.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', 8063, '', '', 1000, '114.246.239.150')

11:41:55.1441.0 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":"8063","web_access_token":"QI4EvCSrRVS9_66CXnJH5sPrzaRvkreb"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u62a5\u9500\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"mod":0}', FALSE, '2025-09-09 11:41:55') RETURNING "id"