SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'en' 
  AND lang.name IN (
    'addons.rus_personal_data_processing.confidentiality_policy', 
    'addons.rus_personal_data_processing.get_confidentiality_policy', 
    'addons.rus_personal_data_processing.get_policy_text', 
    'addons.rus_personal_data_processing.use_confidentiality_policy', 
    'addons.rus_personal_data_processing.use_policy_text', 
    'addons.rus_personal_data_processing.link_web_site', 
    'addons.rus_personal_data_processing.web_site_text', 
    'addons.rus_personal_data_processing.safe', 
    'addons.rus_personal_data_processing.safe_text', 
    'addons.rus_personal_data_processing.conditions_policy', 
    'addons.rus_personal_data_processing.conditions_policy_text', 
    'addons.rus_personal_data_processing.confidentiality_policy', 
    'addons.rus_personal_data_processing.get_confidentiality_policy', 
    'addons.rus_personal_data_processing.get_policy_text', 
    'addons.rus_personal_data_processing.use_confidentiality_policy', 
    'addons.rus_personal_data_processing.use_policy_text', 
    'addons.rus_personal_data_processing.link_web_site', 
    'addons.rus_personal_data_processing.web_site_text', 
    'addons.rus_personal_data_processing.safe', 
    'addons.rus_personal_data_processing.safe_text', 
    'addons.rus_personal_data_processing.conditions_policy', 
    'addons.rus_personal_data_processing.conditions_policy_text'
  )

Query time 0.00073

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "26.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": 11,
      "rows_produced_per_join": 11,
      "filtered": "100.00",
      "index_condition": "((`cscart`.`lang`.`lang_code` = 'en') and (`cscart`.`lang`.`name` in ('addons.rus_personal_data_processing.confidentiality_policy','addons.rus_personal_data_processing.get_confidentiality_policy','addons.rus_personal_data_processing.get_policy_text','addons.rus_personal_data_processing.use_confidentiality_policy','addons.rus_personal_data_processing.use_policy_text','addons.rus_personal_data_processing.link_web_site','addons.rus_personal_data_processing.web_site_text','addons.rus_personal_data_processing.safe','addons.rus_personal_data_processing.safe_text','addons.rus_personal_data_processing.conditions_policy','addons.rus_personal_data_processing.conditions_policy_text','addons.rus_personal_data_processing.confidentiality_policy','addons.rus_personal_data_processing.get_confidentiality_policy','addons.rus_personal_data_processing.get_policy_text','addons.rus_personal_data_processing.use_confidentiality_policy','addons.rus_personal_data_processing.use_policy_text','addons.rus_personal_data_processing.link_web_site','addons.rus_personal_data_processing.web_site_text','addons.rus_personal_data_processing.safe','addons.rus_personal_data_processing.safe_text','addons.rus_personal_data_processing.conditions_policy','addons.rus_personal_data_processing.conditions_policy_text')))",
      "cost_info": {
        "read_cost": "24.21",
        "eval_cost": "2.20",
        "prefix_cost": "26.41",
        "data_read_per_join": "4K"
      },
      "used_columns": [
        "lang_code",
        "name",
        "value"
      ]
    }
  }
}

Result

name value
addons.rus_personal_data_processing.conditions_policy Changes in the Policy
addons.rus_personal_data_processing.conditions_policy_text The Company reserves the right to change this Policy. If any changes are made, the Company publishes the changes of the Policy on the Website. By continuing to use the services and Products of the Company, the User agrees with the changes and new conditions of the Policy.
addons.rus_personal_data_processing.confidentiality_policy Confidentiality Policy
addons.rus_personal_data_processing.get_confidentiality_policy Collecting Personal Data
addons.rus_personal_data_processing.get_policy_text The User may browse the Website without providing personal data; however, in some cases, when the User decides to buy Products of the Company (any software developed by the Company and distributed through the Website), the Company requests the User’s personal data.<br />The company has the right to request the following personal data from the User: first name, last name, company name (if applicable), postal address, phone number, email address, and other financial information mentioned on the Website.<br />Any information received automatically as a result of the User browsing the Website, including the order in which the pages were viewed, is listed without identifying specific Users. The Company uses cookies to make the Website more convenient for Users.
addons.rus_personal_data_processing.link_web_site Links to Other Websites
addons.rus_personal_data_processing.safe Security
addons.rus_personal_data_processing.safe_text The Company takes the appropriate measures to ensure security of the personal data of the User from loss, improper usage, unauthorized access, disclosure, and alteration. However, the method of passing the personal data and its storage in the Internet may not be fully secure; that’s why the Company can’t guarantee absolute security of personal data.
addons.rus_personal_data_processing.use_confidentiality_policy Using and Disclosing Personal Data
addons.rus_personal_data_processing.use_policy_text The Company uses the personal data of the User to provide services and Products, to settle disputes and solve problems, to improve the convenience of the Website, and to inform the User about new services and Products. By registering on the Website, the User agrees to receive information from the Company about the provided services, new versions and Products of the Company, as well as any other information the Company deems noteworthy.<br />The Company doesn’t sell or disclose the personal data of the User. The Company is allowed to disclose and provide personal data to third parties only if it is required by Russian or international legislation, or by the authorities, in line with the course of law.
addons.rus_personal_data_processing.web_site_text The Website contains links to other web-sites. The Company doesn’t control those web-sites and their confidentiality policies. The Company urges the User to familiarize themselves with the confidentiality policies of those web-sites before providing any personal data on those web-sites.