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 (
    77318, 77094, 76484, 77518, 77246, 77080, 
    77507, 76443, 77045, 76891, 76890, 
    76264, 76889, 76152, 76151, 76150, 
    76149, 76148, 76147, 76146
  ) 
  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
76146 247HCLP006DL,24/7 Hardcore,Scott Brown,Al Storm
76147 247HCLP006DL,24/7 Hardcore,Finnbarr
76148 247HCLP006DL,24/7 Hardcore,DJ Shimamura,Al Storm,Olly P
76149 247HCLP006DL,24/7 Hardcore,Damian LH,Del Toro
76150 247HCLP006DL,24/7 Hardcore,Al Storm x dot.MAX
76151 247HCLP006DL,24/7 Hardcore,Del Toro
76152 247HCLP006DL,24/7 Hardcore,Various Artists
76264 FE213,Fatal Energy Records,Ludo
76443 Ganar, Let It Go, We Are One Digital, Extended Mix, Featured Hardcore New, Hard Dance, Toolbox Digital Download Let It Go (Extended Mix) by We Are One Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. WAOD037,We Are One Digital,Ganar
76484 HGX005,HOURGLAXX records,SEFO
76889 DNZF531,DNZ Records,Garbie Project
76890 DNZF533,DNZ Records,Call Of Duty
76891 DNZF533,DNZ Records,Call Of Duty
77045 DNZF534,DNZ Records,Garbie Project
77080 DNZF537,DNZ Records,Garbie Project,Jamie B
77094 PTR098,Power Tracks Records,J. JBlack,Jaime Guerrero,Isaac Sanchez
77246 DNZF536,DNZ Records,Que & Rkay,Kate
77318 DNZF539,DNZ Records,Jamie B
77507 D03,Dance,music No Fear is the debut single for D03 and Undiscovered Digital. The Clubland feel to this track will get you moving and the catchy vocals sung by Grace will definitely be a dance floor filler. club,dance,music,edm
77518 Tamerax,Undiscovered,Digital,Dance,Music,Hardance,hard New to Undiscovered Digital Tamerax brings you his first track with us. This Hard dance Banger has an interesting take on vocal hard dance. With lyrics and a rhythm that will get stuck in your head.Also brilliant for the dance floors with its pumping kick Tamerax,Undiscovered,Digital,Dance,Music,Hardance,hard