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 (
    64531, 63919, 63727, 64535, 64525, 64524, 
    64509, 64424, 64100, 64099, 63197, 
    64508, 64507, 64506, 64505, 64429, 
    64428, 64427, 64426, 64425, 64393, 
    64208, 63573, 63572, 61775, 61755, 
    64145, 64122, 64121, 64120, 61891, 
    64080, 64079, 63775, 63898, 63897, 
    63871, 63718, 63301, 63300
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00059

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
61755
61775
61891 hardhouse,resonator,steve,thornton,tidy,premonition,digital,premonitiondigital,hardtrance,harddance,nrg hardhouse,resonator,steve,thornton,tidy,premonition,digital,premonitiondigital,hardtrance,harddance,nrg
63197
63300 Cheek338,Cheeky Tracks,Brendan Ashley,Dave Owens,John Carr
63301 Cheek338,Cheeky Tracks,Brendan Ashley,Dave Owens,Vandalize
63572 Cheek350B,Cheeky Tracks,Groove Control,Gary O'Connor
63573 Cheek350B,Cheeky Tracks,Groove Control,Gary O'Connor
63718
63727 UTHHD020,Ultratech,Sam Alame,VaderMonkey
63775 Mitch Doig Spectrum Trax
63871
63897 Boris The Noss, Adrian Buss, Transformers, Jeli Jams, Exclusive, Toolbox Digital Making his debut on Jeli Jams we have Boris The Noss. Bringing you a dance floor destroyer this track is driven by a subby off beat bassline, accompanied by acids and gritty synths. The kickback is rather naughty on this number. Boris The Noss, Adrian Buss, Transformers, Jeli Jams, Exclusive, Toolbox Digital, Selina Ridgway, James Price, Hard Jeli
63898
63919 Mischief Duo,Chaos,Disorder,chaos and disorder Mischief Duo,Chaos,Disorder,chaos and disorder
64079 Delusion, Matt Wade & Pez, Delusion 10, Delusion, Exclusive, Toolbox Digital Download Delusion 10 by Delusion from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
64080
64099 Craig Jones, She Mail, Tim Clewz, Hard House, Warm Up Craig Jones, She Mail, Tim Clewz, Hard House, Warm Up
64100 Craig Jones, She Mail, Hard House Craig Jones, She Mail, Hard House
64120 Matt Wade, Gaz F Matt Wade, Gaz F
64121 Rick James, Gaz F, Jump In, Solid State Digital, SSD027 Rick James & Gaz F - Jump In Released on Solid State Digital Rick James, Gaz F, Jump In, Solid State Digital, SSD027
64122 D-Fi,Chucky,Land,Of,Dreams,Nu,NRG,Dreamland,Remix,Rework,Bootleg,Neverland,Recordings We close the 2017 release schedule off with a brilliant rework of a big bosh classic. D-Fi & Chucky make their debut with this rolling monster, filled with dark stabs and an electric riff. D-Fi,Chucky,Land,Of,Dreams,Nu,NRG,Dreamland,Remix,Rework,Bootleg,Neverland,Recordings
64145 Hard house jump Trax Uplifting Banging alittlebitgay Hard house jump Trax Uplifting Banging Hard house jump Trax Uplifting Banging alittlebitgay
64208
64393 Dawn,Lee,Aria,Helix,Recordings,Offbeat,Vocal For the final release of the year we welcome Dawn Lee to the label with her debut appearance being an absolute corker. An off beat bassline with a familiar harmonic vocal. building in the breakdown to a dirty riff which kicks in twisting and squelching ro Dawn,Lee,Aria,Helix,Recordings,Offbeat,Vocal
64424 Al G, Delusion, Delusion 7, Delusion, Exclusive, Toolbox Digital Download Delusion 7 by Delusion from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
64425
64426
64427
64428
64429
64505 TMP096,Alan Sharkey,Mob Money,Tempo Trax,Hard House Hard House TMP096,Alan Sharkey,Mob Money,Tempo Trax,Hard House
64506
64507
64508
64509
64524
64525
64531 Asylum, What's Your Jam?, Drop Bear Digital , Original Mix, Exclusive, Toolbox Digital Download What's Your Jam? (Original Mix) by Drop Bear Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DB018,Drop Bear Digital ,Asylum
64535