SELECT 
  option_id, 
  option_type 
FROM 
  cscart_product_options 
WHERE 
  option_id IN (
    97, 98, 99, 117, 192, 193, 93, 94, 260, 
    270, 271, 89, 96, 95, 92, 87, 100, 102, 
    103, 88, 118, 190, 191, 86, 265, 266, 
    257, 299, 364, 473, 475, 476, 477, 478, 
    269, 85, 363, 474
  )

Query time 0.00075

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "26.61"
    },
    "table": {
      "table_name": "cscart_product_options",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "option_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 38,
      "rows_produced_per_join": 38,
      "filtered": "100.00",
      "index_condition": "(`cscartdb`.`cscart_product_options`.`option_id` in (97,98,99,117,192,193,93,94,260,270,271,89,96,95,92,87,100,102,103,88,118,190,191,86,265,266,257,299,364,473,475,476,477,478,269,85,363,474))",
      "cost_info": {
        "read_cost": "22.81",
        "eval_cost": "3.80",
        "prefix_cost": "26.61",
        "data_read_per_join": "86K"
      },
      "used_columns": [
        "option_id",
        "option_type"
      ]
    }
  }
}