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 (
    52866, 53361, 53825, 53968, 54269, 54270, 
    54271, 54828, 54829, 54842, 54933, 
    54945, 54973, 54974, 54983, 55073, 
    55077, 55117, 55172, 55340, 55355, 
    55356, 55358, 55366, 55451, 55452, 
    55461, 55462, 55466, 55507, 55553, 
    55571, 55572, 55693, 55694, 55714, 
    55715, 55716, 55809, 119410
  )

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
52866 S
53361 S
53825 S
53968 S
54269 S
54270 S
54271 S
54828 S
54829 S
54842 S
54933 S
54945 S
54973 S
54974 S
54983 S
55073 S
55077 S
55117 S
55172 S
55340 S
55355 S
55356 S
55358 S
55366 S
55451 S
55452 S
55461 S
55462 S
55466 S
55507 S
55553 S
55571 S
55572 S
55693 S
55694 S
55714 S
55715 S
55716 S
55809 S
119410 S