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

Query time 0.00043

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

Result

product_id	meta_keywords	meta_description	search_words
61273	hanging stem mount light, country style lighting, decorative western pendant light, decorative outdoor lighting, led pendant light, stem mount pendant light, ceiling lighting, environmentally friendly lighting	Nostalgic styles with energy-saving LED technology! The Laramie offers a classic style in an environmentally friendly design! American made and fully customizable!	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-LED, LED laramie, LED stem mount, LED ceiling light, LED pendant, BLE-S-LAR10-PC-LED, BLE-S-LAR12-PC-LED, BLE-S-LAR14-PC-LED, BLE-S-LAR16-PC-LED, The Laramie Stem Mount LED Pendant, led stem mount, led stem mount pendant, led rlm shade, ceiling lighting, led ceiling lighting, stem mount pendant, led stem mount pendant, industrial lighting, led industrial lighting, warehouse lighting, led warehouse lighting, stem mount warehouse lighting, western lighting, country lighting, western led lighting, rural ceiling light, laramie led, led laramie, led stem, stem led, BLE-S-LAR10, BLE-S-LAR12, BLE-S-LAR14, BLE-S-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 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,
63084	ceiling lighting, ceiling pendant, pendant lighting	Vintage lighting styles available for modern settings! The Colby is an American made lighting fixture. Help this pendant lighting stand out with a vibrant finish color!	The Colby Pendant, BLE-C-CBY-PC, Colby pendant, Colby, Colby lighting, Colby light, pendant, pendant lighting, pendant, pendant light, Colby pendant, Colby pendant lighting, Colby pendant, Colby pendant light, Kolby, Kolbe, Colbe, ceiling light, ceiling lighting, ceiling pendant, ceiling light pendant, SPS-0061, SPS 0061, SPS0061, Colby Collection, Colby Series, The Colby Collection, the Colby series, natural metals, natural metal, 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, H-2040, the classic tall milkman cord hung pendant, milk man, milkman