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 (
    42528, 42529, 42586, 42587, 42617, 42635, 
    42637, 42638, 42639, 42640, 42641, 
    42657, 42728, 42737, 42768, 42771, 
    42772, 42773, 42781, 42782, 42783, 
    42790, 42791, 42792, 42793, 42794, 
    42798, 42799, 42800, 42801, 42802, 
    42805, 42806, 42810, 42811, 42812, 
    42831, 42836, 42907, 42908, 42909, 
    42910, 42911, 42912, 42913, 42914, 
    42915, 42916, 42917, 42918, 42919, 
    42920, 42921, 42922, 42923, 42924, 
    42925, 42926, 42927, 42928, 42929, 
    42930, 42931, 42932, 42933, 42934, 
    42935, 42936, 42937, 42938, 42939, 
    42940, 42941, 42942, 43002, 43192, 
    43193, 43227, 43234, 43433
  )

Query time 0.00114

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 80 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
42528 S
42529 S
42586 S
42587 S
42617 S
42635 S
42637 S
42638 S
42639 S
42640 S
42641 S
42657 S
42728 S
42737 S
42768 S
42771 S
42772 S
42773 S
42781 S
42782 S
42783 S
42790 S
42791 S
42792 S
42793 S
42794 S
42798 S
42799 S
42800 S
42801 S
42802 S
42805 S
42806 S
42810 S
42811 S
42812 S
42831 S
42836 S
42907 S
42908 S
42909 S
42910 S
42911 S
42912 S
42913 S
42914 S
42915 S
42916 S
42917 S
42918 S
42919 S
42920 S
42921 S
42922 S
42923 S
42924 S
42925 S
42926 S
42927 S
42928 S
42929 S
42930 S
42931 S
42932 S
42933 S
42934 S
42935 S
42936 S
42937 S
42938 S
42939 S
42940 S
42941 S
42942 S
43002 S
43192 S
43193 S
43227 S
43234 S
43433 S