Try to force join order

select * ;
  from FORCE abone ;
  JOIN hurun ON abone.hurun  = hurun.id ;
   AND hurun.exp like "Merh%" ;
  JOIN ekler ON abone.ekler = ekler.id

>--------------------------
> First query
>--------------------------
>

>select * ;
>  from abone ;
>  JOIN hurun ON abone.hurun  = hurun.id ;
>   AND hurun.exp like "Merh%" ;
>  JOIN ekler ON abone.ekler = ekler.id
>

>
>** Result : selected 309 records in 6.55 seconds
>
>
>
>Rushmore optimization level for table abone: none
>Rushmore optimization level for table hurun: none
>Rushmore optimization level for table ekler: none
>
>Joining table ekler and table abone using index tag Ekler
>Joining table hurun and intermediate result using temp index
>
>
>---------------------------
> Second query
>---------------------------
>
>

>select * ;
>  from abone ;
>  JOIN ekler on abone.ekler  = ekler.id ;
>   AND ekler.exp like "Arkd%" ;
>  JOIN hurun ON abone.hurun = hurun.id
>

>
>
>** Result : Selected 1155 records in 0.03 seconds
>
>Rushmore optimization level for table abone: none
>Rushmore optimization level for table hurun: none
>Rushmore optimization level for table ekler: none
>Joining table ekler and table abone using index tag Ekler
>Joining table hurun and intermediate result using temp index