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 (
    73780, 73779, 73756, 73689, 73597, 73339, 
    73242, 73628, 73776, 73775, 73774, 
    73773, 73772, 73771, 73770, 73769, 
    73768, 73767, 73766, 73765, 73764, 
    73763, 73762, 73761, 73760, 73759, 
    73288, 73311, 73283, 73282, 73281, 
    73280, 73279, 73278, 73624, 73596, 
    73595, 73338, 73216, 73215
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00063

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
73215 CheekA38,Cheeky Tracks,Nikkdbubble
73216 CheekA38,Cheeky Tracks
73242
73278 Cheek407,Cheeky Tracks,Mickey G,Joe Longbottom
73279 Cheek407,Cheeky Tracks,Joe Longbottom
73280 Cheek407,Cheeky Tracks,Joe Longbottom,Danny Clark
73281 Cheek407,Cheeky Tracks,Joe Longbottom,Danny Clark
73282 Cheek407,Cheeky Tracks,Joe Longbottom
73283 Cheek407,Cheeky Tracks,Mickey G,Joe Longbottom
73288 TT026a,Tuff Trax,Nippy Baines
73311 Leeroy Leeroy
73338
73339
73595 premonition digital,goldie,hight off the tempo,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,hard trance premonition digital,goldie,hight off the tempo,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,hard trance
73596
73597
73624 Dramatik, Filthy Kitten, Nikkdbubble, Skittles, Toolbox Recordings, Dramatik Remix, Exclusive, Toolbox Digital Download Skittles (Dramatik Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
73628 D-Fi, Unidentified, Hot Box Digital, Original Mix, Exclusive, Toolbox Digital Download Unidentified (Original Mix) by Hot Box Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HOT022,Hot Box Digital,D-FI
73689 DB031,Drop Bear Digital ,Random But Raw
73756
73759
73760
73761
73762
73763
73764
73765
73766
73767
73768
73769
73770
73771
73772
73773
73774
73775
73776
73779 Ali,M,believe,flat,4,audio,hard,house,techno Ali M delivers a fat slice of something to make your ears prick up with this little number! Guaranteed floor filler. Ali,M,believe,flat,4,audio,hard,house,techno
73780 premonition digital,beat bangers,808,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,funky,classic,bounce,hard trance premonition digital,beat bangers,808,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,funky,classic,bounce,hard trance