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 (65703, 65704, 65705) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65703,65704,65705) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
65703	Our durable, all-weather Barn Light Basics Bomber Gooseneck Light is the stylish light your garage has been looking for! Budget-friendly pricing makes it the easy choice!	basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, bomber gooseneck, bomber light, bomber basic, bomber gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, bomber discount light, all weather gooseneck warehouse light, back to basics, H-15111, H-15113, H-15115, H-15117, curved warehouse shade, curved warehouse shade gooseneck, basic bomber, bomber basic, farm and barn, farm and barn gooseneck, farm & barn,
65704	Designed to handle all weather conditions, our Barn Light Basics Bomber Stem Mount Light is the affordable choice that doesn't sacrifice on style! Shop now!	All Weather, Farm Light, stem mount, discount light, pendant, BLE-S-STL15-PC, BE-15STL, pendant light, rlm shade, deep bowl pendant, all weather lighting, new listing, new farm and barn, all weather warehouse shade, all weather ware house shade, All weather warehouse light, All weather warehouse lights, All weather warehouse lighting, All weather light, All weather lights, All weather lighting, All weather ware house light, All weather ware house lights, All weather ware house lighting, All weather farmhouse, All weather farm house, All weather outdoor lighting, All weather outdoor light, All weather outdoor lights, all weather stem mount, all weather stem mounts, all weather stem mount light, all weather stem mount lights, all weather stem mount lighting, all weather pendant lighting, all weather pendant light, all weather pendant lights, low cost, low cost lighting, all-weather, farm & barn, bomber stem light, stem mount bomber, bomber basics, bomber basic, bomber stem basic, basic stem bomber, simple light, basic light, back to basics, H-15111, H-15113, H-15115, H-15117, curved warehouse shade, curved warehouse shade stem mount, basic bomber, bomber basic, farm and barn, farm and barn stem, farm & barn, farm and barn stem light, farm and barn stem mount,
65705	Classic RLM style at a price your wallet will thank you for! Our Barn Light Basics Bomber Pendant Light has simplified options for a stress-free shopping experience!	Farm Light, cord hung, discount light, pendant, BLE-C-STL15-PC, farm and barn, farm and barn cord, new listing, new farm and barn, farm and barn cord hung pendant, low cost, low cost lighting, farm & barn, discount lighting, bomber light, bomber pendant, bomber cord, cord hung bomber, basics bomber, bomber basics, bomber basics cord, cord hung bomber basics, budget lighting, simple light, basic light, back to basics, basic bomber, bomber basic, farm and barn, farm and barn pendant, farm & barn,