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 (64742, 64944, 64769, 64771) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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 (64742,64944,64769,64771) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64742 deep cone pendant, vintage reflector light fixture, cord hung ceiling lamp, retro industrial ceiling light Inspired by flared vintage fixtures, this deep cone pendant features a timeless style and cord mounting! Customizable and handcrafted! Ivanhoe Sterling, Sterling cord hung, Sterling pendant, Ivanhoe Deep cone reflector, deep cone reflector pendant, cord hung deep cone reflector, BLE-C-DCS, BLE-C-DCS12, BLE-C-DCS14, BLE-C-DCS16, sterling cord, flat pendant, shallow pendant, deep pendant, flat, shallow, deep, reflector, new listing, new sterling, new rlm, BLE-C-DCS-PC, The Summit Pendant, The Summit Pendants, The Summit Pendant Light, The Summit Pendant Lights, The Summit Pendant Lighting, The Summit Ceiling Pendant, The Summit Ceiling Pendants, The Summit Ceiling Light, The Summit Ceiling Lights, The Summit Ceiling Lighting, Summit Pendant, Summit Pendants, Summit Pendant Light, Summit Pendant Lights, Summit Pendant Lighting, Summit Ceiling Pendant, Summit Ceiling Pendants, Summit Ceiling Light, Summit Ceiling Lights, Summit Ceiling Lighting, Summit, Sumit, BLE-C-DCS12, BLE-C-DCS14, BLE-C-DCS16, SPS-0157, SPS 0157, SPS0157, Sterling Series, the Sterling Series, Sterling Collection, The Sterling Collection, white 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, jadeite, jadite, jadeite light, jadite light,
64769 hanging barn lamp, single chain pendant light, swag light, industrial chain pendant light Add industrial flair to swag lighting with this Steber Chain Pendant! This single chain pendant light features a fully customizable shallow bowl shade. Steber Sinclair Draftsman Chain Hung Pendant Light, BLE-C-SBS-HEX-CN36, chain hung, chain hung barn light, steber, steber chain hung, chain hung sinclair, chain hung draftsman, sinclair chain hung, steber sinclair draftsman, sinclair draftsman, BLE-C-SBS10-HEX-CN36, BLE-C-SBS12-HEX-CN36, BLE-C-SBS14-HEX-CN36, BLE-C-SBS16-HEX-CN36, sinclair, sinclair chain, shallow chain pendant, shallow bowl chain, flat chain pendant, flat chain, new listing, new sinclair, new rlm, Skylark Shallow Bowl Chain Hung Pendant, BLE-C-SBS-HEX-PC-CN36, skylark chain, chain hung skylark, sinclair chain hung, chain hung sinclair, skylark, shallow bowl chain, chain hung shallow bowl, chain hung shallow bowl, BLE-C-SBS10-HEX-PC-CN36, BLE-C-SBS12-HEX-PC-CN36, BLE-C-SBS14-HEX-PC-CN36, BLE-C-SBS16-HEX-PC-CN36, BLE-CN-SBS10, BLE-CN-SBS12, BLE-CN-SBS14, BLE-CN-SBS16, Sinclaire, SPS-0155, SPS0155, SPS 0155, Sinclair Series, Sinclair Collection, The Sinclair Series, The Sinclair Collection, jadeite, jadite, jadeite light, jadite light, bowl shallow,
64771 barn light ceiling light, cord hung pendant, flared pendant light, vintage shallow bowl light, ceiling light fixture, gas station lighting, vintage gas station light fixture, cord hung light fixture The Skylark Pendant Light offers a wide span of light with its flared base and looks right at home in the kitchen, dining room, or office. Skylark, Skylark Cord Hung, Skylark pendant, shallow bowl pendant, shallow bowl cord hung, BLE-C-SBS-PC, BLE-C-SBS10-PC, BLE-C-SBS12-PC, BLE-C-SBS14-PC, BLE-C-SBS16-PC, new listing, new rlm, new skylark, 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, Industrial, 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, new sinclair, new rlm, new listing, BLE-C-SBS10, BLE-C-SBS12, BLE-C-SBS14, BLE-C-SBS16, Sinclaire, SPS-0155, SPS0155, SPS 0155, Sinclair Series, Sinclair Collection, The Sinclair Series, The Sinclair Collection, SPS-0373, SPS 0373, SPS0373, Sinclair Industrial Collection, Sinclair Industrial Series, 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, bowl shallow,
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,