Sandbox

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 (232, 230, 231) 
  AND cscart_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_product_descriptions	range	PRIMARY,product_id	PRIMARY	9		3	Using index condition

Result

product_id	full_description	promo_text
230	<p>Hydration Capacity: 100 oz (3 L)<br /><br />Total Capacity: 1800 cu in (29.50 L)<br /><br />CamelBak® Got Your Bak™ Guarantee: If we built it, we'll Bak it™ with our lifetime guarantee. <br /><br />Reservoir Features: Quick Link™ System, 1/4 turn - easy open/close cap, lightweight fillport, dryer arms, center baffling and low-profile design, patented Big Bite™ Valve, HydroGuard™ technology, insulated PureFlow™ tube, easy-to-clean wide-mouth opening<br /><br />BACK PANEL: Air Director™ Snowshed™<br /><br />HARNESS: Therminator™ provides easy access for frequent sipping, insulated and fully enclosed to protect against freezing<br /><br />BELT: Load-bearing with cargo<br /><br />Additional Features: <br />Versatile Snowboard / Ski Carry (Diagonal, Vertical or Horizontal), tri-zip quick gear access, gear compression, goggle pocket, essentials pocket<br />Drop-out Probe Pocket for instant probe access -- locate survivors without unloading your pack<br /><br />Designed to carry: skis/snowboard, shovel, probe, skins, snowshoes, helmet, goggles, extra layers, lunch, tools, camera, phone, wallet, keys</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>
231	<p>Hydration Capacity: 100 oz (3 L)<br /><br />Total Capacity: 1125 cu in (18.44 L)<br /><br />CamelBak® Got Your Bak™ Guarantee: If we built it, we'll Bak it™ with our lifetime guarantee. <br /><br />Reservoir Features: Quick Link™ System, 1/4 turn - easy open/close cap, lightweight fillport, dryer arms, center baffling and low-profile design, patented Big Bite™ Valve, HydroGuard™ technology, insulated PureFlow™ tube, easy-to-clean wide-mouth opening<br /><br />BACK PANEL: Snowshed™<br /><br />HARNESS: Therminator™ provides easy access for frequent sipping, insulated and fully enclosed to protect against freezing<br /><br />BELT: Load-bearing<br /><br />Additional Features: <br />Snowboard / Ski Carry (Diagonal, Vertical or Horizontal), pack compression, goggle pocket, essentials pocket<br />Drop-out Probe Pocket for instant probe access -- locate survivors without unloading your pack<br /><br />Designed to carry: skis/snowboard, shovel, probe, skins or snowshoes, goggles, extra layer, snack, phone, wallet, keys</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>
232	<p>Hydration Capacity: 70 oz (2 L)<br /><br />Total Capacity: 1000 cu in (16.39 L)<br /><br />CamelBak®Got Your Bak™ Guarantee: If we built it, we'll Bak it™ with our lifetime guarantee. <br /><br />Reservoir Features: 1/4 turn - easy open/close cap, lightweight fillport, dryer arms, center baffling and low-profile design, patented Big Bite™ Valve, HydroGuard™ technology, insulated PureFlow™ tube, easy-to-clean wide-mouth opening<br /><br />BACK PANEL: Snowshed™<br /><br />HARNESS: S-Curved Women's Harness; Therminator™ provides easy access for frequent sipping, insulated and fully enclosed to protect against freezing<br /><br />BELT: Removable 1" (25 mm) stability<br /><br />Additional Features: <br />Tri-Zip design allows easy access to all your gear, compresion, goggle pocket, essentials pocket<br /><br />Designed to carry: Helmet, goggles, extra layers, lunch, phone, wallet, keys</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>