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 (
    13056, 13689, 13687, 13686, 13377, 12913, 
    12912, 13036, 12676, 12617, 12406, 
    12302, 12350, 12339, 12349, 12344, 
    12298, 18728, 18727, 12125
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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 20 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
12125 DNZF006,DNZ Records,PokyTwins
12298 FLMBD025,Flammable Hard Dance,DJ Ransome
12302 12 inch thumpers, 12 inch thumper, digital thumpers, 50,000 watts 12 INCH THUMPERS was officially launched in 1999. Its first release, "Don't Cross The Line", was a track that paved way for the new sound of Hard House to emerge. Now over 10 years later, 12 Inch Thumpers is releasing brand new material on its new label hard house, 12 inch thumpers
12339 Cheek103,Cheeky Tracks,Matt Alliss
12344 DNZF007,DNZ Records,PokyTwins
12349 HNRS005,Hardnoise Records,Nando CP
12350 DNZF008,DNZ Records,PokyTwins
12406 FLMBD027,Flammable Hard Dance,Allan E,Mr Mister
12617 ACT005,Active Sound Records,Kernnel
12676 ACT004,Active Sound Records,Kernnel
12912 12 inch thumpers, 12 inch thumper, thumpers, digital thumpers, hard house 12 INCH THUMPERS was officially launched in 1999. Its first release, "Don't Cross The Line", was a track that paved way for the new sound of Hard House to emerge. Now over 10 years later, 12 Inch Thumpers is releasing brand new material on its new label 12 inch thumpers, hard house, thumpers, digital
12913 12 inch thumpers, 12 inch thumper, thumpers, digital thumpers, hard house 12 INCH THUMPERS was officially launched in 1999. Its first release, "Don't Cross The Line", was a track that paved way for the new sound of Hard House to emerge. Now over 10 years later, 12 Inch Thumpers is releasing brand new material on its new label 12 inch thumpers, hard house, thumpers, digital
13036 Cheek104,Cheeky Tracks,Harry Hard,Big D
13056 DNZF009,DNZ Records,PokyTwins
13377 HNRS007,Hardnoise Records,Nando CP
13686 12 inch thumpers, 12 inch thumper, thumpers, digital thumpers, hard house 12 INCH THUMPERS was officially launched in 1999. Its first release, "Don't Cross The Line", was a track that paved way for the new sound of Hard House to emerge. Now over 10 years later, 12 Inch Thumpers is releasing brand new material on its new label 12 inch thumpers, hard house, thumpers, digital
13687 12 inch thumpers, 12 inch thumper, thumpers, digital thumpers, hard house 12 INCH THUMPERS was officially launched in 1999. Its first release, "Don't Cross The Line", was a track that paved way for the new sound of Hard House to emerge. Now over 10 years later, 12 Inch Thumpers is releasing brand new material on its new label 12 inch thumpers, hard house, thumpers, digital,
13689 12 inch thumpers, 12 inch thumper, thumpers, digital thumpers, hard house 12 INCH THUMPERS was officially launched in 1999. Its first release, "Don't Cross The Line", was a track that paved way for the new sound of Hard House to emerge. Now over 10 years later, 12 Inch Thumpers is releasing brand new material on its new label 12 inch thumpers, hard house, thumpers, digital
18727 TPS003,TPS Records,Dj Crazybass
18728 TPS003,TPS Records,Dj Crazybass