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 (
    31436, 31435, 31434, 31433, 31432, 31431, 
    31430, 31429, 31428, 31427, 31426, 
    31425, 31424, 31423, 14017, 13990, 
    13989, 13968, 13987, 13986, 13985, 
    13983, 13982, 13981, 13980, 13979, 
    13978, 13977, 13976, 13975, 13974, 
    13973, 13972, 13971, 13970, 13969, 
    16527, 13892, 13891, 13882
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

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
13882 DNZ050,DNZ Records,Dj Oskar
13891 DDY027,D-Day Recordings,Dean Zone,Aether Project
13892 DDY027,D-Day Recordings,Chris Meikle
13968 NGAGED031,N-Gaged Recordings,Karlston Khaos,Leigh Green,Lox,Cally Gage
13969 T100P4,Traffic Records,Vinylgroover,The Red Hed
13970 T100P4,Traffic Records,Vinylgroover,The Red Hed
13971 T100P4,Traffic Records,Vinylgroover,The Red Hed
13972 T100P4,Traffic Records,Vinylgroover,The Red Hed
13973 T100P4,Traffic Records,Vinylgroover,Anne Savage,The Red Hed
13974 T100P4,Traffic Records,Vinylgroover,Anne Savage,The Red Hed
13975 T100P4,Traffic Records,Vinylgroover,The Red Hed
13976 T100P4,Traffic Records,Vinylgroover,The Red Hed
13977 T100P4,Traffic Records,Vinylgroover,The Red Hed
13978 T100P4,Traffic Records,Vinylgroover,The Red Hed
13979 T100P4,Traffic Records,Vince Nysse,The Stereosluts
13980 T100P4,Traffic Records,Scott Attrill
13981 T100P4,Traffic Records,Scott Attrill
13982 T100P4,Traffic Records,Scott Attrill
13983 T100P4,Traffic Records,Scott Attrill
13985 T100P4,Traffic Records,Future Disciple
13986 T100P4,Traffic Records,DJ Generator
13987 T100P4,Traffic Records,Bam Bam,Pebbles
13989 RIOT112,Riot Recordings,Scott Attrill
13990 TR085,Technikal Recordings,Technikore,Sy
14017 TR086,Technikal Recordings,Mark HybridZ
16527 MCV02,Metamorph Advance,Cryptix,Sharad
31423 LWFHDC05,LW Recordings,Eufex
31424 LWFHDC05,LW Recordings,Unit 13,Jo Kasner
31425 LWFHDC05,LW Recordings,Ermi Dj
31426 LWFHDC05,LW Recordings,The Tech-Dance Kids
31427 LWFHDC05,LW Recordings,David McRae,KrissCues
31428 LWFHDC05,LW Recordings,Dramatik
31429 LWFHDC05,LW Recordings,NUROGL,Adam T
31430 LWFHDC05,LW Recordings,Dui
31431 LWFHDC05,LW Recordings,Technikal,Andy Whitby
31432 LWFHDC05,LW Recordings,NG Rezonance
31433 LWFHDC05,LW Recordings,Ant Reynolds
31434 LWFHDC05,LW Recordings,Chaney
31435 LWFHDC05,LW Recordings,The Mungrel,Bigg 'N' Crazy
31436 LWFHDC05,LW Recordings,Neira