CREATE TABLE `geo_ips` (
	`idgeo_ip` INT(11) NOT NULL,
	`iprange` LINESTRING NOT NULL,
	PRIMARY KEY (`idgeo_ip`),
	SPATIAL INDEX `AK_iprange` (`iprange`)
)

explain 
select * from geo_ips
where MBRCONTAINS(iprange,POINT(1580060873,0));

"id"	"select_type"	"table"	"type"	"possible_keys"	"key"	"key_len"	"ref"	"rows"	"Extra"
"1"	"SIMPLE"	"geo_ips"	"ALL"	"AK_iprange"	\N	\N	\N	"1986196"	"Using where"

select * from geo_ips
where `start`<= :ip
order by `start` limit 1;

select * from geo_ips
where `start`<= :ip
order by `start` limit 1;

CREATE TABLE `geo_ipranges` (
	`idgeo_iprange` BIGINT(20) NOT NULL AUTO_INCREMENT,
	`start` BIGINT(20) NOT NULL DEFAULT '0',
	`end` BIGINT(20) NOT NULL DEFAULT '0',
	`fk_idgeo_lacation` BIGINT(20) NOT NULL DEFAULT '0',
	PRIMARY KEY (`idgeo_iprange`),
	INDEX `fk_geo_ip__geo_location` (`fk_idgeo_lacation`),
	INDEX `AK_end` (`end`),
	INDEX `AK_start` (`start`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1986197;

explain 
select * from geo_ipranges
where `end` >= 1580060873
order by `end` desc limit 1

"id"	"select_type"	"table"	"type"	"possible_keys"	"key"	"key_len"	"ref"	"rows"	"Extra"
"1"	"SIMPLE"	"geo_ipranges"	"range"	"AK_end"	"AK_end"	"8"	\N	"990000"	"Using index condition"


explain 
select * from geo_ipranges
where `start` <= 1580060873
order by `start` limit 1;


"id"	"select_type"	"table"	"type"	"possible_keys"	"key"	"key_len"	"ref"	"rows"	"Extra"
"1"	"SIMPLE"	"geo_ipranges"	"range"	"AK_start"	"AK_start"	"8"	\N	"990000"	"Using index condition"

select * from geo_ipranges
where `start` <= 1580060873
order by `start` desc limit 1

select * from geo_locations l

join (

select fk_idgeo_lacation 
			from geo_ipranges  
			where 1570080873 >= `start`
			order by `start` desc limit 1) ll on (ll.fk_idgeo_lacation = l.idgeo_location)

select l.*
from geo_locations l 
	join (select ( select i.fk_idgeo_lacation 
				from geo_ipranges i 
				where a.ip >= i.`start`
				order by i.`start` desc limit 1
			) as 'tt' 

#select last 10 logs
		from ap_files a order by a.idap_file desc limit 10
			
		) ll 	on (ll.tt=l.idgeo_location)