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 (
    104328, 104329, 104330, 104331, 104335, 
    104336, 104353, 104411, 104427, 104462, 
    104463, 104509, 104525, 104526, 104527, 
    105068, 105069, 105319, 105607, 105726
  )

Query time 0.00043

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
104328 S
104329 S
104330 S
104331 S
104335 S
104336 S
104353 S
104411 S
104427 S
104462 S
104463 S
104509 S
104525 S
104526 S
104527 S
105068 S
105069 S
105319 S
105607 S
105726 S