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 (
    119174, 119175, 119176, 119177, 119178, 
    119179, 119180, 119181, 119182, 119183, 
    119184, 119185, 119186, 119187, 119188, 
    119189, 119190, 119191, 119192, 120649
  )

Query time 0.00035

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 20 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
119174 S
119175 S
119176 S
119177 S
119178 S
119179 S
119180 S
119181 S
119182 S
119183 S
119184 S
119185 S
119186 S
119187 S
119188 S
119189 S
119190 S
119191 S
119192 S
120649 S