SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'en' 
  AND lang.name IN (
    'gdpr.klaro_accept_all', 'gdpr.klaro_accept_selected', 
    'gdpr.klaro_close', 'gdpr.klaro_consent_modal_description', 
    'gdpr.klaro_consent_modal_title', 
    'gdpr.klaro_consent_notice_change_description', 
    'gdpr.klaro_consent_notice_title', 
    'gdpr.klaro_consent_notice_description', 
    'gdpr.klaro_consent_notice_learn_more', 
    'gdpr.klaro_consent_notice_testing', 
    'gdpr.klaro_contextual_consent_accept_always', 
    'gdpr.klaro_contextual_consent_accept_once', 
    'gdpr.klaro_contextual_consent_description', 
    'gdpr.klaro_decline', 'gdpr.klaro_ok', 
    'gdpr.klaro_powered_by', 'gdpr.klaro_privacy_policy_title', 
    'gdpr.klaro_privacy_policy_name', 
    'gdpr.klaro_service', 'gdpr.klaro_services', 
    'gdpr.strictly_necessary_cookies_title', 
    'gdpr.strictly_necessary_cookies_description', 
    'gdpr.performance_cookies_title', 
    'gdpr.performance_cookies_description', 
    'gdpr.functional_cookies_title', 
    'gdpr.functional_cookies_description', 
    'gdpr.marketing_cookies_title', 
    'gdpr.marketing_cookies_description', 
    'gdpr.klaro_service_purpose', 'gdpr.klaro_service_purposes', 
    'gdpr.klaro_service_required_description', 
    'gdpr.eway_cookies_title', 'gdpr.eway_cookies_description', 
    'gdpr.disable_all_description', 
    'gdpr.disable_all_title', 'gdpr.opt_out_description', 
    'gdpr.opt_out_title', 'gdpr.klaro_service_required_title', 
    'gdpr.uk_cookies_law', 'gdpr.site_functionality_cookies_title', 
    'gdpr.site_functionality_cookies_description', 
    'gdpr.klaro_accept_all', 'gdpr.klaro_accept_selected', 
    'gdpr.klaro_close', 'gdpr.klaro_consent_modal_description', 
    'gdpr.klaro_consent_modal_title', 
    'gdpr.klaro_consent_notice_change_description', 
    'gdpr.klaro_consent_notice_title', 
    'gdpr.klaro_consent_notice_description', 
    'gdpr.klaro_consent_notice_learn_more', 
    'gdpr.klaro_consent_notice_testing', 
    'gdpr.klaro_contextual_consent_accept_always', 
    'gdpr.klaro_contextual_consent_accept_once', 
    'gdpr.klaro_contextual_consent_description', 
    'gdpr.klaro_decline', 'gdpr.klaro_ok', 
    'gdpr.klaro_powered_by', 'gdpr.klaro_privacy_policy_title', 
    'gdpr.klaro_privacy_policy_name', 
    'gdpr.klaro_service', 'gdpr.klaro_services', 
    'gdpr.strictly_necessary_cookies_title', 
    'gdpr.strictly_necessary_cookies_description', 
    'gdpr.performance_cookies_title', 
    'gdpr.performance_cookies_description', 
    'gdpr.functional_cookies_title', 
    'gdpr.functional_cookies_description', 
    'gdpr.marketing_cookies_title', 
    'gdpr.marketing_cookies_description', 
    'gdpr.klaro_service_purpose', 'gdpr.klaro_service_purposes', 
    'gdpr.klaro_service_required_description', 
    'gdpr.eway_cookies_title', 'gdpr.eway_cookies_description', 
    'gdpr.disable_all_description', 
    'gdpr.disable_all_title', 'gdpr.opt_out_description', 
    'gdpr.opt_out_title', 'gdpr.klaro_service_required_title', 
    'gdpr.uk_cookies_law', 'gdpr.site_functionality_cookies_title', 
    'gdpr.site_functionality_cookies_description'
  )

