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 (
    14819, 14818, 39047, 14808, 14807, 23244, 
    23237, 14795, 14720, 14713, 14730, 
    14728, 14726, 14723, 14722, 14787, 
    14701, 76378, 76377, 14677, 14663, 
    14662, 14661, 14660, 14659, 14658, 
    14657, 14656, 14654, 14653, 14652, 
    14651, 14649, 14648, 14647, 14646, 
    14645, 14644, 14643, 14642
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00059

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
14642 RIOTCDD018,Riot Recordings,Scott Attrill
14643 RIOTCDD018,Riot Recordings,BK
14644 RIOTCDD018,Riot Recordings,Joe Rogers
14645 RIOTCDD018,Riot Recordings,Scott Attrill
14646 RIOTCDD018,Riot Recordings,Scott Attrill
14647 RIOTCDD018,Riot Recordings,BK,Ali Wilson
14648 RIOTCDD018,Riot Recordings,Scott Attrill
14649 RIOTCDD018,Riot Recordings,Scott Attrill
14651 RIOTCDD018,Riot Recordings,BK,Vinylgroover,The Red Hed
14652 RIOTCDD018,Riot Recordings,Scott Attrill
14653 RIOTCDD018,Riot Recordings,StripE
14654 RIOTCDD018,Riot Recordings,DJ Generator
14656 HDH003,Total Hard Dance,Anne Savage,Gridbreaker
14657 HDH003,Total Hard Dance,Anne Savage,Klubfiller
14658 HDH003,Total Hard Dance,Anne Savage,Vinylgroover,The Red Hed
14659 HDH003,Total Hard Dance,Organ Donors,Anne Savage
14660 HDH003,Total Hard Dance,Lisa Lashes,Anne Savage
14661 HDH003,Total Hard Dance,Anne Savage,Klubfiller
14662 HDH003,Total Hard Dance,Anne Savage,Vinylgroover,The Red Hed
14663 HDH003,Total Hard Dance,BK,Anne Savage
14677 NOIZE015,Noize Recordings,Rob Prior
14701 HNRS010,Hardnoise Records,Nando CP
14713 FLMBD031,Flammable Hard Dance,Matt Alliss
14720 TR104,Traffic Records,Syrus
14722 TTEHTA004,Total Hard Dance,Alex Kidd,In2Ition,Sa.Vee.Oh
14723 TTEHTA004,Total Hard Dance,Alex Kidd,Dark by Design
14726 TTEHTA004,Total Hard Dance,Dark by Design
14728 TTEHTA004,Total Hard Dance,Fausto,Wragg,Logone,Original
14730 TTEHTA004,Total Hard Dance,Shock:Force
14787 MCR01,Metamorph Rapture,Mechanical Pressure,Thalya Hill,JY Jelly
14795 ATMOSUKDIG028,Atmosphere Recordings:UK,Iain Cross
14807 NTRr008,NTR Red,Swartz & Schulner
14808 NTRr008,NTR Red,Swartz & Schulner
14818 NDS001,Riot Recordings,Scott Attrill
14819 NDS001,Riot Recordings,Scott Attrill
23237 COMPLEXCD002,Complex Recordings,The Phrenetic Project
23244 COMPLEXCD002,Complex Recordings,The Phrenetic Project
39047 EDD012,Emotive Dance Digital,Loleilo DJ,Ladypink DJ
76377 ID05ARR,IDEAL,Technikal,Max Mozart,Farisha
76378 ID05ARR,IDEAL,Technikal,Max Mozart,Farisha