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 (63810, 64766, 64767, 63137) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (63810,64766,64767,63137) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
63137 Looking to the Soho, New York for inspiration this rustic chandelier brings the chic—yet—rugged look to your home or business! Customize it to meet your needs! The Canal Street SoHo 3 Light Chandelier, BLE-S-CH022, Canal Street SoHo 3 Light Chandelier, Canal, Canal Street, Soho, Soho lighting, Soho pendant, soho chandelier, rustic lighting, rustic chandelier, canal street, canal street chandelier, canal st., soho 3 light, soho 3 light chandelier, soho industrial, industrial chandelier, three light, 3 light, 3-light, 3 light chandelier, 3-light chandelier, three light chandelier, industrial pendant chandelier, galvanized, galvanized piping, galvanized soho, chandelier, Canal Street SoHo 3 Light Chandelier, Canal Street SoHo 3-Light Chandelier, canal street 3-light, canal 3-light, canal street 3-light chandelier, canal 3-light chandelier, canal, soho, soho three light, soho 3 light, canal soho 3-light chandelier, soho chandeliers, soho chandelier, canal chandelier, canal chandeliers, SPS-0264, SPS 0264, SPS0264, soho collection, soho series,
63810 Adhering to many different design sensibilities, the Parson shows off five adjustable arms. This lets you adjust each arm to various angles, providing the perfect look for any space! BLE-S-CH027-PC, The Parson Adjustable Arm Chandelier, The Parson Adjustable Arm Chandeliers, Parson Adjustable Arm Chandelier, Parson Adjustable Arm Chandeliers, The Parson Adjustable Chandelier, The Parson Adjustable Chandeliers, Parson Adjustable Chandelier, Parson Adjustable Chandeliers, Adjustable arm chandelier, adjustable arm chandeliers, adjustable arm light, adjustable arm lights, adjustable arm lighting, adjustable chandelier, adjustable chandeliers, Adjustable arm, The Parson Minimalist Chandelier, The Parson Minimalist Chandeliers, Parson Minimalist Chandelier, Parson Minimalist Chandeliers, minimalist chandelier, minimalist chandeliers, minimalist adjustable arm chandelier, minimalist adjustable arm chandeliers, adjustable arm minimalist chandelier, adjustable arm minimalist chandeliers, adjustable minimalist chandelier, adjustable minimalist chandeliers, minimalist adjustable chandelier, adjustable arm, adjustable, minimalist, adjustable arm ceiling pendant, adjustable arm ceiling pendants, adjustable arm ceiling light, adjustable arm ceiling lights, adjustable arm ceiling lighting, adjustable arm pendant, adjustable arm pendants, adjustable arm pendant light, adjustable arm pendant lights, adjustable arm pendant lighting, minimalist ceiling pendant, minimalist ceiling pendants, minimalist ceiling light, minimalist ceiling lights, minimalist ceiling lighting, minimalist pendant, minimalist pendants, minimalist pendant light, minimalist pendant lights, minimalist pendant lighting, Parson, Parson Chandelier, Parson chandeliers, parson brass, brass chandelier, brass chandeliers, brass minimalist chandelier, brass minimalist chandeliers, minimalist brass chandelier, minimalist brass chandeliers, Bare bulb light, bare bulb lights, bare bulb lighting, bare bulb light fixture, bare bulb light fixtures, bare bulb lighting fixture, bare bulb lighting fixtures, Bare bulb pendant, bare bulb pendants, bare bulb ceiling pendant, bare bulb ceiling pendants, bare bulb pendant light, bare bulb pendant lights, bare bulb pendant lighting, bare bulb ceiling light, bare bulb ceiling lights, bare bulb ceiling lighting, Bare bulb chandelier, bare bulb chandeliers, bare bulb chandelier fixture, bare bulb chandelier fixtures, bare bulb multi light, bare bulb multilight, bare bulb multilights, bare bulb multilighting, bare bulb multi light, bare bulb multi lights, bare bulb multi lighting, bare bulb multi-light, bare bulb multi-lights, bare bulb multi-lighting, bare bulb multiple light, bare bulb multiple lights, bare bulb multiple lighting, multiple lighting fixtures, multiple light fixture, multiple light fixtures, multiple lighting fixture, chandelier with multiple fixtures, chandelier with multiple fixture, chandeliers with multiple fixtures, chandeliers with multiple light fixture, chandelier with multiple light fixtures, chandelier with multiple lighting fixture, chandelier with multiple lighting fixtures, chandeliers with multiple light fixtures, chandeliers with multiple lighting fixtures, Downtown Collection, Downtown Series, The Downtown Collection, The Downtown Series, Down town Collection, Down town Series, The Down town Collection, The Down town Series, Minimalist collection, Minimalist series, The Minimalist collection, The Minimalist series, Downtown Minimalist Collection, Downtown Minimalist Series, The Downtown Minimalist Collection, The Downtown Minimalist Series, Down town Minimalist Collection, Down town Minimalist Series, The Down town Minimalist Collection, The Down town Minimalist Series, SPS-0001, SPS0001, SPS 0001,
64766 Striking and versatile, this chandelier makes a statement in any setting! Fully customizable with powder coat, copper, and brass. Made in the USA! BLE-S-CH032, Parabolic Linear 8-Light Chandelier, Parabolic Linear 8-Light Chandeliers, Parabolic 8-Light Chandelier, Parabolic 8-Light Chandeliers, Linear 8-Light Chandelier, Linear 8-Light Chandeliers, The Parabolic Linear 8-Light Chandelier, The Parabolic Linear 8-Light Chandeliers, The Parabolic 8-Light Chandelier, The Parabolic 8-Light Chandeliers, The Linear 8-Light Chandelier, The Linear 8-Light Chandeliers, Parabolic Linear eight Light Chandelier, Parabolic Linear eight Light Chandeliers, Parabolic eight Light Chandelier, Parabolic eight Light Chandeliers, Linear eight Light Chandelier, Linear eight Light Chandeliers, The Parabolic Linear eight Light Chandelier, The Parabolic Linear eight Light Chandeliers, The Parabolic eight Light Chandelier, The Parabolic eight Light Chandeliers, The Linear eight Light Chandelier, The Linear eight Light Chandeliers, 8-light chandelier, 8-light chandeliers, eight light chandelier, eight light chandelier, chandelier, chandeliers, large chandeliers, oversized chandeliers, big chandelier, big chandeliers, large chandelier, oversized chandelier, parabolic, parabolic chandelier, parabolic chandeliers, linear, linear chandelier, linear chandeliers, parabolic, The Parabolic, Parabolic Collection, Parabolic Series, Parabolic Chandelier Collection, Parabolic Chandelier Series, SPS-0210, SPS 0210, SPS0210,
64767 A customizable, hand-crafted statement piece for homes and businesses! This chandelier features a bold design and twelve rotatable shades! USA-made! BLE-S-CH031, Parabolic Linear 12-Light Chandelier, Parabolic Linear 12-Light Chandeliers, Parabolic 12-Light Chandelier, Parabolic 12-Light Chandeliers, Linear 12-Light Chandelier, Linear 12-Light Chandeliers, The Parabolic Linear 12-Light Chandelier, The Parabolic Linear 12-Light Chandeliers, The Parabolic 12-Light Chandelier, The Parabolic 12-Light Chandeliers, The Linear 12-Light Chandelier, The Linear 12-Light Chandeliers, Parabolic Linear twelve Light Chandelier, Parabolic Linear twelve Light Chandeliers, Parabolic twelve Light Chandelier, Parabolic twelve Light Chandeliers, Linear twelve Light Chandelier, Linear twelve Light Chandeliers, The Parabolic Linear twelve Light Chandelier, The Parabolic Linear twelve Light Chandeliers, The Parabolic twelve Light Chandelier, The Parabolic twelve Light Chandeliers, The Linear twelve Light Chandelier, The Linear twelve Light Chandeliers, 12-light chandelier, 12-light chandeliers, twelve light chandelier, twelve light chandelier, chandelier, chandeliers, large chandeliers, oversized chandeliers, big chandelier, big chandeliers, large chandelier, oversized chandelier, parabolic, parabolic chandelier, parabolic chandeliers, linear, linear chandelier, linear chandeliers, parabolic, the Parabolic, Parabolic Collection, Parabolic Series, Parabolic Chandelier Collection, Parabolic Chandelier Series, SPS-0210, SPS 0210, SPS0210,