Query time 0.00078

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "98.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": 41,
      "rows_produced_per_join": 41,
      "filtered": "100.00",
      "index_condition": "((`satishecarter_dec_setup_001`.`lang`.`lang_code` = 'en') and (`satishecarter_dec_setup_001`.`lang`.`name` in ('gdpr.klaro_accept_all','gdpr.klaro_accept_selected','gdpr.klaro_close','gdpr.klaro_consent_modal_description','gdpr.klaro_consent_modal_title','gdpr.klaro_consent_notice_change_description','gdpr.klaro_consent_notice_title','gdpr.klaro_consent_notice_description','gdpr.klaro_consent_notice_learn_more','gdpr.klaro_consent_notice_testing','gdpr.klaro_contextual_consent_accept_always','gdpr.klaro_contextual_consent_accept_once','gdpr.klaro_contextual_consent_description','gdpr.klaro_decline','gdpr.klaro_ok','gdpr.klaro_powered_by','gdpr.klaro_privacy_policy_title','gdpr.klaro_privacy_policy_name','gdpr.klaro_service','gdpr.klaro_services','gdpr.strictly_necessary_cookies_title','gdpr.strictly_necessary_cookies_description','gdpr.performance_cookies_title','gdpr.performance_cookies_description','gdpr.functional_cookies_title','gdpr.functional_cookies_description','gdpr.marketing_cookies_title','gdpr.marketing_cookies_description','gdpr.klaro_service_purpose','gdpr.klaro_service_purposes','gdpr.klaro_service_required_description','gdpr.eway_cookies_title','gdpr.eway_cookies_description','gdpr.disable_all_description','gdpr.disable_all_title','gdpr.opt_out_description','gdpr.opt_out_title','gdpr.klaro_service_required_title','gdpr.uk_cookies_law','gdpr.site_functionality_cookies_title','gdpr.site_functionality_cookies_description','gdpr.klaro_accept_all','gdpr.klaro_accept_selected','gdpr.klaro_close','gdpr.klaro_consent_modal_description','gdpr.klaro_consent_modal_title','gdpr.klaro_consent_notice_change_description','gdpr.klaro_consent_notice_title','gdpr.klaro_consent_notice_description','gdpr.klaro_consent_notice_learn_more','gdpr.klaro_consent_notice_testing','gdpr.klaro_contextual_consent_accept_always','gdpr.klaro_contextual_consent_accept_once','gdpr.klaro_contextual_consent_description','gdpr.klaro_decline','gdpr.klaro_ok','gdpr.klaro_powered_by','gdpr.klaro_privacy_policy_title','gdpr.klaro_privacy_policy_name','gdpr.klaro_service','gdpr.klaro_services','gdpr.strictly_necessary_cookies_title','gdpr.strictly_necessary_cookies_description','gdpr.performance_cookies_title','gdpr.performance_cookies_description','gdpr.functional_cookies_title','gdpr.functional_cookies_description','gdpr.marketing_cookies_title','gdpr.marketing_cookies_description','gdpr.klaro_service_purpose','gdpr.klaro_service_purposes','gdpr.klaro_service_required_description','gdpr.eway_cookies_title','gdpr.eway_cookies_description','gdpr.disable_all_description','gdpr.disable_all_title','gdpr.opt_out_description','gdpr.opt_out_title','gdpr.klaro_service_required_title','gdpr.uk_cookies_law','gdpr.site_functionality_cookies_title','gdpr.site_functionality_cookies_description')))",
      "cost_info": {
        "read_cost": "90.21",
        "eval_cost": "8.20",
        "prefix_cost": "98.41",
        "data_read_per_join": "16K"
      },
      "used_columns": [
        "lang_code",
        "name",
        "value"
      ]
    }
  }
}

Result

name value
gdpr.disable_all_description Use this switch to enable or disable all services.
gdpr.disable_all_title Enable or disable all services
gdpr.eway_cookies_description eWAY is a payment provider. It allows us to accept payments, if you choose a payment method powered by eWAY. Here is <a href="https://www.eway.com.au/privacy-policy/" target="_blank">eWAY privacy policy</a>.
gdpr.eway_cookies_title eWAY
gdpr.functional_cookies_description These cookies enable additional functionality at the website. They may be set by third-party providers whose services we've added to the website. Those services may include many things, like maps, geolocation for preliminary shipping rate calculation, or the ability to sign in with your social network account. Without functional cookies, the parts of the site associated with these services may not work properly.
gdpr.functional_cookies_title Functional cookies
gdpr.klaro_accept_all Accept all
gdpr.klaro_accept_selected Accept selected
gdpr.klaro_close Close
gdpr.klaro_consent_modal_description Here you can assess and customize the services (and their respective cookies) that we'd like to use on this website. You're in charge! Enable or disable services as you see fit.
gdpr.klaro_consent_modal_title Cookies we would like to use
gdpr.klaro_consent_notice_change_description There were changes since your last visit, please renew your consent.
gdpr.klaro_consent_notice_description Hi! Could we please enable some additional services that require cookies? You can always change or withdraw your consent later.
gdpr.klaro_consent_notice_learn_more Let me choose
gdpr.klaro_consent_notice_testing Testing mode!
gdpr.klaro_consent_notice_title Cookie Consent
gdpr.klaro_contextual_consent_accept_always Always
gdpr.klaro_contextual_consent_accept_once 'Yes'
gdpr.klaro_contextual_consent_description Do you want to load external content supplied by {title}?
gdpr.klaro_decline I decline
gdpr.klaro_ok That's ok
gdpr.klaro_powered_by Realized with Klaro!
gdpr.klaro_privacy_policy_name Privacy policy
gdpr.klaro_privacy_policy_title You can find out more in this document: {privacyPolicy}.
gdpr.klaro_service service
gdpr.klaro_services services
gdpr.klaro_service_purpose purpose
gdpr.klaro_service_purposes purposes
gdpr.klaro_service_required_description This service is always required
gdpr.klaro_service_required_title (always required)
gdpr.marketing_cookies_description These cookies are used by our advertising partners. They help them to measure promotion efficiency and serve you ads that are more relevant and less repetitive. This is usually achieved by remembering the browser and device that saw the ad. Turning these cookies off won't reduce the number of ads you see on the internet, but will make them less personalized.
gdpr.marketing_cookies_title Marketing cookies
gdpr.opt_out_description This service is enabled by default (but you can opt out)
gdpr.opt_out_title (opt-out)
gdpr.performance_cookies_description These cookies allow us to see how the website works. The information that these cookies help to collect is anonymous; it is typically presented in numbers. For example, these cookies help us see how often errors occur, how many unique visitors we have, or how long each page is viewed on average. Thanks to these cookies, we can improve the site for you.
gdpr.performance_cookies_title Performance cookies
gdpr.site_functionality_cookies_description These cookies serve the essential functions of the site. For example, they help the site remember that you put something in the cart or signed into your account.
gdpr.site_functionality_cookies_title Site functionality
gdpr.strictly_necessary_cookies_description These cookies are essential for the website to work properly. For example, they let you place an order, or help the site remember that you've signed into your account. That's why they can't be disabled through the site. You can configure your browser to disable even these cookies, but important parts of the site won't work without them.
gdpr.strictly_necessary_cookies_title Strictly necessary cookies
gdpr.uk_cookies_law Cookies are used on this site to provide the best user experience. If you continue, we assume that you agree to receive cookies from this site.