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 (62252, 62260, 62258, 29992) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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 (62252,62260,62258,29992) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
29992	Lighting protector, wire guard for warehouse lights, round wire guard accessory, light diffuser cage, light shade diffuser, glare reducer cage, exterior light glare reducer	This wire cage comes in 8 through 20 inch sizes for your interior and exterior RLM lighting. Use this light accessory as a glare diffuser, or decorative accent!	Barn Light - Wire Guards 8" to 27", wire guard, bulb protector, wire cage, wire cages, metal decorative bulb shield, metal bulb shield, decorative shield, protective metal shield, protective shield, bulb guard, bulb shield, metal bulb guard, cage, wire, wire guard, wire guards, cage for light bulbs,
62252	replacement glass, jelly jar replacement, vapor proof light parts, clear glass jelly jar	Replace your broken vapor proof glass jar with our replacement jelly jar in clear glass. Receive free shipping with your replacement glass jar.	replacement glass, light parts, jelly jar, individual jelly jar, replacement jelly jar, replacement jar, vapor jar replacement, individual vapor jar, Clear Jelly Jar Glass, BLE-CGG-GLASS-CLR, clear glass replacement, replacement clear jelly jar
62258	Ideal for vapor proof fixtures, industrial guard lights and refrigerator lights, this replacement lamp guard has an extra thick frame. Free Shipping on light parts.	Ideal for vapor proof fixtures, industrial guard lights and refrigerator lights, this replacement lamp guard has an extra thick frame. Free Shipping on light parts.	BLE-TGG, industrial cast guard parts, vapor proof cast guard, vapor proof guard replacement, replacement lamp guard, Heavy Duty Cast Guard, light parts, cast guard, replacement cast guard, replacement heavy duty cast guard, cast hard,
62260	vapor proof guard parts, die cast vapor proof guard, light bulb cast guard, vapor tight cast guard	This replacement die cast guard fits standard vapor proof and threaded fixtures and comes with a custom finish. Free Shipping with replacement light parts.	BLE-CGG, Standard Cast Guard, Industrial Light Parts, light parts, cast guard, cast guard replacement, guard replacement, lighting accessories, vapor proof guard, standard vapor proof, cast hard,