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 (
    92499, 92498, 92486, 91950, 91930, 91909, 
    1417, 92477, 91779, 91778, 91777, 91776, 
    91775, 91774, 91773, 91772, 91771, 
    91770, 91769, 91768
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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
1417 KorrosiveBrain SurgeryTwisted TraxHard HouseHard DanceNRG KorrosiveBrain SurgeryTwisted TraxHard HouseHard DanceNRG KorrosiveBrain SurgeryTwisted TraxHard HouseHard DanceNRG
91768 UNTIDYFRAC01D,Untidy,Sam Townend
91769 Sam Townend, Double Pinger, Untidy, Take Me Higher) (Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Double Pinger (Take Me Higher) (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYFRAC01D,Untidy,Sam Townend
91770 UNTIDYFRAC01D,Untidy,Sam Townend
91771 Sam Townend, Disco Whistle, Untidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Disco Whistle (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYFRAC01D,Untidy,Sam Townend
91772 UNTIDYFRAC01D,Untidy,Sam Townend
91773 UNTIDYFRAC01D,Untidy,Sam Townend
91774 UNTIDYFRAC01D,Untidy,Sam Townend
91775 Sam Townend, Make It Bang, Untidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Make It Bang (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYFRAC01D,Untidy,Sam Townend
91776 UNTIDYFRAC01D,Untidy,Sam Townend
91777 UNTIDYFRAC01D,Untidy,Sam Townend
91778 UNTIDYFRAC01D,Untidy,Sam Townend
91779 UNTIDYFRAC01D,Untidy,Sam Townend
91909 M.A.R.C, You Must Tune Your Bass 2 Up, SHED TRAX, M.A.R.C. 2020 Remix, Bounce, Featured Hard House New, Hard House, Toolbox Digital Download You Must Tune Your Bass 2 Up (M.A.R.C. 2020 Remix) by SHED TRAX from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ST022,SHED TRAX,M.A.R.C
91930 KB Project, In My Heart, BTID Music, Original Mix, Bounce, Featured Hard House New, Hard House, Toolbox Digital Download In My Heart (Original Mix) by BTID Music from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BTIDMUSIC087,BTID Music,KB Project
91950 Ains, Audio Chavs, Semi Pro Widow, Cantina Records, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Semi Pro Widow (Original Mix) by Cantina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR006,Cantina Records,Ains,Audio Chavs
92477 DNZF934,DNZ Records,DJ Chris Mac,Bounce Enforcerz
92486 DNZ433,DNZ Records,DJ Oskar,V-Star
92498 The Tidy Boys, Pump It Up, Tidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Pump It Up (Original Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYBAEP01,Tidy,The Tidy Boys
92499 Colin Barratt, Let It Rip, Tidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Let It Rip (Original Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYBAEP01,Tidy,Colin Barratt