SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (17, 20, 13) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00017

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_product_descriptions range PRIMARY,product_id,company_id PRIMARY 13 3 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
13 <p style="text-align: left; color: #000000; font-size: 12px; background-color: #ffffff;">Every time a new story about how some nobody from nowhere got rich producing some clever new product in his garage, you may think, "Why can't I do that?" Well, anyone can--the trick is to take those good ideas and build them into great products that can succeed in the marketplace. In this book, you will get the 12-step plan you need to make your new product or service a profitable reality. You will learn important skills for success, including how to:</p><ul style="text-align: left; color: #000000; font-size: 12px; background-color: #ffffff;"><li style="text-align: left;">Refine their idea to attract a target audience</li><li style="text-align: left;">Research the competition</li><li style="text-align: left;">Find the right manufacturer</li><li style="text-align: left;">Create appropriate brand messaging</li><li style="text-align: left;">Build buzz online and beyond</li><li style="text-align: left;">Work trade shows and conventions</li></ul><p><span style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">Written by a woman with no formal business experience who turned her own idea into a million-dollar company, this book is the pragmatic yet inspiring guide every aspiring entrepreneur is looking for.</span></p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
20 <p><em style="color: #000000; font-family: Verdana; background-color: #ffffff; font-size: small;"><strong>The ABCs of Gold Investing</strong></em><span style="color: #000000; font-family: Verdana; background-color: #ffffff; font-size: small;">&nbsp;(Second Edition) is a solid resource for investors wishing to understand the benefits of private gold ownership. In this reader-friendly book, author Michael J. Kosares addresses the rapid changes in both the American and world economies and explains why gold is important to you as an investor. And, with thirty years experience in the gold business, he can tell you how to add gold to your portfolio in a safe and economical manner.</span></p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>