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 (64078, 64179, 64180, 65145) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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 (64078,64179,64180,65145) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
64078	Celebrating the nostalgic charm of vintage lighting, brighten up your residential or commercial property with stylish post mount lighting! Hand-crafted and available numerous customizing options!	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, BLE-PMS-WHS14, BLE-PMS-WHS16, 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-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, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, post top fixture, post top fixtures, post top light fixture, SPS-0269, SPS 0269, SPS0269, The Original™ Post Mount Collection, The Original™ Post Mount Series, Original™ Post Mount Collection, Original™ Post Mount Series, The Original Post Mount Collection, The Original Post Mount Series, Original Post Mount Collection, Original Post Mount Series, The Originaltm Post Mount Collection, The Originaltm Post Mount Series, Originaltm Post Mount Collection, Originaltm Post Mount Series, poles, pole, 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, BLE PMS, lamp post lights, barn lights on pole, jadeite, jadite, jadeite light, jadite light, outdoor pole lights, light post lighting, H-15114, H-15116, classic warehouse shade post light rlm, classic warehouse shade,
64179	For practical and stylish outdoor barn lights, turn to the Bomber Single Post Mount Light! A hand-crafted, American made RLM shade is perfect for commercial applications! Available in copper and brass!	BLE-PMS-WHB, BLE-PMSD-WHB, BLE-PMS-WHB-BRS, BLE-PMSD-WHB-COP, BLE-PMSD-WHB-BRS, BLE-PMS-WHB-COP, Bomber Single Post Mount Exterior Light, Bomber, Post Mount, single post, pole light, pole light fixture, pole light fixtures, pole lighting, outdoor lighting, pathway lights, commercial post lights, post lights, BLE-PM1-WHB, Bomber post mount, bomber pole light, BLE-PMS-WHB15, BLE-PMS-WHB17, outdoor lighting, exterior lighting, sidewalk light, side walk light, sidewalk lights, sidewalk 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, bomber post mount light, bomber post mount lights, bomber post mount lighting, bomber post, bomber single post, bomber post mount, bomber post light, BLE-PMS-WHB15, BLE-PMS-WHB17, BLE-PMSD-WHB15, BLE-PMSD-WHB17, bomber lighting outdoor, outdoor bomber lighting, bomber light outdoor, bomber lights outdoor, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, SPS-0267, SPS 0267, SPS0267, The Bomber Post Mount Collection, The Bomber Post Mount Series, Bomber Post Mount Collection, Bomber Post Mount Series, 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,
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,
65145	Durably handcrafted and integrated with LED tech, the Avalon is the perfect outdoor lighting fixture! Its classic design is fully customizable with unique finishes! Made in the USA!	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, led post mount, Avalon led, led 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, lamp post lights, barn lights on pole, avalon integrated, outdoor pole lights, light post lighting,