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 (
    106025, 106554, 106553, 105994, 106512, 
    105990, 105989, 105982, 105980, 106364, 
    105818, 105817, 105816, 105815, 105814, 
    106445, 105810, 105809, 106372, 106352
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00029

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
105809 STM066,Stamina Records,Rick Chubbs
105810 STM066,Stamina Records,Rick Chubbs
105814 DARKUG007,Darkside Underground,Adventurous Adam,Subhuman Disorder
105815 DARKUG007,Darkside Underground,Calum Moore
105816 DARKUG007,Darkside Underground,Adventurous Adam
105817 DARKUG007,Darkside Underground,Calum Moore
105818 DARKUG007,Darkside Underground,Adventurous Adam,Calum Moore
105980 JTS, Pulsar, XTC, OneSeventy, Extended Mix, Hardcore, Toolbox Digital Download XTC (Extended Mix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY128,OneSeventy,Pulsar,JTS
105982 ONESEVENTY128,OneSeventy,Pulsar,JTS
105989 HellsVip024,Hell's Recordings,Dj Mastersound
105990 HellsVip024,Hell's Recordings,Dj Mastersound
105994 STDIGI055,Smiley Tunes Digital,Science Of Core
106025 STI290,Stomp-Inc UK,JKO
106352 247HCLP021,24/7 Hardcore,DJ Stompy,Eazyvibe
106364 DARKUL139,Darkside Unleashed,Rob Da Rhythm
106372 XTR044C,X-tinction Recordz,Serpent Godz
106445 area 51, skinwalker, do you want to play a game, hardcore, gabber, 200 bpm, saw, ominous digital We welcome Area 51 and Skinwalker to the Ominous family. They brought a relentless, 200 bpm gabber track that takes a famous question from Saw, awaiting your answer... area 51, skinwalker, do you want to play a game, hardcore, gabber, 200 bpm, saw, ominous digital
106512 Bridgey-B, KINN, Nobody, I Can Feel, Justice Hardcore, KINN Remix, Hardcore, Toolbox Digital Download I Can Feel (KINN Remix) by Justice Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JH338,Justice Hardcore,Bridgey-B,Nobody,KINN
106553 XTR045,X-tinction Recordz,Tony AKS
106554 XTR045,X-tinction Recordz,Tony AKS