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 (
    415843, 426635, 454483, 442900, 441777, 
    426668, 454832, 445457, 454320, 455896, 
    403718, 460902, 408640, 423654, 437901, 
    451860, 447040, 402866, 419169, 440094, 
    409667, 433404, 420606, 408565
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00101

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.04756928,
    "nested_loop": [
      {
        "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"],
          "loops": 1,
          "rows": 24,
          "cost": 0.04756928,
          "filtered": 100,
          "attached_condition": "cscart_seo_names.object_id in (415843,426635,454483,442900,441777,426668,454832,445457,454320,455896,403718,460902,408640,423654,437901,451860,447040,402866,419169,440094,409667,433404,420606,408565) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id seo_name seo_path
402866 eco-mixer-711 219/495
403718 eco-mixer-249 203/500
408565 eco-mixer-958 287/288/289
408640 eco-mixer-272 219/495
409667 eco-mixer-844 287/288/289
415843 eco-laptop-584 287/288/289
419169 eco-mixer-776 287/304/305
420606 eco-mixer-883 219/498
423654 eco-mixer-377 203/500
426635 eco-laptop-590 219/495
426668 eco-laptop-804 203/500
433404 eco-mixer-851 219/495
437901 eco-mixer-559 203/500
440094 eco-mixer-811 219/495
441777 eco-laptop-758 203/500
442900 eco-laptop-713 219/495
445457 eco-mixer-121 219/495
447040 eco-mixer-677 287/304/305
451860 eco-mixer-576 287/304/305
454320 eco-mixer-201 219/498
454483 eco-laptop-711 203/500
454832 eco-mixer-113 203/500
455896 eco-mixer-215 203/500
460902 eco-mixer-258 287/288/289