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 (
    125591, 122624, 125349, 113297, 122609, 
    122620, 125406, 122622, 122626, 109424
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00061

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
109424 TWA002D,Tidy,Paul Glazby
113297 Kym Ayres, Technikal, Yoshi & Razner, More & More, Tidy, Yoshi & Razner Remix, Featured Hard Trance New, Hard Trance, Toolbox Digital Download More & More (Yoshi & Razner Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. MFAHG007,Tidy,Kym Ayres,Technikal,Yoshi & Razner
122609 TIDYHHB004,Tidy,Ben Stevens
122620 TIDYHHB004,Tidy,Trauma,Dan Madams
122622 Kriess Guyte, XTC, Tidy, Extended Mix, Hard Dance, Toolbox Digital Download XTC (Extended Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYHHB004,Tidy,Kriess Guyte
122624 Ben Vennard, Cupra, Trauma, Higher, Tidy, Ben Vennard & Cupra Extended Remix, Featured Hard House, Hard House, Toolbox Digital Download Higher (Ben Vennard & Cupra Extended Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYHHB004,Tidy,Trauma,Ben Vennard,Cupra
122626 TIDYHHB004,Tidy,Tony De Vit,Paul King
125349 Renegade System, I Won't Let You Get Away, Tidy, Extended Mix, Hard Trance, Toolbox Digital Download I Won't Let You Get Away (Extended Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SYN004D,Tidy,Renegade System
125406 Carl Nicholson, James Lawson, Times Like These, Tidy, Extended Mix, Hard Trance, Toolbox Digital Download Times Like These (Extended Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SVR004,Tidy,Carl Nicholson,James Lawson
125591 Various Artists, Harder Faster, Vol 1, Tidy, Hard House, Compilations, Toolbox Digital Download Harder Faster, Vol 1 by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYHF001D,Tidy