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 (
    95010, 95009, 93344, 95875, 95866, 95836, 
    95164, 92917, 95835, 95801, 95800, 
    95852, 95744, 95743, 95742, 95741, 
    95701, 95547, 95538, 95302
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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
92917 Wayne German, Circular Movement, Vicious Circle, Exclusive, Toolbox Digital Download Circular Movement by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
93344 J2S, James Nardi, Frantic Digital, Hard House, Tough Business J2S, James Nardi, Frantic Digital, Hard House, Tough Business
95009 Cheek525,Cheeky Tracks,Rick James,General Bounce
95010 Cheek525,Cheeky Tracks,Rick James,General Bounce
95164 HOT085,Hot Box Digital,Team Sly
95302
95538 Andy Naylor, I gotta have, WLHH, Exclusive, Toolbox Digital Download I gotta have by WLHH from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Andy, Naylor, I gotta have
95547 deadpool,homzy,mada,dael-dean,toolboxdigitalshop/deadpool Deadpool,homzy,mada,dale-dean,wellybob
95701 Dramatik,Leebanga,Eminem,Rap,Helix,Recordings Dramatic makes his debut on the label with this fun offbeat hoover track with a bit of Eminem thrown in on catchy rap vocal loops Dramatik,Leebanga,Eminem,Rap,Helix,Recordings
95741
95742 Support Mechanism, Kimara Records, M-Series Support Mechanism, Kimara Records, M-Series Support Mechanism, Kimara Records, M-Series
95743 M-Series & Stu Cowper, Vandalize Remix, Support Mechanism, Kimara Records, Exclusive, Toolbox Digital Download Support Mechanism by Kimara Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Support Mechanism, Kimara Records, M-Series
95744 Adam Dixon, M-Series & Stu Cowper, Support Mechanism, Kimara Records, Adam Dixon Remix, Exclusive, Toolbox Digital Download Support Mechanism (Adam Dixon Remix) by Kimara Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Support Mechanism, Kimara Records, M-Series
95800
95801
95835 Burning Blade, Tekneak, Tara N Burning Blade, Tekneak, Tara N
95836 Hard trance, hard house, Worth It, hard dance, sugar skull, carl pearce, cheryl pearce, Sugar Skull Digital is premuim hard house and hard trance label, releasing the best tracks in hard dance today. Hard trance, hard house, Worth It, hard dance, sugar skull, carl pearce, cheryl pearce,
95852 Visceral, Hard, Hard Dance, Hard Trance, Uplifting, Visceral Records, Ross Farley, Slenderman, Matt Clarkson, Make it Count Ross Farley & Slenderman keep bringing the serious uplifting hard dance vibes with this one. It mixes both of their styles seamlessly in one jammy jam of a jammy jam. Visceral, Hard, Hard Dance, Hard Trance, Uplifting, Visceral Records, Ross Farley, Slenderman, Matt Clarkson, Make it Count
95866
95875