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 (60748, 60739, 60745, 60753) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00029

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 (60748,60739,60745,60753) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
60739	curved arm, curved gooseneck, 16 inch gooseneck, gooseneck couplers, curve, curved end,	The G11 Gooseneck Arm is curved arm that points straight down.	G11, curved gooseneck, curved arm, BLE-G11, G-11, g11, g-11, gooseneck arm dimensions, gooseneck options,
60745	curved arm, curved gooseneck, 16 inch gooseneck, gooseneck couplers, curve, curved end,	The G15 Gooseneck Arm is curved arm that points straight down.	G15, curved gooseneck, curved arm, BLE-G15, G-15, g15, g-15, gooseneck options,
60748	g19, gooseneck, gooseneck arm, backing plate, wall mount, extended arm	The G19 Gooseneck Arm is held by a rectangular backing plate. This wall mounting makes this gooseneck a sturdy but decorative option.	G19, G19 Gooseneck, G19 Arm, Gooseneck with backing plate, Sturdy Gooseneck, BLE-G19, G-19, arm, gooseneck arm dimensions, gooseneck options,
60753	G26, raised, short, 13 inch, gooseneck arm,	The G26 Gooseneck Arm has a raised appearance.	G26, G-26, G26 Arm, G26 gooseneck, raised gooseneck, BLE-G26, g26, g-26, gooseneck arm dimensions, gooseneck options,