下面语句执行select 查询属性的时候 不是全表扫描,
执行select count(0) 全表扫描
SELECT
COUNT(0)
FROM park_info t1
INNER JOIN park_info t2
ON t1.event_type = 0
AND t1.audit_status = 1
AND t2.only_code = t1.only_code
AND t2.audit_status = 1
AND t2.event_type = 1
未加入idx_onlycode 执行count时间一分钟,
加入后执行时间0.1秒