Database Queries

总计7条数据
TimeDurationTypeQuery
  
14:15:03.6842.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

14:15:03.6870.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

14:15:03.6881.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

14:15:03.6910.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3847'

14:15:03.6910.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id"=3847 ORDER BY "id"

14:15:03.6931.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"='3847') AND (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "r"."id"

14:15:03.6951.5 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":"3847","web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":{"allPaymentAmount":15878,"options":{"PurchaseContractPayments[purchaseContractPaymentApproveRels]":{"key":"PurchaseContractPayments[purchaseContractPaymentApproveRels]","name":"\u5173\u8054\u5ba1\u6279","value":[{"id":1732,"key":1732,"name":"retort (2025-07-03)","created_at":"2025-07-03 14:14:56"}]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 14:15:03') RETURNING "id"