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 (
    87227, 87226, 87225, 87224, 87223, 87222, 
    87221, 87220, 87219, 87218, 87217, 
    87216, 87000, 86999, 86998, 86997, 
    86996, 86995, 86994, 86993, 86506, 
    86447, 86446, 86445, 86444, 86384, 
    86383, 86382, 86381, 86380, 86379, 
    86378, 86377, 86376, 86375, 86374, 
    87116, 86470, 86469, 86468
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00069

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
86374 TFCD020D,TERRAFORM MUSIC,M-Project,Mitomoro
86375 TFCD020D,TERRAFORM MUSIC,M-Project,Venz
86376 TFCD020D,TERRAFORM MUSIC,Relect,M-Project
86377 TFCD020D,TERRAFORM MUSIC,M-Project
86378 TFCD020D,TERRAFORM MUSIC,M-Project,S2i8
86379 TFCD020D,TERRAFORM MUSIC,M-Project
86380 TFCD020D,TERRAFORM MUSIC,M-Project
86381 TFCD020D,TERRAFORM MUSIC,Mitomoro,M-Project
86382 TFCD020D,TERRAFORM MUSIC,M-Project,UTX
86383 TFCD020D,TERRAFORM MUSIC,M-Project
86384 TFCD020D,TERRAFORM MUSIC,4*,M-Project
86444 DARKUL010,Darkside Unleashed,Soul Destroyer
86445 DARKUL010,Darkside Unleashed,Soul Destroyer
86446 DARKUL010,Darkside Unleashed,Soul Destroyer
86447 DARKUL010,Darkside Unleashed,Soul Destroyer
86468 DARKUL009,Darkside Unleashed,Thunder
86469 DARKUL009,Darkside Unleashed,Thunder
86470 DARKUL009,Darkside Unleashed,Thunder
86506 VDH041,Various Digital Hardcore,Overdrive,Monster
86993 247HC197,24/7 Hardcore,Rob IYF
86994 247HC197,24/7 Hardcore,Rob IYF
86995 247HC197,24/7 Hardcore,Rob IYF,Slay
86996 247HC197,24/7 Hardcore,Rob IYF,Slay
86997 247HC197,24/7 Hardcore,Rob IYF,Recore DJ
86998 247HC197,24/7 Hardcore,Rob IYF,Recore DJ
86999 247HC197,24/7 Hardcore,Rob IYF,Monster
87000 247HC197,24/7 Hardcore,Rob IYF,Monster
87116 JH279,Justice Hardcore,Riko,X-Fadid
87216 LWHTE12,LW Recordings,Manu Kenton
87217 LWHTE12,LW Recordings,Noks
87218 LWHTE12,LW Recordings,Goncalo M
87219 LWHTE12,LW Recordings,A.P.,J-Tech
87220 LWHTE12,LW Recordings,Marco Ginelli,Kamil Van Derson
87221 LWHTE12,LW Recordings,Gcubed
87222 LWHTE12,LW Recordings,N.O.B.A
87223 LWHTE12,LW Recordings,Hideyoshi
87224 LWHTE12,LW Recordings,Tonikattitude
87225 LWHTE12,LW Recordings,Jordy Martin
87226 LWHTE12,LW Recordings,Rave Syndicate,Koredeiv
87227 LWHTE12,LW Recordings,Akkon,RBX,MSL-T