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 (61051, 61052, 61411, 61417) 
  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 (61051,61052,61411,61417) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61051 country style gooseneck lighting, decorative exterior wall light, rlm style gooseneck light, curved arm wall light, gooseneck light outdoor, gooseneck reading light, western inspired gooseneck light, industrial farmhouse lighting Channel the farmhouse look with this decorative RLM shade gooseneck light. Fully customizable and made in the USA! The Laramie Gooseneck, BLE-G-LAR-PC, laramie, gooseneck, gooseneck light, amreican made, classic light, unique neck, western style, gooseneck arm,BLE-G-LAR12-PC, BLE-G-LAR14-PC, BLE-G-LAR16-PC, gooseneck lighting, gooseneck wall lights, gooseneck wall lighting, outdoor gooseneck lighting, exterior gooseneck lighting, exterior gooseneck, exterior lighting, outdoor lighting, interior lighting, interior gooseneck, wall light, wall lighting, gooseneck wall lighting, laramie gooseneck, farmhouse gooseneck, BLE-G-LAR8, BLE-G-LAR10, BLE-G-LAR12, BLE-G-LAR14, BLE-G-LAR16, KAR, SPS-0062, SPS 0062, SPS0062, The Laramie Collection, Laramie Collection, The Laramie Series, Laramie Series, Laramie gooseneck lamp, Laramie gooseneck lamps, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, outdoor wall mount light, outdoor wall mount lights, outdoor wall mount lighting, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg, H-70412, armed dome shade, armed dome shade gooseneck,
61052 country style lighting, rustic stem mount pendant, western-style industrial pendant, americana style light, contemporary barn fixture, industrial farmhouse lighting Incorporate farmhouse-style accessories into your home décor with the Laramie Pendant. The RLM-style shade with timeless flair is attached to a rugged stem mount. The Laramie Stem Mount Pendant, laramie, stem mount, pendant, stem mount pendant, amercian made, rlm shade, vintage ceiling light, ceiling light, BLE-S-LAR-PC, BLE-S-LAR8-PC, BLE-S-LAR10-PC, BLE-S-LAR12-PC, BLE-S-LAR14-PC, BLE-S-LAR16-PC, Laramie Stem Mount Pendant Light, Laramie Stem Mount Pendant, Laramie Stem Pendant Light, laramie, laramie stem, laramie pendant, laramie ceiling, BLE-S-LAR8, BLE-S-LAR10, BLE-S-LAR12, BLE-S-LAR14, BLE-S-LAR16, KAR, SPS-0062, SPS 0062, SPS0062, The Laramie Collection, Laramie Collection, The Laramie Series, Laramie Series, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Laramie stem light, 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, H-70412, armed dome shade, armed dome shade stem mount,
61411 decorative barn wall sconces, western style wall light, barn light wall sconce, rustic shade wall light, exterior barn wall sconce, rustic wall sconce, plug-in lighting, plug in lighting It’s the traditional barn light sconce that you love, embellished with farmhouse flair! The Laramie stands out with its mini-arm accents and grooved shade. The Laramie Wall Sconce, laramie, wall sconce, BLE-W-LAR-PC, barn wall sconce, western, rustic, wall light, BLE-W-LAR12-PC, BLE-W-LAR14-PC, Laramie wall sconce, Laramie wall light, wall lighting, industrial wall lighting, industrial wall mount, wall mount, western barn light, barn lighting, barn light sconce, barn sconce, wall sconce lighting, Laramie wall sconce, Laramie lighting, Laramie barn light, plug in sconce light, plug-in sconce lighting, plug-in wall light, plug in wall light, plug-in wall sconces, plug in wall sconce, plug-in sconces, plug in sconces, laramie sconce, BLE-W-LAR12-N, BLE-W-LAR12, BLE-W-LAR14-N, BLE-W-LAR14, KAR, SPS-0074, SPS 0074, SPS0074, The Laramie Wall Sconce Collection, The Laramie Wall Sconce Series, Laramie Wall Sconce Collection, Laramie Wall Sconce Series, The Laramie Sconce Collection, The Laramie Sconce Series, Laramie Sconce Collection, Laramie Sconce Series, Wall mount sconce, wall mount sconces, sconce wall mount, sconce wall mounted, wall mount light, wall mount lights, wall mount lighting, wall mounted light, wall mounted lights, wall mounted lighting, wall mount sconce light, wall mount sconce lights, wall mount sconce lighting, wall mounted sconce light, wall mounted sconce lights, wall mounted sconce lighting, plug in barn light, plug-in barn light, plug-in light,
61417 petite light, country style lighting, miniature barn light, mini wall sconce, western wall sconce, western accent lighting, plug-in sconce lighting This American made mini barn shade channels classic farmhouse styles. Add this mini-barn light in your bathroom, hallway, or inside your reading nook! The Bantam Laramie Wall Sconce, bantam 8"-10" laramie, wall sconce, BLE-W-LAR-PC, barn wall sconce, western, rustic, wall light, bantam laramie, mini wall light, mini shade, mini, BLE-W-LAR8-PC, BLE-W-LAR10-PC, plug-in lighting, plug in lighting, plug-in wall sconce, plug in wall sconce, plug-in wall light, plug-in wall lights, bantam laramie, bantam sconce, bantam wall sconce, BLE-W-LAR8, BLE-W-LAR10, KAR, SPS-0347, SPS 0347, SPS0347, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, plug in barn light, plug-in barn light, plug-in light, armed dome shade,