ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a44bbd2a3d4d: POST https://beta.jinchangxiao.com/vue/account/list at 2026-07-01 03:03:46 pm by 124.127.56.185

Database Queries

总计15条数据
TimeDurationTypeQuery
  
15:03:46.6750.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
15:03:46.6770.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
15:03:46.6790.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
15:03:46.6830.6 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND ("department_id"='9') ORDER BY "updated_at" DESC) "c"

[+] Explain
15:03:46.6840.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND ("department_id"='9') ORDER BY "updated_at" DESC LIMIT 20

[+] Explain
15:03:46.6850.3 msSELECTSELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5500, 5499, 5311))

[+] Explain
15:03:46.6860.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=9

[+] Explain
15:03:46.6860.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (19, 23)

[+] Explain
15:03:46.6860.3 msSELECTSELECT "id", "id" AS "key", "item_name" AS "name", "item_name", "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id" IN (5500, 5499, 5311)

[+] Explain
15:03:46.6870.3 msSELECTSELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name"='AccountManager'

[+] Explain
15:03:46.6870.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id" IN (5500, 5499, 5311)

[+] Explain
15:03:46.6880.3 msSELECTSELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"='1') AND ("name"='AccountManager')

[+] Explain
15:03:46.6890.3 msSELECTSELECT * FROM "global"."tbl_logins" WHERE "id"=1001

[+] Explain
15:03:46.6900.4 msSELECTSELECT * FROM "global"."tbl_enterprises" WHERE "id"=2

[+] Explain
15:03:46.6948.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/account/list', '{"AccountSearch":{"department_id":"9","department_position_id":""},"page":"1","web_access_token":"Ch010kzLIo0K3JLdI5ASnPkRyaIiGsY7"}', '{"code":2000,"result":{"list":[{"id":5500,"email":"","name":"\u6d4b\u8bd5","user_status":"1","pinyin_shortcut":"cs","sex":"F","birth_date":"2026-06-29","entry_date":"2026-06-29","department_id":9,"department_position_id":19,"mobile":"17600801168","telephone":"","created_at":"2026-06-29 09:50:55","updated_at":"2026-06-30 16:09:29","id_number":"","native_place":"","graduate_school":"","specialty":"","education":"","telephone_area_code":"","telephone_extension_number":"","leave_date":"","pinyin1":"ce","pinyin2":"shi","pinyin3":"","pinyin4":"","namecut1":"\u6d4b","namecut2":"\u8bd5","namecut3":"","namecut4":"","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":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"},"departmentPosition":{"id":19,"key":19,"name":"\u9879\u76ee\u7ecf\u7406"},"userRoles":[{"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":"\u5973","bgcolor":"#89c541"},{"id":5499,"email":"","name":"\u9648\u8c46\u8c46","user_status":"1","pinyin_shortcut":"cdd","sex":"F","birth_date":"2026-06-13","entry_date":"2026-06-29","department_id":9,"department_position_id":19,"mobile":"17611391636","telephone":"","created_at":"2026-06-29 09:49:29","updated_at":"2026-06-29 09:49:29","id_number":"","native_place":"","graduate_school":"","specialty":"","education":"","telephone_area_code":"","telephone_extension_number":"","leave_date":"","pinyin1":"chen","pinyin2":"dou","pinyin3":"dou","pinyin4":"","namecut1":"\u9648","namecut2":"\u8c46","namecut3":"\u8c46","namecut4":"","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":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"},"departmentPosition":{"id":19,"key":19,"name":"\u9879\u76ee\u7ecf\u7406"},"userRoles":[{"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":"\u5973","bgcolor":"#89c541"},{"id":5311,"email":"","name":"\u62d3\u5b9e\u79d1\u6280","user_status":"1","pinyin_shortcut":"tskj","sex":"F","birth_date":"2021-09-06","entry_date":"2021-09-06","department_id":9,"department_position_id":23,"mobile":"13911517620","telephone":"","created_at":"2021-09-06 12:39:02","updated_at":"2025-08-12 16:40:08","id_number":"","native_place":"","graduate_school":"","specialty":"","education":"","telephone_area_code":"","telephone_extension_number":"","leave_date":"","pinyin1":"ta","pinyin2":"shi","pinyin3":"ke","pinyin4":"ji","namecut1":"\u62d3","namecut2":"\u5b9e","namecut3":"\u79d1","namecut4":"\u6280","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":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"user_id":5311,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"},"departmentPosition":{"id":23,"key":23,"name":"\u9879\u76ee\u52a9\u7406"},"userRoles":[{"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":"\u5973","bgcolor":"#89c541"}],"create_notice":false,"can_create":true,"pagenation":{"totalcount":3,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"124.127.56.185","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/26.2 Safari\/605.1.15"}', FALSE, '2026-07-01 15:03:46', 21724928) RETURNING "id"

[+] Explain