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 (
    13878, 13877, 13876, 13875, 13874, 13873, 
    13872, 13870, 13869, 13829, 13862, 
    13858, 13850, 13849, 13848, 13847, 
    13846, 13845, 13844, 13843, 13842, 
    13841, 13840, 13839, 13838, 13837, 
    13836, 13835, 13834, 13833, 13832, 
    13831, 13830, 13827, 13826, 13825, 
    13824, 13823, 13822, 13821
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00066

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
13821 IHDSB007,International Hard Dance Sessions,Josh Lang
13822 IHDSB007,International Hard Dance Sessions,Kujin Fu
13823 IHDSB007,International Hard Dance Sessions,Nish
13824 IHDSB007,International Hard Dance Sessions,Shock:Force
13825 IHDSB007,International Hard Dance Sessions,S Dee
13826 IHDSB007,International Hard Dance Sessions,Wragg,Log:One
13827 IHDSB007,International Hard Dance Sessions,Stana
13829 RIOT111,Riot Recordings,Scott Attrill
13830 T100P3,Traffic Records,Vinylgroover,The Red Hed
13831 T100P3,Traffic Records,Vinylgroover,The Red Hed
13832 T100P3,Traffic Records,Vinylgroover,The Red Hed
13833 T100P3,Traffic Records,SJ Project
13834 T100P3,Traffic Records,Vinylgroover,The Red Hed
13835 T100P3,Traffic Records,Scott Attrill
13836 T100P3,Traffic Records,Joe-E
13837 T100P3,Traffic Records,Scott Attrill
13838 T100P3,Traffic Records,Mark Young,Derek Jones
13839 T100P3,Traffic Records,Vinylgroover,Anne Savage,The Red Hed
13840 T100P3,Traffic Records,Anne Savage,Scott Attrill
13841 T100P3,Traffic Records,Scott Attrill
13842 T100P3,Traffic Records,Leon B,Lucy Clarke
13843 T100P3,Traffic Records,Leon B
13844 T100P3,Traffic Records,Vinylgroover,Anne Savage,The Red Hed
13845 T100P3,Traffic Records,Vinylgroover,Andy Farley,The Red Hed
13846 T100P3,Traffic Records,Vinylgroover,The Red Hed
13847 T100P3,Traffic Records,Vince Nysse,The Stereosluts,Vinylgroover,The Red Hed
13848 T100P3,Traffic Records,Vinylgroover,The Red Hed
13849 T100P3,Traffic Records,Vinylgroover,The Red Hed
13850 T100P3,Traffic Records,Vinylgroover,The Red Hed
13858 ACTD008,Active Sound Records,Kernnel
13862 FLMBD029,Flammable Hard Dance,Matt E.B
13869 ES105,Electrik Shandy Recordings,Eddie Hallett
13870 ES105,Electrik Shandy Recordings,Criostasis,Leon Clarke
13872 ES105,Electrik Shandy Recordings,Helen Greenwood
13873 ES105,Electrik Shandy Recordings,Philthy Jennorators
13874 ES105,Electrik Shandy Recordings,Dan Kelly,Lucy Clarke,Klonez
13875 ES105,Electrik Shandy Recordings,Prime Perception
13876 ES105,Electrik Shandy Recordings,Revolution 19
13877 ES105,Electrik Shandy Recordings,Rob.O.T.T,Mark Young,Derek Jones
13878 ES105,Electrik Shandy Recordings,Shaun T