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 (
    69132, 69131, 69252, 69412, 69405, 69404, 
    68938, 68937, 68936, 68934, 68933, 
    68932, 68931, 68930, 68929, 68928, 
    68927, 68926, 68925, 68924, 68923, 
    68922, 68918, 68917, 68915, 68913, 
    68857, 68856, 68855, 68854, 68853, 
    68852, 68851, 68849, 68846, 68842, 
    68841, 68840, 68839, 69286
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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
68839 CheekA32,Cheeky Tracks,Pick & Load
68840 CheekA32,Cheeky Tracks,2 Bald Men,Pokyeo FX
68841 CheekA32,Cheeky Tracks,Starman,Italo Bounce
68842 CheekA32,Cheeky Tracks,Rick James,Poomstyles
68846 CheekA32,Cheeky Tracks,Alan Sharkey
68849 CheekA32,Cheeky Tracks,Starman,Doctor B
68851 CheekA32,Cheeky Tracks,Yummy Tunes,Adam Taylor
68852 CheekA32,Cheeky Tracks,Starman,Italo Bounce
68853 CheekA32,Cheeky Tracks,Audox,Leigh Green,Elivate,The Cheeky Boys
68854 CheekA32,Cheeky Tracks,Aron Hammond
68855 CheekA32,Cheeky Tracks,Miss Detonate
68856 CheekA32,Cheeky Tracks,DJ Saber
68857 CheekA32,Cheeky Tracks,Elivate,Rownz
68913 XTRA125,XTRAHard Records,Mhx
68915 LWHDA11,LW Recordings,Shano,Matt Clarkson,Vandalize
68917 LWHDA11,LW Recordings,DJ Lara,Danny Kobe,Joz B
68918 LWHDA11,LW Recordings,Selina Jayne,Kid Rich
68922 LWHDA11,LW Recordings,MHX
68923 LWHDA11,LW Recordings,Andy McCall
68924 LWHDA11,LW Recordings,Drake Liddell
68925 LWHDA11,LW Recordings,Matt Mara,Nikkdbubble,Filthy Kitten
68926 LWHDA11,LW Recordings,James Price,Leighton Smith
68927 LWHDA11,LW Recordings,Third Degree Gurns
68928 LWHDA11,LW Recordings,Leighton Smith
68929 LWHDA11,LW Recordings,Goldie
68930 LWHDA11,LW Recordings,Nando Cp
68931 LWHDA11,LW Recordings,Miky One,DJ Kino
68932 LWHDA11,LW Recordings,Dave Neale,Parry D
68933 LWHDA11,LW Recordings,Yoji Biomehanika
68934 LWHDA11,LW Recordings,Mikey
68936 LWHDA11,LW Recordings,Groove Control,Gary O'Connor
68937 LWHDA11,LW Recordings,Serge
68938 LWHDA11,LW Recordings,Mischief Duo,Stace
69131 CheekA36,Cheeky Tracks,Pick & Load
69132 CheekA36,Cheeky Tracks,Kye Shand,Jack Butler,Pick & Load
69252 RE115,Relay Records,Giro
69286 HDCPS004,Hard Dance Coalition,Frank Farrell
69404 lee4real, resurgence, amt remix, hard dance, hard house, ominous digital, indepedence day resurgence The UK's Lee4Real puts the biggest EP of the label on the table so far with the term "resurgence" written all over it in several aspects. This remix is a little different from the rest. It could be quickly dubbed as Hard House but its kick is way differen lee4real, resurgence, amt remix, hard dance, hard house, ominous digital, indepedence day resurgence
69405 Bowie666, Lee4Real, Resurgence, Ominous Digital Recordings, Bowie666 Remix, Featured Hard House New, Hard House, Toolbox Digital Download Resurgence (Bowie666 Remix) by Ominous Digital Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. lee4real, resurgence, bowie666 remix, hard dance, hard house, ominous digital, indepedence day resurgence
69412 DNZF404,DNZ Records,Audiorush,Carl Hill