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

Database Queries

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

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

[+] Explain
13:22:33.7413.1 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 ORDER BY "c"."created_at" DESC) "c"

[+] Explain
13:22:33.7443.7 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 ORDER BY "c"."created_at" DESC LIMIT 20

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

[+] Explain
13:22:33.7490.5 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3424, 189, 3286, 402, 3423, 3422, 3421, 1126, 3420, 3419, 3418, 3417, 3408, 3416, 1111, 3415, 3414, 3413, 3412, 3411)

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

[+] Explain
13:22:33.7500.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5064, 5295, 5360, 5300, 1011, 5087)

[+] Explain
13:22:33.7500.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (6192, 6191, 6190, 6188, 6187, 6186, 6185, 6184, 6183, 6182, 6181, 6179, 6178, 6177, 6176, 6173, 6172, 6171, 6170, 6169)

[+] Explain
13:22:33.75125.0 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (6192, 6191, 6190, 6188, 6187, 6186, 6185, 6184, 6183, 6182, 6181, 6179, 6178, 6177, 6176, 6173, 6172, 6171, 6170, 6169)) GROUP BY "object_id"

[+] Explain
13:22:33.7771.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6192, 6191, 6190, 6188, 6187, 6186, 6185, 6184, 6183, 6182, 6181, 6179, 6178, 6177, 6176, 6173, 6172, 6171, 6170, 6169)

[+] Explain
13:22:33.7780.8 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (184, 307, 198, 185, 1, 5, 226, 2, 349, 352, 324, 374, 369, 356, 366, 135, 139)) ORDER BY "sort"

[+] Explain
13:22:33.7800.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6192, 6191, 6190, 6188, 6187, 6186, 6185, 6184, 6183, 6182, 6181, 6179, 6178, 6177, 6176, 6173, 6172, 6171, 6170, 6169)

[+] Explain
13:22:33.7800.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (184, 307, 198, 185, 1, 5, 226, 2, 349, 352, 324, 374, 369, 356, 366, 135, 139)) ORDER BY "sort"

[+] Explain
13:22:33.78120.6 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 (6192, 6191, 6190, 6188, 6187, 6186, 6185, 6184, 6183, 6182, 6181, 6179, 6178, 6177, 6176, 6173, 6172, 6171, 6170, 6169)) GROUP BY "object_id"

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

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

