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 (
    88637, 88638, 88639, 88640, 88642, 88643, 
    88644, 88645, 88646, 88647, 88648, 
    88649, 88650, 88651, 88652, 88653, 
    88654, 89072, 89074, 89284
  )

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
88637 S
88638 S
88639 S
88640 S
88642 S
88643 S
88644 S
88645 S
88646 S
88647 S
88648 S
88649 S
88650 S
88651 S
88652 S
88653 S
88654 S
89072 S
89074 S
89284 S