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 (
    55682, 55702, 55815, 57053, 57154, 57155, 
    57417, 57418, 57557, 57566, 57612, 
    57701, 57726, 57727, 57747, 57904, 
    57905, 57923, 57924, 57944, 57945, 
    57946, 57968, 58029, 58202, 58233, 
    58234, 58235, 58236, 58237, 58238, 
    58311, 58312, 58313, 58314, 58315, 
    58330, 58331, 58337, 58339
  )

Query time 0.00057

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
55682 S
55702 S
55815 S
57053 S
57154 S
57155 S
57417 S
57418 S
57557 S
57566 S
57612 S
57701 S
57726 S
57727 S
57747 S
57904 S
57905 S
57923 S
57924 S
57944 S
57945 S
57946 S
57968 S
58029 S
58202 S
58233 S
58234 S
58235 S
58236 S
58237 S
58238 S
58311 S
58312 S
58313 S
58314 S
58315 S
58330 S
58331 S
58337 S
58339 S