explain
SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei = (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	date between '2009-08-25' AND '2009-08-27'
 UNION
 SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei = (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	t_event.id = (SELECT id FROM t_event
 		WHERE date > '2009-08-27' AND
 		event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 		t_event.device_fk = device.id
 		ORDER BY date ASC LIMIT 1)
 ORDER BY spz_number, date;
cost 2573



explain
SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk in (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei in (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	date between '2009-08-25' AND '2009-08-27'
 UNION
 SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk in (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei in (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	t_event.id = (SELECT id FROM t_event
 		WHERE date > '2009-08-27' AND
 		event_type_fk in (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 		t_event.device_fk = device.id
 		ORDER BY date ASC LIMIT 1)
 ORDER BY spz_number, date;
cost 2109



explain
SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei in (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	date between '2009-08-25' AND '2009-08-27'
 UNION
 SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei in (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	t_event.id = (SELECT id FROM t_event
 		WHERE date > '2009-08-27' AND
 		event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 		t_event.device_fk = device.id
 		ORDER BY date ASC LIMIT 1)
 ORDER BY spz_number, date;
cost 2039


---------------------------------------------------------------------------------------
Extendet time interval:
explain
SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei = (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	date between '2009-08-25' AND '2009-08-27'
 UNION
 SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei = (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	t_event.id = (SELECT id FROM t_event
 		WHERE date > '2009-08-27' AND
 		event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 		t_event.device_fk = device.id
 		ORDER BY date ASC LIMIT 1)
 ORDER BY spz_number, date;
cost 32614



explain
SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk in (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei in (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	date between '2009-08-25' AND '2009-08-27'
 UNION
 SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk in (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei in (SELECT imei FROM t_device WHERE id = 3 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	t_event.id = (SELECT id FROM t_event
 		WHERE date > '2009-08-27' AND
 		event_type_fk in (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 		t_event.device_fk = device.id
 		ORDER BY date ASC LIMIT 1)
 ORDER BY spz_number, date;
cost 2711

explain
SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei in (SELECT imei FROM t_device WHERE id = 34 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	date between '2009-07-25' AND '2009-08-25'
 UNION
 SELECT spz_number, date, value FROM t_event, t_device_cache, t_device device
 	WHERE event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 	device.imei in (SELECT imei FROM t_device WHERE id = 34 limit 1) AND
 	device.id = t_event.device_fk AND
 	t_device_cache.imei = device.imei AND
 	t_event.id = (SELECT id FROM t_event
 		WHERE date > '2009-08-25' AND
 		event_type_fk = (SELECT id FROM t_event_type WHERE type = 10 LIMIT 1) AND
 		t_event.device_fk = device.id
 		ORDER BY date ASC LIMIT 1)
 ORDER BY spz_number, date;
cost 2732