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 (
    88655, 88656, 88657, 88658, 88742, 88789, 
    89152, 89773, 89774, 89775, 89776, 
    89777, 89778, 89779, 89780, 89781, 
    89782, 89783, 89784, 92974
  )

Query time 0.00027

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
88655 S
88656 S
88657 S
88658 S
88742 S
88789 S
89152 S
89773 S
89774 S
89775 S
89776 S
89777 S
89778 S
89779 S
89780 S
89781 S
89782 S
89783 S
89784 S
92974 S