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 (
    87668, 87667, 87689, 87688, 87651, 87790, 
    87789, 87681, 87758, 87757, 87756, 
    87755, 87684, 87677, 87585, 87885, 
    88049, 88048, 88047, 88046, 88045, 
    87873, 87766, 87765, 87646, 87590, 
    87589, 88131, 88130, 88129, 88128, 
    88071, 88070, 88069, 88057, 88056, 
    88055, 87482, 87481, 87487
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00060

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
87481 ONESEVENTY71,OneSeventy,Two Minds Project
87482 ONESEVENTY71,OneSeventy,Two Minds Project
87487 SD182,Scarred Digital,Shtave,Emoticon
87585 CF058,Core Fever,Chris Fear
87589 CR0183,Contagious Records,Snipes,Murf
87590 CR0183,Contagious Records,Snipes,Murf
87646 KTRAR017,Keeping The Rave Alive,Mike Steventon
87651 EXE088,Executive Records,In Effect,Jamie Ritmen
87667 DARKUL021,Darkside Unleashed,Andy The Core,Thunder
87668 DARKUL021,Darkside Unleashed,Andy The Core
87677 TiOS093,TIOS Digital,M3-O,Kevin Instinct
87681 STI0149,Stomp-Inc UK,Adam Frantic
87684 JH285,Justice Hardcore,Niki Jager
87688 CR0184,Contagious Records,Riko,Aftashok
87689 CR0184,Contagious Records,Riko,Aftashok
87755 DARKUL020,Darkside Unleashed,Dave Dope
87756 DARKUL020,Darkside Unleashed,Dave Dope,Artifex
87757 DARKUL020,Darkside Unleashed,Dave Dope,YK Project
87758 DARKUL020,Darkside Unleashed,Dave Dope
87765 UIR008,Underground Industry Records,Badkick
87766 UIR008,Underground Industry Records,Badkick,Pyraw
87789 RID021,Rave Instinct,Arvid
87790 RID021,Rave Instinct,Arvid
87873 STI0147,Stomp-Inc UK,Mikey P,Gee
87885 STI0148,Stomp-Inc UK,Slamma
88045 CRR030,Core Rebelz Records,Angstfrai
88046 CRR030,Core Rebelz Records,Angstfrai,The Janglehead Twins
88047 CRR030,Core Rebelz Records,Angstfrai
88048 CRR030,Core Rebelz Records,Angstfrai
88049 CRR030,Core Rebelz Records,Angstfrai
88055 MOK216,Mokum Records,Wicked XXX
88056 MOK216,Mokum Records,Wicked XXX
88057 MOK216,Mokum Records,Wicked XXX
88069 DARKUL019,Darkside Unleashed,Thunder
88070 DARKUL019,Darkside Unleashed,Thunder
88071 DARKUL019,Darkside Unleashed,Thunder,X-Mind
88128 MOUTHDATA005,Motormouth Recordz,The Relic
88129 MOUTHDATA005,Motormouth Recordz,Fracture 4
88130 MOUTHDATA005,Motormouth Recordz,Dolphin
88131 MOUTHDATA005,Motormouth Recordz,Sadistic