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 (
    109673, 109488, 109235, 109234, 109233, 
    109737, 109148, 109147, 109146, 109145, 
    109144, 109143, 109142, 109779, 109778, 
    109135, 109702, 109701, 109700, 109699
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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
109135 STI304,Stomp-Inc UK,RPL
109142 RAVEMUZIK056,Rave Muzik,Stormtrooper,Project XTC
109143 RAVEMUZIK056,Rave Muzik,Stormtrooper,Project XTC
109144 RAVEMUZIK056,Rave Muzik,Stormtrooper,Project XTC
109145 MOK264,Mokum Records,DJ Balli
109146 MOK264,Mokum Records,DJ Balli
109147 MOK264,Mokum Records,DJ Balli
109148 MOK264,Mokum Records,DJ Balli
109233 Klubfiller, Magic, Klubbed Up, Original Mix, Hard Dance, Toolbox Digital Download Magic (Original Mix) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU91D,Klubbed Up,Klubfiller
109234 CSD119,The Chop Shop Digital,Tiny T
109235 Dionne, Samba D, Together Again, The World Of Obsession Recordings, Extended Mix, Hardcore, Toolbox Digital Download Together Again (Extended 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. NTWO023,The World Of Obsession Recordings,Samba D,Dionne
109488 Al Storm, Dazzler B, Rob Iyf, Fire, 24/7 Hardcore, Original Mix, Hardcore, Toolbox Digital Download Fire (Original Mix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC279,24/7 Hardcore,Rob IYF,Al Storm,Dazzler B
109673 PANDA031,24/7 Hardcore,FREQ-DLT,Rob IYF,Al Storm,Christine
109699 BBR058,Bounce Back records,Beatsbomber
109700 BBR058,Bounce Back records,Beatsbomber
109701 Alaguan, Be Prepared, 24/7 Hardcore, Extended Mix, Hardcore, Toolbox Digital Download Be Prepared (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. 247HC280,24/7 Hardcore,Alaguan
109702 247HC280,24/7 Hardcore,Alaguan
109737 DNZF1330,DNZ Records,SethroW
109778 VDR022,Violent Disorder Records,Striker,Persecute
109779 VDR022,Violent Disorder Records,Striker,Persecute