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 (64180, 64181, 64185, 65160) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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 (64180,64181,64185,65160) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
64180	A shallow bowl reflector shade captures attention and brightens exterior spaces! This fully customizable post mount light is available with marine grade or powder coat finishes, along with copper and brass!	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, BLE-PMS-SBA14, BLE-PMS-SBA16, BLE-PMSD-SBA14, BLE-PMSD-SBA16, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, post top fixture, post top fixtures, post top light fixture, poles, pole, BLE PMS, lamp post lights, barn lights on pole, jadeite, jadite, jadeite light, jadite light, outdoor pole lights, light post lighting,
64181	For stylish and durable post mount lighting, consider the Avalon! Crafted from quality materials, this pole light is manufactured in the United States! Fully customizable and includes copper and brass!	BLE-PMS-WHA, BLE-PMSD-WHA, BLE-PMS-WHA-BRS, BLE-PMSD-WHA-COP, BLE-PMSD-WHA-BRS, single post, post mount, modern lamppost, BLE-PM1-WHA, Avalon Single Post Mount Exterior Light, Avalon, Avalon post mount, lamppost, pole light, post mount pole, driveway light, pole barn light, pole barn lights, commercial pole lighting, pole lighting, walkway light, BLE-PMS-WHA14, BLE-PMS-WHA16, post lights, outdoor post lights, outdoor post lighting, pole lighting, outdoor pool lighting, outdoor lighting, out door lighting, The Avalon Single Post Mount Light, The Avalon Single Post Mount Lights, The Avalon Single Post Mount Lighting, Avalon Single Post Mount Light, Avalon Single Post Mount Lights, Avalon Single Post Mount Lighting, The Avalon Post Mount Light, The Avalon Post Mount Lights, The Avalon Post Mount Lighting, Avalon Post Mount Light, Avalon Post Mount Lights, Avalon Post Mount Lighting, Copper post mount, copper post mounts, brass post mount, brass post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount light, brass post mount lights, brass post mount lighting, avalon post, single avalon post mount, avalon single post, avalon post light, avalon, single avalon post, avalon, BLE-PMS-WHA14, BLE-PMS-WHA16, BLE-PMSD-WHA14, BLE-PMSD-WHA16, avalon post mount collection, the avalon post mount collection, avalon post mount series, the avalon post mount series, SPS-0266, SPS 0266, SPS0266, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, post top fixture, post top fixtures, post top light fixture, poles, pole, BLE PMS, lamp post lights, barn lights on pole, jadeite, jadite, jadeite light, jadite light, outdoor pole lights, light post lighting,
64185	Uniting stunning RLM shades with an industrial post mount makes the Union the perfect exterior commercial light! Available in marine grade, powder coat, copper, and brass! USA made!	BLE-PMS-WHU, BLE-PMSD-WHU, BLE-PMSD-WHU-COP, BLE-PMS-WHU-BRS, BLE-PMSD-WHU-BRS, BLE-PMS-WHU-COP, Union Single Post Mount Decorative Exterior Light, Union post mount, BLE-PMSD-WHU, union light pole, Union, single post, post mount, decorative, exterior light, decorative light pole, light pole, american made, warehouse shade, sidewalk light, landscape lights, commercial lighting, BLE-PMSD-WHU14, BLE-PMSD-WHU16, Union Single Post Mount Exterior Light, BLE-PMS-WHU, union, single post, post mount, exterior light, union light, post mount light, contemporary outdoor lighting, outdoor lighting, lamppost, porch light, landscape lighting, pathway lighting, modern outdoor light, outdoor light, pole mount, post mount, pole lihgt, pole light, BLE-PMS-WHU14, BLE-PMS-WHU16, The Union Post Mount Light, The Union Single Post Mount Light, The Union Single Post Mount Lights, The Union Single Post Mount Lighting, The Union Post Mount Light, The Union Post Mount Lights, The Union Post Mount Lighting, Union Single Post Mount Light, Union Single Post Mount Lights, Union Single Post Mount Lighting, Union Post Mount Light, Union Post Mount Lights, Union 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, union post light, union post mount, union, post light union, union post, union single post, union post light, BLE-PMS-WHU14, BLE-PMS-WHU16, BLE-PMSD-WHU14, BLE-PMSD-WHU16, union series, union collection, the union series, the union collection, SPS-0271, SPS 0271, SPS0271, SPS-0271, SPS 0271, SPS0271, The Union Post Mount Collection, the Union Post Mount Series, Union Post Mount Collection, Union Post Mount Series, poles, pole, BLE PMS, lamp post lights, barn lights on pole, jadeite, jadite, jadeite light, jadite light, 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,