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 (
    99614, 99650, 99651, 99700, 99706, 99707, 
    100063, 100064, 100065, 100066, 100269, 
    100270, 100271, 100272, 100273, 100274, 
    100399, 100430, 100622, 100623
  )

Query time 0.00029

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
99614 S
99650 S
99651 S
99700 S
99706 S
99707 S
100063 S
100064 S
100065 S
100066 S
100269 S
100270 S
100271 S
100272 S
100273 S
100274 S
100399 S
100430 S
100622 S
100623 S