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 (64848, 64944, 65095, 65099) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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 (64848,64944,65095,65099) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
64848	victorian industrial pendant light, flat cone pendant light, reeded pendant lighting, stem and loop light, brass ceiling lighting, vintage brass and shade pendant lamp, brass barn light	Vintage lovers celebrate this decorative brass or nickel loop-to-loop ceiling lamp! The Conoco's flat cone shade makes it the perfect filament bulb pendant.	Conoco, stem mount, loop, stem and loop, stem loop, ivanhoe, ivanhoe conoco, conoco stem & loop, conoco stem and loop, BLE-S-SL-FCC, BLE-S-SL-FCC10, BLE-S-SL-FCC12, BLE-S-SL-FCC14, flat pendant, shallow pendant, flat, shallow, conoco stem loop, new stem & loop, conoco stem, conoco, conoco stem loop, conoco stem & loop, conoco, conoco shade, conoco shades, BLE-S-SL-FCC10, BLE-S-SL-FCC12, BLE-S-SL-FCC15, SPS-0182, SPS 0182, SPS0182, jadeite, jadite, jadeite light, jadite light,
64944		Handcrafted and endlessly customizable, this wooden top pendant features a striking aesthetic and unique design! USA-Made and featuring real wood!	timber, ore, timber and ore, timber & ore, Conoco Draftsman Wooden Top Pendant, Conoco Draftsman Wooden Top Pendant light, Conoco Wooden Top Pendant, Conoco Wooden Top Pendant light, Conoco Draftsman Wooden Pendant, Conoco Draftsman Wooden Pendant light, Conoco Wooden Pendant, Conoco Wooden Pendant light, Conoco Draftsman Wood Top Pendant, Conoco Draftsman Wood Top Pendant light, Conoco Wood Top Pendant, Conoco Wood Top Pendant light, Conoco Draftsman Wood Pendant, Conoco Draftsman Wood Pendant light, Conoco Wood Pendant, Conoco Wood Pendant light, Draftsman Wooden Top Pendant, Draftsman Wooden Top Pendant light, Draftsman Wooden Pendant, Draftsman Wooden Pendant light, Draftsman Wood Top Pendant, Draftsman Wood Top Pendant light, Draftsman Wood Pendant, Draftsman Wood Pendant light, Conoco Draftsman Pendant, Conoco Draftsman Pendant Light, Conoco Pendant, Conoco Pendant Light, Conoco Draftsman Wooden Top Ceiling Pendant, Conoco Draftsman Wooden Ceiling Pendant, Conoco Draftsman Wood Top Ceiling Pendant, Conoco Draftsman Wood Ceiling Pendant, Conoco Draftsman Wooden Top Ceiling Pendants, Conoco Draftsman Wooden Ceiling Pendants, Conoco Draftsman Wood Top Ceiling Pendants, Conoco Draftsman Wood Ceiling Pendants, Conoco Wooden Top Ceiling Pendant, Conoco Wooden Ceiling Pendant, Conoco Wood Top Ceiling Pendant, Conoco Wood Ceiling Pendant, Conoco Wooden Top Ceiling Pendants, Conoco Wooden Ceiling Pendants, Conoco Wood Top Ceiling Pendants, Conoco Wood Ceiling Pendants, Draftsman Wooden Top Ceiling Pendant, Draftsman Wooden Ceiling Pendant, Draftsman Wood Top Ceiling Pendant, Draftsman Wood Ceiling Pendant, Draftsman Wooden Top Ceiling Pendants, Draftsman Wooden Ceiling Pendants, Draftsman Wood Top Ceiling Pendants, Draftsman Wood Ceiling Pendants, Conocco, Conoco Pendant, Conocco Pendant, Conoco Pendant, Conoco Pendants, Draftsman, Drafts man, Timber & Ore, Timber and ore, timber & ore collection, Timber and ore collection, timber & ore light, timber & ore fixture, timber and ore light, timber and ore fixture, Downtown, down town, minimalist, downtown minimalist, down town minimalist, multi-light minimalist pendant, multi light minimalist pendant, wood, wooden, wood pendant, wooden pendant, conoco, conoco shade, conoco shades, wood conoco, conoco wood, 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-WFCC10, BLE-C-WFCC12, BLE-C-WFCC15, SPS-0497, SPS 0497, SPS0497, 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, jadeite, jadite, jadeite light, jadite light,
65095		With its classic influences and timeless appeal, the Conoco brings a ground, industrial-inspired character to any location. Crafted by hand in the United States and fully customizable!	Circle B Spoke Top Pendant, BLE-CCS-FCC-PC, Circle B, spoke top, cord hung, cord pendant, BLE-CCS-FCC10-PC, BLE-CCS-FCC12-PC, BLE-CCS-FCC15-PC, Conoco Spoke Top Pendant Light, Conoco Spoke Top Pendant, Conoco Spoke Top, Conoco Spoke, Spoke top, spoke top conoco, spoke top light, conoco cord, cord conoco, BLE-CCS-FCC10, BLE-CCS-FCC12, BLE-CCS-FCC15, 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, jadeite, jadite, jadeite light, jadite light, spoke top pendant lights,
65099	flat cone pendant, early 20th century style lighting, filament bulb pendant lighting, flared shade pendant light	Hang this classic American-made Conoco pendant fixture in your nostalgic kitchen. Its flat, disk-like reflector shade is perfect for Edison Bulbs!	Industrial, Pendant, Ivanhoe, Conoco, Ivanhoe Conoco, BLE-CU-FCC10, BLE-CU-FCC12, BLE-CU-FCC15, saucer shade, flat cone shade, flat cone pendant, conoco pendant, conoco cord, flat pendant, shallow pendant, flat, shallow, conoco, conoco pendant, conoco pendant light, Conoco Industrial Pendant Light, Conoco Industrial Pendant, conoco, conoco shade, conoco shades, SPS-0375, SPS-0375, SPS-0375, jadeite, jadite, jadeite light, jadite light,