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 (
    73240, 73116, 72858, 72857, 73405, 73404, 
    73403, 73155, 73115, 73351, 73350, 
    73349, 73348, 72836, 73284, 73111, 
    71691, 68825, 49338, 44239, 44238, 
    42033, 73271, 73270, 73252, 73239, 
    73237, 73217, 73156, 73119, 72856, 
    72855, 72852, 72032, 71703, 71486, 
    71485, 71484, 71483, 73020
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00066

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
42033 HARDHOUSE,HARDNRG,NRG,RAVE,toolbox,flashpoint, TOOLBOX,TWISTEDTRAXX,VICIOUS CIRCLE,FLASHPOINT
44238 HARDHOUSE,HARDNRG,NRG,RAVE,toolbox,flashpoint, HARDHOUSE,NRG
44239 HARDHOUSE,HARDNRG,NRG,RAVE,toolbox,flashpoint, HARDHOUSE,NRG
49338 hardhouse,hardnrg,toolbox,flashpoint,delusion,nikkdbubble,gradyg, hardhouse,harnrg,rave,dj,clubbing
68825 hardhouse,rave,twistedtraxx,toolbox,orriblenoize,fireball,fruitionrecords,digitaldamagerecordings hardhouse,rave,twistedtraxx,toolbox,orriblenoize,fireball,fruitionrecords,digitaldamagerecordings
71483 Cheek400B,Cheeky Tracks,Elivate,Matt Wade,Joe Swales
71484 Cheek400B,Cheeky Tracks,Retrospect,Vandalize
71485 Cheek400B,Cheeky Tracks,Retrospect,Vandalize
71486 Cheek400B,Cheeky Tracks,Elivate,Matt Wade,Joe Swales
71691 AAA173,Ahura Mazda Recordings NITRO,Burak Harsitlioglu
71703 UTHHD025,Ultratech,Drake Liddell
72032 FILTH005,The Filth Foundry,Insidious,Boris The Noss
72836 HOT021,Hot Box Digital,Miric
72852
72855
72856
72857
72858
73020 RRR1,Riproar Digital,X-Type,Baseglitz
73111 RR7,Riproar Digital,Baseglitz
73115 AAA176,Ahura Mazda Recordings NITRO,Burak Harsitlioglu
73116
73119 Kirsty,Lee,James,KLJ,Code,Red,Helix,Recordings,TurtleDog,Dave,Owens “Code Red” was first heard across the hard house dance floors in 2011, topping the download charts in 2012 and so it’s time for a re-release. This track sounds as new and fresh as the day it was made with big offbeat bassline, catchy vocal stabs & dirty s Kirsty,Lee,James,KLJ,Code,Red,Helix,Recordings,TurtleDog,Dave,Owens
73155 korruption,hardhouse,dancemusic korruption,hardhouse,dancemusic
73156 premonition digital,kirk p,lucille,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,hard trance premonition digital,kirk p,lucille,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,hard trance
73217
73237
73239 TMP117,Matt Clarkson,Vibrations,Tempo Trax,Hard House Hard House TMP117,Matt Clarkson,Vibrations,Tempo Trax,Hard House
73240 TMP118,GSR,Hot Gurry,Tempo Trax,Hard House Hard House TMP118,GSR,Hot Gurry,Tempo Trax,Hard House
73252
73270 Tantrum Desire, AL G Tantrum Desire, AL G Tantrum Desire, AL G
73271
73284 Kirk P Kirk P
73348
73349 The_Blackening The_Blackening The_Blackening
73350 finally finally finally
73351 Slender Man Remix Slender Man Remix Slender Man Remix
73403 Happy Hour DJ Serenity Energy Source Productions Hard House Happy Hour DJ Serenity Energy Source Productions Hard House Happy Hour DJ Serenity Energy Source Productions Hard House
73404 Feel Good Energy Source Productions DJ Serenity Hard House Feel Good Energy Source Productions DJ Serenity Hard House Feel Good Energy Source Productions DJ Serenity Hard House
73405 Ones and Twos DJ Serenity Energy Source Productions Hard House Ones and Twos DJ Serenity Energy Source Productions Hard House Ones and Twos DJ Serenity Energy Source Productions Hard House