6899cd558ec37: POST https://beta.jinchangxiao.com/vue/account/list at 2025-08-11 07:00:37 pm by 114.246.236.177
Database Queries
总计16条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 19:00:37.588 | 2.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 19:00:37.591 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 19:00:37.594 | 1.5 ms | SELECT | SELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND (("name" ILIKE '%yjc%') OR ("email" ILIKE '%yjc%') OR ("pinyin_shortcut" ILIKE '%yjc%')) ORDER BY "updated_at" DESC) "c" |
| 19:00:37.596 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND (("name" ILIKE '%yjc%') OR ("email" ILIKE '%yjc%') OR ("pinyin_shortcut" ILIKE '%yjc%')) ORDER BY "updated_at" DESC LIMIT 20 |
| 19:00:37.597 | 0.8 ms | SELECT | SELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004) |
| 19:00:37.598 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 19:00:37.598 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id"=5 |
| 19:00:37.599 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "item_name" AS "name", "item_name", "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=1004 |
| 19:00:37.599 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name" IN ('AccountManager', 'SalesDirector', 'Operator') |
| 19:00:37.600 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=1004 |
| 19:00:37.600 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('AccountManager', 'SalesDirector', 'Operator')) |
| 19:00:37.601 | 0.3 ms | SELECT | SELECT * FROM "global"."tbl_logins" WHERE "id"=1001 |
| 19:00:37.602 | 0.4 ms | SELECT | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 19:00:37.604 | 3.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=29) AND ("visit_date"='2025-08-11') |
| 19:00:37.608 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=3, "last_visit_at"='now()' WHERE "id"=55221 |
| 19:00:37.609 | 1.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/account/list', '{"AccountSearch":{"department_id":"","department_position_id":"","keyword":"yjc"},"page":"1","web_access_token":"LUNl2piUGLWNrhpzvIlBH07DFeMsJmI_"}', '{"code":2000,"result":{"list":[{"id":1004,"email":"yijunchen@toast.com.cn","name":"\u4f0a\u5cfb\u8fb0","user_status":"1","pinyin_shortcut":"yjc","sex":"M","birth_date":"1981-02-25","entry_date":"2005-07-01","department_id":1,"department_position_id":5,"mobile":"13911627225","telephone":"","created_at":"2017-02-06 13:07:29","updated_at":"2024-05-02 21:35:14","id_number":"22072119810225021x","native_place":"\u5409\u6797\u677e\u539f","graduate_school":"\u4e2d\u56fd\u4eba\u6c11\u8b66\u5bdf\u6b66\u88c5\u90e8\u961f\u5b66\u9662","specialty":"\u6d88\u9632\u7ba1\u7406","education":"\u672c\u79d1","telephone_area_code":"","telephone_extension_number":"","leave_date":"","pinyin1":"yi","pinyin2":"jun","pinyin3":"chen","pinyin4":"","namecut1":"\u4f0a","namecut2":"\u5cfb","namecut3":"\u8fb0","namecut4":"","budget_count":"2647180.44","profit_count":"1098947.695668000000000000","bargain_count":"7","opportunity_budget_count":"1106340","opportunity_count":"2","work_log_score":"10","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":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"avatar":{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":5,"key":5,"name":"\u9500\u552e\u603b\u76d1"},"userRoles":[{"id":84,"key":84,"name":"SalesDirector","display_name":"\u9500\u552e\u603b\u76d1"},{"id":175,"key":175,"name":"Operator","display_name":"\u5ba2\u6237\u8fd0\u8425"},{"id":81,"key":81,"name":"AccountManager","display_name":"\u5ba2\u6237\u7ecf\u7406"}],"is_sales":true,"is_admin":false,"can_update_visit_auth":true,"can_update":true,"can_change_password":true,"can_delete":true,"can_destroy":false,"can_resend":false,"can_reactivate":false,"sex_display":"\u7537","bgcolor":"#89c541"}],"create_notice":false,"can_create":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-11 19:00:37') RETURNING "id" |