SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  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 (65683, 65613) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65683,65613) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65613 <p>Create an inviting atmosphere at your front porch or doorway with the Ledford Wall Sconce! Crafted from hand-worked iron and finished in Textured Black, this wet-rated wall sconce offers a taste of nostalgia with its traditional lantern shape and hanging shade. Opal white glass eliminates glare and diffuses the illumination for a welcoming glow. </p> <p>|break|</p> <ul> <li>This product is imported by Troy Lighting, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Textured Black Finish </li> <li>Opal White Glass </li> </ul> Outdoor lighting with a classic profile & rugged construction. White glass provides diffused illumination for less glare. B6351, B6353, B6357, mission beach, troy, lantern, outdoor lantern, glass lantern, rectangle lantern, modern lantern, simple outdoor lantern, cylinder glass lantern, outdoor sconce, wet location sconce, modern outdoor lantern,
65683 <p>With inspiration from an era when candles were the only option for illumination, the Ledford Chain Hung Pendant brings the timeless look of a lantern to the modern age. With its sleek Textured Black frame enclosing an opal glass shade, this lantern lends a classic vibe to kitchens, covered porches, and dining rooms. The rugged chain mounting adds a dash of industrial styling to create an eye-catching fixture!</p> <p>|break|</p> <ul> <li>This product is imported by Troy Lighting, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Textured Black Finish </li> <li>Opal White Glass </li> </ul> Outdoor lighting with a classic profile & rugged construction. White glass provides diffused illumination for less glare. B6351, B6353, B6357, F6357, mission beach, troy, lantern, outdoor lantern, glass lantern, rectangle lantern, modern lantern, simple outdoor lantern, cylinder glass lantern, modern outdoor lantern, ledford, ledford chain, chain hung lantern, front porch lantern, F6357, chain lantern, chain mount lantern,