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, 125349, 113297, 122609, 122624, 
    125406, 109424, 109869, 119155, 119391
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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
109869 Guyver, Rob Tissera, Burning, Tidy, Guyver Remix, Featured Hard Trance New, Hard Trance, Toolbox Digital Download Burning (Guyver Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HDA001DD,Tidy,Rob Tissera,Guyver
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
119155 HHPC016D,Tidy,Rachel Auburn
119391 Mark Sherry, Tony De Vit, The Dawn, Tidy, Mark Sherry Extended Remix, Hard Trance, Featured Hard Trance New, Toolbox Digital Download The Dawn (Mark Sherry Extended Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TDV25TD,Tidy,Tony De Vit,Mark Sherry
122609 TIDYHHB004,Tidy,Ben Stevens
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
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