Database Queries

总计9条数据
TimeDurationTypeQuery
  
17:01:47.0592.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='JdAKQRPBAuspvVC1Sc6RdzfONjla3CW_'

17:01:47.0631.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

17:01:47.0660.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

17:01:47.0730.8 msSELECTSELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

17:01:47.0742.5 msSELECTSELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id"=25

17:01:47.0772.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=5064

17:01:47.0801.2 msSELECTSELECT "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('软件开发', 'Engineer', 'Admin'))

17:01:47.0810.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_user_meta" WHERE "user_id"=5064

17:01:47.0842.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5064, 2, 1159, 'v2/user/get-edit', '{"access_token":"JdAKQRPBAuspvVC1Sc6RdzfONjla3CW_","device_type":"2","posttime":"1781168512","token":"f83c20fa257c545306be1827918171fa","version_code":"1159"}', '{"code":200,"data":{"model":{"id":5064,"email":"yaoxuechun@jinchangxiao.com","name":"\u59da\u96ea\u7eaf","user_status":"1","pinyin_shortcut":"yxc","sex":"F","birth_date":"1992-08-02","entry_date":"2018-03-06","department_id":10,"department_position_id":25,"mobile":"17610273960","telephone":"88864628","created_at":"2018-03-06 16:55:56","updated_at":"2026-04-23 17:24:00","id_number":"","native_place":"\u4fdd\u5b9a","graduate_school":"","specialty":"","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"845","leave_date":null,"pinyin1":"yao","pinyin2":"xue","pinyin3":"chun","pinyin4":null,"namecut1":"\u59da","namecut2":"\u96ea","namecut3":"\u7eaf","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","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":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"department":{"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"departmentPosition":{"key":25,"name":"\u4ea7\u54c1\u7ecf\u7406"},"userRoles":[{"key":77,"name":"Admin","display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458"},{"key":101,"name":"\u8f6f\u4ef6\u5f00\u53d1","display_name":"\u8f6f\u4ef6\u5f00\u53d1"},{"key":79,"name":"Engineer","display_name":"\u5de5\u7a0b\u5e08"}],"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.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":"223.104.39.224","ua":"jinchangxiao\/2.3.156 (iPhone 12; iOS 18.6.2; Scale\/3.00)"}', FALSE, '2026-06-11 17:01:47', 33937920) RETURNING "id"