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, 65067, 64985) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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,65067,64985) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
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,
64985 An elevated LED pendant light! The Conoco features integrated LEDs and influences from classic lighting. Customizable, handcrafted, and hyper-efficient! Circle B, Circle B pendant, Circle B cord hung, Circle B Ceiling Light, Flat Cone, Flat Cone Reflector, BLE-CU-FCC-PC, BLE-CU-FCC10-PC, BLE-CU-FCC12-PC, BLE-CU-FCC15-PC, Circle B LED Pendant Light, Circle B LED pendant, Circle B LED, LED Circle B, Industrial, Ivanhoe, Conoco, Ivanhoe Conoco, Draftsman, flat, shallow, flat pendant, shallow pendant, saucer, saucer pendant, BLE-C-FCC10, BLE-C-FCC12, BLE-C-FCC15, SPS-0462, SPS 0462, SPS0462, Conoco Integrated LED Series, The Conoco Integrated LED series, Conoco Integrated LED Collection, The Conoco Integrated LED Collection, Conoco LED Series, The Conoco LED series, Conoco LED Collection, The Conoco LED Collection, Ivanhoe warehouse led pendant, Ivanhoe warehouse led pendants,
65067 Inspired by vintage RLM lights, the Sinclair offers a shallow bowl shade and unique finish options. Complete any decor with an industrial pendant light! Ivanhoe, Sinclair, Ivanhoe Sinclair, shallow bowl, BLE-CU-SBS, BLE-CU-SBS10, BLE-CU-SBS12, BLE-CU-SBS14, BLE-CU-SBS16, flat, flat pendant, sinclair pendant, Skylark Industrial Pendant, BLE-CU-SBS-PC, socket rlm pendant, skylark, shallow bowl, cord hung, cord pendant, BLE-CU-SBS10-PC, BLE-CU-SBS12-PC, BLE-CU-SBS14-PC, BLE-CU-SBS16-PC, The Skylark Industrial Pendant, shallow bowl, Sinclair, ivanhoe sinclair, graniteware light, graniteware confetti lights, speckled finish, BLE-CU-SBS-GRANITE, BLE-CU-SBS10-GRANITE, BLE-CU-SBS12-GRANITE, BLE-CU-SBS14-GRANITE, BLE-CU-SBS16-GRANITE, spongeware, sponge ware, splatterware, splatter ware, splatter, sponge, granite, sinclair graniteware, granite light, spotted light, sinclair, the sinclair, BLE-CU-SBS10, BLE-CU-SBS12, BLE-CU-SBS14, BLE-CU-SBS16, Sinclaire, graphite, 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, ble-cc-sbs, jadeite, jadite, jadeite light, jadite light, bowl shallow, benjamin industrial,