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 (
    96420, 96421, 96429, 96433, 96434, 96435, 
    96436, 96437, 96438, 96439, 96440, 
    96441, 96442, 96443, 96444, 98548, 
    98549, 98550, 98551, 98758
  )

Query time 0.00043

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
96420 S
96421 S
96429 S
96433 S
96434 S
96435 S
96436 S
96437 S
96438 S
96439 S
96440 S
96441 S
96442 S
96443 S
96444 S
98548 S
98549 S
98550 S
98551 S
98758 S