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 (
    67662, 67159, 67063, 67062, 67639, 67207, 
    67629, 67628, 67627, 67613, 67589, 
    67514, 66982, 66835, 66813, 65968, 
    67122, 66719, 67363, 67411, 67360, 
    66786, 66785, 66691, 61783, 67303, 
    67302, 67270, 67269, 67268, 67267, 
    67266, 67265, 67264, 67263, 67262, 
    67261, 67260, 67259, 67258
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

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
61783
65968
66691 TT016b,Tuff Trax,Nippy Baines,Psydef
66719 AAA158,Ahura Mazda Recordings NITRO,Burak Harsitlioglu
66785
66786
66813 The Bounce Factory , TBF, Bounce, Donk The Bounce Factory , TBF, Bounce, Donk The Bounce Factory , TBF, Bounce, Donk
66835 TT016c,Tuff Trax,Nippy Baines,Sean Inside Out
66982
67062 FLA028,Flaunt,Shaun Williams
67063 FLA028,Flaunt,Shaun Williams
67122 HOT002,Hot Box Digital,Matt Wade,Joe Swales
67159 HOT003,Hot Box Digital,Matt Wade,Jay Goodall
67207 RE100,Relay Records,DJ Jaycee
67258
67259
67260
67261
67262
67263
67264
67265
67266
67267
67268
67269
67270
67302 Wang Stang,AL G,Disseminate Wang Stang AL G Disseminate Wang Stang, AL G, Disseminate
67303 420 Rekords, Afraid of the Dark, Riggsy, Grady G 420 Rekords, Afraid of the Dark, Riggsy, Grady G 420 Rekords, Afraid of the Dark, Riggsy, Grady G
67360 hardhouse,shenton,basglitz,premonitiondigital,nrg,filth,harddance,hard,house hardhouse,shenton,basglitz,premonitiondigital,nrg,filth,harddance,hard,house
67363 Dale,West,Ridin,High,Helix,Recordings,Vocal,Acid Debut appearance of Nokturnal promotor Dale West is this month's offering on the label. Not only is dale a great promotor but fantastic DJ and producer and this track is no exception. Big vocal gritty riff, lovely acid line and off beat bassline construct Dale,West,Ridin,High,Helix,Recordings,Vocal,Acid
67411
67514
67589 D-Fi D-Fi
67613
67627
67628
67629
67639
67662