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 (
    101672, 101545, 101174, 101536, 101526, 
    101525, 101519, 101362, 100737, 100736, 
    92949, 101434, 101391, 101390, 101389, 
    101379, 101356, 101034, 100839, 100838
  ) 
  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 20 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
92949
100736 Overdose Records, Overdose, Andy Naylor
100737 Live Together, Overdose Records, Original Mix, Exclusive, Toolbox Digital Download Live Together (Original Mix) by Overdose Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
100838 PMD047,Pumped,Joe Longbottom
100839 PMD046,Pumped,Joe Longbottom
101034 Baseglitz,feat ,karin Baseglitz
101174 BTN025,Bring The Noise Recordings,Dan Carter
101356 Global,Awakening,Records Global,Awakening,Records
101362 Global,Awakening,Records Global,Awakening,Records
101379 superfly,hardhouse,release,digital,toolbox,hardance
101389 EM012,Kieran B,Emmanating Records,Love Will Save The Day,Hard House EM012,Kieran B,Emmanating Records,Love Will Save The Day,Hard House EM012,Kieran B,Emmanating Records,Love Will Save The Day,Hard House
101390 Full Circle Productions, Zillin zillin, full circle productions
101391 Darken, friendly, crack, dealer, hard, house Darken, friendly, crack, dealer, hard, house
101434 Reticence, Energy Source Productions, Exclusive, Toolbox Digital Download Reticence by Energy Source Productions from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Reticence DJ Serenity Energy Source Productions Hardhouse
101519 Full Circle Productions, djone7tout full circle productions, DJOne7TOut, djone7tout
101525 Tekneak, Burning Blade Tekneak, Burning Blade
101526
101536 Shark,Fin,Records,Worlds,A,Dancefloor,Dean,Richardson Shark,Fin,Records,Worlds,A,Dancefloor,Dean,Richardson
101545 Heatwave DJ Serenity Energy Source Productions Hard House Heatwave DJ Serenity Energy Source Productions Hard House Heatwave DJ Serenity Energy Source Productions Hard House
101672 Hard House, NZ Dance Music, Manik, Kiwi Hard Dance, Toolbox, Snap Back, Dance Music, EDM, Hard Dance, High Energy Music BOOM! Meltdown Records is back with this funky Hard House belter! CAUTION: may contain groove magic, tearing synth work & intelligent stabs. With high energy drive and a bassline that keeps on giving, this weapon is sure to get the dancefloor pumping! Manik, Meltdown, Meltdown Records, NZ, Manic, Snap Back