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 (
    96611, 96612, 96613, 96614, 96615, 96616, 
    96617, 96618, 96620, 96639, 96640, 
    96641, 96642, 96643, 96644, 96645, 
    96646, 96647, 96648, 96649
  )

Query time 0.00034

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
96611 S
96612 S
96613 S
96614 S
96615 S
96616 S
96617 S
96618 S
96620 S
96639 S
96640 S
96641 S
96642 S
96643 S
96644 S
96645 S
96646 S
96647 S
96648 S
96649 S