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 (
    45227, 45226, 45225, 45224, 45223, 45222, 
    45221, 45220, 45219, 45218, 45217, 
    45216, 45215, 44881, 44880, 44879, 
    44878, 44877, 44876, 44875
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00026

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
44875 LWHDS08,LW Recordings,DJ Benchuscoro
44876 LWHDS08,LW Recordings,Pain Disorder Project,Da Productor
44877 LWHDS08,LW Recordings,Alex Tr
44878 Brendan Ashley, Valex, 4Gotten, LW Recordings, Brendan Ashley Remix, Hard Dance, Toolbox Digital Download 4Gotten (Brendan Ashley Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,Valex,Brendan Ashley
44879 LWHDS08,LW Recordings,Sergio Caubal,Isaac Sanchez,Jaime Guerrero,Nunu
44880 Cut-Up, Time To Rock, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Time To Rock (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,Cut-Up
44881 LWHDS08,LW Recordings
45215 LWWHAHC09,LW Recordings,Paul Elstak,Firestone,The BeatKrusher
45216 LWWHAHC09,LW Recordings,SRB
45217 LWWHAHC09,LW Recordings,Hardcore Masterz Vienna,Euphority
45218 LWWHAHC09,LW Recordings,E-Noid,SRB
45219 LWWHAHC09,LW Recordings,DJ Overdrive
45220 LWWHAHC09,LW Recordings,Jekyll,Skoda
45221 LWWHAHC09,LW Recordings,Ganar
45222 LWWHAHC09,LW Recordings,IYF,Tripple-T,MC Gazy J
45223 LWWHAHC09,LW Recordings,S3RL
45224 LWWHAHC09,LW Recordings,Bridson,Allison
45225 LWWHAHC09,LW Recordings,Freefall
45226 LWWHAHC09,LW Recordings,Dope D.O.D.,Teddy Killerz,Partyraiser
45227 LWWHAHC09,LW Recordings,Gone