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 (
    66793, 66792, 66791, 66790, 66789, 67007, 
    66714, 66711, 66706, 66704, 66697, 
    66696, 66692, 66725, 66721, 66312, 
    66282, 66281, 66662, 66619, 66618, 
    66617, 66616, 66615, 66614, 66613, 
    66612, 66611, 66610, 66609, 66608, 
    66526, 66206, 66205, 66204, 66203, 
    66202, 66201, 66200, 66199
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00071

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
66199 LWEGHH15,LW Recordings,LeeRoy
66200 LWEGHH15,LW Recordings,Alf Graham
66201 LWEGHH15,LW Recordings,Deadly Nightshade
66202 LWEGHH15,LW Recordings,Jay Pepper
66203 LWEGHH15,LW Recordings,Rich Resonate
66204 LWEGHH15,LW Recordings,Tim Clewz,Jamie Haig
66205 LWEGHH15,LW Recordings,Baseglitz
66206 LWEGHH15,LW Recordings,Fabio Seramota
66281 dan103mx,Dance Solution,Sergio M
66282 dan103mx,Dance Solution,Sergio M,DJ Lara
66312 MHX, Bring The Platform, XTRAHard Records, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Bring The Platform (Original Mix) by XTRAHard Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. XTRA118,XTRAHard Records,Mhx
66526 DNZ300,DNZ Records,Jordi Bump
66608 DNZHH02,DNZ Records,Raul Arribas
66609 DNZHH02,DNZ Records,Gemeliyo,Borja
66610 DNZHH02,DNZ Records,Bounce Enforcerz,DJ Oskar,Handyman
66611 DNZHH02,DNZ Records,DJ Nillos
66612 DNZHH02,DNZ Records,Jumpin Jack
66613 DNZHH02,DNZ Records,Dj Navas,Isaac Sanchez
66614 DNZHH02,DNZ Records,DJ Oskar
66615 DNZHH02,DNZ Records,Yannick Esquefa,Raul Arribas
66616 DNZHH02,DNZ Records,Pokytwins,DJ Bass
66617 DNZHH02,DNZ Records,D3lta
66618 DNZHH02,DNZ Records,Irra Dj
66619 DNZHH02,DNZ Records,Dj Shetanckovik,Dj Akiles
66662 PTR044,Power Tracks Records,Isaac Sanchez,Jaime Guerrero,Sergio Caubal
66692 LWHDA09,LW Recordings,Brian Theodore
66696 LWHDA09,LW Recordings,Starman,DJ Saber,Nikki,Joe Longbottom,Leigh D
66697 LWHDA09,LW Recordings,Tom Parr,Baz
66704 LWHDA09,LW Recordings,VaderMonkey
66706 LWHDA09,LW Recordings,Sean Inside Out,Dale West
66711 LWHDA09,LW Recordings,Bowie666
66714 LWHDA09,LW Recordings,Shaun Williams
66721 DNZF371,DNZ Records,Drake Liddell
66725 DNZF372,DNZ Records,The Lost Planets
66789 CheekA30,Cheeky Tracks,Duck & Cover
66790 CheekA30,Cheeky Tracks,Pick & Load
66791 CheekA30,Cheeky Tracks,Duck & Cover
66792 CheekA30,Cheeky Tracks,Venkman
66793 CheekA30,Cheeky Tracks,Mikey
67007 DNZF375,DNZ Records,DJ Nesket,DJ Pascu