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'"
        }
      }
    ]
  }
}