ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1fead3cb1e4: POST https://beta.jinchangxiao.com/vue/contact/of-client at 2026-06-03 04:50:27 pm by 221.216.117.119

Database Queries

总计17条数据
TimeDurationTypeQuery
  
16:50:28.3572.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:50:28.3610.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:50:28.3641.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='149') AND ("deleted"=FALSE)

[+] Explain
16:50:28.3663.8 msSELECTSELECT COUNT(*) FROM (SELECT c.*, CASE WHEN count(cm.id) != 0 THEN 1 ELSE null END as mp_open_id 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 AND cm.mp_open_id IS NOT NULL WHERE "client"."id"='149' GROUP BY "c"."id" ORDER BY (case c.user_status when 3 then 1 when 1 then 0 else c.user_status end) DESC, c.updated_at DESC) "c"

[+] Explain
16:50:28.3713.0 msSELECTSELECT c.*, CASE WHEN count(cm.id) != 0 THEN 1 ELSE null END as mp_open_id 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 AND cm.mp_open_id IS NOT NULL WHERE "client"."id"='149' GROUP BY "c"."id" ORDER BY (case c.user_status when 3 then 1 when 1 then 0 else c.user_status end) DESC, c.updated_at DESC LIMIT 20

[+] Explain
16:50:28.3756.4 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_contacts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
16:50:28.38217.4 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_contacts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
16:50:28.4000.5 msSELECTSELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2

[+] Explain
16:50:28.4010.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5413, 1022, 5085, 1015, 1016)

[+] Explain
16:50:28.4021.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (1987, 5929, 1314, 5914, 5808, 5153, 4814, 303, 4659, 1270, 4125, 1988, 1156, 1385, 3322, 3130, 3111, 2517, 1155, 783)

[+] Explain
16:50:28.40331.8 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (1987, 5929, 1314, 5914, 5808, 5153, 4814, 303, 4659, 1270, 4125, 1988, 1156, 1385, 3322, 3130, 3111, 2517, 1155, 783)) GROUP BY "object_id"

[+] Explain
16:50:28.4361.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1987, 5929, 1314, 5914, 5808, 5153, 4814, 303, 4659, 1270, 4125, 1988, 1156, 1385, 3322, 3130, 3111, 2517, 1155, 783)

[+] Explain
16:50:28.4370.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (46, 100, 196, 165, 179, 142, 154, 45, 171, 97, 213, 1, 6, 204, 158, 5, 265, 177, 2, 184, 189, 197, 199, 156, 131, 93, 229, 8, 11, 167, 212, 215, 227, 271, 268, 107, 194, 316, 205, 203, 226, 7, 211, 216, 219, 221, 224, 225, 228, 231, 207, 223, 214, 9, 208, 210, 209, 94, 217, 230, 218, 10, 222, 304, 157, 185, 191, 153, 333, 164, 178, 181, 340, 341, 349, 183, 317, 309, 129, 319, 2100000000, 326, 354, 369, 377, 365, 359, 313, 140, 160, 136, 137)) ORDER BY "sort"

[+] Explain
16:50:28.4391.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1987, 5929, 1314, 5914, 5808, 5153, 4814, 303, 4659, 1270, 4125, 1988, 1156, 1385, 3322, 3130, 3111, 2517, 1155, 783)

[+] Explain
16:50:28.4400.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (46, 100, 196, 165, 179, 142, 154, 45, 171, 97, 213, 1, 6, 204, 158, 5, 265, 177, 2, 184, 189, 197, 199, 156, 131, 93, 229, 8, 11, 167, 212, 215, 227, 271, 268, 107, 194, 316, 205, 203, 226, 7, 211, 216, 219, 221, 224, 225, 228, 231, 207, 223, 214, 9, 208, 210, 209, 94, 217, 230, 218, 10, 222, 304, 157, 185, 191, 153, 333, 164, 178, 181, 340, 341, 349, 183, 317, 309, 129, 319, 2100000000, 326, 354, 369, 377, 365, 359, 313, 140, 160, 136, 137)) ORDER BY "sort"

[+] Explain
16:50:28.44121.5 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 (1987, 5929, 1314, 5914, 5808, 5153, 4814, 303, 4659, 1270, 4125, 1988, 1156, 1385, 3322, 3130, 3111, 2517, 1155, 783)) GROUP BY "object_id"

