ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a577c253ebfe: POST https://beta.jinchangxiao.com/v2/client/list at 2026-07-15 08:25:09 pm by 111.9.5.127

Database Queries

总计39条数据
TimeDurationTypeQuery
  
20:25:09.2612.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'

[+] Explain
20:25:09.2652.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
20:25:09.278116.8 msSELECTSELECT COUNT(*) FROM (SELECT c.*, CASE WHEN p.client_id IS NULL THEN false ELSE true END AS cooperated, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, sl.lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, sl.last_contact, max(arrive.end_at) as last_arrive, CASE WHEN c.client_class IS NOT NULL THEN ( (CASE WHEN cl.contact_base > 0 THEN floor(CASE WHEN c.contact_count > cl.contact_base THEN 1 * 15 ELSE c.contact_count * 15 / cl.contact_base END) ELSE 15 END) + floor(c.client_base_info_count * 15 / 9) + (CASE WHEN cl.visit_base > 0 THEN floor(CASE WHEN c.visit_count > ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 196::float END) / cl.visit_base::float) THEN 1 * 20 ELSE c.visit_count * 20 / ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 196::float END) / cl.visit_base::float) END) ELSE 20 END) + (CASE WHEN cl.cooperate_base > 0 THEN floor(CASE WHEN c.cooperate_count > cl.cooperate_base THEN 1 * 20 ELSE c.cooperate_count * 20 / cl.cooperate_base END) ELSE 20 END) + (CASE WHEN cl.case_pre_sales_base > 0 THEN floor(CASE WHEN c.case_pre_sales_count > cl.case_pre_sales_base THEN 1 * 15 ELSE c.case_pre_sales_count * 15 / cl.case_pre_sales_base END) ELSE 15 END) + (CASE WHEN cl.case_implement_base > 0 THEN floor(CASE WHEN c.case_implement_count > cl.case_implement_base THEN 1 * 15 ELSE c.case_implement_count * 15 / cl.case_implement_base END) ELSE 15 END) ) ELSE NULL END as score FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id 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 (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%联通%' GROUP BY "client_id") "cc" ON cc.client_id = c.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE (lower(pn) LIKE '%联通%') OR (lower(sn) LIKE '%联通%') OR (lower(description) LIKE '%联通%') GROUP BY "client_id") "s" ON c.id = s.client_id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE ("pinyin_shortcut" ILIKE '%联通%') OR ("project_title" ILIKE '%联通%') OR ("description" ILIKE '%联通%') OR ("comment" ILIKE '%联通%') GROUP BY "client_id") "pp" ON c.id = pp.client_id WHERE (("cc"."client_id" IS NOT NULL) OR ("s"."client_id" IS NOT NULL) OR ("pp"."client_id" IS NOT NULL) OR (lower(c.name) LIKE '%联通%') OR ("c"."pinyin_shortcut" LIKE '%联通%') OR (lower(c.description) LIKE '%联通%') OR (lower(c.it_budget) LIKE '%联通%') OR (lower(c.main_business) LIKE '%联通%') OR (lower(c.deployment_mode) LIKE '%联通%') OR (lower(c.it_per_num) LIKE '%联通%') OR (lower(c.public_relations_difficulty) LIKE '%联通%') OR (lower(c.it_status) LIKE '%联通%') OR (lower(c.decision_process) LIKE '%联通%') OR (lower(c.coach) LIKE '%联通%') OR (lower(c.competitor) LIKE '%联通%') OR (lower(c.main_product) LIKE '%联通%') OR (lower(c.headcount) LIKE '%联通%') OR (lower(c.peers) LIKE '%联通%') OR (lower(c.supplier) LIKE '%联通%')) AND (("c"."sales_rep" IN (5049, 5500, 5301, 5499, 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 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 ("deleted"=FALSE) GROUP BY "c"."id", "cl"."id", "cooperated", "lost_contact_days", "last_contact" ORDER BY "is_public" DESC, lost_contact_days ASC NULLS LAST, "c"."created_at" DESC) "c"

[+] Explain
20:25:09.396133.0 msSELECTSELECT c.*, CASE WHEN p.client_id IS NULL THEN false ELSE true END AS cooperated, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, sl.lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, sl.last_contact, max(arrive.end_at) as last_arrive, CASE WHEN c.client_class IS NOT NULL THEN ( (CASE WHEN cl.contact_base > 0 THEN floor(CASE WHEN c.contact_count > cl.contact_base THEN 1 * 15 ELSE c.contact_count * 15 / cl.contact_base END) ELSE 15 END) + floor(c.client_base_info_count * 15 / 9) + (CASE WHEN cl.visit_base > 0 THEN floor(CASE WHEN c.visit_count > ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 196::float END) / cl.visit_base::float) THEN 1 * 20 ELSE c.visit_count * 20 / ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 196::float END) / cl.visit_base::float) END) ELSE 20 END) + (CASE WHEN cl.cooperate_base > 0 THEN floor(CASE WHEN c.cooperate_count > cl.cooperate_base THEN 1 * 20 ELSE c.cooperate_count * 20 / cl.cooperate_base END) ELSE 20 END) + (CASE WHEN cl.case_pre_sales_base > 0 THEN floor(CASE WHEN c.case_pre_sales_count > cl.case_pre_sales_base THEN 1 * 15 ELSE c.case_pre_sales_count * 15 / cl.case_pre_sales_base END) ELSE 15 END) + (CASE WHEN cl.case_implement_base > 0 THEN floor(CASE WHEN c.case_implement_count > cl.case_implement_base THEN 1 * 15 ELSE c.case_implement_count * 15 / cl.case_implement_base END) ELSE 15 END) ) ELSE NULL END as score FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id 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 (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%联通%' GROUP BY "client_id") "cc" ON cc.client_id = c.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE (lower(pn) LIKE '%联通%') OR (lower(sn) LIKE '%联通%') OR (lower(description) LIKE '%联通%') GROUP BY "client_id") "s" ON c.id = s.client_id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE ("pinyin_shortcut" ILIKE '%联通%') OR ("project_title" ILIKE '%联通%') OR ("description" ILIKE '%联通%') OR ("comment" ILIKE '%联通%') GROUP BY "client_id") "pp" ON c.id = pp.client_id WHERE (("cc"."client_id" IS NOT NULL) OR ("s"."client_id" IS NOT NULL) OR ("pp"."client_id" IS NOT NULL) OR (lower(c.name) LIKE '%联通%') OR ("c"."pinyin_shortcut" LIKE '%联通%') OR (lower(c.description) LIKE '%联通%') OR (lower(c.it_budget) LIKE '%联通%') OR (lower(c.main_business) LIKE '%联通%') OR (lower(c.deployment_mode) LIKE '%联通%') OR (lower(c.it_per_num) LIKE '%联通%') OR (lower(c.public_relations_difficulty) LIKE '%联通%') OR (lower(c.it_status) LIKE '%联通%') OR (lower(c.decision_process) LIKE '%联通%') OR (lower(c.coach) LIKE '%联通%') OR (lower(c.competitor) LIKE '%联通%') OR (lower(c.main_product) LIKE '%联通%') OR (lower(c.headcount) LIKE '%联通%') OR (lower(c.peers) LIKE '%联通%') OR (lower(c.supplier) LIKE '%联通%')) AND (("c"."sales_rep" IN (5049, 5500, 5301, 5499, 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 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 ("deleted"=FALSE) GROUP BY "c"."id", "cl"."id", "cooperated", "lost_contact_days", "last_contact" ORDER BY "is_public" DESC, lost_contact_days ASC NULLS LAST, "c"."created_at" DESC LIMIT 10

[+] Explain
20:25:09.5300.7 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 1, 6)

