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 (
    96278, 96279, 96284, 96303, 96304, 96305, 
    96306, 96307, 96316, 96317, 96319, 
    96321, 96340, 96465, 96470, 96732, 
    96733, 98612, 98761, 98762
  )

Query time 0.00037

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
96278 S
96279 S
96284 S
96303 S
96304 S
96305 S
96306 S
96307 S
96316 S
96317 S
96319 S
96321 S
96340 S
96465 S
96470 S
96732 S
96733 S
98612 S
98761 S
98762 S