SELECT 
  option_id, 
  option_type 
FROM 
  cscart_product_options 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_product_options.option_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_options'
  ) 
WHERE 
  option_id IN (
    93790, 93872, 94028, 94044, 94136, 94139, 
    94211, 94249, 94256, 94257, 94258, 
    94260, 94265, 94266, 94290, 94294, 
    94297, 94309, 94310, 94311
  )

Query time 0.00028

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 20 Using where
1 SIMPLE cscart_ult_objects_sharing eq_ref PRIMARY PRIMARY 159 toolboxdigitalshop_dev.cscart_product_options.option_id,const,const 1 Using where; Using index

Result

option_id option_type
93790 S
93872 S
94028 S
94044 S
94136 S
94139 S
94211 S
94249 S
94256 S
94257 S
94258 S
94260 S
94265 S
94266 S
94290 S
94294 S
94297 S
94309 S
94310 S
94311 S