[+] Explain
20:25:09.5310.5 msSELECTSELECT "id", "id" AS "key", "name", "notice_days", "color", "visit_base" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 47)

[+] Explain
20:25:09.5323.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)

[+] Explain
20:25:09.5361.0 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (100, 46, 101, 128, 179, 142, 138, 136, 140, 205, 206, 165, 164, 185, 191, 8, 2, 1, 183, 187, 5, 155, 184, 200, 189, 231, 207, 229, 224, 223, 214, 219, 9, 208, 210, 211, 226, 227, 7, 216, 6, 93, 228, 11, 209, 94, 217, 230, 218, 10, 213, 221, 225, 215, 222, 174, 153, 176, 330, 107, 139, 114, 317, 313, 112, 156, 166, 130, 349, 369, 372, 374, 2100000000, 340, 373, 377, 359, 432, 410, 400, 399, 315)) ORDER BY "sort"

[+] Explain
20:25:09.5370.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (20, 5, 10)

[+] Explain
20:25:09.5380.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id" IN (4, 3, 5)

[+] Explain
20:25:09.5380.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5087, 5295, 1004, 5311)

[+] Explain
20:25:09.5390.5 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 5295, 5087, 1004, 1001))

[+] Explain
20:25:09.5400.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5359, 5295, 5087, 1005, 1001, 1006)

[+] Explain
20:25:09.5410.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1006, 5087, 1005, 5359, 1001))

[+] Explain
20:25:09.5410.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 4)

[+] Explain
20:25:09.54219.3 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=10) AND ("object_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)) GROUP BY "object_id"

[+] Explain
20:25:09.5623.0 msSELECTSELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE "id" IN (3089, 30, 2732, 662, 648)

[+] Explain
20:25:09.5652.4 msSELECTSELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481))

[+] Explain
20:25:09.5688.9 msSELECTSELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)) GROUP BY "client_id"

[+] Explain
20:25:09.5772.3 msSELECTSELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "client_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481) GROUP BY "client_id"

[+] Explain
20:25:09.5801.5 msSELECTSELECT "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" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)) GROUP BY "client_id"

[+] Explain
20:25:09.58110.7 msSELECTSELECT "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" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)) GROUP BY "c"."client_id"

[+] Explain
20:25:09.5934.2 msSELECTSELECT "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" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)) GROUP BY "c"."client_id"

[+] Explain
20:25:09.5971.5 msSELECTSELECT "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" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)) GROUP BY "client_id"

[+] Explain
20:25:09.5993.3 msSELECTSELECT "client_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("client_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)) GROUP BY "client_id"

[+] Explain
20:25:09.6030.8 msSELECTSELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "a57be577deb434"."tbl_client_addresses" WHERE "client_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)

[+] Explain
20:25:09.6041.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)

[+] Explain
20:25:09.6060.5 msSELECTSELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1)

[+] Explain
20:25:09.6070.5 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1018, 1023, 1019, 1016, 1007, 1005, 5295, 5311, 1022, 5359, 1011, 5087)

[+] Explain
20:25:09.6081.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (2608, 849, 19, 48, 305, 304, 422, 534, 535, 536, 1263, 882, 1264, 1070, 1074, 1075, 2318, 3509, 477, 4615, 4661, 4087, 4888, 5193, 5932, 5981, 6179)

[+] Explain
20:25:09.6101.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2608, 849, 19, 48, 305, 304, 422, 534, 535, 536, 1263, 882, 1264, 1070, 1074, 1075, 2318, 3509, 477, 4615, 4661, 4087, 4888, 5193, 5932, 5981, 6179)

[+] Explain
20:25:09.6120.7 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (94, 99, 46, 100, 101, 106, 165, 179, 142, 97, 45, 112, 98, 8, 153, 96, 196, 204, 226, 182, 135, 134, 137, 133, 136, 139, 140, 315, 130, 185, 191, 155, 197, 194, 170, 181, 199, 205, 203, 189, 5, 7, 2, 6, 208, 1, 320, 10, 184, 128, 167, 107, 265, 229, 215, 156, 212, 183, 200, 172, 319, 105, 129, 231, 207, 224, 223, 214, 219, 9, 210, 211, 227, 216, 93, 228, 11, 209, 217, 230, 218, 213, 221, 225, 222, 232, 114, 2100000000, 333, 160, 316, 336, 340, 341, 346, 309, 349, 322, 164, 317, 305, 326, 359, 369, 377, 371, 350, 352, 356, 374, 432, 400, 386)) ORDER BY "sort"

[+] Explain
20:25:09.6131.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2608, 849, 19, 48, 305, 304, 422, 534, 535, 536, 1263, 882, 1264, 1070, 1074, 1075, 2318, 3509, 477, 4615, 4661, 4087, 4888, 5193, 5932, 5981, 6179)

[+] Explain
20:25:09.6150.7 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (94, 99, 46, 100, 101, 106, 165, 179, 142, 97, 45, 112, 98, 8, 153, 96, 196, 204, 226, 182, 135, 134, 137, 133, 136, 139, 140, 315, 130, 185, 191, 155, 197, 194, 170, 181, 199, 205, 203, 189, 5, 7, 2, 6, 208, 1, 320, 10, 184, 128, 167, 107, 265, 229, 215, 156, 212, 183, 200, 172, 319, 105, 129, 231, 207, 224, 223, 214, 219, 9, 210, 211, 227, 216, 93, 228, 11, 209, 217, 230, 218, 213, 221, 225, 222, 232, 114, 2100000000, 333, 160, 316, 336, 340, 341, 346, 309, 349, 322, 164, 317, 305, 326, 359, 369, 377, 371, 350, 352, 356, 374, 432, 400, 386)) ORDER BY "sort"

[+] Explain
20:25:09.61719.2 msSELECTSELECT "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" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)) GROUP BY "object_id"

[+] Explain
20:25:09.6360.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_address_rels" WHERE "client_id" IN (2616, 2538, 3417, 2032, 14, 2198, 28, 481)

[+] Explain
20:25:09.6370.8 msSELECTSELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE ("address2" != '') AND ("address2" IS NOT NULL) AND ("id" IN (2732, 30, 662, 3089, 648, 4068, 4231, 4232))

