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

Database Queries

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

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

[+] Explain
11:29:39.5572.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"='1005') ORDER BY "c"."created_at" DESC) "c"

[+] Explain
11:29:39.5592.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"='1005') ORDER BY "c"."created_at" DESC LIMIT 20

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

[+] Explain
11:29:39.5620.4 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3387, 3384, 3376, 3354, 3336, 1457, 3333, 93, 3330, 3316, 149, 2594, 3290, 3285, 57)

[+] Explain
11:29:39.5630.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5311, 5300)

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

[+] Explain
11:29:39.5631.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (6117, 6115, 6086, 6035, 6008, 6001, 6000, 5983, 5971, 5921, 5914, 5906, 5905, 5876, 5847, 5843, 5830, 5808, 5801, 5798)

[+] Explain
11:29:39.56519.5 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (6117, 6115, 6086, 6035, 6008, 6001, 6000, 5983, 5971, 5921, 5914, 5906, 5905, 5876, 5847, 5843, 5830, 5808, 5801, 5798)) GROUP BY "object_id"

[+] Explain
11:29:39.5850.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6117, 6115, 6086, 6035, 6008, 6001, 6000, 5983, 5971, 5921, 5914, 5906, 5905, 5876, 5847, 5843, 5830, 5808, 5801, 5798)

[+] Explain
11:29:39.5860.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (135, 140, 160, 139, 184, 189, 183, 194, 188, 197, 199, 187, 185, 191, 1, 215, 5, 226, 2, 229, 323, 349, 354, 369, 372, 377)) ORDER BY "sort"

[+] Explain
11:29:39.5870.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6117, 6115, 6086, 6035, 6008, 6001, 6000, 5983, 5971, 5921, 5914, 5906, 5905, 5876, 5847, 5843, 5830, 5808, 5801, 5798)

[+] Explain
11:29:39.5870.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (135, 140, 160, 139, 184, 189, 183, 194, 188, 197, 199, 187, 185, 191, 1, 215, 5, 226, 2, 229, 323, 349, 354, 369, 372, 377)) ORDER BY "sort"

[+] Explain
11:29:39.58816.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 (6117, 6115, 6086, 6035, 6008, 6001, 6000, 5983, 5971, 5921, 5914, 5906, 5905, 5876, 5847, 5843, 5830, 5808, 5801, 5798)) GROUP BY "object_id"

[+] Explain
11:29:39.6073.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:39.6111.1 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=175, "last_visit_at"='now()' WHERE "id"=54901

