ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689697f9285fe: GET https://beta.jinchangxiao.com/vue/analysis/sandbox at 2025-08-09 08:36:09 am by 114.119.132.114

Database Queries

总计29条数据
TimeDurationTypeQuery
  
08:36:09.1692.4 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
08:36:09.1721.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
08:36:09.1750.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"

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

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

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

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

[+] Explain
08:36:09.21212.9 msSELECTSELECT COUNT(*) FROM (SELECT c.id, c.name, c.client_class, 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, max(sl.end_at) as last_contact, c.sales_rep FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep 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 WHERE ("sales_rep"=1001) AND ("sales_rep"=1001) AND ("deleted"=FALSE) GROUP BY "c"."id", "cooperated" ORDER BY lost_contact_days ASC NULLS LAST, "c"."created_at" DESC) "c"

[+] Explain
08:36:09.2255.9 msSELECTSELECT c.id, c.name, c.client_class, 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, max(sl.end_at) as last_contact, c.sales_rep FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep 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 WHERE ("sales_rep"=1001) AND ("sales_rep"=1001) AND ("deleted"=FALSE) GROUP BY "c"."id", "cooperated" ORDER BY lost_contact_days ASC NULLS LAST, "c"."created_at" DESC LIMIT 30

[+] Explain
08:36:09.2320.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
08:36:09.2320.5 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
08:36:09.2334.5 msSELECTSELECT "id", "project_status", "project_progress", "created_by", "client_id", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "client_id" IN (3081, 1933, 2616, 2538, 982, 146, 1661, 3372, 3364, 3344, 3334, 3327, 3311, 3304, 3301, 3296, 3286, 3278, 3009, 2845, 2838, 2836, 2803, 2800, 2798, 2719, 2718, 2589, 2582, 2553)

[+] Explain
08:36:09.2390.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (5, 9, 6, 2, 49, 7, 10, 4, 8)

[+] Explain
08:36:09.2391.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3679, 3514, 3544, 3591, 3577, 3568, 3589, 3216, 3644, 3652, 3660, 3661, 3633, 3686, 3714, 3723, 3767, 1983, 3764, 3744, 3752, 3786, 3872, 3857, 3890, 3751, 3281, 3372, 3309, 3371, 3251, 3274, 2079, 2080, 1791, 88, 1929, 1963, 2504, 2508, 1111, 1938, 3424, 3441, 3515, 3503, 3467, 3513, 3201, 3653, 3813, 3927, 1018, 2422)

[+] Explain
08:36:09.2410.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (97, 100, 159, 45, 94, 165, 179, 142, 5, 183, 187, 136, 213, 210, 212, 140, 137, 1, 175, 154, 166, 184, 189, 226, 232, 181, 2, 8, 172, 174, 215, 185, 191, 6, 167, 160, 228, 128, 205, 204, 171, 196, 304, 164, 153, 197, 199, 307, 203, 2100000000, 194, 192, 168, 317, 309, 337, 139, 200, 135, 319, 107, 340, 182, 348, 265, 129, 349, 354, 356, 359, 366, 369, 372, 377)) ORDER BY "sort"

[+] Explain
08:36:09.2421.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3679, 3514, 3544, 3591, 3577, 3568, 3589, 3216, 3644, 3652, 3660, 3661, 3633, 3686, 3714, 3723, 3767, 1983, 3764, 3744, 3752, 3786, 3872, 3857, 3890, 3751, 3281, 3372, 3309, 3371, 3251, 3274, 2079, 2080, 1791, 88, 1929, 1963, 2504, 2508, 1111, 1938, 3424, 3441, 3515, 3503, 3467, 3513, 3201, 3653, 3813, 3927, 1018, 2422)

[+] Explain
08:36:09.2440.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (97, 100, 159, 45, 94, 165, 179, 142, 5, 183, 187, 136, 213, 210, 212, 140, 137, 1, 175, 154, 166, 184, 189, 226, 232, 181, 2, 8, 172, 174, 215, 185, 191, 6, 167, 160, 228, 128, 205, 204, 171, 196, 304, 164, 153, 197, 199, 307, 203, 2100000000, 194, 192, 168, 317, 309, 337, 139, 200, 135, 319, 107, 340, 182, 348, 265, 129, 349, 354, 356, 359, 366, 369, 372, 377)) ORDER BY "sort"

