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 (
    106030, 107274, 108087, 108615, 109762, 
    109972, 110513, 110747, 110855, 111006, 
    111301, 111986, 112201, 112202, 113068, 
    113978, 113988, 114508, 115229, 116172, 
    117041, 117168, 117747, 117785, 117973, 
    118016, 118325, 118442, 118479, 118497
  )

Query time 0.00077

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 30 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
106030 S
107274 S
108087 S
108615 S
109762 S
109972 S
110513 S
110747 S
110855 S
111006 S
111301 S
111986 S
112201 S
112202 S
113068 S
113978 S
113988 S
114508 S
115229 S
116172 S
117041 S
117168 S
117747 S
117785 S
117973 S
118016 S
118325 S
118442 S
118479 S
118497 S