select a.ID id_model from  MODELS a
 join  price c on c.id_model=a.ID and c.ID_PRICE=2 and c.ID_STATUS=1
 join currency d on d.id=a.ID_CURRENCY

------ Performance info ------
Prepare time = 31ms
Execute time = 16ms
Avg fetch time = 0,53 ms
Current memory = 9 845 168
Max memory = 9 935 328
Memory buffers = 2 048
Reads from disk to cache = 0
Writes from cache to disk = 0
Fetches from cache = 77 134

select a.ID id_model from MODELS a

 join  EXCHANGE_RATE b on b.ID_CURRENCY=a.ID_CURRENCY and b.ID_STATUS=1
 join  price c on c.id_model=a.ID and c.ID_PRICE=2 and c.ID_STATUS=1
 join currency d on d.id=b.ID_CURRENCY

------ Performance info ------
Prepare time = 31ms
Execute time = 1s 375ms
Avg fetch time = 45,83 ms
Current memory = 9 857 632
Max memory = 9 935 328
Memory buffers = 2 048
Reads from disk to cache = 0
Writes from cache to disk = 0
Fetches from cache = 12 399 373

Plan
--------------------------------------------------------------------------------
PLAN JOIN (C INDEX (FK_PRICES_CURRENCY), A INDEX (PK_MODELS), D INDEX (PK_CURRENCY))

Plan
--------------------------------------------------------------------------------
PLAN JOIN (C INDEX (FK_PRICES_CURRENCY), A INDEX (PK_MODELS), D INDEX (PK_CURRENCY), B INDEX (FK_EXCHANGE_RATE_CURRENCY))