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 (
    83871, 87463, 93133, 93156, 93628, 93633, 
    93769, 93783, 93787, 93792, 93797, 
    93820, 93821, 93823, 93824, 93825, 
    93826, 93827, 93870, 93995
  )

Query time 0.00065

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
83871 S
87463 S
93133 S
93156 S
93628 S
93633 S
93769 S
93783 S
93787 S
93792 S
93797 S
93820 S
93821 S
93823 S
93824 S
93825 S
93826 S
93827 S
93870 S
93995 S