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 (
    2764, 12676, 12655, 2831, 2832, 15312, 
    13836, 2844, 2679, 2669, 2683, 2680, 
    2675, 2674, 4357, 11901, 11902, 11919, 
    11906, 11662, 11903, 11661, 11907, 
    11908
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00051

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": 26,
      "filtered": 100,
      "index_condition": "cscart_seo_names.object_id in (2764,12676,12655,2831,2832,15312,13836,2844,2679,2669,2683,2680,2675,2674,4357,11901,11902,11919,11906,11662,11903,11661,11907,11908) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
    }
  }
}