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

Query time 0.00039

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

Result

product_id	meta_keywords	meta_description	search_words
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,
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,
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,
63225		Country and industrial lighting styles meet in the Laramie. With LED lighting components equipped into its design, the Laramie is energy efficient and environmentally friendly!	The Laramie Rustic LED Stem Mount Pendant, Laramie Rustic LED Stem Mount Pendant, The Laramie LED Stem Mount Pendant, The Laramie Rustic Stem Mount Pendant, Laramie LED Stem Mount Pendant, Laramie Rustic Stem Mount Pendant, Laramie Stem mount pendant, laramie stem mount, laramie pendant, laramie, laramie pendant light, laramie pendant lights, laramie pendant lighting, laramie ceiling light, laramie ceiling lights, laramie ceiling lighting, pendant light, pendant lights, pendant lighting, ceiling light, ceiling lights, ceiling lighting, laramie, rustic led, rustic led light, rustic led lights, rustic led lighting, rustic pendant, rustic pendant lighting, rustic lights, rustic pendant lights, rustic pendant light, stem mount, stem mount light, stem mount lights, stem mount lighting, led stem mount light, led stem mount lights, led stem mount lighting, rustic stem mount, rustic stem mount light, rustic stem mount lights, rustic stem mount lighting, BLE-S-LAR-PC-CGG-LED, laramie nautical, nautical laramie, led laramie, laramie led, Laramie Nautical LED Stem Mount Pendant Light, The Laramie Nautical LED Stem Mount Pendant Light, Laramie Nautical Stem Mount Pendant Light, The Laramie Nautical Stem Mount Pendant Light, Laramie Nautical Stem Mount Pendant, The Laramie Nautical Stem Mount Pendant. Laramie Nautical Pendant Light, Laramie Nautical Pendant, BLE-S-LAR12, BLE-S-LAR14, BLE-S-LAR16, SPS-0062, SPS 0062, SPS0062, The Laramie Collection, Laramie Collection, The Laramie Series, Laramie Series, 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, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, H-70412, armed dome shade, armed dome shade stem mount,