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

Result

product_id	meta_keywords	meta_description	search_words
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,
60749	G22, gooseneck arm, standard gooseneck, basic arm, 22 inch, porcelain,	The G22 Gooseneck Arm is one of our standard gooseneck arms. This basic arm has a 22 inch projection and is painted to match our porcelain finishes.	G22, G22 Gooseneck, G22 Arm, Porcelain Gooseneck, Porcelain arm, BLE-G22, G-22, arm, gooseneck arm, g-22, g22, 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,