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 (64761, 64757, 64976, 64740) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00058

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 (64761,64757,64976,64740) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
64740	flared deep cone reflector, gas station reflector, modern stem pendant, retro ceiling lighting, colorful factory lighting, flared cone light, deep cone reflector,	Bold and minimalistic, the Sterling showcases a retro RLM look with a modern twist. This customizable flared cone light is perfectly paired with a stem mount.	Benjamin Sterling, Benjamin Deep Cone Reflector, stem mount Sterling, Sterling pendant, stem mount deep cone, stem mount deep cone reflector, deep cone pendant, deep cone reflector pendant, BLE-S-DCS, BLE-S-DCS12, BLE-S-DCS14, BLE-S-DCS16, sterling stem, sterling pendant, sterling deep cone, deep cone stem, reflector stem, reflector pendant, deep steep, cone stem, deep cone pendant, shallow pendant, shallow stem, flat pendant, flat stem, flat, shallow pendant, shallow stem, shallow, new listing, new rlm, new sterling, BLE-S-DCS-PC, The Summit Stem Mount Pendant, The Summit Stem Mount Pendant Light, The Summit Stem Mount Pendant Lights, The Summit Stem Mount Pendant Lighting, The Summit Stem Mounted Pendant, The Summit Stem Mounted Pendant Light, The Summit Stem Mounted Pendant Lights, The Summit Stem Mounted Pendant Lighting, Summit Stem Mount Pendant, Summit Stem Mount Pendant Light, Summit Stem Mount Pendant Lights, Summit Stem Mount Pendant Lighting, Summit Stem Mounted Pendant, Summit Stem Mounted Pendant Light, Summit Stem Mounted Pendant Lights, Summit Stem Mounted Pendant Lighting, The Summit Stem Mount, The Summit Stem Mounts, The Summit Stem Mount Light, The Summit Stem Mount Lights, The Summit Stem Mount Lighting, The Summit Stem Mounted Pendant Light, The Summit Stem Mounted Lights, The Summit Stem Mounted Lighting, Summit Stem Mount, Summit Stem Mounts, Summit Stem Mount Light, Summit Stem Mount Lights, Summit Stem Mount Lighting, Summit Stem Mounted Light, Summit Stem Mounted Lights, Summit Stem Mounted Lighting, The Summit Pendant, The Summit Pendant Light, The Summit Pendant Lights, The Summit Pendant Lighting, Summit Pendant, Summit Pendant Light, Summit Pendant Lights, Summit Pendant Lighting, The Summit Stem Mount Pendants, Summit Stem Mount Pendants, The Summit Stem Mount Ceiling Pendant, The Summit Stem Mount Ceiling Pendants, The Summit Stem Mount Ceiling Light, The Summit Stem Mount Ceiling Lights, The Summit Stem Mount Ceiling Lighting, Summit Stem Mount Ceiling Pendant, Summit Stem Mount Ceiling Pendants, Summit Stem Mount Ceiling Light, Summit Stem Mount Ceiling Lights, Summit Stem Mount Ceiling Lighting, The Summit Stem Mounted Ceiling Pendant, The Summit Stem Mounted Ceiling Pendants, The Summit Stem Mounted Ceiling Light, The Summit Stem Mounted Ceiling Lights, The Summit Stem Mounted Ceiling Lighting, Summit Stem Mounted Ceiling Pendant, Summit Stem Mounted Ceiling Pendants, Summit Stem Mounted Ceiling Light, Summit Stem Mounted Ceiling Lights, Summit Stem Mounted Ceiling Lighting, The Summit Ceiling Pendant, The Summit Ceiling Pendants, The Summit Ceiling Light, The Summit Ceiling Lights, The Summit Ceiling Lighting, Summit Ceiling Pendant, Summit Ceiling Pendants, Summit Ceiling Light, Summit Ceiling Lights, Summit Ceiling Lighting, Summit Pendant, Summit Pendants, Summit Pendant Light, Summit Pendant Lights, Summit Pendant Lighting, Summit, Sumit, sterling, BLE-S-DCS12, BLE-S-DCS16, BLE-S-DCS14, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, SPS-0157, SPS 0157, SPS0157, Sterling Series, the Sterling Series, Sterling Collection, The Sterling Collection, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, exterior ceiling mount light, exterior ceiling mount lights, exterior ceiling mount lighting, exterior ceiling mount light fixture, exterior ceiling mount light fixtures, exterior ceiling mount lighting fixture, exterior ceiling mount lighting fixtures, exterior ceiling mount, exterior ceiling mounts, exterior ceiling mount fixture, exterior ceiling mount fixtures, Ceiling mount exterior light, Ceiling mount exterior lights, Ceiling mount exterior lighting, Ceiling mount exterior light fixture, Ceiling mount exterior light fixtures, Ceiling mount exterior lighting fixture, Ceiling mount exterior lighting fixtures, jadeite, jadite, jadeite light, jadite light,
64757		This exterior pendant light reflects ample lighting with its flat-cone shade. The Conoco's modern look is enhanced with an industrial stem mount.	Benjamin, benjamin conoco, BLE-S-FCC, BLE-S-FCC10, BLE-S-FCC12, BLE-S-FCC15, conoco stem, conoco pendant, flat pendant, shallow pendant, flat, shallow, new listing, new rlm, new conoco, Circle B, Circle B pendant, Circle B stem mount, Circle B Ceiling Light, Flat Cone, Flat Cone Reflector, BLE-S-FCC-PC, BLE-S-FCC10-PC, BLE-S-FCC12-PC, BLE-S-FCC15-PC, stem mount pendant, circle b light, circle b lighting, circle b ceiling light, ceiling lighting, ceiling light, interior lighting, residential lighting, flat shade, flat warehouse shade, flat rlm shade, conoco, conoco shade, conoco shades, circle b, BLE-S-FCC10, BLE-S-FCC12, BLE-S-FCC15, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, SPS-0151, SPS 0151, SPS0151, Conoco series, Conoco collection, the Conoco series, the Conoco collection, jadeite, jadite, jadeite light, jadite light,
64761	gas station lighting, exterior pendant light, shallow shade ceiling light, yard light, gas station light, outdoor light,	The Marathon's shallow bowl shade and durable stem mount is ideal for outdoor ceiling lighting and interior spaces! Customizable and handcrafted!	benjamin marathon, gas station light, benjamin marathon, marathon stem mount, marathon pendant, BLE-G-YDM, BLE-S-YDM12, BLE-S-YDM14, BLE-S-YDM16, marathon, marathon stem, shallow pendant, shallow, new listing, new rlm, new marathon, Maritime stem mount, Maritime Pendant, Maritime Ceiling light, stem mount Yard Light, Yard Light Pendant, Shallow bowl stem mount, shallow bowl pendant, The Maritime Shallow Bowl Stem Mount Pendant, BLE-S-YDM-PC, YDM12-PC, BLE-S-YDM14-PC, BLE-S-YDM16-PC, BLE-S-YDM12, BLE-S-YDM14, BLE-S-YDM16, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, marathon series, marathon collection, the marathon series, the marathon collection, SPS-0109, SPS 0109, SPS0109, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, exterior ceiling mount light, exterior ceiling mount lights, exterior ceiling mount lighting, exterior ceiling mount light fixture, exterior ceiling mount light fixtures, exterior ceiling mount lighting fixture, exterior ceiling mount lighting fixtures, exterior ceiling mount, exterior ceiling mounts, exterior ceiling mount fixture, exterior ceiling mount fixtures, Ceiling mount exterior light, Ceiling mount exterior lights, Ceiling mount exterior lighting, Ceiling mount exterior light fixture, Ceiling mount exterior light fixtures, Ceiling mount exterior lighting fixture, Ceiling mount exterior lighting fixtures, jadeite, jadite, jadeite light, jadite light, bowl shallow,
64976		Classic, handcrafted, and efficient: the Seaside incorporates cutting-edge LED components into its playful design! Customizable and eco-friendly!	Benjamin Seaside, Benjamin radial wave, Benjamin radial wave reflector, Seaside stem mount, radial wave stem mount, radial wave reflector stem mount, Seaside pendant, radial wave pendant, radial wave reflector pendant, LED, Benjamin LED, seaside LED, LED radial wave, LED reflector, LED ceiling light, LED pendant, LED lighting, BLE-S-RWS-LED, BLE-S-RWS12-LED, BLE-S-RWS14-LED, BLE-S-RWS16-LED, Benjamin LED Stem Light, Benjamin Stem Light, Seaside Radial Wave Reflector Stem Light, seaside, seaside led, seaside led stem, seaside stem, seaside stem led, seaside stem pendant, led seaside, led seaside stem, seaside stem mount, seaside stem mount led, radial wave, radial wave led, radial wave led stem, radial wave stem, radial wave stem led, radial wave stem pendant, led radial wave, led radial wave stem, radial wave stem mount, radial wave stem mount led, seaside LED, seaside, seaside led, seaside led stem, seaside stem, seaside stem led, seaside stem pendant, led seaside, led seaside stem, seaside stem mount, seaside stem mount led, radial wave, radial wave led, radial wave led stem, radial wave stem, radial wave stem led, radial wave stem pendant, led radial wave, led radial wave stem, radial wave stem mount, radial wave stem mount led, Starfire pendant, starfire reflector pendant, radial wave stem mount, radial wave pendant, radial wave reflector stem mount, radial wave reflector pendant, radial wave, reflector, The Starfire Radial Wave Reflector Stem Light, BLE-S-RWS-PC-LED, LED, LED Starfire, LED radial wave, LED reflector, LED ceiling Light, LED pendant, BLE-S-RWS12-PC-LED, BLE-S-RWS14-PC-LED, BLE-S-RWS16-PC-LED, kitchen lighting, restaurant lighting, BLE-S-RWS12, BLE-S-RWS14, BLE-S-RWS16, 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, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, H-19112, H-19114, H-19116, classic radial shade, classic radial shade stem mount,