SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'ko' 
  AND lang.name IN (
    'sd_google_analytics.gtag_cookies_title', 
    'sd_google_analytics.gtag_cookies_description', 
    'sd_google_analytics.gtag_cookies_title', 
    'sd_google_analytics.gtag_cookies_description'
  )

Query time 0.00016

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "lang",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "392",
      "used_key_parts": ["lang_code", "name"],
      "rows": 2,
      "filtered": 100,
      "index_condition": "lang.lang_code = 'ko' and lang.`name` in ('sd_google_analytics.gtag_cookies_title','sd_google_analytics.gtag_cookies_description','sd_google_analytics.gtag_cookies_title','sd_google_analytics.gtag_cookies_description')"
    }
  }
}

Result

name value
sd_google_analytics.gtag_cookies_description Google Analytics is a simple yet effective instrument to provide the user behaviour tracking on our site. We synchronize these data with our Google Analytics account to analyze it and make our site more comfortable and user friendly. Here is <a href="https://policies.google.com/privacy" target="_blank">Google privacy policy;</a> we also recommend Google's concise and comprehensive <a href="https://support.google.com/analytics/answer/6004245" target="_blank">note on privacy</a>.
sd_google_analytics.gtag_cookies_title Google Analytics