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 (29983, 61937, 58884, 61211) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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 (29983,61937,58884,61211) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
29983 Lighting Hardware, Lighting Hardware Accessories, Light Hardware Accessories, Lights Hardware Accessories, Hardware Accessories, Lighting Accessories, Light Hardware Accessories, Stem Mount 1/2 inch or 3/4 inch round aluminum pipe threaded on both ends that connects the ceiling canopy and the shade, can be hung both vertically and horizontally. Barn Light - 1/2" & 3/4" IP Stem Extensions, stem, stem replacement, lighting hardware, hardware, pipe extension
58884 gooseneck socket replacement, vintage barn light socket replacement, porcelain enamel socket replacement This socket assembly is often used as a replacement part for vintage porcelain enamel barn lights, and can fit any Barn Light with a hex hole in the neck. Socket Assembly - Coupler - 7' Wire, socket, coupler, lighting parts, vintage light repair, socket replacement, replacement socket, gooseneck socket, stem socket, light socket,
61211 hanging light cord, hanging bulb pendant, electrical swag light kit, socket pendant, porcelain socket pendant light, decorative socket pendant, filament bulb pendant, bare porcelain socket pendant light, bare bulb pendant This modern drop cord fixture follows a simple industrial style and features a ceramic porcelain socket and cloth cord mount. Big savings + Free Shipping! The Indy Porcelain Socket Pendant, BLE-C-PINDY, BLE-INDY, hanging bulb, bulb pendant, light cord, pendant light bulbs,Indy Pendant, light cord, hanging bulb, bulb pendant, hanging bulbs, pendant light bulbs, drop cord, porcelain socket, socket pendant, socket light, pindy socket, pindy sockets, pindy cup, pindy cups, pendy socket, pendy sockets, pendy cup, pendy cups,
61937 bare bulb pendant, single bulb rope light, edison bulb cord light, hanging cord light with single bulb, colorful socket bulb pendant, naked bulb pendant lighting, single bulb pendant, drop cap pendant Bare is beautiful with our Downtown Minimalist cord ceiling pendant! Make your single bulb lights stand out with custom cords and vibrant socket cap finishes. bare bulb pendant, single bulb rope light, edison bulb cord light, hanging cord light with single bulb, colorful socket bulb pendant, BLE-C-PINDY-CUP, Downtown Minimalist Cord Pendant, single bulb pendant, single bulb, bare bulb lighting, bare bulb, downtown, down town, down town minimalist, downtown minimalist, downtown pendant, down town pendant, minimalist pendant, downtown, down, town, downtown minimalist pendant, Bare bulb light, bare bulb lights, bare bulb lighting, bare bulb light fixture, bare bulb light fixtures, bare bulb lighting fixture, bare bulb lighting fixtures, Bare bulb pendant, bare bulb pendants, bare bulb ceiling pendant, bare bulb ceiling pendants, bare bulb pendant light, bare bulb pendant lights, bare bulb pendant lighting, bare bulb ceiling light, bare bulb ceiling lights, bare bulb ceiling lighting, Bare bulb cord, cord bare bulb, bare bulb cord hung, cord hung bare bulb, bare bulb cord hung pendant, bare bulb cord hung pendants, cord hung bare bulb pendant, cord hung bare bulb pendants, cord hung bare bulb ceiling pendant, bare bulb cord hung ceiling pendant, cord hung bare bulb ceiling pendants, bare bulb cord hung ceiling pendants, bare bulb cord hung pendant light, cord hung bare bulb pendant light, cord hung bare bulb pendant lights, bare bulb cord hung pendant lights, cord hung bare bulb pendant lighting, bare bulb cord hung pendant lighting, cord hung bare bulb ceiling light, bare bulb cord hung ceiling light, cord hung bare bulb ceiling lights, bare bulb cord hung ceiling lights, bare bulb cord hung ceiling lighting, cord hung bare bulb ceiling lighting, bare bulb cord mount, cord mount bare bulb, bare bulb cord mount pendant, bare bulb cord mount pendants, cord mount bare bulb pendant, cord mount bare bulb pendants, cord mount bare bulb ceiling pendant, bare bulb cord mount ceiling pendant, cord mount bare bulb ceiling pendants, bare bulb cord mount ceiling pendants, bare bulb cord mount pendant light, cord mount bare bulb pendant light, cord mount bare bulb pendant lights, bare bulb cord mount pendant lights, cord mount bare bulb pendant lighting, bare bulb cord mount pendant lighting, cord mount bare bulb ceiling light, bare bulb cord mount ceiling light, cord mount bare bulb ceiling lights, bare bulb cord mount ceiling lights, bare bulb cord mount ceiling lighting, cord mount bare bulb ceiling lighting, Pendant island lights, pindy, downlight minimalist, down light minimalist, down minimalist, pindy cup, pendy cup, Downtown Collection, Downtown Series, The Downtown Collection, The Downtown Series, Down town Collection, Down town Series, The Down town Collection, The Down town Series, Minimalist collection, Minimalist series, The Minimalist collection, The Minimalist series, Downtown Minimalist Collection, Downtown Minimalist Series, The Downtown Minimalist Collection, The Downtown Minimalist Series, Down town Minimalist Collection, Down town Minimalist Series, The Down town Minimalist Collection, The Down town Minimalist Series, SPS-0211, SPS 0211, SPS0211, 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, edison bulb pendant, bulb pendant,