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 (
    103928, 103929, 103931, 103932, 104007, 
    104008, 104033, 104034, 104035, 104036, 
    104038, 104040, 104043, 104094, 104099, 
    104101, 104119, 104133, 104355, 104408
  )

Query time 0.00032

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
103928 S
103929 S
103931 S
103932 S
104007 S
104008 S
104033 S
104034 S
104035 S
104036 S
104038 S
104040 S
104043 S
104094 S
104099 S
104101 S
104119 S
104133 S
104355 S
104408 S