[+] Explain
20:25:09.6390.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
20:25:09.6455.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1161, 'v2/client/list', '{"ClientSearch":{"client_class":"","client_industry":"","client_type":"","company_nature":"","contact_status":"","cooperated":"","keyword":"\u8054\u901a","sales_rep":""},"Filter":{"name":"","sort":""},"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","lat":"30.52059516059028","lng":"104.0834309895833","posttime":"1784118272","token":"b3488fdbbec34539d519a5b344571509","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":null,"pinyin_shortcut":"bjydsbkjyxgsgd","description":"","corp_rep":"\u9648\u84c9","website":"","capital":"1000","established_at":"2010-02-01","headcount":null,"reg_address":null,"working_address":null,"telephone":"","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":5359,"created_at":"2023-10-23 21:18:16","updated_at":"2026-05-09 18:11:24","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101085514397148\n\u5730\u5740\uff0c\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4e09\u73af\u897f\u8def32\u53f7\u697c16\u5c421806\u5ba4 010-82095611\n\u5f00\u6237\u884c\u53ca\u5e10\u53f7\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5317\u592a\u5e73\u5e84\u652f\u884c 0200010019200496640","logo":null,"en_name":"","pick_at":"2025-01-13 16:21:22","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":5,"client_key_info_count":0,"contact_count":3,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"cooperated":true,"is_public":1,"lost_contact_days":"67.1334421057407","last_arrive_days":"902.385652753889","last_contact":"2026-05-09 17:13:00","last_arrive":"2024-01-25 11:09:49+08","score":"43","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":null,"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"createdBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"workingAddress":null,"unCloseCases":[],"workLogCount":{"client_id":2616,"count":5},"caseCount":null,"salesTimeCount":{"client_id":2616,"hours":"1.81805555555556","times":2},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[],"contacts":[{"id":4888,"name":"\u5218\u4e07\u5e7f","email":"","pinyin_shortcut":"lwg","sex":"M","birth_date":null,"department":"","job_position":"\u9500\u552e","mobile":"","telephone":"","client_id":2616,"supplier_id":null,"created_by":5359,"created_at":"2023-10-23 21:18:16","updated_at":"2023-10-23 21:18:16","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"liu","pinyin2":"wan","pinyin3":"guang","pinyin4":null,"namecut1":"\u5218","namecut2":"\u4e07","namecut3":"\u5e7f","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","user_status":"-1"},"mobiles":[{"id":5684,"contact_id":4888,"mobile":"13901046429","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":5193,"name":"\u5218\u6d69\u96ef","email":"","pinyin_shortcut":"lhw","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2616,"supplier_id":null,"created_by":5359,"created_at":"2024-01-25 20:34:14","updated_at":"2024-01-25 20:34:14","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"liu","pinyin2":"hao","pinyin3":"wen","pinyin4":null,"namecut1":"\u5218","namecut2":"\u6d69","namecut3":"\u96ef","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","user_status":"-1"},"mobiles":[{"id":5981,"contact_id":5193,"mobile":"15235187436","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":5981,"name":"\u8bb8\u5a1c\u5a1c","email":"","pinyin_shortcut":"xnn","sex":"M","birth_date":null,"department":"\u91c7\u8d2d\u90e8","job_position":"\u5546\u52a1","mobile":"","telephone":"82095611","client_id":2616,"supplier_id":null,"created_by":1011,"created_at":"2025-01-13 15:44:05","updated_at":"2025-01-13 15:44:05","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"xu","pinyin2":"na","pinyin3":"na","pinyin4":null,"namecut1":"\u8bb8","namecut2":"\u5a1c","namecut3":"\u5a1c","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":6768,"contact_id":5981,"mobile":"18851588760","mp_open_id":null}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":4068,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a:\u6052\u6da6\u56fd\u9645\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":null,"country":"\u4e2d\u56fd","geolocation":"(116.329015,39.966865)","created_by":1001,"created_at":"2025-01-13 16:21:22","updated_at":"2025-01-13 16:21:22","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.329015","lat":"39.966865"}],"unread":0,"lost_contact_days_display":"2\u4e2a\u6708\u524d","last_arrive_days_display":"2\u5e74\u524d","bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f8\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f888\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":2538,"name":"(\u8fc7\u5355)\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"gdbjklltkjfzgfyxgs","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":null,"reg_address":null,"working_address":3089,"telephone":"","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":5295,"created_at":"2023-05-18 11:35:22","updated_at":"2026-05-09 18:10:57","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-11-13 10:19:31","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":1,"client_key_info_count":0,"contact_count":2,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"cooperated":true,"is_public":1,"lost_contact_days":"67.1334421057407","last_arrive_days":null,"last_contact":"2026-05-09 17:13:00","last_arrive":null,"score":"36","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":{"id":156,"key":156,"name":"\u5382\u5546\u4ecb\u7ecd"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2538,"comment":1},"workingAddress":{"id":3089,"name":"\uff08\u8fc7\u5355\uff09\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","address1":null,"address2":"","state":null,"city":null,"region":null,"zip":"","country":"\u4e2d\u56fd","geolocation":null,"created_by":5295,"created_at":"2023-05-18 11:35:22","updated_at":"2023-06-14 12:20:35","state_id":null,"city_id":null,"region_id":null,"country_id":1,"lng":null,"lat":null},"unCloseCases":[],"workLogCount":{"client_id":2538,"count":4},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[],"contacts":[{"id":4615,"name":"\u5218\u5149\u660e","email":"","pinyin_shortcut":"lgm","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2538,"supplier_id":null,"created_by":5295,"created_at":"2023-05-18 20:00:29","updated_at":"2023-06-08 16:45:41","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"liu","pinyin2":"guang","pinyin3":"ming","pinyin4":null,"namecut1":"\u5218","namecut2":"\u5149","namecut3":"\u660e","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":5425,"contact_id":4615,"mobile":"18310217588","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":5932,"name":"\u5510\u4e60\u95fb","email":"","pinyin_shortcut":"txw","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"64847070","client_id":2538,"supplier_id":null,"created_by":1011,"created_at":"2024-11-13 10:09:44","updated_at":"2024-11-13 10:09:44","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"tang","pinyin2":"xi","pinyin3":"wen","pinyin4":null,"namecut1":"\u5510","namecut2":"\u4e60","namecut3":"\u95fb","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":6720,"contact_id":5932,"mobile":"18611919632","mp_open_id":null}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[],"unread":0,"lost_contact_days_display":"2\u4e2a\u6708\u524d","last_arrive_days_display":null,"bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f8\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f1140\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":3417,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","abbr":null,"pinyin_shortcut":"szhzbjkjyxgsgd","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":null,"reg_address":null,"working_address":null,"telephone":"","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":5087,"main_contact":null,"created_by":5087,"created_at":"2025-10-31 16:23:01","updated_at":"2026-03-09 00:52:15","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2025-10-31 16:23:01","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":0,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"128.856358772407","last_arrive_days":null,"last_contact":"2026-03-08 23:52:00","last_arrive":null,"score":"27","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":null,"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","client_lock":false,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"workingAddress":null,"unCloseCases":[],"workLogCount":{"client_id":3417,"count":2},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[],"contacts":[{"id":6179,"name":"\u5f20\u6d0b","email":"","pinyin_shortcut":"zy","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":3417,"supplier_id":null,"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":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"yang","pinyin3":null,"pinyin4":null,"namecut1":"\u5f20","namecut2":"\u6d0b","namecut3":null,"namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6961,"contact_id":6179,"mobile":"13021111199","mp_open_id":null}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}}],"unreadComments":null,"fromContact":null,"workingAddresses":[],"unread":0,"lost_contact_days_display":"4\u4e2a\u6708\u524d","last_arrive_days_display":null,"bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f69\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f243\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","abbr":null,"pinyin_shortcut":"cqlhkjgfyxgsbjfgsqdlhdzswyxgsbjypxxkjyxgs","description":"\u5317\u4eac\u662f\u603b\u90e8\uff0c240\u4eba\uff0c\u6709\u81ea\u5df1\u7684\u6570\u636e\u4e2d\u5fc3\uff0c\u673a\u623f\uff0c\u6570\u636e\u5e93\uff0c\u5df2\u7ecf\u7528\u4e867\u5e74\u4e86\u3002IT\u9884\u7b97\u4e0d\u56fa\u5b9a","corp_rep":"\u91d1 \u91d1\u7fbd\u4e2d","website":" http:\/\/www.afocus.com.cn","capital":"3300","established_at":"2010-09-29","headcount":"\u5404\u5730\u52a0\u8d77\u6765700-800\u4eba\uff0c\u5317\u4eac300-400\uff0c\u4ea6\u5e84100\uff0c\u4e0a\u6d77200\u591a\uff0c\u91cd\u5e86100\u591a\u4eba","reg_address":null,"working_address":null,"telephone":"023-63420740","fax":"","scale":"6.1-6.18 103\u4ebf \u53bb\u5e74\u53cc11\u6d3b\u52a81000\u591a\u4ebf\uff1b","branch":"","purchase_scale_per_yr":null,"purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":1,"sales_rep":5295,"main_contact":null,"created_by":1005,"created_at":"2021-01-15 17:02:11","updated_at":"2026-03-24 09:50:54","main_business":"\u6570\u5b57\u8425\u9500\u3001\u7535\u5546\u8425\u9500\u3001\u79fb\u52a8\u8425\u9500\uff0c\u4e5f\u6709\u76f4\u64ad\u7248\u5757","deleted":false,"capital_currency":"rmb","invoice_info":"915000005616488006","logo":null,"en_name":"","pick_at":"2021-06-23 22:33:43","it_budget":"40-50\u4e07\uff0c\u5176\u4e2d\u5927\u591a\u5728\u4e13\u7ebf\u4e0a","deployment_mode":"\u4e1a\u52a1\u4e0a\u4e91\uff0c\u4e0a\u7684\u963f\u91cc\u4e91\u548c\u534e\u4e3a\u4e91\uff0c\u672c\u5730\u4e5f\u6709\u6d4b\u8bd5","it_per_num":"1","public_relations_difficulty":"","it_status":"\u8054\u901a\u4e13\u7ebf300\u3001\u7535\u4fe1100\uff1b\u8bbe\u5907\u90fd\u662f\u534e\u4e3a\u7684\uff0c\u63a5\u5165\u8bbe\u5907\u662f\u534e\u4e09\u7684","decision_process":"\u6280\u672f\u90e8\u63d0\u9700\u6c42-\u9886\u5bfc\u5ba1\u6279","coach":"\u9648\u519b","competitor":"\u65e0","peers":"","supplier":"","main_product":"\u516c\u53f8\u6709\u76f4\u64ad\u5e73\u53f0\uff0c\u8fd8\u4e3a\u4eac\u4e1c\u63d0\u4f9b\u5927\u6570\u636e\uff08\u4eac\u7075\u5927\u6570\u636e\uff09\uff1b\u7535\u5546\u8425\u9500\u3001\u6570\u5b57\u8425\u9500","client_base_info_count":7,"client_key_info_count":11,"contact_count":1,"visit_count":3,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"cooperated":true,"is_public":1,"lost_contact_days":"138.411543957593","last_arrive_days":"138.411543957593","last_contact":"2026-02-27 10:32:32","last_arrive":"2026-02-27 10:32:32+08","score":"57","clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":null,"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","client_lock":false,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2032,"comment":3},"workingAddress":null,"unCloseCases":[],"workLogCount":{"client_id":2032,"count":153},"caseCount":{"client_id":2032,"count":43},"salesTimeCount":{"client_id":2032,"hours":"64.9061111111111","times":54},"implementTimeCount":{"client_id":2032,"sum":"120.473611111111","times":"40"},"presalesTimeCount":{"client_id":2032,"sum":"12.075","times":"8"},"engineerTimeCount":null,"reimbursementAmountSum":{"client_id":2032,"sum":"4005.08"},"addresses":[{"id":1304,"key":1304,"name":"\u5317\u4eac\u5e02\u897f\u57ce\u533a\u961c\u6210\u95e8\u5916\u5927\u88572\u53f76\u5c42621\u5ba4","client_id":2032}],"contacts":[{"id":3509,"name":"\u9648\u519b","email":"","pinyin_shortcut":"cj","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f","mobile":"","telephone":"61874160","client_id":2032,"supplier_id":null,"created_by":1005,"created_at":"2021-01-15 17:02:49","updated_at":"2021-08-27 17:42:28","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"023","telephone_extension_number":"","mp_open_id":null,"pinyin1":"chen","pinyin2":"jun","pinyin3":null,"pinyin4":null,"namecut1":"\u9648","namecut2":"\u519b","namecut3":null,"namecut4":null,"is_mp_bind":true,"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":4478,"contact_id":3509,"mobile":"13811095664","mp_open_id":"oagch6YPmauNCTsiJDXfpnI2eNAM"}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":4231,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","address1":"","address2":":\u5317\u4eac\u5e02\u897f\u57ce\u533a\u961c\u6210\u95e8\u5916\u5927\u88572\u53f7","state":null,"city":null,"region":null,"zip":null,"country":"\u4e2d\u56fd","geolocation":"(116.3543,39.92291)","created_by":5295,"created_at":"2025-08-11 11:11:53","updated_at":"2025-08-11 11:11:53","state_id":null,"city_id":null,"region_id":null,"country_id":1,"lng":"116.3543","lat":"39.92291"},{"id":4232,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","address1":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e39\u68f1\u88571\u53f7(\u6d77\u6dc0\u9ec4\u5e84\u5730\u94c1\u7ad9A2\u897f\u5317\u53e3\u6b65\u884c360\u7c73)","address2":"\u4e92\u8054\u7f51\u91d1\u878d","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":null,"country":"\u4e2d\u56fd","geolocation":"(116.3131,39.97932)","created_by":5295,"created_at":"2025-08-11 11:11:53","updated_at":"2025-08-11 11:11:53","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.3131","lat":"39.97932"}],"unread":0,"lost_contact_days_display":"4\u4e2a\u6708\u524d","last_arrive_days_display":"4\u4e2a\u6708\u524d","bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f79\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f124\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjbfcljtyxgs","description":"","corp_rep":"\u674e\u5168\u6587","website":"","capital":"17848.63","established_at":"1988-12-10","headcount":"4000","reg_address":29,"working_address":30,"telephone":"010-83807000 ","fax":"010-83876659","scale":"","branch":"","purchase_scale_per_yr":"500","purchase_freq":"","company_nature":3,"client_class":47,"client_industry":5,"client_type":6,"sales_rep":1004,"main_contact":null,"created_by":1001,"created_at":"2017-02-08 17:36:54","updated_at":"2026-03-22 22:31:17","main_business":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8\u662f\u4e2d\u56fd\u5175\u5668\u5de5\u4e1a\u96c6\u56e2\u516c\u53f8\u76f4\u5c5e\u5927\u578b\u4e00\u7c7b\u3001\u56fd\u5bb6\u4e8c\u7ea7\u519b\u6c11\u7ed3\u5408\u578b\u91cd\u70b9\u4fdd\u519b\u4f01\u4e1a\uff0c\u751f\u4ea7\u53ca\u9500\u552e\u88c5\u7532\u8f66\u8f86\u3001\u5317\u65b9\u5ba2\u8f66\u7b49\u3002","deleted":false,"capital_currency":"rmb","invoice_info":"\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a91110000101101759J","logo":null,"en_name":"","pick_at":"2023-11-28 12:59:38","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":2,"contact_count":12,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"cooperated":true,"is_public":1,"lost_contact_days":"141.444553216852","last_arrive_days":null,"last_contact":"2026-02-24 09:45:00","last_arrive":null,"score":"26","clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"clientFrom":{"id":166,"key":166,"name":"cold call"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"},"companyNature":{"id":3,"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","client_lock":false,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":null,"workingAddress":{"id":30,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","address1":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u6731\u5bb6\u575f5\u91cc5\u53f7","address2":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u957f\u8f9b\u5e97\u8857\u9053\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e30\u53f0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.185302,39.814434)","created_by":1004,"created_at":"2017-02-08 17:36:55","updated_at":"2023-11-28 12:59:38","state_id":110000,"city_id":110100,"region_id":110106,"country_id":1,"lng":"116.185302","lat":"39.814434"},"unCloseCases":[],"workLogCount":{"client_id":14,"count":290},"caseCount":{"client_id":14,"count":104},"salesTimeCount":null,"implementTimeCount":{"client_id":14,"sum":"457.963333333333","times":"94"},"presalesTimeCount":{"client_id":14,"sum":"22.1166666666667","times":"11"},"engineerTimeCount":{"client_id":14,"hours":"9","times":6},"reimbursementAmountSum":{"client_id":14,"sum":"19966.44"},"addresses":[{"id":126,"key":126,"name":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u6731\u5bb6\u575f5\u91cc5\u53f7","client_id":14},{"id":127,"key":127,"name":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u6731\u5bb6\u575f5\u91cc5\u53f7","client_id":14}],"contacts":[{"id":2608,"name":"\u8d75\u632f\u5f3a","email":"","pinyin_shortcut":"zzq","sex":"M","birth_date":null,"department":"\u6218\u7565\u90e8","job_position":"\u90e8\u957f","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1004,"created_at":"2019-05-16 21:20:34","updated_at":"2019-05-16 21:20:34","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhao","pinyin2":"zhen","pinyin3":"qiang","pinyin4":null,"namecut1":"\u8d75","namecut2":"\u632f","namecut3":"\u5f3a","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":null},{"id":19,"name":"\u674e\u5efa\u660e","email":"15801279719@163.com","pinyin_shortcut":"ljm","sex":"M","birth_date":null,"department":"\u6218\u7565\u90e8","job_position":"\u7ecf\u7406","mobile":null,"telephone":"010-83807000","client_id":14,"supplier_id":null,"created_by":1004,"created_at":"2017-02-08 17:38:11","updated_at":"2017-04-07 13:55:54","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"li","pinyin2":"jian","pinyin3":"ming","pinyin4":null,"namecut1":"\u674e","namecut2":"\u5efa","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","user_status":"1"},"mobiles":[{"id":32,"contact_id":19,"mobile":"15801279719","mp_open_id":null}],"contactKeyRoles":[{"id":134,"key":134,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"},{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":305,"name":"\u674e\u5927\u52c7","email":"","pinyin_shortcut":"ldy","sex":"M","birth_date":null,"department":"\u4fdd\u5bc6\u4e0e\u4fe1\u606f\u5316\u90e8","job_position":"","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1019,"created_at":"2017-03-08 23:06:08","updated_at":"2017-03-08 23:06:08","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"da","pinyin3":"yong","pinyin4":null,"namecut1":"\u674e","namecut2":"\u5927","namecut3":"\u52c7","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1019,"key":1019,"name":"\u90dd\u5c06\u4f1f","sex":"M","user_status":"-1"},"mobiles":[{"id":293,"contact_id":305,"mobile":"13681495828","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":304,"name":"\u674e\u8f89","email":"","pinyin_shortcut":"lh","sex":"M","birth_date":null,"department":"\u4fdd\u5bc6\u4e0e\u4fe1\u606f\u5316\u90e8","job_position":"","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1019,"created_at":"2017-03-08 23:05:02","updated_at":"2017-03-08 23:05:02","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"hui","pinyin3":null,"pinyin4":null,"namecut1":"\u674e","namecut2":"\u8f89","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1019,"key":1019,"name":"\u90dd\u5c06\u4f1f","sex":"M","user_status":"-1"},"mobiles":[{"id":292,"contact_id":304,"mobile":"18515509282","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":422,"name":"\u7aa6\u57f9\u57f9","email":"","pinyin_shortcut":"dpp","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1016,"created_at":"2017-03-22 19:05:59","updated_at":"2017-03-22 19:05:59","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"dou","pinyin2":"pei","pinyin3":"pei","pinyin4":null,"namecut1":"\u7aa6","namecut2":"\u57f9","namecut3":"\u57f9","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":[{"id":406,"contact_id":422,"mobile":"13693548460","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":1263,"name":"\u5eb7\u9662\u957f","email":"","pinyin_shortcut":"kyc","sex":"M","birth_date":null,"department":"\u8bbe\u8ba1\u9662","job_position":"\u9662\u957f","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1016,"created_at":"2017-11-08 15:16:40","updated_at":"2017-11-08 15:16:40","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"kang","pinyin2":"yuan","pinyin3":"chang","pinyin4":null,"namecut1":"\u5eb7","namecut2":"\u9662","namecut3":"\u957f","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":[{"id":786,"contact_id":1263,"mobile":"13691329111","mp_open_id":null}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":882,"name":"\u674e\u7ea2\u8273","email":"","pinyin_shortcut":"lhy","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1019,"created_at":"2017-06-22 12:12:51","updated_at":"2017-06-22 12:12:51","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"hong","pinyin3":"yan","pinyin4":null,"namecut1":"\u674e","namecut2":"\u7ea2","namecut3":"\u8273","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1019,"key":1019,"name":"\u90dd\u5c06\u4f1f","sex":"M","user_status":"-1"},"mobiles":[{"id":863,"contact_id":882,"mobile":"15810631713","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":1264,"name":"\u9b4f\u9662\u957f","email":"","pinyin_shortcut":"wyc","sex":"M","birth_date":null,"department":"\u8bbe\u8ba1\u9662","job_position":"\u526f\u9662\u957f","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1016,"created_at":"2017-11-08 15:17:52","updated_at":"2017-11-08 15:17:52","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wei","pinyin2":"yuan","pinyin3":"chang","pinyin4":null,"namecut1":"\u9b4f","namecut2":"\u9662","namecut3":"\u957f","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":[{"id":849,"contact_id":1264,"mobile":"13910697549","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":2318,"name":"\u5f20\u79cb\u7433","email":"","pinyin_shortcut":"zql","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1016,"created_at":"2018-10-10 11:35:53","updated_at":"2023-05-24 09:32:00","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"qiu","pinyin3":"lin","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u79cb","namecut3":"\u7433","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":[{"id":2296,"contact_id":2318,"mobile":"15699889087","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":477,"name":"\u5e9e\u91d1\u5f55","email":"","pinyin_shortcut":"pjl","sex":"M","birth_date":null,"department":"\u4fdd\u5bc6\u4e0e\u4fe1\u606f\u5316\u90e8","job_position":"\u4e66\u8bb0\u53ca\u90e8\u957f","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1004,"created_at":"2017-04-07 13:57:31","updated_at":"2017-04-07 13:57:50","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"pang","pinyin2":"jin","pinyin3":"lu","pinyin4":null,"namecut1":"\u5e9e","namecut2":"\u91d1","namecut3":"\u5f55","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","user_status":"1"},"mobiles":[{"id":457,"contact_id":477,"mobile":"15699889092","mp_open_id":null}],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":4661,"name":"\u6bb7\u5f6c\u6743","email":"","pinyin_shortcut":"ybq","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":5311,"created_at":"2023-06-29 14:07:30","updated_at":"2023-06-29 14:07:30","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"yin","pinyin2":"bin","pinyin3":"quan","pinyin4":null,"namecut1":"\u6bb7","namecut2":"\u5f6c","namecut3":"\u6743","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","user_status":"1"},"mobiles":[{"id":5471,"contact_id":4661,"mobile":"13717609058","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":4087,"name":"\u8d75\u4e9a\u8fd0","email":"","pinyin_shortcut":"zyy","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":14,"supplier_id":null,"created_by":1022,"created_at":"2022-08-09 12:32:15","updated_at":"2022-08-09 12:32:15","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhao","pinyin2":"ya","pinyin3":"yun","pinyin4":null,"namecut1":"\u8d75","namecut2":"\u4e9a","namecut3":"\u8fd0","namecut4":null,"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":[{"id":4907,"contact_id":4087,"mobile":"18618262591","mp_open_id":"oagch6cufXLa_bsHwC98k2YuDwrI"}],"contactKeyRoles":[],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":30,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","address1":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u6731\u5bb6\u575f5\u91cc5\u53f7","address2":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u957f\u8f9b\u5e97\u8857\u9053\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e30\u53f0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.185302,39.814434)","created_by":1004,"created_at":"2017-02-08 17:36:55","updated_at":"2023-11-28 12:59:38","state_id":110000,"city_id":110100,"region_id":110106,"country_id":1,"lng":"116.185302","lat":"39.814434"}],"unread":0,"lost_contact_days_display":"4\u4e2a\u6708\u524d","last_arrive_days_display":null,"bgcolor":"#EB13C3","overdue_display":"\u903e\u671f112\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f3435\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":2198,"name":"(\u8fc7\u5355)\u4e2d\u5b89\u5a01\u58eb(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"gdzawsbjkjyxgs","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":2732,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":5311,"main_contact":null,"created_by":5295,"created_at":"2022-06-15 10:21:31","updated_at":"2026-01-15 15:07:02","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2025-01-10 14:52:27","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"cooperated":true,"is_public":1,"lost_contact_days":"1148.4264976613","last_arrive_days":null,"last_contact":"2023-05-24 10:11:00","last_arrive":null,"score":"1","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":{"id":155,"key":155,"name":"\u5ba2\u6237\u4ecb\u7ecd"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","client_lock":false,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2198,"comment":3},"workingAddress":{"id":2732,"name":"(\u8fc7\u5355)\u4e2d\u5b89\u5a01\u58eb(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8","address1":null,"address2":"","state":null,"city":null,"region":null,"zip":"","country":"\u4e2d\u56fd","geolocation":"(0,0)","created_by":5295,"created_at":"2022-06-15 10:21:31","updated_at":"2022-06-15 10:21:31","state_id":null,"city_id":null,"region_id":null,"country_id":1,"lng":"0","lat":"0"},"unCloseCases":[],"workLogCount":{"client_id":2198,"count":2},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[],"contacts":[],"unreadComments":null,"fromContact":null,"workingAddresses":[],"unread":0,"lost_contact_days_display":"3\u5e74\u524d","last_arrive_days_display":null,"bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f1089\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f1477\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":28,"name":"\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhxtdxfwyxgs","description":"","corp_rep":"\u5f20\u5f6c","website":"www.chinaepay.com","capital":"3200","established_at":"2002-08-22","headcount":"\u516c\u53f8\u4eba\u657050\u4eba\uff0c\u4e1a\u52a1\u4eba\u54584-5\u4eba\uff0c\u4e5f\u6709\u7814\u53d1\u4eba\u5458\uff0c\u5bf9\u63a5\u6536\u8d39\u63a5\u53e3\u3002","reg_address":47,"working_address":662,"telephone":"010-64090030","fax":"","scale":"\u4f46\u662f\u975e\u8425\u5229\uff0c\u57f9\u8bad\u6536\u8d39","branch":"","purchase_scale_per_yr":"20","purchase_freq":"","company_nature":4,"client_class":null,"client_industry":10,"client_type":6,"sales_rep":null,"main_contact":null,"created_by":1006,"created_at":"2017-02-10 09:50:37","updated_at":"2024-02-19 14:47:23","main_business":"\u516c\u5171\u4e8b\u4e1a\u7f34\u8d39\u670d\u52a1","deleted":false,"capital_currency":"rmb","invoice_info":"91110108742305655X","logo":null,"en_name":"","pick_at":"2023-06-08 23:01:26","it_budget":"20\u4e07\uff1b\uff081\uff09\u5b98\u65b9\u7f51\u7ad9\u6258\u7ba1\u5728\u6df1\u4fe1\u670d\u7684\u6570\u636e\u4e2d\u5fc3\uff08\u56e0\u4e3a\u9700\u8981\u8fc7\u4e09\u7ea7\u7b49\u4fdd\uff09\n\uff082\uff09\u5176\u4ed6","deployment_mode":"\u672c\u5730\u90e8\u7f72","it_per_num":"3-4\u4eba","public_relations_difficulty":"","it_status":"\uff081\uff09\u4e1a\u52a1\u7f51\uff1a\u65e0\n\uff082\uff09\u529e\u516c\u7f51\uff1a\u603b\u5e26\u5bbd\uff1a140\u5146","decision_process":"\uff081\uff095\u4e07\u4ee5\u4e0b\uff1a\u4fe1\u606f\u5904\u5185\u90e8\u51b3\u7b56\u91c7\u8d2d\uff0c\u4f46\u9700\u8981\u4e09\u5bb6\u6bd4\u4ef7\u6587\u4ef6\n\uff082\uff095\u4e07-50\u4e07\uff1a\u4fe1\u606f\u5904\u9009\u578b\u4e0a\u62a5\u2014\u2014\u7ec4\u7ec7\u7ba1\u7406\u5904\u6bd4\u4ef7\u91c7\u8d2d\n\uff083\uff0950\u4e07\u4ee5\u4e0a\uff1a\u4fe1\u606f\u5904\u9009\u578b\u4e0a\u62a5\u2014\u2014\u7ec4\u7ec7\u7ba1\u7406\u5904\u62db\u6807\u91c7\u8d2d","coach":"\u65e0","competitor":"\u795e\u5dde\u6570\u7801","peers":"","supplier":"\u79fb\u52a8\u3001\u8054\u901a\u3001\u7535\u529b\u7f51","main_product":"1.\u7ec4\u7ec7\u79d1\u6280\u7c7b\u5b66\u672f\u6d3b\u52a8\n2.\uff08\u6838\u5fc3\uff09\u8003\u8bd5\uff0c\u57f9\u8bad\uff08\u673a\u5668\u4eba\u65b9\u9762\uff0c\u7269\u8054\u7f51\u65b9\u9762\u7b49\uff09\n3.\u671f\u520a\n\u4f18\u52bf\uff1a\u56fd\u5bb6\u6276\u6301","client_base_info_count":7,"client_key_info_count":12,"contact_count":4,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"cooperated":true,"is_public":0,"lost_contact_days":"972.885525439074","last_arrive_days":"1821.4077476613","last_contact":"2023-11-15 23:10:00","last_arrive":"2021-07-20 10:38:00+08","score":null,"clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":null,"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":null,"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"workingAddress":{"id":662,"name":"\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u5e02\u4e1c\u57ce\u533a\u9f99\u6f6d\u8857\u9053\u5e7f\u6e20\u5357\u6c34\u5173\u80e1\u540c","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e1c\u57ce\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.440149,39.891623)","created_by":5295,"created_at":"2017-09-08 15:59:59","updated_at":"2021-08-01 15:42:46","state_id":110000,"city_id":110100,"region_id":110101,"country_id":1,"lng":"116.440149","lat":"39.891623"},"unCloseCases":[],"workLogCount":{"client_id":28,"count":93},"caseCount":{"client_id":28,"count":36},"salesTimeCount":{"client_id":28,"hours":"0.633333333333333","times":1},"implementTimeCount":{"client_id":28,"sum":"132.833333333333","times":"34"},"presalesTimeCount":{"client_id":28,"sum":"2","times":"2"},"engineerTimeCount":{"client_id":28,"hours":"0.5","times":1},"reimbursementAmountSum":null,"addresses":[{"id":324,"key":324,"name":"\u5e7f\u6e20\u95e8\u5730\u94c1 \u5317\u4eac\u5e02\u4e1c\u57ce\u533a\u9f99\u6f6d\u8857\u9053\u5915\u7167\u5bfa\u88572\u53f7 \u5317\u4eac\u5e02\u7535\u4fe1\u5de5\u7a0b\u5c40 3\u5c42","client_id":28}],"contacts":[{"id":849,"name":"\u674e\u6b23\u6d0b","email":"","pinyin_shortcut":"lxy","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":28,"supplier_id":null,"created_by":1018,"created_at":"2017-06-16 13:24:45","updated_at":"2019-12-26 16:53:36","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"xin","pinyin3":"yang","pinyin4":null,"namecut1":"\u674e","namecut2":"\u6b23","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1018,"key":1018,"name":"\u7a0b\u946b\u658c","sex":"M","user_status":"-1"},"mobiles":[{"id":3260,"contact_id":849,"mobile":"15831640153","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":48,"name":"\u6797\u6770","email":"linj@chinaepay.com","pinyin_shortcut":"lj","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"","mobile":null,"telephone":"","client_id":28,"supplier_id":null,"created_by":1023,"created_at":"2017-02-13 08:59:53","updated_at":"2017-12-13 17:56:55","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":"oagch6S3SjFRwiucmqXkXDfNOBUc","pinyin1":"lin","pinyin2":"jie","pinyin3":null,"pinyin4":null,"namecut1":"\u6797","namecut2":"\u6770","namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":47,"contact_id":48,"mobile":"13911719666","mp_open_id":"oagch6S3SjFRwiucmqXkXDfNOBUc"}],"contactKeyRoles":[],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":534,"name":"\u674e\u946b\u3001\u674e\u6770\u8fce","email":"","pinyin_shortcut":"lxljy","sex":"M","birth_date":null,"department":"\u7814\u53d1\u90e8","job_position":"SQL","mobile":null,"telephone":"","client_id":28,"supplier_id":null,"created_by":1007,"created_at":"2017-04-28 19:06:55","updated_at":"2017-04-28 19:09:59","user_status":2,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"li","pinyin2":"xin","pinyin3":"li","pinyin4":"jie","namecut1":"\u674e","namecut2":"\u946b","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","user_status":"-1"},"mobiles":[{"id":517,"contact_id":534,"mobile":"","mp_open_id":null}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":535,"name":"\u9648\u9510 (\u6613\u4ed8\u901a)","email":"chenrui@chinaepay.com","pinyin_shortcut":"cryft","sex":"F","birth_date":null,"department":"\u6613\u4ed8\u901a","job_position":"\u5546\u52a1","mobile":null,"telephone":"010-64090061 ","client_id":28,"supplier_id":null,"created_by":1007,"created_at":"2017-04-28 19:09:31","updated_at":"2017-08-28 16:41:56","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"chen","pinyin2":"rui","pinyin3":"yi","pinyin4":"fu","namecut1":"\u9648","namecut2":"\u9510","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","user_status":"-1"},"mobiles":[{"id":541,"contact_id":535,"mobile":"13901054140 ","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":536,"name":"\u53f2\u79c0\u8f89","email":"","pinyin_shortcut":"sxh","sex":"F","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"CIO","mobile":null,"telephone":"64090008","client_id":28,"supplier_id":null,"created_by":1007,"created_at":"2017-04-28 19:11:34","updated_at":"2017-12-15 09:26:06","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"shi","pinyin2":"xiu","pinyin3":"hui","pinyin4":null,"namecut1":"\u53f2","namecut2":"\u79c0","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","user_status":"-1"},"mobiles":[{"id":550,"contact_id":536,"mobile":"13901222777","mp_open_id":null}],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"}],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":662,"name":"\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u5e02\u4e1c\u57ce\u533a\u9f99\u6f6d\u8857\u9053\u5e7f\u6e20\u5357\u6c34\u5173\u80e1\u540c","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e1c\u57ce\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.440149,39.891623)","created_by":5295,"created_at":"2017-09-08 15:59:59","updated_at":"2021-08-01 15:42:46","state_id":110000,"city_id":110100,"region_id":110101,"country_id":1,"lng":"116.440149","lat":"39.891623"}],"unread":0,"lost_contact_days_display":"2\u5e74\u524d","last_arrive_days_display":"4\u5e74\u524d","bgcolor":"gray","overdue_display":"","last_arrive_overdue_display":"","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":true,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":481,"name":"\u745e\u65af\u5eb7\u8fbe\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"rskdkjfzgfyxgs","description":"\u745e\u65af\u5eb7\u8fbe\n\t\u7ec4\u7ec7\u67b6\u6784\n\t\t\u526f\u603b\n\t\t\t\u6280\u672f\u90e8\u7ecf\u7406\uff1a\u6768\u70e8\n\t\t\t\twindows\uff1a\u8881\u6797\n\t\t\t\tlinux\uff1a\u6768\u4e49\u8fb0\n\t\t\t\u91c7\u8d2d\u90e8\n\t\u7ade\u4e89\u5bf9\u624b\n\t\t\u6606\u4ed1\u8054\u901a\n\tIT\u73b0\u72b6\n\t\t60\u53f0DELL\u670d\u52a1\u5668\uff0c\u81ea\u5df1\u7684\u7f51\u7edc\u8bbe\u5907\n\n\u4e0d\u9700\u8981\uff0c\u5b89\u5168\u7528\u7684360","corp_rep":"\u9ad8\u78ca","website":"http:\/\/www.raisecom.com","capital":"42105","established_at":"1999-06-08","headcount":null,"reg_address":637,"working_address":648,"telephone":"010-82884499","fax":"","scale":"","branch":"","purchase_scale_per_yr":null,"purchase_freq":"","company_nature":5,"client_class":null,"client_industry":5,"client_type":1,"sales_rep":null,"main_contact":null,"created_by":1005,"created_at":"2017-08-25 16:00:13","updated_at":"2023-10-20 22:50:52","main_business":"\u8ba1\u7b97\u673a\u7cfb\u7edf\u96c6\u6210\uff1b\u5236\u9020\u901a\u8baf\u8bbe\u5907","deleted":false,"capital_currency":"rmb","invoice_info":"911101087003918234","logo":null,"en_name":"","pick_at":"","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":7,"client_key_info_count":1,"contact_count":3,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"cooperated":false,"is_public":0,"lost_contact_days":"999.12858099463","last_arrive_days":null,"last_contact":"2023-10-20 17:20:00","last_arrive":null,"score":null,"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":null,"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"},"companyNature":{"id":5,"key":5,"name":"\u7cfb\u7edf\u96c6\u6210\u5546"},"salesRep":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":481,"comment":1},"workingAddress":{"id":648,"name":"\u745e\u65af\u5eb7\u8fbe\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","address1":"\u897f\u5317\u65fa\u4e1c\u8def10\u53f7\u9662\u4e1c\u533a11\u53f7\u697c\u4e00\u81f3\u4e94\u5c42","address2":"","state":"\u5317\u4eac","city":"\u6d77\u6dc0\u533a","region":null,"zip":"100094","country":"\u4e2d\u56fd","geolocation":"(0,0)","created_by":5096,"created_at":"2017-09-08 11:23:44","updated_at":"2020-12-29 14:47:00","state_id":110000,"city_id":110100,"region_id":null,"country_id":1,"lng":"0","lat":"0"},"unCloseCases":[],"workLogCount":{"client_id":481,"count":14},"caseCount":{"client_id":481,"count":2},"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":{"client_id":481,"sum":"4","times":"2"},"engineerTimeCount":{"client_id":481,"hours":"2.25","times":1},"reimbursementAmountSum":null,"addresses":[{"id":307,"key":307,"name":"\u897f\u5317\u65fa\u4e1c\u8def10\u53f7\u9662\u4e1c\u533a11\u53f7\u697c\u4e00\u81f3\u4e94\u5c42","client_id":481},{"id":308,"key":308,"name":"\u897f\u5317\u65fa\u4e1c\u8def10\u53f7\u9662\u4e1c\u533a11\u53f7\u697c\u4e00\u81f3\u4e94\u5c42","client_id":481}],"contacts":[{"id":1070,"name":"\u6768\u4e49\u8fb0","email":"yangyichen@raisecom.com","pinyin_shortcut":"yyc","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u5316","job_position":"\u6280\u672f\uff0dlinux","mobile":null,"telephone":"","client_id":481,"supplier_id":null,"created_by":1005,"created_at":"2017-08-25 16:00:30","updated_at":"2017-08-29 20:57:40","user_status":2,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"yang","pinyin2":"yi","pinyin3":"chen","pinyin4":null,"namecut1":"\u6768","namecut2":"\u4e49","namecut3":null,"namecut4":null,"is_mp_bind":null,"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":1069,"contact_id":1070,"mobile":"13311380317","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1074,"name":"\u6768\u70e8","email":"","pinyin_shortcut":"yy","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u5316","job_position":"\u6280\u672f\u7ecf\u7406","mobile":null,"telephone":"","client_id":481,"supplier_id":null,"created_by":1005,"created_at":"2017-08-29 20:59:01","updated_at":"2017-08-29 20:59:01","user_status":2,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"yang","pinyin2":"ye","pinyin3":null,"pinyin4":null,"namecut1":"\u6768","namecut2":"\u70e8","namecut3":null,"namecut4":null,"is_mp_bind":null,"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":1070,"contact_id":1074,"mobile":"13810457950","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1075,"name":"\u8881\u6797","email":"","pinyin_shortcut":"yl","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u5316","job_position":"\u6280\u672f\uff0dwindows","mobile":null,"telephone":"","client_id":481,"supplier_id":null,"created_by":1005,"created_at":"2017-08-29 21:02:10","updated_at":"2017-08-29 21:02:10","user_status":2,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"yuan","pinyin2":"lin","pinyin3":null,"pinyin4":null,"namecut1":"\u8881","namecut2":"\u6797","namecut3":null,"namecut4":null,"is_mp_bind":null,"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":1071,"contact_id":1075,"mobile":"15901064619","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}}],"unreadComments":null,"fromContact":null,"workingAddresses":[],"unread":0,"lost_contact_days_display":"2\u5e74\u524d","last_arrive_days_display":null,"bgcolor":"gray","overdue_display":"","last_arrive_overdue_display":"","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":true,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true}],"pagenation":{"totalcount":8,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.127","ua":"jinchangxiao\/2.3.158 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-07-15 20:25:09', 386541056) RETURNING "id"

[+] Explain