6a261fad84a9d: POST https://beta.jinchangxiao.com/v2/user/get-edit at 2026-06-08 09:49:33 am by 125.78.86.146
Database Queries
总计9条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 09:49:33.549 | 1.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC' |
| 09:49:33.555 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:49:33.556 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:49:33.567 | 4.6 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4 |
| 09:49:33.575 | 4.9 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id"=7 |
| 09:49:33.580 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=1001 |
| 09:49:33.581 | 0.7 ms | SELECT | SELECT "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('AccountManager', 'Admin', 'Treasurer')) |
| 09:49:33.582 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_user_meta" WHERE "user_id"=1001 |
| 09:49:33.583 | 3.4 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 7, 176, 'v2/user/get-edit', '{"posttime":"1780883373","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"7","version_code":"176","token":"0ae5e3b7da1a612a6d2d3523ce7a2e11"}', '{"code":200,"data":{"model":{"id":1001,"email":"lrc@toast.com.cn","name":"\u5218\u4eba\u8bda","user_status":"1","pinyin_shortcut":"lrc","sex":"M","birth_date":"1977-04-06","entry_date":"2005-06-06","department_id":4,"department_position_id":7,"mobile":"13501128560","telephone":"88864628","created_at":"2017-02-06 13:05:08","updated_at":"2026-04-24 14:52:43","id_number":"220523197704064411","native_place":"\u5409\u6797","graduate_school":"\u5409\u6797\u5de5\u4e1a\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u5e94\u7528","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"821","leave_date":null,"pinyin1":"liu","pinyin2":"ren","pinyin3":"cheng","pinyin4":null,"namecut1":"\u5218","namecut2":"\u4eba","namecut3":"\u8bda","namecut4":null,"budget_count":"2000425.78","profit_count":"88226.214434000000000000","bargain_count":"5","opportunity_budget_count":"697106.06","opportunity_count":"4","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":null,"work_on_remind":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"department":{"key":4,"name":"\u603b\u7ecf\u7406"},"departmentPosition":{"key":7,"name":"\u603b\u7ecf\u7406"},"userRoles":[{"key":77,"name":"Admin","display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458"},{"key":283,"name":"Treasurer","display_name":"\u8d22\u52a1\u4e13\u5458"},{"key":81,"name":"AccountManager","display_name":"\u5ba2\u6237\u7ecf\u7406"}],"avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"options":[{"key":"Users[sex]","name":"sex","value":[{"key":"M","name":"\u7537"},{"key":"F","name":"\u5973"}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"125.78.86.146","ua":"jinchangxiao\/1.0.40 (emulator emulator; HarmonyOS 6.1.0)"}', FALSE, '2026-06-08 09:49:33', 38661888) RETURNING "id" |