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 (59410, 62272, 63827, 62450) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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 (59410,62272,63827,62450) 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
62272 industrial ceiling light, up/down lighting, warehouse shade pendant, pendant light Ideal for industrial ceiling lighting, the Cherokee Pendant Light features a flared warehouse shade that has horizontal vents on the neck for up/down lighting. Cherokee Uplight Cord Hung Pendant, cherokee cord pendant, uplight pendant, cord, cord pendant, BLE-C-ULC-PC, shade with jelly jar, cherokee, comanche, vented, flared shade, up light, upight, charokee uplight, charokee, BLE-C-ULC16-PC, cherokee cord, cherokee cords, cherokee cord light, cherokee cord lights, cherokee cord lighting, new listing, BLE-C-ULC12, BLE-C-ULC14, BLE-C-ULC16, BLE-C-ULC18, SPS-0161, SPS 0161, SPS0161, cherokee uplight series, cherokee uplight collection, the cherokee uplight series, the cherokee uplight collection, cherokee up light series, cherokee up light collection, the cherokee up light series, the cherokee up light collection, cherokee up-light series, cherokee up-light collection, the cherokee up-light series, the cherokee up-light collection, cherokee series, cherokee collection, the cherokee series, the cherokee collection, 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, cherokee pendants, slotted, slotted light,
62450 streamline pendant light, modern ring pendant light, modern industrial led pendant light, led ring pendant light Streamline style meets the future of LED technology with our Brewster LED Pendant. This modern ring pendant is infused with the latest technology from Cree Inc. Barn Light LED Brewster Pendant, led Brewster, Atomic led light, modern led, pendant, C-10LC, led ring pendant, brewster led, BLE-C-ULBR-PC-LED, The Brewster LED Pendant, SPS-0034, SPS 0034, SPS0034, Brewster Collection, Brewster Series, The Brewster Collection, The Brewster Series, SPS-0034, SPS 0034, SPS0034, Industrial guard led cord pendant, Industrial guard led cord pendants,
63827 Matching both contemporary and classic sensibilities, the Static Ring Pendant adapts to any space’s needs. Customize this pendant light with a lively finish color! USA made! BLE-C-RGU-PC, Static Ring Pendant, Static Ring Pendants, Static Ring Pendant Light, Static Ring Pendant Lights, Static Ring Pendant Lighting, Static Ring Ceiling Pendant, Static Ring Ceiling Pendants, Static Ring Ceiling Pendant Light, Static Ring Ceiling Pendant Lights, Static Ring Ceiling Pendant Lighting, Static Ring Ceiling Light, Static Ring Ceiling Lights, Static Ring Ceiling Lighting, Static Ring Light, Static Ring Lights, Static Ring Lighting, Static Ring, Rustic, Rustic Light, Rustic Lights, Rustic Lighting, Rustic Pendant Light, Rustic Pendant Lights, Rustic Pendant Lighting, Rustic Ceiling Pendant, Rustic Ceiling Pendants, Rustic Ceiling Pendant Light, Rustic Ceiling Pendant Lighting, Rustic Ceiling Light, Rustic Ceiling Lights, Rustic Ceiling Lighting, Industrial Light, Industrial Lights, Industrial Lighting, Industrial Pendant Light, Industrial Pendant Lights, Industrial Pendant Lighting, Industrial Ceiling Pendant, Industrial Ceiling Pendants, Industrial Ceiling Light, Industrial Ceiling Lights, Industrial Ceiling Lighting, Static, Rugged Light, Rugged Lights, Rugged Lighting, Rugged Pendant Light, Rugged Pendant Lights, Rugged Pendant Lighting, Rugged Ceiling Pendant, Rugged Ceiling Pendants, Rugged Ceiling Pendant Light, Rugged Ceiling Pendant Lighting, Rugged Ceiling Light, Rugged Ceiling Lights, Rugged Ceiling Lighting, cord hung pendant, cord hung pendants, cord hung pendant light, cord hung pendant lights, cord hung ceiling pendant, cord hung ceiling pendants, cord hung ceiling pendant light, cord hung ceiling pendant lights, cord hung ceiling light, cord hung ceiling lights, cord hung ceiling lighting, rustic cord hung pendant, rustic cord hung pendants, rustic cord hung pendant light, rustic cord hung pendant lights, rustic cord hung ceiling pendant, rustic cord hung ceiling pendants, rustic cord hung ceiling pendant light, rustic cord hung ceiling pendant lights, rustic cord hung ceiling light, rustic cord hung ceiling lights, rustic cord hung ceiling lighting, rugged cord hung pendant, rugged cord hung pendants, rugged cord hung pendant light, rugged cord hung pendant lights, rugged cord hung ceiling pendant, rugged cord hung ceiling pendants, rugged cord hung ceiling pendant light, rugged cord hung ceiling pendant lights, rugged cord hung ceiling light, rugged cord hung ceiling lights, rugged cord hung ceiling lighting, industrial cord hung pendant, industrial cord hung pendants, industrial cord hung pendant light, industrial cord hung pendant lights, industrial cord hung ceiling pendant, industrial cord hung ceiling pendants, industrial cord hung ceiling pendant light, industrial cord hung ceiling pendant lights, industrial cord hung ceiling light, industrial cord hung ceiling lights, industrial cord hung ceiling lighting, ring guard, ring guards, ring guard fixture, ring guard fixtures, ring guard light fixture, ring guard light fixtures, ring, ring fixture, ring fixtures, ring light fixture, ring light fixtures, industrial ring guard, industrial ring guards, ring industrial guard fixtures, ring industrial guard light fixture, industrial ring guard light fixtures, ring industrial guard, ring industrial guards, ring industrial guard fixtures, ring industrial guard light fixture, ring industrial guard light fixtures, Ring guard pendant, ring guard pendants, ring guard ceiling pendant, ring guard ceiling pendants, ring guard pendant light, ring guard pendant lighting, ring guard pendant lights, ring guard wall lights, ring pendant, ring pendants, ring ceiling pendant, ring ceiling pendants, ring pendant light, ring pendant lights, ring pendant lighting, industrial ring guard pendant, industrial ring guard pendants, ring industrial guard ceiling pendant, ring industrial guard ceiling pendants, ring industrial guard pendant light, ring industrial guard pendant lights, ring industrial guard pendant lighting, SPS-0162, SPS 0162, SPS0162, static ring collection, static ring series, the static ring collection, the static ring series, static ring guard collection, static ring guard series, the static ring guard collection, the static ring guard series, static guard collection, static guard series, the static guard collection, the static guard series, 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,