sql offset 优化
// let groupSql = ` select id,jd_gcj02ll, wd_gcj02ll from ${tablename_qiye} where id between ${size * (page - 1) + offset+1} and ${size * page + offset} `; let groupSql = ` select id,jd_gcj02ll, wd_gcj02ll from ${tablename_qiye} where county1 ='' or county1 is NULL limit ${size} offset ${size * (page - 1) + offset} `;