Time | Duration | Type | Query |
---|---|---|---|
14:15:03.684 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
14:15:03.687 | 0.5 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
14:15:03.688 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
14:15:03.691 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3847' |
14:15:03.691 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id"=3847 ORDER BY "id" |
14:15:03.693 | 1.3 ms | SELECT | SELECT "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.695 | 1.5 ms | INSERT | INSERT 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" |