Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (63755, 62252, 62253) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00028

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (63755,62252,62253) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
62252	replacement glass, jelly jar replacement, vapor proof light parts, clear glass jelly jar	Replace your broken vapor proof glass jar with our replacement jelly jar in clear glass. Receive free shipping with your replacement glass jar.	replacement glass, light parts, jelly jar, individual jelly jar, replacement jelly jar, replacement jar, vapor jar replacement, individual vapor jar, Clear Jelly Jar Glass, BLE-CGG-GLASS-CLR, clear glass replacement, replacement clear jelly jar
62253	replacement jelly jar, cast guard and glass parts, jelly jar with frosted glass, industrial light parts	Shop for replacement frosted glass jelly jars from our selection of threaded glass!	replacement glass, light parts, jelly jar, individual jelly jar, replacement jelly jar, replacement jar, vapor jar replacement, individual vapor jar, Frosted Jelly Jar Glass, replacement frosted jelly jar, BLE-CGG-GLASS-FST
63755		Swap out broken or damaged schoolhouse shades with these fashionable replacements. Customize these glass globes with hand-painted stripes!	BLE-SCH-GLASS, Opaque Schoolhouse Glass, Opaque Schoolhouse Glass Shade, Opaque Schoolhouse Glass shades, schoolhouse glass shade, schoolhouse glass shades, schoolhouse shade, schoolhouse shades, replacement, replacement shade, replacement shades, replacement glass shade, replacement glass shades, replacement schoolhouse, replacement schoolhouse shade, replacement schoolhouse shades, school house, schoolhouse, school house shade, school house shades, replacement school house shade, replacement school house shades, schoolhouse globe, schoolhouse globes, school house globe, school house globes, replacement school house globe, replacement school house globes, replacement opaque shade, replacement opaque shades, replacement Opaque Schoolhouse Glass, replacement Opaque Schoolhouse Glass shade, replacement Opaque Schoolhouse Glass shades, replacement glass, replacement globes, striped schoolhouse, striped schoolhouse light,