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 (
    76828, 76829, 76851, 76852, 76968, 76969, 
    77000, 77076, 77081, 77203, 77270, 
    77271, 77272, 77304, 77320, 77374, 
    77375, 77377, 77405, 78721
  )

Query time 0.00030

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
76828 S
76829 S
76851 S
76852 S
76968 S
76969 S
77000 S
77076 S
77081 S
77203 S
77270 S
77271 S
77272 S
77304 S
77320 S
77374 S
77375 S
77377 S
77405 S
78721 S