ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6897b29d8a2c8: GET https://beta.jinchangxiao.com/vue/dashboard/uncontact at 2025-08-10 04:42:05 am by 114.119.132.114

Performance Profiling

Total processing time: 97 ms; Peak memory: 5.228 MB. Show Profiling Timeline

总计18条数据
TimeDurationCategoryInfo
  
04:42:05.57829.3 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, sub.lost_contact_days, sub.last_contact FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT sub_c.id, extract(epoch FROM (CURRENT_TIMESTAMP - max( sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact FROM "a57be577deb434"."tbl_clients" "sub_c" LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.client_id = sub_c.id WHERE ("sub_c"."sales_rep"=1001) AND ("sub_c"."deleted"=FALSE) GROUP BY "sub_c"."id") "sub" ON c.id = sub.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON c.client_class = cc.id WHERE (("c"."sales_rep"=1001) AND ("c"."deleted"=FALSE)) AND ((sub.lost_contact_days >= cc.notice_days - 1) OR (sub.lost_contact_days IS NULL)) ORDER BY "last_contact", "c"."created_at" DESC) "c"
04:42:05.62012.6 msyii\db\Command::queryselect 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
04:42:05.6076.5 msyii\db\Command::querySELECT c.*, sub.lost_contact_days, sub.last_contact FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT sub_c.id, extract(epoch FROM (CURRENT_TIMESTAMP - max( sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact FROM "a57be577deb434"."tbl_clients" "sub_c" LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.client_id = sub_c.id WHERE ("sub_c"."sales_rep"=1001) AND ("sub_c"."deleted"=FALSE) GROUP BY "sub_c"."id") "sub" ON c.id = sub.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON c.client_class = cc.id WHERE (("c"."sales_rep"=1001) AND ("c"."deleted"=FALSE)) AND ((sub.lost_contact_days >= cc.notice_days - 1) OR (sub.lost_contact_days IS NULL)) ORDER BY "last_contact", "c"."created_at" DESC LIMIT 20
04:42:05.6145.7 msyii\db\Command::querySELECT 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;
04:42:05.6445.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1661, 146, 982, 2538, 2616, 1933, 3081, 3372, 3364, 3344, 3334, 3327, 3311, 3304, 3301, 3296, 3286, 3278, 3009, 2845)
04:42:05.6394.6 msyii\db\Command::querySELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id" IN (1661, 146, 982, 2538, 2616, 1933, 3081, 3372, 3364, 3344, 3334, 3327, 3311, 3304, 3301, 3296, 3286, 3278, 3009, 2845))
04:42:05.6563.7 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/dashboard/uncontact', '[]', '{"code":2000,"result":{"list":[{"id":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjwxykjyxgs","description":"\u6881\u5b87\u4ecb\u7ecd","corp_rep":"\u674e\u4e1c","website":"http:\/\/www.netcell.cn","capital":"500","established_at":"2005-11-18","headcount":"","reg_address":null,"working_address":null,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":null,"purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1011,"created_at":"2020-06-23 16:16:09","updated_at":"2025-04-21 17:02:54","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":2,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":true,"from_contact":null,"lost_contact_days":"1428.71742601921","last_contact":"2021-09-11 11:29:00","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"lost_contact_days_display":"3\u5e74\u524d","can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f1369\u5929\u672a\u8054\u7cfb","bgcolor":"#1EE6DC"},{"id":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-\uff08\u91cd\u590d\u5ba2\u6237\uff09","abbr":null,"pinyin_shortcut":"smctjzzyxgscfkh","description":"smc\u5206\u516c\u53f8","corp_rep":"\u8d75\u5f64","website":"","capital":"200000.000000","established_at":"2016-04-18","headcount":"500","reg_address":null,"working_address":null,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"20","purchase_freq":"3","company_nature":6,"client_class":43,"client_industry":5,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1003,"created_at":"2017-03-06 15:44:05","updated_at":"2024-10-30 09:56:39","main_business":"\u6c14\u538b\u52a8\u529b\u673a\u68b0\u53ca\u90e8\u4ef6\u3001\u5de5\u4e1a\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u53ca\u90e8\u4ef6\u7684\u5236\u9020\u3001","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-10-30 09:56:39","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":3,"client_key_info_count":2,"contact_count":1,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"lost_contact_days":"1073.7875649081","last_contact":"2022-09-01 09:48:00","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":6,"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1},"lost_contact_days_display":"2\u5e74\u524d","can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f1014\u5929\u672a\u8054\u7cfb","bgcolor":"#1EE6DC"},{"id":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","abbr":null,"pinyin_shortcut":"zgxxaqyjs","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":null,"telephone":"01062305540","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":3,"client_class":1,"client_industry":4,"client_type":6,"sales_rep":1001,"main_contact":null,"created_by":5076,"created_at":"2018-05-16 18:55:46","updated_at":"2024-07-09 20:50:26","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-06-27 14:45:57","it_budget":"800","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":2,"client_key_info_count":1,"contact_count":62,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"lost_contact_days":"1034.61187046366","last_contact":"2022-10-10 14:01:00","clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"companyNature":{"id":3,"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},"clientIndustry":{"id":4,"key":4,"name":"\u901a\u4fe1"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":5076,"key":5076,"name":"\u5b8b\u6d77\u7389","sex":"F","department_id":1},"lost_contact_days_display":"2\u5e74\u524d","can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f1025\u5929\u672a\u8054\u7cfb","bgcolor":"#E89F0E"},{"id":2538,"name":"\uff08\u8fc7\u5355\uff09\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":"2025-01-17 10:09:06","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,"lost_contact_days":"796.650064908102","last_contact":"2023-06-05 13:06:00","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":{"id":156,"key":156,"name":"\u5382\u5546\u4ecb\u7ecd"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"lost_contact_days_display":"2\u5e74\u524d","can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f737\u5929\u672a\u8054\u7cfb","bgcolor":"#1EE6DC"},{"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":"2025-02-20 09:08:25","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":1,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"lost_contact_days":"533.782009352546","last_contact":"2024-02-23 09:56:00","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1},"lost_contact_days_display":"1\u5e74\u524d","can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f474\u5929\u672a\u8054\u7cfb","bgcolor":"#1EE6DC"},{"id":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8\uff08\u91cd\u590d\u5ba2\u6237\uff09","abbr":null,"pinyin_shortcut":"SMCbjzzyxgscfkh","description":"smc\u4e2d\u56fd\u516c\u53f8\u5317\u4eac\u5206\u5382","corp_rep":"\u8d75\u5f64","website":"","capital":null,"established_at":"2000-12-31","headcount":"3000","reg_address":null,"working_address":2303,"telephone":"80480101","fax":"","scale":"10","branch":"","purchase_scale_per_yr":null,"purchase_freq":"","company_nature":6,"client_class":43,"client_industry":5,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1003,"created_at":"2020-09-29 09:58:29","updated_at":"2025-01-22 15:00:54","main_business":"\u5236\u9020\u5de5\u4e1a\u81ea\u52a8\u5316\u5143\u4ef6","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-10-28 17:59:19","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":3,"contact_count":3,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":6,"is_overdue_remind":false,"from_contact":null,"lost_contact_days":"481.520898241435","last_contact":"2024-04-15 16:12:00","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":6,"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":{"id":155,"key":155,"name":"\u5ba2\u6237\u4ecb\u7ecd"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1},"lost_contact_days_display":"1\u5e74\u524d","can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f422\u5929\u672a\u8054\u7cfb","bgcolor":"#1EE6DC"},{"id":3081,"name":"\u91d1\u98ce\u79d1\u521b\u98ce\u7535\u8bbe\u5907\u6709\u9650\u516c\u53f8(CAE)-\uff08\u91cd\u590d\u5ba2\u6237\uff09","abbr":null,"pinyin_shortcut":"jfkcfdsbyxgsCAEcfkh","description":"\u6240\u5c5e\u884c\u4e1a\u6c7d\u8f66\/\u667a\u80fd\u5236\u9020\u516c\u53f8\u4ea7\u54c1\u98ce\u7535\u8bbe\u5907\u3001\u667a\u6167\u50a8\u80fd\u5355\u5143\u5ba2\u6237\u7fa4\u98ce\u7535\u8fd0\u8425\u5546\u7ade\u4e89\u4f18\u52bf\u7ade\u4e89\u5bf9\u624b\uff08\u542f\u4fe1\u5b9d\u7ade\u54c1\u4fe1\u606f\u660e\u786e\u6807\u660e\uff09\u745e\u80fd\u5317\u65b9\u98ce\u7535\u8bbe\u5907\u6709\u9650\u516c\u53f8\u516c\u53f8\u4eba\u65701210\u79d1\u7814\u56e2\u961f\uff08\u542f\u4fe1\u5b9d\u660e\u786e\u6807\u660e\uff0977\u4e13\u5229\uff08\u542f\u4fe1\u5b9d\u660e\u786e\u6807\u660e\uff092814","corp_rep":"","website":"https:\/\/www.goldwind.com\/cn\/windpower\/solution-onshore\/","capital":null,"established_at":"2006-02-13","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":57,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2024-05-10 18:01:54","updated_at":"2024-10-28 17:59:52","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-10-28 17:59:52","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":2,"client_key_info_count":0,"contact_count":6,"visit_count":2,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":5750,"lost_contact_days":"366.508398241435","last_contact":"2024-08-08 16:30:00","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":57,"key":57,"name":"EDA\/CAE"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"lost_contact_days_display":"1\u5e74\u524d","can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f307\u5929\u672a\u8054\u7cfb","bgcolor":"#1EE6DC"},{"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","abbr":null,"pinyin_shortcut":"hnsdgysmjjglhhqyyxhh","description":"","corp_rep":"\u97e9\u5149\u52c7","website":"","capital":"1000","established_at":"2020-08-24","headcount":null,"reg_address":null,"working_address":null,"telephone":"18681551295","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":10,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1011,"created_at":"2025-06-13 14:44:58","updated_at":"2025-07-28 10:11:01","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u540d\u79f0\uff1a\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09\n\u7a0e\u53f7\uff1a91460000MA5TMJQA1N\n\u5355\u4f4d\u5730\u5740\uff1a\u6d77\u5357\u7701\u4e09\u4e9a\u5e02\u6d77\u68e0\u6e7e\u533a\u4e9a\u592a\u91d1\u878d\u5c0f\u9547A1\u533a2-8\u53f7\n\u7535\u8bdd\uff1a18681551295\n\u5f00\u6237\u94f6\u884c\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u4e09\u4e9a\u6d77\u68e0\u6e7e\u652f\u884c\n\u94f6\u884c\u8d26\u6237\uff1a2201085709100046924\n\u6536\u7968\u90ae\u7bb1\uff1a657288788@qq.com","logo":null,"en_name":"","pick_at":"2025-06-13 14:44:58","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":6,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":3,"is_overdue_remind":false,"from_contact":4640,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":""},{"id":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","abbr":null,"pinyin_shortcut":"bjjtsjxxjsyxgsgd","description":"","corp_rep":"\u738b\u4e95\u83b2","website":"","capital":"500","established_at":"2019-04-11","headcount":null,"reg_address":null,"working_address":null,"telephone":"010-82723450","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1011,"created_at":"2025-05-14 16:30:29","updated_at":"2025-06-17 11:23:08","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\n\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4e09\u73af\u4e2d\u8def44\u53f757\u5e621\u5c42119\n\u7535\u8bdd\uff1a13269110935\n\u7a0e\u53f7\uff1a91110108MA004NJB20\n\u5f00\u6237\u884c\uff1a\u5174\u4e1a\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u4e0a\u5730\u652f\u884c\n\u8d26\u53f7\uff1a321090100100334313","logo":null,"en_name":"","pick_at":"2025-05-14 16:30:29","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":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":5957,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f28\u5929\u672a\u8054\u7cfb"},{"id":3344,"name":"\u5317\u4eac\u4e2d\u795e\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","abbr":null,"pinyin_shortcut":"bjzswdkjyxgsgd","description":"","corp_rep":"\u738b\u5409","website":"https:\/\/www.ajsafe.com","capital":"400","established_at":"2019-07-05","headcount":null,"reg_address":null,"working_address":null,"telephone":"010-62924655","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1011,"created_at":"2025-03-27 14:39:34","updated_at":"2025-04-15 09:48:56","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u4f01\u4e1a\u540d\u79f0\uff1a\t\u5317\u4eac\u4e2d\u795e\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u4f01\u4e1a\u7a0e\u53f7\uff1a\t91110114MA01L8R14J\n\u4f01\u4e1a\u5730\u5740\uff1a\t\u5317\u4eac\u5e02\u660c\u5e73\u533a\u666f\u5174\u885725\u53f7\u96621\u53f7\u697c2\u5c42207\n\u7535\u8bdd\u53f7\u7801\uff1a\t010-62924655\n\u5f00\u6237\u94f6\u884c\uff1a\t\u5174\u4e1a\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u9f99\u57df\u652f\u884c\n\u94f6\u884c\u8d26\u6237\uff1a\t321720100100002656","logo":null,"en_name":"","pick_at":"2025-04-02 11:42:02","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":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":5957,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f76\u5929\u672a\u8054\u7cfb"},{"id":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":null,"pinyin_shortcut":"bjrygdkjyxgsgd","description":"","corp_rep":"\u67f3\u98de","website":"www.rongyee-oe.com","capital":"5000","established_at":"2009-03-27","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":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1011,"created_at":"2025-02-28 16:18:15","updated_at":"2025-03-31 15:45:04","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a \u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101116876451701\n\u5730\u5740: \u5317\u4eac\u5e02\u987a\u4e49\u533a\u6f9c\u897f\u56ed\u56db\u533a26\u53f7\u697c2\u5c42238\u5ba4\uff08\u79d1\u6280\u521b\u65b0\u529f\u80fd\u533a\uff09\n\u7535\u8bdd\u53f7\u7801\uff1a13126522178","logo":null,"en_name":"","pick_at":"2025-02-28 16:18:15","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":6,"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":5980,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f103\u5929\u672a\u8054\u7cfb"},{"id":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","abbr":null,"pinyin_shortcut":"xlzbqdgcjsyxgsgd","description":"","corp_rep":"\u738b\u8c26\u68ee","website":"","capital":"500","established_at":"2014-12-30","headcount":null,"reg_address":null,"working_address":null,"telephone":"0532-68069137","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1011,"created_at":"2024-12-17 16:37:43","updated_at":"2025-04-22 12:20:17","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u4fe1\u94f6\u884c\u9752\u5c9b\u52b2\u677e\u8def\u652f\u884c \n\u884c\u53f7\uff1a3024 5203 6174\n\u8d26\u53f7\uff1a7361 4101 8260 0067 385\n\u6ce8\u518c\u5730\u5740\uff1a\u9752\u5c9b\u5e02\u5d02\u5c71\u533a\u682a\u6d32\u8def69\u53f7\u9ad8\u65b0\u56ed\u4e09\u671f7\u53f7 \n\u7a0e\u52a1\u767b\u8bb0\u8bc1\u53f7\uff1a91370212325941917P\n\u7535\u8bdd\uff1a0532-68069137","logo":null,"en_name":"","pick_at":"2024-12-17 16:37:43","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":6,"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":1262,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f176\u5929\u672a\u8054\u7cfb"},{"id":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhcykjyxgs","description":"","corp_rep":"\u6d2a\u79d1","website":"http:\/\/www.bjhdd.com","capital":"100","established_at":"2009-11-04","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":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2024-10-16 11:09:32","updated_at":"2024-11-29 13:52:19","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-10-16 11:09:32","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":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":4838,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f238\u5929\u672a\u8054\u7cfb"},{"id":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","abbr":null,"pinyin_shortcut":"bjyckjyxgsgd","description":"","corp_rep":"\u5409\u5a1f","website":"","capital":"500","established_at":"2020-06-03","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":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2024-09-19 15:34:42","updated_at":"2025-03-03 10:24:33","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91110111MA01RP4H80\n\u5f00\u6237\u94f6\u884c\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5174\u5b9c\u652f\u884c\n\u94f6\u884c\u8d26\u53f7\uff1a0200 3014 0910 0054 430\n\u5730\u5740\uff1a\u5317\u4eac\u5e02\u623f\u5c71\u533a\u62f1\u8fb0\u8857\u9053\u6708\u534e\u5927\u88571\u53f7A8-667\n\u7535\u8bdd\uff1a13717705170","logo":null,"en_name":"","pick_at":"2024-09-19 15:34:42","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":2,"visit_count":0,"cooperate_count":2,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":1262,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f265\u5929\u672a\u8054\u7cfb"},{"id":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","abbr":null,"pinyin_shortcut":"jrsbs","description":"","corp_rep":"\u90a2\u65e9\u5fe0","website":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e2d\u5173\u6751\u5357\u5927\u8857\u753218\u53f7D\u5ea722\u5c42","capital":null,"established_at":null,"headcount":null,"reg_address":null,"working_address":null,"telephone":"010-82198082","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":18,"client_type":6,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2024-09-06 17:10:37","updated_at":"2025-05-08 14:39:42","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u589e\u503c\u7a0e\u4e13\u7528\u53d1\u7968\n\u5f00\u6237\u94f6\u884c:\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u592a\u5e73\u6865\u652f\u884c\n\u94f6\u884c\u8d26\u6237:0200020309014412832\n\u6ce8\u518c\u5730\u5740:\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e2d\u5173\u6751\u5357\u5927\u8857\u753218\u53f7D\u5ea718-22\u5c42","logo":null,"en_name":"","pick_at":"2024-09-06 17:10:37","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":2,"visit_count":0,"cooperate_count":2,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"lost_contact_days":null,"last_contact":"","clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":3,"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},"clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f278\u5929\u672a\u8054\u7cfb"},{"id":3296,"name":"\u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","abbr":null,"pinyin_shortcut":"tesxxjsgfyxgsgd","description":"","corp_rep":"\u674e\u6e1d\u52e4","website":"https:\/\/www.trs.com.cn","capital":"79529.1951","established_at":"1993-02-18","headcount":null,"reg_address":null,"working_address":null,"telephone":"010-64848899 ","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":2,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2024-08-22 15:33:07","updated_at":"2024-10-30 11:14:07","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a \u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911100006000107204\n\u5730\u5740: \u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5efa\u67ab\u8def\uff08\u5357\u5ef6\uff096\u53f7\u96623\u53f7\u697c1\u81f37\u5c42101 \n\u7535\u8bdd\u53f7\u7801\uff1a64848899 \n\u5f00\u6237\u94f6\u884c\uff1a\u4e2d\u884c\u5317\u4eac\u77e5\u6625\u8def\u652f\u884c \n\u8d26\u6237\uff1a 329856010832 \n","logo":null,"en_name":"","pick_at":"2024-08-22 15:33: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":7,"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,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":2,"key":2,"name":"\u6c11\u8425\u4e0a\u5e02"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f293\u5929\u672a\u8054\u7cfb"},{"id":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"ltkjshyxgs","description":"\u53d1\u7968\u5bc4\u9001\u5730\u5740\uff1a\u4e0a\u6d77\u5e02\u9759\u5b89\u533a\u6c5f\u573a\u897f\u8def299\u5f0449\u53f7\u4e2d\u94c1\u4e2d\u73af\u65f6\u4ee3\u5e7f\u573a1\u53f7\u697c1201B \u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8 \u8d22\u52a1\u4e18\u794e\u7a0b 021-61421866","corp_rep":"CHIA HONG LOONG ERIC","website":"","capital":"1000","established_at":"2006-04-09","headcount":null,"reg_address":null,"working_address":3793,"telephone":"","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2024-07-03 14:38:20","updated_at":"2025-08-08 10:55:27","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0: \u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8\n\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a 91310000786707955D\n\u516c\u53f8\u5730\u5740\u53ca\u7535\u8bdd:\u3000\u4e0a\u6d77\u5e02\u9759\u5b89\u533a\u6c5f\u573a\u897f\u8def299\u5f0449\u53f71201-3\u30011201-4\u30011201-5\u5ba4\u00a0\u00a0\u00a0 021-61421866\n\u5f00\u6237\u94f6\u884c\u3001\u8d26\u53f7\uff1a\u4ea4\u901a\u94f6\u884c\u5e02\u5317\u5de5\u4e1a\u533a\u652f\u884c\u00a0 310066247018160174864\u00a0 ","logo":null,"en_name":"","pick_at":"2024-07-03 14:38:20","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":2,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":1262,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f343\u5929\u672a\u8054\u7cfb"},{"id":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjcagtkjfzyxgs","description":"","corp_rep":"\u675c\u78ca","website":"","capital":"200","established_at":"2016-06-20","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":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1011,"created_at":"2024-06-26 10:41:52","updated_at":"2024-10-17 16:05:43","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a \u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8 \n\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a 91110114MA006F0W2X \n\u5730\u5740\u7535\u8bdd\uff1a \u5317\u4eac\u5e02\u660c\u5e73\u533a\u57ce\u5357\u8857\u9053\u9f99\u6c34\u8def28\u53f7\u697c-1\u81f32\u5c42028-3\u5185-1\u5c42B101 010-58444180 \n\u5f00\u6237\u94f6\u884c\u53ca\u5e10\u53f7\uff1a \u5174\u4e1a\u94f6\u884c\u5317\u4eac\u5206\u884c\u957f\u5b89\u652f\u884c 321120100100304908 ","logo":null,"en_name":"","pick_at":"2024-06-26 10:41:52","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":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":1262,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f350\u5929\u672a\u8054\u7cfb"},{"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","abbr":null,"pinyin_shortcut":"tfzwbjjsyxgstfzwszcbjsgfyxgszgxsqkgpbdzzzsyxgs","description":"\u540d\u79f0\uff1a\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91110108710924451B\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u5c0f\u53e3\u8def66\u53f7\u4e2d\u5173\u6751\u4e1c\u5347\u79d1\u6280\u56edB-2\u53f7\u697c\u4e8c\u5c42B201-B203\u3001B205-B210\u5ba4(\u4e1c\u5347\u5730\u533a) 62969002-8076\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u5efa\u884c\u6e05\u534e\u5927\u5b66\u652f\u884c11001029000052500014\n\n\u540d\u79f0\uff1a\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101086337298973\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6e05\u534e\u56ed\u6e05\u534e\u5927\u5b6636\u533a1407\u30011408\u30011409 62969002-8079\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u62db\u5546\u94f6\u884c\u6e05\u534e\u56ed\u652f\u884c866780465610001\n\n\u540d\u79f0\uff1a\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101087693507203\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u5c0f\u53e3\u8def66\u53f7\u4e1c\u5347\u79d1\u6280\u56ed\u5317\u9886\u5730A\u533a\u7b2c2\u53f7\u697c 62969002-8076\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u5efa\u884c\u6e05\u534e\u5927\u5b66\u652f\u884c11001029000059809201\n","corp_rep":"\u5218\u957f\u6b23","website":"www.cnki.net","capital":"826.41","established_at":"2004-11-18","headcount":null,"reg_address":null,"working_address":3501,"telephone":"","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":18,"client_type":6,"sales_rep":1001,"main_contact":null,"created_by":1011,"created_at":"2024-05-07 16:42:41","updated_at":"2025-01-20 16:02:12","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-05-07 16:42:41","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":2,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"lost_contact_days":null,"last_contact":"","clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":3,"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},"clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f400\u5929\u672a\u8054\u7cfb"},{"id":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","abbr":null,"pinyin_shortcut":"bjhttlxxjsyxgsPAgd","description":"","corp_rep":"\u5f20\u6587\u9b41","website":"","capital":"2508","established_at":"2006-12-14","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":13,"client_type":5,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2024-04-26 09:27:41","updated_at":"2025-06-05 11:16:12","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\n\u7a0e \u53f7\uff1a911101087967203014\n\u516c\u53f8\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u6e05\u8def68\u53f7\u966221\u697c2\u5c4218\u5ba4\n\u7535 \u8bdd\uff1a010-82783839\n\u5f00 \u6237 \u884c\uff1a\u5e7f\u53d1\u94f6\u884c\u5317\u4eac\u4e0a\u5730\u652f\u884c\n\u5e10 \u53f7\uff1a137281516010000396","logo":null,"en_name":"","pick_at":"2024-04-26 09:27:41","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":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":1262,"lost_contact_days":null,"last_contact":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","client_lock":false,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"unCloseCases":[],"clientFrom":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"lost_contact_days_display":null,"can_pick_up":false,"can_update":true,"can_delete":false,"can_give_up":true,"overdue_display":"\u903e\u671f411\u5929\u672a\u8054\u7cfb"}],"can_transfer":true,"pagenation":{"totalcount":57,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-10 04:42:05') RETURNING "id"
04:42:05.5692.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
04:42:05.5671.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
04:42:05.6351.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id" IN (4, 6, 3, 2)
04:42:05.5721.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
04:42:05.6341.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 6)
04:42:05.6370.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (13, 5, 4, 20, 57, 10, 18)
04:42:05.6500.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (101, 164, 132, 142, 5, 138, 165, 179, 1, 196, 204, 226, 2, 184, 189, 181, 213, 212, 229, 160, 140, 215, 133, 197, 199, 7, 94, 174, 176, 205, 135, 131, 2100000000, 185, 168, 178, 191, 307, 192, 128, 167, 335, 319, 340, 130, 156, 172, 129, 107, 155, 313, 153, 349, 351, 353, 359, 369, 377)) ORDER BY "sort"
04:42:05.6380.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
04:42:05.6500.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1003, 5076, 5295, 5359, 1001)
04:42:05.6350.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 1)
04:42:05.6380.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001