6a1e3ecf5ce3c: POST https://beta.jinchangxiao.com/vue/search/project-by-client-id-with-bargain-date at 2026-06-02 10:24:15 am by 221.216.117.119
Database Queries
总计5条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:24:15.806 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:24:15.809 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:24:15.810 | 8.1 ms | SELECT | SELECT "id" AS "key", "project_title" AS "name", "bargain_date", "pinyin_shortcut", "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='982') AND ("project_status"=3) ORDER BY "bargain_date" DESC |
| 10:24:15.819 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1003) |
| 10:24:15.820 | 6.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/search/project-by-client-id-with-bargain-date', '{"client_id":"982","web_access_token":"wTKilqflq6B-eOSFd1z6EzcpqcAU3V6m"}', '{"code":2000,"result":[{"key":4167,"name":"\u65b0\u5efa\u9879\u76ee (2026-05-14)","bargain_date":"2026-05-14","pinyin_shortcut":"xjxm","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":4166,"name":"9999 (2026-05-12)","bargain_date":"2026-05-12","pinyin_shortcut":"9999","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":4161,"name":"3535 (2026-04-23)","bargain_date":"2026-04-23","pinyin_shortcut":"3535","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":4164,"name":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a\/\u7f16\u8f91\/\u751f\u6210\u5408\u540c (2026-04-08)","bargain_date":"2026-04-08","pinyin_shortcut":"csxjsjbjscht","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":4155,"name":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a (2026-03-31)","bargain_date":"2026-03-31","pinyin_shortcut":"csxjsj","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"key":1111,"name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf (2019-09-23)","bargain_date":"2019-09-23","pinyin_shortcut":"ylsphytytx","created_by":1003,"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1}}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-02 10:24:15', 439194880) RETURNING "id" |