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 (
    104103, 104104, 104110, 104162, 104163, 
    104167, 104198, 104199, 104224, 104226, 
    104232, 104233, 104249, 104290, 104312, 
    104315, 104320, 104321, 104323, 105576
  )

Query time 0.00104

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
104103 S
104104 S
104110 S
104162 S
104163 S
104167 S
104198 S
104199 S
104224 S
104226 S
104232 S
104233 S
104249 S
104290 S
104312 S
104315 S
104320 S
104321 S
104323 S
105576 S