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 (
    4845, 4516, 4521, 4676, 4520, 4587, 5094, 
    5075, 5074, 5068, 5350, 5082, 4708, 
    4707, 4706, 4652, 4627, 4628, 4651, 
    4677, 4679, 4678, 5070, 4344
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ru'

Query time 0.00174

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "PRIMARY",
      "key_length": "206",
      "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
      "rows": 24,
      "filtered": 75,
      "index_condition": "cscart_seo_names.object_id in (4845,4516,4521,4676,4520,4587,5094,5075,5074,5068,5350,5082,4708,4707,4706,4652,4627,4628,4651,4677,4679,4678,5070,4344) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'ru'"
    }
  }
}