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 (
    418069, 445198, 411240, 422817, 423808, 
    415217, 426276, 436126, 447490, 423364, 
    434857, 413139, 447321, 401174, 414674, 
    415838, 449270, 446080, 448955, 431392, 
    437836, 458853, 450047, 448348, 413081, 
    437392, 451197, 439162, 456958, 421530, 
    440029, 438251, 412981, 444999, 454857, 
    440645, 405789, 437993, 452275, 425655, 
    417942, 409696, 430996, 428294, 445807, 
    448196, 443895, 446957, 426562, 446627, 
    409567, 403223, 456812, 416073, 444305, 
    414771, 405344, 428114, 460638, 435197, 
    412021, 450932, 405246, 430164, 444428, 
    428029, 441949, 460434, 433652, 426548, 
    416330, 447518, 427542, 408429, 447154, 
    419276, 421080, 437947, 413185, 419295, 
    403213, 403380, 408359, 409393, 430349, 
    453094, 411903, 422798, 422092, 433129, 
    424917, 459596, 425363, 441519, 434875, 
    460167
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00210

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.18879416,
    "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": 96,
          "cost": 0.18879416,
          "filtered": 100,
          "attached_condition": "cscart_seo_names.object_id in (418069,445198,411240,422817,423808,415217,426276,436126,447490,423364,434857,413139,447321,401174,414674,415838,449270,446080,448955,431392,437836,458853,450047,448348,413081,437392,451197,439162,456958,421530,440029,438251,412981,444999,454857,440645,405789,437993,452275,425655,417942,409696,430996,428294,445807,448196,443895,446957,426562,446627,409567,403223,456812,416073,444305,414771,405344,428114,460638,435197,412021,450932,405246,430164,444428,428029,441949,460434,433652,426548,416330,447518,427542,408429,447154,419276,421080,437947,413185,419295,403213,403380,408359,409393,430349,453094,411903,422798,422092,433129,424917,459596,425363,441519,434875,460167) 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
401174 lite-book-955 287/304/305
403213 lite-sneakers-896 287/304/305
403223 lite-laptop-334 287/304/305
403380 lite-sofa-200 287/304/305
405246 lite-router-205 287/304/305
405344 lite-mixer-486 287/304/305
405789 lite-drone-456 287/304/305
408359 lite-sofa-519 287/304/305
408429 lite-shirt-313 287/304/305
409393 lite-sofa-808 287/304/305
409567 lite-laptop-263 287/304/305
409696 lite-grinder-932 287/304/305
411240 lite-backpack-280 287/304/305
411903 lite-watch-182 287/304/305
412021 lite-phone-696 287/304/305
412981 lite-chair-979 287/304/305
413081 lite-camera-667 287/304/305
413139 lite-book-718 287/304/305
413185 lite-sneakers-290 287/304/305
414674 lite-bottle-100 287/304/305
414771 lite-mixer-440 287/304/305
415217 lite-backpack-696 287/304/305
415838 lite-bottle-306 287/304/305
416073 lite-laptop-594 287/304/305
416330 lite-router-877 287/304/305
417942 lite-grinder-840 287/304/305
418069 lite-backpack-150 287/304/305
419276 lite-shirt-716 287/304/305
419295 lite-sneakers-564 287/304/305
421080 lite-shirt-717 287/304/305
421530 lite-chair-222 287/304/305
422092 max-backpack-491 287/304/305
422798 lite-watch-479 287/304/305
422817 lite-backpack-530 287/304/305
423364 lite-book-483 287/304/305
423808 lite-backpack-576 287/304/305
424917 max-book-477 287/304/305
425363 max-book-609 287/304/305
425655 lite-grinder-303 287/304/305
426276 lite-backpack-728 287/304/305
426548 lite-router-699 287/304/305
426562 lite-headphones-807 287/304/305
427542 lite-shirt-229 287/304/305
428029 lite-router-331 287/304/305
428114 lite-mixer-634 287/304/305
428294 lite-headphones-156 287/304/305
430164 lite-router-255 287/304/305
430349 lite-sofa-821 287/304/305
430996 lite-grinder-948 287/304/305
431392 lite-camera-175 287/304/305
433129 max-backpack-775 287/304/305
433652 lite-router-557 287/304/305
434857 lite-book-588 287/304/305
434875 max-book-868 287/304/305
435197 lite-phone-684 287/304/305
436126 lite-backpack-942 287/304/305
437392 lite-camera-710 287/304/305
437836 lite-camera-213-en 287/304/305
437947 lite-sneakers-188 287/304/305
437993 lite-grinder-168 287/304/305
438251 lite-chair-369 287/304/305
439162 lite-camera-948 287/304/305
440029 lite-chair-226 287/304/305
440645 lite-drone-342 287/304/305
441519 max-book-612 287/304/305
441949 lite-router-362 287/304/305
443895 lite-headphones-517 287/304/305
444305 lite-laptop-781 287/304/305
444428 lite-router-302 287/304/305
444999 lite-drone-132 287/304/305
445198 lite-backpack-190 287/304/305
445807 lite-headphones-257 287/304/305
446080 lite-bottle-774 287/304/305
446627 lite-laptop-257 287/304/305
446957 lite-headphones-730 287/304/305
447154 lite-shirt-702 287/304/305
447321 lite-book-763 287/304/305
447490 lite-book-135 287/304/305
447518 lite-shirt-114 287/304/305
448196 lite-headphones-424 287/304/305
448348 lite-camera-583 287/304/305
448955 lite-bottle-968 287/304/305
449270 lite-bottle-563 287/304/305
450047 lite-camera-568 287/304/305
450932 lite-router-128 287/304/305
451197 lite-camera-749 287/304/305
452275 lite-grinder-266 287/304/305
453094 lite-sofa-900 287/304/305
454857 lite-drone-222 287/304/305
456812 lite-laptop-409 287/304/305
456958 lite-chair-153 287/304/305
458853 lite-camera-303 287/304/305
459596 max-book-549 287/304/305
460167 max-bottle-429 287/304/305
460434 lite-router-448 287/304/305
460638 lite-mixer-946 287/304/305