如何计算经纬度之间的距离?

页面:/news/view-950240/ | 耗时:0.4744 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=950240 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=950240 LIMIT 0,1
select * from tbl_Articles_sphinx where id=950240 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(535286,515397,390893,476925,645737,453881,508742,599157,419763,462375,664125,599855,499814,897263,663632,682267,479006,416389,569765,367701,468334,1275212,671757,430674,502604,443467,686353,554479,490997,3366990) ORDER BY field (ArticleID,535286,515397,390893,476925,645737,453881,508742,599157,419763,462375,664125,599855,499814,897263,663632,682267,479006,416389,569765,367701,468334,1275212,671757,430674,502604,443467,686353,554479,490997,3366990)