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 (
    76145, 76144, 76143, 76142, 76141, 76140, 
    76139, 76138, 76137, 76136, 76135, 
    76134, 76133, 76132, 76095, 77060, 
    76155, 76523, 76522, 76489
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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
76095 FE210,Fatal Energy Records,IP
76132 247HCLP006DL,24/7 Hardcore,Al Storm x MC Whizzkid
76133 247HCLP006DL,24/7 Hardcore,Fracus & Darwin
76134 247HCLP006DL,24/7 Hardcore,SQUAD E
76135 247HCLP006DL,24/7 Hardcore,Al Storm,IYF,Nobody
76136 247HCLP006DL,24/7 Hardcore,Al Storm,M-Project
76137 247HCLP006DL,24/7 Hardcore,Macks Wolf
76138 247HCLP006DL,24/7 Hardcore,Eufeion
76139 247HCLP006DL,24/7 Hardcore,Darkman,Deadhead
76140 247HCLP006DL,24/7 Hardcore,DJ Demand,Re-Con
76141 247HCLP006DL,24/7 Hardcore,MY3R5,Al Storm
76142 247HCLP006DL,24/7 Hardcore,Rob IYF x MC Riddle
76143 247HCLP006DL,24/7 Hardcore,Daniel Seven
76144 247HCLP006DL,24/7 Hardcore,Al Storm,DJ Dreem
76145 247HCLP006DL,24/7 Hardcore,Mizel x Wilsxn
76155 Mike Reverie, Scott Attrill, Slammer, Riot Recordings, Mike Reverie Remix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Slammer (Mike Reverie Remix) by Riot Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. RIOT176,Riot Recordings,Scott Attrill,Mike Reverie
76489 DNZF526,DNZ Records,Garbie Project
76522 DNZF527,DNZ Records,Kritikal Mass
76523 DNZF527,DNZ Records,Kritikal Mass
77060 PTR096,Power Tracks Records,J. JBlack