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 (
    93498, 93497, 93496, 93495, 93494, 93493, 
    93492, 93491, 93490, 93489, 93488, 
    93487, 93486, 93485, 93484, 93483, 
    93482, 93481, 93480, 93479, 93478, 
    93477, 93476, 93475, 93474, 93473, 
    93466, 94268, 94267, 94266, 93443, 
    93440, 93432, 93430, 93429, 93428, 
    93427, 93426, 93425, 93424
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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
93424 2021D,Hard B!tch Records,Adam Clap
93425 2021D,Hard B!tch Records,Adam Clap
93426 2021D,Hard B!tch Records,Adam Clap
93427 2021D,Hard B!tch Records,Adam Clap
93428 2021D,Hard B!tch Records,Adam Clap
93429 2021D,Hard B!tch Records,Adam Clap
93430 2021D,Hard B!tch Records,Adam Clap
93432 SethroW, In For Your Love, Stomp-Inc UK, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download In For Your Love (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. STI0197,Stomp-Inc UK,SethroW
93440 FE341,Fatal Energy Records,B.R.K.
93443 CRR059,Core Rebelz Records,Fatal Footwork Freaks
93466 Sti0198,Stomp-Inc UK,SethroW
93473 MOUTHLP001,Motormouth Recordz,Motormouth
93474 MOUTHLP001,Motormouth Recordz,Embrionyc
93475 MOUTHLP001,Motormouth Recordz,Stan Grewzell
93476 MOUTHLP001,Motormouth Recordz,Cubic Nomad,Xtematic
93477 MOUTHLP001,Motormouth Recordz,Al Twisted
93478 MOUTHLP001,Motormouth Recordz,Godbuzda
93479 MOUTHLP001,Motormouth Recordz,Encrypter
93480 MOUTHLP001,Motormouth Recordz,NRK
93481 MOUTHLP001,Motormouth Recordz,The Relic
93482 MOUTHLP001,Motormouth Recordz,Matt Green
93483 MOUTHLP001,Motormouth Recordz,[KRTM]
93484 MOUTHLP001,Motormouth Recordz,DJ DBN
93485 MOUTHLP001,Motormouth Recordz,The 7th Genocide
93486 MOUTHLP001,Motormouth Recordz,Absence of Mind,Elektrotype
93487 MOUTHLP001,Motormouth Recordz,The 7th Genocide
93488 MOUTHLP001,Motormouth Recordz,Tripped
93489 MOUTHLP001,Motormouth Recordz,[KRTM]
93490 MOUTHLP001,Motormouth Recordz,JFX
93491 MOUTHLP001,Motormouth Recordz,DJ UEP
93492 MOUTHLP001,Motormouth Recordz,Matt Green
93493 MOUTHLP001,Motormouth Recordz,DJ UEP
93494 MOUTHLP001,Motormouth Recordz,Calum Moore,Gnasher
93495 MOUTHLP001,Motormouth Recordz,Sarin Assault
93496 MOUTHLP001,Motormouth Recordz,Lost Origin,NRK
93497 MOUTHLP001,Motormouth Recordz,DJ Freak
93498 MOUTHLP001,Motormouth Recordz,Sadistic
94266 UIR014,Underground Industry Records,Hannibal Noizer
94267 UIR014,Underground Industry Records,Hannibal Noizer
94268 UIR014,Underground Industry Records,Badkick,Hannibal Noizer