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 (
    72204, 70361, 73117, 73112, 71487, 72922, 
    72854, 72853, 72851, 71741, 71202, 
    71175, 71174, 71432, 71152, 71742, 
    71123, 71178, 42032, 71586, 71585, 
    71318, 71549, 71433, 70126, 71459, 
    71014, 70360, 71345, 71344, 71285, 
    71177, 71319, 71290, 71107, 71022, 
    71284, 71277, 71228, 71227
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00056

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
42032 Grady G, mutilation, Twisted Trax, Exclusive, Toolbox Digital Download mutilation by Twisted Trax from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TOOLBOX,TWISTEDTRAXX,VICIOUS CIRCLE,FLASHPOINT
70126
70360
70361 Leeroy, Hybridized Dynamite, Toolbox Recordings, Exclusive, Toolbox Digital Download Hybridized Dynamite by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
71014 FILTH004,The Filth Foundry,D-FI
71022 FE160,Fatal Energy Records,D-Railed,STRIX
71107 DT087,Devious Trax,Dina Watson
71123 DB030,Drop Bear Digital ,Asylum
71152 UTHHT017,Ultratech,VaderMonkey
71174 FLA032,Flaunt,Shaun Williams
71175 FLA032,Flaunt,Shaun Williams
71177 Matt Wade Matt Wade
71178 Matt Wade & Joe Swales Matt Wade & Joe Swales
71202 TT019b,Tuff Trax,Nippy Baines,Mark Hard
71227 Alf Graham, Here We Go, Solid State Digital, SSD036 Alf Graham - Here We Go Released on Solid State Digital Alf Graham, Here We Go, Solid State Digital, SSD036
71228
71277 Neil Bee, Cupra, Banged Up, Slingshot Neil Bee, Cupra, Banged Up, Slingshot
71284 TMP114,Ben Stevens,&,Lee Mills,Stronger,Tempo Trax,Hard House Hard House TMP114,Ben Stevens,&,Lee Mills,Stronger,Tempo Trax,Hard House
71285 TMP115,Rat-E,Brainchild,Temp Trax,Hard House Hard House TMP115,Rat-E,Brainchild,Temp Trax,Hard House
71290 Hard House, Asylum, NRG, Orrible Noize
71318 HOT019,Hot Box Digital,Leeroy,Dan Dyson
71319
71344
71345
71432 korruption,hardhouse korruption,hardhouse
71433 premonition digital,asylum,bootie shaker,music,hardhouse,filth,nrg,rave,hardhouse,trance,hard house,hard trance premonition digital,asylum,bootie shaker,music,hardhouse,filth,nrg,rave,hardhouse,trance,hard house,hard trance
71459 Red Indian , Kid Sample Red Indian , Kid Sample Red Indian , Kid Sample
71487 UTHHD026,Ultratech,VaderMonkey
71549 Valex, Tribute, Hellstorm Trax, Exclusive, Toolbox Digital Download Tribute by Hellstorm Trax from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
71585
71586
71741 premonition digital,random but raw,fresh to the familar,rob yellowley,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,hard trance We welcome back the one and only Random But Raw to the label with his latest offering 'Fresh To The Familar' premonition digital,random but raw,fresh to the familar,rob yellowley,music,hardhouse,hard house,filth,nrg,rave,hardhouse,trance,hard house,hard trance
71742
72204 HOT020,Hot Box Digital,Kirk.P
72851
72853
72854 Dave Neale, Stalker, Jeli Jams, Exclusive, Toolbox Digital For Novembers release we welcome Dave Neale to Jeli Jams with a vocal beast. Dave has been making waves in the scene with his first 4 releases all hitting top spot on Toolbox, fingers crossed we can make it 5 out of 5 with this one. ’Stalker’ is powered b James Price, Selina Ridgway, Dave Neale, Stalker, Jeli Jams, Exclusive, Toolbox Digital
72922 TMP116,Lok-E,Strapped In,Tempo Trax,Hard House Hard House TMP116,Lok-E,Strapped In,Tempo Trax,Hard House
73112 Will Shepherd & Lee Mills, Antimatter, Solid State Digital, SSD037 Will Shepherd & Lee Mills - Antimatter Released on Solid State Digital Will Shepherd & Lee Mills, Antimatter, Solid State Digital, SSD037
73117 One Foot In The Rave One Foot In The Rave