Bad performance with query with binds

Hello,

We would like to know if there is a better way to do this query or any best index

SELECT ID, url, type, quality, thumbnail, is_main

FROM HOTELS

where

             ID IN

             (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:

             19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:3

             5,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51

             ,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:62,:63,:64,:65,:66,:67,

             :68,:69,:70,:71,:72,:73,:74,:75,:76,:77,:78,:79,:80,:81,:82,:83,:

             84,:85,:86,:87,:88,:89,:90,:91,:92,:93,:94,:95,:96,:97,:98,:99,:1

             00)

AND is_main = 1;

  NUM_ROWS

----------

  59330277

   IS_MAIN   COUNT(*)

---------- ----------

                94693

         1    1405844

         0   57829684

We have one index on table:

CREATE INDEX HOTELS_i1 ON HOTELS ("ID");