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 (
    95818, 95817, 95816, 95815, 95814, 95813, 
    95812, 95811, 95810, 95809, 95808, 
    95807, 95806, 95805, 95804, 95803, 
    95874, 95867, 95638, 95637
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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
95637 PTR163,Power Tracks Records,DJ Ivan Diaz,Sue
95638 PTR163,Power Tracks Records,DJ Ivan Diaz,Sue
95803 HDCSHD001,Hard Dance Coalition,Robbie Teeze
95804 HDCSHD001,Hard Dance Coalition,Mark HybridZ
95805 HDCSHD001,Hard Dance Coalition,Fluu x Fluu
95806 HDCSHD001,Hard Dance Coalition,Arran T
95807 Scott Attrill, In Your Eyes, Hard Dance Coalition, Original Mix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download In Your Eyes (Original Mix) by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HDCSHD001,Hard Dance Coalition,Scott Attrill
95808 Audox, Max Mozart, Full Control, Hard Dance Coalition, Original Mix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Full Control (Original Mix) by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HDCSHD001,Hard Dance Coalition,Audox,Max Mozart
95809 HDCSHD001,Hard Dance Coalition,Cut-Up
95810 HDCSHD001,Hard Dance Coalition,Andy Whitby,Karlston Khaos
95811 HDCSHD001,Hard Dance Coalition,Andy Whitby,Karlston Khaos
95812 HDCSHD001,Hard Dance Coalition,Scott Attrill
95813 HDCSHD001,Hard Dance Coalition,Audox
95814 HDCSHD001,Hard Dance Coalition,Andy Whitby,Klubfiller,Cally Gage,Kyla,Breeze,Modulate
95815 HDCSHD001,Hard Dance Coalition,12 Inch Thumpers,Mobi D
95816 HDCSHD001,Hard Dance Coalition,Andy Whitby,MDA,Spherical
95817 HDCSHD001,Hard Dance Coalition,Jonzzo
95818 HDCSHD001,Hard Dance Coalition,12 Inch Thumpers
95867 PTR166,Power Tracks Records,Jaime Guerrero
95874 DNZF1002,DNZ Records,Garbie Project