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 (
    92969, 92968, 92967, 92966, 92964, 92963, 
    92962, 92961, 92960, 92959, 92826, 
    92822, 92812, 92811, 92810, 92809, 
    1644, 92657, 92654, 93172
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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
1644 RikromFilthboxTwisted TraxHard HouseHard DanceNRG RikromFilthboxTwisted TraxHard HouseHard DanceNRG RikromFilthboxTwisted TraxHard HouseHard DanceNRG
92654 CLK, Bad Cookies, SHED TRAX, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Bad Cookies (Original Mix) by SHED TRAX from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ST024,SHED TRAX,CLK
92657 Charlie Bosh, Matt Wigman, Head Poppa, BTID Music, Original Mix, Bounce, Featured Hard House New, Hard House, Toolbox Digital Download Head Poppa (Original Mix) by BTID Music from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BTIDMUSIC085,BTID Music,Matt Wigman,Charlie Bosh
92809 Unit DVSN, Break Free, SHED TRAX, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Break Free (Original Mix) by SHED TRAX from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ST025,SHED TRAX,UNIT DVSN
92810 Starquake, Hold Me Hostage, Tidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Hold Me Hostage (Original Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYBAEP02,Tidy,Starquake
92811 TIDYBAEP02,Tidy,Tidy DJ's,Jon BW
92812 TIDYBAEP02,Tidy,Max Mozart,Lia B
92822 Charlie Bosh, Nothing To Hide, BTID Music, Original Mix, Bounce, Featured Hard House New, Hard House, Toolbox Digital Download Nothing To Hide (Original Mix) by BTID Music from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BTIDMUSIC051,BTID Music,Charlie Bosh
92826 Ains, Audio Chavs, Bass Dominators, DJ One Eye, Someday, Cantina Records, Ains & Audio Chavs Remix, Featured Hard House New, Hard House, Toolbox Digital Download Someday (Ains & Audio Chavs Remix) by Cantina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR008,Cantina Records,Bass Dominators,DJ One Eye,Ains,Audio Chavs
92959 BORHH1,Alien Technology,Rebel Frequency
92960 BORHH1,Alien Technology,Rebel Frequency
92961 BORHH1,Alien Technology,Distorted Robocops
92962 BORHH1,Alien Technology,Tom Whyld
92963 BORHH1,Alien Technology,Distorted Robocops
92964 BORHH1,Alien Technology,Rebel Frequency
92966 BORHH1,Alien Technology,Rebel Frequency
92967 BORHH1,Alien Technology,Distorted Robocops
92968 BORHH1,Alien Technology,Rebel Frequency
92969 BORHH1,Alien Technology,Type Zero
93172 DNZF950,DNZ Records,Jamie B