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 (61070, 61074, 61080, 61083) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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 (61070,61074,61080,61083) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61070 american designer pendant light, mini pendant lighting, mini pendant shade, industrial cord hung pendant light, commercial industrial pendant light, art gallery pendant light, upcycled pendant light Our Lafayette SoHo Pendant embodies industrial chic with its small cone shade and rustic mount. Fully customizable to your tastes! The Lafayette Street Soho Pendant, Lafayette, BLE-C-SOH-LAF-PC, soho pendant, factory light, hanging light, bulky light, industrial, industrial pendant, lafayette soho, soho pendant, soho cord, soho cord pendant, soho pendant light, lafayette cord, lafayette cord pendant, lafayette pendant, lafayette pendant light, soho, lafayette, SPS-0421, SPS 0421, SPS0421, soho collection, soho series, The soho collection, the soho series, Lafayette collection, Lafayette series, The Lafayette collection, The Lafayette series, Lafayette soho collection, soho series, The soho collection, the soho series, teal, Soho cord hung, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded,
61074 american designer pendant light, mini pendant shade studio light, small cone light, cone shade industrial pendant, exposed cord pendant light, exposed cord light fixture, upcycled lighting Revamp your home or business with this chic pendant light. This sleek mini shade is affixed to an ultra industrial cord and exposed wire mount. The Lafayette Street Soho Studio Light, Lafayette, BLE-SUS-SOH-LAF-PC, soho light, studio light, chunky light, industrial pendant, studio light, factory light, modern lighting, loft lighting, lafayette studio, soho studio, soho studio light, Lafayette Studio Light, Soho, soho light, Lafayete, Lafayette SoHo Studio Light, Studio light, studio cable, studio cable light, studio cable pendant, studio cable lights, studio pendant cable, studio, cable, soho collection, soho series, The soho collection, the soho series, Lafayette collection, Lafayette series, The Lafayette collection, The Lafayette series, Lafayette soho collection, soho series, The soho collection, the soho series, SPS-0352, SPS 0352, SPS0352, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded,
61080 american designer wall sconce, industrial style wall sconce, steampunk home wall sconce, mini industrial wall sconce, mini shade wall light, pvc pipe lighting Our Lafayette SoHo Sconce mixes a chic mini shade with an industrial pipe mount. Looking for rustic wall lighting for your artsy loft or apartment? Create your own unique look! The Lafayette Street Soho Sconce, BLE-W-SOH-LAF-PC, lafayette sconce, lafayette wall light, lafayette, soho sconce, soho light, industrial sconce, chunky light, small light shade, wall light, durable light, outdoor lighting, industrial decor, shop lighting, lafayette street sconce, lafayette sconce, soho, lafayette, soho sconce, soho wall sconce, lafayette wall sconce, lafayette, lafayete, sconce soho, soho collection, soho series, The soho collection, the soho series, Lafayette collection, Lafayette series, The Lafayette collection, The Lafayette series, Lafayette soho collection, soho series, The soho collection, the soho series, SPS-0418, SPS 0418, SPS0418, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor 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,
61083 american designer pendant light, light pipe design, steampunk style pendant, flared industrial pendant light, pipe light stem mount fixture, chic warehouse shade pendant Our Canal Stem Mount brings industrial edge and city chic together in one fixture with its bulky warehouse shade mounted to a rustic pipe stem mount. The Canal Street Soho Stem Mount Pendant, canal, BLE-S-SOH-CAN-PC, soho light, stem mount, pendant, modern industrial, industrial light, chunky light, factory light, outdoor lighting, soho stem mount, Canal SoHo Stem Mount Pendant, canal stem, canal stem mount, soho stem, soho stem mount, canal soho, soho canal, 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,