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, 64180, 64182, 65151) 
  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 (64078,64180,64182,65151) 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,
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,
64182	Mounted to a pole, the Seaside incorporates a radial wave style RLM shade and a curved arm to create the perfect outdoor lighting for commercial spaces! Available in copper and brass!	BLE-PMS-RWS, BLE-PMSD-RWS, BLE-PMS-RWS-BRS, BLE-PMS-RWS-COP, BLE-PMSD-RWS-BRS, BLE-PMSD-RWS-COP, Seaside Radial Wave Reflector Single Post Mount Exterior Light, Seaside post mount, BLE-PMS-RWS, seaside, radial wave, single post, post mount, exterior light, pole light, pole light fixtures light pole, radial wave, radial wave light, decorative outdoor lighting, driveway lighting, commercial outdoor lighting, outdoor lighting, garden lighting, pole mount, post light, BLE-PMS-RWS14, BLE-PMS-RWS16, Seaside Radial Wave Post/Pole Mount Light, The Seaside Radial Wave Single Post Mount Light, The Seaside Radial Wave Single Post Mount Lights, The Seaside Radial Wave Single Post Mount Lighting, The Seaside Radial Wave Post Mount Light, The Seaside Radial Wave Post Mount Lights, The Seaside Radial Wave Post Mount Lighting, Seaside Radial Wave Post Mount Light, Seaside Radial Wave Post Mount Lights, Seaside Radial Wave Post Mount Lighting, Seaside Post Mount Light, Seaside Post Mount Lights, Seaside 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, seaside post, seaside post mount, seaside radial wave post, radial wave post mount, seaside single post, radial post, BLE-PMS-RWS12, BLE-PMS-RWS14, BLE-PMSD-RWS12, BLE-PMSD-RWS14, seaside series, seaside collection, sea side series, sea side collection, the seaside series, the seaside collection, the sea side series, the sea side collection, SPS-0156, SPS0156, SPS 0156, SPS-0268, SPS0268, SPS 0268, The Seaside Post Mount Collection, The Seaside Post Mount Series, The Sea side Post Mount Collection, The Sea side Post Mount Series, Seaside Post Mount Collection, Seaside Post Mount Series, Sea side Post Mount Collection, Sea side 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, H-19112, H-19114, H-19116, classic radial shade, classic radial shade post light,
65151	Line walkways and outdoor areas with LED post mount lighting! High-performance tech makes this fixture eco-friendly and cost effective! American made and fully customizable!	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, 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, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting,