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 (65416, 65564, 65584) 
  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 (65416,65564,65584) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
65416		The Ellington’s modern, minimalist look brings style and plenty of light to homes and businesses. Customizable with various finish colors and cord styles!	BLE-C-EGT, Ellington Pendant Light, Ellington Pendant Light, Ellington Pendant Lighting, Ellington Pendant Lights, Ellington Ceiling Pendant Light, Ellington Ceiling Pendant, Ellington Ceiling Pendants, Ellington Ceiling Light, Ellington Ceiling lights, Ellington ceiling lighting, Ellington pendant, Ellington Pendants, Ellington, Ellington Light, Ellington Lights, Ellington Lighting, 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, ellingtons
65564		The Ellington’s modern, minimalist look brings style and plenty of light to homes and businesses. Customizable with various finish colors!	BLE-F-EGT, Ellington Flush Mount Light, Ellington Flush Mount, Ellington Pendant Lighting, Ellington Pendant Lights, Ellington Ceiling Flush Light, Ellington Ceiling Pendant, Ellington Ceiling Pendants, Ellington Ceiling Light, Ellington Ceiling lights, Ellington ceiling lighting, Ellington pendant, Ellington Pendants, Ellington, Ellington Light, Ellington Lights, Ellington Flush, Ellington Lighting, flush mount, flush, modern flush mount, modern light, simple light, minimal light, surface mount fixture, surface mounted, surface mount, ceiling mount, surface fixture, surface light, ceiling mounted, ellingtons
65584	contemporary lighting, contemporary lights, modern lighting, modern lights, disk lighting, disk lights, american made lighting, american made lights	Oversized pendant lighting with a creative modern style! Create a custom look and give your space a brand new focal point!	BLE-C-EGT30, EGT30, BLE-C-EGT, Ellington Pendant Light, Ellington Pendant Light, Ellington Pendant Lighting, Ellington Pendant Lights, Ellington Ceiling Pendant Light, Ellington Ceiling Pendant, Ellington Ceiling Pendants, Ellington Ceiling Light, Ellington Ceiling lights, Ellington ceiling lighting, Ellington pendant, Ellington Pendants, Ellington, Ellington Light, Ellington Lights, Ellington Lighting, 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, Ellington, Oversized Ellington, Over Sized Ellington, 30 inch ellington, 30-inch ellington, 30 ellington, ellington 30, thirty inch ellington, 30” Ellington, Ellington 30”, 30 inch shade ellington, 30-inch shade ellington, 30” shade Ellington, Large Ellington, Oversized Ellington Pendant, Oversized Ellington Pendants, Over Sized Ellington Pendant, Over Sized Ellington Pendants, 30” Ellington Pendant, 30” Ellington Pendants, 30 Ellington Pendant, 30 Ellington Pendants, Thirty Inch Ellington Pendant, Thirty Inch Ellington Pendants, ellingtons