ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68978efe4279c: GET https://beta.jinchangxiao.com/vue/address-book/list at 2025-08-10 02:10:06 am by 20.171.207.75

Database Queries

总计10条数据
TimeDurationTypeQuery
  
02:10:06.2752.4 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
02:10:06.2791.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
02:10:06.2812.9 msSELECTSELECT COUNT(*) FROM (SELECT "u".* FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_departments" "d" ON d.id = u.department_id LEFT JOIN "a57be577deb434"."tbl_department_positions" "dp" ON dp.id = u.department_position_id LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON aa.user_id = u.id LEFT JOIN "a57be577deb434"."tbl_auth_items" "ai" ON ai.name = aa.item_name WHERE "u"."user_status" IN ('1', '2') GROUP BY "u"."id", "d"."order", "dp"."created_at" ORDER BY d.order, dp.created_at, u.pinyin1 nulls first, namecut1 nulls first, u.pinyin2 nulls first, namecut2 nulls first, u.pinyin3 nulls first, namecut3 nulls first, u.pinyin4 nulls first, namecut4 nulls first ) "c"

[+] Explain
02:10:06.2841.6 msSELECTSELECT "u".* FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_departments" "d" ON d.id = u.department_id LEFT JOIN "a57be577deb434"."tbl_department_positions" "dp" ON dp.id = u.department_position_id LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON aa.user_id = u.id LEFT JOIN "a57be577deb434"."tbl_auth_items" "ai" ON ai.name = aa.item_name WHERE "u"."user_status" IN ('1', '2') GROUP BY "u"."id", "d"."order", "dp"."created_at" ORDER BY d.order, dp.created_at, u.pinyin1 nulls first, namecut1 nulls first, u.pinyin2 nulls first, namecut2 nulls first, u.pinyin3 nulls first, namecut3 nulls first, u.pinyin4 nulls first, namecut4 nulls first LIMIT 20

[+] Explain
02:10:06.2860.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1, 2, 3, 8, 6)

[+] Explain
02:10:06.2860.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (7, 2, 5, 3, 6, 18, 60, 61, 16)

[+] Explain
02:10:06.2860.4 msSELECTSELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5332, 5087, 5300, 5295, 5449, 1004, 1005, 5085, 5311, 5248, 1022, 1023, 1017, 1015, 1011, 5360, 5446, 5252, 5388))

[+] Explain
02:10:06.2870.3 msSELECTSELECT "id", "id" AS "key", "item_name" AS "name", "item_name", "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id" IN (1001, 5332, 5087, 5300, 5295, 5449, 1004, 1005, 5085, 5311, 5248, 1022, 1023, 1017, 1015, 1011, 5360, 5446, 5252, 5388)

[+] Explain
02:10:06.2870.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name" IN ('Dispatcher', 'AccountManager', 'Engineer', 'CommercialAttache', 'Admin', 'SalesDirector', 'Operator', 'Accountant', '人力资源', 'Treasurer')

