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 (
    93938, 92908, 92679, 93934, 93931, 93930, 
    93929, 93927, 93907, 93906, 93905, 
    93902, 93796, 93784, 93544, 93459, 
    93069, 93068, 93797, 93774
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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
92679 James Dub, The Hospital, Fireball, Exclusive, Toolbox Digital Download The Hospital by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
92908 Paul Glazby, Loventi, Vicious Circle, Exclusive, Toolbox Digital Download Loventi by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
93068 Cheek514B,Cheeky Tracks,Brysi,Grapey,Kirk P
93069 Cheek514B,Cheeky Tracks,Brysi,Grapey,Kirk P
93459 HOT081,Hot Box Digital,The Hoover Jocks
93544 GSR, Tough Guy - Lockdown Mix, WLHH, Ode to Snoopy, Exclusive, Toolbox Digital Download Tough Guy (Ode to Snoopy) - Lockdown Mix by WLHH from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. GSR, Tough Guy (Ode to Snoopy), WLHH, Hard House
93774 Paul Clark, Razmatazz, Hi-Five Digital , Exclusive, Toolbox Digital Download Razmatazz by Hi-Five Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
93784 Eton Mess, Kimara Records, Hayz, M-Series, remix Eton Mess, Kimara Records, Hayz, M-Series, remix
93796
93797 Jamesnardi, jamesnardistudio, scorpiontrac, hardhouse Jamesnardi, jamesnardistudio, scorpiontrac, hardhouse Jamesnardi, jamesnardistudio, scorpiontrac, hardhouse
93902 Hard trance, hard house, Pete warwick, locked up, hard dance, sugar skull, carl pearce, cheryl pearce, filth, filthy hard house Sugar Skull Digital is premuim hard house and hard trance label, releasing the best tracks in hard dance today. Hard trance, hard house, Pete warwick, locked up, hard dance, sugar skull, carl pearce, cheryl pearce, filth, filthy hard house
93905
93906
93907 Visceral, filth, hoover, Paul, Reeves, Paul Reeves, Visceral Filth, my, dirty Paul Reeves brings the MASSIVE hoover-y goodness to Visceral Filth with his track Hoover my (Dirty) Playroom. Beastly brutal, this one. Visceral, filth, hoover, Paul, Reeves, Paul Reeves, Visceral Filth, my, dirty
93927 Random,But,Raw,Deep,Down,Motorcycle,as,the,rush,comes,remix,bootleg,rework,helix,recordings Random But Raw returns to the label to follow up his chart topping release Go Ape last year with this sensual vocal intertwined with hoovers. Random,But,Raw,Deep,Down,Motorcycle,as,the,rush,comes,remix,bootleg,rework,helix,recordings
93929 Kodokushi, Tekneak, Burning Blade Kodokushi, Tekneak, Burning Blade
93930
93931
93934 Gary O'Connor, Shine, Digital Snail, Hard House Gary O'Connor, Shine, Digital Snail, Hard House Gary O'Connor, Shine, Digital Snail, Hard House
93938 TMP172,Aynsley Byrne,Touch Me,Tempo Trax,Hard House Hard House TMP172,Aynsley Byrne,Touch Me,Tempo Trax,Hard House