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 (
    102379, 102378, 102377, 102376, 102375, 
    102374, 102373, 102372, 102371, 102370, 
    102369, 102348, 102346, 102345, 102344, 
    102343, 102342, 102341, 102340, 102339
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00022

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
102339 TIDYCTA001DB,Tidy,Ingo
102340 TIDYCTA001DB,Tidy,Bulletproof
102341 TIDYCTA001DB,Tidy,Ben Stevens
102342 TIDYCTA001DB,Tidy,Andy Naylor,Hayley Colleen
102343 TIDYCTA001DB,Tidy,Starquake
102344 TIDYCTA001DB,Tidy,Max Mozart,Lia B
102345 TIDYCTA001DB,Tidy,Bass Jumper
102346 TIDYCTA001DB,Tidy,Nick Rafferty,Velos
102348 TIDYCTA001DB,Tidy,NG Rezonance,PHD,Hayley Colleen,Stimulant DJ's
102369 TIDYCTA001DA,Tidy,Sam Townend
102370 TIDYCTA001DA,Tidy,James Revill
102371 TIDYCTA001DA,Tidy,Ben Stevens,Sam Townend
102372 TIDYCTA001DA,Tidy,Nicholson
102373 TIDYCTA001DA,Tidy,Eamonn Fevah,NuroGL
102374 TIDYCTA001DA,Tidy,NG Rezonance,PHD
102375 TIDYCTA001DA,Tidy,The Tidy Boys
102376 TIDYCTA001DA,Tidy,Colin Barratt
102377 TIDYCTA001DA,Tidy,Digital Mafia,JLF
102378 TIDYCTA001DA,Tidy,Tidy DJ's,Jon BW
102379 TIDYCTA001DA,Tidy,Paul Maddox