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 (
    101324, 101425, 101431, 101432, 101433, 
    101434, 101435, 101436, 101437, 101438, 
    101439, 101440, 101441, 101531, 101532, 
    101533, 101593, 101710, 101762, 101763
  )

Query time 0.00030

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
101324 S
101425 S
101431 S
101432 S
101433 S
101434 S
101435 S
101436 S
101437 S
101438 S
101439 S
101440 S
101441 S
101531 S
101532 S
101533 S
101593 S
101710 S
101762 S
101763 S