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 (65034, 64967, 64917, 64730) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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 (65034,64967,64917,64730) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64730 Ashland, Stem Mount, Ashland Stem Mount, Ashland Pendant, Warehouse Shade, BLE-S-WHA-PC, BLE-S-WHA12-PC, BLE-S-WHA14-PC, BLE-S-WHA16-PC, new avalon, new listing, new rlm, Ashland, Stem Mount, Ashland Stem Mount, Ashland Pendant, Warehouse Shade, BLE-S-WHA-PC, BLE-S-WHA12-PC, BLE-S-WHA14-PC, BLE-S-WHA16-PC, ashland stem, ashland pendant, BLE-S-WHA8, BLE-S-WHA10, BLE-S-WHA12, BLE-S-WHA14, BLE-S-WHA16, Outdoor farm light, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, SPS-0108, SPS0108, SPS 0108, avalon collection, avalon series, the avalon collection, the avalon series, Pendent outdoor, pendant outdoor, Pendant light outdoor, pendant shade, pendant wet, pendent wet, pendant hanging lights, outdoor hanging pendant, outdoor hanging light, Outdoor ceiling mount, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, stems, Stem pendant lights, stem light mount, stem light mounts, stem, 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, exterior ceiling mount light, exterior ceiling mount lights, exterior ceiling mount lighting, exterior ceiling mount light fixture, exterior ceiling mount light fixtures, exterior ceiling mount lighting fixture, exterior ceiling mount lighting fixtures, exterior ceiling mount, exterior ceiling mounts, exterior ceiling mount fixture, exterior ceiling mount fixtures, Ceiling mount exterior light, Ceiling mount exterior lights, Ceiling mount exterior lighting, Ceiling mount exterior light fixture, Ceiling mount exterior light fixtures, Ceiling mount exterior lighting fixture, Ceiling mount exterior lighting fixtures, 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, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents, Avalon series, jadeite, jadite, jadeite light, jadite light,
64917 led pendant lighting, led barn lighting, industrial pendant lighting led, led ceiling light, warehouse lighting, led pendant, led fixture Bright, white, LED light! Light up your ceiling with classic RLM style with the Original™ LED light and its custom finishes and accessories. The Original Stem Mount LED Pendant, BLE-S-WHS-PC-LED, Original, Original stem mount, original pendant, LED original, LED pendant, LED ceiling light, LED stem mount, LED, BLE-S-WHS12-PC-LED, BLE-S-WHS14-PC-LED, BLE-S-WHS16-PC-LED, BLE-S-WHS18-PC-LED, BLE-S-WHS20-PC-LED, The Original™, The Original™ warehouse shade, The Original™ led warehouse lighting, The Original led lighting, ceiling pendant, ceiling pendant lighting, led ceiling pendant, ceiling lighting, led ceiling lighting, stem mount lighting, led stem mount lighting, stem mount pendant, stem mount led, ceiling light, ceiling led, industrial lighting, industrial led lighting, industrial ceiling light, industrial led ceiling light, Original LED, Original LED stem, Original LED pendant, Original LED stem mount, Original, Original LED stem pendant, Original LED pendants, Sky Chief, Sky Chief LED, Sky Chief LED stem, Sky Chief LED pendant, Sky Chief LED stem mount, LED stem mount, BLE-S-WHS16, BLE-S-WHS18, BLE-S-WHS20, BLE-S-WHS24, BLE-S-WHS28, BLE-S-WHS12, BLE-S-WHS14, BLE-S-WHS16, BLE-S-WHS18, BLE-S-WHS20, BLE-S-WHS24, BLE-S-WHS28, original led warehouse, original led ware house, original led warehouse shade, original led ware house shade, original led warehouse shades, original led ware house shades, 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, Original led warehouse pendant, Original led warehouse pendants, 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, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Original led warehouse light, 24" shade, 28" shade, H-15112, H-15114, H-15116, H-15118, H-15120, classic warehouse shade stem mount pendant rlm, classic warehouse shade,
64967 Reinvigorate any decor while decreasing energy consumption with the Bomber LED Stem Mount Pendant! Handcrafted, customizable, and American made lighting! ceiling light, ceiling lighting, ceiling pendant, pendant lighting, pendant light, LED pendant light, LED ceiling pendant, LED warehouse shade, warehouse LED shade light, RLM warehouse shade, warehouse ceiling light, warehouse pendant, LED warehouse pendant, ceiling lighting, stem mount pendant, stem mount ceiling light, stem mount, stem mount industrial light, industrial LED lighting, bomber, bomber led, bomber led stem, bomber stem, bomber stem led, bomber stem pendant, led bomber, led bomber stem, bomber stem mount, bomber stem mount led, led bomber, The Old Dixie Stem Mount LED Pendant, Barn Light Warehouse Pendant, stem mounted, Old dixie, stem mount, Old dixie stem mount, ceiling light, BLE-S-WHB-PC-LED, LED, LED light, LED pendant, LED ceiling light, Old Dixie LED, BLE-S-WHB11-PC-LED, BLE-S-WHB13-PC-LED, BLE-S-WHB15-PC-LED, BLE-S-WHB17-PC-LED, old Dixie shade, old Dixie led shade, old Dixie barn light, old Dixie stem mount, old Dixie led stem mount, old Dixie mount, led old Dixie, barn lighting, led barn lighting, warehouse lighting, warehouse led lighting, stem mount lighting, led stem mount lighting, BLE-S-WHB11, BLE-S-WHB13, BLE-S-WHB15, BLE-S-WHB17, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, bomber led series, bomber led collection, SPS-0452, SPS0452, SPS 0452, 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, H-15111, H-15113, H-15115, H-15117, curved warehouse shade, curved warehouse shade stem mount,
65034 Cutting-edge LED lights and nautical industrial guards meet in the Avalon! Perfect for commercial lighting and residential spaces, revamp any space with LED pendant lighting! rustic ceiling pendant, rustic ceiling pendants, rustic ceiling light, rustic ceiling lights, rustic ceiling lighting, rustic led light, rustic led lights, rustic led lighting, led rustic light, led rustic lights, led rustic lighting, cast guard, cast guard and glass, cast guard & glass, cast guard and glass pendant, cast guard and glass pendants, cast guard & glass pendant, cast guard & glass pendants, cast guard and glass pendant light, cast guard & glass pendant light, cast guard and glass pendant lights, cast guard & glass pendant lights, cast guard and glass pendant lighting, cast guard & glass pendant lighting, led cast and guard, led cast & guard, Benjamin® Avalon Rustic LED Stem Mount Pendant, BLE-S-WHA-CGG-LED, Benjamin Avalon Rustic LED Stem Mount Pendant, Avalon Rustic LED Stem Mount Pendant, Avalon Rustic LED Stem Mount Pendants, Avalon Rustic Stem Mount Pendant, Avalon Rustic Stem Mount Pendants, Avalon Rustic Stem Mount Pendant light, Avalon Rustic Stem Mount Pendant lights. Avalon Rustic Stem Mount Pendant lighting, Avalon LED Stem Mount Pendant, Avalon LED Stem Mount Pendants, Avalon LED Stem Mount Pendant light, Avalon LED Stem Mount Pendant lights, Avalon LED Stem Mount Pendant lighting, Avalon pendant light, Avalon pendant lights, Avalon pendant lighting, nautical ceiling pendant, nautical ceiling pendants, nautical ceiling light, nautical ceiling lights, nautical ceiling lighting, nautical led light, nautical led lights, nautical led lighting, led nautical light, led nautical lights, Benjamin® Avalon Nautical LED Stem Mount Pendant, BLE-S-WHA-CGG-LED, Benjamin Avalon Nautical LED Stem Mount Pendant, Avalon Nautical LED Stem Mount Pendant, Avalon Nautical LED Stem Mount Pendants, Avalon Nautical Stem Mount Pendant, Avalon Nautical Stem Mount Pendants, Avalon Nautical Stem Mount Pendant light, Avalon Nautical Stem Mount Pendant lights. Avalon Nautical Stem Mount Pendant lighting, The Ashland Rustic LED Stem Mount Pendant, Ashland Rustic LED Stem Mount Pendant, The Ashland LED Stem Mount Pendant, The Ashland Rustic Stem Mount Pendant, Ashland LED Stem Mount Pendant, Ashland Rustic Stem Mount Pendant, Ashland Stem mount pendant, ashland stem mount, ashland pendant, ashland, ashland pendant light, ashland pendant lights, ashland pendant lighting, ashland ceiling light, ashland ceiling lights, ashland ceiling lighting, pendant light, pendant lights, pendant lighting, ceiling light, ceiling lights, ceiling lighting, ashland, rustic led, rustic led light, rustic led lights, rustic led lighting, rustic pendant, rustic pendant lighting, rustic lights, rustic pendant lights, rustic pendant light, stem mount, stem mount light, stem mount lights, stem mount lighting, led stem mount light, led stem mount lights, led stem mount lighting, rustic stem mount, rustic stem mount light, rustic stem mount lights, rustic stem mount lighting, BLE-S-WHA-PC-CGG-LED, The Ashland Nautical LED Stem Mount Pendant, Ashland Nautical LED Stem Mount Pendant, The Ashland LED Stem Mount Pendant, The Ashland Nautical Stem Mount Pendant, Ashland LED Stem Mount Pendant, Ashland Nautical Stem Mount Pendant, nautical led, nautical led light, nautical led lights, nautical led lighting, nautical pendant, nautical pendant lighting, nautical lights, nautical pendant lights, nautical pendant light, stem mount, stem mount light, stem mount lights, stem mount lighting, led stem mount light, led stem mount lights, led stem mount lighting, nautical stem mount, nautical stem mount light, nautical stem mount lights, nautical stem mount lighting, BLE-S-WHA12, BLE-S-WHA14, BLE-S-WHA16, Avalon LED collection, avalon LED series, the avalon led collection, the avalon led series, SPS-0457, SPS0457, SPS 0457, SPS-0520, SPS 0520, SPS0520, Avalon nautical led collection, Avalon nautical led series, The Avalon nautical led collection, the Avalon nautical led 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,