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 (
    81253, 81318, 81319, 81320, 81321, 81352, 
    81353, 81357, 81378, 81399, 81805, 
    81813, 81918, 81919, 81920, 81921, 
    81922, 81923, 81924, 81925, 81926, 
    81927, 81928, 81929, 81930, 82027, 
    82028, 82029, 82030, 82031, 82032, 
    82033, 82034, 82035, 82036, 82037, 
    82038, 82140, 82141, 82142
  )

Query time 0.00049

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 40 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
81253 S
81318 S
81319 S
81320 S
81321 S
81352 S
81353 S
81357 S
81378 S
81399 S
81805 S
81813 S
81918 S
81919 S
81920 S
81921 S
81922 S
81923 S
81924 S
81925 S
81926 S
81927 S
81928 S
81929 S
81930 S
82027 S
82028 S
82029 S
82030 S
82031 S
82032 S
82033 S
82034 S
82035 S
82036 S
82037 S
82038 S
82140 S
82141 S
82142 S