[0.00047206878662109] SELECT * FROM countries ORDER BY country_name ASC
[0.00013089179992676] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE l.status IN ('new','pending','validated') AND l.longitude BETWEEN -0.3 AND 0.3 AND l.latitude BETWEEN -0.3 AND 0.3
