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 (
    124602, 124217, 124737, 124733, 120650, 
    121239, 9672, 123724, 119502, 124103
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
9672 TBRD023,The Beat Ranch Digital,Dramatik
119502
120650 Paul King, Tony De Vit, I Don't Care, TDV Records, Paul King Trade Club Extended Remix, Featured Hard House, Hard House, Toolbox Digital Download I Don't Care (Paul King Trade Club Extended Remix) by TDV Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TDV007TD,TDV Records,Tony De Vit,Paul King
121239 Agent Jack, Dan Madams, All fire and no desire, Feersum, Hard House, Toolbox Digital Download All fire and no desire by Feersum from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Dan Madams All Fire No Desire, Agent Jack new track, FEERSUM Records music, Latest EDM hits, 2023 club music, Electronic dance tracks, UK DJ music, Dance party anthem, EDM download, New dance music releases, High-energy electronic, Nightclub favorites, DJ collaboration hits, Energetic dance beats, Dance music fans
123724 Dan Madams, Raise Me Up, Feersum, Exclusive, Toolbox Digital Download Raise Me Up by Feersum from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Dan Madams Raise Me Up, Hard House 2024, New dance music, High-energy tracks, Club music hits, UK hard house, Energetic electronic music, Party anthems, Music for DJs, Hard house anthems, Dance floor hits, Electronic music downloads, Dan Madams music, Hard house classics, Top dance tracks.
124103 Andy Farley, Ben Stevens, Shut Ya Mouth!, PureAF Records, Original Mix, Hard Dance, Toolbox Digital Download Shut Ya Mouth! (Original Mix) by PureAF Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. PAF1,PureAF Records,Andy Farley,Ben Stevens
124217 The Kat, Look Me In The Eye, D, Extended, Hard House, Toolbox Digital Download Look Me In The Eye (Extended) by D from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DNRGK3,D,The Kat
124602 Ben Vennard, Gav Adam, A Little Bit More, Feersum, Hard House, Toolbox Digital Download A Little Bit More by Feersum from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Gav Adam A Little Bit More, Ben Vennard new music, 2024 EDM tracks, Club hits, Latest dance music, Energetic EDM, Music collaboration hits, UK DJ music, Party anthems, New electronic tracks, Upbeat dance songs, Dance music downloads, Electronic music fans, Nightclub music playlist, EDM release 2024.
124733 The Kat, Hours Only, D, Extended, Hard House, Toolbox Digital Download Hours Only (Extended) by D from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DNRGK4,D,The Kat
124737 Dan Madams, Feed Your Soul, Feersum, Hard House, Toolbox Digital Download Feed Your Soul by Feersum from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Dan Madams Feed Your Soul, New EDM 2024, Dance music hits, Club anthems, Energetic dance tracks, Electronic music 2024, Party music, Dance floor hits, DJ Dan Madams new track, Hard house music, EDM downloads, Uplifting dance songs, Nightclub playlist, High-energy beats, Latest dance releases.