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

Query time 0.00034

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

Result

product_id	meta_description	search_words
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,
65141	Crafted from commercial-grade materials, this decorative yet functional post mount light features cutting-edge LED technology, multiple arm styles, and unique customizing options!	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, union led, union led post mount, led union post mount, Union LED Single Post Mount Light, new led post, BLE-PMS-WHU14, BLE-PMS-WHU16, BLE-PMSD-WHU14, BLE-PMSD-WHU16, union series, union collection, the union series, the union collection, union LED series, union LED collection, the union led series, the union led 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, 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, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting,
65163	Outfitting vintage designs with modern LED technology, the Union is the perfect post mount light for homes and businesses! Handcrafted in the USA and fully customizable!	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, union led, union led post mount, led union post mount, Union LED Single Post Mount Light, new led post, Union Nautical LED Single Post Mount Light, Union Nautical LED Single Post Mount, Union Nautical LED Post Mount Light, Union Nautical LED Post Mount, Union nautical post mount, union led post mount, union nautical led, led union post mount, nautical union post mount, BLE-PMS-WHU14, BLE-PMS-WHU16, BLE-PMSD-WHU14, BLE-PMSD-WHU16, rustic LED Post mount, rustic LED Post mounts, rustic LED Post mount light, rustic+LED+Post+mount, union LED series, union LED collection, the union led series, the union led collection, 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, 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, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting,