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 (
    67257, 67256, 66534, 67158, 67208, 67196, 
    67195, 66979, 66878, 66812, 66787, 
    66527, 65967, 66881, 67016, 67014, 
    66981, 66980, 66784, 66622, 66621, 
    66393, 61786, 66986, 66985, 66978, 
    66846, 66843, 66842, 66783, 66780, 
    66286, 66283, 66214, 66779, 65966, 
    66533, 66729, 66594, 66287
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

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
61786
65966
65967
66214 hardhouse,craiglee,daveneale,premonitiondigital,reachmyelement,hard,house,harddance hardhouse,craiglee,daveneale,premonitiondigital,reachmyelement,hard,house,harddance
66283 UTHHD022,Ultratech,VaderMonkey
66286 TT006b,Tuff Trax,Sean Inside Out,Damaged Gudz
66287 AAA157,Ahura Mazda Recordings NITRO,Burak Harsitlioglu
66393 TT015a,Tuff Trax,Matt Wade,Pez & Miric
66527 TT016a,Tuff Trax,Nippy Baines
66533 Anytime House, Agent Jack, The Sneaky Ninja, Slingshot, Jeff Payne Anytime House, Agent Jack, The Sneaky Ninja, Slingshot, Jeff Payne
66534 Cupra, The Nightfall, Slingshot Cupra, The Nightfall, Slingshot
66594
66621 Cheek364,Cheeky Tracks,DJ Saber
66622 Cheek364,Cheeky Tracks,DJ Saber
66729
66779 Kumite, Monster Munch, Hellstorm Trax, Exclusive, Toolbox Digital Download Monster Munch by Hellstorm Trax from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
66780
66783
66784
66787
66812 The Bounce Factory , TBF, Bounce, Donk, Dave Owens, Groove Control, Justin Daniels & Jamie R The Bounce Factory , TBF, Bounce, Donk, Dave Owens, Groove Control, Justin Daniels & Jamie R The Bounce Factory , TBF, Bounce, Donk, Dave Owens, Groove Control, Justin Daniels & Jamie R
66842 Sean Inside Out Sean Inside Out
66843 Marc Lewis Marc Lewis
66846
66878 BMR057,Beast Mode Recordings,Teck071
66881 HOT001,Hot Box Digital,Matt Wade,Kenny Seear
66978 TMP101,Robski & Matt Clarkson,Pressure Switch,Tempo Trax,Hard House Hard House TMP101,Robski & Matt Clarkson,Pressure Switch,Tempo Trax,Hard House
66979 TMP102,Aynsley & Jay Vs Matt Clarkson,Out Of Order,Tempo Trax,Hard House Hard House TMP102,Aynsley & Jay Vs Matt Clarkson,Out Of Order,Tempo Trax,Hard House
66980
66981
66985 Kid Sample, Lost in Life Kid Sample Lost in Life Kid Sample Lost in Life
66986 Karim, Riggsy, Atomic Kick Karim, Riggsy, Atomic Kick Karim, Riggsy, Atomic Kick
67014 Tom Basquil, Ladies Night, Jeli Jams, Exclusive, Toolbox Digital Next up we have Tom Basquil making his debut appearance on Jeli Jams, we present to you ‘Ladies Night’. Rolling bass, big uplifting riffs and haunting vocal drive this track. Tom Basquil, Ladies Night, Jeli Jams, Exclusive, Toolbox Digital, James Price, Selina Ridgway
67016
67158 DT0086,Devious Trax,Marc Lewis
67195 Miric Miric
67196 G.S.R, Matt Clarkson, Get Em Higher, Solid State Digital, Exclusive, Toolbox Digital Download Get Em Higher by Solid State Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. G.S.R & Matt Clarkson, Get Em Higher, Solid State Digital, SSD030
67208
67256
67257