Sandbox

SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'es' 
  AND lang.name IN (
    'vendor_directory.slow_fashion_directory', 
    'vendor_directory.about_the_directory', 
    'vendor_directory.about_the_directory_info', 
    'vendor_directory.filter_by', 'reset', 
    'vendor_directory.here', 'vendor_directory.want_to_register_with_us', 
    'vendor_directory.more', 'empty', 
    'vendor_directory.slow_fashion_directory', 
    'vendor_directory.about_the_directory', 
    'vendor_directory.about_the_directory_info', 
    'vendor_directory.filter_by', 'reset', 
    'vendor_directory.here', 'vendor_directory.want_to_register_with_us', 
    'vendor_directory.more', 'empty'
  )

Query time 0.00249

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "lang",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "392",
          "used_key_parts": ["lang_code", "name"],
          "rows": 9,
          "filtered": 100,
          "index_condition": "lang.lang_code = 'es' and lang.`name` in ('vendor_directory.slow_fashion_directory','vendor_directory.about_the_directory','vendor_directory.about_the_directory_info','vendor_directory.filter_by','reset','vendor_directory.here','vendor_directory.want_to_register_with_us','vendor_directory.more','empty','vendor_directory.slow_fashion_directory','vendor_directory.about_the_directory','vendor_directory.about_the_directory_info','vendor_directory.filter_by','reset','vendor_directory.here','vendor_directory.want_to_register_with_us','vendor_directory.more','empty')"
        }
      }
    ]
  }
}

Result

name	value
empty	Vacío
reset	Reset
vendor_directory.about_the_directory	About The Directory
vendor_directory.about_the_directory_info	Entro a una casa de la ciudad de México donde se confecciona un sueño. Ésta tarde se reúne un grupo de mujeres Toztzil Maya provenientes de Chenalhó Chiapas, que comparten su destreza, con algunos talleristas que desean mejorar su técnica de bordado La aventura de hacer ropa, generando moda ética con diseños vanguardistas, recuperando técnicas del bordado artesanal y materiales de textiles ecológicos, comenzó a desarrollarse. La aventura de hacer ropa, generando moda ética con diseños vanguardistas, recuperando técnicas del bordado artesanal y materiales de textiles ecológicos, comenzó a desarrollarse.
vendor_directory.filter_by	Filter by
vendor_directory.here	Here
vendor_directory.more	More
vendor_directory.slow_fashion_directory	Slow Fashion Directory
vendor_directory.want_to_register_with_us	Want To Register With Us?