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 (
    99347, 99349, 99351, 99353, 99355, 99413, 
    99414, 99415, 99416, 99417, 99418, 
    99419, 99420, 99421, 99441, 99442, 
    99448, 99449, 99450, 99451, 99459, 
    99460, 99461, 99462, 99464, 99465, 
    99470, 99471, 99472, 99473
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00112

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "13.52"
    },
    "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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "10.52",
        "eval_cost": "3.00",
        "prefix_cost": "13.52",
        "data_read_per_join": "50K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (99347,99349,99351,99353,99355,99413,99414,99415,99416,99417,99418,99419,99420,99421,99441,99442,99448,99449,99450,99451,99459,99460,99461,99462,99464,99465,99470,99471,99472,99473)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
99347 npf1841-p 7170/7201
99349 npf2241-p 7170/7201
99351 npf2341-p 7170/7201
99353 npf2641-p 7170/7201
99355 npf2941-p 7170/7201
99413 nvf141-p 7170/7201
99414 nvf1441-p 7170/7201
99415 nvf2241-p 7170/7201
99416 nvf2541-p 7170/7201
99417 nvf2941-p 7170/7201
99418 nvf3041-p 7170/7201
99419 nvf541n-p 7170/7201
99420 nvf641n-p 7170/7201
99421 nvf841-p 7170/7201
99441 nvm141-p 7170/7201
99442 nvs142-p 7170/7201
99448 off145-p 7170/7201
99449 off146-p 7170/7201
99450 off147-p 7170/7201
99451 off148-p 7170/7201
99459 off3045-p 7170/7201
99460 off3046-p 7170/7201
99461 off3047-p 7170/7201
99462 off3048-p 7170/7201
99464 off3245-p 7170/7201
99465 off3247-p 7170/7201
99470 off545n-p 7170/7201
99471 off546n-p 7170/7201
99472 off547n-p 7170/7201
99473 off548n-p 7170/7201