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 (61166, 61211, 59410, 59412) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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 (61166,61211,59410,59412) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
59410 wire cage industrial pendant light, copper cage light, hanging copper light, vintage industrial pendant light Superior American craftsmenship, roots in historic cage lighting, and copper styling makes the Minimalist Copper Pendant a vintage pendant light to be proud of. Minimalist Copper Pendant, BLE-500-TW, copper cage light, minimalist wire cage light, Minimalist Copper Cage Pendant, copper, copper pendant, caged pendants, cage pendant light, caged light, caged pendant light, farmhouse, farm house, modern farmhouse, modern farm house, modern farmhouse light, modern farmhouse lights, modern farmhouse lighting, modern farm house light, modern farm house lights, modern farm house lighting, farmhouse light, farmhouse lights, farmhouse lighting, farm house light, farm house lights, farm house lighting, minimalist light, minimalist pendant, minimalist cage pendant, minimalist light, copper, copper minimalist, minimalist copper, Minimalist Copper Cage Pendant Light, Minimalist Copper Pendant Light, Minimalist Copper Pendant, Pendant island lights, cage, wire, 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, industrial cage lighting, BLE-TW-500
59412 raw brass hanging pendant, brass ceiling light, Cord hung lighting, vintage industrial pendant light This vintage pendant light features a cloth cord mount with an exposed socket. Customize this reproduction pendant with a unique bulb! Minimalist Raw Brass Pendant, minimal pendant light, single bulb hanging pendant, raw brass hanging pendant, brass ceiling light, cloth cord pendant light, vintage industrial edison light, BLE-501-TW, minimalist, minimalist pendant, bare bulb pendant, bare bulb light, bare bulb pendant light, minimalist pendant light, 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,
61166 filament bulb pendant, solo pendant light, exposed socket pendant, cord hung bulb light, single bulb pendant, edison bulb pendant light, cord hung socket pendant, minimalist bulb pendant Loved for its minimal, bare bulb the Indy Pendant is rooted in vintage industrial lighting styles. Its turn key and custom cord options makes you the designer. Barn Light Indy Industrial Pendant, BLE-PHSCKT, BLE-INDY, hanging bulb, bulb pendant, light cord, pendant light bulbs, Indy Industrial Pendant, Indy Industrial Pendant Light, Indy Industrial Pendant Lights, Indy Industrial Pendant Lighting, Indy Pendant, Indy Pendants, Indy Pendant Light, Indy Pendant Lights, Indy Pendant Lighting, bare bulb light, bare bulb pendant, minimalist pendant, industrial pendant, minimalist ceiling pendant, 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,
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,