gistfile1.txt

select p.idprel,
e.lespcm,
s.idstation
from opt_prelevement p
INNER JOIN espece e ON (p.cesp = e.cesp)
INNER JOIN opt_station s ON (p.idstation = s.idstation)
order by idprel limit 10 offset 289900

=> 49.394ms

---------------------------------------------------------
select p.idprel,
e.lespcm,
s.idstation
from opt_prelevement p
INNER JOIN espece e ON (p.cesp = e.cesp)
INNER JOIN opt_station s ON (p.idstation = s.idstation)
where p.idprel > 'E543384678' //c'est l'ID du 289899 eme prelevement
order by idprel limit 10

=> 30ms