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 (
    87461, 92803, 92811, 92987, 92995, 92996, 
    93117, 93118, 93119, 93120, 93121, 
    93162, 93196, 93197, 93266, 93268, 
    93269, 93270, 93271, 93302
  )

Query time 0.00025

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
87461 S
92803 S
92811 S
92987 S
92995 S
92996 S
93117 S
93118 S
93119 S
93120 S
93121 S
93162 S
93196 S
93197 S
93266 S
93268 S
93269 S
93270 S
93271 S
93302 S