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 (
    55713, 59706, 59707, 59948, 60014, 60017, 
    60018, 60120, 60251, 60257, 60258, 
    60317, 60343, 60344, 60444, 60494, 
    60495, 60497, 60498, 60501, 60525, 
    60555, 60556, 60559, 60590, 60593, 
    60687, 60688, 60689, 60690, 60694, 
    60695, 60723, 60725, 60862, 60898, 
    60899, 60911, 60957, 60958
  )

Query time 0.00084

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 40 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
55713 S
59706 S
59707 S
59948 S
60014 S
60017 S
60018 S
60120 S
60251 S
60257 S
60258 S
60317 S
60343 S
60344 S
60444 S
60494 S
60495 S
60497 S
60498 S
60501 S
60525 S
60555 S
60556 S
60559 S
60590 S
60593 S
60687 S
60688 S
60689 S
60690 S
60694 S
60695 S
60723 S
60725 S
60862 S
60898 S
60899 S
60911 S
60957 S
60958 S