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, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (12, 11, 15, 280) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 4 Using index condition

Result

product_id meta_keywords meta_description search_words promo_text unit_name
11 <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
12 <p>Introducing the all-new 100g Pants - the ultimate combination of comfort and style! </p> <p>With our HTML tags, we can give you a sneak peek into the amazing features of these pants:</p> <p><strong>Lightweight:</strong> These pants weigh only 100 grams, making them incredibly lightweight and perfect for any season. Whether you're lounging at home or going for a run, these pants will never weigh you down.</p> <p><em>Flexible:</em> The stretchy fabric of our 100g Pants allows for maximum flexibility and freedom of movement. Say goodbye to restrictive clothing and hello to unrestricted comfort.</p> <p><u>Durable:</u> Made with high-quality materials, these pants are built to last. No matter how many times you wear them, they will maintain their shape and color, ensuring long-lasting satisfaction.</p> <p><code>Stylish:</code> Who says comfort can't be stylish? Our 100g Pants come in various trendy colors and designs, so you can look effortlessly fashionable wherever you go.</p> <p><a href="https://www.example.com">Shop now</a> and experience the unmatched comfort and style of our 100g Pants. Don't miss out on this incredible opportunity to upgrade your wardrobe!</p>
15 <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
280