Sandbox

SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'tr' 
  AND lang.name IN (
    'profile_details', 'downloads', 'orders', 
    'view_comparison_list', 'track_my_order', 
    'track_my_order', 'order_id', 'email', 
    'go', 'go_to_admin_panel', 'sign_out', 
    'sign_in', 'register', 'sign_in', 
    'profile_details', 'downloads', 
    'orders', 'view_comparison_list', 
    'track_my_order', 'track_my_order', 
    'order_id', 'email', 'go', 'go_to_admin_panel', 
    'sign_out', 'sign_in', 'register', 
    'sign_in'
  )

Query time 0.00045

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

Result

name	value
downloads	Üye Ol
email	E-posta
go	Gİt
go_to_admin_panel	Admin panel
orders	Tamamlanan Siparişler
order_id	Sipariş Nr
profile_details	Üye Girişi
register	Üye ol
sign_in	Giriş
sign_out	Çıkış
track_my_order	Sipariş takibi
view_comparison_list	Karşılaştırma listesi