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 (
    82833, 82836, 83103, 83138, 83139, 83193, 
    83194, 83221, 83242, 83243, 83245, 
    83246, 83247, 83248, 83249, 83250, 
    83251, 83252, 83253, 83254, 83255, 
    83256, 83257, 83258, 83259, 83260, 
    83261, 83262, 83263, 83264, 83265, 
    83266, 83267, 83268, 83298, 83406, 
    83407, 83596, 83597, 83598
  )

Query time 0.00054

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
82833 S
82836 S
83103 S
83138 S
83139 S
83193 S
83194 S
83221 S
83242 S
83243 S
83245 S
83246 S
83247 S
83248 S
83249 S
83250 S
83251 S
83252 S
83253 S
83254 S
83255 S
83256 S
83257 S
83258 S
83259 S
83260 S
83261 S
83262 S
83263 S
83264 S
83265 S
83266 S
83267 S
83268 S
83298 S
83406 S
83407 S
83596 S
83597 S
83598 S