SELECT * FROM `location`
WHERE
(acos(
sin((#{lat}*3.1415)/180) * sin((lat*3.1415)/180) +
cos((#{lat}*3.1415)/180) * cos((lat*3.1415)/180) * cos((#{lng}*3.1415)/180 - (lng*3.1415)/180)
)*6370.996
) <= #{range}
range的单位是KM
SELECT * FROM `location`
WHERE
(acos(
sin((#{lat}*3.1415)/180) * sin((lat*3.1415)/180) +
cos((#{lat}*3.1415)/180) * cos((lat*3.1415)/180) * cos((#{lng}*3.1415)/180 - (lng*3.1415)/180)
)*6370.996
) <= #{range}
range的单位是KM