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 (65157, 65160, 65169, 65175) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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 (65157,65160,65169,65175) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65157 Versatile and stylish, the Aero shows off a look perfect for both contemporary designs and more traditional looks. Equipped with LED drivers! Customize the shade with the numerous finish options we offer! BLE-PMS-SBA, BLE-PMSD-SBA, BLE-PMS-SBA-BRS, BLE-PMSD-SBA-COP, BLE-PMS-SBA-COP, BLE-PMSD-SBA-BRS, Prospector Single Post Mount Exterior Light, Post mount, Prospector, Exterior light, Outdoor light, light pole, driveway light, walkway light, dock light, parking lot light, Warehouse, warehouse shade, barn light, Post Mount, Post Mount Warehouse Shade, P-3, pole mount, post mount, pole light, BLE-PMS-SBA14, BLE-PMS-SBA16, The Aero Single Post Mount Light, Aero Single Post Mount Light, The Aero Single Post Mount Lights, Aero Single Post Mount Lights, The Aero Single Post Mount Lighting, Aero Single Post Mount Lighting, The Aero Post Mount Light, Aero Post Mount Light, The Aero Post Mount Lights, Aero Post Mount Lights, The Aero Post Mount Lighting, Aero Post Mount Lighting, Copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, aero post, aero post mount, aero single post, single aero post, aero post mount light, single post mount aero, aero post light, new led post, Aero Nautical LED Single Post Mount Light, Aero Nautical LED Single Post Mount, Aero Nautical LED Post Mount Light, Aero Nautical LED Post Mount, Aero Nautical Single Post Mount Light, Aero Nautical Single Post Mount, Aero Nautical Post Mount Light, Aero Nautical Post Mount, Aero LED, Aero LED post Mount, LED aero, LED aero post mount, LED Nautical, Nautical LED, LED nautical post mount, nautical led post mount, aero nautical, nautical aero, BLE-PMS-SBA14, BLE-PMS-SBA16, BLE-PMSD-SBA14, BLE-PMSD-SBA16, aero led series, aero LED collection, SPS-0458, SPS0458, SPS 0458, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, SPS-0526, SPS0526, SPS 0526, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, post top fixture, post top fixtures, post top light fixture, LED post top, LED Post top light, LED Post Top Lights, LED Post top lighting, LED Post top fixture, LED post top fixtures, led post top light fixture, led post top light fixtures, rustic LED Post mount, rustic LED Post mounts, BLE PMS, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting,
65160 An iconic look, the Original™ embraces integrated LED technology and industrial styles. Hyper-efficient LEDs reduce energy demands while the customizable design stands out in any outdoor setting! BLE-PMS-WHS, Sky Chief Single Post Mount Exterior Light, Sky Chief, BLE-PM1-WHS, single post, post mount, exterior light, driveway light, hook post, post mount light, pole light, walkway light, park light, garden post light, post light, post light, pole mount, BLE-PMS-WHS14, BLE-PMS-WHS16, outdoor lighting, outdoor post light, copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, BLE-PMSD-WHS, BLE-PMS-WHS, BLE-PMS-WHS-BRS, BLE-PMSD-WHS-COP, BLE-PMS-WHS-COP, BLE-PMSD-WHS-BRS, skychief post, skychief, sky chief single post, sky chief post mount, skychief post mount, original post mount, original post, sky chief post light, The Original Single Post Mount Light, Original Single Post Mount Light, The Original Single Post Mount, Original Single Post Mount, Original Single Post Mount, Original Single Post Mount Light, Original Post Mount Light, Original Post Mount, Original Single Post Mount, Original, Original Post, The Original, original post, new led post, The Original™ Nautical LED Single Post Mount, The Original™ Nautical LED Single Post Mount Light, The Original Nautical LED Single Post Mount, The Original Nautical LED Single Post Mount Light, The Original Nautical LED Post Mount light, The Original Nautical LED Post Mount, The Original Nautical Single Post Mount Light, The Original Nautical Post Mount, original nautical, original led, led original, nautical original, cast guard led, led cast guard, cast guard led light, led cast guard light, led cast guard light, led guard, BLE-PMS-WHS14, BLE-PMS-WHS16, BLE-PMSD-WHS14, BLE-PMSD-WHS16, original+led+post+mount, 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, SPS-0505, SPS 0505, SPS0505, SPS-0269, SPS 0269, SPS0269, The Original Post Mount Collection, The Original™ Post Mount Collection, The Originaltm post mount collection, The Original Post Mount series, The Original™ Post Mount series, The Originaltm post mount series, Original Post Mount Collection, Original™ Post Mount Collection, Originaltm post mount collection, Original Post Mount series, Original™ Post Mount series, Originaltm post mount series, SPS-0589, SPS 0589, SPS0589, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, LED post top, original led post mount, rustic LED Post mount, rustic LED Post mounts, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, LED pier mount, LED pier mounts, LED pier mount light, LED pier mount lights, LED pier mount lighting, LED pier mount fixture, LED pier mount fixtures, LED pier mount light fixture, LED pier mount light fixtures, LED pier mount lighting fixture, LED pier mount lighting fixtures, pier mount LED, pier mount LED light, pier mount LED lights, pier mount LED lighting, pier mount LED fixture, pier mount LED fixtures, pier mount LED light fixture, pier mount LED light fixtures, pier mount LED lighting fixture, pier mount LED lighting fixtures, BLE PMS, lamp post lights, original nautical led, barn lights on pole, original led single, outdoor pole lights, light post lighting, H-15114, H-15116, classic warehouse shade post light rlm, classic warehouse shade,
65169 Stunning deep bowl shades are fitted to a pole mounting, creating a dynamic focal point for residential and commercial settings. Fitted with efficient LED modules! BLE-PMS-DBW, BLE-PMSD-DBW, Wilcox Single Post Mount Decorative Exterior Light, BLE-PMSD-DBW, Wilcox post mount, wilcox light pole, wilcox, single post, post mount, decorative, exterior light, decorative light pole, light pole, deep bowl, bowl shade, sidewalk light, commercial lighting, pole light, post light, Wilcox Single Post Mount Exterior Light, BLE-PMS-DBW, wilcox, single post, post mount, exterior light, lampost, post mount, deep bowl, bowl light, porch light, driveway lighting, street lamp post, lamp post, direct lighting, BLE-PMS-DBW14, BLE-PMS-DBW16, The Wilcox Single Post Mount Light, The Wilcox Single Post Mount Lights, The Wilcox Single Post Mount Lighting, The Wilcox Post Mount Light, The Wilcox Post Mount Lights, The Wilcox Post Mount Lighting, Wilcox Single Post Mount Light, Wilcox Single Post Mount Lights, Wilcox Single Post Mount Lighting, Wilcox Post Mount Light, Wilcox Post Mount Lights, Wilcox Post Mount Lighting, Copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, wilcox post, wilcox post mount light, single wilcox post mount, wilcox single post, deep bowl post mount, deep bowl post, wilcox, wilcox post light, new led post, wilcox post mount, wilcox led post mount, led post mount, wilcox led post, led wilcox post mount, wilcox post mount, Wilcox Nautical LED Single Post Mount Light, Wilcox Nautical LED Post Mount Light, Wilcox Nautical LED Single Post Mount, Wilcox Nautical LED Post Mount, Wilcox LED Single Post Mount Light, Wilcox LED Single Post Mount, Wilcox Nautical LED Post Mount Light, Wilcox Nautical LED Post Mount, Wilcox Nautical Post Mount Light, Wilcox Nautical Post Mount, nautical led, led nautical, nautical post mount, BLE-DBW14, BLE-DBW16, BLE-PMS-DBW14, BLE-PMS-DBW16, BLE-PMSD-DBW14, BLE-PMSD-DBW16, rustic LED Post mount, rustic LED Post mount light, rustic+LED+Post+mount, PMS Wilcox, SPS-0272, SPS 0272, SPS0272, 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 LED Series, Wilcox LED Collection, The Wilcox LED Series, The Wilcox LED Collection, Wilcox LED deep bowl series, wilcox LED deep bowl collection, the wilcox LED deep bowl series, the wilcox LED deep bowl collection, LED deep bowl series, LED deep bowl collection, SPS-0453, SPS0453, SPS 0453, SPS-0272, SPS 0272, SPS0272, The Wilcox Post Mount Collection, The Wilcox Post Mount Series, Wilcox Post Mount Collection, Wilcox Post Mount Series, rustic LED Post mount, rustic LED Post mounts, BLE PMS, wilcox bowl, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting, H-16114, H-16116, classic deep bowl shade, classic deep bowl shade post light, H-16114, H-16116, classic deep bowl shade, classic deep bowl post light,
65175 The Sterling’s dramatic, streamline shade and nautical guard establishes the perfect look for commercial settings and residential properties. Outfitted with LED modules! Customize this post mount light to match your space! BLE-PMS-DCS, BLE-PMSD-DCS, Sterling Deep Cone Reflector Single Post Mount Decorative Exterior Light, BLE-PMSD-DCS, deep cone light pole, deep cone post mount, sterling post mount, sterling light pole, sterling, deep cone, cone reflector, single post, post mount, exterior light, decorative light pole, light pole, post mount light, reflector shade, sidewalk light, landscape lighting, commercial lighting, pole light, post light, pole mount, BLE-PMSD-DCS14, BLE-PMSD-DCS16, Sterling Deep Cone Reflector Single Post Mount Exterior Light, Sterling, Deep Cone, Reflector, Single, pole light, Post Mount, Exterior Light, BLE-PMS-DCS, reflector shade, cone reflector shade, post mount, garden lights, patio post lights, post lights, restaurant post, outdoor lighting, lamppost, pole mount, BLE-PMS-DCS14, BLE-PMS-DCS16, The Sterling Post Mount Light, The Sterling Post Mount Lights, The Sterling Post Mount Lighting, Sterling post mount light, sterling post mount lights, sterling post mount lighting, Copper post mount light, copper post mount lights, copper post mount lighting, copper post mount, copper post mounts, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, sterling post, sterling post mount, deep cone post, deep cone post mount, sterling single post mount, sterling post light, sterling deep cone post , reflector post mount light, new led post, Sterling LED Single Post Mount Light, Sterling LED Post Mount Light, Sterling LED Single Post Mount, Sterling Single Post Mount, Sterling LED, led sterling, led post mount, post mount led, Sterling Nautical LED Single Post Mount Light, Sterling Nautical LED Single Post Mount, Sterling Nautical Single Post Mount Light, Sterling Nautical Single Post Mount, Sterling LED Single Post Mount Light, Sterling LED Single Post Mount, Sterling Nautical Post Mount Light, Sterling Nautical Post Mount, Sterling LED Post Mount Light, Sterling LED Post Mount, Nautical led, LED nautical, nautical post mount, post mount nautical, led post mount, post mount led, BLE-PMS-DCS14, BLE-PMS-DCS16, BLE-PMSD-DCS14, BLE-PMSD-DCS16, SPS-0270, SPS 0270, SPS0270, The Sterling Post Mount Collection, The Sterling Post Mount Series, Sterling Post Mount Collection, Sterling Post Mount Series, rustic LED Post mount, rustic LED Post mounts, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting,