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 (64766, 62230, 64351, 63467) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00072

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 (64766,62230,64351,63467) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
62230 three light pendant, parabolic light, stem pendant light, mid century lighting, retro pendant light Bring mid century lighting to any space with this 3-light chandelier. The Parabolic Chandelier features a refined stem pendant and retro, half-dome shades. Parabolic 3-Light Chandelier, BLE-S-CH013, clamshell light, half shade pendant, chandelier, mid century, parabolic light, parabolic shade pendant, retro chandelier, parabolic, parabolic 3-light, 3-light parabolic, parabolic 3 light, 3 light parabolic, three light parabolic, parabolic three light, Parabolic 3 light chandelier, chandelier, chandeliers, three light chandelier, three light chandeliers, 3-light chandelier, 3-light chandeliers, 3 light chandelier, 3 light chandeliers, industrial chandelier, industrial chandeliers, farmhouse chandelier, farmhouse chandeliers, farm house chandelier, farm house chandeliers, small chandeliers,
63467 Removing its shade, this three light minimalist chandelier displays a fashionable style perfect for any location. Customizable with lively finish colors, bring the Downtown to your space today! minimalist chandelier, minimalist chandeliers, minimalist pendant, minimalist pendants, minimalist pendant light, minimalist pendant lights, minimalist pendant lighting, modern chandelier, modern chandeliers, contemporary chandelier, contemporary chandeliers, modern pendant, modern pendants, modern pendant light, modern pendant lights, modern pendant lighting, contemporary pendant, contemporary pendants, contemporary pendant light, contemporary pendant lights, contemporary pendant lighting, minimalist ceiling pendant, minimalist ceiling pendants, minimalist ceiling light, minimalist ceiling lights, minimalist ceiling lighting, modern ceiling pendant, modern ceiling pendants, modern ceiling light, modern ceiling lights, modern ceiling lighting, contemporary ceiling pendant, contemporary ceiling pendants, contemporary ceiling light, contemporary ceiling lights, contemporary ceiling lighting, chandelier, chandeliers, downtown, down town, downtown chandelier, downtown chandeliers, down town chandelier, down town chandeliers, downtown light, down town light, downtown lights, down town lights, downtown lighting, down town lighting, downtown ceiling pendant, down town pendants, downtown ceiling pendant, down town ceiling pendant, down town ceiling pendant, down town ceiling pendants, downtown ceiling light, down town ceiling light, downtown ceiling lights, down town ceiling lights, downtown ceiling lighting, down town ceiling lighting, BLE-S-CH025-PC, The Downtown Minimalist 3-Light Chandelier, The Downtown Minimalist 3-Light Chandeliers, The Downtown Minimalist 3 Light Chandelier, The Downtown Minimalist 3 Light Chandeliers, Downtown Minimalist 3-Light Chandelier, Downtown Minimalist 3-Light Chandeliers, Downtown Minimalist 3 Light Chandelier, Downtown Minimalist 3 Light Chandeliers, The Downtown Minimalist Chandelier, The Downtown Minimalist Chandeliers, Downtown Minimalist Chandelier, Downtown Minimalist Chandeliers, 3-light chandelier, 3 light chandelier, 3-light chandeliers, 3 light chandeliers, 3-light pendant, 3-light pendants, 3 light pendants, 3 light pendants, 3-light ceiling light, 3-light ceiling lights, 3-light ceiling lighting, 3 light ceiling light, 3 light ceiling lights, 3 light ceiling lighting, 3-light pendant light, 3-light pendant lights, 3-light pendant lighting, minimalist 3-light chandelier, minimalist 3-light chandeliers, 3-light minimalist chandelier, 3-light minimalist chandeliers, 3 light pendant light, 3 light pendant lights, 3 light pendant lighting, minimalist 3 light chandelier, minimalist 3 light chandeliers, 3 light minimalist chandelier, 3 light minimalist chandeliers, downtown 3 light, 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, downlight minimalist, down light minimalist, down minimalist, 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-0282, SPS 0282, SPS0282, small chandeliers,
64351 A fashionable mid century chandelier with an imaginative design! Customizable with various finish colors and glass options! Made in the USA! The Bubble Chandelier, Bubble Chandelier, The Bubble Chandeliers, Bubble Chandeliers, The Bubble 5-Light Chandelier, The Bubble 5-Light Chandeliers, Bubble 5-Light Chandelier, Bubble 5-Light Chandeliers, The Bubble 5 Light Chandelier, The Bubble 5 Light Chandeliers, Bubble 5 Light Chandelier, Bubble 5 Light Chandeliers, 5-Light Chandelier, 5-Light Chandeliers, 5 Light Chandelier, 5 Light Chandelier, Bubble, The Bubble, midcentury chandelier, mid-century chandelier, mid century chandelier, midcentury chandeliers, mid-century chandeliers, mid century chandeliers, modern chandelier, modern chandeliers, BLE-S-CH028-PC, The Bubble Stem Mount Pendant, The Bubble Stem Mount Pendant Light, The Bubble Stem Mount Pendant Lights, The Bubble Stem Mount Pendant Lighting, The Bubble Stem Mount Ceiling Pendant, The Bubble Stem Mount Ceiling Pendants, The Bubble Stem Mount Ceiling Light, The Bubble Stem Mount Ceiling Lights, The Bubble Stem Mount Ceiling Lighting, Bubble Stem Mount Pendant, Bubble Stem Mount Pendant Light, Bubble Stem Mount Pendant Lights, Bubble Stem Mount Pendant Lighting, Bubble Stem Mount Ceiling Pendant, Bubble Stem Mount Ceiling Pendants, Bubble Stem Mount Ceiling Light, Bubble Stem Mount Ceiling Lights, Bubble Stem Mount Ceiling Lighting, The Bubble Stem Pendant, The Bubble Stem Pendant Light, The Bubble Stem Pendant Lights, The Bubble Stem Pendant Lighting, The Bubble Stem Ceiling Pendant, The Bubble Stem Ceiling Pendants, The Bubble Stem Ceiling Light, The Bubble Stem Ceiling Lights, The Bubble Stem Ceiling Lighting, Bubble Stem Pendant, Bubble Stem Pendant Light, Bubble Stem Pendant Lights, Bubble Stem Pendant Lighting, Bubble Stem Ceiling Pendant, Bubble Stem Ceiling Pendants, Bubble Stem Ceiling Light, Bubble Stem Ceiling Lights, Bubble Stem Ceiling Lighting, The Bubble Pendant, The Bubble Pendant Light, The Bubble Pendant Lights, The Bubble Pendant Lighting, The Bubble Ceiling Pendant, The Bubble Ceiling Pendants, The Bubble Ceiling Light, The Bubble Ceiling Lights, The Bubble Ceiling Lighting, Bubble Pendant, Bubble Pendant Light, Bubble Pendant Lights, Bubble Pendant Lighting, Bubble Ceiling Pendant, Bubble Ceiling Pendants, Bubble Ceiling Light, Bubble Ceiling Lights, Bubble Ceiling Lighting, Midcentury pendant, mid-century pendant, mid century pendant, Midcentury pendant light, mid-century pendant light, mid century pendant light, Midcentury pendant lights, mid-century pendant lights, mid century pendant lights, Midcentury pendant lighting, mid-century pendant lighting, mid century pendant lighting, Midcentury ceiling pendant, mid-century ceiling pendant, mid century ceiling pendant, Midcentury ceiling pendants, mid-century ceiling pendants, mid century ceiling pendants, Midcentury ceiling light, mid-century ceiling light, mid century ceiling light, Midcentury ceiling lights, mid-century ceiling lights, mid century ceiling lights, Midcentury ceiling lighting, mid-century ceiling lighting, mid century ceiling lighting, Midcentury light, mid-century light, mid century light, Midcentury lights, mid-century lights, mid century lights, Midcentury lighting, mid-century lighting, mid century lighting, Modern pendant, modern pendants, modern pendant light, modern pendant lights, modern pendant lighting, modern ceiling pendant, modern ceiling pendants, modern ceiling light, modern ceiling lights, modern ceiling lighting, contemporary pendant, contemporary pendants, contemporary ceiling pendant, contemporary ceiling pendants, contemporary pendant light, contemporary pendant lights, contemporary pendant lighting, contemporary ceiling light, contemporary ceiling lights, contemporary ceiling lighting, midcentury light, mid-century lights, mid century lighting, modern light, modern lights, modern lighting, contemporary light, contemporary lights, contemporary lighting, BLE-S-CH028-PC, contemporary chandelier, contemporary chandeliers, midcentury modern, mid century modern, mid-century modern, new downtown and bubble, bubble light, bubble, buble, bubbel, bubble collection, bubble series, the bubble collection, the bubble series, SPS-0003, SPS 0003, SPS0003, bubble lights, bubble light, bubble lighting, bubble light fixture, bubble light fixtures, bubble lighting fixture, bubble light fixtures, bubble light chandelier,
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,