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 (
    88722, 88721, 88720, 88719, 88718, 88717, 
    88716, 88715, 88714, 88713, 88712, 
    88711, 88710, 88709, 88708, 88707, 
    88706, 89080, 89079, 89078, 88676, 
    88675, 88674, 88920, 88919, 88493, 
    89075, 88916, 88491, 89082, 89030, 
    89029, 89028, 88996, 88995, 88994, 
    88993, 88981, 88520, 88495
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00062

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 40 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
88491 TiOS096,TIOS Digital,GERCORE
88493 TiOS097,TIOS Digital,Pez
88495 CRR036,Core Rebelz Records,Zeom,AmnesiA
88520 Rave20201,Rave Essentials,Bridson X Rikston
88674 ONESEVENTY75,OneSeventy,Mike Reverie
88675 ONESEVENTY75,OneSeventy,Mike Reverie
88676 HBA0018,Hard Beat Asylum,Kashi
88706 CRR037,Core Rebelz Records,Preacker
88707 CRR037,Core Rebelz Records,Preacker
88708 CRR037,Core Rebelz Records,Preacker
88709 TiOSALBUM005,TIOS Digital,Nylar,GERCORE
88710 TiOSALBUM005,TIOS Digital,Danny R-Core
88711 TiOSALBUM005,TIOS Digital,Richie
88712 TiOSALBUM005,TIOS Digital,M3-O,GERCORE
88713 TiOSALBUM005,TIOS Digital,V-Star,Jonny El
88714 TiOSALBUM005,TIOS Digital,Craig Daze
88715 TiOSALBUM005,TIOS Digital,M3-O,X-Cyte
88716 TiOSALBUM005,TIOS Digital,Jay G
88717 TiOSALBUM005,TIOS Digital,M3-O
88718 TiOSALBUM005,TIOS Digital,Powerbounce
88719 TiOSALBUM005,TIOS Digital,JKO
88720 TiOSALBUM005,TIOS Digital,Powerbounce
88721 TiOSALBUM005,TIOS Digital,JKO
88722 TiOSALBUM005,TIOS Digital,Powerbounce
88916 BAB005,Bombs & Bullets Records,Hyrule War,Sprinky,Claire Classicore
88919 RRS002,Recharged,Surgery
88920 RRS002,Recharged,Surgery
88981 247HC204,24/7 Hardcore,Vinylgroover,Al Storm
88993 247HC205,24/7 Hardcore,M-Project,Signal,UTX
88994 247HC205,24/7 Hardcore,M-Project,Signal,S2i8
88995 247HC205,24/7 Hardcore,M-Project,Signal
88996 247HC205,24/7 Hardcore,M-Project,Kamikaze
89028 DARKUL023,Darkside Unleashed,Mikey Motion,Chuff
89029 DARKUL023,Darkside Unleashed,Mikey Motion,Chuff
89030 DARKUL023,Darkside Unleashed,Mikey Motion,Chuff
89075 XZONE041,X-Zone,Ragga Wolvz
89078 RID023,Rave Instinct,Painbringer
89079 RID023,Rave Instinct,Painbringer
89080 RID023,Rave Instinct,Painbringer
89082 UKDD0042,UK Dance Records,Jamie Ritmen