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 (
    450261, 416995, 446789, 426059, 409013, 
    414886, 444321, 406390, 408586, 425085, 
    413163, 415231, 429505, 404254, 401286, 
    447216, 440066, 456947, 406411, 404724, 
    416102, 419585, 417300, 439809, 410868, 
    452526, 440855, 429487, 429075, 407708, 
    457100, 449639, 427186, 437962, 413207, 
    434226, 413616, 400971, 429866, 439522, 
    404231, 420223, 402063, 434025, 453641, 
    414955, 407875, 430665
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00135

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.09438304,
    "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": 48,
          "cost": 0.09438304,
          "filtered": 100,
          "attached_condition": "cscart_seo_names.object_id in (450261,416995,446789,426059,409013,414886,444321,406390,408586,425085,413163,415231,429505,404254,401286,447216,440066,456947,406411,404724,416102,419585,417300,439809,410868,452526,440855,429487,429075,407708,457100,449639,427186,437962,413207,434226,413616,400971,429866,439522,404231,420223,402063,434025,453641,414955,407875,430665) 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
400971 classic-router-911 287/304/305
401286 classic-mixer-768 287/288/289
402063 classic-shirt-474 287/304/305
404231 classic-shirt-372 287/288/289
404254 classic-mixer-701 287/304/305
404724 classic-phone-379 287/304/305
406390 classic-mixer-153 287/288/289
406411 classic-phone-307 287/304/305
407708 classic-router-406 287/304/305
407875 classic-shirt-741 287/304/305
408586 classic-mixer-182 287/304/305
409013 classic-laptop-853 287/304/305
410868 classic-phone-910 287/304/305
413163 classic-mixer-344 287/304/305
413207 classic-router-746 287/288/289
413616 classic-router-878 287/304/305
414886 classic-laptop-886 287/288/289
414955 classic-shirt-553 287/288/289
415231 classic-mixer-415 287/304/305
416102 classic-phone-397 287/288/289
416995 classic-laptop-680 287/304/305
417300 classic-phone-734 287/304/305
419585 classic-phone-494 287/288/289
420223 classic-shirt-472 287/304/305
425085 classic-mixer-332 287/288/289
426059 classic-laptop-834 287/304/305
427186 classic-router-643 287/304/305
429075 classic-router-375 287/288/289
429487 classic-router-371 287/288/289
429505 classic-mixer-666 287/304/305
429866 classic-shirt-128 287/288/289
430665 classic-shirt-838 287/288/289
434025 classic-shirt-482 287/304/305
434226 classic-router-822 287/304/305
437962 classic-router-684 287/288/289
439522 classic-shirt-355 287/304/305
439809 classic-phone-756 287/288/289
440066 classic-mixer-867 287/288/289
440855 classic-router-324 287/304/305
444321 classic-laptop-889 287/288/289
446789 classic-laptop-753 287/288/289
447216 classic-mixer-805 287/288/289
449639 classic-router-641 287/304/305
450261 classic-laptop-421 287/288/289
452526 classic-phone-943 287/304/305
453641 classic-shirt-544 287/304/305
456947 classic-mixer-946 287/288/289
457100 classic-router-552 287/304/305