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 (64867, 61072, 64981, 64944) 
  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 (64867,61072,64981,64944) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61072 industrial chic lighting, american designer pendant light, shallow bowl industrial pendant, shallow warehouse shade pendant, factory light style pendant An artistic twist to classic gas station lights, the Marathon SoHo Pendant combines industrial edge with a shallow bowl shade for rustic loft lighting. The Houston Street Soho Pendant, BLE-C-SOH-HOU-PC, industrial pendant, industrial, heavy duty light, durable, factory light, factory lights, soho pendant, bulky light, garage lighting, shop lights, BLE-C-SOH-HOU12-PC, BLE-C-SOH-HOU14-PC, Marathon soho, Marathon Soho Pendant, Marathon Soho Pendant Light, Soho pendant light, soho, marathon, marathon light, soho pendant, BLE-C-SOH-HOU12, BLE-C-SOH-HOU14, SPS-0133, SPS0133, SPS 0133, marathon soho series, marathon soho collection, Houston series, houston collection, houston street soho series, houston street series, houston street collection, soho series, soho collection, Soho cord hung, Soho cord hung pendant, 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,
64867 Iconic lighting designs with wooden tops, this handcrafted pendant contributes character and illumination to any décor! Customize a unique look for your space! BLE-C-WYDM, 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, 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,
64981 LED pendant lighting with a classic style! This high-performance fixture produces light with unequaled efficiency! Check out the Marathon and revamp any decor! Maritime cord hung, Maritime Pendant, Maritime Ceiling light, cord hung Yard Light, Yard Light Pendant, The Maritime Warehouse Cord Hung Pendant, BLE-C-YDM-PC, BLE-C-YDM12-PC, BLE-C-YDM14-PC, BLE-C-YDM16-PC, maritime LED, Maritime LED pendant, LED maritime, Ivanhoe Marathon, Marathon pendant, marathon ceiling light, cord hung marathon, cord hung yard light, pendant lighting,vanhoe lighting, BLE-C-YDM, BLE-C-YDM12, BLE-C-YDM14, BLE-C-YDM16, marathon, marathon cord, shallow pendant, flat pendant, flat, shallow, marathon LED, led marathon, Marathon LED pendant, LED marathon pendant, marathon cord led, marathon LED cord, led cord pendant, cord led pendant, led pendant, marathon cord pendant, BLE-C-YDM12, BLE-C-YDM14, BLE-C-YDM16, marathon series, marathon collection, the marathon series, the marathon collection, SPS-0109, SPS 0109, SPS0109, marathon led series, marathon led collection, the marathon led series, the marathon led collection, SPS-0459, SPS 0459, SPS0459, Ivanhoe warehouse led pendant, Ivanhoe warehouse led pendants,