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 (
    90088, 90089, 90249, 90250, 90251, 90252, 
    90253, 90254, 90255, 90256, 90257, 
    90258, 90259, 90260, 90261, 90262, 
    90263, 90264, 90310, 90317
  )

Query time 0.00053

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
90088 S
90089 S
90249 S
90250 S
90251 S
90252 S
90253 S
90254 S
90255 S
90256 S
90257 S
90258 S
90259 S
90260 S
90261 S
90262 S
90263 S
90264 S
90310 S
90317 S