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 (
    82556, 85583, 89595, 89596, 89597, 82336, 
    91936, 91970, 91973, 91985, 91986, 
    91987, 91988, 91989, 91990, 91991, 
    91969, 91971, 91972, 91974, 91975, 
    86810, 82557, 84045, 82369, 82375, 
    82357, 89590, 89589, 86806, 82560, 
    82565, 82569, 82573, 82562, 82566, 
    82570, 91968, 84289, 82555, 82553, 
    82391, 82554, 82559, 82552, 82564, 
    82568, 82572
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00062

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.63"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.83",
        "eval_cost": "4.80",
        "prefix_cost": "21.63",
        "data_read_per_join": "81K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (82556,85583,89595,89596,89597,82336,91936,91970,91973,91985,91986,91987,91988,91989,91990,91991,91969,91971,91972,91974,91975,86810,82557,84045,82369,82375,82357,89590,89589,86806,82560,82565,82569,82573,82562,82566,82570,91968,84289,82555,82553,82391,82554,82559,82552,82564,82568,82572)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}