SELECT 
  cscart_product_descriptions.product_id, 
  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 (
    78020, 78019, 78018, 78017, 78016, 78015, 
    78014, 78013, 78012, 78011, 78010, 
    78009, 78008, 78007, 78006, 78005, 
    78004, 78003, 78002, 78001
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00033

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 meta_keywords meta_description search_words promo_text
78001 HBCBT0203RRD,Hard Dance Coalition,RR Fierce,Nick Sentience
78002 HBCBT0203RRD,Hard Dance Coalition,Trauma,Paul King
78003 HBCBT0203RRD,Hard Dance Coalition,OD404
78004 HBCBT0203RRD,Hard Dance Coalition,Justin Bourne,Jay Pidgeon,James Lawson
78005 HBCBT0203RRD,Hard Dance Coalition,Paul Glazby
78006 HBCBT0203RRD,Hard Dance Coalition,Jez & Charlie
78007 HBCBT0203RRD,Hard Dance Coalition,Paul Glazby,RR Fierce
78008 HBCBT0203RRD,Hard Dance Coalition,Incisions,Paul Glazby,Paul Janes
78009 HBCBT0203RRD,Hard Dance Coalition,RR Fierce,K-Live
78010 HBCBT0203RRD,Hard Dance Coalition,Trauma
78011 HBCBT0203RRD,Hard Dance Coalition,OD404
78012 HBCBT0203RRD,Hard Dance Coalition,Defective Audio,Paul Glazby
78013 HBCBT0203RRD,Hard Dance Coalition,RR Fierce
78014 HBCBT0203RRD,Hard Dance Coalition,Defective Audio
78015 HBCBT0203RRD,Hard Dance Coalition,F1,Paul Glazby
78016 HBCBT0203RRD,Hard Dance Coalition,Technikal,Justin Bourne
78017 HBCBT0203RRD,Hard Dance Coalition,Base Graffiti
78018 HBCBT0203RRD,Hard Dance Coalition,RR Fierce,DMF
78019 HBCBT0203RRD,Hard Dance Coalition,Energy UK DJ's,Justin Bourne,Dynamic Intervention
78020 HBCBT0203RRD,Hard Dance Coalition,Paul Glazby