[+] Explain
11:29:39.6131.8 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":"1005","page":"1","web_access_token":"Q2GVCf176c7Vlog0hO6aJo3ZEkjcIMKK"}', '{"code":2000,"result":{"list":[{"id":6117,"name":"\u82cf\u632f\u6d9b","email":"suzt@bjjazx.com","pinyin_shortcut":"szt","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3387,"supplier_id":"","created_by":1005,"created_at":"2025-07-28 17:34:16","updated_at":"2025-07-28 17:34:16","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"su","pinyin2":"zhen","pinyin3":"tao","pinyin4":"","namecut1":"\u82cf","namecut2":"\u632f","namecut3":"\u6d9b","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\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":6898,"contact_id":6117,"mobile":"18611890030","mp_open_id":"","mobile_display":"18611890030"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u82cf\u632f\u6d9b","email_display":"suzt@bjjazx.com","telephone_display":""},{"id":6115,"name":"\u5434\u88f4\u82d7","email":"","pinyin_shortcut":"wpm","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3384,"supplier_id":"","created_by":1005,"created_at":"2025-07-27 23:26:39","updated_at":"2025-07-27 23:26:39","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wu","pinyin2":"pei","pinyin3":"miao","pinyin4":"","namecut1":"\u5434","namecut2":"\u88f4","namecut3":"\u82d7","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3384,"key":3384,"name":"\u5e7f\u5dde\u7eb3\u667a\u901a\u79d1\u6280\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":6896,"contact_id":6115,"mobile":"13711016186","mp_open_id":"","mobile_display":"13711016186"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5434\u88f4\u82d7","email_display":"","telephone_display":""},{"id":6086,"name":"\u738b\u4e3d","email":"","pinyin_shortcut":"wl","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3376,"supplier_id":"","created_by":1005,"created_at":"2025-06-30 12:00:46","updated_at":"2025-06-30 12:00:46","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"li","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u4e3d","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3376,"key":3376,"name":"\u8fb0\u5c79\u5bf0\u5b87\uff08\u4e0a\u6d77\uff09\u4fe1\u606f\u79d1\u6280\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":6869,"contact_id":6086,"mobile":"19109690909","mp_open_id":"","mobile_display":"19109690909"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u738b\u4e3d","email_display":"","telephone_display":""},{"id":6035,"name":"\u82cf\u5f3a","email":"","pinyin_shortcut":"sq","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3354,"supplier_id":"","created_by":1005,"created_at":"2025-04-16 09:25:37","updated_at":"2025-04-16 09:25:37","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"su","pinyin2":"qiang","pinyin3":"","pinyin4":"","namecut1":"\u82cf","namecut2":"\u5f3a","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3354,"key":3354,"name":"\u822a\u5929\u79d1\u6280\u4e00\u966215\u6240","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":6817,"contact_id":6035,"mobile":"13911609683","mp_open_id":"","mobile_display":"13911609683"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u82cf\u5f3a","email_display":"","telephone_display":""},{"id":6008,"name":"\u6c6a\u4e91\u98de","email":"","pinyin_shortcut":"wyf","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3336,"supplier_id":"","created_by":1005,"created_at":"2025-03-18 10:07:39","updated_at":"2025-03-18 10:07:39","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"yun","pinyin3":"fei","pinyin4":"","namecut1":"\u6c6a","namecut2":"\u4e91","namecut3":"\u98de","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3336,"key":3336,"name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09","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":6792,"contact_id":6008,"mobile":"13811970900","mp_open_id":"","mobile_display":"13811970900"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u6c6a\u4e91\u98de","email_display":"","telephone_display":""},{"id":6001,"name":"\u4efb\u5149\u5b87","email":"","pinyin_shortcut":"rgy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":1457,"supplier_id":"","created_by":1005,"created_at":"2025-02-26 10:28:55","updated_at":"2025-02-26 10:28:55","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ren","pinyin2":"guang","pinyin3":"yu","pinyin4":"","namecut1":"\u4efb","namecut2":"\u5149","namecut3":"\u5b87","namecut4":"","is_mp_bind":false,"sales_rep":5311,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":1457,"key":1457,"name":"\u5317\u4eac\u795e\u821f\u822a\u5929\u8f6f\u4ef6\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"}},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":6785,"contact_id":6001,"mobile":"18813065165","mp_open_id":"","mobile_display":"18813065165"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u4efb\u5149\u5b87","email_display":"","telephone_display":""},{"id":6000,"name":"\u5f20\u5609\u5174","email":"zhangjiaxing@aerostrong.com.cn","pinyin_shortcut":"zjx","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"63833663","client_id":3333,"supplier_id":"","created_by":1005,"created_at":"2025-02-26 10:20:57","updated_at":"2025-02-26 10:20:57","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"jia","pinyin3":"xing","pinyin4":"","namecut1":"\u5f20","namecut2":"\u5609","namecut3":"\u5174","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","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":[],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":{},"name_display":"\u5f20\u5609\u5174","email_display":"zhangjiaxing@aerostrong.com.cn","telephone_display":"010-63833663"},{"id":5983,"name":"\u8d75\u79b9\u6850","email":"yutong.zhao@pharmaron.com","pinyin_shortcut":"zyt","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobile":"","telephone":"","client_id":93,"supplier_id":"","created_by":1005,"created_at":"2025-01-15 11:17:59","updated_at":"2025-03-05 13:35:07","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhao","pinyin2":"yu","pinyin3":"tong","pinyin4":"","namecut1":"\u8d75","namecut2":"\u79b9","namecut3":"\u6850","namecut4":"","is_mp_bind":false,"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":6770,"contact_id":5983,"mobile":"19525486256","mp_open_id":"","mobile_display":"19525486256"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u8d75\u79b9\u6850","email_display":"yutong.zhao@pharmaron.com","telephone_display":""},{"id":5971,"name":"\u9ad8\u95f9\u77f3","email":"","pinyin_shortcut":"gns","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3330,"supplier_id":"","created_by":1005,"created_at":"2024-12-25 10:28:12","updated_at":"2024-12-25 10:28:12","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"gao","pinyin2":"nao","pinyin3":"shi","pinyin4":"","namecut1":"\u9ad8","namecut2":"\u95f9","namecut3":"\u77f3","namecut4":"","is_mp_bind":false,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3330,"key":3330,"name":"\u94a2\u7814\u660a\u666e\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":6760,"contact_id":5971,"mobile":"15652778888","mp_open_id":"","mobile_display":"15652778888"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"},"unreadComments":{},"name_display":"\u9ad8\u95f9\u77f3","email_display":"","telephone_display":""},{"id":5921,"name":"\u9646 \u91d1\u6cfd","email":"","pinyin_shortcut":"ljz","sex":"M","birth_date":"","department":"\u4fe1\u606f\u5316","job_position":"\u6280\u672f","mobile":"","telephone":"","client_id":3316,"supplier_id":"","created_by":1005,"created_at":"2024-10-31 19:29:51","updated_at":"2024-10-31 19:29:51","user_status":2,"description":"24 \u5e74 8 \u6708\u5165\u804c","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"lu","pinyin2":"jin","pinyin3":"ze","pinyin4":"","namecut1":"\u9646","namecut2":" ","namecut3":"\u91d1","namecut4":"\u6cfd","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3316,"key":3316,"name":"\u822a\u5929\u79d1\u5de5\u96c6\u56e2\u7b2c\u4e8c\u7814\u7a76\u9662 206 \u6240","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":6710,"contact_id":5921,"mobile":"18210948206","mp_open_id":"","mobile_display":"18210948206"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u9646 \u91d1\u6cfd","email_display":"","telephone_display":""},{"id":5914,"name":"\u674e\u60f3","email":"","pinyin_shortcut":"lx","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobile":"","telephone":"68773201","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2024-10-25 10:07:25","updated_at":"2024-10-25 10:07:25","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"xiang","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u60f3","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09","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":6703,"contact_id":5914,"mobile":"13621371855","mp_open_id":"","mobile_display":"13621371855"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":{},"name_display":"\u674e\u60f3","email_display":"","telephone_display":"010-68773201"},{"id":5906,"name":"\u738b\u6676","email":"","pinyin_shortcut":"wj","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"63596318","client_id":2594,"supplier_id":"","created_by":1005,"created_at":"2024-10-17 11:33:15","updated_at":"2024-10-17 11:33:15","user_status":2,"description":"\u8d1f\u8d23\u57fa\u7840\u8bbe\u65bd","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"jing","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u6676","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2594,"key":2594,"name":"\u4e2d\u77f3\u6cb9\u4e2d\u4e9a\u5929\u7136\u6c14\u7ba1\u9053\u6709\u9650\u516c\u53f8\/\u4e2d\u6cb9\u56fd\u9645\u7ba1\u9053\u516c\u53f8\uff08\u8fc7\u5355\uff09","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":[],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u738b\u6676","email_display":"","telephone_display":"010-63596318"},{"id":5905,"name":"\u5434\u4e1c\u5fd7","email":"","pinyin_shortcut":"wdz","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2594,"supplier_id":"","created_by":1005,"created_at":"2024-10-17 11:32:26","updated_at":"2024-10-17 11:32:26","user_status":2,"description":"\u8d1f\u8d23\u7f51\u7edc\u5b89\u5168","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wu","pinyin2":"dong","pinyin3":"zhi","pinyin4":"","namecut1":"\u5434","namecut2":"\u4e1c","namecut3":"\u5fd7","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":2594,"key":2594,"name":"\u4e2d\u77f3\u6cb9\u4e2d\u4e9a\u5929\u7136\u6c14\u7ba1\u9053\u6709\u9650\u516c\u53f8\/\u4e2d\u6cb9\u56fd\u9645\u7ba1\u9053\u516c\u53f8\uff08\u8fc7\u5355\uff09","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":6696,"contact_id":5905,"mobile":"18610181833","mp_open_id":"","mobile_display":"18610181833"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u5434\u4e1c\u5fd7","email_display":"","telephone_display":""},{"id":5876,"name":"\u51af\u5b66\u9e4f","email":"xuepeng.feng@pharmaron.com","pinyin_shortcut":"fxp","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":93,"supplier_id":"","created_by":1005,"created_at":"2024-09-13 13:27:00","updated_at":"2024-09-13 13:27:00","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"feng","pinyin2":"xue","pinyin3":"peng","pinyin4":"","namecut1":"\u51af","namecut2":"\u5b66","namecut3":"\u9e4f","namecut4":"","is_mp_bind":false,"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":6667,"contact_id":5876,"mobile":"18611394482","mp_open_id":"","mobile_display":"18611394482"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u51af\u5b66\u9e4f","email_display":"xuepeng.feng@pharmaron.com","telephone_display":""},{"id":5847,"name":"\u5f20\u7389\u6885","email":"Yumei.zhang@pharmaron.com","pinyin_shortcut":"zym","sex":"F","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d\u7ecf\u7406","mobile":"","telephone":"","client_id":93,"supplier_id":"","created_by":1005,"created_at":"2024-08-12 11:41:11","updated_at":"2024-08-12 11:41:11","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"yu","pinyin3":"mei","pinyin4":"","namecut1":"\u5f20","namecut2":"\u7389","namecut3":"\u6885","namecut4":"","is_mp_bind":false,"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":6640,"contact_id":5847,"mobile":"13520635417","mp_open_id":"","mobile_display":"13520635417"}],"commentCount":{},"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":{},"name_display":"\u5f20\u7389\u6885","email_display":"Yumei.zhang@pharmaron.com","telephone_display":""},{"id":5843,"name":"\u4f59\u5c0f\u7434","email":"","pinyin_shortcut":"yxq","sex":"F","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3290,"supplier_id":"","created_by":1005,"created_at":"2024-08-08 11:03:09","updated_at":"2024-08-08 11:03:09","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yu","pinyin2":"xiao","pinyin3":"qin","pinyin4":"","namecut1":"\u4f59","namecut2":"\u5c0f","namecut3":"\u7434","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3290,"key":3290,"name":"\u4ebf\u4e00\u751f\u7269","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":6636,"contact_id":5843,"mobile":"18810155645","mp_open_id":"","mobile_display":"18810155645"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u4f59\u5c0f\u7434","email_display":"","telephone_display":""},{"id":5830,"name":"\u738b\u632f\u677e","email":"","pinyin_shortcut":"wzs","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3285,"supplier_id":"","created_by":1005,"created_at":"2024-07-18 12:27:47","updated_at":"2024-07-18 12:27:47","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"zhen","pinyin3":"song","pinyin4":"","namecut1":"\u738b","namecut2":"\u632f","namecut3":"\u677e","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3285,"key":3285,"name":"\u5317\u4eac\u4e2d\u76fe\u5b89\u6c11\u5206\u6790\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","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":6623,"contact_id":5830,"mobile":"18510908707","mp_open_id":"","mobile_display":"18510908707"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u738b\u632f\u677e","email_display":"","telephone_display":""},{"id":5808,"name":"\u5b8b\u6167\u5f3a","email":"","pinyin_shortcut":"shq","sex":"M","birth_date":"","department":"\u751f\u4ea7\u7ef4\u4fee\u90e8","job_position":"","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2024-06-21 16:27:16","updated_at":"2024-06-21 16:27:16","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"song","pinyin2":"hui","pinyin3":"qiang","pinyin4":"","namecut1":"\u5b8b","namecut2":"\u6167","namecut3":"\u5f3a","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09","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":6601,"contact_id":5808,"mobile":"13693364313","mp_open_id":"","mobile_display":"13693364313"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u5b8b\u6167\u5f3a","email_display":"","telephone_display":""},{"id":5801,"name":"\u8303\u52e4\u534e","email":"","pinyin_shortcut":"fqh","sex":"M","birth_date":"","department":"\u4e0a\u6d77\u5e93\u623f","job_position":"\u6536\u4ef6\u4eba","mobile":"","telephone":"31064788","client_id":57,"supplier_id":"","created_by":1005,"created_at":"2024-06-13 10:46:25","updated_at":"2024-06-13 10:46:25","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"021","telephone_extension_number":"","mp_open_id":"","pinyin1":"fan","pinyin2":"qin","pinyin3":"hua","pinyin4":"","namecut1":"\u8303","namecut2":"\u52e4","namecut3":"\u534e","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\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":[],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u8303\u52e4\u534e","email_display":"","telephone_display":"021-31064788"},{"id":5798,"name":"\u8303\u660e\u6d0b","email":"","pinyin_shortcut":"fmy","sex":"M","birth_date":"","department":"\u65e0\u9521\u5e93\u623f","job_position":"","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1005,"created_at":"2024-06-11 17:05:21","updated_at":"2024-06-13 10:46:44","user_status":2,"description":"\u65e0\u9521\u5e93\u623f\u8054\u7cfb\u4eba","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"fan","pinyin2":"ming","pinyin3":"yang","pinyin4":"","namecut1":"\u8303","namecut2":"\u660e","namecut3":"\u6d0b","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\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":6592,"contact_id":5798,"mobile":"18018331307","mp_open_id":"","mobile_display":"18018331307"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":"","unreadComments":{},"name_display":"\u8303\u660e\u6d0b","email_display":"","telephone_display":""}],"pagenation":{"totalcount":287,"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:39') RETURNING "id"

[+] Explain