SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    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 (5473, 59, 5476, 364) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (5473,59,5476,364) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
59 Freshly squeezed oranges. Zest spritzing from a juicy tangerine. A touch of lemon. Our Citrus Oatmeal is a magnificent bar that revitalizes you with every shower. No wonder its one of our best sellers for men and women. We start with the same wholesome vegetable oils and emollients that go into all Herbaria soaps. Then we add ground oatmeal for gentle exfoliation and shea butter for moisturizing. The combination of rich, creamy lather and a good scrub makes for clean, healthy skin. It is a gorgeous bar colored by the bright orange essential oil and annatto, an all natural food coloring. Citrus Oatmeal, orange, shea butter, olive oil, tangerine, Best, handmade, all natural, cold-process, all-vegetable, vegan, Castile, bar soap, moisturize, moisturizing, skin, face, body, acne, dermatitis, psoriasis, eczema, dry skin, skin problems. 'Smells fresh squeezed!' Citrus scent from orange & tangerine essential oils. Oatmeal soothes, scrubs. Shea butter moisturizes. Buy 6 get 1 free. Over 60 varieties. Citrus Oatmeal, Best, handmade, all natural, cold-process, all-vegetable, vegan, Castile, bar soap, moisturize, moisturizing, skin, face, body, acne, dermatitis, psoriasis, eczema, dry skin, skin problems
364 This might be the happiest bar of soap ever, a fragrant marriage of citrusy orange and sweet vanilla. Sniff closely and you will find that the tan swirls smell of vanilla and the bright orange swirls smell like freshly squeezed oranges. Each bar comes out slightly different, some more vanilla, some more orange. Thats the charm of it. To impart the yummy vanilla aroma, we use a natural vanilla infusion made with pods of the orchid Vanilla planifolia. The fresh orange scent comes from 5-fold orange essential oil. Sweet Orange & Vanilla soap "Best handmade bars!" Sweet Orange & Vanilla soap is moisturizing, scented with essential oil and natural vanilla infusion. Buy 6 get 1 free.
5473 <p><span class="gmail_default">Though there are those who can't wait to try another soap variety, s</span>ome of us are just too darn lazy to get a new bar for the shower so we made Big Bars.&nbsp;</p> <p>These five bestsellers are nearly twice as large as our regular bars.&nbsp;</p> big bars soap large bars larger Our bestsellers are nearly twice the size of regular bars. Free shipping on $60 orders. We offer 60 soap varieties for face and body. <p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five popular varieties</span></p> <p>&nbsp;</p>
5476 Herbaria Shampoo Bars produce abundant creamy lather to gently but thoroughly cleanse your hair and leave it soft, shiny, and easy to manage. Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy. shampoo soap bars Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy. bar shampoo, natural shampoo, bar shampoo <p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>