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 (
    83661, 83662, 83663, 83664, 83665, 83666, 
    83687, 83688, 83689, 83726, 83727, 
    83728, 83730, 83732, 83733, 83734, 
    83735, 83736, 83753, 83754, 83755, 
    83756, 83757, 83758, 83915, 84108, 
    84130, 84131, 84132, 84133, 84134, 
    84173, 84174, 84175, 84208, 84209, 
    84210, 84211, 84216, 84318
  )

Query time 0.00073

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 40 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
83661 S
83662 S
83663 S
83664 S
83665 S
83666 S
83687 S
83688 S
83689 S
83726 S
83727 S
83728 S
83730 S
83732 S
83733 S
83734 S
83735 S
83736 S
83753 S
83754 S
83755 S
83756 S
83757 S
83758 S
83915 S
84108 S
84130 S
84131 S
84132 S
84133 S
84134 S
84173 S
84174 S
84175 S
84208 S
84209 S
84210 S
84211 S
84216 S
84318 S