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 (
    96894, 96895, 96896, 96897, 96898, 96899, 
    96900, 96901, 96902, 96903, 96904, 
    96905, 96906, 96907, 96908, 96909, 
    96910, 96911, 96912, 96913, 96914, 
    96915, 96916, 96969, 96970, 96971, 
    96972, 96973, 96974, 96975
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00113

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 (96894,96895,96896,96897,96898,96899,96900,96901,96902,96903,96904,96905,96906,96907,96908,96909,96910,96911,96912,96913,96914,96915,96916,96969,96970,96971,96972,96973,96974,96975)) 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
96894 aqven6228-p 7165/7168/7177
96895 aqven6229-p 7165/7168/7177
96896 aqven6230-p 7165/7168/7177
96897 aqven6231-p 7165/7168/7177
96898 aqven6232-p 7165/7168/7177
96899 aqven6233-p 7165/7168/7177
96900 aqven6234-p 7165/7168/7177
96901 aqven6235-p 7165/7168/7177
96902 aqven6236-p 7165/7168/7177
96903 aqven6237-p 7165/7168/7177
96904 aqven6238-p 7165/7168/7177
96905 aqven6239-p 7165/7168/7177
96906 aqven6240-p 7165/7168/7177
96907 aqven6241-p 7165/7168/7177
96908 aqven6242-p 7165/7168/7177
96909 aqven6243-p 7165/7168/7177
96910 aqven6244-p 7165/7168/7177
96911 aqven6245-p 7165/7168/7177
96912 aqven6246-p 7165/7168/7177
96913 aqven6247-p 7165/7168/7177
96914 aqven6248-p 7165/7168/7177
96915 aqven6249-p 7165/7168/7177
96916 aqven6250-p 7165/7168/7177
96969 aqven8159-p 7165/7168/7177
96970 aqven8160-p 7165/7168/7177
96971 aqven8161-p 7165/7168/7177
96972 aqven8162-p 7165/7168/7177
96973 aqven8163-p 7165/7168/7177
96974 aqven8164-p 7165/7168/7177
96975 aqven8165-p 7165/7168/7177