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 (64340, 61387, 61388, 64339) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64340,61387,61388,64339) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61387	long gooseneck arm, double gooseneck arm, heavy duty wall mount arm, dual mount gooseneck arm. commercial gooseneck arm	The G40 gooseneck arm has a double arm for extra support in high wind and snow load locations. Designed to be used with large lamp shades.	G-40, gooseneck arm, heavy duty gooseneck arm, double arm gooseneck, G40, arm, Heavy Duty Double Gooseneck Arm, gooseneck arm dimensions, gooseneck options,
61388	oversized gooseneck arm, garage lighting, barn lighting, long gooseneck arm, double gooseneck arm, heavy duty wall mount arm, flexible gooseneck arm	G36 gooseneck arm has a 49.7 inch projection is designed for use with large lamp shades. Adjustable second arm provides support with flexibility in mounting height.	G-36, G36, gooseneck arm, heavy duty gooseneck arm, double arm gooseneck, adjustable gooseneck arm, arm, g-36, g36, gooseneck arm dimensions, gooseneck options,
64339	G64, gooseneck arm, gooseneck, basic arm, 23 inch, chain mount gooseneck, chain gooseneck,		G64, G64 Gooseneck, G64 Arm, BLE-G64, G-64, arm, gooseneck arm, g-64, g64, Gooseneck light with chain, Gooseneck mount with chain, Gooseneck with a chain, Goosenecks with a chain, 22.9" Projection gooseneck, 22.9" Projection, 22" Projection, 23" Projection, gooseneck options,
64340	G65, gooseneck arm, gooseneck, basic arm, 29 inch, chain mount gooseneck, chain gooseneck,		G65, G65 Gooseneck, G65 Arm, BLE-G65, G-65, arm, gooseneck arm, g-65, g65, Gooseneck light with chain, Gooseneck mount with chain, Gooseneck with a chain, Goosenecks with a chain, Gooseneck with a chains, Goosenecks with a chains, Gooseneck with chain, Goosenecks with chain, Gooseneck with chains, Goosenecks with chains, 28.9" Projection, 28.9 Projection, 28 Projection, 28" Projection, 30" Projection, 30 Projection, G65 Gooseneck Arm - 28.9" Projection, gooseneck options,