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 (61399, 64690, 64692) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (61399,64690,64692) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61399 outdoor led lighting, large led light, led gooseneck light, oversized led light The Original® Gooseneck Light now comes in two larger sizes with energy saving LED technology. This new LED gooseneck light reflects bright, white LED light! Warehouse, warehouse shade, gooseneck light, H-15116G, The Original, Original, BLE-G-WHS24-PC-LED, Original LED, LED gooseneck, LED light, commercial lighting, BLE-G-WHS28-PC-LED, original 24, original 24", original 28, original 28", Original LED gooseneck, The Original™ LED Warehouse Gooseneck Light - 24" & 28", Original™ LED Warehouse Gooseneck Light - 24" & 28", The Original LED Warehouse Gooseneck Light - 24" & 28", The Original LED Warehouse Gooseneck Light - 24" & 28", original gooseneck, original goosenecks, original™ gooseneck, original™ goosenecks, original led gooseneck, original led goosenecks, led original gooseneck, led original goosenecks, gooseneck original, gooseneck original led, led gooseneck original, gooseneck led original, BLE-G-WHS24, BLE-G-WHS28, 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-0448, SPS0448, SPS 0448, original led series, original™ led series, originaltm led series, original led collection, original™ led collection, originaltm led collection, the original led series, the original™ led series, the originaltm led series, the original led collection, the original™ led collection, the originaltm led collection, large shade, large shades, extra large shade, extra large shades, large light shade, large light shades, large light fixture, large light fixtures, large lighting fixture, large lighting fixtures, bleg, 24" gooseneck, 28" gooseneck, original gooseneck 24, 24" shade, 28" shade, 24 inch gooseneck, 28 inch gooseneck, H-15120, classic warehouse shade gooseneck rlm, classic warehouse shade,
64690 extra large light, heavy duty pendant, large barn light, large pendant shade, extra large rlm light, loft lighting, lighting for high ceilings, oversized light fixture, factory ceiling light, barn light pendant, original pendant light fixture The classic factory light, the Original™ Warehouse Pendant is now available in two larger sizes. This over-sized, cord hung shade is ideal for sloped ceilings. The Original Warehouse Pendant 24" & 28", large Barn Light Warehouse Pendant, Cord Hung, The Original, BLE-S-WHS24-PC, BLE-C-WHS28-PC, The Original™ Warehouse Pendant 24" & 28", The Original™, The Original™ Warehouse Pendant, large pendant lighting, oversized pendant light, large warehouse lighting, large warehouse shade, 24” shade, 24” RLM shade, 24” shades, 24” warehouse shade, 24” warehouse shades, 24” ware house shade, 24” ware house shades, 24 inch shade, 24 inch shades, 24 warehouse shade, 24 inch warehouse shades, 24 ware house shade, 24 inch ware house shades, 24 inch RLM shade, 24 inch RLM shades, warehouse shade, warehouse lighting, industrial lighting, industrial lights, exterior lighting, outdoor lighting, new listing, new rlm, original 24, original 24", original 28, original 28", BLE-C-WHS24, BLE-C-WHS28, 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, large shade, large shades, extra large shade, extra large shades, large light shade, large light shades, large light fixture, large light fixtures, large lighting fixture, large lighting fixtures, 24” shade, 24” RLM shade, 24” shades, 24” warehouse shade, 24” warehouse shades, 24” ware house shade, 24” ware house shades, 24 inch shade, 24 inch shades, 24 warehouse shade, 24 inch warehouse shades, 24 ware house shade, 24 inch ware house shades, 24 inch RLM shade, 24 inch RLM shades, 24 inch warehouse shade, 24 inch ware house shade, Warehouse pendent, Warehouse pendent light, oversized shades, 24" shade, 28" shade, 24in size pendant, 24 inch pendant, 28 inch pendant, H-15124, classic warehouse shade cord-hung pendant rlm, classic warehouse shade,
64692 extra large light, heavy duty pendant, large barn light, large pendant shade, extra large RLM light, huge barn light stem mount, original pendant light fixture Original™ stem mount pendant is now available in two larger sizes. This over-sized warehouse shade is ideal for lighting tall commercial facades and barns. The Original™ Stem Mount Pendant 24" & 28", BLE-S-WHS24-PC, original, warehouse shade, large barn light, stem mount pendant, BLE-S-WHS28-PC, new listing, new rlm, original 24, original 24", original 28, original 28", 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, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, large shade, large shades, extra large shade, extra large shades, large light shade, large light shades, large light fixture, large light fixtures, large lighting fixture, large lighting fixtures, 24” shade, 24” RLM shade, 24” shades, 24” warehouse shade, 24” warehouse shades, 24” ware house shade, 24” ware house shades, 24 inch shade, 24 inch shades, 24 warehouse shade, 24 inch warehouse shades, 24 ware house shade, 24 inch ware house shades, 24 inch RLM shade, 24 inch RLM shades, 24 inch warehouse shade, 24 inch ware house shade, oversized shades, 24" shade, 28" shade, 24in size pendant, H-15124, classic warehouse shade stem mount pendant rlm, classic warehouse shade,