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 (
    69618, 69616, 69615, 69459, 69449, 69401, 
    69350, 69507, 69506, 69505, 69503, 
    69447, 69410, 68998, 68698, 67810, 
    67809, 67808, 67807, 67806, 67805, 
    67804, 67803, 67802, 67801, 67800, 
    67799, 67798, 67797, 67796, 67795, 
    67794, 67793, 67792, 67791, 69107, 
    69432, 69348, 69005, 68836
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00062

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
67791
67792
67793
67794
67795
67796
67797
67798
67799
67800
67801
67802
67803
67804
67805
67806
67807
67808
67809
67810
68698
68836 Cheek380,Cheeky Tracks,Matt Wade,Joe Swales
68998
69005 AAA165,Ahura Mazda Recordings NITRO,Burak Harsitlioglu
69107 HOT011,Hot Box Digital,Damaged Gudz
69348 Matt Wade Matt Wade
69350 YEAH088,Yeah Boi Recordings,Lee4Real
69401 TMP109,Joe Swales,A Different Alternative,Tempo Trax,Hard House Hard House TMP109,Joe Swales,A Different Alternative,Tempo Trax,Hard House
69410 premonition digital,Fabio Seramota,Mel,Found You,music,hardhouse,filth,nrg,rave,tidy trax,tidy premonition digital,Fabio Seramota,Mel,Found You,music,hardhouse,filth,nrg,rave,tidy trax,tidy
69432 Tom Basquil, Betelgeuse, Hellstorm Trax, Exclusive, Toolbox Digital Download Betelgeuse by Hellstorm Trax from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
69447 MIRIC MIRIC
69449 IMNO023,Immortal Noise Recordings,Dark by Design,Arkett Spyndl
69459 MIRIC MIRIC
69503
69505 James Price, Selina Ridgway, Hard Jeli, Dave Owens, La Chops, Jeli Jams, Exclusive, Toolbox Digital For our 25th release label managers ‘Hard Jeli’ team up with the mighty Dave Owens. Dave has helped us to shape ‘our’ sound over the last 4 years and it only feels right to have this milestone as a collaboration with him. We are proud to present to you ‘L James Price, Selina Ridgway, Hard Jeli, Dave Owens, La Chops, Jeli Jams, Exclusive, Toolbox Digital
69506
69507
69615 Dan Dyson, April Foolz, Hooverweight Records, Exclusive, Toolbox Digital Download April Foolz by Hooverweight Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Dan Dyson Hooverweight April Foolz
69616 Dan Dyson On Da Rox Hooverweight Dan Dyson On Da Rox Hooverweight
69618 Team Sly vs Alf Graham, Broken Bones, Solid State Digital, SSD034 Team Sly vs Alf Graham - Broken Bones Released on Solid State Digital Team Sly vs Alf Graham, Broken Bones, Solid State Digital, SSD034