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 (
    99146, 99147, 99148, 99149, 99150, 99151, 
    99152, 100143, 100144, 100145, 100146, 
    100147, 100148, 100149, 100150, 100152, 
    100153, 100154, 100155, 100289
  )

Query time 0.00044

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
99146 S
99147 S
99148 S
99149 S
99150 S
99151 S
99152 S
100143 S
100144 S
100145 S
100146 S
100147 S
100148 S
100149 S
100150 S
100152 S
100153 S
100154 S
100155 S
100289 S