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 (
    101689, 101688, 102270, 102269, 102268, 
    101746, 101745, 101744, 101743, 101615, 
    101614, 101960, 101569, 101568, 101567, 
    101566, 101540, 101539, 101969, 102183
  ) 
  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 20 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
101539 TOKDD18,Tears Of Kunlun,Archefluxx
101540 TOKDD18,Tears Of Kunlun,Archefluxx
101566 MOK248,Mokum Records,Aggroman
101567 MOK248,Mokum Records,Aggroman
101568 MOK248,Mokum Records,Aggroman
101569 MOK248,Mokum Records,ASF,Aggroman
101614 Jennifer Rene, Technikore, The Power Of You, OneSeventy, Extended Mix, Hardcore, Toolbox Digital Download The Power Of You (Extended Mix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY123,OneSeventy,Technikore,Jennifer Rene
101615 ONESEVENTY123,OneSeventy,Technikore,Jennifer Rene
101688 Vinylgroover, Hands Up, The World Of Obsession Recordings, Original Mix, Hardcore, Toolbox Digital Download Hands Up (Original Mix) by The World Of Obsession Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NTWO009,The World Of Obsession Recordings,Vinylgroover
101689 Solo, I've Been Very Good, Stomp-Inc UK, Original Mix, Hardcore, Toolbox Digital Download I've Been Very Good (Original Mix) by Stomp-Inc UK from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STI288,Stomp-Inc UK,Solo
101743 247HC254,24/7 Hardcore,Ezkill
101744 EzKiLL, Not This Time, 24/7 Hardcore, Extended Mix, Hardcore, Toolbox Digital Download Not This Time (Extended Mix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC254,24/7 Hardcore,Ezkill
101745 247HC254,24/7 Hardcore,Ezkill
101746 247HC254,24/7 Hardcore,Ezkill
101960 DARKULLP004t09,Darkside Unleashed,Lady Dammage,Bulletproof
101969 DNZF1174,DNZ Records,CDuggyz,Ed Hertz,Mellow D
102183 XTR037,X-tinction Recordz,Dj Mastersound,MC Squabbler
102268 EX060,Exode Records,Shinra Tensei
102269 EX060,Exode Records,Shinra Tensei
102270 EX060,Exode Records,Shinra Tensei