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 (
    74996, 75157, 74620, 74619, 74618, 74617, 
    74616, 74615, 74614, 74613, 74612, 
    74611, 74870, 74993, 74918, 74515, 
    74513, 74512, 74898, 74465
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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
74465 Inner Sinner, Your Life, Cheeky Tracks, Original Mix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Your Life (Original Mix) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Cheek411,Cheeky Tracks,Inner Sinner
74512 FE185,Fatal Energy Records,Attat,LEZAMAboy
74513 TiOS034,TIOS Digital,M3-O
74515 Scott Attrill, The Sequence, Traffic Records, 10 Seconds) (Original Mix, Tech Dance, Featured Hard Dance New, Hard Dance, Toolbox Digital Download The Sequence (10 Seconds) (Original Mix) by Traffic Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TR1780,Traffic Records,Scott Attrill
74611 TFCD013D,TERRAFORM MUSIC,Scott Brown,M-Project
74612 TFCD013D,TERRAFORM MUSIC,MUZIK SERVANT,M-Project
74613 TFCD013D,TERRAFORM MUSIC,Mitomoro,M-Project
74614 TFCD013D,TERRAFORM MUSIC,Relect,M-Project
74615 TFCD013D,TERRAFORM MUSIC,S3RL Vs. M-Project,Krystal,Eufeion
74616 TFCD013D,TERRAFORM MUSIC,S-WORX,M-Project
74617 TFCD013D,TERRAFORM MUSIC,SynthWulf,M-Project
74618 TFCD013D,TERRAFORM MUSIC,M-Project
74619 TFCD013D,TERRAFORM MUSIC,T4TSUYA,M-Project
74620 TFCD013D,TERRAFORM MUSIC,Scott Brown,M-Project,Krystal
74870 PTR090,Power Tracks Records,NYS
74898 DNZF468,DNZ Records,Paul Norval,Sparkos
74918 DNZF470,DNZ Records,T-Jay
74993 DNZF472,DNZ Records,Que & Rkay
74996 PTR091,Power Tracks Records,Dance Energy Vol.1
75157 DNZF474,DNZ Records,Que & Rkay