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 (
    95595, 95594, 95593, 95592, 95591, 95590, 
    95589, 95588, 95587, 95586, 95585, 
    95584, 95583, 95582, 95581, 95580, 
    95579, 95578, 95577, 95576, 95575, 
    95574, 95573, 95572, 95571, 94905, 
    95440, 95439, 94679, 94678, 94677, 
    94676, 94675, 94674, 94673, 94672, 
    94659, 94629, 94628, 94626
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00076

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
94626 NUNRG71to80RM,Nu Energy Records,Transcend
94628 Cally, J-Trax, Jakka-B, Macks Wolf, Hold On, HDUK, Jakka-B & Macks Wolf Remix (Extended Mix), Featured Hardcore New, Hardcore, Toolbox Digital Download Hold On (Jakka-B & Macks Wolf Remix (Extended Mix)) by HDUK from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HDUK009,HDUK,Cally,J-Trax,Jakka-B,Macks Wolf
94629 HDUK009,HDUK,Cally,J-Trax,Jakka-B,Macks Wolf
94659 HPU005,Hardcore Producer: United As One,Samba D,Ellie Jay,X-Cyte
94672 Silver004,Hell's Recordings,Lunatic,Miss Hysteria
94673 Silver004,Hell's Recordings,Bartoch
94674 Silver004,Hell's Recordings,Bartoch
94675 Silver004,Hell's Recordings,Miss Hysteria
94676 Silver004,Hell's Recordings,Bartoch
94677 Silver004,Hell's Recordings,D-Spirit
94678 Silver004,Hell's Recordings,Bartoch
94679 Silver004,Hell's Recordings,Razor Edge
94905 XTR010,X-tinction Recordz,Dark Intentions,Sasha F
95439 MRV241,Megarave Records,Hardheads,F.Noize
95440 MRV241,Megarave Records,Rotterdam Terror Corps,F.Noize
95571 MR090,Megarave Records,Dione
95572 MR090,Megarave Records,Dr. Z-Vago,E-Noid
95573 MR090,Megarave Records,Roughsketch
95574 MR090,Megarave Records,Kasparov
95575 MR090,Megarave Records,Partyraiser,Chrono,The Demon Dwarf
95576 MR090,Megarave Records,Headbanger
95577 MR090,Megarave Records,Roughsketch
95578 MR090,Megarave Records,Dione
95579 MR090,Megarave Records,Squaresoundz
95580 MR090,Megarave Records,The Genesis Projection
95581 MR090,Megarave Records,Tones
95582 MR090,Megarave Records,Roughsketch
95583 MR090,Megarave Records,Ruffneck & Dione
95584 MR090,Megarave Records,Tieum,Partyraiser,MC Da Hustla
95585 MR090,Megarave Records,Chrono
95586 MR090,Megarave Records,DestructiveTendencies
95587 MR090,Megarave Records,Roughsketch
95588 MR090,Megarave Records,Dione
95589 MR090,Megarave Records,HardcoreMasterzVienna
95590 MR090,Megarave Records,Rotterdam Terror Corps,The Beatkrusher
95591 MR090,Megarave Records,The Unfamous
95592 MR090,Megarave Records,Cardan
95593 MR090,Megarave Records,Artifex&D-Master
95594 MR090,Megarave Records,System 3
95595 MR090,Megarave Records,Partyraiserfeat.Corecell