Database Queries

总计6条数据
TimeDurationTypeQuery
  
09:19:04.1632.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

09:19:04.1661.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

09:19:04.1690.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3850'

09:19:04.1700.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id"=3850 ORDER BY "id"

09:19:04.1711.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"

09:19:04.1731.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":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":{"allPaymentAmount":4324,"options":{"PurchaseContractPayments[purchaseContractPaymentApproveRels]":{"key":"PurchaseContractPayments[purchaseContractPaymentApproveRels]","name":"\u5173\u8054\u5ba1\u6279","value":[]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-04 09:19:04') RETURNING "id"