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 (65141, 65145, 65148, 65154) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00033

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 (65141,65145,65148,65154) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
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,
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,
65148	Save energy with LED post mount lighting! These post mount lights show off a timeless style and are fully customizable! Handcrafted and USA Made!	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, new led post, Bomber LED Single Post Mount Light, Bomber LED Single Post Mount, Bomber LED Post Mount Light, Bomber LED Post Mount, Bomber LED post mount, LED bomber post mount, bomber led, led bomber, 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, bomber led series, bomber led collection, SPS-0452, SPS0452, SPS 0452, 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, 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, H-15115, H-15117, curved warehouse shade, curved warehouse shade post light,
65154	With a playful fluted shade and integrated LED technology, this post mount light was designed for outdoor lighting plans. Customize its appearance with a decorative mounting and vibrant finish!	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, new led post, BLE-PMS-RWS12, BLE-PMS-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-0456, SPS 0456, SPS0456, seaside led series, seaside led collection, sea side led series, sea side led collection, the seaside led series, the seaside led collection, the sea side led series, the sea side led collection, 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, lamp post lights, barn lights on pole, seaside led post mount, outdoor pole lights, light post lighting, H-19112, H-19114, H-19116, classic radial shade, classic radial shade post light,