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 (
    33862, 33891, 33892, 33893, 33894, 33895, 
    33896, 33941, 33942, 33943, 33944, 
    33953, 33954, 33955, 33956, 33957, 
    33958, 33959, 33960, 33961, 33962, 
    33963, 33964, 33965, 33966, 33967, 
    33968, 33969, 33970, 33972, 34007, 
    34008, 34046, 34047, 34048, 34069, 
    34070, 34077, 34081, 34082, 34085, 
    34086, 34087, 34088, 34089, 34092, 
    34133, 34138, 34139, 34151, 34193, 
    34197, 34198, 34199, 34201, 34203, 
    34205, 34206, 34207, 34209, 34213, 
    34259, 34316, 34317, 34441, 34444, 
    34519, 35072, 35073, 35074, 35075, 
    35076, 35077, 35078, 66017, 66018, 
    66019, 66020, 74817, 74840
  )

Query time 0.00088

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
33862 S
33891 S
33892 S
33893 S
33894 S
33895 S
33896 S
33941 S
33942 S
33943 S
33944 S
33953 S
33954 S
33955 S
33956 S
33957 S
33958 S
33959 S
33960 S
33961 S
33962 S
33963 S
33964 S
33965 S
33966 S
33967 S
33968 S
33969 S
33970 S
33972 S
34007 S
34008 S
34046 S
34047 S
34048 S
34069 S
34070 S
34077 S
34081 S
34082 S
34085 S
34086 S
34087 S
34088 S
34089 S
34092 S
34133 S
34138 S
34139 S
34151 S
34193 S
34197 S
34198 S
34199 S
34201 S
34203 S
34205 S
34206 S
34207 S
34209 S
34213 S
34259 S
34316 S
34317 S
34441 S
34444 S
34519 S
35072 S
35073 S
35074 S
35075 S
35076 S
35077 S
35078 S
66017 S
66018 S
66019 S
66020 S
74817 S
74840 S