6866223c89ce8: POST https://beta.jinchangxiao.com/vue/search/purchase-contract-by-supplier-id at 2025-07-03 02:25:00 pm by 114.254.1.137
Database Queries
总计8条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:25:00.580 | 2.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:25:00.584 | 3.4 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:25:00.589 | 5.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:25:00.595 | 1.3 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" AS "name", "created_at" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "supplier_id"='431' ORDER BY "signed_at" DESC |
| 14:25:00.597 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3847, 3848, 3834, 2364, 2216, 2198, 2114) ORDER BY "id" |
| 14:25:00.598 | 0.7 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (14, 2120, 3278, 3334, 2133) |
| 14:25:00.599 | 0.8 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2706, 3801, 3786) |
| 14:25:00.603 | 2.0 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/search/purchase-contract-by-supplier-id', '{"supplier_id":"431","web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":[{"id":3847,"key":3847,"name":"646456456(2025-07-03)","created_at":"2025-07-03 14:01:32","purchaseClientRels":[{"id":3135,"contract_id":3847,"client_id":2133,"project_id":null,"client":{"id":2133,"key":2133,"name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5311},"project":null}]},{"id":3848,"key":3848,"name":"\u6d4b\u8bd5\u8d39\u7528\u5408\u540c(2025-07-03)","created_at":"2025-07-03 14:21:31","purchaseClientRels":[]},{"id":3834,"key":3834,"name":"\u6d4b\u8bd5\u9500\u552e\u5408\u540c\u5173\u8054\u91c7\u8d2d\u5408\u540c\u95ee\u9898(2025-04-14)","created_at":"2025-04-14 14:27:28","purchaseClientRels":[{"id":3128,"contract_id":3834,"client_id":3278,"project_id":3801,"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3801,"key":3801,"name":"\u8d1f\u6570\u95ee\u9898"}},{"id":3131,"contract_id":3834,"client_id":3334,"project_id":3786,"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001},"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1"}}]},{"id":2364,"key":2364,"name":"BJHLXT-GFJ-20220610(2022-08-03)","created_at":"2022-08-03 10:59:27","purchaseClientRels":[]},{"id":2216,"key":2216,"name":"20220211(2022-02-25)","created_at":"2022-02-25 15:17:24","purchaseClientRels":[]},{"id":2198,"key":2198,"name":"BJHLXT-GFJ-2021207(2022-01-21)","created_at":"2022-01-21 09:26:04","purchaseClientRels":[{"id":962,"contract_id":2198,"client_id":2120,"project_id":2706,"client":{"id":2120,"key":2120,"name":"\u8fbd\u5b81\u5e86\u9633\u7279\u79cd\u5316\u5de5\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1004},"project":{"id":2706,"key":2706,"name":"\u56fd\u4ea7\u5316\u6d4b\u8bd5\u673a"}}]},{"id":2114,"key":2114,"name":"BJHLXT-GFJ-20210928(2021-10-26)","created_at":"2021-10-26 11:38:52","purchaseClientRels":[{"id":873,"contract_id":2114,"client_id":14,"project_id":null,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":null}]}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 14:25:00') RETURNING "id" |