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 (
    37132, 37186, 37195, 37199, 37200, 37201, 
    37223, 37271, 37275, 37276, 37277, 
    37278, 37279, 37280, 37292, 37331, 
    37332, 37340, 37484, 37513
  )

Query time 0.00029

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
37132 S
37186 S
37195 S
37199 S
37200 S
37201 S
37223 S
37271 S
37275 S
37276 S
37277 S
37278 S
37279 S
37280 S
37292 S
37331 S
37332 S
37340 S
37484 S
37513 S