表结构：
CREATE TABLE ec_user_base_info (
id bigint(20) NOT NULL AUTO_INCREMENT,
project_id int(11) NOT NULL DEFAULT 0 COMMENT ‘项目id’,
landing_page_no varchar(64) NOT NULL DEFAULT ‘’ COMMENT ‘落地页序号’,
user_id varchar(64) NOT NULL DEFAULT ‘’ COMMENT ‘用户id’,
start_time int(11) NOT NULL DEFAULT 0 COMMENT ‘开始时间’,
pcp_browse_time int(11) NOT NULL DEFAULT 0 COMMENT ‘浏览时间’,
banner_no int(11) NOT NULL DEFAULT 0 COMMENT ‘banner编号’,
pf varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘投放渠道’,
mp varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘投放点位’,
cti varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘基础定向-收入’,
cts varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘基础定向-性别’,
cta varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘基础定向-年龄’,
ctc varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘基础定向-城市’,
ctp varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘基础定向-方位’,
ctct varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘基础定向-城市级别’,
ctcp varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘基础定向-文案’,
ott varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘其他定向’,
os varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘操作系统0-未知1-ios2-Android3-Windows4-Symbian5-Java’,
imei varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘用户收imei信息’,
idfa varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘idfa信息’,
ua text NOT NULL COMMENT ‘用户浏览器信息’,
ref text NOT NULL COMMENT ‘refer信息’,
is_mobile tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘是否是手机 1是 0 否’,
data_json json DEFAULT NULL COMMENT ‘其他数据’,
add_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘添加时间’,
ip varchar(128) DEFAULT ‘’ COMMENT ‘ip’,
last_update_time int(11) DEFAULT 0 COMMENT ‘最终更新时间’,
survey_id int(11) DEFAULT 0 COMMENT ‘问卷ID’,
PRIMARY KEY (id),
KEY start_time (start_time),
KEY survey_user (survey_id,user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=744182 COMMENT=’【内容测试-用户】信息’;
异常sql：SELECT
*
FROM
ec_user_base_info
WHERE
survey_id=672427
报错信息：2013 - Lost connection to MySQL server during query
更换别的survey_id 不会报错，例如 survey_id = 672327