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 (90, 89, 88, 47) 
  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	full_description	promo_text
47	<p><span style="color: #242424; font-family: Arial, Verdana, Helvetica, sans-serif; text-align: left; background-color: #ffffff; font-size: xx-small; padding: 0px; margin: 0px;">The ultimate "VS." Series was born here!</span></p><ul style="padding-top: 0px; padding-right: 20px; padding-bottom: 0px; padding-left: 20px; margin-top: 10px; margin-bottom: 20px; margin-left: 0px; list-style-position: initial; list-style-image: initial; color: #242424; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; text-align: left; background-color: #ffffff;"><li style="padding-top: 2px; padding-bottom: 8px; padding-left: 20px; background-image: url(http://drh.img.digitalriver.com/DRHM/Storefront/Site/capcomus/cm/images/site/bg_bullet.jpg); background-attachment: scroll; background-origin: initial; background-clip: initial; background-color: transparent; background-position: 0% 5px; background-repeat: no-repeat no-repeat; margin: 0px;"><strong style="padding: 0px; margin: 0px;">Innovative graphics and gameplay bring the Marvel® and Capcom universes to life:</strong>Powered by an advanced version of MT Framework, the engine used in Resident Evil® 5 and Lost Planet® 2, Marvel® vs. Capcom® 3 brings beautiful backgrounds and character animations to the forefront</li><li style="padding-top: 2px; padding-bottom: 8px; padding-left: 20px; background-image: url(http://drh.img.digitalriver.com/DRHM/Storefront/Site/capcomus/cm/images/site/bg_bullet.jpg); background-attachment: scroll; background-origin: initial; background-clip: initial; background-color: transparent; background-position: 0% 5px; background-repeat: no-repeat no-repeat; margin: 0px;"><strong style="padding: 0px; margin: 0px;">Evolved VS. Fighting System:</strong> Wild over-the-top gameplay complete with signature aerial combos, hyper combos and more. The evolved new battle system, the “Team Aerial Combo,” takes the exciting mind-reading game to a whole new level!</li><li style="padding-top: 2px; padding-bottom: 8px; padding-left: 20px; background-image: url(http://drh.img.digitalriver.com/DRHM/Storefront/Site/capcomus/cm/images/site/bg_bullet.jpg); background-attachment: scroll; background-origin: initial; background-clip: initial; background-color: transparent; background-position: 0% 5px; background-repeat: no-repeat no-repeat; margin: 0px;"><strong style="padding: 0px; margin: 0px;">3-on-3 Tag Team Fighting:</strong> Players build their own perfect team by assigning unique “Assist Attacks” for each character and utilize each character’s special moves to create their own unique fighting style</li><li style="padding-top: 2px; padding-bottom: 8px; padding-left: 20px; background-image: url(http://drh.img.digitalriver.com/DRHM/Storefront/Site/capcomus/cm/images/site/bg_bullet.jpg); background-attachment: scroll; background-origin: initial; background-clip: initial; background-color: transparent; background-position: 0% 5px; background-repeat: no-repeat no-repeat; margin: 0px;"><strong style="padding: 0px; margin: 0px;">Simple Mode:</strong> Streamlined button mapping option allows novice players to perform moves like a pro</li><li style="padding-top: 2px; padding-bottom: 8px; padding-left: 20px; background-image: url(http://drh.img.digitalriver.com/DRHM/Storefront/Site/capcomus/cm/images/site/bg_bullet.jpg); background-attachment: scroll; background-origin: initial; background-clip: initial; background-color: transparent; background-position: 0% 5px; background-repeat: no-repeat no-repeat; margin: 0px;"><strong style="padding: 0px; margin: 0px;">Living Comic Book Art Style:</strong> See the most adored characters from the Capcom and Marvel® universes brought to life in a “moving comic” style, blurring the boundaries between 2D and 3D graphics</li><li style="padding-top: 2px; padding-bottom: 8px; padding-left: 20px; background-image: url(http://drh.img.digitalriver.com/DRHM/Storefront/Site/capcomus/cm/images/site/bg_bullet.jpg); background-attachment: scroll; background-origin: initial; background-clip: initial; background-color: transparent; background-position: 0% 5px; background-repeat: no-repeat no-repeat; margin: 0px;"><strong style="padding: 0px; margin: 0px;">New Characters:</strong> Popular returning characters include Spider-Man, Ryu, Wolverine, Morrigan, Iron Man, Hulk, Captain America, Felicia, Chun-Li, Tron Bonne, Magneto and Doctor Doom. Viewtiful Joe will make his debut in the Marvel vs. Capcom franchise. <strong style="padding: 0px; margin: 0px;">New characters joining the playable cast for the first time in fighting game history include Chris Redfield, Thor, Trish, Super-Skrull, Amaterasu, Dormammu, Wesker, X-23, Arthur, Deadpool, Nathan Spencer, M.O.D.O.K. and Dante!</strong></li></ul><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>
88	<p> </p><p>Studio: Warner Home Video</p><p>Packaging Type: PS3</p><p>Genre: Action/Adventure, Racing</p><p>Synopsis:</p><p>In The Lord of the Rings: War in the North, players will experience an unrivaled Co-Op based Action/RPG gameplay experience – banding together on an untold journey to defeat the Dark Lord Sauron’s forces and turn the tide in the War of the Ring.</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>
89	<p><p>Studio: Warner Home Video</p><p>Packaging Type: PS3</p><p>Genre: Action/Adventure</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>
90	<p><p>Studio: Warner Bros.</p><p>Packaging Type: PS3</p><p>Genre: GAME</p><p>Synopsis:</p><p>As a specialized soldier in the elite squad, First Encounter Assault Recon (F.E.A.R.), you must uncover the mystery of Armacham’s current operations, reassemble the lost F.E.A.R. and Delta teams, and stop the powerful paranormal entity, Alma, before she releases the most unimaginable horror into this world.</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>