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 (65657, 65658) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00065

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": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65657,65658) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words	promo_text
65657		Classic RLM design gets an upgrade with warm, inviting wood. Energy-efficient LED makes this pendant a smart and stylish choice for home or business!	BLE-C-WYDM, BLE-C-WYDM-LED, Marathon Uplight Wooden Top Pendant, Marathon Uplight Wooden Top Pendant light, Marathon Wooden Top Pendant, Marathon Wooden Top Pendant light, Marathon Uplight Wooden Pendant, Marathon Uplight Wooden Pendant light, Marathon Wooden Pendant, Marathon Wooden Pendant Light, Marathon Up light Wooden Top Pendant, Marathon Up light Wooden Top Pendant light, Marathon Up light Wooden Pendant, Marathon Up light Wooden Pendant light, Wooden Uplight pendant, Wooden Up Light Pendant, Wooden Uplight Pendant Light, Wooden Up Light Pendant light, Marathon wooden pendant, marathon wooden pendant light, wooden top pendant, wooden top pendant light, wooden pendant, wooden pendant light, Marathon, Marathon Uplight, Marathon wooden uplight, Marathon Up Light, Marathon wooden up light, wood, Marathon Uplight Wood Top Pendant, Marathon Uplight Wood Top Pendant light, Marathon Wood Top Pendant, Marathon Wood Top Pendant light, Marathon Uplight Wood Pendant, Marathon Uplight Wood Pendant light, Marathon Wood Pendant, Marathon Wood Pendant Light, Marathon Up light Wood Top Pendant, Marathon Up light Wood Top Pendant light, Marathon Up light Wood Pendant, Marathon Up light Wood Pendant light, Wood Uplight pendant, Wood Up Light Pendant, Wood Uplight Pendant Light, Wood Up Light Pendant light, Marathon wood pendant, marathon wood pendant light, wood top pendant, wood top pendant light, wood pendant, wood pendant light, Marathon, Marathon Uplight, Marathon wood uplight, Marathon Up Light, Marathon wood up light, wooden, timber, ore, timber and ore, timber & ore, Light with wooden top, light with wood top, light with wooden fixture, light with wood fixture, light with wood top, light with wooden top, light with wood, light with wood socket, light with wooden socket, light with wooden sockets, light with wood sockets, wood socket, wooden sockets, wood socket light, wooden socket lights, Pendant with wooden top, pendant with wood top, Pendant with wooden fixture, pendant with wood fixture, pendant with wood top, pendant with wooden top, pendant with wood, pendant with wood socket, pendant with wooden socket, pendant with wooden sockets, pendant with wood sockets, Pendants with wooden top, pendants with wood top, Pendants with wooden fixture, pendants with wood fixture, pendants with wood top, pendants with wooden top, pendants with wood, pendants with wood socket, pendants with wooden socket, pendants with wooden sockets, pendants with wood sockets, BLE-C-WYDM12, BLE-C-WYDM14, BLE-C-WYDM16, marathon series, marathon collection, the marathon series, the marathon collection, marathon led series, marathon led collection, the marathon led series, the marathon led collection, SPS-0477, SPS0477, SPS 0477, white pendant, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wooden hanging light, wooden hanging lights, wooden hanging lighting, wood hanging light, wood hanging lights, wood hanging lighting, 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, wooden top barn light, wood lights, wood and metal lights, timber ore, marathon led, marathon wood led, marathon wooden led, wood marathon, led wood, wood led, timber and ore led, timber ore led, led timber and ore, led timber ore, wood accent light, wood accent pendant,
65658		Our popular Marathon shade gets an upgrade with a sleek wooden top and diffuser to disperse energy-efficient LED light. Order now for your home or business!	BLE-C-UWYDM, Marathon Uplight Wooden Top Pendant, Marathon Uplight Wooden Top Pendant light, Marathon Wooden Top Pendant, Marathon Wooden Top Pendant light, Marathon Uplight Wooden Pendant, Marathon Uplight Wooden Pendant light, Marathon Wooden Pendant, Marathon Wooden Pendant Light, Marathon Up light Wooden Top Pendant, Marathon Up light Wooden Top Pendant light, Marathon Up light Wooden Pendant, Marathon Up light Wooden Pendant light, Wooden Uplight pendant, Wooden Up Light Pendant, Wooden Uplight Pendant Light, Wooden Up Light Pendant light, Marathon wooden pendant, marathon wooden pendant light, wooden top pendant, wooden top pendant light, wooden pendant, wooden pendant light, Marathon, Marathon Uplight, Marathon wooden uplight, Marathon Up Light, Marathon wooden up light, wood, Marathon Uplight Wood Top Pendant, Marathon Uplight Wood Top Pendant light, Marathon Wood Top Pendant, Marathon Wood Top Pendant light, Marathon Uplight Wood Pendant, Marathon Uplight Wood Pendant light, Marathon Wood Pendant, Marathon Wood Pendant Light, Marathon Up light Wood Top Pendant, Marathon Up light Wood Top Pendant light, Marathon Up light Wood Pendant, Marathon Up light Wood Pendant light, Wood Uplight pendant, Wood Up Light Pendant, Wood Uplight Pendant Light, Wood Up Light Pendant light, Marathon wood pendant, marathon wood pendant light, wood top pendant, wood top pendant light, wood pendant, wood pendant light, Marathon, Marathon Uplight, Marathon wood uplight, Marathon Up Light, Marathon wood up light, wooden, timber, ore, timber and ore, timber & ore, Light with wooden top, light with wood top, light with wooden fixture, light with wood fixture, light with wood top, light with wooden top, light with wood, light with wood socket, light with wooden socket, light with wooden sockets, light with wood sockets, wood socket, wooden sockets, wood socket light, wooden socket lights, Pendant with wooden top, pendant with wood top, Pendant with wooden fixture, pendant with wood fixture, pendant with wood top, pendant with wooden top, pendant with wood, pendant with wood socket, pendant with wooden socket, pendant with wooden sockets, pendant with wood sockets, Pendants with wooden top, pendants with wood top, Pendants with wooden fixture, pendants with wood fixture, pendants with wood top, pendants with wooden top, pendants with wood, pendants with wood socket, pendants with wooden socket, pendants with wooden sockets, pendants with wood sockets, BLE-C-WYDM12, BLE-C-WYDM14, BLE-C-WYDM16, marathon series, marathon collection, the marathon series, the marathon collection, marathon led series, marathon led collection, the marathon led series, the marathon led collection, SPS-0477, SPS0477, SPS 0477, white pendant, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wooden hanging light, wooden hanging lights, wooden hanging lighting, wood hanging light, wood hanging lights, wood hanging lighting, 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, wooden top barn light, wood lights, wood and metal lights, timber ore, led marathon, led wood marathon, marathon wood led, marathon with diffuser, marathon diffuser, marathon wood diffuser, led timber and ore, timber and ore led, led wooden, led wood, timber and ore led, timber ore led, led timber and ore, led timber ore, wood accent light, wood accent pendant,