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 (
    104248, 104288, 104287, 102289, 102288, 
    102287, 102286, 102285, 102284, 102283, 
    102282, 102278, 104481, 104480, 104479, 
    104478, 104477, 104476, 104475, 104474
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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
102278 Al Storm, Rob Iyf, Whizzkid, Blow The House Down, Voodoo Panda, Extended Mix, Hardcore, Toolbox Digital Download Blow The House Down (Extended Mix) by Voodoo Panda from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. PANDA033,Voodoo Panda,Rob IYF,Al Storm,Whizzkid
102282 Eufeion, New Day, 24/7 Hardcore, Extended Mix, Hardcore, Toolbox Digital Download New Day (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. 247HC256,24/7 Hardcore,Eufeion
102283 247HC256,24/7 Hardcore,Eufeion
102284 247HC256,24/7 Hardcore,Eufeion
102285 247HC256,24/7 Hardcore,Eufeion
102286 247HC256,24/7 Hardcore,Eufeion
102287 247HC256,24/7 Hardcore,Eufeion
102288 247HC256,24/7 Hardcore,Eufeion
102289 247HC256,24/7 Hardcore,Eufeion
104248 Hells058,Hell's Recordings,D-Tempo
104287 TAMBAT, Losing You, OneSeventy, Extended Mix, Hardcore, Toolbox Digital Download Losing You (Extended Mix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY125,OneSeventy,TAMBAT
104288 ONESEVENTY125,OneSeventy,TAMBAT
104474 MOUTHLP006,Motormouth Recordz,eDUB,Contagious Madness
104475 MOUTHLP006,Motormouth Recordz,Dolphin
104476 MOUTHLP006,Motormouth Recordz,Dataklysm,DJ Tugie
104477 MOUTHLP006,Motormouth Recordz,Khaoz Engine,Nuke
104478 MOUTHLP006,Motormouth Recordz,Detest,Matt Green,Sieben Stein
104479 MOUTHLP006,Motormouth Recordz,Hellfish,Bryan Fury
104480 MOUTHLP006,Motormouth Recordz,Deathmachine
104481 MOUTHLP006,Motormouth Recordz,Doormouse