[+] Explain
16:50:28.4691.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/contact/of-client', '{"id":"149","page":"1","web_access_token":"3sqoTbqwkHhRmqiLIelKWucsK6N07HRT"}', '{"code":2000,"result":{"list":[{"id":1987,"name":"\u674e\u6676\u6676","email":"effenljj@126.com","pinyin_shortcut":"ljj","sex":"M","birth_date":"","department":"\u53d1\u8bc1\u90e8","job_position":"\u751f\u4ea7\u5904\u4e3b\u4efb","mobile":"","telephone":"61721950","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2018-05-24 08:54:56","updated_at":"2025-06-27 11:43:02","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"2214","mp_open_id":"","pinyin1":"li","pinyin2":"jing","pinyin3":"jing","pinyin4":"","namecut1":"\u674e","namecut2":"\u6676","namecut3":"\u6676","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":6867,"contact_id":1987,"mobile":"13910119068","mp_open_id":"","mobile_display":"13910119068"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u674e\u6676\u6676","email_display":"effenljj@126.com","telephone_display":"010-61721950-2214","unread":0},{"id":5929,"name":"\u738b\u5b87","email":"","pinyin_shortcut":"wy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":5413,"created_at":"2024-11-11 13:51:05","updated_at":"2024-11-11 13:51:05","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"yu","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u5b87","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5413,"key":5413,"name":"\u8096\u6167\u4e3d(\u5df2\u79bb\u804c)","sex":"F","user_status":"-1"},"mobiles":[{"id":6717,"contact_id":5929,"mobile":"13552005986","mp_open_id":"","mobile_display":"13552005986"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u738b\u5b87","email_display":"","telephone_display":"","unread":0},{"id":1314,"name":"\u8d3a\u840c\u840c","email":"","pinyin_shortcut":"hmm","sex":"F","birth_date":"","department":"","job_position":"\u91c7\u8d2d","mobile":"","telephone":"88513549","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2017-11-22 20:16:56","updated_at":"2024-11-06 10:27:25","user_status":2,"description":"\u5927\u5174\u533a\u65e7\u5fe0\u8def\u897f\u56db\u67612\u53f73\u697c\uff0c\u738b\u5148\u751f\uff0c15811045369","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"he","pinyin2":"meng","pinyin3":"meng","pinyin4":"","namecut1":"\u8d3a","namecut2":"\u840c","namecut3":"\u840c","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":4951,"contact_id":1314,"mobile":"13810730256","mp_open_id":"","mobile_display":"13810730256"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u8d3a\u840c\u840c","email_display":"","telephone_display":"010-88513549","unread":0},{"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,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","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":"","can_update":true,"can_delete":true,"name_display":"\u674e\u60f3","email_display":"","telephone_display":"010-68773201","unread":0},{"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,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","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":"","can_update":true,"can_delete":true,"name_display":"\u5b8b\u6167\u5f3a","email_display":"","telephone_display":"","unread":0},{"id":5153,"name":"\u6c99\u6b27","email":"","pinyin_shortcut":"so","sex":"F","birth_date":"","department":"","job_position":"\u91c7\u8d2d","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2024-01-09 18:08:58","updated_at":"2024-01-09 18:08:58","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"sha","pinyin2":"ou","pinyin3":"","pinyin4":"","namecut1":"\u6c99","namecut2":"\u6b27","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":5940,"contact_id":5153,"mobile":"13611399447","mp_open_id":"","mobile_display":"13611399447"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u6c99\u6b27","email_display":"","telephone_display":"","unread":0},{"id":4814,"name":"\u83ab\u5149\u8f89","email":"","pinyin_shortcut":"mgh","sex":"M","birth_date":"","department":"\u8d44\u4ea7\u5904","job_position":"\u79d1\u957f","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2023-09-12 08:47:08","updated_at":"2023-09-12 08:47:08","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"mo","pinyin2":"guang","pinyin3":"hui","pinyin4":"","namecut1":"\u83ab","namecut2":"\u5149","namecut3":"\u8f89","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":5609,"contact_id":4814,"mobile":"18910590879","mp_open_id":"","mobile_display":"18910590879"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u83ab\u5149\u8f89","email_display":"","telephone_display":"","unread":0},{"id":303,"name":"\u5218\u575a","email":"","pinyin_shortcut":"lj","sex":"M","birth_date":"","department":"\u751f\u4ea7\u90e8","job_position":"\u6280\u672f","mobile":"","telephone":"61721950","client_id":149,"supplier_id":"","created_by":1022,"created_at":"2017-03-08 20:09:03","updated_at":"2023-07-13 22:59:30","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"jian","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u575a","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","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":"","can_update":true,"can_delete":true,"name_display":"\u5218\u575a","email_display":"","telephone_display":"61721950","unread":0},{"id":4659,"name":"\u80e1\u79d1\u6770","email":"","pinyin_shortcut":"hkj","sex":"M","birth_date":"","department":"\u6c38\u5c45\u8bc1","job_position":"\u4e3b\u4efb","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":5085,"created_at":"2023-06-28 09:28:57","updated_at":"2023-06-28 09:29:28","user_status":2,"description":"\u6c38\u5c45\u8bc1\u80e1\u79d1\u6770","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"hu","pinyin2":"ke","pinyin3":"jie","pinyin4":"","namecut1":"\u80e1","namecut2":"\u79d1","namecut3":"\u6770","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","user_status":"1"},"mobiles":[{"id":5468,"contact_id":4659,"mobile":"13811935368","mp_open_id":"","mobile_display":"13811935368"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u80e1\u79d1\u6770","email_display":"","telephone_display":"","unread":0},{"id":1270,"name":"\u90b1\u65ed\u534e","email":"","pinyin_shortcut":"qxh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1015,"created_at":"2017-11-10 09:58:26","updated_at":"2023-01-05 11:45:38","user_status":2,"description":"\u5bb6\uff1a\u5317\u4eac\u5e02\u897f\u57ce\u533a\u897f\u4fbf\u95e8\u5185\u5927\u885752\u53f7 \u5929\u6cfd\u56ed\u5c0f\u533a 1\u53f7\u697c 3\u95e8310\u623f\u95f4","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"qiu","pinyin2":"xu","pinyin3":"hua","pinyin4":"","namecut1":"\u90b1","namecut2":"\u65ed","namecut3":"\u534e","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","user_status":"1"},"mobiles":[{"id":4395,"contact_id":1270,"mobile":"12345678901","mp_open_id":"","mobile_display":"12345678901"}],"commentCount":{},"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u90b1\u65ed\u534e","email_display":"","telephone_display":"","unread":0},{"id":4125,"name":"\u738b\u5411\u4e1c","email":"","pinyin_shortcut":"wxd","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"61721950","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2022-09-08 14:35:07","updated_at":"2022-12-27 21:37:16","user_status":2,"description":"\u660c\u5e73\u533a\u65b0\u5eb7\u56ed\u5c0f\u533a1\u53f7\u697c2\u5355\u5143203\u53f7\u3002\u738b\u5411\u4e1c 133 9158 7580\uff0c\u5e2e\u6211\u53d12\u76d2\u6708\u997c","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"xiang","pinyin3":"dong","pinyin4":"","namecut1":"\u738b","namecut2":"\u5411","namecut3":"\u4e1c","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":4952,"contact_id":4125,"mobile":"13391587580","mp_open_id":"","mobile_display":"13391587580"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u738b\u5411\u4e1c","email_display":"","telephone_display":"010-61721950","unread":0},{"id":1988,"name":"\u674e\u82f1","email":"","pinyin_shortcut":"ly","sex":"F","birth_date":"","department":"\u8bc1\u4ef6\u90e8","job_position":"\u6280\u672f\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2018-05-24 08:56:14","updated_at":"2022-09-02 15:30:46","user_status":2,"description":"\u5bb6\uff1a\u5317\u4eac\u5e02\u897f\u57ce\u533a\u5317\u9732\u56ed5\u53f7\u697c6\u5355\u5143502","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"ying","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u82f1","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":4950,"contact_id":1988,"mobile":"13810818979","mp_open_id":"","mobile_display":"13810818979"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u674e\u82f1","email_display":"","telephone_display":"","unread":0},{"id":1156,"name":"\u7fc1\u660c\u6960","email":"","pinyin_shortcut":"wcn","sex":"M","birth_date":"","department":"","job_position":"\u5904\u957f","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2017-09-29 17:55:15","updated_at":"2021-07-26 15:18:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"weng","pinyin2":"chang","pinyin3":"nan","pinyin4":"","namecut1":"\u7fc1","namecut2":"\u660c","namecut3":"\u6960","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":4396,"contact_id":1156,"mobile":"13601019650","mp_open_id":"","mobile_display":"13601019650"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u7fc1\u660c\u6960","email_display":"","telephone_display":"","unread":0},{"id":1385,"name":"\u9648\u536b","email":"","pinyin_shortcut":"cw","sex":"M","birth_date":"","department":"","job_position":"\u603b\u7ecf\u7406","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2017-12-09 12:01:20","updated_at":"2021-07-26 15:16:27","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"chen","pinyin2":"wei","pinyin3":"","pinyin4":"","namecut1":"\u9648","namecut2":"\u536b","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":4392,"contact_id":1385,"mobile":"13801365810","mp_open_id":"","mobile_display":"13801365810"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u9648\u536b","email_display":"","telephone_display":"","unread":0},{"id":3322,"name":"\u6bd5\u6653\u6645","email":"","pinyin_shortcut":"bxx","sex":"M","birth_date":"","department":"\u751f\u4ea7\u90e8","job_position":"\u4e3b\u4efb","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2020-09-01 14:54:07","updated_at":"2020-09-01 14:54:07","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"bi","pinyin2":"xiao","pinyin3":"xuan","pinyin4":"","namecut1":"\u6bd5","namecut2":"\u6653","namecut3":"\u6645","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":3696,"contact_id":3322,"mobile":"13910110069","mp_open_id":"","mobile_display":"13910110069"}],"commentCount":{},"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u6bd5\u6653\u6645","email_display":"","telephone_display":"","unread":0},{"id":3130,"name":"\u8d3a\u6960","email":"","pinyin_shortcut":"hn","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1016,"created_at":"2020-04-20 16:15:40","updated_at":"2020-04-20 16:15:40","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"he","pinyin2":"nan","pinyin3":"","pinyin4":"","namecut1":"\u8d3a","namecut2":"\u6960","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1016,"key":1016,"name":"\u8346\u626c(\u5df2\u79bb\u804c)","sex":"M","user_status":"-1"},"mobiles":[{"id":3398,"contact_id":3130,"mobile":"18601345105","mp_open_id":"","mobile_display":"18601345105"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u8d3a\u6960","email_display":"","telephone_display":"","unread":0},{"id":3111,"name":"\u8d75\u4e9a\u5f3a","email":"","pinyin_shortcut":"zyq","sex":"M","birth_date":"","department":"\u8bc1\u4ef6\u90e8","job_position":"\u6570\u636e\u5e93\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2020-03-18 16:18:07","updated_at":"2020-03-18 16:18:07","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhao","pinyin2":"ya","pinyin3":"qiang","pinyin4":"","namecut1":"\u8d75","namecut2":"\u4e9a","namecut3":"\u5f3a","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":3371,"contact_id":3111,"mobile":"15600908378","mp_open_id":"","mobile_display":"15600908378"}],"commentCount":{},"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u8d75\u4e9a\u5f3a","email_display":"","telephone_display":"","unread":0},{"id":2517,"name":"\u8042\u4e3b\u4efb","email":"","pinyin_shortcut":"nzr","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2019-04-08 08:56:56","updated_at":"2019-04-08 08:56:56","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"nie","pinyin2":"zhu","pinyin3":"ren","pinyin4":"","namecut1":"\u8042","namecut2":"\u4e3b","namecut3":"\u4efb","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u8042\u4e3b\u4efb","email_display":"","telephone_display":"","unread":0},{"id":1155,"name":"\u6881\u4e3b\u4efb","email":"","pinyin_shortcut":"lzr","sex":"M","birth_date":"","department":"\u751f\u4ea7\u5904\u4e3b\u4efb","job_position":"","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1005,"created_at":"2017-09-29 17:54:32","updated_at":"2018-07-30 08:48:33","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liang","pinyin2":"zhu","pinyin3":"ren","pinyin4":"","namecut1":"\u6881","namecut2":"\u4e3b","namecut3":"\u4efb","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","user_status":"1"},"mobiles":[{"id":2043,"contact_id":1155,"mobile":"13311576357","mp_open_id":"","mobile_display":"13311576357"}],"commentCount":{},"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u6881\u4e3b\u4efb","email_display":"","telephone_display":"","unread":0},{"id":783,"name":"\u9a6c\u6210","email":"","pinyin_shortcut":"mc","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":149,"supplier_id":"","created_by":1022,"created_at":"2017-06-02 19:18:41","updated_at":"2018-07-30 08:48:20","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ma","pinyin2":"cheng","pinyin3":"","pinyin4":"","namecut1":"\u9a6c","namecut2":"\u6210","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","user_status":"1"},"mobiles":[{"id":2042,"contact_id":783,"mobile":"18310095133","mp_open_id":"","mobile_display":"18310095133"}],"commentCount":{},"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"},{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":"","can_update":true,"can_delete":true,"name_display":"\u9a6c\u6210","email_display":"","telephone_display":"","unread":0}],"can_create":true,"pagenation":{"totalcount":22,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-03 16:50:28', 636886272) RETURNING "id"

[+] Explain