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 (
    187, 232, 230, 231, 170, 131, 177, 186, 
    185, 179, 233, 152
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00042

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

Result

product_id	full_description	promo_text
131	<p class="MsoPlainText">The new Catania features carbon fork, carbon seatpost, Ultegra derailleur, and the new Fezzari Racing Design R3A frame with increased aerodynamic properties and a sleeker look.</p><p class="MsoPlainText">The Catania road bike is a great all-around bike. If you want to get into road biking or want a bike that is durable, high-performing, and as comfortable as a road bike can get, the Catania is for you.</p><p class="MsoPlainText">The Catania features the R3A frame with compact geometry. Compact geometry means that we shorten the seat tube slightly, which makes the bike a little lighter and reduces lateral flex (you don’t want your bike flexing side to side when you’re pedaling). It also allows your riding position to be a little more upright.</p><p class="MsoPlainText">Add to that a great set of components, including: Shimano Ultegra derailleur and Shimano 105 shifters for smooth shifting Fezzari Carbon II fork to minimize the road chatter; FSA Gossamer crank with external oversized bearings that make it pedal smoother and more efficiently; Alex double-wall rims that are extremely durable; Maxxis performance tires; and a Fezzari Racing Design Ultra XR saddle that is one of the most comfortable road saddles you’ll ride.</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>
152	<div id="overview-bullets"><ul class="bullet-points"><li>Sun-Hot Heat-Treated Aluminum Beach Cruiser Frame</li><li>Hi-Ten Remington Steel Curvaceous Beach Cruiser Fork</li><li>Shimano 7-Spd Megarange Freewheel & Twist Shifter</li><li>Rust-Proof Alloy Rims & Stainless Steel Spokes</li><li>Color-Matched Custom Beach Cruiser Fenders</li></ul></div>	<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>
170	<p>The 588 Forged wedge maintains the popular, tour-proven shape of its predecessor with a series of technological breakthroughs to provide even more performance. Every wedge is Precision Forged from 1025 carbon steel for incredibly soft, solid feel and the highest level of manufacturing consistency for supreme confidence and trust over every shot. Tour Zip Grooves™ and Laser Milled™ technology maximize spin in accordance with USGA regulations. Exclusive to the 588 Forged wedge is the Tour Concept Wedge steel shaft, co-developed and engineered by Cleveland Golf and industry leader True Temper. With a unique stiffness profile that features a less active tip, this shaft promotes a more penetrating ball flight, increased spin and optimal distance control along with superior feel. Choose from two different finishes – Satin and Chrome – as well as low, standard and high bounce options.</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>
177	<p>With a sleek and striking look, the CG Black driver weighs only 265 grams, making it the lightest driver on the market to help players generate measurable increases in swing speed and distance with the same swing effort. The advanced aerodynamics found in the driver’s Speed Crown Design – an innovative, teardrop-inspired crown profile – maximize distance by reducing drag at all angles of airflow during the swing. MaxCOR2 Variable Face Thickness Technology reduces face weight and increases trampoline effect on off-center hits, meaning higher ball speed and more distance on off-center hits. Plus, a high-density weight screw at the rear of the sole plate positions the center of gravity lower and deeper to promote a high, draw-biased trajectory with optimal launch conditions for effortless distance. The CG Black driver features a Miyazaki C. Kua 39 Limited Edition graphite shaft and a Golf Pride Ultralite grip, a combination that decreases overall club weight for faster swing speed.</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>
179	<div class="overviewbody"><p>Based on the shape of the tour proven CG14<span style="font-size: 8pt;">™</span> wedge, the CG16<span style="font-size: 8pt;">™</span> has a hint of offset and is slightly larger for added forgiveness.  The face features the same spin maximizing technology featured on the CG15<span style="font-size: 8pt;">™</span> wedge – Tour Zip Grooves<span style="font-size: 8pt;">™</span> in combination with Cleveland<span style="font-size: 8pt;">®</span> Golf’s breakthrough Laser Milled<span style="font-size: 8pt;">™ </span>surface roughness technology.  Using the precision accuracy of a laser, each face features four perfectly calibrated texture lines milled between each groove exactly to the conforming roughness limit.  This surface roughness application optimizes ball-to-face friction and maximizes spin within the Rules of Golf.</p></div>	<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>
185	<p>CG Lightweight Cart bags are perfect for push and power carts</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>
186	<h3 class="product_availability">Item is not available at this time.<br />Can be Preordered.</h3>	<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>
187	<p>Used by Cleveland Golf tour staff players worldwide</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>
233	<p>• Coleman® warm weather sleeping bags made for camping temperatures between 40 and 60 degrees<br />• Rectangle shape, 33” x 75”, fits up to 5’11” tall<br />• 3 pounds of ThermoTech® insulation<br />• Cotton cover with soft cotton liner<br />• Essential camping gear, sleeping bag for a better night outdoors<br />• Don’t forget the Coleman® camping tent to go with your sleeping bags<br />• ComfortSmart™ Technology includes:<br />• ZipPlow™ plows fabric away from zipper to prevent snags<br />• ComfortCuff™ surrounds your face with softness<br />• Roll Control™ locks bag in place for easier rolling<br />• FiberLock™ prevents insulation from shifting, increases durability<br />• ThermoLock™ construction reduces heat loss through the zipper, keeping you warmer<br />• ZipperGlide™ tailoring allows smooth zipper operation around the corners<br />• QuickCord™ for easy, no tie closure<br />• Commercial Machine washable<br />• Five year limited warranty<br />• Made in China</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>