Database Queries

总计6条数据
TimeDurationTypeQuery
  
11:35:19.2032.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

11:35:19.2071.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

11:35:19.2090.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3850'

11:35:19.2100.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id"=3850 ORDER BY "id"

11:35:19.2111.3 msSELECTSELECT "r"."id", "r"."id" AS "key", "r"."title" AS "name", "r"."created_at" FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE ("r"."purchase_contract_id"='3850') AND (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "r"."id"

11:35:19.2131.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/get-new-payment', '{"contract_id":"3850","web_access_token":"tld3jO0KyGCnBfJLTA8332fg4dJPv04V"}', '{"code":2000,"result":{"allPaymentAmount":4322,"options":{"PurchaseContractPayments[purchaseContractPaymentApproveRels]":{"key":"PurchaseContractPayments[purchaseContractPaymentApproveRels]","name":"\u5173\u8054\u5ba1\u6279","value":[{"id":1735,"key":1735,"name":"\u6d4b\u8bd5\u8d39\u7528\u5408\u540c (2025-07-04)","created_at":"2025-07-04 10:16:07"}]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-04 11:35:19') RETURNING "id"