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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    5618, 5676, 5661, 5634, 5619, 6216, 2458, 
    2457, 2456, 2455, 2454, 2451, 2450, 
    6164, 2443, 2448, 2447, 2446, 2445, 
    2444, 85065, 85064, 78818, 78817, 2441, 
    2440, 2439, 5885, 2442, 78201, 5897, 
    2434, 2435, 2437, 2438, 2436, 6059, 
    2433, 2432, 2431, 2430, 6189, 6130, 
    6129, 6126, 6125, 6124, 6123, 6122, 
    5940, 2428, 2427, 2426, 2425, 6183, 
    2422, 2423, 2421, 2420, 2424, 2419, 
    2418, 2416, 2414, 6181, 5985, 77579, 
    6321, 26680, 6174, 6306, 2408, 2412, 
    2413, 2411, 2410, 2409, 2407, 6186, 
    103458
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00136

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 80 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
2407 DixiePsychonauticalSumo Training Hard HouseHard DanceNRG DixiePsychonauticalSumo Training Hard HouseHard DanceNRG DixiePsychonauticalSumo Training Hard HouseHard DanceNRG
2408 SinobeThe BrickyBoxed DigitalHard HouseHard DanceNRG SinobeThe BrickyBoxed DigitalHard HouseHard DanceNRG SinobeThe BrickyBoxed DigitalHard HouseHard DanceNRG
2409 Gem StoneRule BreakerSmalltown RecordsHard HouseHard DanceNRG Gem StoneRule BreakerSmalltown RecordsHard HouseHard DanceNRG Gem StoneRule BreakerSmalltown RecordsHard HouseHard DanceNRG
2410 Zoe Holborn & Gem StoneForbiddenSmalltown RecordsHard HouseHard DanceNRG Zoe Holborn & Gem StoneForbiddenSmalltown RecordsHard HouseHard DanceNRG Zoe Holborn & Gem StoneForbiddenSmalltown RecordsHard HouseHard DanceNRG
2411 ManikBlack Sun Rising4AM Cube RemixMeltdown RecordingsHard HouseHard DanceNRG ManikBlack Sun Rising4AM Cube RemixMeltdown RecordingsHard HouseHard DanceNRG ManikBlack Sun Rising4AM Cube RemixMeltdown RecordingsHard HouseHard DanceNRG
2412
2413
2414 Karl DavisYa Got No BassPure NRGHard HouseHard DanceNRG Karl DavisYa Got No BassPure NRGHard HouseHard DanceNRG Karl DavisYa Got No BassPure NRGHard HouseHard DanceNRG
2416 Robbie MuirThe ChangeFruit Machine RemixDigital CohesionHard HouseHard DanceNRG Robbie MuirThe ChangeFruit Machine RemixDigital CohesionHard HouseHard DanceNRG Robbie MuirThe ChangeFruit Machine RemixDigital CohesionHard HouseHard DanceNRG
2418 Matt Mara vs Stone & HewittImperial HighSlingshot RecordingsHard HouseHard DanceNRG Matt Mara vs Stone & HewittImperial HighSlingshot RecordingsHard HouseHard DanceNRG Matt Mara vs Stone & HewittImperial HighSlingshot RecordingsHard HouseHard DanceNRG
2419
2420 Stephen WalkerDo It Like This!Stereodays RecordingsHard HouseHard DanceNRG Stephen WalkerDo It Like This!Stereodays RecordingsHard HouseHard DanceNRG Stephen WalkerDo It Like This!Stereodays RecordingsHard HouseHard DanceNRG
2421 Ben TownsendSuperkalafrajalisticSmalltown RecordsHard HouseHard DanceNRG Ben TownsendSuperkalafrajalisticSmalltown RecordsHard HouseHard DanceNRG Ben TownsendSuperkalafrajalisticSmalltown RecordsHard HouseHard DanceNRG
2422 Digital MafiaHooked On (So In Love)Immuir RecordingsHard HouseHard DanceNRG Digital MafiaHooked On (So In Love)Immuir RecordingsHard HouseHard DanceNRG Digital MafiaHooked On (So In Love)Immuir RecordingsHard HouseHard DanceNRG
2423 Digital MafiaDo Your Thing (Boom Bang)Immuir RecordingsHard HouseHard DanceNRG Digital MafiaDo Your Thing (Boom Bang)Immuir RecordingsHard HouseHard DanceNRG Digital MafiaDo Your Thing (Boom Bang)Immuir RecordingsHard HouseHard DanceNRG
2424 Digital MafiaWhat Girls LoveImmuir RecordingsHard HouseHard DanceNRG Digital MafiaWhat Girls LoveImmuir RecordingsHard HouseHard DanceNRG Digital MafiaWhat Girls LoveImmuir RecordingsHard HouseHard DanceNRG
2425 JT2, Breathless, Sublime Paradox, Hard House, Toolbox Digital Download Breathless by Sublime Paradox from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JT2BreathlessSublime ParadoxHard HouseHard DanceNRG
2426 Tom ParrIf You Love MeEncoded NRGHard HouseHard DanceNRG Tom ParrIf You Love MeEncoded NRGHard HouseHard DanceNRG Tom ParrIf You Love MeEncoded NRGHard HouseHard DanceNRG
2427 Gary O'Connor & Boca ByrneMagnificentHi Oktane RecordsHard HouseHard DanceNRG Gary O'Connor & Boca ByrneMagnificentHi Oktane RecordsHard HouseHard DanceNRG Gary O'Connor & Boca ByrneMagnificentHi Oktane RecordsHard HouseHard DanceNRG
2428 Matt Pickup & Gem StoneRazzle DazzleRise Up DigitalHard HouseHard DanceNRG Matt Pickup & Gem StoneRazzle DazzleRise Up DigitalHard HouseHard DanceNRG Matt Pickup & Gem StoneRazzle DazzleRise Up DigitalHard HouseHard DanceNRG
2430 Imaginary ForcesMoved By MusicMK3 RS Turbo RemixBezerkHard HouseHard DanceNRG Imaginary ForcesMoved By MusicMK3 RS Turbo RemixBezerkHard HouseHard DanceNRG Imaginary ForcesMoved By MusicMK3 RS Turbo RemixBezerkHard HouseHard DanceNRG
2431 Gary O'Connor & Mick DoyleMake You MoveVicious Circle RecordingsHard HouseHard DanceNRG Gary O'Connor & Mick DoyleMake You MoveVicious Circle RecordingsHard HouseHard DanceNRG Gary O'Connor & Mick DoyleMake You MoveVicious Circle RecordingsHard HouseHard DanceNRG
2432 Kye Shand & Ste HallmanThe ReaperFireball RecordingsHard HouseHard DanceNRG Kye Shand & Ste HallmanThe ReaperFireball RecordingsHard HouseHard DanceNRG Kye Shand & Ste HallmanThe ReaperFireball RecordingsHard HouseHard DanceNRG
2433 Boneski & LipGive It To MeSmalltown RecordsHard HouseHard DanceNRG Boneski & LipGive It To MeSmalltown RecordsHard HouseHard DanceNRG Boneski & LipGive It To MeSmalltown RecordsHard HouseHard DanceNRG
2434 James GibsonIn And OutBoxed DigitalHard HouseHard DanceNRG James GibsonIn And OutBoxed DigitalHard HouseHard DanceNRG James GibsonIn And OutBoxed DigitalHard HouseHard DanceNRG
2435 JT2 & NooNooSneakyvilleBoxed DigitalHard HouseHard DanceNRG JT2 & NooNooSneakyvilleBoxed DigitalHard HouseHard DanceNRG JT2 & NooNooSneakyvilleBoxed DigitalHard HouseHard DanceNRG
2436 WizardRock Your BodyEffiective RecordsHard HouseHard DanceNRG WizardRock Your BodyEffiective RecordsHard HouseHard DanceNRG WizardRock Your BodyEffiective RecordsHard HouseHard DanceNRG
2437 Ross HomsonRun For Cover 2011Fireball RecordingsHard HouseHard DanceNRG Ross HomsonRun For Cover 2011Fireball RecordingsHard HouseHard DanceNRG Ross HomsonRun For Cover 2011Fireball RecordingsHard HouseHard DanceNRG
2438 LustyHigherFunky DiskoHard HouseHard DanceNRG LustyHigherFunky DiskoHard HouseHard DanceNRG LustyHigherFunky DiskoHard HouseHard DanceNRG
2439 Gary ByrneOblivionHi Oktane RecordsHard HouseHard DanceNRG Gary ByrneOblivionHi Oktane RecordsHard HouseHard DanceNRG Gary ByrneOblivionHi Oktane RecordsHard HouseHard DanceNRG
2440 LeftyTree HuggerRise Up DigitalHard HouseHard DanceNRG LeftyTree HuggerRise Up DigitalHard HouseHard DanceNRG LeftyTree HuggerRise Up DigitalHard HouseHard DanceNRG
2441 Tom ParrMy AnswerSlingshot RecordingsHard HouseHard DanceNRG Tom ParrMy AnswerSlingshot RecordingsHard HouseHard DanceNRG Tom ParrMy AnswerSlingshot RecordingsHard HouseHard DanceNRG
2442 Rob Brown & Random But RawYou Can't HideBoxed DigitalHard HouseHard DanceNRG Rob Brown & Random But RawYou Can't HideBoxed DigitalHard HouseHard DanceNRG Rob Brown & Random But RawYou Can't HideBoxed DigitalHard HouseHard DanceNRG
2443
2444 Matt CapitaniDeath BlowCaterpillar TraxHard HouseHard DanceNRG Matt CapitaniDeath BlowCaterpillar TraxHard HouseHard DanceNRG Matt CapitaniDeath BlowCaterpillar TraxHard HouseHard DanceNRG
2445 Matt CapitaniUnleashedCaterpillar TraxHard HouseHard DanceNRG Matt CapitaniUnleashedCaterpillar TraxHard HouseHard DanceNRG Matt CapitaniUnleashedCaterpillar TraxHard HouseHard DanceNRG
2446 Dave's ProjectGroovelineMojo MusicHard HouseHard DanceNRG Dave's ProjectGroovelineMojo MusicHard HouseHard DanceNRG Dave's ProjectGroovelineMojo MusicHard HouseHard DanceNRG
2447 Dave's ProjectSanctuaryMojo MusicHard HouseHard DanceNRG Dave's ProjectSanctuaryMojo MusicHard HouseHard DanceNRG Dave's ProjectSanctuaryMojo MusicHard HouseHard DanceNRG
2448 Ben TownsendWhite CrushSmalltown RecordsHard HouseHard DanceNRG Ben TownsendWhite CrushSmalltown RecordsHard HouseHard DanceNRG Ben TownsendWhite CrushSmalltown RecordsHard HouseHard DanceNRG
2450 ValexUltra FreeBezerkHard HouseHard DanceNRG ValexUltra FreeBezerkHard HouseHard DanceNRG ValexUltra FreeBezerkHard HouseHard DanceNRG
2451 ValexShadowsBezerkHard HouseHard DanceNRG ValexShadowsBezerkHard HouseHard DanceNRG ValexShadowsBezerkHard HouseHard DanceNRG
2454 IlogikI Just Can't StopTechnikal vs Fusion DJ's RemixElasticman PlatinumHard HouseHard DanceNRG IlogikI Just Can't StopTechnikal vs Fusion DJ's RemixElasticman PlatinumHard HouseHard DanceNRG IlogikI Just Can't StopTechnikal vs Fusion DJ's RemixElasticman PlatinumHard HouseHard DanceNRG
2455 Dave OwensDouble Sausage & Egg McMuffinTurtledog RecordsHard HouseHard DanceNRG Dave OwensDouble Sausage & Egg McMuffinTurtledog RecordsHard HouseHard DanceNRG Dave OwensDouble Sausage & Egg McMuffinTurtledog RecordsHard HouseHard DanceNRG
2456 DOAFMuppet MouseTurtledog RecordsHard HouseHard DanceNRG DOAFMuppet MouseTurtledog RecordsHard HouseHard DanceNRG DOAFMuppet MouseTurtledog RecordsHard HouseHard DanceNRG
2457 Dave OwensLeverageTurtledog RecordsHard HouseHard DanceNRG Dave OwensLeverageTurtledog RecordsHard HouseHard DanceNRG Dave OwensLeverageTurtledog RecordsHard HouseHard DanceNRG
2458 Dave OwensPepsi Is Greater Than CokeTurtledog RecordsHard HouseHard DanceNRG Dave OwensPepsi Is Greater Than CokeTurtledog RecordsHard HouseHard DanceNRG Dave OwensPepsi Is Greater Than CokeTurtledog RecordsHard HouseHard DanceNRG
5618 AWSUMCD01IT,AWsum,Tom Parr
5619 AWSUMCD01IT,AWsum,Scott Fo Shaw,Andy Whitby
5634 AWSUMCD01IT,AWsum,Zac H,Tom Berry
5661 AWSUMCD001,AWsum,Scott Fo Shaw,Andy Whitby
5676 AWSUMCD001,AWsum,Zac H,Tom Berry
5885 OWR027,Oneway Records,DJ Disa
5897 BAL035,Ballistik Recordings,David Ding
5940 NUSM007,NUsum,DJ Ransome
5985 AWSMPARR006,AWsum presents Tom Parr,Tom Parr
6059 OWR026,Oneway Records,Ugly Dave
6122 DEFCA07,Defiant Collection,Gammer,Klubfiller
6123 DEFCA07,Defiant Collection,Klubfiller
6124 DEFCA07,Defiant Collection,Klubfiller,MC Whizzkid
6125 DEFCA07,Defiant Collection,Klubfiller,Viration
6126 DEFCA07,Defiant Collection,Klubfiller,Stu Hughes
6129 DEFCA07,Defiant Collection,Andy Whitby,Klubfiller
6130 DEFCA07,Defiant Collection,Andy Whitby,Klubfiller,MDA,Spherical
6164 OWR028,Oneway Records,Jck,Kam-Pain
6174 OWR022,Oneway Records,Dan Dyson,Dramatik
6181 OWR023,Oneway Records,Crazy Chris
6183 OWR024,Oneway Records,Random But Raw,Crazy Chris
6186 OWR021,Oneway Records,Crazy Chris
6189 OWR025,Oneway Records,Crazy Chris,Jck,Key
6216 UDT08,Underdog Trax,Elivate
6306 RC009,Revolution Corps,Krovax
6321 UDT06,Underdog Trax,Dan Diamond
26680 247HC051,24/7 Hardcore,Al Storm,Taya,Essex Boyz
77579 Rocked022,Rocked Music,Rockin Russ
78201 Rocked023,Rocked Music,Rockin Russ
78817 TIDYBOYSHDD016D,Hard Drive,Perfect Poise
78818 TIDYBOYSHDD016D,Hard Drive,Perfect Poise,Lox,Leigh Green
85064 TIDYD016,Tidy,Perfect Poise
85065 TIDYD016,Tidy,Perfect Poise,Lox,Leigh Green
103458 TIDYHHH01D,Tidy,Karim,Frank Farrell