Sandbox

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 (63852, 64849, 64850, 64851) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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 (63852,64849,64850,64851) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
63852	Offering a functional purpose and charming sense of style, this 3-Light Pendant Chandelier is perfect for kitchens, dining rooms, and commercial settings. Customizable with cord styles and finish colors!	The 3-Light Pendant Chandelier, The 3-Light Pendant Chandeliers, The 3 Light Pendant Chandelier, The 3 Light Pendant Chandeliers, 3-Light Pendant Chandelier, 3-Light Pendant Chandeliers, 3 Light Pendant Chandelier, 3 Light Pendant Chandeliers, The 3-Light Pendant Chandelier Light, The 3-Light Pendant Chandelier Lights, The 3-Light Pendant Chandelier Lighting, 3-Light Pendant Chandelier Light, 3-Light Pendant Chandelier Lights, 3-Light Pendant Chandelier Lighting, The 3 Light Pendant Chandelier Light, The 3 Light Pendant Chandelier Lights, The 3 Light Pendant Chandelier Lighting, 3 Light Pendant Chandelier Light, 3 Light Pendant Chandelier Lights, 3 Light Pendant Chandelier Lighting, The 3-Light Pendant, The 3-Light Pendants, The 3 Light Pendant, The 3 Light Pendants, 3-Light Pendant, 3-Light Pendants, 3 Light Pendant, 3 Light Pendants, The 3-Light Pendant Light, The 3-Light Pendant Lights, The 3-Light Pendant Lighting, 3-Light Pendant Light, 3-Light Pendant Lights, 3-Light Pendant Lighting, The 3 Light Pendant Light, The 3 Light Pendant Lights, The 3 Light Pendant Lighting, 3 Light Pendant Light, 3 Light Pendant Lights, 3 Light Pendant Lighting, The 3-Light Ceiling Pendant, The 3-Light Ceiling Pendants, The 3 Light Ceiling Pendant, The 3 Light Ceiling Pendants, 3-Light Ceiling Pendant, 3-Light Ceiling Pendants, 3 Light Ceiling Pendants, 3 Light Ceiling Pendants, The 3-Light Ceiling Pendant Light, The 3-Light Ceiling Pendant Lights, The 3-Light Ceiling Pendant Lighting, 3-Light Ceiling Pendant Light, 3-Light Ceiling Pendant Lights, 3-Light Ceiling Pendant Lighting, The 3 Light Ceiling Pendant Light, The 3 Light Ceiling Pendant Lights, The 3 Light Ceiling Pendant Lighting, 3 Light Ceiling Pendant Light, 3 Light Ceiling Pendant Lights, 3 Light Ceiling Pendant Lighting, The 3-Light Ceiling Light, The 3-Light Ceiling Lights, The 3-Light Ceiling Lighting, The 3 Light Ceiling Light, The 3 Light Ceiling Lights, The 3 Light Ceiling Lighting, 3-Light Ceiling Light, 3-Light Ceiling Lights, 3-Light Ceiling Lighting, 3 Light Ceiling Light, 3 Light Ceiling Lights, 3 Light Ceiling Lighting, The 3-Light Pendant Light, The 3-Light Pendant Lights, The 3-Light Pendant Lighting, The 3 Light Pendant Light, The 3 Light Pendant Lights, The 3 Light Pendant Lighting, 3-Light Pendant Light, 3-Light Pendant Lights, 3-Light Pendant Lighting, 3 Light Pendant Light, 3 Light Pendant Lights, 3 Light Pendant Lighting, Bare Bulb Chandelier, Bare Bulb Chandeliers, Bare Bulb pendant, Bare Bulb pendants, Bare Bulb pendant Light, Bare Bulb pendant lights, Bare Bulb pendant lighting, Bare Bulb ceiling pendant, Bare Bulb ceiling pendants, Bare Bulb ceiling pendant light, Bare Bulb ceiling pendant lights, Bare Bulb ceiling pendant lighting, Bare Bulb Ceiling Light, Bare Bulb ceiling lights, bare bulb ceiling lighting, bare bulb light, bare bulb lights, bare bulb lighting, Cord hung chandelier, cord hung chandeliers, cord hung pendant chandelier, cord hung pendant chandeliers, Multi-light chandelier, multi light chandelier, multi-light chandelier, multi light chandeliers, Multi-pendant chandelier, multi pendant chandelier, multi-pendant chandeliers, multi pendant chandeliers, BLE-WV-PINDY3/VAN24-PC, The three-Light Pendant Chandelier, The three-Light Pendant Chandeliers, The three Light Pendant Chandelier, The three Light Pendant Chandeliers, three-Light Pendant Chandelier, three-Light Pendant Chandeliers, three Light Pendant Chandelier, three Light Pendant Chandeliers, The three-Light Pendant Chandelier Light, The three-Light Pendant Chandelier Lights, The three-Light Pendant Chandelier Lighting, three-Light Pendant Chandelier Light, three-Light Pendant Chandelier Lights, three-Light Pendant Chandelier Lighting, The three Light Pendant Chandelier Light, The three Light Pendant Chandelier Lights, The three Light Pendant Chandelier Lighting, three Light Pendant Chandelier Light, three Light Pendant Chandelier Lights, three Light Pendant Chandelier Lighting, The three-Light Pendant, The three-Light Pendants, The three Light Pendant, The three Light Pendants, three-Light Pendant, three-Light Pendants, three Light Pendant, three Light Pendants, The three-Light Pendant Light, The three-Light Pendant Lights, The three-Light Pendant Lighting, three-Light Pendant Light, three-Light Pendant Lights, three-Light Pendant Lighting, The three Light Pendant Light, The three Light Pendant Lights, The three Light Pendant Lighting, three Light Pendant Light, three Light Pendant Lights, three Light Pendant Lighting, The three-Light Ceiling Pendant, The three-Light Ceiling Pendants, The three Light Ceiling Pendant, The three Light Ceiling Pendants, three-Light Ceiling Pendant, three-Light Ceiling Pendants, three Light Ceiling Pendants, three Light Ceiling Pendants, The three-Light Ceiling Pendant Light, The three-Light Ceiling Pendant Lights, The three-Light Ceiling Pendant Lighting, three-Light Ceiling Pendant Light, three-Light Ceiling Pendant Lights, three-Light Ceiling Pendant Lighting, The three Light Ceiling Pendant Light, The three Light Ceiling Pendant Lights, The three Light Ceiling Pendant Lighting, three Light Ceiling Pendant Light, three Light Ceiling Pendant Lights, three Light Ceiling Pendant Lighting, The three-Light Ceiling Light, The three-Light Ceiling Lights, The three-Light Ceiling Lighting, The three Light Ceiling Light, The three Light Ceiling Lights, The three Light Ceiling Lighting, three-Light Ceiling Light, three-Light Ceiling Lights, three-Light Ceiling Lighting, three Light Ceiling Light, three Light Ceiling Lights, three Light Ceiling Lighting, The three-Light Pendant Light, The three-Light Pendant Lights, The three-Light Pendant Lighting, The three Light Pendant Light, The three Light Pendant Lights, The three Light Pendant Lighting, three-Light Pendant Light, three-Light Pendant Lights, three-Light Pendant Lighting, three Light Pendant Light, three Light Pendant Lights, three Light Pendant Lighting, Pendant chandelier, Pendant Chandeliers, 3-light chandelier, 3-light chandeliers, downtown, down town, downtown chandelier, downtown pendant chandelier, down town chandelier, downtown, down town, down town minimalist, downtown minimalist, downtown pendant, down town pendant, minimalist pendant, downtown, down, town, downtown minimalist pendant, 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 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, Bare bulb cord, cord bare bulb, bare bulb cord hung, cord hung bare bulb, bare bulb cord hung pendant, bare bulb cord hung pendants, cord hung bare bulb pendant, cord hung bare bulb pendants, cord hung bare bulb ceiling pendant, bare bulb cord hung ceiling pendant, cord hung bare bulb ceiling pendants, bare bulb cord hung ceiling pendants, bare bulb cord hung pendant light, cord hung bare bulb pendant light, cord hung bare bulb pendant lights, bare bulb cord hung pendant lights, cord hung bare bulb pendant lighting, bare bulb cord hung pendant lighting, cord hung bare bulb ceiling light, bare bulb cord hung ceiling light, cord hung bare bulb ceiling lights, bare bulb cord hung ceiling lights, bare bulb cord hung ceiling lighting, cord hung bare bulb ceiling lighting, bare bulb cord mount, cord mount bare bulb, bare bulb cord mount pendant, bare bulb cord mount pendants, cord mount bare bulb pendant, cord mount bare bulb pendants, cord mount bare bulb ceiling pendant, bare bulb cord mount ceiling pendant, cord mount bare bulb ceiling pendants, bare bulb cord mount ceiling pendants, bare bulb cord mount pendant light, cord mount bare bulb pendant light, cord mount bare bulb pendant lights, bare bulb cord mount pendant lights, cord mount bare bulb pendant lighting, bare bulb cord mount pendant lighting, cord mount bare bulb ceiling light, bare bulb cord mount ceiling light, cord mount bare bulb ceiling lights, bare bulb cord mount ceiling lights, bare bulb cord mount ceiling lighting, cord mount bare bulb ceiling lighting, 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-0072, SPS 0072, SPS0072, Downtown Pendant Chandeliers, Downtown Pendant Chandelier Collection, Downtown Pendant Chandelier Series, The Downtown Pendant Chandeliers, The Downtown Pendant Chandelier Collection, The Downtown Pendant Chandelier Series, Down town Pendant Chandeliers, Down town Pendant Chandelier Collection, Down town Pendant Chandelier Series, The Down town Pendant Chandeliers, The Down town Pendant Chandelier Collection, The Down town Pendant Chandelier Series, Triple Pendant lights, Triple Pendant light, Triple Pendant lighting, pindy socket, pindy sockets, pindy cup, pindy cups, pendy socket, pendy sockets, pendy cup, pendy cups,
64849	Fully customizable, this multi-light pendant features an authentic industrial character. Give any space a rugged, eye-catching style!	new listing, new mig, BLE-C-MLP3-MIG, Mig Multi-Light Pendant, Mig Multi-Light Pendants, The Mig Multi-Light Pendant, The Mig Multi-Light Pendants, Mig, The mig, Mig Chandelier, Mig Pendant, Mig Pendants, Multi-light pendant, multi-light pendants, multi-light chandelier, multi-light chandeliers, Mig 3-light Pendant, Mig 3-light chandelier, Mig multilight pendant, mig multilight chandelier, multilight pendant, multilight chandelier, cluster pendant, cluster chandelier, multi-light cluster pendant, multilight cluster pendant, multi-light cluster chandelier, multilight cluster chandelier, Mig Multi Light Pendant, Mig Multi Light Pendants, The Mig Multi Light Pendant, The Mig Multi Light Pendants, Multi Light Pendant, Multi Light Chandelier, Multi Light Cluster Pendant, Multi Light Cluster Chandelier, mig multi light chandelier, mig multilight chandelier, Mig cluster chandelier, SPS-0473, SPS 0473, SPS0473, Mig Collection, The Mig Collection, Mig Series, The Mig Series, Triple Pendant lights, Triple Pendant lighting, Triple Pendant light, the mig retro, gas cap,
64850	Industrial, stylish, and unique, this linear pendant features an authentic character and elevates any décor! Customize its look for your space!	new listing, new mig, BLE-C-CV24-MIG, Mig 2-Light Linear Pendant, Mig 2-Light Linear Chandelier, The Mig 2-Light Linear Pendant, The Mig 2-Light Linear Chandelier, Mig, The Mig, Mig 2 Light Linear Pendant, Mig 2 Light Linear Chandelier, 2-Light Linear Pendant, 2-Light Linear Chandelier, Linear Pendant, Linear Chandelier, 2-light, 2 light, two light, 2-light pendant, 2 light pendant, 2-light pendant, two light pendant, 2-light chandelier, two light chandelier, multi light pendant, multi light chandelier, multilight pendant, multilight chandelier, multi-light pendant, multi-light chandelier, mig multi light chandelier, mig multilight chandelier, migs, SPS-0473, SPS 0473, SPS0473, Mig Collection, The Mig Collection, Mig Series, The Mig Series, pendants, double, the mig retro, gas cap,
64851	A customizable industrial look, the Mig Linear Pendant can put the finishing touches on any décor! Revamp homes and businesses with this unique design!	new listing, new mig, BLE-C-CV36-MIG, Mig 3-Light Linear Pendant, Mig, The Mig, Mig 3-Light Pendant, Mig 3-Light Pendants, Mig Pendant, Mig Pendants, Mig Chandelier, Mig Chandeliers, Mig 3-Light Linear Chandelier, Linear Pendant, Linear Chandelier, 3-light linear pendant, 3 light linear pendant, 3-light, 3 light, three light, 3-light linear chandelier, three light chandelier, 3 light chandelier, linear pendants, multi light pendant, multi light chandelier, mig multi light chandelier, mig multilight chandelier, Triple Pendant lights, Triple Pendant light, Triple Pendant lighting, the mig retro, gas cap,