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 (
    103572, 103583, 103618, 103620, 103621, 
    103622, 103623, 104016, 104068, 104126, 
    104127, 104128, 104129, 104261, 104262, 
    104263, 104264, 104265, 104266, 104267
  )

Query time 0.00027

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
103572 S
103583 S
103618 S
103620 S
103621 S
103622 S
103623 S
104016 S
104068 S
104126 S
104127 S
104128 S
104129 S
104261 S
104262 S
104263 S
104264 S
104265 S
104266 S
104267 S