SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'ar' 
  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.00118

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": "((`danishecarter_31jan`.`lang`.`lang_code` = 'ar') and (`danishecarter_31jan`.`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"
      ]
    }
  }
}