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 (
    102782, 102783, 102784, 102785, 102793, 
    102794, 102801, 102802, 102806, 102813, 
    102814, 102815, 103168, 103169, 103227, 
    103228, 103242, 103361, 103478, 103591
  )

Query time 0.00046

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
102782 S
102783 S
102784 S
102785 S
102793 S
102794 S
102801 S
102802 S
102806 S
102813 S
102814 S
102815 S
103168 S
103169 S
103227 S
103228 S
103242 S
103361 S
103478 S
103591 S