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 (
    14641, 14640, 14637, 14635, 14634, 14633, 
    14632, 14631, 14630, 14629, 14628, 
    14627, 14626, 14481, 14480, 14482, 
    24684, 24683, 14436, 14434, 14438, 
    14437, 14411, 16539, 14409, 14410, 
    14101, 14138, 14137, 31447, 31446, 
    31445, 31444, 31443, 31442, 31441, 
    31440, 31439, 31438, 31437
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00072

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
14101 ATMOSUKDIG027,Atmosphere Recordings:UK,Wragg
14137 HARD063,SDK Hard,Ryosuke
14138 HARD063,SDK Hard,Ryosuke
14409 AD007,Absolution Digital,Danny Williamson
14410 AD007,Absolution Digital,Danny Williamson
14411 DNZ053,DNZ Records,Salva Dj
14434 FLMBD030,Flammable Hard Dance,Ant Reynolds,Junky Twins
14436 RIOT113,Riot Recordings,Scott Attrill
14437 DNZ061,DNZ Records,Ginxi Dj
14438 DNZ061,DNZ Records,Ginxi Dj,Dj Oskar,Dj Suko
14480 HARD064,SDK Hard,The Phrenetic Project
14481 UV013,Ultraviolence Recordings,Ultraviolence
14482 UV013,Ultraviolence Recordings,Ultraviolence,The Monitorz
14626 IHDSB008,International Hard Dance Sessions,NXT
14627 IHDSB008,International Hard Dance Sessions,Kujin Fu
14628 IHDSB008,International Hard Dance Sessions,Andrea Montorsi,In2Ition
14629 IHDSB008,International Hard Dance Sessions,Fausto,Phill York,Original
14630 IHDSB008,International Hard Dance Sessions,Proteus
14631 IHDSB008,International Hard Dance Sessions,Geck-O
14632 IHDSB008,International Hard Dance Sessions,DJ Thera
14633 IHDSB008,International Hard Dance Sessions,Oyaebu
14634 IHDSB008,International Hard Dance Sessions,Phil York,Jim Justice
14635 IHDSB008,International Hard Dance Sessions,Scott Attrill
14637 TR105,Traffic Records,Cut Up
14640 RIOTCDD018,Riot Recordings,Scott Attrill
14641 RIOTCDD018,Riot Recordings,BK,Vinylgroover
16539 MCV03,Metamorph Advance,Clayfacer
24683 COMPLEX015,Complex Recordings,The Phrenetic Project
24684 COMPLEX015,Complex Recordings,The Phrenetic Project
31437 LWFHDC05,LW Recordings,Elivate,Matt E.B
31438 LWFHDC05,LW Recordings,Ultraviolence
31439 LWFHDC05,LW Recordings,Rob O.T.T
31440 LWFHDC05,LW Recordings,Zone ONE
31441 LWFHDC05,LW Recordings,TalkSin
31442 LWFHDC05,LW Recordings,Ben Stevens,Adam M,WhiteHayz
31443 LWFHDC05,LW Recordings,On NRG
31444 LWFHDC05,LW Recordings,DJ IKKODATE
31445 LWFHDC05,LW Recordings,Cally Gage,Energy Syndicate,Lox,Leigh Green
31446 LWFHDC05,LW Recordings,Kipster
31447 LWFHDC05,LW Recordings,C&D Project