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 (
    99905, 99906, 99910, 99911, 99912, 99913, 
    99914, 100072, 100074, 100081, 100082, 
    100086, 100115, 100429, 100439, 100447, 
    100519, 100584, 100624, 100625
  )

Query time 0.00068

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
99905 S
99906 S
99910 S
99911 S
99912 S
99913 S
99914 S
100072 S
100074 S
100081 S
100082 S
100086 S
100115 S
100429 S
100439 S
100447 S
100519 S
100584 S
100624 S
100625 S