Como Obtimizar esta Consulta?

[huesos52]

No utilices el *.

solo llama los campos que requieras. En tu caso ip_publica.

Prueba así y dinos si mejora

Código SQL:

SELECT T1.ip_publica AS ip, T2.*, T2.country_name AS pais, COUNT(T2.country_name) AS total FROM (SELECT ip_publica FROM stat_user GROUP BY ip_publica) AS T1 LEFT JOIN stat_country AS T2 ON INET_ATON(T1.ip_publica)>=T2.IP_FROM AND INET_ATON(T1.ip_publica)<=T2.IP_TO GROUP BY pais ORDER BY total DESC LIMIT 0,10
 

o así

Código SQL:

SELECT T1.ip_publica AS ip, T2.*, T2.country_name AS pais, COUNT(T2.country_name) AS total FROM (SELECT DISTINCT ip_publica FROM stat_user) AS T1 LEFT JOIN stat_country AS T2 ON INET_ATON(T1.ip_publica)>=T2.IP_FROM AND INET_ATON(T1.ip_publica)<=T2.IP_TO GROUP BY pais ORDER BY total DESC LIMIT 0,10