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 (62020, 61411, 63087, 61213) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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 (62020,61411,63087,61213) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61213	led gooseneck light, exterior led wall light, energy saving exterior lighting, led wall lighting, led gooseneck, gooseneck barn light, lighting fixture, environmentally-friendly lighting	This LED gooseneck light pays tribute to classic American Lighting with its RLM-style shade and curved arm. American made, endlessly customizable!	The Laramie Gooseneck, BLE-G-LAR-PC, laramie, gooseneck, gooseneck light, amreican made, classic light, unique neck, western style, gooseneck arm, BLE-G-LAR-PC-LED, LED gooseneck, Laramie LED, LED lighting, commercial lighting, BLE-G-LAR10-PC-LED, BLE-G-LAR12-PC-LED, BLE-G-LAR14-PC-LED, BLE-G-LAR16-PC-LED, led laramie, laramie led, led gooseneck, gooseneck led, led gooseneck light, gooseneck led light, BLE-G-LAR10, BLE-G-LAR12, BLE-G-LAR14, BLE-G-LAR16, KAR, SPS-0074, SPS 0074, SPS0074, 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, bleg, H-70412, armed dome shade, armed dome shade gooseneck,
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,
62020	decorative barn lights, galvanized gooseneck barn light, outdoor lighting, hand crafted lighting, gooseneck barn light	Inspired by the spirit and steadfastness of early American barn lights, Chestnut Gooseneck is a locally made outdoor light fixture ready for modern venues!	chestnut, the chestnut, chestnuts, chestnut light, laramie, gooseneck, goose-neck, goosenecks, goose neck, gooeneck, wall light, outdoor light, decorative barn light, BLE-G-CLAR-PC, chestnut gooseneck, chest nut gooseneck, barnlight gooseneck, BLE-G-CLAR12-PC, BLE-G-CLAR14-PC, BLE-G-CLAR16-PC, new listing, new chestnut, chesnut, chest nut, chestnut gooseneck light, chest nut goose neck light, chesnut gooseneck, chesnut goose neck, chestnut goosenecks, BLE-G-CLAR8, BLE-G-CLAR10, BLE-G-CLAR12, BLE-G-CLAR14, BLE-G-CLAR16, SPS-0063, SPS 0063, SPS0063, The Chestnut Collection, The Chestnut Series, Chestnut Collection, Chestnut Series, 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,
63087	Wall Sconce, Wall Sconce Lighting, Durable Sconce Lighting	Suitable for both interior and exterior lighting purposes, the Colby Sconce is perfect for homes and businesses! Add this fixture to your space today!	The Colby Sconce, BLE-W-CBY-PC, Colby Sconce, Sconce, Colby, Colby Wall Sconce, Colby Wall Sconce Light, Colby Wall Sconce Lighting, Colby Sconce Light, Colby Sconce Lighting, Wall Light, Wall Lighting, Barn sconce, barn light sconce, barn wall sconce, exterior lighting, exterior barn lighting, wall light for outside, outside lighting, outdoor lighting, porch light, front porch light, patio light, patio lighting, colby Wall Light, colby Wall Lighting, Kolby, Kolbe, Colbe, SPS-0079, SPS 0079, SPS0079, Colby Collection, Colby Series, The Colby Collection, the Colby series, Outdoor garage lights, Outdoor garage light, Outdoor garage lighting, Out door garage lights, Out door garage light, Out door garage lighting, 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, 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, H-2041-B, the flat arm milk man wall light, milk man, milkman