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 (
    88127, 88126, 88125, 88124, 87662, 87418, 
    87417, 87416, 87415, 87414, 87413, 
    87412, 87411, 87410, 87409, 87363, 
    87362, 87158, 87157, 87659, 88123, 
    88122, 87708, 87707, 87676, 87675, 
    87475, 87169, 87083, 87082, 87081, 
    87067, 87024, 87854, 87853, 87852, 
    87713, 87712, 87711, 87710
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

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
87024 STI0159,Stomp-Inc UK,Shameless,Awdy T
87067 CF057,Core Fever,Chris Fear
87081 RAVEMUZIK036,Rave Muzik,Project XTC
87082 RAVEMUZIK036,Rave Muzik,Project XTC
87083 RAVEMUZIK036,Rave Muzik,R Evolve,Project XTC
87157 STM055,Stamina Records,Digital Commandos,MC Cyx
87158 STM055,Stamina Records,Digital Commandos
87169 VDH044,Various Digital Hardcore,Overdrive
87362 CR0182,Contagious Records,Nizzle,Paul Repleay
87363 CR0182,Contagious Records,Nizzle,Paul Repleay
87409 HUAACD010,Hardcore Underground,Entity
87410 HUAACD010,Hardcore Underground,Entity,Darwin
87411 HUAACD010,Hardcore Underground,Entity,Darwin
87412 HUAACD010,Hardcore Underground,Entity
87413 HUAACD010,Hardcore Underground,Entity
87414 HUAACD010,Hardcore Underground,Fracus & Entity,Fraz,Entity
87415 HUAACD010,Hardcore Underground,Entity
87416 HUAACD010,Hardcore Underground,Fracus,Entity
87417 HUAACD010,Hardcore Underground,Entity,Dune
87418 HUAACD010,Hardcore Underground,Entity
87475 STI0146,Stomp-Inc UK,BenAddikt,Elektrik
87659 STI0145,Stomp-Inc UK,BenAddikt,Blade,Praetor
87662 JH284,Justice Hardcore,EzKill
87675 DSB032,Disobey records,Chemical Gorilla,Meccano Twins
87676 DSB032,Disobey records,Giuly,Alee
87707 RELIGION007,Religion Recordings,Joey Riot,Seduction
87708 RELIGION007,Religion Recordings,Joey Riot,Seduction
87710 MOUTH04,Motormouth Recordz,Satronica
87711 MOUTH04,Motormouth Recordz,Deathmachine
87712 MOUTH04,Motormouth Recordz,Al Twisted,Rob Da Rhythm,Negative A
87713 MOUTH04,Motormouth Recordz,Sadistic
87852 DARKUL017,Darkside Unleashed,Rob Da Rhythm
87853 DARKUL017,Darkside Unleashed,Rob Da Rhythm
87854 DARKUL017,Darkside Unleashed,Rob Da Rhythm
88122 MOUTHDATA087,Motormouth Recordz,The Satan
88123 MOUTHDATA087,Motormouth Recordz,The Satan
88124 DARKUL018,Darkside Unleashed,V.S.C.
88125 DARKUL018,Darkside Unleashed,V.S.C.
88126 DARKUL018,Darkside Unleashed,V.S.C.
88127 DARKUL018,Darkside Unleashed,V.S.C.