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 (
    104296, 104297, 104299, 104300, 104317, 
    104318, 104319, 104322, 104325, 104326, 
    104354, 104356, 104357, 104358, 104359, 
    104387, 104390, 104391, 104515, 104659
  )

Query time 0.00024

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
104296 S
104297 S
104299 S
104300 S
104317 S
104318 S
104319 S
104322 S
104325 S
104326 S
104354 S
104356 S
104357 S
104358 S
104359 S
104387 S
104390 S
104391 S
104515 S
104659 S