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 (61052, 62704, 63088, 62019) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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 (61052,62704,63088,62019) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
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,
62019 porch pendant light, industrial stem mount porch light, exterior hanging pendant, barn light ceiling pendant, suspended warehouse shade, hanging barn light, doorway lighting Taking a nod from early American lights, the Chestnut Pendant is a period style warehouse shade suspended in a stem ceiling mount. Lovely for porch lighting! BLE-S-CLAR-PC, Chestnut Stem Mount Pendant, stem light, stem mount light, stemmount, stem light, barn light shade pendant light, hanging pendant, ceiling pendant, stem mount pendant, chestnut stem pendant, chestnut, chestnut pendant, the chestnut, chestnuts, chestnut light, laramie, BLE-S-CLAR8-PC, BLE-S-CLAR10-PC, BLE-S-CLAR12-PC, BLE-S-CLAR14-PC, BLE-S-CLAR16-PC, new listing, chestnut, chestnut stem, chesnut, chesnut stem, chest nut, chestnut pendant, chesnut pendant, chest nut pendant, new chestnut, BLE-S-CLAR8, BLE-S-CLAR10, BLE-S-CLAR12, BLE-S-CLAR14, BLE-S-CLAR16, SPS-0063, SPS 0063, SPS0063, The Chestnut Collection, The Chestnut Series, Chestnut Collection, Chestnut Series, 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,
62704 hanging stem mount light, rustic kitchen pendant light, outdoor lighting, industrial farmhouse led light, gas station lighting, warehouse shade, stem mount pendant, ceiling light, led pendant Eye-catching and efficient, this classic lighting design now embraces integrated LEDs! Still American made and fully customizable! Elevate any decor with LED pendant lighting! The Chestnut Stem Mount Pendant, laramie, stem mount, pendant, stem mount pendant, amercian made, rlm shade, vintage ceiling light, ceiling light, BLE-S-CLAR-PC-LED, LED laramie, LED stem mount, LED ceiling light, LED pendant, BLE-S-CLAR10-PC-LED, BLE-S-CLAR12-PC-LED, BLE-S-CLAR14-PC-LED, BLE-S-CLAR16-PC-LED, warehouse lighting, stem mount lighting, led warehouse lighting, stem mount led lighting, ceiling lighting, led pendant lighting, ceiling lighting led, led ceiling lighting, pendant lighting, led pendant, stem mount, led stem mount lighting, led warehouse lighting, rlm warehouse, rlm warehouse light, led rlm warehouse, ceiling lighting, ceiling pendant, led ceiling pendant, chestnut led, led chestnut, led stem, stem led, BLE-S-CLAR10, BLE-S-CLAR12, BLE-S-CLAR14, BLE-S-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 pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants,
63088 LED Lighting, LED Pendant Lights, LED Pendant Lighting Pairing vintage looks with modern technology, the Colby LED Pendant reduces power bills while adding a unique sense of style. Perfect for homes and businesses! The Colby LED Pendant, The Colby Pendant, Colby LED Pendant, Colby Pendant, Colby, Pendant, LED Pendant, LED pendant lighting, LED pendant light, LED Pendant Lights, Ceiling Light, Ceiling Lighting, LED ceiling Light, LED ceiling Pendant, cord hung light, cord hung lighting, LED cord hung light, led cord hung lighting, Cord hung ceiling light, cord hung ceiling lighting, BLE-C-CBY-PC-LED, SPS-0545, SPS0545, SPS 0545, Colby LED Collection, Colby LED Series, The Colby LED Collection, the Colby LED series, H-2040, the classic tall milkman cord hung pendant, milk man, milkman