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 (
    9453, 9454, 9455, 9456, 9457, 9458, 9459, 
    9460, 9461, 9462, 9463, 9464, 9465, 
    9466, 9467, 9468, 9469, 9470, 9471, 
    9472, 9473, 9474, 9475, 9476, 9477, 
    9478, 9479, 9480, 9481, 9488, 9492, 
    9531, 9532, 9534, 9535, 9536, 9537, 
    9538, 9539, 9540
  )

Query time 0.00043

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
9453 S
9454 S
9455 S
9456 S
9457 S
9458 S
9459 S
9460 S
9461 S
9462 S
9463 S
9464 S
9465 S
9466 S
9467 S
9468 S
9469 S
9470 S
9471 S
9472 S
9473 S
9474 S
9475 S
9476 S
9477 S
9478 S
9479 S
9480 S
9481 S
9488 S
9492 S
9531 S
9532 S
9534 S
9535 S
9536 S
9537 S
9538 S
9539 S
9540 S