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

Query time 0.00033

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

Result

product_id meta_keywords meta_description search_words promo_text
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,
64691 large farm light, heavy duty gooseneck light, large scale lighting fixture, extra large barn light, extra large lighting, RLM gooseneck light Featuring the factory light look of the Original™ Gooseneck Light with two additional sizes, this over-sized wall light reflects liberal amounts of light. The Original™ Warehouse Gooseneck Light 24" & 28", large warehouse, large warehouse shade, large barn light, BLE-G-WHS24-PC, BLE-G-WHS28-PC, 24” warehouse light, 28” warehouse shade, twenty four inch warehouse shade, twenty eight inch warehouse shade, oversized warehouse shade, The Original Warehouse Gooseneck Light 24" & 28", oversized gooseneck lighting, oversized gooseneck, oversized original, oversized Original™, large Original™, The Original™ gooseneck, The Original™ lighting, outdoor The Original™, exterior The Original™, outdoor Original™, indoor Original™, The Original™ wall light, The Original™ wall mount, wall mount gooseneck, wall mount lighting, original gooseneck, 24 gooseneck, 28 gooseneck, 24 28 gooseneck, new listing, new rlm, original 24, original 24", original 28, original 28", original gooseneck, original goosenecks, original™ gooseneck, original™ goosenecks, gooseneck original, gooseneck original™, BLE-G-WHS24, BLE-G-WHS28, outdoor extra large gooseneck, 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, Warehouse Gooseneck Lights, Warehouse Gooseneck Light, Warehouse Gooseneck Lighting, Ware house Gooseneck Lights, Ware house Gooseneck Light, Ware house Gooseneck Lighting, Warehouse Goose neck Lights, Warehouse Goose neck Light, Warehouse Goose neck Lighting, Ware house Goose neck Lights, Ware house Goose neck Light, Ware house Goose neck Lighting, Warehouse Gooseneck, Warehouse Goosenecks, Ware house Gooseneck, Ware house Goosenecks, Ware house Goose neck, Ware house Goose necks, Gooseneck Warehouse Lights, Gooseneck Warehouse Light, Gooseneck Warehouse Lighting, Gooseneck Ware house Lights, Gooseneck Ware house Light, Gooseneck Ware house Lighting, Goose neck Warehouse Lights, Goose neck Warehouse Light, Goose neck Warehouse Lighting, Goose neck Ware house Lights, Goose neck Ware house Light, Goose neck Ware house Lighting, Gooseneck Warehouse, Gooseneck Ware house, Goose neck Warehouse, Goose neck Ware house, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, 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, bleg, oversized shades, original gooseneck 24, 24" shade, 28" shade, 24 inch gooseneck, 28 inch gooseneck, H-151124, classic warehouse shade gooseneck 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,
65495 With a 24” or 28” shade, this chain mount pendant helps homes and businesses take on a heightened sense of character. Handcrafted, fully customizable, and American made! BLE-CN, 24” Original Chain, 24 original chain, 24” Original Chain Mount, 24” Original Chain Mount Pendant, 24” Original Chain Pendant, 24” Original Chain Mount Light, 24” Original Chain Mount Pendant Light, 24 Original Chain, 24 Original Chain Mount, 24 Original Chain Mount Pendant, 24 Original Chain Pendant, 24 Original Chain Mount Light, 24 Original Chain Mount Pendant Light, 24” Original Chain Hung, 24” Original Chain Hung Pendant, 24” Original Chain Hung Light, 24” Original Chain Hung Pendant Light, 24 Original Chain Hung, 24 Original Chain Hung Pendant, 24 Original Chain Hung Light, 24 Original Chain Hung Pendant Light, 24” Original™ Chain, 24 original™ chain, 24” Original™ Chain Mount, 24” Original™ Chain Mount Pendant, 24” Original™ Chain Pendant, 24” Original™ Chain Mount Light, 24” Original™ Chain Mount Pendant Light, 24 Original™ Chain, 24 Original™ Chain Mount, 24 Original™ Chain Mount Pendant, 24 Original™ Chain Pendant, 24 Original™ Chain Mount Light, 24 Original™ Chain Mount Pendant Light, 24” Original™ Chain Hung, 24” Original™ Chain Hung Pendant, 24” Original™ Chain Hung Light, 24” Original™ Chain Hung Pendant Light, 24 Original™ Chain Hung, 24 Original™ Chain Hung Pendant, 24 Original™ Chain Hung Light, 24 Original™ Chain Hung Pendant Light, 28” Original Chain, 28 original chain, 28” Original Chain Mount, 28” Original Chain Mount Pendant, 28” Original Chain Pendant, 28” Original Chain Mount Light, 28” Original Chain Mount Pendant Light, 28 Original Chain, 28 Original Chain Mount, 28 Original Chain Mount Pendant, 28 Original Chain Pendant, 28 Original Chain Mount Light, 28 Original Chain Mount Pendant Light, 28” Original Chain Hung, 28” Original Chain Hung Pendant, 28” Original Chain Hung Light, 28” Original Chain Hung Pendant Light, 28 Original Chain Hung, 28 Original Chain Hung Pendant, 28 Original Chain Hung Light, 28 Original Chain Hung Pendant Light, 28” Original™ Chain, 28 original™ chain, 28” Original™ Chain Mount, 28” Original™ Chain Mount Pendant, 28” Original™ Chain Pendant, 28” Original™ Chain Mount Light, 28” Original™ Chain Mount Pendant Light, 28 Original™ Chain, 28 Original™ Chain Mount, 28 Original™ Chain Mount Pendant, 28 Original™ Chain Pendant, 28 Original™ Chain Mount Light, 28 Original™ Chain Mount Pendant Light, 28” Original™ Chain Hung, 28” Original™ Chain Hung Pendant, 28” Original™ Chain Hung Light, 28” Original™ Chain Hung Pendant Light, 28 Original™ Chain Hung, 28 Original™ Chain Hung Pendant, 28 Original™ Chain Hung Light, 28 Original™ Chain Hung Pendant Light, twenty four, twenty eight, BLE-CN-WHS24, BLE-CN-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, 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, 28" shade,
65529
65681 compact florescent studio lighting, exposed cable pendant light, airline cable pendant, swag pendant light, adjustable cable pendant light, industrial cord and wire pendant light, This Sky Chief pendant is a stylish twist on pendant lighting with its exposed wire and cord. Customize your swag light with a variety of finishes. sky chief lighting, sky chief lighting, warehouse lighting, BLE-C-STU-WHS12, BLE-C-STU-WHS14, BLE-C-STU-WHS16, BLE-C-STU-WHS18, BLE-C-STU-WHS20, skychief studio, sky chief, studio light, studio pendant, sky chief studio pendant, Studio light, studio cable, studio cable light, studio cable pendant, studio cable lights, studio pendant cable, studio, cable, The Original™ Studio Light, The Original™ Studio Pendant, Original™ Studio Light, Original™ Studio Pendant, The Original Studio Light, The Original Studio Pendant, Original Studio Light, Original Studio Pendant, Original studio, original, original studio cable, original cable, studio cable original, studio light original, BLE-C-STU-WHS12, BLE-C-STU-WHS14, BLE-C-STU-WHS16, BLE-C-STU-WHS18, BLE-C-STU-WHS20, BLE-C-STU-WHS24, BLE-C-STU-WHS28, SPS-0550, SPS0550, SPS 0550, 24" shade, 28" shade, jadeite, jadite, jadeite light, jadite light,