[+] Explain
02:10:06.2892.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/address-book/list', '[]', '{"code":2000,"result":{"list":[{"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":"2025-08-06 16:56:18","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":"5016468","profit_count":"76579.235000000000000000","bargain_count":"12","opportunity_budget_count":"360224.06","opportunity_count":"2","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":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"departmentPosition":{"id":7,"key":7,"name":"\u603b\u7ecf\u7406"},"avatar":{"user_id":1001,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"authAssignments":[{"id":114,"key":114,"name":"AccountManager","item_name":"AccountManager","user_id":1001,"item":{"id":81,"key":81,"name":"AccountManager"}},{"id":217,"key":217,"name":"Admin","item_name":"Admin","user_id":1001,"item":{"id":77,"key":77,"name":"Admin"}},{"id":487,"key":487,"name":"Treasurer","item_name":"Treasurer","user_id":1001,"item":{"id":283,"key":283,"name":"Treasurer"}}],"telephone_display":"010-88864628-821","bgcolor":"#89c541"},{"id":5332,"email":"huoweichao@toast.com.cn","name":"\u970d\u536b\u8d85","user_status":"1","pinyin_shortcut":"hwc","sex":"M","birth_date":"1991-08-10","entry_date":"2022-07-04","department_id":1,"department_position_id":2,"mobile":"15933300625","telephone":"88864628","created_at":"2022-07-04 09:43:32","updated_at":"2022-11-07 10:43:57","id_number":"130424199108102256","native_place":"\u6cb3\u5317\u7701\u90af\u90f8\u5e02","graduate_school":"\u90af\u90f8\u804c\u4e1a\u6280\u672f\u5b66\u9662","specialty":"\u793e\u4f1a\u4f53\u80b2","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"2022-11-07","pinyin1":"huo","pinyin2":"wei","pinyin3":"chao","pinyin4":null,"namecut1":"\u970d","namecut2":"\u536b","namecut3":"\u8d85","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":false,"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,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":2,"key":2,"name":"\u5ba2\u6237\u7ecf\u7406"},"avatar":{"user_id":5332,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"},"authAssignments":[{"id":432,"key":432,"name":"AccountManager","item_name":"AccountManager","user_id":5332,"item":{"id":81,"key":81,"name":"AccountManager"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"},{"id":5087,"email":"liuwei@toast.com.cn","name":"\u5218\u5fae","user_status":"1","pinyin_shortcut":"lw","sex":"F","birth_date":"1977-07-07","entry_date":"2005-05-01","department_id":1,"department_position_id":2,"mobile":"13910698067","telephone":"","created_at":"2019-01-16 14:27:07","updated_at":"2021-12-13 11:21:52","id_number":"","native_place":"\u5409\u6797","graduate_school":"\u5317\u4eac\u5efa\u8bbe\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u5e94\u7528","education":"\u672c\u79d1","telephone_area_code":"","telephone_extension_number":"","leave_date":"2020-06-12","pinyin1":"liu","pinyin2":"wei","pinyin3":null,"pinyin4":null,"namecut1":"\u5218","namecut2":"\u5fae","namecut3":null,"namecut4":null,"budget_count":"4222680","profit_count":"940357.724000000000000000","bargain_count":"9","opportunity_budget_count":"7262800","opportunity_count":"7","work_log_score":"4","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":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":2,"key":2,"name":"\u5ba2\u6237\u7ecf\u7406"},"avatar":{"user_id":5087,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"authAssignments":[{"id":256,"key":256,"name":"AccountManager","item_name":"AccountManager","user_id":5087,"item":{"id":81,"key":81,"name":"AccountManager"}}],"telephone_display":"","bgcolor":"#89c541"},{"id":5300,"email":"suqingyun@toast.com.cn","name":"\u82cf\u6e05\u4e91","user_status":"1","pinyin_shortcut":"sqy","sex":"F","birth_date":"1988-11-27","entry_date":"2021-06-28","department_id":1,"department_position_id":2,"mobile":"13889570890","telephone":"88864628","created_at":"2021-06-28 09:26:03","updated_at":"2021-11-29 16:30:12","id_number":"230231198811274721","native_place":"\u9ed1\u9f99\u6c5f\u7701\u62dc\u6cc9\u53bf","graduate_school":"\u9ed1\u9f99\u6c5f\u519c\u4e1a\u7ecf\u6d4e\u804c\u4e1a\u5b66\u9662","specialty":"\u5546\u52a1\u82f1\u8bed","education":"\u5927\u4e13","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"su","pinyin2":"qing","pinyin3":"yun","pinyin4":null,"namecut1":"\u82cf","namecut2":"\u6e05","namecut3":"\u4e91","namecut4":null,"budget_count":"899694","profit_count":"262214.033600000000000000","bargain_count":"60","opportunity_budget_count":"1280000","opportunity_count":"4","work_log_score":"15","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":true,"view_public":true,"client_remind_alarm_before":3,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":2,"key":2,"name":"\u5ba2\u6237\u7ecf\u7406"},"avatar":{"user_id":5300,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"authAssignments":[{"id":396,"key":396,"name":"AccountManager","item_name":"AccountManager","user_id":5300,"item":{"id":81,"key":81,"name":"AccountManager"}},{"id":409,"key":409,"name":"Operator","item_name":"Operator","user_id":5300,"item":{"id":175,"key":175,"name":"Operator"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"},{"id":5295,"email":"weizewen@toast.com.cn","name":"\u9b4f\u6cfd\u6587","user_status":"1","pinyin_shortcut":"wzw","sex":"F","birth_date":"1996-07-26","entry_date":"2021-04-07","department_id":1,"department_position_id":2,"mobile":"18601965887","telephone":"88864628","created_at":"2021-04-07 09:21:31","updated_at":"2021-11-29 16:29:49","id_number":"13112219960726282X","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u5929\u6d25\u6e24\u6d77\u804c\u4e1a\u6280\u672f\u5b66\u9662","specialty":"\u836f\u7269\u5236\u5242\u6280\u672f","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":null,"namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","namecut4":null,"budget_count":"1226049.7","profit_count":"313451.617170000000000000","bargain_count":"32","opportunity_budget_count":"727759.6","opportunity_count":"7","work_log_score":"18","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":true,"view_public":true,"client_remind_alarm_before":4,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":2,"key":2,"name":"\u5ba2\u6237\u7ecf\u7406"},"avatar":{"user_id":5295,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"authAssignments":[{"id":384,"key":384,"name":"AccountManager","item_name":"AccountManager","user_id":5295,"item":{"id":81,"key":81,"name":"AccountManager"}},{"id":385,"key":385,"name":"Operator","item_name":"Operator","user_id":5295,"item":{"id":175,"key":175,"name":"Operator"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"},{"id":5449,"email":"zhoulifei@toast.com.cn","name":"\u5468\u4e3d\u98de","user_status":"1","pinyin_shortcut":"zlf","sex":"F","birth_date":"1986-04-01","entry_date":"2025-05-12","department_id":1,"department_position_id":2,"mobile":"18622478636","telephone":"88864628","created_at":"2025-05-19 15:12:32","updated_at":"2025-05-19 15:12:32","id_number":"142703198604011242","native_place":"\u5929\u6d25\u5e02","graduate_school":"\u5929\u6d25\u5de5\u4e1a\u5927\u5b66","specialty":"\u4fe1\u606f\u4e0e\u8ba1\u7b97\u79d1\u5b66","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"zhou","pinyin2":"li","pinyin3":"fei","pinyin4":null,"namecut1":"\u5468","namecut2":"\u4e3d","namecut3":"\u98de","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"5","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":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":2,"key":2,"name":"\u5ba2\u6237\u7ecf\u7406"},"avatar":null,"authAssignments":[{"id":486,"key":486,"name":"AccountManager","item_name":"AccountManager","user_id":5449,"item":{"id":81,"key":81,"name":"AccountManager"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"},{"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":null,"pinyin1":"yi","pinyin2":"jun","pinyin3":"chen","pinyin4":null,"namecut1":"\u4f0a","namecut2":"\u5cfb","namecut3":"\u8fb0","namecut4":null,"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":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":5,"key":5,"name":"\u9500\u552e\u603b\u76d1"},"avatar":{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"authAssignments":[{"id":190,"key":190,"name":"AccountManager","item_name":"AccountManager","user_id":1004,"item":{"id":81,"key":81,"name":"AccountManager"}},{"id":232,"key":232,"name":"SalesDirector","item_name":"SalesDirector","user_id":1004,"item":{"id":84,"key":84,"name":"SalesDirector"}},{"id":340,"key":340,"name":"Operator","item_name":"Operator","user_id":1004,"item":{"id":175,"key":175,"name":"Operator"}}],"telephone_display":"","bgcolor":"#89c541"},{"id":1005,"email":"zhaohanyan@toast.com.cn","name":"\u8d75\u6657\u7131","user_status":"1","pinyin_shortcut":"zhy","sex":"F","birth_date":"1981-02-19","entry_date":"2006-03-01","department_id":1,"department_position_id":5,"mobile":"13911609683","telephone":"","created_at":"2017-02-06 13:08:05","updated_at":"2025-07-02 10:20:42","id_number":"130403198102190324","native_place":"\u90af\u90f8","graduate_school":"\u897f\u5b89\u6b27\u4e9a\u5b66\u9662","specialty":"\u82f1\u8bed","education":"\u672c\u79d1","telephone_area_code":"","telephone_extension_number":"","leave_date":null,"pinyin1":"zhao","pinyin2":"han","pinyin3":"yan","pinyin4":null,"namecut1":"\u8d75","namecut2":"\u6657","namecut3":"\u7131","namecut4":null,"budget_count":"6201982","profit_count":"1538097.795000000000000000","bargain_count":"14","opportunity_budget_count":"2568000","opportunity_count":"5","work_log_score":"17","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":3,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":1,"search_all_client":true,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"id":5,"key":5,"name":"\u9500\u552e\u603b\u76d1"},"avatar":{"user_id":1005,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"authAssignments":[{"id":146,"key":146,"name":"AccountManager","item_name":"AccountManager","user_id":1005,"item":{"id":81,"key":81,"name":"AccountManager"}},{"id":229,"key":229,"name":"SalesDirector","item_name":"SalesDirector","user_id":1005,"item":{"id":84,"key":84,"name":"SalesDirector"}},{"id":335,"key":335,"name":"Operator","item_name":"Operator","user_id":1005,"item":{"id":175,"key":175,"name":"Operator"}}],"telephone_display":"","bgcolor":"#89c541"},{"id":5085,"email":"huodongyang@toast.com.cn","name":"\u970d\u4e1c\u9633","user_status":"1","pinyin_shortcut":"hdy","sex":"M","birth_date":"1988-11-05","entry_date":"2012-06-01","department_id":2,"department_position_id":3,"mobile":"18513066231","telephone":"","created_at":"2019-01-04 09:17:53","updated_at":"2021-10-27 19:20:03","id_number":"130825198811053111","native_place":"","graduate_school":"\u4e91\u5357\u8b66\u5b98\u5b66\u9662","specialty":"","education":"","telephone_area_code":"","telephone_extension_number":"","leave_date":null,"pinyin1":"huo","pinyin2":"dong","pinyin3":"yang","pinyin4":null,"namecut1":"\u970d","namecut2":"\u4e1c","namecut3":"\u9633","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":"95","e_budget_count":"19280.0","e_profit_count":"11658.23000000000000000","e_client_count":"15","e_project_count":"29","e_point_count":"8831","visit_resource_sync":false,"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,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"departmentPosition":{"id":3,"key":3,"name":"\u6280\u672f\u5de5\u7a0b\u5e08"},"avatar":{"user_id":5085,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3b53061b-3148-3c6a-a16d-763f381ad1b6.jpg"},"authAssignments":[{"id":253,"key":253,"name":"Engineer","item_name":"Engineer","user_id":5085,"item":{"id":79,"key":79,"name":"Engineer"}}],"telephone_display":"","bgcolor":"#89c541"},{"id":5311,"email":"","name":"\u62d3\u5c0f\u6587","user_status":"1","pinyin_shortcut":"txw","sex":"F","birth_date":"2021-09-06","entry_date":"2021-09-06","department_id":2,"department_position_id":3,"mobile":"13911517620","telephone":"","created_at":"2021-09-06 12:39:02","updated_at":"2022-11-04 14:14:21","id_number":"","native_place":"","graduate_school":"","specialty":"","education":"","telephone_area_code":"","telephone_extension_number":"","leave_date":null,"pinyin1":"ta","pinyin2":"xiao","pinyin3":"wen","pinyin4":null,"namecut1":"\u62d3","namecut2":"\u5c0f","namecut3":"\u6587","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":true,"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,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"departmentPosition":{"id":3,"key":3,"name":"\u6280\u672f\u5de5\u7a0b\u5e08"},"avatar":{"user_id":5311,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"},"authAssignments":[{"id":415,"key":415,"name":"AccountManager","item_name":"AccountManager","user_id":5311,"item":{"id":81,"key":81,"name":"AccountManager"}},{"id":417,"key":417,"name":"Dispatcher","item_name":"Dispatcher","user_id":5311,"item":{"id":161,"key":161,"name":"Dispatcher"}}],"telephone_display":"","bgcolor":"#89c541"},{"id":5248,"email":"wenjialong@toast.com.cn","name":"\u6587\u4f73\u9f99","user_status":"1","pinyin_shortcut":"wjl","sex":"M","birth_date":"1996-03-11","entry_date":"2020-11-16","department_id":2,"department_position_id":3,"mobile":"15511215410","telephone":"88864628","created_at":"2020-11-16 09:35:44","updated_at":"2020-11-16 10:18:56","id_number":"142622199603117510","native_place":"\u5c71\u897f\u7701\u7ffc\u57ce\u53bf","graduate_school":"\u6cb3\u5317\u79d1\u6280\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u79d1\u5b66\u4e0e\u6280\u672f","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"wen","pinyin2":"jia","pinyin3":"long","pinyin4":null,"namecut1":"\u6587","namecut2":"\u4f73","namecut3":"\u9f99","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":"79","e_budget_count":"199391.0","e_profit_count":"75964.6601000000000000","e_client_count":"23","e_project_count":"30","e_point_count":"4014","visit_resource_sync":false,"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,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"departmentPosition":{"id":3,"key":3,"name":"\u6280\u672f\u5de5\u7a0b\u5e08"},"avatar":{"user_id":5248,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"},"authAssignments":[{"id":343,"key":343,"name":"Engineer","item_name":"Engineer","user_id":5248,"item":{"id":79,"key":79,"name":"Engineer"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"},{"id":1022,"email":"xushuo@toast.com.cn","name":"\u5f90\u7855","user_status":"1","pinyin_shortcut":"xs","sex":"M","birth_date":"1995-04-28","entry_date":"2016-11-21","department_id":2,"department_position_id":3,"mobile":"18630643723","telephone":"88864628","created_at":"2017-02-06 13:18:12","updated_at":"2018-10-25 09:57:46","id_number":"130705199504281230","native_place":"\u9999\u6cb3","graduate_school":"\u71d5\u4eac\u7406\u5de5\u5b66\u9662","specialty":"\u901a\u4fe1\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"815","leave_date":null,"pinyin1":"xu","pinyin2":"shuo","pinyin3":null,"pinyin4":null,"namecut1":"\u5f90","namecut2":"\u7855","namecut3":"\u53cb","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":"92","e_budget_count":"80900","e_profit_count":"44380.0000000000000000","e_client_count":"19","e_project_count":"31","e_point_count":"6796","visit_resource_sync":false,"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,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"departmentPosition":{"id":3,"key":3,"name":"\u6280\u672f\u5de5\u7a0b\u5e08"},"avatar":{"user_id":1022,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"},"authAssignments":[{"id":163,"key":163,"name":"Engineer","item_name":"Engineer","user_id":1022,"item":{"id":79,"key":79,"name":"Engineer"}}],"telephone_display":"010-88864628-815","bgcolor":"#89c541"},{"id":1023,"email":"zhouzijian@toast.com.cn","name":"\u5468\u5b50\u5065","user_status":"1","pinyin_shortcut":"zzj","sex":"M","birth_date":"1994-03-13","entry_date":"2016-09-12","department_id":2,"department_position_id":3,"mobile":"15104919818","telephone":"","created_at":"2017-02-06 13:18:34","updated_at":"2019-10-16 11:32:43","id_number":"15210119940313153x","native_place":"\u547c\u4f26\u8d1d\u5c14","graduate_school":"\u6e58\u6f6d\u5927\u5b66","specialty":"\u7f51\u7edc\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"","telephone_extension_number":"","leave_date":null,"pinyin1":"zhou","pinyin2":"zi","pinyin3":"jian","pinyin4":null,"namecut1":"\u5468","namecut2":"\u5b50","namecut3":"\u6ce2","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":"166","e_budget_count":"590775.34","e_profit_count":"154611.93066800000000000","e_client_count":"27","e_project_count":"45","e_point_count":"10325","visit_resource_sync":false,"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,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"departmentPosition":{"id":3,"key":3,"name":"\u6280\u672f\u5de5\u7a0b\u5e08"},"avatar":{"user_id":1023,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"},"authAssignments":[{"id":160,"key":160,"name":"Engineer","item_name":"Engineer","user_id":1023,"item":{"id":79,"key":79,"name":"Engineer"}}],"telephone_display":"","bgcolor":"#89c541"},{"id":1017,"email":"chemingfei@toast.com.cn","name":"\u8f66\u660e\u98de","user_status":"1","pinyin_shortcut":"cmf","sex":"M","birth_date":"1985-06-29","entry_date":"2016-12-15","department_id":2,"department_position_id":6,"mobile":"17601672879","telephone":"88864628","created_at":"2017-02-06 13:15:43","updated_at":"2020-04-20 19:52:23","id_number":"220122198506290916","native_place":"\u5409\u6797\u519c\u5b89","graduate_school":"\u70df\u53f0\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u79d1\u5b66\u4e0e\u6280\u672f","education":"\u672c\u79d1","telephone_area_code":"","telephone_extension_number":"","leave_date":null,"pinyin1":"che","pinyin2":"ming","pinyin3":"fei","pinyin4":null,"namecut1":"\u8f66","namecut2":"\u660e","namecut3":"\u745e","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":"289091.0","e_profit_count":"78734.1990000000000000","e_client_count":"13","e_project_count":"4","e_point_count":"1800","visit_resource_sync":false,"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":1,"search_all_client":true,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"departmentPosition":{"id":6,"key":6,"name":"\u6280\u672f\u603b\u76d1"},"avatar":{"user_id":1017,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"},"authAssignments":[{"id":78,"key":78,"name":"Engineer","item_name":"Engineer","user_id":1017,"item":{"id":79,"key":79,"name":"Engineer"}}],"telephone_display":"88864628","bgcolor":"#89c541"},{"id":1015,"email":"wuhao@toast.com.cn","name":"\u5434\u660a","user_status":"1","pinyin_shortcut":"wh","sex":"M","birth_date":"1976-10-31","entry_date":"2005-10-10","department_id":2,"department_position_id":6,"mobile":"13501285502","telephone":"88864628","created_at":"2017-02-06 13:14:18","updated_at":"2020-04-20 19:52:00","id_number":"110108197610310019","native_place":"\u5317\u4eac","graduate_school":"\u5317\u4eac\u4eac\u6d77\u5b66\u9662","specialty":"\u8ba1\u7b97\u673a\u7ba1\u7406","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"851","leave_date":null,"pinyin1":"wu","pinyin2":"hao","pinyin3":null,"pinyin4":null,"namecut1":"\u5434","namecut2":"\u660a","namecut3":null,"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":"13","e_budget_count":"4077018.2","e_profit_count":"885178.6814200000000000","e_client_count":"32","e_project_count":"14","e_point_count":"3000","visit_resource_sync":false,"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,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"departmentPosition":{"id":6,"key":6,"name":"\u6280\u672f\u603b\u76d1"},"avatar":{"user_id":1015,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"authAssignments":[{"id":97,"key":97,"name":"Engineer","item_name":"Engineer","user_id":1015,"item":{"id":79,"key":79,"name":"Engineer"}}],"telephone_display":"010-88864628-851","bgcolor":"#89c541"},{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","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":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"},"departmentPosition":{"id":18,"key":18,"name":"\u5546\u52a1\u7ecf\u7406"},"avatar":{"user_id":1011,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"authAssignments":[{"id":236,"key":236,"name":"Dispatcher","item_name":"Dispatcher","user_id":1011,"item":{"id":161,"key":161,"name":"Dispatcher"}},{"id":74,"key":74,"name":"CommercialAttache","item_name":"CommercialAttache","user_id":1011,"item":{"id":85,"key":85,"name":"CommercialAttache"}}],"telephone_display":"010-88864628-831","bgcolor":"#89c541"},{"id":5360,"email":"zhanghongfang@toast.com.cn","name":"\u5f20\u7ea2\u82b3","user_status":"1","pinyin_shortcut":"zhf","sex":"F","birth_date":"1997-04-07","entry_date":"2023-04-24","department_id":3,"department_position_id":60,"mobile":"18660100116","telephone":"88864628","created_at":"2023-04-24 09:37:05","updated_at":"2023-04-25 06:04:57","id_number":"371421199704072969","native_place":"\u5c71\u4e1c\u7701\u9675\u53bf","graduate_school":"\u5c71\u4e1c\u5e08\u8303\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u7f51\u8def\u6280\u672f","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"819","leave_date":null,"pinyin1":"zhang","pinyin2":"hong","pinyin3":"fang","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u7ea2","namecut3":"\u82b3","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":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"},"departmentPosition":{"id":60,"key":60,"name":"\u5546\u52a1\u4e13\u5458"},"avatar":{"user_id":5360,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"authAssignments":[{"id":445,"key":445,"name":"CommercialAttache","item_name":"CommercialAttache","user_id":5360,"item":{"id":85,"key":85,"name":"CommercialAttache"}}],"telephone_display":"010-88864628-819","bgcolor":"#89c541"},{"id":5446,"email":"liujuan@toast.com.cn","name":"\u5218\u5a1f","user_status":"1","pinyin_shortcut":"lj","sex":"F","birth_date":"1987-10-04","entry_date":"2025-03-03","department_id":8,"department_position_id":61,"mobile":"15699735973","telephone":"88864628","created_at":"2025-03-03 10:55:13","updated_at":"2025-03-03 10:55:13","id_number":"413026198710047225","native_place":"\u7518\u8083\u7701\u5609\u5cea\u5173\u5e02","graduate_school":"\u5317\u4eac\u4e1c\u65b9\u5927\u5b66","specialty":"\u5de5\u5546\u4f01\u4e1a\u7ba1\u7406","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"liu","pinyin2":"juan","pinyin3":null,"pinyin4":null,"namecut1":"\u5218","namecut2":"\u5a1f","namecut3":null,"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":false,"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,"department":{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90"},"departmentPosition":{"id":61,"key":61,"name":"\u62db\u8058\u4e13\u5458"},"avatar":{"user_id":5446,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"},"authAssignments":[{"id":484,"key":484,"name":"\u4eba\u529b\u8d44\u6e90","item_name":"\u4eba\u529b\u8d44\u6e90","user_id":5446,"item":{"id":110,"key":110,"name":"\u4eba\u529b\u8d44\u6e90"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"},{"id":5252,"email":"wangxiaoxiao@toast.com.cn","name":"\u738b\u7b11\u7b11","user_status":"1","pinyin_shortcut":"wxx","sex":"F","birth_date":"1995-06-16","entry_date":"2021-01-04","department_id":6,"department_position_id":16,"mobile":"18736768324","telephone":"88864628","created_at":"2021-01-04 09:48:16","updated_at":"2021-03-23 18:05:00","id_number":"411424199506165066","native_place":"\u6cb3\u5357\u7701\u67d8\u57ce\u53bf","graduate_school":"\u4e2d\u539f\u5de5\u5b66\u9662\u4fe1\u606f\u5546\u52a1\u5b66\u9662","specialty":"\u4f1a\u8ba1","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"wang","pinyin2":"xiao","pinyin3":"xiao","pinyin4":null,"namecut1":"\u738b","namecut2":"\u7b11","namecut3":"\u7b11","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":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"},"departmentPosition":{"id":16,"key":16,"name":"\u4f1a\u8ba1"},"avatar":{"user_id":5252,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"authAssignments":[{"id":346,"key":346,"name":"Accountant","item_name":"Accountant","user_id":5252,"item":{"id":99,"key":99,"name":"Accountant"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"},{"id":5388,"email":"yangyanxia@toast.com.cn","name":"\u6768\u71d5\u971e","user_status":"1","pinyin_shortcut":"yyx","sex":"F","birth_date":"1987-10-25","entry_date":"2023-11-27","department_id":6,"department_position_id":16,"mobile":"13693086045","telephone":"88864628","created_at":"2023-11-27 10:06:12","updated_at":"2023-11-27 12:41:56","id_number":"13072319871025002X","native_place":"\u6cb3\u5317\u7701\u5f20\u5bb6\u53e3\u5e02","graduate_school":"\u6cb3\u5317\u5927\u5b66","specialty":"\u5de5\u5546\u4f01\u4e1a\u7ba1\u7406","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"yang","pinyin2":"yan","pinyin3":"xia","pinyin4":null,"namecut1":"\u6768","namecut2":"\u71d5","namecut3":"\u971e","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":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,"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"},"departmentPosition":{"id":16,"key":16,"name":"\u4f1a\u8ba1"},"avatar":{"user_id":5388,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"authAssignments":[{"id":449,"key":449,"name":"Accountant","item_name":"Accountant","user_id":5388,"item":{"id":99,"key":99,"name":"Accountant"}}],"telephone_display":"010-88864628","bgcolor":"#89c541"}],"pagenation":{"totalcount":25,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-10 02:10:06') RETURNING "id"

[+] Explain