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 (
    930, 1067, 1068, 1069, 2569, 2588, 2590, 
    2591, 2593, 2594, 2596, 2598, 2621, 
    2622, 2623, 2624, 2642, 2646, 2647
  )

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 19 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
930 S
1067 S
1068 S
1069 S
2569 S
2588 S
2590 S
2591 S
2593 S
2594 S
2596 S
2598 S
2621 S
2622 S
2623 S
2624 S
2642 S
2646 S
2647 S