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 (
    10566, 10499, 10474, 10473, 10472, 10471, 
    31948, 10339, 10226, 10064, 10049, 
    8088, 6289, 4064, 3580, 3578, 3577, 
    6278, 6202, 3978
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
3577 Tom's ProjectParty TimeRave On RecordingsHard HouseHard DanceNRG Tom's ProjectParty TimeRave On RecordingsHard HouseHard DanceNRG Tom's ProjectParty TimeRave On RecordingsHard HouseHard DanceNRG
3578 Johnny Napalm & Dynamic InterventionBack To The Funk (Ingo Remix)Rave On RecordingsHard HouseHard DanceNRG Johnny Napalm & Dynamic InterventionBack To The Funk (Ingo Remix)Rave On RecordingsHard HouseHard DanceNRG Johnny Napalm & Dynamic InterventionBack To The Funk (Ingo Remix)Rave On RecordingsHard HouseHard DanceNRG
3580 Tom's ProjectMindblowingRave On RecordingsHard HouseHard DanceNRG Tom's ProjectMindblowingRave On RecordingsHard HouseHard DanceNRG Tom's ProjectMindblowingRave On RecordingsHard HouseHard DanceNRG
3978 ac002,AC Tracks,Alex Cervera
4064 BAD013,B2T Academy Digital,The Don
6202 B2T013B,B2T Academy Digital,Sannah Heartfield,Sprout DJ,KS2 Presents
6278 UDT61,Underdog Trax,K-Finn,Matt Alliss
6289 UDT62,Underdog Trax,Dan Diamond
8088 UDT66,Underdog Trax,Mooney,K-Finn
10049 DNZ041,DNZ Records,Dj Oskar
10064 UDT65,Underdog Trax,Okami,HybridZ
10226 AA001,Audio Abuse Recordings,Charlie Bosh,Tom Berry,Jamie.R,Justin Daniels
10339 FRWL002,From Russia With Love,DJ Ransome
10471 YEAH048,Yeah Boi Recordings,Heath Aspinall
10472 YEAH048,Yeah Boi Recordings,Heath Aspinall
10473 YEAH048,Yeah Boi Recordings,Heath Aspinall
10474 YEAH048,Yeah Boi Recordings,Heath Aspinall
10499 RC021,Revolution Corps,Krovax
10566 YEAH049,Yeah Boi Recordings,Trix,Fl4sh
31948 LWFHDC01,LW Recordings,Chop & Change,Tranz-Linquants