Sandbox

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 (64692, 64682, 61401, 61400) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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 (64692,64682,61401,61400) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61400	large cord hung led light, large led light, cord hung led barn light, led pendant fixture, extra large led pendant lighting, large led ceiling light	We've updated the Original™ pendant light fixture: Now you can get the classic barn light in extra large sizes with LED technology. Energy efficient lighting!	The Original™ Warehouse LED Pendant 24" & 28", large shade, BLE-C-WHS24-PC-LED, LED pendant, cord hung LED light, large LED, BLE-C-WHS28-PC-LED, oversized pendant lighting, oversized warehouse shade, oversized lighting, oversized shade, large shade lighting, large warehouse lighting, oversized warehouse led, oversized led warehouse shade, warehouse lighting, warehouse ceiling light, led warehouse ceiling light, cord hung led lighting, industrial lighting, led industrial lighting, industrial pendant lighting, industrial pendant, led industrial pendant, The Original™ Warehouse LED Pendant, The Original Warehouse LED Pendant, the original pendant, the original led pendant, cord hung warehouse pendant, led cord hung, original 24, original 28, original 24", 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, 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, The Original™ Integrated LED Series, The Original™ Integrated LED Collection, Original™ Integrated LED Series, Original™ Integrated LED Collection, The Original Integrated LED Series, The Original Integrated LED Collection, Original Integrated LED Series, Original Integrated LED Collection, The Original™ Integrated LED Series, The Original™ Integrated LED Collection, Original™ Integrated LED Series, Original™ Integrated LED Collection, The Originaltm Integrated LED Series, The Originaltm Integrated LED Collection, Originaltm Integrated LED Series, Originaltm Integrated LED Collection, SPS-0448, SPS 0448, SPS0448, 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, oversized shades, 24" shade, 28" shade, 24in size pendant, H-15124, classic warehouse shade cord-hung pendant rlm, classic warehouse shade,
61401	extra large led pendant, large led light, led barn pendant, large pendant lighting, large led pendant, led loft pendant, LED ceiling light, led barn light, original pendant light fixture	We've updated the Original™ Warehouse Pendant: Now you can get the classic stem mount in larger sizes with new LED technology. An efficient LED light!	The Original Stem Mount LED Pendant, BLE-S-WHS24-PC-LED, Original, Original stem mount, original pendant, LED original, LED pendant, LED ceiling light, LED stem mount, LED, BLE-S-WHS28-PC-LED, Stem mount LED light, stem mount lighting, stem mount ceiling light, stem mount led, ceiling light, stem ceiling light, led stem mount ceiling light, pendant lighting, led pendant lighting, led ceiling light, the original led, the original led pendant, ceiling lighting, led ceiling lighting, industrial led lighting, industrial lighting, industrial ceiling lights, led industrial ceiling lights, ceiling mount, ceiling mount lighting, led ceiling mount, pendant lighting, led pendant lighting, oversized lighting, large ceiling lights, extra large lighting, original 24, original 28, original 24", original 28", BLE-S-WHS24, BLE-S-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, 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, oversized shades, 24" shade, 28" shade, 24in size pendant, H-15124, classic warehouse shade stem mount pendant rlm, classic warehouse shade,
64682	exterior barn light, barn light, gooseneck wall light, galvanized warehouse shade, garage light, gooseneck barn light, title 24 compliant exterior lighting, dark sky lighting	Vintage craftsmanship meets modern styles in this handcrafted, American-made gooseneck barn light! Shop customizable gooseneck lighting and revamp any space!	The Original Warehouse Gooseneck Light, Warehouse, warehouse shade, barn light, gooseneck light, H-15116G, The Original, Original, BLE-G-WHS-PC, BLE-G-WHS12, BLE-G-WHS14, BLE-G-WHS16, BLE-G-WHS18, BLE-G-WHS20, gooseneck lighting, gooseneck lights, gooseneck wall light, warehouse gooseneck light, wall light, gooseneck warehouse shade, gooseneck warehouse wall light, original gooseneck, the original gooseneck, The Original™ Warehouse Gooseneck Light, The Original™ gooseneck, The Original™ gooseneck light, The Original™ wall light, The Original™ gooseneck lighting, original gooseneck lighting, the original gooseneck, gooseneck barn light, The Original™ gooseneck barn light, The Original™ barn light, original, original gooseneck, gooseneck original, 20" shade, outdoor light, wet location, new listing, the original light, original light, Sky chief, skychief, warhouse light, gooseneck, BLE-G-WHS, goodrich, goodrich sky chief, BLE-G-WHS, BLE-G-WHS12, BLE-G-WHS14, BLE-G-WHS16, BLE-G-WHS18, BLE-G-WHS20, sky chief gooseneck, skychief gooseneck, new rlm, new gooseneck, new original, BLE-G-WHS16-P/G64, Goodrich Gooseneck Light, Goodrich Gooseneck Lights, Goodrich Gooseneck Lighting, Goodrich Gooseneck Wall Light, Goodrich Gooseneck Wall Lights, Goodrich Gooseneck Wall Lighting, duncan, g64, g65, Goodrich, Skyway, gooseneck light, gooseneck lighting, 16" shade, BLE-WHS16-P/G1916, BLE-WHS16-P/G19, BLE-WHS18-P/G19, BLE-WHS20-P/G19, g19, large gooseneck light, big gooseneck light, Gooseneck Backing plate, Square gooseneck, outdoor goosneck, BLE-G-WHS-PC, BLE-G-WHS16-PC, BLE-G-WHS18-PC, BLE-G-WHS20-PC, outdoor gooseneck, warehouse lighting, warehouse gooseneck lighting, warehouse gooseneck wall light, outdoor gooseneck lighting, outdoor gooseneck light, outdoor warehouse gooseneck, rodeo, rodeo gooseneck, rodeo light, the original gooseneck light, original gooseneck light, BLE-G-WHS18, BLE-G-WHS20, BLE-G-WHS24, BLE-G-WHS28, original warehouse, original warehouse shade, original warehouse shades, original ware house, original ware house shade, original ware house shades, the original barn light, Outdoor farm light, Light with photocell, outdoor light light with photocell, goodyear, 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, outdoor gooseneck barn lights, outdoor gooseneck barn light, outdoor gooseneck barn lighting, Outdoor garage lights, Outdoor garage light, Outdoor garage lighting, Out door garage lights, Out door garage light, Out door garage lighting, Original gooseneck warehouse light, Original gooseneck warehouse lights, Original gooseneck warehouse lighting, Original gooseneck warehouse, 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 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, 24" gooseneck, 28" gooseneck, 24" shade, 28" shade, jadeite, jadite, jadeite light, jadite light, H-15112, H-15114, H-15116, H-15118, H-15120, 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,