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 (
    83866, 87447, 90372, 90373, 90374, 90375, 
    90376, 90377, 90378, 90379, 90380, 
    90381, 90546, 91042, 91241, 91302, 
    91310, 91335, 91343, 119860
  )

Query time 0.00040

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
83866 S
87447 S
90372 S
90373 S
90374 S
90375 S
90376 S
90377 S
90378 S
90379 S
90380 S
90381 S
90546 S
91042 S
91241 S
91302 S
91310 S
91335 S
91343 S
119860 S