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 (
    95318, 95317, 95316, 95315, 95314, 95313, 
    95312, 95311, 95310, 95309, 95308, 
    95307, 98602, 94670, 94299, 94252, 
    94163, 94162, 94161, 94160
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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
94160 HDP003,Traffic Records,Jigsaw
94161 HDP003,Traffic Records,Joaquin
94162 HDP003,Traffic Records,Joe E
94163 HDP003,Traffic Records,Joe Rogers
94252 FE348,Fatal Energy Records,PAJ
94299 FE349,Fatal Energy Records,Arkett Spyndl,Hagane Shizuka
94670 PTR160,Power Tracks Records,Brivi
95307 HDCHDM005,Hard Dance Coalition,Arran T
95308 HDCHDM005,Hard Dance Coalition,Robbie Teeze
95309 HDCHDM005,Hard Dance Coalition,Rich Halpin
95310 HDCHDM005,Hard Dance Coalition,Robbie Teeze
95311 Technikal, Almost There, Hard Dance Coalition, Original Mix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Almost There (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. HDCHDM005,Hard Dance Coalition,Technikal
95312 Dan Kelly, Scott Attrill, Organised Noize, Hard Dance Coalition, Scott Attrill Remix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Organised Noize (Scott Attrill Remix) by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HDCHDM005,Hard Dance Coalition,Dan Kelly,Scott Attrill
95313 HDCHDM005,Hard Dance Coalition,Scott Attrill
95314 HDCHDM005,Hard Dance Coalition,Andy McCarthy
95315 HDCHDM005,Hard Dance Coalition,Scott Attrill,Sanna Hartfield
95316 HDCHDM005,Hard Dance Coalition,Rattez,Audio Hedz
95317 HDCHDM005,Hard Dance Coalition,Energy Syndicate,Fierce DJs
95318 HDCHDM005,Hard Dance Coalition,Project Phase
98602 laura may,spring box,radiation recordings,hardtrance,hard dance,techtrance,trance,radiation,trance,hard trance,trance Laura May makes her return to Radiation Recordings with her brand new track entitled 'Spring Box'. Full of twists n turns and is hell of a funky but hard journey!! laura may,spring box,radiation recordings,hardtrance,hard dance,techtrance,trance,radiation,trance,hard trance,trance