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 (
    70121, 70812, 70727, 70339, 70697, 70696, 
    70695, 70694, 70640, 70600, 70584, 
    70539, 70432, 70357, 70587, 70586, 
    70583, 70579, 70537, 70493, 70120, 
    69978, 69977, 70358, 70462, 70459, 
    70458, 70433, 69982, 70435, 70434, 
    70362, 70015, 70014, 70235, 70234, 
    70161, 70119, 69980, 69745
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00121

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
69745 Cheek386,Cheeky Tracks,Rick James,Cat
69977 Cheek385,Cheeky Tracks,Mikey
69978 Cheek385,Cheeky Tracks,Mikey
69980 Jon Doe, Miss Detonate Jon Doe, Miss Detonate
69982 Matt Wade, Andy T Matt Wade, Andy T
70014 DB029,Drop Bear Digital ,Snoozy,Alex Calver
70015 FILTH001,The Filth Foundry,Matt Wade,Gaz.F
70119
70120
70121
70161 premonition digital,matt wade ,pez,unreadable,music,hardhouse,filth,nrg,rave,hardhouse,trance,hard house,hard trance premonition digital,matt wade ,pez,unreadable,music,hardhouse,filth,nrg,rave,hardhouse,trance,hard house,hard trance
70234 Dan Diamond, Yo DJ, Solid State Digital, SSD035 Dan Diamond - Yo DJ Released on Solid State Digital Dan Diamond, Yo DJ, Solid State Digital, SSD035
70235
70339 HOT016,Hot Box Digital,Rat-E
70357 FILTH002,The Filth Foundry,Damaged Gudz
70358 Nikkdbubble, Random But Raw, Fuck All Ya, Toolbox Recordings, Exclusive, Toolbox Digital Download Fuck All Ya by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
70362
70432 hardhouse,harddance, hardhouse,harddance
70433
70434 Only Your Lovin, Miss Adrenaline Only Your Lovin, Miss Adrenaline Only Your Lovin, Miss Adrenaline
70435 Slim Boy Fat, AL G Slim Boy Fat, AL G Slim Boy Fat, AL G
70458
70459
70462 Filth, Damaged Gudz, Raw Power, Synths, Hoovers, RPR178,Flump-weee, Hard House, NRG Damaged Gudz make a welcome debut on Raw Power with this monster track! As expected, it's dark and filth with hoovers, brutal synths and a thundering rolling bassline. A must have for any NRG lover! Filth, Damaged Gudz, Raw Power, Synths, Hoovers, RPR178,Flump-weee, Hard House, NRG
70493 premonition digital,drake liddell,man hunt,music,hardhouse,filth,nrg,rave,boing premonition digital,drake liddell,man hunt,music,hardhouse,filth,nrg,rave,boing
70537 D-Fi, Emma Nate D-Fi, Emma Nate
70539 NeveRuMinD NeveRuMinD
70579
70583 TMP111,Homzy,Feelin' Alive,Tempo Trax,Hard House Hard House TMP111,Homzy,Feelin' Alive,Tempo Trax,Hard House
70584 TMP112,Danny Clark,Bring It On,Tempo Trax,Hard House Hard House TMP112,Danny Clark,Bring It On,Tempo Trax,Hard House
70586 Mark Heyes, Raw Power, Synths, Hoovers, RPR179,Delirious, Hard House, NRG This week we have two tracks from Mark Heyes, who is a very welcome addition to the label! Delirious has a storming bass, epic breakdown and a must have for losing yourself in the music! Mark Heyes, Raw Power, Synths, Hoovers, RPR179,Delirious, Hard House, NRG
70587 Mark Heyes, Raw Power, Synths, Hoovers, RPR179,Delirious, Hard House, Funk, Groove Mark Heyes's second tune is a bit more low key for RPR as a rule but this track has an amazing groove to it and a great track for and DJ loving a bit of fun in their set! Definitely look out for more of Mark on the label soon.... We're definitey a fan, we Mark Heyes, Raw Power, Synths, Hoovers, RPR179,Delirious, Hard House, Funk, Groove
70600
70640
70694 Leighton Smith, 4Ever, Jeli Jams, Exclusive, Toolbox Digital Download 4Ever by Jeli Jams from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. James Price, Selina Ridgway, Leighton Smith, Dave Owens, 4Ever, Forever, Jeli Jams, Exclusive, Toolbox Digital
70695
70696
70697
70727 Mark Heyes, Raw Power, Synths, Hoovers, RPR181,Feell The Filth, Hard House, Funk, Groove Mark Heyes returns to RPR with this quirky little number! With a pumping off beat bass, old skool synths and hoovers, this is sure to be a hit with any dancefloor! Mark Heyes, Raw Power, Synths, Hoovers, RPR181,Feell The Filth, Hard House, Funk, Groove
70812