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 (
    88095, 88094, 88093, 88092, 88091, 88090, 
    88089, 88088, 88087, 88086, 88082, 
    88081, 87851, 87731, 87730, 87729, 
    87728, 88625, 88624, 88623, 88039, 
    88532, 88531, 88530, 88406, 88405, 
    88404, 88403, 88402, 88401, 87762, 
    87678, 88629, 88628, 88627, 88626, 
    88575, 88574, 88573, 88149
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00089

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 40 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
87678 Solo, Never Agent, Stomp-Inc UK, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Never Agent (Original Mix) by Stomp-Inc UK from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STI0156,Stomp-Inc UK,Solo
87728 MOK218,Mokum Records,Nordcore GMBH
87729 MOK218,Mokum Records,Nordcore GMBH
87730 MOK218,Mokum Records,Nordcore GMBH
87731 MOK218,Mokum Records,Nordcore GMBH,909 Junkies
87762 STI0157,Stomp-Inc UK,Solo
87851 STI0158,Stomp-Inc UK,Mark Ridjel
88039 IT044,Infused Traxx,DJ Darroo
88081 Two Minds Project, Scared, OneSeventy, Extended Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Scared (Extended Mix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY73,OneSeventy,Two Minds Project
88082 ONESEVENTY73,OneSeventy,Two Minds Project
88086 CRR034,Core Rebelz Records,Angstfrai
88087 CRR034,Core Rebelz Records,C-Devastator
88088 CRR034,Core Rebelz Records,Droonix
88089 CRR034,Core Rebelz Records,Fifthy
88090 CRR034,Core Rebelz Records,Fucking Paranoid
88091 CRR034,Core Rebelz Records,Gabbanatic
88092 CRR034,Core Rebelz Records,mRNA
88093 CRR034,Core Rebelz Records,Sneith & Bloodle$$
88094 CRR034,Core Rebelz Records,Those Early Gabber Guys
88095 CRR034,Core Rebelz Records,Preacker
88149 RRS001,Recharged,Surgery
88401 EX005,Exode Records,Imperium Bass,D-ohmicyd
88402 EX005,Exode Records,Imperium Bass,S'aphira
88403 EX004,Exode Records,D-ohmicyd,Wars Industry
88404 EX004,Exode Records,D-ohmicyd,Wars Industry
88405 EX004,Exode Records,D-ohmicyd,Wars Industry
88406 EX004,Exode Records,D-ohmicyd,Wars Industry,The Loading Project
88530 BAB003,Bombs & Bullets Records,The Sequel
88531 BAB003,Bombs & Bullets Records,The Sequel,Hyrule War
88532 BAB003,Bombs & Bullets Records,The Sequel,Sinister Seven
88573 BBR036,Bounce Back records,M1dlet
88574 BBR036,Bounce Back records,M1dlet
88575 BBR036,Bounce Back records,M1dlet
88623 SD183,Scarred Digital,Mansy,Lara B
88624 SD183,Scarred Digital,Mansy,Lara B,X-Cyte
88625 Lara B, Mansy, Old Skool Junkies, Summer Time, Scarred Digital, Old Skool Junkies Breakbeat Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Summer Time (Old Skool Junkies Breakbeat Remix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD183,Scarred Digital,Mansy,Lara B,Old Skool Junkies
88626 RAVEMUZIK037,Rave Muzik,DJ Thera,Stormtrooper
88627 DJ Thera, Stormtrooper, All Over Again, Rave Muzik, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download All Over Again (Original Mix) by Rave Muzik from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. RAVEMUZIK037,Rave Muzik,Stormtrooper,DJ Thera
88628 RAVEMUZIK037,Rave Muzik,DJ Thera,Stormtrooper
88629 RAVEMUZIK037,Rave Muzik,Stormtrooper,DJ Thera