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 (
    106778, 106777, 106776, 106775, 106774, 
    106313, 106760, 106759, 106369, 106368, 
    106273, 106271, 106270, 106269, 106260, 
    106243, 106242, 106241, 106240, 106239
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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
106239 BRR194,Black Reverb,Diabolic Shop
106240 BRR194,Black Reverb,Cirqit,Black Ahead
106241 BRR194,Black Reverb,Cirqit
106242 BRR194,Black Reverb,Black Ahead
106243 BRR194,Black Reverb,Assuc,X6Cta
106260 Elevate, Virtual Dreams, The World Of Obsession Recordings, Extended Mix, Hardcore, Toolbox Digital Download Virtual Dreams (Extended Mix) by The World Of Obsession Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TWORC002,The World Of Obsession Recordings,Elevate
106269 Arnie, Jay G, Here Forever, Digital Dragon, Original Mix, Hardcore, Toolbox Digital Download Here Forever (Original Mix) by Digital Dragon from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DD004,Digital Dragon,Jay G,Arnie
106270 Audio Nitrate, Love Of Yesterday, OneSeventy, Extended Mix, Hardcore, Toolbox Digital Download Love Of Yesterday (Extended Mix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY129,OneSeventy,Audio Nitrate
106271 ONESEVENTY129,OneSeventy,Audio Nitrate
106273 VDH052,Various Digital Hardcore,Infinite,Rikston
106313 STI296,Stomp-Inc UK,SethroW
106368 Alaguan, Back With A Bang!, 24/7 Hardcore, Extended Mix, Hardcore, Toolbox Digital Download Back With A Bang! (Extended Mix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC270,24/7 Hardcore,Alaguan
106369 247HC270,24/7 Hardcore,Alaguan
106759 XTR046,X-tinction Recordz,Desotica,l Pa$o
106760 XTR046,X-tinction Recordz,Desotica
106774 LWHTS01,LW Recordings,HRDDMAT
106775 LWHTS01,LW Recordings,Don Weber,Atonal Structures
106776 LWHTS01,LW Recordings,Destroyer,Kuros Chimenes
106777 LWHTS01,LW Recordings,KRISMIX
106778 LWHTS01,LW Recordings,Talantoesis