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 (64684, 62057, 62060, 62204) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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 (64684,62057,62060,62204) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
62057 vintage deep bowl pendant, deep bowl factory light, industrial deep bowl reflector pendant, vented deep-bowl reflector For a unique twist on classic barn lighting, hang the Vented Wesco pendant! This highly customizable deep bowl pendant showcases both directional and up lighting. vented, vented shade, vintage warehouse, BLE-C-VDBW-PC, Wesco Vented Cord Hung Pendant Light, wesco, deep bowl, vinted, ventedd deep bowl, cord hung, BLE-C-VDBW10-PC, BLE-C-VDBW12-PC, BLE-C-VDBW14-PC, BLE-C-VDBW16-PC, vintage ceiling light, vintage style lighting, vintage inspired lighting, ceiling light, ceiling lighting, vented ceiling light, vented pendant light, Wesco vented light, Wesco ceiling light, vented shade, vented shade light, vented warehouse shade, warehouse shade, deep bowl warehouse shade, ceiling light, ceiling lighting, porch light, kitchen light, vented wilcox, vented wilcox cord, Wilcox Vented Pendant Light, Wilcox Vented Pendant, wilcox vinted, vinted, vint, vent wilcox, vent wilcox pendant, vented pendant, wilcox vented pendant, Wilcox uplight, wilcox uplights, BLE-C-VDBW16, BLE-C-VDBW20, BLE-C-VDBW10, BLE-C-VDBW12, BLE-C-VDBW14, SPS-0168, SPS 0168, SPS0168, SPS-0158, SPS 0158, SPS0158, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, wilcox vented collection, wilcox vented series, the wilcox vented collection, the wilcox vented series, Wilcox vented deep, natural metals, natural metal, 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, wilcox bowl, slotted, slotted light, H-16510, H-16512, H-16514, H-16516, H-16518, H-16524, vented deep bowl shade, vented deep bowl shade cord-hung pendant,
62060 For custom commercial and residential up lighting, try our vented Astro light! This shallow bowl shade has small vents for added light and industrial edge. vented, vented shade, vintage warehouse, Astro Shallow Bowl Vented Cord Hung Pendant, astro, BLE-C-VSBA-PC, BLE-C-VSBA12-PC, BLE-C-VSBA14-PC, BLE-C-VSBA16-PC, Shallow bowl pendant, cord hung pendant, warehouse shade, vented warehouse shade, vented lighting, astro lighting, astro light, astro shade light, astro ceiling light, vintage inspired lighting, interior lighting, indoor lighting, farmhouse lighting, farmhouse light, astro vented, vented astro, Astro Vented, Vented Astro, BLE-C-VSBA12, BLE-C-VSBA14, BLE-C-VSBA16, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, aero vented series, aero vented collection, SPS-0169, SPS0169, SPS 0169, 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, slotted, slotted light, bowl shallow,
62204 chain hung factory light, vintage industrial chain hung light, factory shade lights, chain hung barn pendants Styled after salvaged factory lights, our Original™ barn shade features custom vents for up lighting and an industrial chain mount. Enjoy this vintage industrial light with Free Shipping! original, vented original, original vented chain, vented original chain, BLE-C-VWHS-PC-CN36, Original™ Vented Chain Hung Pendant, vented chain hung, chain hung vented, BLE-CN-VWHS12, BLE-CN-VWHS14, BLE-CN-VWHS16, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, SPS-0020, SPS 0020, SPS0020, original vented series, original vented collection, original™ vented series, originaltm vented series, original vented collection, original™ vented collection, originaltm vented collection, the original vented series, the original vented collection, the original™ vented series, the originaltm vented series, the original vented collection, the original™ vented collection, the originaltm vented collection, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, SPS-0020, SPS 0020, SPS0020, original vented series, original vented collection, original™ vented series, originaltm vented series, original vented collection, original™ vented collection, originaltm vented collection, the original vented series, the original vented collection, the original™ vented series, the originaltm vented series, the original vented collection, the original™ vented collection, the originaltm vented collection, magenta, slotted, slotted light, H-15612, H-15614, H15616, vented warehouse shade,
64684 warehouse style pendant, barn light pendant, original barn lighting, cord hung warehouse shade, farm style ceiling light, industrial farmhouse pendant, original pendant light fixture Inspired by vintage gas station lights and traditional RLM shades, we've crafted the essential warehouse pendant. Customize with unique finishes and cord options. Barn Light Warehouse Pendant, Cord Hung, The Original, Original Pendant, BLE-C-WHS-PC, BLE-C-WHS12-PC, BLE-C-WHS14-PC, BLE-C-WHS16-PC, BLE-C-WHS18-PC, BLE-C-WHS20-PC, Original, The Original™ Warehouse Pendant, The Original™ Warehouse Pendants, Original™ Warehouse Pendant, Original™ Warehouse Pendants, The Original™ Warehouse Pendant Light, The Original™ Warehouse Pendant Lights, The Original™ Warehouse Pendant Lighting, The Original Warehouse Pendant Light, The Original Warehouse Pendant Lights, The Original Warehouse Pendant Lighting, Original™ Warehouse Pendant Light, Original™ Warehouse Pendant Lights, Original™ Warehouse Pendant Lighting, original cord, original cord hung, original pendant, original cord pendant, new listing, sky chief lighting, warehouse lighting, pendant lighting, pendant lights, sky chief, cord hung lights, BLE-C-WHS12, BLE-C-WHS14, BLE-C-WHS16, BLE-C-WHS18, BLE-C-WHS20, ivanhoe sky chief, ivanhoe skychief, skychief, warehouse pendant, oringal cord, original cord light, original cord lights, original cord lighting, sky chief cord, new rlm, new cord, BLE-C-WHS16, BLE-C-WHS18, BLE-C-WHS20, BLE-C-WHS24, BLE-C-WHS28, BLE-C-WHS12, BLE-C-WHS14, original warehouse, original warehouse shade, original warehouse shades, original ware house, original ware house shade, original ware house shades, the original barn light, whs, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm 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, The original warehouse pendent light, original warehouse pendent light, The original warehouse pendent, original warehouse pendent, Warehouse pendent, Warehouse pendents, Ware house pendent, Ware house pendents, Warehouse pendent light, Warehouse pendent lights, Warehouse pendent lighting, Ware house pendent light, Ware house pendent lights, Ware house pendent lighting, Warehouse ceiling pendent, Warehouse ceiling pendents, Ware house ceiling pendent, Ware house ceiling pendents, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, Warehouse pendent, Warehouse pendent light, ble c whs, 24" shade, 28" shade, jadeite, jadite, jadeite light, jadite light, H-15112, H-15114, H-15116, H-15118, H-15120, classic warehouse shade cord-hung pendant rlm, classic warehouse shade,