Database Queries

总计9条数据
TimeDurationTypeQuery
  
13:28:32.9050.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5495

13:28:32.9070.4 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495

13:28:32.9070.3 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495

13:28:32.9080.4 msSELECTSELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=4

13:28:32.9090.3 msSELECTSELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_department_positions" WHERE "id"=9

13:28:32.9090.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE "user_id"=5495

13:28:32.9090.5 msSELECTSELECT "id" AS "key", "name", "display_name" FROM "o6a13e2c574d5a"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('Engineer', 'Admin', 'AccountManager', 'CommercialAttache', 'Treasurer', 'FinancialAudit'))

13:28:32.9100.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE "user_id"=5495

13:28:32.9111.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/user/get-edit', '{"web_access_token":"IuY-ym_H6ExVPmdOBBbdelHiinliWD4j"}', '{"code":2000,"result":{"model":{"id":5495,"email":"","name":"\u903b\u8f91\u6d4b\u8bd5","user_status":"1","pinyin_shortcut":"ljcs","sex":"F","birth_date":"2026-05-25","entry_date":"2026-05-25","department_id":4,"department_position_id":9,"mobile":"17600801168","telephone":"","created_at":"2026-05-25 13:53:25","updated_at":"2026-06-01 13:25:07","id_number":"","native_place":"","graduate_school":"","specialty":"","education":"","telephone_area_code":"","telephone_extension_number":"","leave_date":null,"pinyin1":"luo","pinyin2":"ji","pinyin3":"ce","pinyin4":"shi","namecut1":"\u903b","namecut2":"\u8f91","namecut3":"\u6d4b","namecut4":"\u8bd5","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":true,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"department":{"key":4,"name":"\u5546\u52a1\u90e8"},"departmentPosition":{"key":9,"name":"\u5546\u52a1\u7ecf\u7406"},"userRoles":[{"key":2,"name":"Admin","display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458"},{"key":3,"name":"AccountManager","display_name":"\u5ba2\u6237\u7ecf\u7406"},{"key":4,"name":"Engineer","display_name":"\u5de5\u7a0b\u5e08"},{"key":6,"name":"Treasurer","display_name":"\u8d22\u52a1\u4e13\u5458"},{"key":7,"name":"FinancialAudit","display_name":"\u8d22\u52a1\u5ba1\u8ba1"},{"key":5,"name":"CommercialAttache","display_name":"\u5546\u52a1\u4e13\u5458"}],"sex_display":"\u5973"},"options":{"Users[sex]":{"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":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/147.0.0.0 Safari\/537.36"}', FALSE, '2026-06-01 13:28:32', 6930688) RETURNING "id"