6891c2fdc3f45: POST https://beta.jinchangxiao.com/v2/client/get-edit at 2025-08-05 04:38:21 pm by 124.64.23.198
Database Queries
总计41条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 16:38:21.806 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='JaijjTZWzZjgdx9RhHhwFXGU-e0N-Sfm' |
| 16:38:21.809 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:38:21.811 | 7888.6 ms | SELECT | SELECT c.*, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE c.sales_rep END AS sales_rep, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, CASE WHEN p.id IS NULL THEN false ELSE true END AS cooperated, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(sl.end_at) as last_contact, cc.notice_days AS notice_days FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.client_id = c.id AND p.project_status = 3 LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON cc.id = c.client_class WHERE ("c"."id"='12') AND ("deleted"=FALSE) GROUP BY "c"."id", "cooperated", "cc"."notice_days" |
| 16:38:29.702 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=5 |
| 16:38:29.703 | 1.1 ms | SELECT | SELECT "id", "id" AS "key", "name", "notice_days", "color", "visit_base" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=80 |
| 16:38:29.704 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=6 |
| 16:38:29.704 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=5 |
| 16:38:29.705 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 |
| 16:38:29.705 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300) |
| 16:38:29.706 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=12 |
| 16:38:29.706 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (97, 213, 2, 7, 212, 165, 179, 142, 133, 197, 194, 140, 8, 1, 5, 94, 215, 226, 229, 316, 326)) ORDER BY "sort" |
| 16:38:29.707 | 1.1 ms | SELECT | SELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id"=12) |
| 16:38:29.708 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1003 |
| 16:38:29.709 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1003) |
| 16:38:29.709 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 16:38:29.709 | 0.6 ms | SELECT | SELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id"=12) GROUP BY "client_id" |
| 16:38:29.710 | 0.7 ms | SELECT | SELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "client_id"=12 GROUP BY "client_id" |
| 16:38:29.711 | 0.6 ms | SELECT | SELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("client_id"=12) GROUP BY "client_id" |
| 16:38:29.712 | 7.1 ms | SELECT | SELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."client_id"=12) GROUP BY "c"."client_id" |
| 16:38:29.719 | 3.1 ms | SELECT | SELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."client_id"=12) GROUP BY "c"."client_id" |
| 16:38:29.723 | 0.6 ms | SELECT | SELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("client_id"=12) GROUP BY "client_id" |
| 16:38:29.723 | 1.3 ms | SELECT | SELECT "client_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("client_id"=12) GROUP BY "client_id" |
| 16:38:29.725 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "a57be577deb434"."tbl_client_addresses" WHERE "client_id"=12 |
| 16:38:29.725 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id"=12 |
| 16:38:29.727 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1) |
| 16:38:29.727 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1003, 1022, 1018, 1016, 5300, 1015, 1011) |
| 16:38:29.728 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (17, 16, 202, 329, 1079, 1022, 469, 1452, 1852, 1869, 1931, 4518, 5191, 5275, 5761, 6038, 6091, 6096) |
| 16:38:29.729 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (17, 16, 202, 329, 1079, 1022, 469, 1452, 1852, 1869, 1931, 4518, 5191, 5275, 5761, 6038, 6091, 6096) |
| 16:38:29.730 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (46, 100, 101, 6, 93, 165, 179, 142, 105, 102, 2100000000, 97, 185, 193, 213, 1, 2, 7, 136, 135, 196, 204, 139, 130, 172, 205, 164, 184, 194, 94, 10, 5, 197, 199, 8, 215, 226, 128, 131, 173, 212, 153, 230, 189, 192, 181, 207, 214, 219, 223, 224, 229, 231, 9, 208, 210, 211, 227, 216, 228, 11, 209, 217, 218, 221, 225, 222, 154, 166, 313, 107, 156, 320, 315, 319, 112, 340, 137, 140, 160, 133, 349, 183, 322, 350, 359, 365, 373, 377, 348, 323)) ORDER BY "sort" |
| 16:38:29.731 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (17, 16, 202, 329, 1079, 1022, 469, 1452, 1852, 1869, 1931, 4518, 5191, 5275, 5761, 6038, 6091, 6096) |
| 16:38:29.732 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (46, 100, 101, 6, 93, 165, 179, 142, 105, 102, 2100000000, 97, 185, 193, 213, 1, 2, 7, 136, 135, 196, 204, 139, 130, 172, 205, 164, 184, 194, 94, 10, 5, 197, 199, 8, 215, 226, 128, 131, 173, 212, 153, 230, 189, 192, 181, 207, 214, 219, 223, 224, 229, 231, 9, 208, 210, 211, 227, 216, 228, 11, 209, 217, 218, 221, 225, 222, 154, 166, 313, 107, 156, 320, 315, 319, 112, 340, 137, 140, 160, 133, 349, 183, 322, 350, 359, 365, 373, 377, 348, 323)) ORDER BY "sort" |
| 16:38:29.733 | 19.6 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=10) AND ("object_id"=12) GROUP BY "object_id" |
| 16:38:29.753 | 16.9 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=10) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=12) GROUP BY "object_id" |
| 16:38:29.770 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_address_rels" WHERE "client_id"=12 |
| 16:38:29.770 | 1.3 ms | SELECT | SELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE ("address2" != '') AND ("address2" IS NOT NULL) AND ("id" IN (4215, 4216)) |
| 16:38:29.774 | 1.8 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE (("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("c"."id"=12)) |
| 16:38:29.779 | 0.2 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=5 |
| 16:38:29.779 | 0.2 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=80 |
| 16:38:29.779 | 0.1 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=6 |
| 16:38:29.779 | 0.1 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=5 |
| 16:38:29.780 | 1.8 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 265, 'v2/client/get-edit', '{"access_token":"JaijjTZWzZjgdx9RhHhwFXGU-e0N-Sfm","device_type":"0","version_code":"265","id":"12","lat":"39.960297","lng":"116.28911","token":"d01a671ece9cba8fc13a624f05a1bcbe","posttime":"1754383102"}', '{"code":200,"data":{"model":{"id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"smczgyxgsSMCbjzzyxgs","description":"","corp_rep":"\u8584\u4e95\u90c1\u4e8c","website":"http:\/\/www.smc.com.cn","capital":"125632.5","established_at":"1994-09-02","headcount":"4054","reg_address":26,"working_address":null,"telephone":" 010-67885566","fax":"010-67881837","scale":"","branch":"\uff33\uff2d\uff23(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u6280\u672f\u7814\u53d1\u4e2d\u5fc3","purchase_scale_per_yr":"200","purchase_freq":"","company_nature":6,"client_class":80,"client_industry":5,"client_type":5,"sales_rep":5300,"main_contact":null,"created_by":1003,"created_at":"2017-02-08 17:23:15","updated_at":"2025-07-28 17:55:50","main_business":"\u673a\u68b0\u5236\u9020\u6c7d\u7f38","deleted":false,"capital_currency":"rmb","invoice_info":"\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a \t9111030260002492XA ","logo":null,"en_name":"","pick_at":"2022-10-12 15:39:34","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":9,"client_key_info_count":2,"contact_count":17,"visit_count":11,"cooperate_count":37,"case_pre_sales_count":4,"case_implement_count":18,"is_overdue_remind":false,"from_contact":null,"is_public":1,"cooperated":true,"lost_contact_days":"12.1363635800347","last_arrive_days":"12.1363635800347","last_contact":"2025-07-24 13:22:00","notice_days":30,"workingAddress":null,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315","visit_base":60},"companyNature":{"id":6,"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","client_lock":true,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientFrom":null,"unCloseCases":[],"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"workLogCount":{"client_id":12,"count":328},"caseCount":{"client_id":12,"count":134},"salesTimeCount":{"client_id":12,"hours":"43.7833333333333","times":27},"implementTimeCount":{"client_id":12,"sum":"153.759444444444","times":"118"},"presalesTimeCount":{"client_id":12,"sum":"29.3675","times":"14"},"engineerTimeCount":{"client_id":12,"hours":"8.5","times":5},"reimbursementAmountSum":{"client_id":12,"sum":"19060.70"},"addresses":[{"id":368,"key":368,"name":"\u5317\u4eac\u7ecf\u6d4e\u6280\u672f\u5f00\u53d1\u533a\u5174\u76db\u8857\u75322\u53f7","client_id":12},{"id":369,"key":369,"name":"\u4ea6\u5e84\u7ecf\u6d4e\u6280\u672f\u5f00\u53d1\u533a\u5b8f\u8fbe\u4e2d\u8def2\u53f7","client_id":12}],"contacts":[{"id":17,"name":"\u5218\u6606","email":"liukun@smc.com.cn","pinyin_shortcut":"lk","sex":"M","birth_date":null,"department":"\u8d2d\u4e70\u90e8","job_position":"\u8bfe\u957f","mobile":null,"telephone":"67885566-24506","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2017-02-08 17:26:26","updated_at":"2017-03-28 11:39:39","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":"oagch6Vec0Fybbx1I-FzrY0phg0o","pinyin1":"liu","pinyin2":"kun","pinyin3":null,"pinyin4":null,"namecut1":"\u5218","namecut2":"\u6606","namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":23,"contact_id":17,"mobile":"13810668780","mp_open_id":"oagch6Vec0Fybbx1I-FzrY0phg0o"}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":16,"name":"\u7f34\u4eae","email":"jiaoliang@smc.com.cn","pinyin_shortcut":"jl","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u8bfe\u957f","mobile":null,"telephone":"67885566-16929","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2017-02-08 17:24:37","updated_at":"2017-03-28 11:38:53","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"jiao","pinyin2":"liang","pinyin3":null,"pinyin4":null,"namecut1":"\u7f34","namecut2":"\u4eae","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":22,"contact_id":16,"mobile":"13911128030","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":202,"name":"\u5218\u5efa\u56fd","email":"liujianguo@smc.com.cn","pinyin_shortcut":"ljg","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u5de5\u7a0b\u5e08","mobile":null,"telephone":"67885566-16927","client_id":12,"supplier_id":null,"created_by":1022,"created_at":"2017-02-28 16:18:52","updated_at":"2017-03-28 11:39:26","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"liu","pinyin2":"jian","pinyin3":"guo","pinyin4":null,"namecut1":"\u5218","namecut2":"\u5efa","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","user_status":"1"},"mobiles":[{"id":211,"contact_id":202,"mobile":"15810967168","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":329,"name":"\u5b8b\u521a\u592b","email":"songgangfu@smc.com.cn","pinyin_shortcut":"sgf","sex":"M","birth_date":null,"department":"\u7535\u7b97","job_position":"\u79d1\u957f","mobile":null,"telephone":"67885566-16916","client_id":12,"supplier_id":null,"created_by":1018,"created_at":"2017-03-13 13:36:02","updated_at":"2017-03-28 11:39:11","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"song","pinyin2":"gang","pinyin3":"fu","pinyin4":null,"namecut1":"\u5b8b","namecut2":"\u521a","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1018,"key":1018,"name":"\u7a0b\u946b\u658c","sex":"M","user_status":"-1"},"mobiles":[{"id":318,"contact_id":329,"mobile":"13701152782","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1079,"name":"\u5168\u52c7\u7537","email":"quanyongnan@smc.com.cn","pinyin_shortcut":"qyn","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u90e8\u957f","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2017-08-31 16:31:21","updated_at":"2017-11-13 15:58:31","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"quan","pinyin2":"yong","pinyin3":"nan","pinyin4":null,"namecut1":"\u5168","namecut2":"\u52c7","namecut3":"\u7537","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":947,"contact_id":1079,"mobile":"13581889159","mp_open_id":null}],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1022,"name":"\u674e\u7194\u53cb","email":"lirongyou@smc.com.cn","pinyin_shortcut":"lry","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u5de5\u7a0b\u5e08","mobile":"","telephone":"80480101","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2017-07-31 15:37:51","updated_at":"2023-10-17 17:49:15","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"rong","pinyin3":"you","pinyin4":null,"namecut1":"\u674e","namecut2":"\u7194","namecut3":"\u53cb","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":5574,"contact_id":1022,"mobile":"15311444022","mp_open_id":"oagch6STIcr4Xg3n38Njq9ZI3Kwg"}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":469,"name":"\u949f\u4eac\u7a57","email":"smc8900@smc.com.cn","pinyin_shortcut":"zjs","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u987e\u95ee","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2017-04-05 14:30:26","updated_at":"2018-03-30 21:02:45","user_status":1,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhong","pinyin2":"jing","pinyin3":"sui","pinyin4":null,"namecut1":"\u949f","namecut2":"\u4eac","namecut3":"\u7a57","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":1254,"contact_id":469,"mobile":"13801178172","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1452,"name":"\u6d82\u52c7\uff08\u5185\u7ebf\uff09","email":"tuyong@smc.com.cn","pinyin_shortcut":"tynx","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u79d1\u957f","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2018-01-09 20:49:40","updated_at":"2018-01-22 14:54:07","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"tu","pinyin2":"yong","pinyin3":"nei","pinyin4":"xian","namecut1":"\u6d82","namecut2":"\u52c7","namecut3":"\uff08","namecut4":"\u5185","is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":1382,"contact_id":1452,"mobile":"13911023106","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1852,"name":"\u59da\u6606","email":"yaokun@smc.com.cn","pinyin_shortcut":"yk","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2018-03-23 11:36:16","updated_at":"2023-09-08 09:24:23","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"yao","pinyin2":"kun","pinyin3":null,"pinyin4":null,"namecut1":"\u59da","namecut2":"\u6606","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1869,"name":"\u674e\u6842\u5a1f","email":"liguijuan@smc.com.cn","pinyin_shortcut":"lgj","sex":"F","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u79d1\u957f","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2018-03-30 20:58:33","updated_at":"2018-03-30 20:58:33","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"gui","pinyin3":"juan","pinyin4":null,"namecut1":"\u674e","namecut2":"\u6842","namecut3":"\u5a1f","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":1742,"contact_id":1869,"mobile":"13611225272","mp_open_id":null}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1931,"name":"\u803f\u6653\u8389","email":"","pinyin_shortcut":"gxl","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"67885566","client_id":12,"supplier_id":null,"created_by":1016,"created_at":"2018-05-03 14:30:03","updated_at":"2018-08-08 19:06:46","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"42111","mp_open_id":null,"pinyin1":"geng","pinyin2":"xiao","pinyin3":"li","pinyin4":null,"namecut1":"\u803f","namecut2":"\u6653","namecut3":"\u8389","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","user_status":"-1"},"mobiles":[],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":null},{"id":4518,"name":"\u738b\u73b2\u7389","email":"","pinyin_shortcut":"wly","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2023-03-07 16:10:49","updated_at":"2023-03-07 16:10:49","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wang","pinyin2":"ling","pinyin3":"yu","pinyin4":null,"namecut1":"\u738b","namecut2":"\u73b2","namecut3":"\u7389","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":5332,"contact_id":4518,"mobile":"13132115791","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":5191,"name":"\u6768\u65ed","email":"","pinyin_shortcut":"yx","sex":"M","birth_date":null,"department":"","job_position":"\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"00000000","client_id":12,"supplier_id":null,"created_by":1015,"created_at":"2024-01-25 00:36:22","updated_at":"2024-01-25 00:36:22","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"000","telephone_extension_number":"00","mp_open_id":null,"pinyin1":"yang","pinyin2":"xu","pinyin3":null,"pinyin4":null,"namecut1":"\u6768","namecut2":"\u65ed","namecut3":null,"namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","user_status":"1"},"mobiles":[{"id":5979,"contact_id":5191,"mobile":"13662051825","mp_open_id":null}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":null},{"id":5275,"name":"\u674e\u83b9","email":"","pinyin_shortcut":"ly","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"80480101","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2024-04-16 14:05:54","updated_at":"2024-04-16 14:05:54","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"ying","pinyin3":null,"pinyin4":null,"namecut1":"\u674e","namecut2":"\u83b9","namecut3":null,"namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6064,"contact_id":5275,"mobile":"13501032024","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":5761,"name":"\u8bb8\u4e16\u5fe0","email":"","pinyin_shortcut":"xsz","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2024-05-14 14:05:59","updated_at":"2024-05-14 14:05:59","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"xu","pinyin2":"shi","pinyin3":"zhong","pinyin4":null,"namecut1":"\u8bb8","namecut2":"\u4e16","namecut3":"\u5fe0","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6553,"contact_id":5761,"mobile":"18518572891","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":6038,"name":"\u5f20\u91d1\u946b","email":"","pinyin_shortcut":"zjx","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2025-04-17 10:38:52","updated_at":"2025-04-17 10:38:52","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"jin","pinyin3":"xin","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u91d1","namecut3":"\u946b","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6820,"contact_id":6038,"mobile":"18222331096","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":6091,"name":"\u4ed8\u677e\u741b","email":"","pinyin_shortcut":"fsc","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":1011,"created_at":"2025-07-01 11:48:36","updated_at":"2025-07-01 11:48:36","user_status":2,"description":"SMC\uff08\u5929\u6d25\uff09\u5236\u9020\u6709\u9650\u516c\u53f8 \u6536\u8d27\u4eba","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"fu","pinyin2":"song","pinyin3":"chen","pinyin4":null,"namecut1":"\u4ed8","namecut2":"\u677e","namecut3":"\u741b","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6875,"contact_id":6091,"mobile":"17822165115","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":6096,"name":"\u8096\u9701\u6850","email":"xiaojitong@smc.com.cn","pinyin_shortcut":"xjt","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"67885566","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2025-07-02 17:35:48","updated_at":"2025-07-02 17:35:48","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"16925","mp_open_id":null,"pinyin1":"xiao","pinyin2":"ji","pinyin3":"tong","pinyin4":null,"namecut1":"\u8096","namecut2":"\u9701","namecut3":"\u6850","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":null}],"commentCount":{"object_id":12,"comment":7},"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":4215,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","address1":"\u5317\u4eac\u7ecf\u6d4e\u6280\u672f\u5f00\u53d1\u533a\u5174\u76db\u8857\u75322\u53f7","address2":"\u5317\u4eac\u5e02\u5927\u5174\u533aSMC\u4e2d\u56fd\u6280\u672f\u4e2d\u5fc3","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u5927\u5174\u533a","zip":null,"country":"\u4e2d\u56fd","geolocation":"(116.5146,39.79027)","created_by":5300,"created_at":"2025-07-16 14:03:51","updated_at":"2025-07-16 14:03:51","state_id":110000,"city_id":110100,"region_id":110115,"country_id":1,"lng":"116.5146","lat":"39.79027"},{"id":4216,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","address1":"\u5317\u4eac\u5e02\u987a\u4e49\u533a\u5929\u7afa\u7a7a\u6e2f\u5de5\u4e1a\u533aA\u533a\u5929\u67f1\u4e1c\u8def3\u53f7","address2":"smc\u5317\u4eac\u5236\u9020\u6709\u9650\u516c\u53f8\u4e1c\u95e8","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u987a\u4e49\u533a","zip":null,"country":"\u4e2d\u56fd","geolocation":"(116.5619,40.08317)","created_by":5300,"created_at":"2025-07-16 14:03:51","updated_at":"2025-07-16 14:03:51","state_id":110000,"city_id":110100,"region_id":110113,"country_id":1,"lng":"116.5619","lat":"40.08317"}],"unread":0,"lost_contact_days_display":"12\u5929\u524d","last_arrive_days_display":null,"bgcolor":"#0EE315","overdue_display":"","last_arrive_overdue_display":"","can_pick_up":false,"can_transfer":false,"can_update":true,"can_delete":false,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},"options":[{"key":"sales_rep","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5300,"name":"\u82cf\u6e05\u4e91"}]},{"key":"client_industry","name":"\u5ba2\u6237\u884c\u4e1a","value":[{"key":5,"name":"\u5236\u9020"}]},{"key":"company_nature","name":"\u516c\u53f8\u6027\u8d28","value":[{"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"}]},{"key":"client_class","name":"\u5ba2\u6237\u7ea7\u522b","value":[{"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"}]},{"key":"client_type","name":"\u5ba2\u6237\u6027\u8d28","value":[{"key":5,"name":"\u5546\u4e1a"}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-05 16:38:29') RETURNING "id" |