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 (
    96572, 96559, 96114, 95928, 92920, 96615, 
    96498, 95750, 95749, 96567, 96499, 
    95897, 95896, 94823, 96556, 96522, 
    96521, 96520, 96519, 96518
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00033

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
92920
94823 hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic
95749 PRN007,Perennial Recording Network,Inner City Sumo
95750 PRN007,Perennial Recording Network,Inner City Sumo,Stampatron
95896 BTN011,Bring The Noise Recordings,Ludo
95897 BTN011,Bring The Noise Recordings,Ludo
95928 Spyndl, Tantrum, Immortal Noise Recordings, Original Mix, Exclusive, Hard House, Toolbox Digital Download Tantrum (Original Mix) by Immortal Noise Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. INR071,Immortal Noise Recordings,Spyndl
96114
96498 Hardhouse, hardhousefamily, UKHardHouse, digital, TomWhyld Hard House, Hard House family, Tom Whyld
96499 Kaki Raphael, Inner-City Sumo, Kaki Trax Kaki Raphael, Inner-City Sumo, Kaki Trax
96518 the,hoover,jocks,rock,the,beat,pitch,drift the,hoover,jocks,rock,the,beat,pitch,drift the,hoover,jocks,rock,the,beat,pitch,drift
96519 pat,glenny,team,sly,airlock,pitch,drift pat,glenny,team,sly,airlock,pitch,drift pat,glenny,team,sly,airlock,pitch,drift
96520 dean,richardson,i,don't,need,you dean,richardson,i,don't,need,you dean,richardson,i,don't,need,you
96521
96522 Batten & Brow,That's How We Do It,Tuff Groove Batten & Brow - That's How We Do It - Tuff Groove Recordings Batten & Brow,That's How We Do It,Tuff Groove
96556 G.W.R., Visceral, Hard, Hard House, Hard Dance, Iverson, Visceral Records, UK Hard House, American Hard House, Hard Trance G.W.R. is BACK with another banger for Visceral's main label. This Philly-native knows his fookin' stuff and we are grateful to have it on the roster. G.W.R., Visceral, Hard, Hard House, Hard Dance, Iverson, Visceral Records, UK Hard House, American Hard House, Hard Trance
96559 superfly,hardhouse,release,digital,toolbox,hardance
96567
96572 Casey F,Move Closer, Emmanating records, Hard House Casey F,Move Closer, Emmanating records, Hard House Casey F,Move Closer, Emmanating records, Hard House
96615