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 (
    10310, 10311, 10312, 10313, 10314, 10315, 
    10316, 10317, 10319, 10320, 10321, 
    10322, 10324, 10325, 10326, 10327, 
    10328, 10329, 10330, 10331, 10344, 
    10360, 10372, 10379, 10381, 10382, 
    10385, 10387, 10389, 10445, 10452, 
    10464, 10465, 10475, 10476, 18471, 
    18478, 33875, 71392, 71393
  )

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 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
10310 S
10311 S
10312 S
10313 S
10314 S
10315 S
10316 S
10317 S
10319 S
10320 S
10321 S
10322 S
10324 S
10325 S
10326 S
10327 S
10328 S
10329 S
10330 S
10331 S
10344 S
10360 S
10372 S
10379 S
10381 S
10382 S
10385 S
10387 S
10389 S
10445 S
10452 S
10464 S
10465 S
10475 S
10476 S
18471 S
18478 S
33875 S
71392 S
71393 S