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 (
    99381, 99279, 92940, 99916, 99866, 99806, 
    99805, 99804, 99790, 99789, 99753, 
    99751, 99439, 99434, 99429, 99278, 
    99257, 99219, 99372, 99360
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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 20 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
92940
99219
99257 Outspoken Outsider, F-Trax Digital,FT002 Outspoken Outsider, F-Trax Digital,FT002 Outspoken Outsider, F-Trax Digital,FT002
99278
99279
99360 Dark Suspects,Watch Ya Step,RipRoar Digital,
99372 K-Zone, James Nardi, Danny Gilligan, Hard House, Hard Dance, Filth, K-Zone, James Nardi, Danny Gilligan, Hard House,
99381 HOT088,Hot Box Digital,Gaz Pritchard,Team Sly
99429 Dan Carter, Frantic Digital, Hard Trance, Narcotic Bass Dan Carter, Frantic Digital, Hard Trance, Narcotic Bass
99434
99439 Hard House, Slenderman, Ross Farley, RF3, Hard Dance, Electric, Visceral Main The 2nd to last release from the incredible IN:VISION album, Slenderman and Ross Farley (RF3) bring you At Night Hard House, Slenderman, Ross Farley, RF3, Hard Dance, Electric, Visceral Main
99751
99753 Valex, Vespa, Waltered, Nitrox, Exclusive, Toolbox Digital Download Waltered by Nitrox from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
99789 Full Circle Productions zillin, full circle productions
99790 full circle productions, Homzy, zillin homzy, full circle productions, zillin
99804
99805
99806
99866 DJ One7TOut, Project Freelancer, Hi-Five Digital , Exclusive, Toolbox Digital Download Project Freelancer by Hi-Five Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
99916 Rick James Fab Rick James Fab Rick, James, Fab