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 (
    9545, 9554, 9555, 9630, 9631, 9632, 9633, 
    9634, 9635, 9636, 9637, 9638, 9639, 
    9640, 9641, 9642, 9643, 9644, 9645, 
    9647, 9648, 9649, 9650, 9651, 9677, 
    11788, 26520, 26521, 26522, 26523, 
    26524, 26525, 26526, 26527, 26528, 
    26529, 26530, 26531, 26532, 26533
  )

Query time 0.00064

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
9545 S
9554 S
9555 S
9630 S
9631 S
9632 S
9633 S
9634 S
9635 S
9636 S
9637 S
9638 S
9639 S
9640 S
9641 S
9642 S
9643 S
9644 S
9645 S
9647 S
9648 S
9649 S
9650 S
9651 S
9677 S
11788 S
26520 S
26521 S
26522 S
26523 S
26524 S
26525 S
26526 S
26527 S
26528 S
26529 S
26530 S
26531 S
26532 S
26533 S