ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
69438f953f04e: POST https://beta.jinchangxiao.com/vue/analysis/view-contacts at 2025-12-18 01:22:29 pm by 223.72.15.22

Database Queries

总计18条数据
TimeDurationTypeQuery
  
13:22:29.2622.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
13:22:29.2651.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
13:22:29.2683.7 msSELECTSELECT COUNT(*) FROM (SELECT c.*, client.sales_rep FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_contact_mobiles" "cm" ON c.id = cm.contact_id WHERE (client_id is not null) AND ("cm"."mp_open_id" IS NOT NULL) AND ("c"."is_mp_bind"=TRUE) GROUP BY "c"."id", "client"."id" ORDER BY "c"."created_at" DESC) "c"

[+] Explain
13:22:29.2722.9 msSELECTSELECT c.*, client.sales_rep FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_contact_mobiles" "cm" ON c.id = cm.contact_id WHERE (client_id is not null) AND ("cm"."mp_open_id" IS NOT NULL) AND ("c"."is_mp_bind"=TRUE) GROUP BY "c"."id", "client"."id" ORDER BY "c"."created_at" DESC LIMIT 20

[+] Explain
13:22:29.2750.3 msSELECTSELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2

[+] Explain
13:22:29.2760.4 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3343, 3357, 2736, 1301, 1663, 3312, 3299, 2128, 2526, 93, 3263, 402, 2585, 2189, 20, 89, 90)

[+] Explain
13:22:29.2760.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 5087, 5295, 1004, 5311)

[+] Explain
13:22:29.2770.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5360, 5300, 5295, 5413, 5248, 5087, 1022, 5015, 5296, 1005, 1023)

[+] Explain
13:22:29.2771.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (6114, 6042, 6003, 5969, 5920, 5904, 5864, 5835, 5805, 5793, 5760, 5286, 5235, 5233, 5209, 5200, 5195, 5181, 5157, 5144)

[+] Explain
13:22:29.27922.2 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (6114, 6042, 6003, 5969, 5920, 5904, 5864, 5835, 5805, 5793, 5760, 5286, 5235, 5233, 5209, 5200, 5195, 5181, 5157, 5144)) GROUP BY "object_id"

[+] Explain
13:22:29.3012.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6114, 6042, 6003, 5969, 5920, 5904, 5864, 5835, 5805, 5793, 5760, 5286, 5235, 5233, 5209, 5200, 5195, 5181, 5157, 5144)

[+] Explain
13:22:29.3040.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (197, 199, 229, 184, 189, 187, 160, 140, 1, 327, 2, 215, 5, 226, 307, 203, 183, 190, 349, 356, 371, 377, 363, 359, 369, 367, 352, 366)) ORDER BY "sort"

[+] Explain
13:22:29.3050.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6114, 6042, 6003, 5969, 5920, 5904, 5864, 5835, 5805, 5793, 5760, 5286, 5235, 5233, 5209, 5200, 5195, 5181, 5157, 5144)

[+] Explain
13:22:29.3060.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (197, 199, 229, 184, 189, 187, 160, 140, 1, 327, 2, 215, 5, 226, 307, 203, 183, 190, 349, 356, 371, 377, 363, 359, 369, 367, 352, 366)) ORDER BY "sort"

[+] Explain
13:22:29.30618.2 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=14) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (6114, 6042, 6003, 5969, 5920, 5904, 5864, 5835, 5805, 5793, 5760, 5286, 5235, 5233, 5209, 5200, 5195, 5181, 5157, 5144)) GROUP BY "object_id"

[+] Explain
13:22:29.3273.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-18')

[+] Explain
13:22:29.3320.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=54, "last_visit_at"='now()' WHERE "id"=59594

