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 (
    461277, 461276, 461275, 461274, 461273, 
    461272, 461271, 461270, 461269, 461268, 
    461267, 461266, 461265, 461264, 461263, 
    461262, 461261, 461260, 461259, 461258, 
    461257, 461256, 461255, 461254, 461253, 
    461252, 461251, 461250, 461249, 461248, 
    461247, 461246, 461245, 461244, 461243, 
    461242, 461218, 461039, 461038, 461037, 
    461036, 461035, 461034, 461033, 461032, 
    461031, 461030, 461029, 461026, 461025, 
    461022, 461020, 461018, 461017, 461013, 
    461010, 461009, 461008, 460961, 460958, 
    460957, 460955, 460952, 460951, 460948, 
    460947, 460946, 460918, 460921, 460936, 
    460804, 460816, 460828, 460835, 460856, 
    460859, 460861, 460869, 460870, 460873, 
    460888, 460902, 460734, 460754, 460758, 
    460765, 460774, 460778, 460795, 460638, 
    460693, 460698, 460504, 460515, 460518, 
    460521
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00086

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 (461277,461276,461275,461274,461273,461272,461271,461270,461269,461268,461267,461266,461265,461264,461263,461262,461261,461260,461259,461258,461257,461256,461255,461254,461253,461252,461251,461250,461249,461248,461247,461246,461245,461244,461243,461242,461218,461039,461038,461037,461036,461035,461034,461033,461032,461031,461030,461029,461026,461025,461022,461020,461018,461017,461013,461010,461009,461008,460961,460958,460957,460955,460952,460951,460948,460947,460946,460918,460921,460936,460804,460816,460828,460835,460856,460859,460861,460869,460870,460873,460888,460902,460734,460754,460758,460765,460774,460778,460795,460638,460693,460698,460504,460515,460518,460521) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
        }
      }
    ]
  }
}