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 (
    68974, 68973, 68972, 68971, 68970, 68969, 
    68968, 68967, 68966, 68965, 68964, 
    68963, 68962, 68961, 68960, 68959, 
    68958, 68957, 68956, 68955, 68954, 
    68953, 68952, 68951, 68950, 68949, 
    68948, 68947, 68946, 68945, 68321, 
    68290, 68289, 68288, 68286, 68285, 
    68284, 68283, 68282, 68281
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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
68281 CheekA35,Cheeky Tracks,Audox,Gilly,Paul Maddox
68282 CheekA35,Cheeky Tracks,Kye Shand,Jack Butler
68283 CheekA35,Cheeky Tracks,Ross Homson
68284 CheekA35,Cheeky Tracks,Kye Shand,Jack Butler,Pick & Load
68285 CheekA35,Cheeky Tracks,Starman,General Bounce,Left Eye
68286 CheekA35,Cheeky Tracks,Ross Homson
68288 CheekA35,Cheeky Tracks,Starman,DJ Saber,Nikki,Alf Graham
68289 CheekA35,Cheeky Tracks,Ben Stevens,Paul Stacey
68290 CheekA35,Cheeky Tracks,Elivate,General Bounce
68321 ENE018,Energy Hard Espana,Fran Dj
68945 HDCSTP004,Hard Dance Coalition,Steve Maynard
68946 HDCSTP004,Hard Dance Coalition,Maddox & Townend
68947 HDCSTP004,Hard Dance Coalition,Amp Attack
68948 HDCSTP004,Hard Dance Coalition,Swack,Hotwire
68949 HDCSTP004,Hard Dance Coalition,Ben Stevens
68950 HDCSTP004,Hard Dance Coalition,Agent Jack
68951 HDCSTP004,Hard Dance Coalition,Foreign Body
68952 HDCSTP004,Hard Dance Coalition,RJ,Ruskul
68953 HDCSTP004,Hard Dance Coalition,Beat Jammers
68954 HDCSTP004,Hard Dance Coalition,Ben Stevens,Tenchy
68955 HDCSTP004,Hard Dance Coalition,Andy Farley,Ben Stevens,Lox,Leigh Green
68956 HDCSTP004,Hard Dance Coalition,Aftermath
68957 HDCSTP004,Hard Dance Coalition,Groove Complex
68958 HDCSTP004,Hard Dance Coalition,All Boxed In,Maddox & Townend
68959 HDCSTP004,Hard Dance Coalition,Ingo,Masmada
68960 HDCSTP004,Hard Dance Coalition,Armitage Shanks
68961 HDCSTP004,Hard Dance Coalition,Beat Jammers
68962 HDCSTP004,Hard Dance Coalition,Digital Mafia
68963 HDCSTP004,Hard Dance Coalition,Ben Stevens,Tenchy
68964 HDCSTP004,Hard Dance Coalition,James Devlin
68965 HDCSTP004,Hard Dance Coalition,Olive Grooves
68966 HDCSTP004,Hard Dance Coalition,Beat Jammers
68967 HDCSTP004,Hard Dance Coalition,Kev Dunkling
68968 HDCSTP004,Hard Dance Coalition,Groove Complex
68969 HDCSTP004,Hard Dance Coalition,JP,Jukesy,Amp Attack
68970 HDCSTP004,Hard Dance Coalition,Beat Jammers
68971 HDCSTP004,Hard Dance Coalition,Paul Maddox,Ben Stevens,Olive Grooves
68972 HDCSTP004,Hard Dance Coalition,Groove Complex
68973 HDCSTP004,Hard Dance Coalition,Maddox & Townend
68974 HDCSTP004,Hard Dance Coalition,Digital Mafia