[+] Explain
13:22:29.3331.9 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/view-contacts', '{"is_mp_bind":"1","page":"1"}', '{"code":2000,"result":{"list":[{"id":6114,"name":"\u738b\u4f1f\uff08\u4e2d\u90fd\u8054\u7cfb\u4eba\uff09","email":"","pinyin_shortcut":"wwzdlxr","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3343,"supplier_id":"","created_by":5360,"created_at":"2025-07-23 17:39:56","updated_at":"2025-07-23 17:39:56","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"wei","pinyin3":"zhong","pinyin4":"dou","namecut1":"\u738b","namecut2":"\u4f1f","namecut3":"\uff08","namecut4":"\u4e2d","is_mp_bind":true,"sales_rep":1004,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6895,"contact_id":6114,"mobile":"13911435372","mp_open_id":"oagch6aToyOsMaDAL1nES-qiKtK8","mobile_display":"13911435372"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u738b\u4f1f\uff08\u4e2d\u90fd\u8054\u7cfb\u4eba\uff09","email_display":"","telephone_display":""},{"id":6042,"name":"\u6f58\u4e94\u4fdd","email":"","pinyin_shortcut":"pwb","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"51293385","client_id":3357,"supplier_id":"","created_by":5300,"created_at":"2025-04-22 15:36:04","updated_at":"2025-04-27 09:19:36","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"pan","pinyin2":"wu","pinyin3":"bao","pinyin4":"","namecut1":"\u6f58","namecut2":"\u4e94","namecut3":"\u4fdd","namecut4":"","is_mp_bind":true,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3357,"key":3357,"name":"\u5317\u4eac\u8231\u6e7e\u6587\u5316\u8fd0\u8425\u7ba1\u7406\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6824,"contact_id":6042,"mobile":"18132788066","mp_open_id":"oagch6XCZ8x1nJH9-tWLbq6Y04NY","mobile_display":"18132788066"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u6f58\u4e94\u4fdd","email_display":"","telephone_display":"010-51293385"},{"id":6003,"name":"\u80e1\u4e54\u5e06","email":"","pinyin_shortcut":"hqf","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2736,"supplier_id":"","created_by":5300,"created_at":"2025-03-03 19:01:31","updated_at":"2025-03-03 19:01:31","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"hu","pinyin2":"qiao","pinyin3":"fan","pinyin4":"","namecut1":"\u80e1","namecut2":"\u4e54","namecut3":"\u5e06","namecut4":"","is_mp_bind":true,"sales_rep":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)","sales_rep":"","salesRep":{}},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6787,"contact_id":6003,"mobile":"18600417002","mp_open_id":"oagch6VqjkgD2XpVginGFeC1T0I4","mobile_display":"18600417002"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u80e1\u4e54\u5e06","email_display":"","telephone_display":""},{"id":5969,"name":"\u8c46\u6d77\u9e4f","email":"","pinyin_shortcut":"dhp","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"56305555","client_id":1301,"supplier_id":"","created_by":5295,"created_at":"2024-12-24 13:25:33","updated_at":"2025-05-06 11:42:39","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"dou","pinyin2":"hai","pinyin3":"peng","pinyin4":"","namecut1":"\u8c46","namecut2":"\u6d77","namecut3":"\u9e4f","namecut4":"","is_mp_bind":true,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":6758,"contact_id":5969,"mobile":"15829805724","mp_open_id":"oagch6Q2auGvrJvyqPx-R3HqP6X0","mobile_display":"15829805724"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u8c46\u6d77\u9e4f","email_display":"","telephone_display":"010-56305555"},{"id":5920,"name":"\u97e9\u65ed","email":"hanxu17480@autohome.com.cn","pinyin_shortcut":"hx","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":1663,"supplier_id":"","created_by":5300,"created_at":"2024-10-31 18:05:36","updated_at":"2025-05-29 12:03:52","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"han","pinyin2":"xu","pinyin3":"","pinyin4":"","namecut1":"\u97e9","namecut2":"\u65ed","namecut3":"","namecut4":"","is_mp_bind":true,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6709,"contact_id":5920,"mobile":"18310711812","mp_open_id":"oagch6ca8t2yVXWZjLRKzya-jwpE","mobile_display":"18310711812"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u97e9\u65ed","email_display":"hanxu17480@autohome.com.cn","telephone_display":""},{"id":5904,"name":"\u8d75\u5148\u751f","email":"","pinyin_shortcut":"zxs","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"8507","client_id":3312,"supplier_id":"","created_by":5413,"created_at":"2024-10-17 11:24:59","updated_at":"2024-11-14 11:25:44","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"6330","mp_open_id":"","pinyin1":"zhao","pinyin2":"xian","pinyin3":"sheng","pinyin4":"","namecut1":"\u8d75","namecut2":"\u5148","namecut3":"\u751f","namecut4":"","is_mp_bind":true,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3312,"key":3312,"name":"\u9f0e\u6656\u80a1\u6743\u6295\u8d44\u7ba1\u7406\uff08\u5929\u6d25\uff09\u6709\u9650\u516c\u53f8\/\u6da6\u6656\u6295\u8d44\u7ba1\u7406\uff08\u5929\u6d25\uff09\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"createdBy":{"id":5413,"key":5413,"name":"\u8096\u6167\u4e3d(\u5df2\u79bb\u804c)","sex":"F","user_status":"-1"},"mobiles":[{"id":6722,"contact_id":5904,"mobile":"18600753727","mp_open_id":"oagch6TD5KQX3DvLX1KXG2PntiFs","mobile_display":"18600753727"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u8d75\u5148\u751f","email_display":"","telephone_display":"010-8507-6330"},{"id":5864,"name":"\u5b59\u777f\u9633","email":"","pinyin_shortcut":"sry","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3299,"supplier_id":"","created_by":5248,"created_at":"2024-08-27 17:53:23","updated_at":"2024-08-27 17:53:23","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"sun","pinyin2":"rui","pinyin3":"yang","pinyin4":"","namecut1":"\u5b59","namecut2":"\u777f","namecut3":"\u9633","namecut4":"","is_mp_bind":true,"sales_rep":1004,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3299,"key":3299,"name":"\u6c5f\u897f\u6a1f\u6f9c\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"createdBy":{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","user_status":"1"},"mobiles":[{"id":6655,"contact_id":5864,"mobile":"17621981357","mp_open_id":"oagch6XLtFm6okNo_4nObnAJydFs","mobile_display":"17621981357"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5b59\u777f\u9633","email_display":"","telephone_display":""},{"id":5835,"name":"\u674e\u5965","email":"","pinyin_shortcut":"la","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2128,"supplier_id":"","created_by":5087,"created_at":"2024-07-24 17:57:43","updated_at":"2024-07-24 17:57:43","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"ao","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u5965","namecut3":"","namecut4":"","is_mp_bind":true,"sales_rep":5087,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6628,"contact_id":5835,"mobile":"15611040178","mp_open_id":"oagch6ftRot5zf0OI7cNmofZzqwc","mobile_display":"15611040178"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":{},"name_display":"\u674e\u5965","email_display":"","telephone_display":""},{"id":5805,"name":"\u90d1\u5b87\u540c","email":"","pinyin_shortcut":"zyt","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2526,"supplier_id":"","created_by":5087,"created_at":"2024-06-18 09:13:18","updated_at":"2024-06-18 09:13:18","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zheng","pinyin2":"yu","pinyin3":"tong","pinyin4":"","namecut1":"\u90d1","namecut2":"\u5b87","namecut3":"\u540c","namecut4":"","is_mp_bind":true,"sales_rep":5087,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6598,"contact_id":5805,"mobile":"18513662152","mp_open_id":"oagch6Z4OOvm_vyC31KRqujI77DM","mobile_display":"18513662152"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u90d1\u5b87\u540c","email_display":"","telephone_display":""},{"id":5793,"name":"\u6881\u6b63","email":"","pinyin_shortcut":"lz","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":93,"supplier_id":"","created_by":1022,"created_at":"2024-06-05 18:30:48","updated_at":"2024-06-05 18:30:48","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liang","pinyin2":"zheng","pinyin3":"","pinyin4":"","namecut1":"\u6881","namecut2":"\u6b63","namecut3":"","namecut4":"","is_mp_bind":true,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","user_status":"1"},"mobiles":[{"id":6586,"contact_id":5793,"mobile":"18610298995","mp_open_id":"oagch6aBrbhNPvMfokuVmtgGIOLw","mobile_display":"18610298995"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u6881\u6b63","email_display":"","telephone_display":""},{"id":5760,"name":"\u6768\u5cc4","email":"","pinyin_shortcut":"yy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"13501069905","telephone":"","client_id":3263,"supplier_id":"","created_by":5015,"created_at":"2024-05-13 14:27:43","updated_at":"2024-07-03 11:12:57","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yang","pinyin2":"yi","pinyin3":"sheng","pinyin4":"","namecut1":"\u6768","namecut2":"\u5cc4","namecut3":"\u751f","namecut4":"","is_mp_bind":true,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3263,"key":3263,"name":"\u5de5\u4e1a\u548c\u4fe1\u606f\u5316\u90e8\u4eba\u624d\u4ea4\u6d41\u4e2d\u5fc3","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e(\u5df2\u79bb\u804c)","sex":"F","user_status":"-1"},"mobiles":[{"id":6552,"contact_id":5760,"mobile":"13501069905","mp_open_id":"oagch6UIiXElzCU0Kwyix_EMNh1M","mobile_display":"13501069905"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u6768\u5cc4","email_display":"","telephone_display":""},{"id":5286,"name":"\u738b\u65ed\u6668","email":"","pinyin_shortcut":"wxc","sex":"F","birth_date":"","department":"","job_position":"","mobile":"","telephone":"01063611985","client_id":402,"supplier_id":"","created_by":5300,"created_at":"2024-04-24 15:05:23","updated_at":"2024-11-22 17:52:18","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"xu","pinyin3":"chen","pinyin4":"","namecut1":"\u738b","namecut2":"\u65ed","namecut3":"\u6668","namecut4":"","is_mp_bind":true,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw","mobile_display":"17860562122"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u738b\u65ed\u6668","email_display":"","telephone_display":"01063611985"},{"id":5235,"name":"\u5f20\u5174\u6e90","email":"","pinyin_shortcut":"zxy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2585,"supplier_id":"","created_by":5087,"created_at":"2024-03-15 09:59:00","updated_at":"2024-03-15 09:59:00","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"xing","pinyin3":"yuan","pinyin4":"","namecut1":"\u5f20","namecut2":"\u5174","namecut3":"\u6e90","namecut4":"","is_mp_bind":true,"sales_rep":5087,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2585,"key":2585,"name":"\u822a\u5929\u5b8f\u5eb7\u667a\u80fd\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6024,"contact_id":5235,"mobile":"18518352460","mp_open_id":"oagch6UBHUeHmphj41RBgKF1qLoI","mobile_display":"18518352460"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5f20\u5174\u6e90","email_display":"","telephone_display":""},{"id":5233,"name":"\u5f20\u5b50\u5cb3","email":"","pinyin_shortcut":"zzy","sex":"M","birth_date":"","department":"","job_position":"\u6280\u672f\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":93,"supplier_id":"","created_by":5296,"created_at":"2024-03-12 21:06:05","updated_at":"2024-03-12 21:07:25","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"zi","pinyin3":"yue","pinyin4":"","namecut1":"\u5f20","namecut2":"\u5b50","namecut3":"\u5cb3","namecut4":"","is_mp_bind":true,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"createdBy":{"id":5296,"key":5296,"name":"\u8d75\u5b87(\u5df2\u79bb\u804c)","sex":"M","user_status":"-1"},"mobiles":[{"id":6022,"contact_id":5233,"mobile":"15801415393","mp_open_id":"oagch6UX6EgAPHG2NBsLgSwNF2PA","mobile_display":"15801415393"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u5f20\u5b50\u5cb3","email_display":"","telephone_display":""},{"id":5209,"name":"\u4e8e\u6d2a\u8d85","email":"","pinyin_shortcut":"yhc","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2189,"supplier_id":"","created_by":5295,"created_at":"2024-02-22 10:16:22","updated_at":"2024-02-22 10:16:32","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yu","pinyin2":"hong","pinyin3":"chao","pinyin4":"","namecut1":"\u4e8e","namecut2":"\u6d2a","namecut3":"\u8d85","namecut4":"","is_mp_bind":true,"sales_rep":5311,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2189,"key":2189,"name":"\u5317\u4eac\u601d\u56fe\u573a\u666f\u6570\u636e\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"}},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":5999,"contact_id":5209,"mobile":"13611053533","mp_open_id":"oagch6b5g746tD-oEwJF3ZdplQxo","mobile_display":"13611053533"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u4e8e\u6d2a\u8d85","email_display":"","telephone_display":""},{"id":5200,"name":"\u5180\u6653\u9e4f","email":"","pinyin_shortcut":"jxp","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2024-01-31 16:01:14","updated_at":"2024-01-31 16:01:14","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ji","pinyin2":"xiao","pinyin3":"peng","pinyin4":"","namecut1":"\u5180","namecut2":"\u6653","namecut3":"\u9e4f","namecut4":"","is_mp_bind":true,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":5988,"contact_id":5200,"mobile":"13552776255","mp_open_id":"oagch6XX7REPbRRWbbUG29EuEzH8","mobile_display":"13552776255"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5180\u6653\u9e4f","email_display":"","telephone_display":""},{"id":5195,"name":"\u674e\u4e1b\u6ed4","email":"","pinyin_shortcut":"lct","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":89,"supplier_id":"","created_by":1023,"created_at":"2024-01-27 09:19:51","updated_at":"2024-01-27 09:19:51","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"cong","pinyin3":"tao","pinyin4":"","namecut1":"\u674e","namecut2":"\u4e1b","namecut3":"\u6ed4","namecut4":"","is_mp_bind":true,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":5983,"contact_id":5195,"mobile":"18953530050","mp_open_id":"oagch6Vwf8HYZUh95a1_6l-hP8HQ","mobile_display":"18953530050"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u674e\u4e1b\u6ed4","email_display":"","telephone_display":""},{"id":5181,"name":"\u4efb\u53f6\u8f89","email":"","pinyin_shortcut":"ryh","sex":"M","birth_date":"","department":"","job_position":"\u6280\u672f\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":93,"supplier_id":"","created_by":1005,"created_at":"2024-01-23 11:50:38","updated_at":"2024-01-23 11:50:38","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ren","pinyin2":"ye","pinyin3":"hui","pinyin4":"","namecut1":"\u4efb","namecut2":"\u53f6","namecut3":"\u8f89","namecut4":"","is_mp_bind":true,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":5969,"contact_id":5181,"mobile":"18301451285","mp_open_id":"oagch6TrH5pF-sZzMkwGjjSNeohg","mobile_display":"18301451285"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":{},"name_display":"\u4efb\u53f6\u8f89","email_display":"","telephone_display":""},{"id":5157,"name":"\u5f20\u5bb6\u534e","email":"","pinyin_shortcut":"zjh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":1301,"supplier_id":"","created_by":5295,"created_at":"2024-01-10 15:51:10","updated_at":"2024-01-10 15:51:10","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"jia","pinyin3":"hua","pinyin4":"","namecut1":"\u5f20","namecut2":"\u5bb6","namecut3":"\u534e","namecut4":"","is_mp_bind":true,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":5944,"contact_id":5157,"mobile":"15600907087","mp_open_id":"oagch6WCZsXQmR-GxBwRKssHdktA","mobile_display":"15600907087"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5f20\u5bb6\u534e","email_display":"","telephone_display":""},{"id":5144,"name":"\u8d75\u91d1\u7a0b","email":"","pinyin_shortcut":"zjc","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":"","created_by":5295,"created_at":"2024-01-03 11:01:28","updated_at":"2024-02-20 15:28:09","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhao","pinyin2":"jin","pinyin3":"cheng","pinyin4":"","namecut1":"\u8d75","namecut2":"\u91d1","namecut3":"\u7a0b","namecut4":"","is_mp_bind":true,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":5931,"contact_id":5144,"mobile":"13602159075","mp_open_id":"oagch6UFe3mx9ON7HIBpToY84YWE","mobile_display":"13602159075"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u8d75\u91d1\u7a0b","email_display":"","telephone_display":""}],"pagenation":{"totalcount":284,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 13:22:29') RETURNING "id"

[+] Explain