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 (
    33660, 33670, 33774, 33901, 33945, 33974, 
    33975, 34093, 34232, 34257, 34315, 
    34442, 34443, 34594, 34603, 34646, 
    34742, 34761, 34769, 34854
  )

Query time 0.00095

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
33660 S
33670 S
33774 S
33901 S
33945 S
33974 S
33975 S
34093 S
34232 S
34257 S
34315 S
34442 S
34443 S
34594 S
34603 S
34646 S
34742 S
34761 S
34769 S
34854 S