6a587765eb9cf: POST https://beta.jinchangxiao.com/vue/search/project-by-client-id-with-bargain-date at 2026-07-16 02:17:09 pm by 114.244.130.25
Database Queries
总计6条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:17:09.968 | 0.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1013 |
| 14:17:09.970 | 0.5 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:17:09.971 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:17:09.973 | 0.5 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 |
| 14:17:09.973 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1003) |
| 14:17:09.979 | 2.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":"8xqSDHkpxFShwMjatgql1iJNjJHyfMBa"}', '{"code":2000,"result":[{"key":4187,"name":"\u6d4b\u91c7\u8d2d\u9700\u6c42\u7edf\u8ba1 (2026-07-16)","bargain_date":"2026-07-16","pinyin_shortcut":"ccgxqtj","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4}},{"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":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-16 14:17:09', 13528832) RETURNING "id" |