Database Queries

总计5条数据
TimeDurationTypeQuery
  
15:20:51.9700.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5493

15:20:51.9720.9 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493

15:20:51.9741.1 msSELECTSELECT "id" AS "key", "project_title" AS "name", "bargain_date", "pinyin_shortcut", "created_by" FROM "o6a13e2c574d5a"."tbl_projects" WHERE ("client_id"='1') AND ("project_status"=3) ORDER BY "bargain_date" DESC

15:20:51.9750.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493

15:20:51.9761.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5493, 5, 'vue/search/project-by-client-id-with-bargain-date', '{"client_id":"1","web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":[{"key":1,"name":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260527001 (2026-05-27)","bargain_date":"2026-05-27","pinyin_shortcut":"xsxssc20260527001","created_by":5493,"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1}}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 15:20:51', 7983104) RETURNING "id"