[+] Explain
08:36:09.2451.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3679, 3514, 3544, 3591, 3577, 3568, 3589, 3216, 3644, 3652, 3660, 3661, 3633, 3686, 3714, 3723, 3767, 1983, 3764, 3744, 3752, 3786, 3872, 3857, 3890, 3751, 3281, 3372, 3309, 3371, 3251, 3274, 2079, 2080, 1791, 88, 1929, 1963, 2504, 2508, 1111, 1938, 3424, 3441, 3515, 3503, 3467, 3513, 3201, 3653, 3813, 3927, 1018, 2422)

[+] Explain
08:36:09.2470.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (97, 100, 159, 45, 94, 165, 179, 142, 5, 183, 187, 136, 213, 210, 212, 140, 137, 1, 175, 154, 166, 184, 189, 226, 232, 181, 2, 8, 172, 174, 215, 185, 191, 6, 167, 160, 228, 128, 205, 204, 171, 196, 304, 164, 153, 197, 199, 307, 203, 2100000000, 194, 192, 168, 317, 309, 337, 139, 200, 135, 319, 107, 340, 182, 348, 265, 129, 349, 354, 356, 359, 366, 369, 372, 377)) ORDER BY "sort"

[+] Explain
08:36:09.2470.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id" IN (3679, 3514, 3544, 3591, 3577, 3568, 3589, 3216, 3644, 3652, 3660, 3661, 3633, 3686, 3714, 3723, 3767, 1983, 3764, 3744, 3752, 3786, 3872, 3857, 3890, 3751, 3281, 3372, 3309, 3371, 3251, 3274, 2079, 2080, 1791, 88, 1929, 1963, 2504, 2508, 1111, 1938, 3424, 3441, 3515, 3503, 3467, 3513, 3201, 3653, 3813, 3927, 1018, 2422)

[+] Explain
08:36:09.2480.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1020, 1023, 5085, 1016, 5247, 5074, 1015, 1022)

[+] Explain
08:36:09.2490.3 msSELECTSELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 5)

[+] Explain
08:36:09.2490.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5300, 1003, 1005, 5295)

[+] Explain
08:36:09.2501.4 msSELECTSELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3679, 3514, 3544, 3591, 3577, 3568, 3589, 3216, 3644, 3652, 3660, 3661, 3633, 3686, 3714, 3723, 3767, 1983, 3764, 3744, 3752, 3786, 3872, 3857, 3890, 3751, 3281, 3372, 3309, 3371, 3251, 3274, 2079, 2080, 1791, 88, 1929, 1963, 2504, 2508, 1111, 1938, 3424, 3441, 3515, 3503, 3467, 3513, 3201, 3653, 3813, 3927, 1018, 2422)

[+] Explain
08:36:09.2523.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_product_types" WHERE "client_id" IN (3081, 1933, 2616, 2538, 982, 146, 1661, 3372, 3364, 3344, 3334, 3327, 3311, 3304, 3301, 3296, 3286, 3278, 3009, 2845, 2838, 2836, 2803, 2800, 2798, 2719, 2718, 2589, 2582, 2553)

[+] Explain
08:36:09.2550.3 msSELECTSELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 1, 47, 80)

[+] Explain
08:36:09.2583.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-09')

[+] Explain
08:36:09.2620.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=20, "last_visit_at"='now()' WHERE "id"=54996

