经纬度查询

$sqlStr = "SELECT
store_id,title,address,linkmobile,dqh_price,bz_price_tip,parent_id,bind_ghs_store_id,
(
   6371 * acos (
      cos ( radians( #{lat} ) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians( #{lng} ) ) + sin ( radians( #{lat} ) ) * sin( radians( lat ) )
   )
)
AS
   distance
FROM
   fa_store
where 

bind_ghs_store_id > 0 and  type = 2 and  online = 1 and is_hospital=1
   HAVING
   distance <= 1
ORDER BY
   distance asc
LIMIT 10;
      ";