Sandbox

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 (136, 135, 138) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00036

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	full_description	promo_text
135	<p>The ZEN line of portable media players has long been associated with the highest quality in audio playback, and the Creative ZEN Touch 2 continues to uphold this standard. But that's not all it offers. What makes this player truly stand out from the rest is that you can stream music wirelessly to compatible Bluetooth® headphones or speakers such as Creative's ZiiSound D5 and WP-300, and surf the Internet too.</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>
136	<p><p>The Time of the AZURE is Here!</p><p> </p><p>Aksys Games, a publisher of interactive entertainment software, is proud to announce that the next installment in the hit fighting game series BlazBlue, BlazBlue: Continuum Shift EXTEND, will be coming to North America as a PlayStation®Vita launch title! With the devious, all new playable character Relius Clover, new story scenarios, new gameplay modes, and competitively balanced action, BlazBlue: Continuum Shift EXTEND makes a grand return to home consoles and the new frontier!</p><p>BlazBlue: Continuum Shift EXTEND Key Features:</p><p> </p><p>Enhanced Story Mode: Relive and rediscover the events that took place in BlazBlue: Calamity Trigger or venture forth into one of four all new story scenarios!</p><p>New and Revised Game Modes to Explore: Take on the strongest of foes in Unlimited Mars Mode, dungeoneer your way to the bottom of Abyss Mode, or lead an army to victory in Legion Mode!</p><p>Fully Revised Combat System: All characters, new and old, have been thoroughly rebalanced and armed with all new strategies and combos to take your game to the top!</p><p>Improved Online Multiplayer: Battle it out in BlazBlue’s acclaimed online mode with all new multiplayer features, such as online team battles!</p><p>SHIP DATE: February 14, 2012</p><p>GENRE: Fighting</p><p>PLAYER(S): 1 Local, 2-6 Online</p></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>
138	<p><p>BEAUTY & HIGH SPEED DRIFTING AROUND THE WORLD!</p><p>The high-octane racing franchise drifts onto the PlayStation®Vita delivering stunning graphics and heart-pounding action that players can truly feel. Ridge Racer® features high-speed action, high-performance racing machines, and all-new gameplay additions creating an edge-of-your-seat experience only possible on the PlayStation®Vita. Racing fans can also take the action online and tear up the track against players from around the globe using the PlayStation®Vita “near” and Wi-Fi functionality and race against other players’ ghosts anywhere at anytime.</p><p><p>Vivid, next generation high-contrast graphics and advanced lighting effects powered by the PlayStation®Vita painting processor</p><p>An immersive audio experience with a dynamic soundscape that changes and evolves with each race according to the movement of your machine.</p><p>All-new custom drift system enables players to tune the action to suit their style of driving. All new "Machine Upgrade Map" customization allows players to upgrade functional parts and create their own original machines</p><p>New introduction of the Planetary League allows players to join in one of four racing teams and race against other players from around the world both at real-time and "anywhere at any time" by exchanging ghosts via "near" functionality.</p><p>Compete against up to 7 other players from around the world with online (ad-hoc, Wi-Fi) multiplayer.</p></p></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>