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 (
    59934, 59935, 59936, 59937, 59938, 59939, 
    59940, 59941, 60012, 60013, 60042, 
    60250, 60331, 60332, 60333, 60334, 
    60335, 60336, 60337, 60338, 60339, 
    60340, 60341, 60342, 60379, 60408, 
    60412, 60413, 60420, 60422, 60427, 
    60430, 60436, 60440, 60503, 60504, 
    60505, 60506, 60507, 60716
  )

Query time 0.00056

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
59934 S
59935 S
59936 S
59937 S
59938 S
59939 S
59940 S
59941 S
60012 S
60013 S
60042 S
60250 S
60331 S
60332 S
60333 S
60334 S
60335 S
60336 S
60337 S
60338 S
60339 S
60340 S
60341 S
60342 S
60379 S
60408 S
60412 S
60413 S
60420 S
60422 S
60427 S
60430 S
60436 S
60440 S
60503 S
60504 S
60505 S
60506 S
60507 S
60716 S