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 (63344, 63345, 63346, 63347) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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 (63344,63345,63346,63347) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
63344	Looking to the Machine Age for inspiration, we’ve introduced a line of steampunk lighting. This wall sconce adds unique style and industrial flair to any space!	The Victoria Machine Age Sconce, Victoria Machine Age Sconce, The Victoria Sconce, Victoria Sconce, The Victoria Wall Sconce, Victoria Wall Sconce, Victoria Wall Sconces, Victoria Sconces, The Victoria Sconces, Machine Age Sconce, Machine Age Sconces, Machine Age Wall Sconce, Machine Age Wall Sconces, Machine Age Wall Light, Machine Age Wall Lights, Machine Age Wall Lighting, Victoria Wall Light, Victoria Wall Lighting, Steampunk, Steam punk, steampunk light, steam punk light, steampunk lights, steam punk lights, steampunk lighting, steam punk lighting, steampunk sconce, steam punk sconce, steampunk wall sconce, steam punk wall sconce, steampunk wall sconces, steam punk wall sconces, steampunk wall light, steam punk wall light, steam punk wall lights, steampunk wall lights, steam punk wall lighting, steampunk wall lighting, BLE-G-MA2, Victoria, Machine age, steam punk, steampunk, cage, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor lighting, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces,
63345	Suspended in homes or businesses, this steampunk pendant offers a touch of industrial style. Made with Machine Age styles to give any space a trendy new look!	BLE-C-MA3, The Verne Machine Age Pendant, Verne Machine Age Pendant, Verne Pendant, The Verne Machine Age, Verne Machine Age, Machine Age, Verne Pendant, Verne, Machine Age, Machine Age Pendant, Machine Age Pendants, Machine Age Pendant Light, Machine Age Pendant Lights, Machine Age Pendant Lighting, Verne, Verne Pendants, Verne Pendant Light, Verne Pendant Lights, Verne Pendant Lighting, Verne Ceiling Pendant, Verne Ceiling Pendants, Verne Ceiling Light, Verne Ceiling Lights, Verne Ceiling Lighting, Steam, punk, steampunk, steam punk, steampunk light, steam punk light, steampunk lights, steam punk lights, steam, punk, machine, age, machine age, steampunk, steam punk, Verne, cage, verne machine aged, plumbing pendant, Caged lights, Caged light, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, wire cage pipe pendant, industrial cage lighting,
63346	A chandelier influenced by Machine Age styles and the steampunk aesthetic, the Edward offers an unprecedented style to any home or business! Add a unique ceiling light today!	The Edward Machine Age Chandelier, Edward Machine Age Chandelier, The Edward Machine Age, Edward Machine Age, The Edward Chandelier, Edward Chandelier, Machine, Age, Machine Age, Machine Age chandelier, machine age chandeliers, machine age ceiling light, machine age ceiling lights, machine age ceiling lighting, Edward chandeliers, Edward ceiling light, Edward ceiling lights, Edward ceiling lighting, machine, age, machine age, steam, punk, steampunk, steam punk, Edward, Edward light, Edward lights, Edward lighting, machine age light, machine age lights, machine age lighting, steampunk light, steampunk lights, steampunk lighting, steam punk light, steam punk lights, steam punk lighting, steampunk chandelier, steampunk chandeliers, steam punk chandelier, steam punk chandeliers, steampunk ceiling light, steam punk ceiling light, steampunk ceiling lights, steam punk ceiling lights, steampunk ceiling lighting, steam punk ceiling lighting, BLE-S-MA4, Edward, steampunk, steam punk, machine age, cage, plumbing pendant, Caged lights, Caged light, industrial cage lighting,
63347	Give your room the unmatched style of steampunk lights! The Wells Machine Age Chandelier is made by hand from quality materials in the United States.	The Wells Machine Age Chandelier, Wells Machine Age Chandelier, The Wells Machine Age, Wells Machine Age, The Wells Chandelier, Wells Chandelier, Machine, Age, Machine Age, Machine Age chandelier, machine age chandeliers, machine age ceiling light, machine age ceiling lights, machine age ceiling lighting, Wells chandeliers, Wells ceiling light, Wells ceiling lights, Wells ceiling lighting, machine, age, machine age, steam, punk, steampunk, steam punk, Wells, Wells light, Wells lights, Wells lighting, machine age light, machine age lights, machine age lighting, steampunk light, steampunk lights, steampunk lighting, steam punk light, steam punk lights, steam punk lighting, steampunk chandelier, steampunk chandeliers, steam punk chandelier, steam punk chandeliers, steampunk ceiling light, steam punk ceiling light, steampunk ceiling lights, steam punk ceiling lights, steampunk ceiling lighting, steam punk ceiling lighting, Wells, BLE-S-MA5, 3-light chandelier, 3-light chandeliers, cage, plumbing pendant, Caged lights, Caged light, small chandeliers, industrial cage lighting,