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 (
    58356, 58885, 58929, 58930, 58931, 58932, 
    58933, 58976, 58995, 58996, 58997, 
    58998, 58999, 59000, 59001, 59002, 
    59003, 59004, 59005, 59006, 59007, 
    59008, 59009, 59010, 59011, 59012, 
    59013, 59014, 59015, 59016, 59017, 
    59018, 59019, 59020, 59021, 59022, 
    59023, 59024, 59025, 59102
  )

Query time 0.00055

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
58356 S
58885 S
58929 S
58930 S
58931 S
58932 S
58933 S
58976 S
58995 S
58996 S
58997 S
58998 S
58999 S
59000 S
59001 S
59002 S
59003 S
59004 S
59005 S
59006 S
59007 S
59008 S
59009 S
59010 S
59011 S
59012 S
59013 S
59014 S
59015 S
59016 S
59017 S
59018 S
59019 S
59020 S
59021 S
59022 S
59023 S
59024 S
59025 S
59102 S