ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68902926587ac: POST https://beta.jinchangxiao.com/vue/analysis/engineer-contact-list at 2025-08-04 11:29:42 am by 124.64.23.198

Database Queries

总计18条数据
TimeDurationTypeQuery
  
11:29:42.3662.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5252

[+] Explain
11:29:42.3691.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

[+] Explain
11:29:42.3722.0 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 WHERE (client_id is not null) AND ("c"."created_by"='1001') ORDER BY "c"."created_at" DESC) "c"

[+] Explain
11:29:42.3742.2 msSELECTSELECT c.*, client.sales_rep FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id WHERE (client_id is not null) AND ("c"."created_by"='1001') ORDER BY "c"."created_at" DESC LIMIT 20

[+] Explain
11:29:42.3770.3 msSELECTSELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2

[+] Explain
11:29:42.3780.4 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3311, 3304, 3301, 3286, 3296, 2803, 3261, 3260, 3259, 3258, 3257, 3256, 3255)

[+] Explain
11:29:42.3780.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1013)

[+] Explain
11:29:42.3790.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:29:42.3791.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (5903, 5883, 5868, 5867, 5866, 5857, 5820, 5751, 5750, 5749, 5748, 5747, 5746, 5745, 5744, 5743, 5742, 5741, 5740, 5739)

[+] Explain
11:29:42.38019.6 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (5903, 5883, 5868, 5867, 5866, 5857, 5820, 5751, 5750, 5749, 5748, 5747, 5746, 5745, 5744, 5743, 5742, 5741, 5740, 5739)) GROUP BY "object_id"

[+] Explain
11:29:42.4000.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5903, 5883, 5868, 5867, 5866, 5857, 5820, 5751, 5750, 5749, 5748, 5747, 5746, 5745, 5744, 5743, 5742, 5741, 5740, 5739)

[+] Explain
11:29:42.4010.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (333, 348, 185, 192, 309, 184, 189, 191, 183, 194, 187, 5, 1, 2, 226, 160, 140, 349, 354, 369, 372)) ORDER BY "sort"

[+] Explain
11:29:42.4020.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5903, 5883, 5868, 5867, 5866, 5857, 5820, 5751, 5750, 5749, 5748, 5747, 5746, 5745, 5744, 5743, 5742, 5741, 5740, 5739)

[+] Explain
11:29:42.4020.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (333, 348, 185, 192, 309, 184, 189, 191, 183, 194, 187, 5, 1, 2, 226, 160, 140, 349, 354, 369, 372)) ORDER BY "sort"

[+] Explain
11:29:42.40316.9 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=14) AND (remind_user_id = 5252 AND is_read = false) AND ("object_id" IN (5903, 5883, 5868, 5867, 5866, 5857, 5820, 5751, 5750, 5749, 5748, 5747, 5746, 5745, 5744, 5743, 5742, 5741, 5740, 5739)) GROUP BY "object_id"

[+] Explain
11:29:42.4233.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5252) AND ("object_type"=23) AND ("visit_date"='2025-08-04')

[+] Explain
11:29:42.4270.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=176, "last_visit_at"='now()' WHERE "id"=54901

