Tiempos en consulta de Geolocalizacion exagerado

[jurena]

SELECT cl.country, cl.region, cl.city, cl.postalCode, cl.latitude, cl.longitude, cl.metroCode, cl.areaCode FROM CityLocation cl INNER JOIN (SELECT locId FROM CityBlocks WHERE (3193711229 >= startIpNum AND 3193711229 <= endIpNum) ORDER BY startIpNum DESC) t1 ON cl.locid = t1.locId