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 (
    67841, 68817, 67790, 67789, 67788, 67787, 
    67786, 67785, 67784, 67783, 67782, 
    67781, 67780, 67779, 67778, 67777, 
    67776, 67775, 67774, 67773, 67772, 
    67771, 68694, 68693, 68661, 68532, 
    68124, 68123, 68692, 68662, 68573, 
    68531, 68374, 68361, 68199, 67871, 
    67844, 67843, 67840, 68201
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00068

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
67771
67772
67773
67774
67775
67776
67777
67778
67779
67780
67781
67782
67783
67784
67785
67786
67787
67788
67789
67790
67840 Kirsty Walker, Ryan Handley, Hoovers Of Hell, Vicious Circle, Exclusive, Toolbox Digital Download Hoovers Of Hell by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
67841
67843
67844
67871
68123 Cheek375,Cheeky Tracks,Rick James,General Bounce
68124 Cheek375,Cheeky Tracks,Rick James,General Bounce
68199 Asylum, Dan Dyson, Whats Your Jam?, Drop Bear Digital , Dan Dyson Remix, Exclusive, Toolbox Digital Download Whats Your Jam? (Dan Dyson Remix) by Drop Bear Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DB025,Drop Bear Digital ,Asylum,Dan Dyson
68201 TMP106,One Foot In The Rave,Take You Back,Tempo Trax,Hard House Hard House TMP106,One Foot In The Rave,Take You Back,Tempo Trax,Hard House
68361 SLENDERMAN, DEAD, Fruition Records, Exclusive, Toolbox Digital Download DEAD by Fruition Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
68374 HOT008,Hot Box Digital,Matt Wade,Syanide
68531 Cupra,Hard House, Axis, Slingshot Cupra,Hard House, Axis, Slingshot
68532 premonition digital,drake liddell,somebody,music,hardhouse,filth,nrg,rave,tidy trax,tidy premonition digital,drake liddell,somebody,music,hardhouse,filth,nrg,rave,tidy trax,tidy
68573 Pluto,open,door,flat,4,audio,hard,house,acid,hoover A barrage of thunder from the fresh-faced Pluto. Pluto,open,door,flat,4,audio,hard,house,acid,hoover
68661 Paul Batten,Ground&Pound,Tuff Groove Tuff Groove back in the game after a little break. This ones been getting some serious playtime at Twist - Paul Batten with Ground & Pound enjoy! Paul Batten,Ground&Pound,Tuff Groove
68662
68692 Leeroy, Orrible Noize, Hard NRG, Hard House, Filth
68693 Random but Raw, Anna K, Orrible Noize, Filth, NRG, Hard House
68694
68817