[+] Explain
11:29:42.4281.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5252, 5, 'vue/analysis/engineer-contact-list', '{"to":"","from":"","period":"all","dataUserId":"1001","page":"1","web_access_token":"Q2GVCf176c7Vlog0hO6aJo3ZEkjcIMKK"}', '{"code":2000,"result":{"list":[{"id":5903,"name":"\u547c\u7389\u946b","email":"","pinyin_shortcut":"hyx","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3311,"supplier_id":"","created_by":1001,"created_at":"2024-10-16 11:09:32","updated_at":"2024-10-16 11:09:32","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"hu","pinyin2":"yu","pinyin3":"xin","pinyin4":"","namecut1":"\u547c","namecut2":"\u7389","namecut3":"\u946b","namecut4":"","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3311,"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6694,"contact_id":5903,"mobile":"18803097927","mp_open_id":"","mobile_display":"18803097927"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u547c\u7389\u946b","email_display":"","telephone_display":""},{"id":5883,"name":"\u5b59\u7ecf\u7406","email":"","pinyin_shortcut":"sjl","sex":"F","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d\u7ecf\u7406","mobile":"","telephone":"","client_id":3304,"supplier_id":"","created_by":1001,"created_at":"2024-09-19 15:34:42","updated_at":"2024-09-19 15:34:42","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"sun","pinyin2":"jing","pinyin3":"li","pinyin4":"","namecut1":"\u5b59","namecut2":"\u7ecf","namecut3":"\u7406","namecut4":"","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6674,"contact_id":5883,"mobile":"17611733637","mp_open_id":"","mobile_display":"17611733637"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5b59\u7ecf\u7406","email_display":"","telephone_display":""},{"id":5868,"name":"\u5218\u5b87\u9e4f","email":"","pinyin_shortcut":"lyp","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3301,"supplier_id":"","created_by":1001,"created_at":"2024-09-06 17:13:02","updated_at":"2024-09-06 17:13:02","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"yu","pinyin3":"peng","pinyin4":"","namecut1":"\u5218","namecut2":"\u5b87","namecut3":"\u9e4f","namecut4":"","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6659,"contact_id":5868,"mobile":"13810877418","mp_open_id":"","mobile_display":"13810877418"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5218\u5b87\u9e4f","email_display":"","telephone_display":""},{"id":5867,"name":"\u6768\u5f6c","email":"","pinyin_shortcut":"yb","sex":"M","birth_date":"","department":"","job_position":"\u53d1\u7968\u8054\u7cfb\u4eba","mobile":"","telephone":"","client_id":3301,"supplier_id":"","created_by":1001,"created_at":"2024-09-06 17:10:37","updated_at":"2024-09-06 17:10:37","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yang","pinyin2":"bin","pinyin3":"","pinyin4":"","namecut1":"\u6768","namecut2":"\u5f6c","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6658,"contact_id":5867,"mobile":"15001283101","mp_open_id":"","mobile_display":"15001283101"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u6768\u5f6c","email_display":"","telephone_display":""},{"id":5866,"name":"\u9648\u5a1f","email":"chen.juan@cn.lantro.com","pinyin_shortcut":"cj","sex":"F","birth_date":"","department":"Business Development Dept.","job_position":"Account Manager","mobile":"","telephone":"84493275","client_id":3286,"supplier_id":"","created_by":1001,"created_at":"2024-09-06 14:52:12","updated_at":"2024-09-06 14:52:12","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"chen","pinyin2":"juan","pinyin3":"","pinyin4":"","namecut1":"\u9648","namecut2":"\u5a1f","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6657,"contact_id":5866,"mobile":"13811587080","mp_open_id":"","mobile_display":"13811587080"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u9648\u5a1f","email_display":"chen.juan@cn.lantro.com","telephone_display":"010-84493275"},{"id":5857,"name":"\u6587\u9759","email":"","pinyin_shortcut":"wj","sex":"F","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobile":"","telephone":"64848899","client_id":3296,"supplier_id":"","created_by":1001,"created_at":"2024-08-22 15:33:07","updated_at":"2024-08-22 15:33:07","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"wen","pinyin2":"jing","pinyin3":"","pinyin4":"","namecut1":"\u6587","namecut2":"\u9759","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3296,"key":3296,"name":"\u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":{},"name_display":"\u6587\u9759","email_display":"","telephone_display":"010-64848899"},{"id":5820,"name":"\u8d75\u91d1\u4eae","email":"lz.jin@cn.lantro.com","pinyin_shortcut":"zjl","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobile":"","telephone":"61421866","client_id":3286,"supplier_id":"","created_by":1001,"created_at":"2024-07-03 14:38:20","updated_at":"2024-07-03 14:38:20","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"021","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhao","pinyin2":"jin","pinyin3":"liang","pinyin4":"","namecut1":"\u8d75","namecut2":"\u91d1","namecut3":"\u4eae","namecut4":"","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6613,"contact_id":5820,"mobile":"18888841875","mp_open_id":"","mobile_display":"18888841875"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":{},"name_display":"\u8d75\u91d1\u4eae","email_display":"lz.jin@cn.lantro.com","telephone_display":"021-61421866"},{"id":5751,"name":"\u5728\u7ebf\u4f53\u9a8c-baidu","email":"","pinyin_shortcut":"zxtybaidu","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2803,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:26:39","updated_at":"2024-05-10 18:26:39","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zai","pinyin2":"xian","pinyin3":"ti","pinyin4":"yan","namecut1":"\u5728","namecut2":"\u7ebf","namecut3":"\u4f53","namecut4":"\u9a8c","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6531,"contact_id":5751,"mobile":"13800000009","mp_open_id":"","mobile_display":"13800000009"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5728\u7ebf\u4f53\u9a8c-baidu","email_display":"","telephone_display":""},{"id":5750,"name":"\u901f\u77f3\u63d0\u4f9b\u7ebf\u7d22-\u5c55\u4f1a","email":"","pinyin_shortcut":"sstgxszh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2803,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:26:13","updated_at":"2024-05-10 18:26:13","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"su","pinyin2":"shi","pinyin3":"ti","pinyin4":"gong","namecut1":"\u901f","namecut2":"\u77f3","namecut3":"\u63d0","namecut4":"\u4f9b","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6530,"contact_id":5750,"mobile":"13800000008","mp_open_id":"","mobile_display":"13800000008"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u901f\u77f3\u63d0\u4f9b\u7ebf\u7d22-\u5c55\u4f1a","email_display":"","telephone_display":""},{"id":5749,"name":"\u5b98\u7f51-\u751f\u4fe1\u65b9\u6848-\u66f4\u591a\u5e94\u7528","email":"","pinyin_shortcut":"gwsxfagdyy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2803,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:25:14","updated_at":"2024-05-10 18:25:14","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"guan","pinyin2":"wang","pinyin3":"sheng","pinyin4":"xin","namecut1":"\u5b98","namecut2":"\u7f51","namecut3":"-","namecut4":"\u751f","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6529,"contact_id":5749,"mobile":"13800000007","mp_open_id":"","mobile_display":"13800000007"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5b98\u7f51-\u751f\u4fe1\u65b9\u6848-\u66f4\u591a\u5e94\u7528","email_display":"","telephone_display":""},{"id":5748,"name":"\u7b2c\u516b\u754cBig\u533b\u836f\u5e74\u4f1a","email":"","pinyin_shortcut":"dbjBigyynh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2803,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:24:34","updated_at":"2024-05-10 18:24:34","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"di","pinyin2":"ba","pinyin3":"jie","pinyin4":"big","namecut1":"\u7b2c","namecut2":"\u516b","namecut3":"\u754c","namecut4":"b","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6528,"contact_id":5748,"mobile":"13800000006","mp_open_id":"","mobile_display":"13800000006"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u7b2c\u516b\u754cBig\u533b\u836f\u5e74\u4f1a","email_display":"","telephone_display":""},{"id":5747,"name":"ICDIA","email":"","pinyin_shortcut":"ICDIA","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2803,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:23:37","updated_at":"2024-05-10 18:23:37","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"icdia","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"i","namecut2":"c","namecut3":"d","namecut4":"i","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6527,"contact_id":5747,"mobile":"13800000005","mp_open_id":"","mobile_display":"13800000005"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"ICDIA","email_display":"","telephone_display":""},{"id":5746,"name":"ic-case-\u6848\u4f8b","email":"","pinyin_shortcut":"iccaseal","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2803,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:22:45","updated_at":"2024-05-10 18:22:45","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"iccase","pinyin2":"an","pinyin3":"li","pinyin4":"","namecut1":"i","namecut2":"c","namecut3":"-","namecut4":"c","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6526,"contact_id":5746,"mobile":"13800000004","mp_open_id":"","mobile_display":"13800000004"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"ic-case-\u6848\u4f8b","email_display":"","telephone_display":""},{"id":5745,"name":"\u8096\u592a\u660e","email":"","pinyin_shortcut":"xtm","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3261,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:02:16","updated_at":"2024-05-10 18:02:16","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"xiao","pinyin2":"tai","pinyin3":"ming","pinyin4":"","namecut1":"\u8096","namecut2":"\u592a","namecut3":"\u660e","namecut4":"","is_mp_bind":false,"sales_rep":1013,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3261,"key":3261,"name":"\u4e0a\u6d77\u4e0a\u6c7d\u6052\u65ed\u6295\u8d44\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1013,"salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6525,"contact_id":5745,"mobile":"18688974897","mp_open_id":"","mobile_display":"18688974897"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u8096\u592a\u660e","email_display":"","telephone_display":""},{"id":5744,"name":"\u9a6c\u9e4f\u98de","email":"","pinyin_shortcut":"mpf","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3260,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:02:16","updated_at":"2024-05-10 18:02:16","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ma","pinyin2":"peng","pinyin3":"fei","pinyin4":"","namecut1":"\u9a6c","namecut2":"\u9e4f","namecut3":"\u98de","namecut4":"","is_mp_bind":false,"sales_rep":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3260,"key":3260,"name":"\u5317\u4eac\u6770\u53d1\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","sales_rep":"","salesRep":{}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6524,"contact_id":5744,"mobile":"18810460153","mp_open_id":"","mobile_display":"18810460153"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u9a6c\u9e4f\u98de","email_display":"","telephone_display":""},{"id":5743,"name":"\u9a6c\u5c0f\u5e74","email":"","pinyin_shortcut":"mxn","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3259,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:02:15","updated_at":"2024-05-10 18:02:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ma","pinyin2":"xiao","pinyin3":"nian","pinyin4":"","namecut1":"\u9a6c","namecut2":"\u5c0f","namecut3":"\u5e74","namecut4":"","is_mp_bind":false,"sales_rep":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3259,"key":3259,"name":"\u5317\u4eac\u5bf0\u5b87\u661f\u6cb3\u673a\u5668\u4eba\u79d1\u6280\u6709\u9650\u516c\u53f8(CAE)\u91cd\u590d","sales_rep":"","salesRep":{}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6523,"contact_id":5743,"mobile":"18800123531","mp_open_id":"","mobile_display":"18800123531"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u9a6c\u5c0f\u5e74","email_display":"","telephone_display":""},{"id":5742,"name":"\u5b63\u4fca\u8f89","email":"","pinyin_shortcut":"jjh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3258,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:02:15","updated_at":"2024-05-10 18:02:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ji","pinyin2":"jun","pinyin3":"hui","pinyin4":"","namecut1":"\u5b63","namecut2":"\u4fca","namecut3":"\u8f89","namecut4":"","is_mp_bind":false,"sales_rep":1013,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3258,"key":3258,"name":"\u82af\u6d77\u79d1\u6280\uff08\u6df1\u5733\uff09\u80a1\u4efd\u6709\u9650\u516c\u53f8(EDA)","sales_rep":1013,"salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6522,"contact_id":5742,"mobile":"13810461137","mp_open_id":"","mobile_display":"13810461137"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5b63\u4fca\u8f89","email_display":"","telephone_display":""},{"id":5741,"name":"\u9648\u6d77\u519b","email":"","pinyin_shortcut":"chj","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3257,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:02:15","updated_at":"2024-05-10 18:02:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"chen","pinyin2":"hai","pinyin3":"jun","pinyin4":"","namecut1":"\u9648","namecut2":"\u6d77","namecut3":"\u519b","namecut4":"","is_mp_bind":false,"sales_rep":1013,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3257,"key":3257,"name":"\u5947\u6377\u79d1\u6280\uff08\u6df1\u5733\uff09\u6709\u9650\u516c\u53f8\uff08EDA)","sales_rep":1013,"salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6521,"contact_id":5741,"mobile":"13910592304","mp_open_id":"","mobile_display":"13910592304"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u9648\u6d77\u519b","email_display":"","telephone_display":""},{"id":5740,"name":"\u5b8b\u4e9a\u6e05","email":"","pinyin_shortcut":"syq","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3256,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:02:15","updated_at":"2024-05-10 18:02:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"song","pinyin2":"ya","pinyin3":"qing","pinyin4":"","namecut1":"\u5b8b","namecut2":"\u4e9a","namecut3":"\u6e05","namecut4":"","is_mp_bind":false,"sales_rep":1013,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3256,"key":3256,"name":"\u4e2d\u56fd\u6c7d\u8f66\u5de5\u7a0b\u5b66\u4f1a","sales_rep":1013,"salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6520,"contact_id":5740,"mobile":"18611465919","mp_open_id":"","mobile_display":"18611465919"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5b8b\u4e9a\u6e05","email_display":"","telephone_display":""},{"id":5739,"name":"\u8fdf\u9896","email":"","pinyin_shortcut":"cy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3255,"supplier_id":"","created_by":1001,"created_at":"2024-05-10 18:02:15","updated_at":"2024-05-10 18:02:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"chi","pinyin2":"ying","pinyin3":"","pinyin4":"","namecut1":"\u8fdf","namecut2":"\u9896","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3255,"key":3255,"name":"\u89d2\u4e95(\u5317\u4eac)\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8\uff08EDA\/CAE)","sales_rep":"","salesRep":{}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6519,"contact_id":5739,"mobile":"18612161392","mp_open_id":"","mobile_display":"18612161392"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u8fdf\u9896","email_display":"","telephone_display":""}],"pagenation":{"totalcount":347,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-04 11:29:42') RETURNING "id"

[+] Explain