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 (
    65260, 65340, 65210, 64553, 65258, 65257, 
    65256, 65255, 65254, 65253, 65252, 
    65251, 65250, 65249, 65248, 65247, 
    65246, 65245, 65244, 65243, 65242, 
    65241, 65240, 65239, 65238, 65237, 
    65236, 65235, 65234, 65233, 65232, 
    65231, 65230, 65229, 65163, 65162, 
    65161, 65160, 65159, 65114
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00046

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
64553 hardhouse,tarabanks,fame,hungry,premonition,digital,tara,banks,hard,house hardhouse,tarabanks,fame,hungry,premonition,digital,tara,banks,hard,house
65114 frank,farrell,motion,picture,remaster,igloo,wax,allstars frank,farrell,motion,picture,remaster,igloo,wax,allstars
65159 frank,farrell,symbiotic,igloo,allstars,wax,remaster frank,farrell,symbiotic,igloo,allstars,wax,remaster
65160 frank,farrell,dave,owens,manslap,remaster,igloo,wax.allstars frank,farrell,dave,owens,manslap,remaster,igloo,wax.allstars
65161 riggsy,frank,farrell,disabled,disco,remaster,igloo,wax,allstars riggsy,frank,farrell,disabled,disco,remaster,igloo,wax,allstars
65162 frank,farrell,riggsy,electribe,remaster,igloo,wax,allstars frank,farrell,riggsy,electribe,remaster,igloo,wax,allstars
65163 frank,farrell,steve,maynard,little,fella,igloo,wax,allstars,remaster frank,farrell,steve,maynard,little,fella,igloo,wax,allstars,remaster
65210 Kirk P Kirk P
65229
65230
65231
65232
65233
65234
65235
65236
65237
65238
65239
65240
65241
65242
65243
65244
65245
65246
65247
65248
65249
65250
65251
65252
65253
65254
65255
65256
65257
65258
65260
65340 jump, hardhouse, jumptrax jump, hardhouse, jumptrax jump, hardhouse, jumptrax