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 (199, 11, 195) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00022

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	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
195		<p><p>2DVD edition of the 2010 Crossroads Guitar Festival. Featuring: Eric Clapton, Jeff Beck,Sheryl Crow,Vince Gill, Buddy Guy, B.B. King,John Mayer, Bill Murray,Steve Winwood,Ronnie Wood, ZZ Top,and more PLUS behind-the-scenes footage and interviews.</p><p> </p><p>DVD 1</p><p> </p><p>01 Promise Land - By Sonny Landreth with Eric Clapton</p><p>02 Z. Rider - By Sonny Landreth with Eric Clapton</p><p>03 Traveling Shoes - By Robert Randolph & The Family Band</p><p>04 Going Down - By Pino Daniele, Joe Bonamassa, Robert Randolph & The Family Band</p><p>05 Killing Floor - By Robert Cray with Jimmie Vaughan & Hubert Sumlin</p><p>06 Six Strings Down - By Jimmie Vaughan with Robert Cray & Hubert Sumlin</p><p>07 Waiting For The Bus - By ZZ Top</p><p>08 Jesus Just Left Chicago - By ZZ Top</p><p>09 Gypsy Blood - By Doyle Bramhall II</p><p>10 In My Time Of Dying (Jesus Make Up My Dying Bed) - By Doyle Bramhall II</p><p>11 Bright Lights - By Gary Clark Jr.</p><p>12 Long Road Home - By Sheryl Crow with Derek Trucks, Susan Tedeschi, Doyle Bramhall II & Gary Clark Jr.</p><p>13 Our Love Is Fading - By Sheryl Crow with Eric Clapton, Doyle Bramhall II & Gary Clark Jr.</p><p>14 Blackwaterside - By Bert Jansch</p><p>15 Mississippi Blues - By Stefan Grossman & Keb' Mo'</p><p>16 Roll And Tumble Blues - By Stefan Grossman</p><p>17 One More Last Chance - By Vince Gill with Keb' Mo', James Burton, Earl Klugh & Albert Lee</p><p>18 Mystery Train - By Vince Gill with James Burton, Albert Lee, Keb' Mo' & Earl Klugh</p><p>19 Lay Down Sally - By Vince Gill with Sheryl Crow, Keb' Mo', Albert Lee, James Burton & Earl Klugh</p><p>20 Angelina - By Earl Klugh</p><p>21 Vonetta - By Earl Klugh</p><p>22 Who Did You Think I Was - By John Mayer Trio</p><p>23 Ain't No Sunshine - By John Mayer Trio</p><p> </p><p>DVD 2</p><p> </p><p>01 Midnight In Harlem - By Derek Trucks & Susan Tedeschi Band</p><p>02 Coming Home - By Derek Trucks & Susan Tedeschi Band with Warren Haynes</p><p>03 Soulshine - By Warren Haynes</p><p>04 Don't Keep Me Wondering - By David Hidalgo & Cesar Rosas with Derek Trucks</p><p>05 Space Captain - By Derek Trucks & Susan Tedeschi Band with Warren Haynes, David Hidalgo, Cesar Rosas & Chris Stainton</p><p>06 Five Long Years - By Buddy Guy with Jonny Lang & Ronnie Wood</p><p>07 Miss You - By Buddy Guy with Jonny Lang & Ronnie Wood</p><p>08 Hammerhead - By Jeff Beck</p><p>09 Nessun Dorma - By Jeff Beck</p><p>10 Crossroads</p><p>11 Hands Of The Saints - By Citizen Cope & Eric Clapton</p><p>12 I Shot The Sheriff</p><p>13 Shake Your Money Maker - By Eric Clapton & Jeff Beck</p><p>14 Had To Cry Today - By Steve Winwood & Eric Clapton</p><p>15 Voodoo Chile - By Eric Clapton & Steve Winwood</p><p>16 Dear Mr. Fantasy - By Steve Winwood & Eric Clapton</p><p>17 The Thrill Is Gone - By B.B. King & Ensemble</p><div></div></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>
199		<p><div class="wiki_section" style="margin-bottom: 15px; line-height: 18px; color: #3b3b3b; font-family: 'Gill Sans MT', tahoma, arial, sans-serif; font-size: 12px; text-align: left; background-color: #ffffff;">Product Details <br /><ul class="wiki_list"><li class="wiki_listitem">Audio CD (September 13, 2005)</li><li class="wiki_listitem">Original Release Date: September 13, 2005</li><li class="wiki_listitem">Number of Discs: 2</li><li class="wiki_listitem">Label: Virgin Records Us</li></ul></div><div class="wiki_section" style="margin-bottom: 15px; line-height: 18px; color: #3b3b3b; font-family: 'Gill Sans MT', tahoma, arial, sans-serif; font-size: 12px; text-align: left; background-color: #ffffff;">Disc: 1<ul class="wiki_list"><li class="wiki_listitem">1. 3 O'Clock Blues</li><li class="wiki_listitem">2. Blind Love</li><li class="wiki_listitem">3. She's Dynamite</li><li class="wiki_listitem">4. You Know I Love You</li><li class="wiki_listitem">5. Please Love Me</li><li class="wiki_listitem">6. Story Fom My Heart And Soul</li><li class="wiki_listitem">7. The Woman I Love</li><li class="wiki_listitem">8. Neighborhood Affair</li><li class="wiki_listitem">9. When My Heart Beats Like A Hammer</li><li class="wiki_listitem">10. Every Day I Have The Blues</li><li class="wiki_listitem">11. Love You Baby (Take A Swing With Me)</li><li class="wiki_listitem">12. Ten Long Years</li><li class="wiki_listitem">13. You Upset Me, Baby</li><li class="wiki_listitem">14. Boogie Rock (House Rocker)</li><li class="wiki_listitem">15. Crying Won't Help You</li><li class="wiki_listitem">16. Bad Luck</li><li class="wiki_listitem">17. Did You Ever Love A Woman</li><li class="wiki_listitem">18. You Don't Know</li><li class="wiki_listitem">19. Sweet Little Angel</li><li class="wiki_listitem">20. On My Word Of Honor</li></ul><br />Disc: 2<ul class="wiki_list"><li class="wiki_listitem">1. Be Careful With A Fool</li><li class="wiki_listitem">2. Please Accept My Love</li><li class="wiki_listitem">3. Days Of Old</li><li class="wiki_listitem">4. Worry, Worry</li><li class="wiki_listitem">5. Confessin' The Blues</li><li class="wiki_listitem">6. Sweet Sixteen Parts 1 & 2</li><li class="wiki_listitem">7. Ain't Nobody's Business</li><li class="wiki_listitem">8. Walkin' Dr. Bill</li><li class="wiki_listitem">9. My Own Fault</li><li class="wiki_listitem">10. You Done Lost Your Good Thing Now</li><li class="wiki_listitem">11. Downhearted (How Blue Can You Get?)</li><li class="wiki_listitem">12. I'll Survive</li><li class="wiki_listitem">13. Mashed Potato Twist</li><li class="wiki_listitem">14. Down Now</li><li class="wiki_listitem">15. Peace Of Mind</li><li class="wiki_listitem">16. That Evil Child</li><li class="wiki_listitem">17. Blues Stay Away From Me</li><li class="wiki_listitem">18. Rock Me Baby</li><li class="wiki_listitem">19. Miss Martha King</li><li class="wiki_listitem">20. When Your Baby Packs Up And Goes</li></ul></div></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>