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 (
    103072, 103077, 103078, 103079, 103085, 
    103086, 103362, 103425, 103426, 103427, 
    103428, 103429, 103430, 103431, 103432, 
    103433, 103434, 103435, 103436, 103687
  )

Query time 0.00038

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
103072 S
103077 S
103078 S
103079 S
103085 S
103086 S
103362 S
103425 S
103426 S
103427 S
103428 S
103429 S
103430 S
103431 S
103432 S
103433 S
103434 S
103435 S
103436 S
103687 S