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 (154, 155, 157, 153) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00037

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 4 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
153 <p>Slipping into a set of lightweight, professional headphones like the Koss UR55 studio headphones is like listening to a live musical performance at a spacious outdoor venue. These high velocity headphones feature open-screen ear cups that deliver great sound, lasting comfort, and impressive air circulation. <br /><br />Designed to deliver equal parts sound quality and comfort, Koss UR55s bump with massive bass while their lightweight foam ear cushions are enough to convince you it&rsquo;s just you and the music. A padded sling with a sturdy metal headband reinforcement provides extreme durability, while the swivel ear cups encourage maximum flexibility, single-ear listening and convenient storage.</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>
154 <p>Koss JR900s are the music lover&rsquo;s answer to true stereo and cordless freedom. Operating on one of the highest power bands available on the market, the Koss JR900 headphone system (consisting of a high quality, battery operated RF transmitter with AC adapter) offers the best in wireless audio technology, allowing you to roam freely over a 70,000-square-foot area. From room to room, inside to outside, even in bright sunlight, you can move to your heart&rsquo;s content without the need for additional transmitters or worry of signal breakup.</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>
155 <p>Koss Porta Pro KTC, the most sophisticated version of the Porta Pro, features a new technological upgrade which brings listeners closer to the music they love. Koss Touch Control (KTC) remote and microphone technology, made for iPhone&reg;, iPad&reg; and iPod&reg;, gives listeners more control in fewer steps. Listeners are now able to stay connected, shuffle song and adjust volume with the flick of a switch.</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>
157 <p>Love at first listen. Striking yet comfortable studio monitor headphones with neodymium magnets deliver sounds even the most discerning of audiophiles will flip for.</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>