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 (
    90895, 90615, 90614, 90624, 90536, 90162, 
    89928, 89927, 89922, 89694, 89689, 
    89688, 89687, 89686, 89680, 89590, 
    89589, 90080, 90079, 90077
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00066

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
89589 247HC203,24/7 Hardcore,Al Storm,Darren Tyler,Rob IYF
89590 247HC203,24/7 Hardcore,Al Storm,Darren Tyler,Rob IYF
89680 LTB06,Lightning Trax,Dawson,V4ugh4n
89686 Cheek488B,Cheeky Tracks,Micky Modelle Vs. Friday Night Posse,Simone Denny,Groove Control,General Bounce
89687 Cheek488B,Cheeky Tracks,Micky Modelle Vs. Friday Night Posse,Simone Denny,Vandalize
89688 Cheek488B,Cheeky Tracks,Micky Modelle Vs. Friday Night Posse,Simone Denny,Vandalize
89689 Cheek488B,Cheeky Tracks,Micky Modelle Vs. Friday Night Posse,Simone Denny,Groove Control,General Bounce
89694 PMD033,Pumped,Eggman,Joe Longbottom
89922 Jon Hemming, Gap Juice, SHED TRAX, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Gap Juice (Original Mix) by SHED TRAX from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ST018,SHED TRAX,Jon Hemming
89927 CHUBBY031,Chubby Choons,Beat Bangers
89928 CHUBBY031,Chubby Choons,Beat Bangers
90077 DNZ419,DNZ Records,DJ Oskar,Sergio Caubal,Sparkos,Silent Skies
90079 DNZ419,DNZ Records,DJ Oskar,Sergio Caubal,Ben G
90080 DNZ419,DNZ Records,DJ Oskar,Sergio Caubal,Handyman
90162 BTIDMUSIC054,BTID Music,Energy Syndicate
90536 Digital Mafia, The Cantina Band, In The Air, Cantina Records, Original Mix) (Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download In The Air (Original Mix) (Original Mix) by Cantina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR001,Cantina Records,Digital Mafia,The Cantina Band
90614 DNZF900,DNZ Records,DJ Oskar,Sergio Caubal,Bounce Enforcerz
90615 DNZF900,DNZ Records,DJ Oskar,Sergio Caubal,Clarky
90624 DNZF898,DNZ Records,Klubb Efekt
90895 Jason Nawty, Unlocked - 100% to Charity Remaster, Nawty Loopz, Featured Hard House New, Hard House, Toolbox Digital Download Unlocked - 100% to Charity Remaster by Nawty Loopz from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. nspcc,hardhouse,lockdown,covid,charity,dance,rave,love,peace,unity