Database Queries

总计6条数据
TimeDurationTypeQuery
  
13:53:37.0212.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5250

13:53:37.0241.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

13:53:37.0270.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3834'

13:53:37.0270.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id"=3834 ORDER BY "id"

13:53:37.0291.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"='3834') AND (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "r"."id"

13:53:37.0311.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/purchase-contract/get-new-payment', '{"contract_id":"3834","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"allPaymentAmount":900000000,"options":{"PurchaseContractPayments[purchaseContractPaymentApproveRels]":{"key":"PurchaseContractPayments[purchaseContractPaymentApproveRels]","name":"\u5173\u8054\u5ba1\u6279","value":[{"id":1725,"key":1725,"name":"asd (2025-05-22)","created_at":"2025-05-22 13:40:51"},{"id":1726,"key":1726,"name":"123123 (2025-05-22)","created_at":"2025-05-22 13:41:04"}]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-01 13:53:37') RETURNING "id"