FIND_IN_SET 导致查询慢 求解决方案
SELECT DISTINCT c.ID CompID, c.CompName, c.Province, c.City, c.District, c.Address, c.Street,c.MapLng,c.MapLat ,c.compKind,c.AppArea,c.MainProduct,
(case when ISNULL(c.MapLng) or ISNULL(c.MapLat) THEN 100000000 ELSE round(6378.138 * 2 * asin(sqrt(pow(sin((@mapLat * pi() / 180 - c.MapLat * pi() / 180) / 2),2) + cos(@mapLat * pi() / 180) * cos(c.MapLat * pi() / 180) * pow(
sin((@mapLng * pi() / 180 - c.MapLng * pi() / 180) / 2),2))) *1000) END ) Distance from eq e
join co c on e.CompID=c.ID
left join class as class on
FIND_IN_SET(class.ID, REPLACE(e.EqClassPath, '_', ','))
and class.CPath LIKE '3383\_%' AND class.State=0
WHERE c.State=1 and c.SearchShow='0' AND (e.State=1 or e.State=4) and e.IsPublic=1 and e.EntityState<2;