这样一条sql要怎么优化呢?
李秀才 2017-04-14 03:54:43 这样一个sql要怎么优化呢?
select t.loginName,t.distanceStr,t.sex from (select (st_distance(point(r.lon,r.lat), point(108.979118,34.166634)) * 111195 )
as distanceStr ,r.loginName,
r.sex from ycd_sys_user r where r.id != '55ef37a3dcd3423ab7f1cb8e5de3de1f' )
t where t.distanceStr <=50000
order by t.distanceStr asc limit 20