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 (
    6243, 6290, 4074, 6274, 6222, 6219, 3254, 
    4100, 4097, 6209, 6245, 6285, 6258, 
    6329, 6270, 6269, 6268, 6267, 6266, 
    6265
  ) 
  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 20 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
3254 OD404, Bad Mother, Kaktai Records, Bounce, Hard House, Toolbox Digital Download Bad Mother by Kaktai Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. OD404Bad MotherKaktai RecordsHard HouseHard DanceNRG
4074 ac001,AC Tracks,Alex Cervera
4097 AWSMB013,AWsum,Zac H,Tom Berry
4100 AWSMB013,AWsum,SQ
6209 UDT53,Underdog Trax,Pez,Periferal
6219 UDT57,Underdog Trax,Okami,HybridZ
6222 RC020,Revolution Corps,Bastard Bounce
6243 UDT60,Underdog Trax,FOID,Mr Mister
6245 TR065,Technikal Recordings,HybridZ,Technikal
6258 BAD008,B2T Academy Digital,Ozy n' Ash P,KS2
6265 AWSMB011,AWsum,Ectic
6266 AWSMB011,AWsum,Wain Johnstone
6267 AWSMB011,AWsum,Tom Berry
6268 AWSMB011,AWsum,Tom Berry
6269 AWSMB011,AWsum,Tom Berry
6270 AWSMB011,AWsum,Energy Syndicate,Wain Johnstone
6274 BAD009,B2T Academy Digital,Ash-P,Ben-CH,KS2
6285 BAD007,B2T Academy Digital,KS2 N' Cliffy
6290 BAD011,B2T Academy Digital,Hyperstate,Lusty
6329 B2T037,B2T Recordings,Charlie Bosh