[+] Explain
13:22:33.8213.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', '{"page":"1"}', '{"code":2000,"result":{"list":[{"id":6192,"name":"\u59da","email":"","pinyin_shortcut":"y","sex":"M","birth_date":"","department":"","job_position":"","mobile":"13244444455","telephone":"","client_id":3424,"supplier_id":"","created_by":5064,"created_at":"2025-12-03 10:07:16","updated_at":"2025-12-03 10:07:16","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yao","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"\u59da","namecut2":"","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1001,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3424,"key":3424,"name":"\u4e2d\u56fd","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","user_status":"1"},"mobiles":[{"id":6974,"contact_id":6192,"mobile":"13244444455","mp_open_id":"","mobile_display":"13244444455"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u59da","email_display":"","telephone_display":""},{"id":6191,"name":"\u6e29\u7389\u9633","email":"","pinyin_shortcut":"wyy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":189,"supplier_id":"","created_by":5295,"created_at":"2025-11-13 14:37:29","updated_at":"2025-11-13 14:37:29","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wen","pinyin2":"yu","pinyin3":"yang","pinyin4":"","namecut1":"\u6e29","namecut2":"\u7389","namecut3":"\u9633","namecut4":"","is_mp_bind":false,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","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":6973,"contact_id":6191,"mobile":"15133338779","mp_open_id":"","mobile_display":"15133338779"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u6e29\u7389\u9633","email_display":"","telephone_display":""},{"id":6190,"name":"\u674e\u777f\uff08PA\u5382\u5546\uff09","email":"","pinyin_shortcut":"lrPAcs","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3286,"supplier_id":"","created_by":5360,"created_at":"2025-11-13 14:34:51","updated_at":"2025-11-13 14:35:03","user_status":2,"description":"PA\u9500\u552e","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"rui","pinyin3":"pa","pinyin4":"chang","namecut1":"\u674e","namecut2":"\u777f","namecut3":"\uff08","namecut4":"p","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":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6972,"contact_id":6190,"mobile":"13910153435","mp_open_id":"","mobile_display":"13910153435"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u674e\u777f\uff08PA\u5382\u5546\uff09","email_display":"","telephone_display":""},{"id":6188,"name":"\u5f20\u5fd7\u6797","email":"","pinyin_shortcut":"zzl","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":402,"supplier_id":"","created_by":5300,"created_at":"2025-11-10 15:08:14","updated_at":"2025-11-10 15:08:14","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"zhi","pinyin3":"lin","pinyin4":"","namecut1":"\u5f20","namecut2":"\u5fd7","namecut3":"\u6797","namecut4":"","is_mp_bind":false,"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":6970,"contact_id":6188,"mobile":"13601314417","mp_open_id":"","mobile_display":"13601314417"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5f20\u5fd7\u6797","email_display":"","telephone_display":""},{"id":6187,"name":"\u97e9\u6674","email":"","pinyin_shortcut":"hq","sex":"F","birth_date":"","department":"","job_position":"","mobile":"13683118852","telephone":"","client_id":3423,"supplier_id":"","created_by":1011,"created_at":"2025-11-10 10:04:06","updated_at":"2025-11-10 10:04:06","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"han","pinyin2":"qing","pinyin3":"","pinyin4":"","namecut1":"\u97e9","namecut2":"\u6674","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3423,"key":3423,"name":"\u5317\u4eac\u661f\u5149\u88d5\u534e\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6969,"contact_id":6187,"mobile":"13683118852","mp_open_id":"","mobile_display":"13683118852"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u97e9\u6674","email_display":"","telephone_display":""},{"id":6186,"name":"\u5316\u5149","email":"","pinyin_shortcut":"hg","sex":"M","birth_date":"","department":"","job_position":"","mobile":"13671227373","telephone":"","client_id":3422,"supplier_id":"","created_by":1011,"created_at":"2025-11-10 09:49:23","updated_at":"2025-11-10 09:49:23","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"hua","pinyin2":"guang","pinyin3":"","pinyin4":"","namecut1":"\u5316","namecut2":"\u5149","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3422,"key":3422,"name":"\u5317\u4eac\u5929\u822a\u4fe1\u6c11\u822a\u901a\u4fe1\u7f51\u7edc\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6968,"contact_id":6186,"mobile":"13671227373","mp_open_id":"","mobile_display":"13671227373"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5316\u5149","email_display":"","telephone_display":""},{"id":6185,"name":"\u95eb\u7ee7\u519b","email":"","pinyin_shortcut":"yjj","sex":"M","birth_date":"","department":"","job_position":"","mobile":"13701109825","telephone":"","client_id":3421,"supplier_id":"","created_by":1011,"created_at":"2025-11-10 09:48:27","updated_at":"2025-11-10 09:48:27","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yan","pinyin2":"ji","pinyin3":"jun","pinyin4":"","namecut1":"\u95eb","namecut2":"\u7ee7","namecut3":"\u519b","namecut4":"","is_mp_bind":false,"sales_rep":1004,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3421,"key":3421,"name":"\u5317\u4eac\u5e02\u5e94\u6025\u7ba1\u7406\u5c40\u5e94\u6025\u7ba1\u7406\u90e8","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6967,"contact_id":6185,"mobile":"13701109825","mp_open_id":"","mobile_display":"13701109825"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u95eb\u7ee7\u519b","email_display":"","telephone_display":""},{"id":6184,"name":"\u674e\u5c0f\u52c7","email":"","pinyin_shortcut":"lxy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":1126,"supplier_id":"","created_by":5300,"created_at":"2025-11-07 14:52:46","updated_at":"2025-11-07 14:52:46","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"xiao","pinyin3":"yong","pinyin4":"","namecut1":"\u674e","namecut2":"\u5c0f","namecut3":"\u52c7","namecut4":"","is_mp_bind":false,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":1126,"key":1126,"name":"\u4e2d\u56fd\u5927\u5510\u96c6\u56e2\u8d44\u672c\u63a7\u80a1\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":6966,"contact_id":6184,"mobile":"13575476468","mp_open_id":"","mobile_display":"13575476468"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u674e\u5c0f\u52c7","email_display":"","telephone_display":""},{"id":6183,"name":"\u5f20\u5148\u751f","email":"","pinyin_shortcut":"zxs","sex":"M","birth_date":"","department":"","job_position":"","mobile":"18600423946","telephone":"","client_id":3420,"supplier_id":"","created_by":1011,"created_at":"2025-11-07 14:52:29","updated_at":"2025-11-07 14:52:29","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"xian","pinyin3":"sheng","pinyin4":"","namecut1":"\u5f20","namecut2":"\u5148","namecut3":"\u751f","namecut4":"","is_mp_bind":false,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3420,"key":3420,"name":"\u4e2d\u822a\u54a8\u8be2\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6965,"contact_id":6183,"mobile":"18600423946","mp_open_id":"","mobile_display":"18600423946"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5f20\u5148\u751f","email_display":"","telephone_display":""},{"id":6182,"name":"\u53f2\u6590\u534e","email":"","pinyin_shortcut":"sfh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"18734837796","telephone":"","client_id":3419,"supplier_id":"","created_by":1011,"created_at":"2025-11-07 14:52:26","updated_at":"2025-11-07 14:52:26","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"shi","pinyin2":"fei","pinyin3":"hua","pinyin4":"","namecut1":"\u53f2","namecut2":"\u6590","namecut3":"\u534e","namecut4":"","is_mp_bind":false,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3419,"key":3419,"name":"\u5317\u4eac\u7b51\u9f99\u4f1f\u4e1a\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6964,"contact_id":6182,"mobile":"18734837796","mp_open_id":"","mobile_display":"18734837796"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u53f2\u6590\u534e","email_display":"","telephone_display":""},{"id":6181,"name":"\u77f3\u5148\u751f","email":"","pinyin_shortcut":"sxs","sex":"M","birth_date":"","department":"","job_position":"","mobile":"13011113301","telephone":"","client_id":3418,"supplier_id":"","created_by":1011,"created_at":"2025-11-06 17:30:12","updated_at":"2025-11-06 17:30:12","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"shi","pinyin2":"xian","pinyin3":"sheng","pinyin4":"","namecut1":"\u77f3","namecut2":"\u5148","namecut3":"\u751f","namecut4":"","is_mp_bind":false,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3418,"key":3418,"name":"\u4e2d\u56fd\u5bb6\u7528\u7535\u5668\u7814\u7a76\u9662","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6963,"contact_id":6181,"mobile":"13011113301","mp_open_id":"","mobile_display":"13011113301"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u77f3\u5148\u751f","email_display":"","telephone_display":""},{"id":6179,"name":"\u5f20\u6d0b","email":"","pinyin_shortcut":"zy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3417,"supplier_id":"","created_by":5087,"created_at":"2025-10-31 16:23:01","updated_at":"2025-10-31 16:23:01","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"yang","pinyin3":"","pinyin4":"","namecut1":"\u5f20","namecut2":"\u6d0b","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":5087,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3417,"key":3417,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\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":6961,"contact_id":6179,"mobile":"13021111199","mp_open_id":"","mobile_display":"13021111199"}],"commentCount":{},"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"},"unreadComments":{},"name_display":"\u5f20\u6d0b","email_display":"","telephone_display":""},{"id":6178,"name":"\u5434\u65b9\u4eae","email":"","pinyin_shortcut":"wfl","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"63611888","client_id":3408,"supplier_id":"","created_by":5300,"created_at":"2025-10-31 10:56:32","updated_at":"2025-10-31 10:56:32","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"wu","pinyin2":"fang","pinyin3":"liang","pinyin4":"","namecut1":"\u5434","namecut2":"\u65b9","namecut3":"\u4eae","namecut4":"","is_mp_bind":false,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3408,"key":3408,"name":"\u90a2\u53f0\u65b0\u80fd\u6e90\u804c\u4e1a\u5b66\u9662(\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\uff09","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":6960,"contact_id":6178,"mobile":"13718682713","mp_open_id":"","mobile_display":"13718682713"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5434\u65b9\u4eae","email_display":"","telephone_display":"010-63611888"},{"id":6177,"name":"\u8d75\u94ce","email":"","pinyin_shortcut":"zd","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3416,"supplier_id":"","created_by":5300,"created_at":"2025-10-30 16:56:33","updated_at":"2025-10-30 16:56:33","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhao","pinyin2":"duo","pinyin3":"","pinyin4":"","namecut1":"\u8d75","namecut2":"\u94ce","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3416,"key":3416,"name":"\u4e2d\u7535\u79d1\u53d1\u5c55\u89c4\u5212\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u56fd\u7535\u5b50\u79d1\u6280\u96c6\u56e2\u6709\u9650\u516c\u53f8\u7535\u5b50\u79d1\u5b66\u7814\u7a76\u9662","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":6959,"contact_id":6177,"mobile":"18600663740","mp_open_id":"","mobile_display":"18600663740"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u8d75\u94ce","email_display":"","telephone_display":""},{"id":6176,"name":"\u8c22\u51ef","email":"","pinyin_shortcut":"xk","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":1111,"supplier_id":"","created_by":5295,"created_at":"2025-10-29 20:51:50","updated_at":"2025-10-29 20:51:50","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"xie","pinyin2":"kai","pinyin3":"","pinyin4":"","namecut1":"\u8c22","namecut2":"\u51ef","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":1111,"key":1111,"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40","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":6958,"contact_id":6176,"mobile":"13146429527","mp_open_id":"","mobile_display":"13146429527"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u8c22\u51ef","email_display":"","telephone_display":""},{"id":6173,"name":"\u620e\u6cfd\u9e9f","email":"","pinyin_shortcut":"rzl","sex":"M","birth_date":"","department":"","job_position":"","mobile":"15801193167","telephone":"","client_id":3415,"supplier_id":"","created_by":1011,"created_at":"2025-10-28 10:42:40","updated_at":"2025-10-28 10:42:40","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"rong","pinyin2":"ze","pinyin3":"lin","pinyin4":"","namecut1":"\u620e","namecut2":"\u6cfd","namecut3":"\u9e9f","namecut4":"","is_mp_bind":false,"sales_rep":1005,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3415,"key":3415,"name":"\u5317\u4eac\u4e2d\u91d1\u4fdd\u9669\u7ecf\u7eaa\u6709\u9650\u516c\u53f8","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6955,"contact_id":6173,"mobile":"15801193167","mp_open_id":"","mobile_display":"15801193167"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u620e\u6cfd\u9e9f","email_display":"","telephone_display":""},{"id":6172,"name":"\u5218\u6c5f","email":"","pinyin_shortcut":"lj","sex":"M","birth_date":"","department":"","job_position":"","mobile":"13653512645","telephone":"","client_id":3414,"supplier_id":"","created_by":1011,"created_at":"2025-10-28 10:41:29","updated_at":"2025-10-28 10:41:29","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"jiang","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u6c5f","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3414,"key":3414,"name":"\u5317\u4eac\u8fea\u5b89\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6954,"contact_id":6172,"mobile":"13653512645","mp_open_id":"","mobile_display":"13653512645"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u5218\u6c5f","email_display":"","telephone_display":""},{"id":6171,"name":"\u6768\u5065","email":"","pinyin_shortcut":"yj","sex":"M","birth_date":"","department":"","job_position":"","mobile":"15810373839","telephone":"","client_id":3413,"supplier_id":"","created_by":1011,"created_at":"2025-10-28 10:39:51","updated_at":"2025-10-28 10:39:51","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yang","pinyin2":"jian","pinyin3":"","pinyin4":"","namecut1":"\u6768","namecut2":"\u5065","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":5295,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3413,"key":3413,"name":"\u534e\u8bbe\u8bbe\u8ba1\u96c6\u56e2\u5317\u4eac\u6c11\u822a\u8bbe\u8ba1\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6953,"contact_id":6171,"mobile":"15810373839","mp_open_id":"","mobile_display":"15810373839"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u6768\u5065","email_display":"","telephone_display":""},{"id":6170,"name":"\u6768\u6e24","email":"","pinyin_shortcut":"yb","sex":"M","birth_date":"","department":"","job_position":"","mobile":"13121381376","telephone":"","client_id":3412,"supplier_id":"","created_by":1011,"created_at":"2025-10-28 10:37:36","updated_at":"2025-10-28 10:37:36","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yang","pinyin2":"bo","pinyin3":"","pinyin4":"","namecut1":"\u6768","namecut2":"\u6e24","namecut3":"","namecut4":"","is_mp_bind":false,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3412,"key":3412,"name":"\u4e2d\u94f6\u96c6\u56e2","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6952,"contact_id":6170,"mobile":"13121381376","mp_open_id":"","mobile_display":"13121381376"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u6768\u6e24","email_display":"","telephone_display":""},{"id":6169,"name":"\u6c6a\u51a0\u6743","email":"","pinyin_shortcut":"wgq","sex":"M","birth_date":"","department":"","job_position":"","mobile":"13521525850","telephone":"","client_id":3411,"supplier_id":"","created_by":1011,"created_at":"2025-10-27 17:01:21","updated_at":"2025-10-27 17:01:21","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"guan","pinyin3":"quan","pinyin4":"","namecut1":"\u6c6a","namecut2":"\u51a0","namecut3":"\u6743","namecut4":"","is_mp_bind":false,"sales_rep":5300,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"client":{"id":3411,"key":3411,"name":"\u5317\u4eac\u57ce\u5efa\u4e9a\u6cf0\u5efa\u8bbe\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6951,"contact_id":6169,"mobile":"13521525850","mp_open_id":"","mobile_display":"13521525850"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":"","unreadComments":{},"name_display":"\u6c6a\u51a0\u6743","email_display":"","telephone_display":""}],"pagenation":{"totalcount":3377,"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:33') RETURNING "id"

[+] Explain