[+] Explain
08:36:09.2631.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sandbox', '[]', '{"code":2000,"result":{"labels":[{"id":"client_name","key":"client_name","name":"\u5ba2\u6237\u540d\u79f0"},{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},{"id":88,"key":88,"name":"\u79c1\u6709\u4e91"},{"id":8,"key":8,"name":"\u4e91\u684c\u9762"},{"id":7,"key":7,"name":"\u8f6f\u4ef6"},{"id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},{"id":69,"key":69,"name":"\u5907\u4efd"},{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},{"id":12,"key":12,"name":"\u7b14\u8bb0\u672c"},{"id":13,"key":13,"name":"\u6253\u5370\u673a"},{"id":14,"key":14,"name":"UPS"},{"id":16,"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1"},{"id":17,"key":17,"name":"\u5de5\u63a7\u673a"},{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},{"id":20,"key":20,"name":"\u529e\u516c\u8bbe\u5907"},{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},{"id":22,"key":22,"name":"\u670d\u52a1"},{"id":23,"key":23,"name":"\u793c\u54c1"},{"id":75,"key":75,"name":"\u8f6f\u4ef6\u5f00\u53d1"}],"list":[{"id":3081,"name":"\u91d1\u98ce\u79d1\u521b\u98ce\u7535\u8bbe\u5907\u6709\u9650\u516c\u53f8(CAE)-\uff08\u91cd\u590d\u5ba2\u6237\uff09","client_class":43,"cooperated":false,"lost_contact_days":"365.670940112454","last_contact":"2024-08-08 16:30:00","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"1\u5e74\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8\uff08\u91cd\u590d\u5ba2\u6237\uff09","client_class":43,"cooperated":true,"lost_contact_days":"480.683440112454","last_contact":"2024-04-15 16:12:00","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"1\u5e74\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":1}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","client_class":43,"cooperated":true,"lost_contact_days":"532.944551223565","last_contact":"2024-02-23 09:56:00","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"1\u5e74\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[{"id":5,"status":0,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2538,"name":"\uff08\u8fc7\u5355\uff09\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"795.81260677912","last_contact":"2023-06-05 13:06:00","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"2\u5e74\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[{"id":5,"status":0,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"cooperated":true,"lost_contact_days":"1033.77441233468","last_contact":"2022-10-10 14:01:00","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"lost_contact_days_display":"2\u5e74\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"clientProductType3":{"id":3,"color":"#d3e0ff","value":"{\"name\":\"\",\"time\":\"\",\"content\":\"\\u65e0\"}"},"clientProductType85":{"id":85,"color":"#d3e0ff","value":"{\"name\":\"\\u5415\\u5174\\u5143\",\"time\":\"2020-03-28\",\"content\":\"\\u65e0 \"}"},"clientProductType86":{"id":86,"color":"#d3e0ff","value":"{\"name\":\"\\u5218\\u4eba\\u8bda\",\"time\":\"2022-06-30\",\"content\":\"\\u5ba2\\u6237\\u65e0\\u9884\\u7b97\"}"},"clientProductType87":{"id":87,"color":"#d3e0ff","value":"{\"name\":\"\\u5415\\u5174\\u5143\",\"time\":\"2020-03-28\",\"content\":\"\\u65e0 \"}"},"clientProductType22":{"id":22,"color":"#d3e0ff","value":"{\"name\":\"\",\"time\":\"\",\"content\":\"\\u65e0\"}"},"clientProductType91":{"id":91,"color":"#d3e0ff","value":"{\"name\":\"\",\"time\":\"\",\"content\":\"\\u6709\"}"},"clientProductType69":{"id":69,"color":"#d3e0ff","value":"{\"name\":\"\",\"time\":\"\",\"content\":\"\\u65e0\"}"},"can_edit":true},{"id":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-\uff08\u91cd\u590d\u5ba2\u6237\uff09","client_class":43,"cooperated":true,"lost_contact_days":"1072.95010677912","last_contact":"2022-09-01 09:48:00","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"2\u5e74\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"1427.87996789023","last_contact":"2021-09-11 11:29:00","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u5e74\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[{"id":4,"status":0,"count":1}],"projectProductType5":[{"id":5,"status":0,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[{"id":5,"status":0,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3344,"name":"\u5317\u4eac\u4e2d\u795e\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":43,"cooperated":false,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[{"id":5,"status":5,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[{"id":7,"status":0,"count":1}],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[{"id":5,"status":0,"count":2}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":1}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[{"id":5,"status":0,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3296,"name":"\u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[{"id":4,"status":3,"count":1}],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"clientProductType85":{"id":85,"color":"#d3e0ff","value":"{\"name\":\"\\u5218\\u4eba\\u8bda\",\"time\":\"2024-07-08\",\"content\":\"\\u8ba1\\u5212\"}"},"can_edit":true},{"id":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3009,"name":"\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":2}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[{"id":5,"status":0,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2838,"name":"\u8d5b\u514b\u8c31\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2836,"name":"\u5317\u4eac\u4e2d\u8bda\u7f51\u5b89\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","client_class":43,"cooperated":false,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2800,"name":"\u5ddd\u5d0e\u91cd\u5de5\uff08\u5927\u9023\uff09\u79d1\u6280\u958b\u767a\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":false,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2798,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2719,"name":"\u91d1\u9510\u540c\u521b\uff08\u5317\u4eac\uff09\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":47,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2718,"name":"\u4e0a\u6d77\u745e\u6280\u8ba1\u7b97\u673a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","client_class":80,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2589,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2582,"name":"\u4e2d\u56fd\u80fd\u6e90\u4f20\u5a92\u96c6\u56e2\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"","last_contact":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[{"id":5,"status":0,"count":1},{"id":5,"status":3,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true}],"pagenation":{"totalcount":57,"thispage":1,"pagesize":30}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-09 08:36:09') RETURNING "id"

[+] Explain