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 (
    104602, 104601, 102467, 102466, 102192, 
    102058, 102039, 102037, 102035, 102034, 
    104446, 102187, 102001, 101996, 101995, 
    102025, 102023, 102022, 102021, 102020
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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
101995 MOK249,Mokum Records,Rodox Trading
101996 MOK249,Mokum Records,Rodox Trading
102001 DARKULLP004t12,Darkside Unleashed,Lady Dammage,Mat Weasel Busters
102020 MMT022,Meccano Music,Meccano Twins
102021 MMT022,Meccano Music,Meccano Twins
102022 MMT022,Meccano Music,Meccano Twins
102023 MMT022,Meccano Music,Meccano Twins
102025 Mike Reverie, Sanna Hartfield, Vinylgroover, Like The Sunshine, The World Of Obsession Recordings, Mike Reverie Remix, Hardcore, Toolbox Digital Download Like The Sunshine (Mike Reverie Remix) 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. NTWO009D,The World Of Obsession Recordings,Vinylgroover,Sanna Hartfield,Mike Reverie
102034 Axel Oliver, Set You Free, OneSeventy, Extended Mix, Hardcore, Toolbox Digital Download Set You Free (Extended Mix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY124,OneSeventy,Axel Oliver
102035 ONESEVENTY124,OneSeventy,Axel Oliver
102037 DD003,Digital Dragon,Jay G,Kinn
102039 M-Project, Hardcore Vibes, Voodoo Panda, Extended Mix, Hardcore, Toolbox Digital Download Hardcore Vibes (Extended Mix) by Voodoo Panda from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. PANDA022,Voodoo Panda,M-Project
102058 XPN006E,XPN Music,X-Pander,Killer MC
102187 CRY012D,VELA Music,Crypton x Hyperverb
102192 XTR039,X-tinction Recordz,l Pa$o
102466 RID030,Rave Instinct,Painbringer
102467 RID030,Rave Instinct,Painbringer
104446 DNZF1189,DNZ Records,SethroW,Miss B
104601 BBR054,Bounce Back records,Blooded Minds,Fearless Mates
104602 BBR054,Bounce Back records,Blooded Minds,Fearless Mates