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 (
    42163, 42164, 42165, 42166, 42167, 42168, 
    42169, 42170, 42203, 42252, 42285, 
    42303, 42304, 42305, 42307, 42320, 
    42321, 42322, 42323, 42335, 42336, 
    42337, 42338, 42367, 42369, 42372, 
    42373, 42374, 42377, 42394, 42407, 
    42408, 42409, 42412, 42417, 42434, 
    42435, 42436, 42556, 42565, 42568, 
    42571, 42572, 42573, 42591, 42883, 
    42884, 42885, 42886, 42887, 42888, 
    42889, 42890, 42891, 42892, 42893, 
    42894, 42895, 42896, 42897, 42898, 
    42899, 42900, 42901, 42902, 42903, 
    42904, 42905, 42906, 65955, 65956, 
    65957, 65958, 85531, 85532, 85533, 
    85534, 85535, 85536, 85537
  )

Query time 0.00089

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
42163 S
42164 S
42165 S
42166 S
42167 S
42168 S
42169 S
42170 S
42203 S
42252 S
42285 S
42303 S
42304 S
42305 S
42307 S
42320 S
42321 S
42322 S
42323 S
42335 S
42336 S
42337 S
42338 S
42367 S
42369 S
42372 S
42373 S
42374 S
42377 S
42394 S
42407 S
42408 S
42409 S
42412 S
42417 S
42434 S
42435 S
42436 S
42556 S
42565 S
42568 S
42571 S
42572 S
42573 S
42591 S
42883 S
42884 S
42885 S
42886 S
42887 S
42888 S
42889 S
42890 S
42891 S
42892 S
42893 S
42894 S
42895 S
42896 S
42897 S
42898 S
42899 S
42900 S
42901 S
42902 S
42903 S
42904 S
42905 S
42906 S
65955 S
65956 S
65957 S
65958 S
85531 S
85532 S
85533 S
85534 S
85535 S
85536 S
85537 S