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 (
    40932, 40950, 40960, 41038, 41071, 41072, 
    41077, 41118, 41131, 41132, 41133, 
    41134, 41164, 41166, 41167, 41178, 
    41179, 41210, 41211, 41212, 41213, 
    41214, 41215, 41216, 41217, 41218, 
    41220, 41293, 41294, 41295, 41296, 
    41408, 41409, 41410, 41411, 41445, 
    41446, 41447, 41448, 41449, 41450, 
    41451, 41452, 41453, 41454, 41455, 
    41456, 41457, 41458, 41459, 41460, 
    41461, 41464, 41465, 41466, 41467, 
    41468, 41469, 41470, 41471, 41472, 
    41473, 41474, 41475, 41476, 41477, 
    41478, 41479, 41480, 41481, 41482, 
    41483, 41484, 41485, 41486, 41487, 
    41488, 41508, 41509, 41510
  )

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 80 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
40932 S
40950 S
40960 S
41038 S
41071 S
41072 S
41077 S
41118 S
41131 S
41132 S
41133 S
41134 S
41164 S
41166 S
41167 S
41178 S
41179 S
41210 S
41211 S
41212 S
41213 S
41214 S
41215 S
41216 S
41217 S
41218 S
41220 S
41293 S
41294 S
41295 S
41296 S
41408 S
41409 S
41410 S
41411 S
41445 S
41446 S
41447 S
41448 S
41449 S
41450 S
41451 S
41452 S
41453 S
41454 S
41455 S
41456 S
41457 S
41458 S
41459 S
41460 S
41461 S
41464 S
41465 S
41466 S
41467 S
41468 S
41469 S
41470 S
41471 S
41472 S
41473 S
41474 S
41475 S
41476 S
41477 S
41478 S
41479 S
41480 S
41481 S
41482 S
41483 S
41484 S
41485 S
41486 S
41487 S
41488 S
41508 S
41509 S
41510 S