SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'tr' 
  AND lang.name IN (
    'wk_select_service', 'welcome_text', 
    'wk_chatbot_error_text', 'query_submitted', 
    'wk_submit_query_text', 'wk_submit_query_mail', 
    'wk_submit_query_message', 'wk_select_service', 
    'welcome_text', 'wk_chatbot_error_text', 
    'query_submitted', 'wk_submit_query_text', 
    'wk_submit_query_mail', 'wk_submit_query_message'
  )

Query time 0.00020

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE lang range PRIMARY PRIMARY 392 7 Using index condition