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 (
    37261, 37189, 37186, 37157, 58968, 40532, 
    40347, 40346, 40345, 40344, 37060, 
    40530, 40524, 40523, 40522, 40521, 
    40520, 40354, 36734, 36533
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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
36533 Dj Jose Acinas, Drop It Way, Basics Hard Music Company, Original Mix, Hard House, Toolbox Digital Download Drop It Way (Original Mix) by Basics Hard Music Company from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BS016,Basics Hard Music Company,Dj Jose Acinas
36734 Nando CP, Here We Go!, Hardnoise Records, Original Mix, Hard House, Toolbox Digital Download Here We Go! (Original Mix) by Hardnoise Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HNRS043,Hardnoise Records,Nando Cp
37060 Djay D, Wain Johnstone, Edge Of Acid, OMPTraxx, Original Mix, Bounce, Hard House, Toolbox Digital Download Edge Of Acid (Original Mix) by OMPTraxx from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. OMP012,OMPTraxx,Wain Johnstone,DJay D
37157 ACTD051,Active Sound Records,Kernnel
37186 Dj Akiles, NSA Round, DNZ Records, Original Mix, Hard House, Toolbox Digital Download NSA Round (Original Mix) by DNZ Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DNZF053,DNZ Records,Dj Akiles
37189 Danny Kobe, Stephanie Kay, Off The Floor, Dance Solution, Original Mix, Bounce, Hard House, Toolbox Digital Download Off The Floor (Original Mix) by Dance Solution from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. dan031mx,Dance Solution,Danny Kobe,Stephanie Kay
37261 Djay D, Tom Berry, Real Shit, OMPTraxx, Original Mix, Bounce, Hard House, Toolbox Digital Download Real Shit (Original Mix) by OMPTraxx from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. OMP013,OMPTraxx,DJay D,Tom Berry
40344 DR009,Demolition Records,Dean Fitz
40345 DR009,Demolition Records,Dean Fitz
40346 DR009,Demolition Records,Dean Fitz
40347 DR009,Demolition Records,Dean Fitz
40354 DR005,Demolition Records,Infusion Productionz
40520 DR006,Demolition Records,Fitzer
40521 DR006,Demolition Records,Fitzer
40522 DR006,Demolition Records,Fitzer
40523 DR006,Demolition Records,Fitzer
40524 DR007,Demolition Records,Fitzer
40530 DR008,Demolition Records,Infusion Productionz
40532 DR010,Demolition Records,Fitzer
58968 TPS045,TPS Records,Dj Manel Y Dj Vane