SELECT 
  cscart_seo_names.object_id AS product_id, 
  cscart_seo_names.name AS seo_name, 
  cscart_seo_names.path AS seo_path 
FROM 
  cscart_seo_names 
WHERE 
  cscart_seo_names.object_id IN (
    9982, 9923, 21325, 32298, 10997, 32872, 
    21326, 31794, 32348, 11084, 11049, 
    11073, 32345, 13201, 32341, 13255, 
    13203, 13218, 13200, 32333, 33025, 
    13229, 33810, 13195, 33014, 6615, 13205, 
    33157, 18220, 18205, 18198, 18197, 
    18216, 11080, 18210, 60881, 18219, 
    18222, 18212, 18196, 18217, 33000, 
    18202, 18206, 18224, 18208, 18201, 
    36477, 18203, 18213
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00219

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "38.16"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 57,
      "rows_produced_per_join": 57,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (9982,9923,21325,32298,10997,32872,21326,31794,32348,11084,11049,11073,32345,13201,32341,13255,13203,13218,13200,32333,33025,13229,33810,13195,33014,6615,13205,33157,18220,18205,18198,18197,18216,11080,18210,60881,18219,18222,18212,18196,18217,33000,18202,18206,18224,18208,18201,36477,18203,18213)) and (`cscartdb`.`cscart_seo_names`.`type` = 'p') and (`cscartdb`.`cscart_seo_names`.`dispatch` = '') and (`cscartdb`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "32.46",
        "eval_cost": "5.70",
        "prefix_cost": "38.16",
        "data_read_per_join": "96K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}