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 (
    220173, 339556, 254330, 339744, 339676, 
    339576, 339461, 391686, 339748, 392163, 
    387088, 339667, 339645, 151062, 339684, 
    151100, 254331, 339583, 387086, 339588, 
    339708, 387055, 339826, 339454, 339547, 
    339553, 339633, 387090, 339580, 339548, 
    339657, 339777, 339632, 339649, 339711, 
    339743, 339719, 339647, 339716, 339773, 
    339776, 387065, 339474, 339756, 339745, 
    339471, 387054, 265037, 339577, 339848, 
    339666, 339552, 339665, 339669, 339767, 
    339670, 387066, 339833, 339698, 339703, 
    220171, 339557, 339544, 339646, 339651, 
    339749, 339824, 339455, 339628, 339591, 
    387052, 339784, 339549, 339565, 339673, 
    339614, 339789, 339575, 339662, 265040, 
    339595, 339834, 339853, 339653, 339658, 
    339818, 339626, 339631, 339717, 339852, 
    339559, 339470, 339545, 339487, 339542, 
    339822, 339579, 339567, 271697, 339850
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00316

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "140.11"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 100,
      "rows_produced_per_join": 100,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "120.11",
        "eval_cost": "20.00",
        "prefix_cost": "140.11",
        "data_read_per_join": "169K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`webmarco`.`cscart_seo_names`.`object_id` in (220173,339556,254330,339744,339676,339576,339461,391686,339748,392163,387088,339667,339645,151062,339684,151100,254331,339583,387086,339588,339708,387055,339826,339454,339547,339553,339633,387090,339580,339548,339657,339777,339632,339649,339711,339743,339719,339647,339716,339773,339776,387065,339474,339756,339745,339471,387054,265037,339577,339848,339666,339552,339665,339669,339767,339670,387066,339833,339698,339703,220171,339557,339544,339646,339651,339749,339824,339455,339628,339591,387052,339784,339549,339565,339673,339614,339789,339575,339662,265040,339595,339834,339853,339653,339658,339818,339626,339631,339717,339852,339559,339470,339545,339487,339542,339822,339579,339567,271697,339850)) and (`webmarco`.`cscart_seo_names`.`type` = 'p') and (`webmarco`.`cscart_seo_names`.`dispatch` = '') and (`webmarco`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}