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 (
    73214, 73213, 73212, 73211, 73210, 73209, 
    73208, 73207, 73206, 73205, 73204, 
    73203, 73202, 73201, 73200, 73199, 
    73198, 73197, 73196, 73195, 73623, 
    73622, 73621, 73620, 73619, 73618, 
    73617, 73616, 73615, 73614, 73613, 
    73612, 73509, 73285, 73241, 73408, 
    73402, 73401, 73337, 73336
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

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
73195 CheekA38,Cheeky Tracks,Miss Detonate
73196 CheekA38,Cheeky Tracks,Groove Control,Gary O'Connor
73197 CheekA38,Cheeky Tracks,Jamie Tennant
73198 CheekA38,Cheeky Tracks,Brendan Ashley,Dave Owens,Vandalize
73199 CheekA38,Cheeky Tracks,Digital Mafia,Ben Warren
73200 CheekA38,Cheeky Tracks,DJ Saber
73201 CheekA38,Cheeky Tracks,Rick James,General Bounce
73202 CheekA38,Cheeky Tracks,Elivate,Rownz
73203 CheekA38,Cheeky Tracks,Griffiths,Dodd
73204 CheekA38,Cheeky Tracks,Rick James,Cat
73205 CheekA38,Cheeky Tracks,Rob Oakley,Rob Tissera
73206 CheekA38,Cheeky Tracks,James Valentine
73207 CheekA38,Cheeky Tracks,Griffiths & Dodd,Ben Kaye
73208 CheekA38,Cheeky Tracks,Matt Wade,Joe Swales
73209 CheekA38,Cheeky Tracks,Alan Sharkey
73210 CheekA38,Cheeky Tracks,Kirk P
73211 CheekA38,Cheeky Tracks,Leighton Smith,Jenni G
73212 CheekA38,Cheeky Tracks,Dale West
73213 CheekA38,Cheeky Tracks,Filthykitten,Random But Raw
73214 CheekA38,Cheeky Tracks,Drake Liddell
73241
73285 GSR GSR
73336 premonition digital,drake liddell,kez,breathe,music,hardhouse,filth,nrg,rave,hard house,dirty,bassline premonition digital,drake liddell,kez,breathe,music,hardhouse,filth,nrg,rave,hard house,dirty,bassline
73337
73401 Mischief Duo, Karl Davies, Not Going Home, Unbounded Traxx
73402
73408 Hard Jeli, Selina, Ridgway, James, Price, D.N.A., DNA, Jeli Jams, Exclusive, Toolbox Digital Last release of the year and our 30th on Jeli Jams, the labels managers ‘Hard Jeli’ bring you ‘D.N.A.’. A heavy roller powers this meaty number, combined with the standard Jeli bits, pianos, vocals and dirty synths this monster will keep those feet moving James Price, Selina Ridgway, Hard Jeli, D.N.A., DNA, Jeli Jams, Exclusive, Toolbox Digital
73509
73612
73613
73614
73615
73616
73617
73618
73619
73620
73621
73622
73623