Sandbox

SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'en' 
  AND lang.name IN (
    'contact_information', 'text_multiprofile_notice', 
    'billing_address', 'shipping_address', 
    'shipping_address', 'billing_address', 
    'revert', 'delete_my_account_description', 
    'delete_my_account', 'delete_my_account', 
    'delete_my_account', 'usergroup', 
    'status', 'action', 'active', 'available', 
    'join', 'declined', 'join', 'pending', 
    'cancel', 'contact_information', 
    'text_multiprofile_notice', 'billing_address', 
    'shipping_address', 'shipping_address', 
    'billing_address', 'revert', 'delete_my_account_description', 
    'delete_my_account', 'delete_my_account', 
    'delete_my_account', 'usergroup', 
    'status', 'action', 'active', 'available', 
    'join', 'declined', 'join', 'pending', 
    'cancel'
  )

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "38.41"
    },
    "table": {
      "table_name": "lang",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "lang_code",
        "name"
      ],
      "key_length": "392",
      "rows_examined_per_scan": 16,
      "rows_produced_per_join": 16,
      "filtered": "100.00",
      "index_condition": "((`satishecarter_dec_setup_001`.`lang`.`lang_code` = 'en') and (`satishecarter_dec_setup_001`.`lang`.`name` in ('contact_information','text_multiprofile_notice','billing_address','shipping_address','shipping_address','billing_address','revert','delete_my_account_description','delete_my_account','delete_my_account','delete_my_account','usergroup','status','action','active','available','join','declined','join','pending','cancel','contact_information','text_multiprofile_notice','billing_address','shipping_address','shipping_address','billing_address','revert','delete_my_account_description','delete_my_account','delete_my_account','delete_my_account','usergroup','status','action','active','available','join','declined','join','pending','cancel')))",
      "cost_info": {
        "read_cost": "35.21",
        "eval_cost": "3.20",
        "prefix_cost": "38.41",
        "data_read_per_join": "6K"
      },
      "used_columns": [
        "lang_code",
        "name",
        "value"
      ]
    }
  }
}

Result

name	value
action	Action
active	Active
available	Available
billing_address	Billing address
cancel	Cancel
contact_information	Contact information
declined	Declined
delete_my_account	Delete my account
delete_my_account_description	<p>We’ll deactivate your account and remove all your personal data from it. After that you won’t be able to sign in. However, you’ll be able to register a new account with the same email address in the future. Please note that we’ll need some time to process this request, so your account won’t be deactivated immediately. If you have any comments regarding your request, please leave them in the field below.</p>
join	Join
pending	Pending
revert	Revert
shipping_address	Shipping address
status	Status
text_multiprofile_notice	One user can have multiple profiles. For example, one for personal orders and another for office needs.
usergroup	User group