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, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (125, 120, 117, 113) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00021

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 4 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
113 <p>The Samsung Focus Flash 4G mobile phone features Windows Phone 7.5 OS (Mango) and 4G speed for faster downloads and streaming. This 4G smartphone also includes a Super AMOLED touch screen for simple navigation of features, a rear-facing 5.0MP camera for still photos, a secondary front-facing camera for video chatting, and Bluetooth-compatibility for use with your favorite Bluetooth-enabled device. Plus, the Samsung Focus Flash 4G doubles as a mobile hotspot for up to 4 additional Wi-Fi enabled devices.</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>
117 <p>Galaxy Nexus is the world's first phone with a 4.65" high-definition Super AMOLED display, making text, photos, videos and games look crisp, vibrant and rich. With 1280x720 HD resolution, videos look amazing and the unique Contour Display curves nicely to the shape of your face and makes it easier to hold.</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>
120 <p>The fastest, state-of-the-art networks are 4G, so naturally, the Epic&trade; 4G Touch is designed for speed. With 4G, every download, upload, app, game, connection and feature runs almost as fast as you can push the button.</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>
125 <dl><dt>The Galaxy S II has an amazing 4.27" Super AMOLED Plus screen. This superb display has razor sharp clarity and breathtaking color. See every detail of videos and pictures. See the full range of hues in all their subtlety and brilliance. And with its superior wide viewing angle, you don't have to be directly in front of the screen to see a perfect image. Truth is, you really have to see it to believe it.</dt></dl> <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>