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 (
    71200, 71013, 70292, 70814, 71176, 71156, 
    71155, 71154, 71153, 70919, 71125, 
    71078, 71113, 70994, 70541, 71108, 
    71015, 70830, 71012, 70827, 71064, 
    71062, 71061, 71011, 70545, 70544, 
    70122, 70813, 70817, 70952, 70947, 
    70540, 70359, 70882, 70881, 70829, 
    70828, 70538, 70230, 70229
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
70122
70229 Cheek388,Cheeky Tracks,Filthykitten,Random But Raw
70230 Cheek388,Cheeky Tracks,Filthykitten,Random But Raw
70292
70359
70538 Damaged Gudz Damaged Gudz
70540 Matt Wade Matt Wade
70541 D-Fi D-Fi
70544 Cheek392,Cheeky Tracks,Drake Liddell
70545 Cheek392,Cheeky Tracks,Drake Liddell
70813
70814
70817 HOT017,Hot Box Digital,D-FI
70827 FILTH003,The Filth Foundry,Matt Wade,Karl Davis
70828 Back On It Hooverweight Marc Lewis Back On It Hooverweight Marc Lewis
70829 premonition,Gareth Hogan, Stereophonic Sound,music,hardhouse,filth,nrg,rave premonition,Gareth Hogan, Stereophonic Sound,music,hardhouse,filth,nrg,rave
70830 UTHHD024,Ultratech,Jay Middleton,VaderMonkey
70881 Dave Owens, Aporkalypse, TurtleDog, Exclusive, Toolbox Digital Download Aporkalypse by TurtleDog from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
70882 Dave Owens, Aporkalypse, TurtleDog, Exclusive, Toolbox Digital Download Aporkalypse by TurtleDog from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
70919 XTRA128,XTRAHard Records,Mhx
70947
70952 Slender Man, Tim Sloan Slender Man, Tim Sloan Slender Man, Tim Sloan
70994 premonition digital,adam taylor,charlie godadard,music,hardhouse,filth,nrg,rave,hardtrance,trance,hard house,hard trance premonition digital,adam taylor,charlie godadard,music,hardhouse,filth,nrg,rave,hardtrance,trance,hard house,hard trance
71011 premonition digital,dale parry,parry d,having fun,music,hardhouse,filth,nrg,rave,hard house,premonition premonition digital,dale parry,parry d,having fun,music,hardhouse,filth,nrg,rave,hard house,premonition
71012 Cupra, Mystery, Slingshot Cupra, Mystery, Slingshot
71013 HOT018,Hot Box Digital,Matt Wade,Gaz.P
71015 BMR058,Beast Mode Recordings,NuroGL
71061 D-Fi & Chucky D-Fi & Chucky
71062
71064 TMP113,Robski,Reckless Behaviour,Tempo Trax,Hard House Hard House TMP113,Robski,Reckless Behaviour,Tempo Trax,Hard House
71078 korruption,hardhouse korruption,hardhouse
71108 craig,jones,fear,not,flat,4,audio,hard,trance The bearded whizzkid strikes again with this feel good hard trance roller, set to blast you into outer orbit. craig,jones,fear,not,flat,4,audio,hard,trance
71113 Tom Whyld, Spellcaster, Jeli Jams, Exclusive, Toolbox Digital For our October release we are pleased to present Spellcaster from Tom Whyld. Well known to the Ibiza crew, Tom makes the annual pilgrimage to the white isle each year from Moscow. Spellcaster had its debut play at last years hard house week on the party James Price, Selina Ridgway, Tom Whyld, Spellcaster, Jeli Jams, Exclusive, Toolbox Digital
71125 Asylum, Raw Power, Synths, Hoovers, RPR184,Face Hugger, Hard House, Filth, hoovers Asylum make a welcome return to Raw Power as a follow up to Typhoon.... and well.... what can I say apart from these are the ones to watch.... man do they up their game! Brutal main riff and hoovers to boot... Definitely the Raw Power!!!!! Asylum, Raw Power, Synths, Hoovers, RPR184,Face Hugger, Hard House, Filth, hoovers
71153 Dreamin DJ Serenity Energy Source Productions Hard House Dreamin DJ Serenity Energy Source Productions Hard House Dreamin DJ Serenity Energy Source Productions Hard House
71154 Dreamzone DJ Serenity Energy Source Productions Hard House Dreamzone DJ Serenity Energy Source Productions Hard House Dreamzone DJ Serenity Energy Source Productions Hard House
71155 Fantasy DJ Serenity Energy Source Productions Hard House Fantasy DJ Serenity Energy Source Productions Hard House Fantasy DJ Serenity Energy Source Productions Hard House
71156 Desire Remix DJ Serenity Energy Source Productions Hard House Desire Remix DJ Serenity Energy Source Productions Hard House Desire Remix DJ Serenity Energy Source Productions Hard House
71176 Kev & Si Kev & Si
71200 premonition digital,jade paley,jaley,sam alame, sam alamé,music,all it takes,hardhouse,filth,nrg,rave,hardtrance,trance,hard house,hard trance,vocal,kiss,one We welcome Jade Paley & Sam Alamé as they make their debut on Premonition Digital with this incredible vocal banger!! premonition digital,jade paley,jaley,sam alame, sam alamé,music,all it takes,hardhouse,filth,nrg,rave,hardtrance,trance,hard house,hard trance,vocal,kiss,one