SELECT
6370 * acos(
cos(
radians(#{lat})) * cos(radians(weidu)) * cos(radians(jingdu) - radians(#{lng})) + sin(radians(#{lat})) * sin(radians(weidu))) AS distance,
qiyemingcheng,jingdu,weidu,id
from ${tableId}
原文：https://www.cnblogs.com/wudi521/p/12567478.html