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 (65937, 65938) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65937,65938) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words	promo_text
65937	LED linear light, wood suspension light, modern pendant lighting, handcrafted lighting, linear pendant, Suora light, kitchen island lighting, American made lighting, minimalist lighting, customizable light fixture	Discover the Suora LED Linear Suspension Light, a sleek wood pendant handcrafted for modern spaces. Customizable finishes, energy-efficient LED, and timeless design make it perfect for dining areas, kitchens, and workspaces. Made in the USA.	c-stu-dcm, c-stu-scm, linear suora, suora linear,
65938	LED wall sconce, wooden sconce, adjustable wall light, modern wall lighting, handcrafted lighting, dimmable sconce, Suora sconce, American-made lighting, hallway lighting, entryway sconce	Discover the Suora LED Linear Wooden Adjustable Sconce, a sleek and versatile wall light that blends handcrafted wood with modern design. Features adjustable, dimmable LED lighting, customizable finishes, and American-made quality—perfect for hallways, en	W-LIN, linear adjustable, suora sconce,