这样一个sql要怎么优化呢?
select t.loginName,t.distanceStr,t.sex from (select (st_distance(point(r.lon,r.lat), point(108.979118,34.166634)) * 111195 ) select t.loginName,t.distance
select t.loginName,t.distanceStr,t.sex from (select (st_distance(point(r.lon,r.lat), point(108.979118,34.166634)) * 111195 ) select t.loginName,t.distance