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 (
    93122, 93123, 93124, 93125, 93126, 93127, 
    93128, 93129, 93130, 93131, 93332, 
    93413, 93458, 93463, 93465, 93478, 
    93479, 93480, 93481, 119920
  )

Query time 0.00040

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
93122 S
93123 S
93124 S
93125 S
93126 S
93127 S
93128 S
93129 S
93130 S
93131 S
93332 S
93413 S
93458 S
93463 S
93465 S
93478 S
93479 S
93480 S
93481 S
119920 S